1345 Courses delivered Online

This one-day workshop is ideal for those looking to work with existing databases as well as creating a new Access database. You will learn effective ways to enter and extract data and convert data into a well-presented format for reports. This course will help participants: Plan and create a database Sort and filter records Use field data types Work with tables Create and manage a query Create and work with forms, and use the form wizard View, create and print reports 1 Access introduced Planning a database Creating a blank database Opening an existing database Security warnings The navigation pane Previewing database components Closing an Access database 2 Tables introduced Viewing and navigating table data Navigating using keyboard shortcuts Editing table data Adding records to tables Selecting and deleting records Finding and replacing data Filtering tables Summing table data 3 Queries introduced Opening a query in datasheet view Opening a query in design view Adding fields to a query Sorting query results Modifying datasheet view Saving and closing queries 4 Forms introduced Working with form data Sorting records Filtering records Working in design and layout views Changing object attributes 5 Reports introduced Opening and viewing reports Viewing a report in design view Previewing and printing report data Creating reports with auto report Creating reports with the report wizard Changing field attributes 6 Creating a new database Creating database tables Creating table fields Selecting field data types 7 Table relationships Introducing relationships Establishing table relationships The one-to-many relationship type Establishing referential integrity 8 Creating queries Streamline query criteria using wildcards Creating summary queries Creating queries based on criteria Running date queries Formatting field properties Building queries from multiple tables Summing in queries 9 Creating forms Creating a new form Inserting form fields Working with the property sheet The command button wizard The command button wizard Programming without typing Creating forms with embedded sub forms Creating forms with the sub form wizard Creating forms with the form wizard 10 Creating reports What are report bands? Managing report controls Basing reports on multiple tables Basing reports on queries Sorting and grouping records

🚀 Unlock the Power of Microsoft Excel with Our Excel VBA Programming Training Course! 📊 Are you ready to take your Excel skills to the next level? Dive deep into the world of Excel VBA programming and unleash the full potential of this powerful tool! Our comprehensive online course, 'Microsoft Excel VBA Programming Training,' is designed to equip you with the expertise needed to automate tasks, streamline processes, and boost productivity within Excel. Here's what you'll learn in this dynamic course: 📌 Section 1: Introduction Get acquainted with the fundamentals of Excel VBA programming. Understand its significance and explore the vast possibilities it offers to transform your Excel experience. 📌 Section 2: Macros Master the art of creating and executing macros to automate repetitive tasks and significantly reduce manual work. Learn to streamline your workflow like a pro! 📌 Section 3: VBA Editor Navigate the VBA Editor seamlessly. Gain proficiency in using this interface to write, edit, and debug your VBA code effectively. 📌 Section 4: Variables and Procedures Understand the concept of variables and procedures in VBA. Learn how to declare, assign, and utilize them efficiently to optimize your coding process. 📌 Section 5: Loops and IF Statements Discover the power of loops and conditional IF statements. Harness these constructs to create dynamic and responsive Excel applications. 📌 Section 6: Error Handling Learn robust error-handling techniques to troubleshoot issues and create resilient VBA programs. 📌 Section 7: User Defined Functions Unlock the potential of creating custom functions tailored to your specific needs, enhancing Excel's capabilities beyond its default functions. 📌 Section 8: Assignments Apply your newfound knowledge through hands-on assignments and practical exercises to reinforce your skills. 📌 Section 9: Creating Forms Explore the creation of user-friendly forms and interfaces within Excel, making interactions more intuitive and efficient. Whether you're a beginner or have some experience in Excel, this course is tailored to suit your learning needs. With comprehensive modules, real-world examples, and expert guidance, you'll gain the confidence to create powerful VBA scripts and automate Excel operations like never before! Join us today and embark on a transformative journey in mastering Microsoft Excel VBA programming. Elevate your Excel skills and become a proficient VBA programmer! Enroll now and excel in Excel VBA programming! 💡📈✨ Course Curriculum Section 1 - Introduction What is VBA 00:00 Object Orientated Programming 00:00 Section 2 - Macros Macros Initial Setup 00:00 Recording a Macro 00:00 Saving a Macro 00:00 Section 3 - VBA Editor Launching VBA 00:00 VB Editor 00:00 Custom Menu 00:00 Naming Projects 00:00 Modules 00:00 Code Window 00:00 Comments 00:00 Section 4 - Variables and Procedures Introduction 00:00 Vraibales 00:00 Variable Exercise 00:00 What are Procedures 00:00 What are Procedures - Part Two 00:00 What are Procedures - Part Three 00:00 Message Boxes 00:00 Input Box 00:00 Input Box - Part Two 00:00 Basic Navigation 00:00 Sheets 00:00 Draft LessonCell Navigation 00:00 Advanced Sheets 00:00 Offset 00:00 Section 5 - Loops and IF Statements Introduction 00:00 Operators 00:00 Using Variables 00:00 What is Automation 00:00 For Loop 00:00 Do Loops 00:00 IF Statements 00:00 IF Statements - Part Two 00:00 Select Case 00:00 Section 6 - Error Handling Debugging 00:00 Section 7 - User Defined Functions UDFs 00:00 Section 8 - Assignments Introduction 00:00 Exercise 1 - Record a Macro 00:00 Exercise 2 - Duplicating Data 00:00 Exercise 3 - Generate a Report 00:00 Generate a Report - Part Two 00:00 Exercise 4 - Inner and Outer Loops 00:00 Inner and Outer Loops - Part Two 00:00 Inner and Outer Loops - Part Three 00:00 Inner and Outer Loops - Part Four 00:00 Inner and Outer Loops - Part Five 00:00 Section 9 - Creating Forms Form Controls 00:00 Building the Form 00:00 Initialize the Form 00:00 Command Buttons 00:00 Command Buttons - Part Two 00:00

Duration 1 Days 6 CPD hours This course is intended for This course is intended for students who have a foundational working knowledge of PowerPoint, who wish to take advantage of the application's higher-level usability, security, collaboration, and distribution functionality. Overview In this course, you will use the advanced tools and features in PowerPoint to create and deliver engaging presentations.You will: Customize design templates. Add tables. Add charts. Work with media. Build advanced transitions and animations. Collaborate on a presentation. Customize the delivery of a presentation. Modify presentation navigation. Secure and distribute a presentation. Meetings, instruction, training, pitches; these are all a part of our daily lives. We are often called upon to deliver presentations with little notice, at multiple venues, and with varying requirements. And, some of these presentations include sensitive information that needs to be guarded. Given all the variables, it may seem an overwhelming task to deliver your content, on time, to all audiences, and to only those who need to see it. Oh, and by the way, you need to make it interesting, informative, and memorable. So, how do you do it? Without the help of a robust set of tools, it would be nearly impossible. But Microsoft© PowerPoint© provides you with a variety of such tools that can help you deliver content in nearly any situation, while saving time and effort. By taking advantage of these tools, you will be creating presentations that not only stand out from the crowd, but also don't consume all of your available time. Note: Most Office users perform the majority of their daily tasks using the desktop version of the Office software, so that is the focus of this training. The course material will also enable you to access and effectively utilize many web-based resources provided with your Microsoft 365? subscription. Helpful notes throughout the material alert you to cases where the online version of the application may function differently from the primary, desktop version. This course may be a useful component in your preparation for the PowerPoint Associate (Microsoft 365 Apps and Office 2019): Exam MO-300 certification exam. Lesson 1: Customizing Design Templates Topic A: Modify Slide Masters and Slide Layouts Topic B: Modify the Notes Master and the Handout Master Topic C: Add Headers and Footers Lesson 2: Adding Tables Topic A: Create a Table Topic B: Format a Table Topic C: Insert a Table from Other Office Applications Lesson 3: Adding Charts Topic A: Create a Chart Topic B: Format a Chart Topic C: Insert a Chart from Microsoft Excel Lesson 4: Working with Media Topic A: Add Audio to a Presentation Topic B: Add Video to a Presentation Topic C: Add a Screen Recording Lesson 5: Building Advanced Transitions and Animations Topic A: Use the Morph Transition Topic B: Customize Animations Lesson 6: Collaborating on a Presentation Topic A: Review a Presentation Topic B: Co-author a Presentation Lesson 7: Customizing Presentation Delivery Topic A: Enhance a Live Presentation Topic B: Record a Presentation Topic C: Set Up a Slide Show Lesson 8: Modifying Presentation Navigation Topic A: Divide a Presentation into Sections Topic B: Add Links Topic C: Create a Custom Slide Show Lesson 9: Securing and Distributing a Presentation Topic A: Secure a Presentation Topic B: Create a Video or a CD

Have you ever wondered how businesses transform raw data into actionable insights or how financial analysts accurately pinpoint market trends? Microsoft Excel stands tall as the fulcrum that balances numerous sectors of the business world. This 8-course Microsoft Excel Mastery: AutoCAD, SQL, Data Analysis, Financial Modelling & Marketing bundle dives deep into the myriad applications of Microsoft Excel, from interfacing with AutoCAD to crafting marketing strategies and comprehensive financial models. In an era defined by data-driven decisions, this 8-course Microsoft Excel Mastery: AutoCAD, SQL, Data Analysis, Financial Modelling & Marketing bundle is tailored to equip learners with the multifaceted applications of Microsoft Excel. Ranging from foundational Excel operations to advanced integrations with tools like AutoCAD and MySQL, the course bundle aims to foster expertise in data management, analysis, and visualisation. Whether you're venturing into financial modelling, HR analytics, or design integration, this bundle serves as a comprehensive guide to mastering Excel in diverse professional realms, ensuring you are well-prepared to leverage its capabilities in the modern workplace. Ready to excel in your career? Embrace the transformative power of data and design by mastering Microsoft Excel with our comprehensive course bundle. Dive in now and shape your future with unparalleled proficiency! The Eight CPD Accredited courses that the bundle includes are: Course 1: Microsoft Excel Course for Everyone - Complete Excel Course Course 2: Excel VBA/Macros Foundations Course 3: Dynamic Excel Gantt Chart and Timelines Course 4: Hands on Programming on AutoCAD to Excel Using VB.NET Course 5: Learn MySQL from Scratch for Data Science and Analytics Course 6: Data Analytics Course 7: Build HR Dashboard using Excel Course 8: Financial Modelling Using Excel Learning Outcomes: Gain comprehensive knowledge and understanding of Microsoft Excel and its vast capabilities. Understand the seamless integration between Excel and tools like AutoCAD and MySQL. Develop proficiency in creating intricate financial models and marketing strategies. Acquire skills to analyse data, forecast trends, and build informative dashboards. Learn the principles of personal finance management using Excel. Master the art of crafting Gantt charts and timelines for effective project management. Microsoft Excel Course for Everyone - Complete Excel Course: Acquaint yourself with the foundational and advanced facets of Microsoft Excel, fostering data management expertise. Excel VBA/Macros Foundations: Dive into the transformative world of VBA, unlocking Excel's programming potentials. Dynamic Excel Gantt Chart and Timelines: Grasp the essentials of project management by designing insightful Gantt charts and timelines in Excel. Hands on Programming on AutoCAD to Excel Using VB.NET: Bridge the realms of design and data by merging AutoCAD functionalities with Microsoft Excel's prowess. Learn MySQL from Scratch for Data Science and Analytics: Understand the confluence of Excel and MySQL, anchoring data science and analytics. Data Analytics: Master the techniques of transforming raw numbers into actionable insights using Microsoft Excel. Build HR Dashboard using Excel: Curate informative HR dashboards, offering a snapshot of organisational metrics, all within Excel. Financial Modelling Using Excel: Unravel the intricacies of financial markets, crafting accurate models in Microsoft Excel. CPD 90 CPD hours / points Accredited by CPD Quality Standards Who is this course for? Individuals keen on enhancing their Microsoft Excel skills for professional or personal reasons. Marketing professionals aiming to refine their strategic planning with Excel. Financial analysts and enthusiasts looking to build and understand models in Excel. Data scientists and analysts desire to integrate Excel with tools like MySQL. Design engineers and architects keen on integrating AutoCAD designs with Excel data. Career path Data Analyst Financial Modeller Marketing Strategist HR Dashboard Specialist Database Administrator (with Excel integration knowledge) Project Manager (familiar with Gantt and timelines in Excel) Design Engineer using Excel with AutoCAD Certificates CPD Certificate Of Completion Digital certificate - Included 8 Digital Certificates Are Included With This Bundle CPD Quality Standard Hardcopy Certificate (FREE UK Delivery) Hard copy certificate - £9.99 Hardcopy Transcript: £9.99

Overview This comprehensive course on AutoCAD VBA Programming - Beginner course will deepen your understanding on this topic. After successful completion of this course you can acquire the required skills in this sector. This AutoCAD VBA Programming - Beginner course comes with accredited certification which will enhance your CV and make you worthy in the job market. So enrol in this course today to fast track your career ladder. How will I get my certificate? You may have to take a quiz or a written test online during or after the course. After successfully completing the course, you will be eligible for the certificate. Who is this course for? There is no experience or previous qualifications required for enrolment on this AutoCAD VBA Programming - Beginner course. It is available to all students, of all academic backgrounds. Requirements Our AutoCAD VBA Programming - Beginner course is fully compatible with PC's, Mac's, Laptop, Tablet and Smartphone devices. This course has been designed to be fully compatible on tablets and smartphones so you can access your course on wifi, 3G or 4G. There is no time limit for completing this course, it can be studied in your own time at your own pace. Career path Having these various qualifications will increase the value in your CV and open you up to multiple sectors such as Business & Management, Admin, Accountancy & Finance, Secretarial & PA, Teaching & Mentoring etc. Course Curriculum 11 sections • 42 lectures • 03:37:00 total length •Module 01: Introduction: 00:04:00 •Module 02: Course Content Identified: 00:06:00 •Module 01: Setting-up the Environment (Installing VBA IDE): 00:01:00 •Module 02: Downloading and Installing AutoCAD VBA IDE: 00:04:00 •Module 03: Identify and Understand VBA IDE Components (Toolbars and Windows): 00:03:00 •Module 04: VBA IDE Walkthrough: 00:14:00 •Module 01: Examining AutoCAD VBA Object Model Structure: 00:07:00 •Module 02: Examining AutoCAD Object Model Structure Part 2: 00:06:00 •Module 01: Working on Variables: 00:01:00 •Module 02: Using Variables in the Program: 00:14:00 •Module 01: User Forms and Controls Topic Breakdown: 00:02:00 •Module 02: Using Label, Textbox and Command Button Controls: 00:10:00 •Module 03: Using ListBox Control: 00:06:00 •Module 04: Using ComboBox Control: 00:09:00 •Module 05: Using CheckBox Control: 00:08:00 •Module 06: Using OptionButton Control: 00:03:00 •Module 07: Using MultiPage Control: 00:10:00 •Module 08: Using MultiPage Control Continued: 00:14:00 •Module 09: Using Frame Control: 00:03:00 •Module 01: Conditions and Decisions Course Outline: 00:01:00 •Module 02: IF-THEN-ELSE Condition: 00:02:00 •Module 03: IF-THEN-ELSEIF Condition: 00:04:00 •Module 04: Conditional Operators in VBA: 00:04:00 •Module 05: Logical Operators in VBA: 00:07:00 •Module 06: SELECT CASE Statement in VBA: 00:05:00 •Module 01: Looping and Iterations Overview: 00:02:00 •Module 02: Using DO-WHILE Loop in VBA: 00:04:00 •Module 03: Using DO-UNTIL Loop in VBA: 00:02:00 •Module 04: Using FORNEXT Loop in VBA: 00:02:00 •Module 05: Using FOREACHNEXT Loop in VBA: 00:03:00 •Module 01: Drawing Objects Overview: 00:01:00 •Module 02: Draw a Line Object using Utility Function: 00:03:00 •Module 03: Draw a Line Object using Points from User's Input: 00:07:00 •Module 04: Draw a Circle Object Using Utility Functions: 00:03:00 •Module 05: Draw a Text Object using Utility Functions: 00:05:00 •Module 06: Draw a LWPolyline and Polyline Objects: 00:06:00 •Module 01: Code Debugging Overview: 00:01:00 •Module 02: Code Debugging in VBA Demo: 00:12:00 •Module 03: Code Debugging in VBA Demo Continued: 00:02:00 •Module 01: Error Handling Course Outline: 00:02:00 •Module 02: Error Handling in VBA Demo: 00:13:00 •Module 01: Conclusion and Thank you!: 00:01:00

Most people only use a fraction of Excel's capabilities. This workshop shows what you've been missing! This course will help participants: Nest formulas Get the most from pivot tables Use conditional formatting Write array formulas Explore the lookup functions Calculate by criteria Use 'goal seek' and 'scenario manager' for what-if analysis Record macros 1 Nesting formulas Principles of nesting formulas together Using IF with AND or OR to answer questions Nesting an AND function in an IF Nesting an OR function in an IF 2 Advanced pivot table reports Grouping dates, numerical and text items Running percentage analyse Running analyses to compare data Inserting Field calculations Finishing off with a user-friendly dashboard 3 Advanced conditional formatting Colour table rows based on criteria in it Applying colour to approaching dates Exploring the different rule types 4 Lookup functions Going beyond the VLOOKUP function Lookups that retrieve data from left or right The versatile INDEX and MATCH functions Retrieving data from columns with duplicates 5 Calculate by criteria Using SUMIFS to sum by criteria Finding an average by criteria with AVERAGEIFS Use SUMPRODUCT to multiply then add different values 6 What-if analysis Use Goal Seek to meet targets Forecast reports with the Scenario Manager 7 Recording Macros Macro security Understanding a Relative References macro Recording, running and editing macros Saving files as Macro Enabled Workbooks Introduction to VBA code Making macros available across workbooks Add a macro button to the Quick Access toolbar

This one-day workshop is designed to give you an awareness of the fundamentals of Microsoft Excel and, in particular, to give you the confidence needed to efficiently create, edit and manage spreadsheets. This course will help participants: Create tables Use functions Manage rows and columns Write formulas Manage sheets Use content formats Handle larger tables Create reports and charts 1 Creating a table Creating an Excel table from scratch Wrapping text in cells Speeding up data entry using AutoFill Sorting columns 2 Inserting function Inserting function calculators Using AutoSum to sum numbers Statistical calculations AVERAGE, MAX and MIN 3 Table rows and columns Inserting and deleting rows and columns Adjusting multiple column widths and row heights Hiding and unhiding rows and columns 4 Formula writing The basics of formula writing Understanding mathematical symbols Using multiple mathematical symbols in a formula When to use brackets Troubleshooting calculation errors 5 Managing sheets Inserting, renaming, moving and deleting sheets Copying a worksheet to another file Copying a table to another sheet 6 Managing content formats Applying data formats Managing number formats Controlling formats with the Format Painter 7 Managing larger tables Applying freeze panes to lock tables when scrolling Sorting on multiple columns Using filters to extract table information 8 Creating and modifying charts Creating a pie chart Creating a column chart Inserting chart titles and data labels Controlling chart formatting Changing chart types 9 Printing Previewing and printing tables and charts Modifying page orientation Adjusting print margins Printing a selection 10 Calculating with absolute reference The difference between a relative and absolute formula Changing a relative formula to an absolute Using $ signs to lock cells when copying formulas 11 Pivot tables Create a pivot table report Insert a pivot chart into a report

This one-day workshop is designed to enhance your PowerPoint skills to achieve dynamic presentations that work with you, making it easier to deliver a polished, professional presentation. You will learn advanced PowerPoint skills that will save you time and elevate your presentations. This course will help participants: Create custom shows to personalise presentations for individual clients Make the Slide Master work collectively with slide layouts and themes Seamlessly interact with external content using links Work with advanced animations and transitions, and video/audio tools 1 Themes and Masters Add a Design theme to a presentation Make changes to the Slide Master Delete layouts from the slide master Saving a slide master with themes as a template 2 Advanced graphics and diagrams Drawing, duplicating and resizing shapes Grouping, aligning and stacking shapes and graphics Using SmartArt for diagrams and organisation charts 3 Graphs and charts Inserting and formatting a chart Linking an Excel chart to a slide Linking Excel tables to a slide Animating charts 4 Video, Custom animation and Hyperlinks Adding and editing video Animating pictures and drawings Hyperlink to another Slide or Website Compressing and optimising media 5 Presenting Reuse slides Hide slides Rehearsing timings Enabling a presentation to run continuously

This one-day workshop focuses on building a professional presentation from scratch, giving you essential hints and tips on how to utilise the key features of PowerPoint, including speaker notes, inserting charts, diagrams and pictures, and utilising slide transitions and animation. You will also learn about PowerPoint templates and themes to ensure your presentations have the best impact. This course will help participants: Using Slide Master Create a presentation using a template Insert slides and change the layout Manage slides and control formats Enhance slides using animation, pictures, charts and graphics Work with tables, rows, cells and columns Create and control paragraph lists Insert titles and labels Effectively use slide show controls and presenter view Print slides, handouts and notes 1 Introduction to PowerPoint Navigating the features Creating a simple presentation Inserting new slides and changing layouts Creating speaker notes 2 Using Layouts in Slide Master Editing templates in slide master Adding a design theme Adding transitions, pictures and logos Using Slide Show View 3 Drawing shapes and SmartArt Using Drawing Tool Formats Creating shapes Aligning shapes and stacking order Creating a cycle graphic Creating an organisation chart 4 Animation Visually enhancing slides with animation Using text and object animation Adding animation to lists Making animation work for you 5 Presenting Confidently running a presentation Using presenter view Using the slide show controls

Duration 0.5 Days 3 CPD hours This course is intended for This course is intended for people who have made the transition to remote working and now wish to fully leverage Microsoft Teams for their day to day business needs. Done in a show and Tell style, this course is designed to give business users a thorough understanding of how to use Teams features from an organizational perspective. Features such as: how to manage communications, file sharing for collaboration, calendar events, conference calling, search functions and other daily tasks. Prerequisites: To ensure your success in this course, you should have end-user skills with any current version of Windows, including being able to open and close applications, navigate basic file structures, and manage files and folders. Overview Overview of Teams Permissions, Access & Restrictions Team Management (Power Users) Team Management (End Users) Communication and Collaboration Searching and Activity Sharing Files Customizing your settings Meetings and Calls Done in a show and Tell style, this course is designed to give business users a thorough understanding of how to use Teams features from an organizational perspective. Overview What is Microsoft Teams? How to Access Microsoft Teams Etiquette for using teams Integration and Storage Capabilities Interface Permissions, Access & Restrictions Owner, Member & Guest Team restrictions Channel restrictions Call Restrictions Team Management (Power Users) Create a Team Access administrator settings Add/delete members to a Team Add/delete a guest user Create and manage Channels Create and manage Private channels Customize Channel tabs Creating Tags Team Management (End Users) Getting your Channel email address Integration with Outlook Leave a Team or Channel Communication and Collaboration Team Conversations Using the New Conversation panel Replying to a conversation Using the interactive options Deleting and editing a conversation Turn off notifications for a conversation Using Mentions and Tags Saving messages Accessing your saved messages Accessing recent chats Create a new Chat for one-2-one Create a new chat for group chats Read Receipts Pop out Chats Searching and Activity Use the search tool to find Specific messages Files People Accessing your Activity Accessing your Feed Filtering your feed and activity Sharing Files Uploading files Viewing files Attaching files to a conversation Sharing a link to a file Edit and Collaborate on files Create files Open files in Teams Online Desktop SharePoint Add a file to a tab Share file outside your organization Customizing your settings Filter Teams Hide channels Channel notifications Channel analytics Changing your Status Setting your status message Controlling the general user settings Controlling your privacy settings Controlling your personal notification settings Controlling your device settings (headphones and microphone) Controlling your call settings Setting your Voicemail message Controlling your app permissions Meetings and Calls Accessing your calendar Calendar views Create a Teams meeting Meeting options Meeting requests and RSVP options Join a Teams meeting Copy join information Create a meeting from Outlook Using the Meet Now option Sharing your screen Changing your background image Adding more people to a meeting Meetings menu Download meeting attendees End meetings for everyone (Organizer only) Accessing your Contacts Accessing your Voicemail Accessing your call history Additional course details: Nexus Humans Microsoft Teams for the Remote Business User training program is a workshop that presents an invigorating mix of sessions, lessons, and masterclasses meticulously crafted to propel your learning expedition forward. This immersive bootcamp-style experience boasts interactive lectures, hands-on labs, and collaborative hackathons, all strategically designed to fortify fundamental concepts. Guided by seasoned coaches, each session offers priceless insights and practical skills crucial for honing your expertise. Whether you're stepping into the realm of professional skills or a seasoned professional, this comprehensive course ensures you're equipped with the knowledge and prowess necessary for success. While we feel this is the best course for the Microsoft Teams for the Remote Business User course and one of our Top 10 we encourage you to read the course outline to make sure it is the right content for you. Additionally, private sessions, closed classes or dedicated events are available both live online and at our training centres in Dublin and London, as well as at your offices anywhere in the UK, Ireland or across EMEA.