803 Microsoft Certification courses delivered Online

Overview This comprehensive course on Complete Microsoft Access Course will deepen your understanding on this topic. After successful completion of this course you can acquire the required skills in this sector. This Complete Microsoft Access Course comes with accredited certification from CPD, 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 Complete Microsoft Access Course. It is available to all students, of all academic backgrounds. Requirements Our Complete Microsoft Access Course is fully compatible with PC's, Mac's, Laptop, Tablet and Smartphone devices. This course has been designed to be fully compatible with tablets and smartphones so you can access your course on Wi-Fi, 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 Learning this new skill will help you to advance in your career. It will diversify your job options and help you develop new techniques to keep up with the fast-changing world. This skillset will help you to- Open doors of opportunities Increase your adaptability Keep you relevant Boost confidence And much more! Course Curriculum 3 sections • 58 lectures • 08:04:00 total length •Orientation to Microsoft Access: 00:39:00 •Create a Simple Access Database: 00:10:00 •Get Help and Configure Options in Microsoft Access: 00:06:00 •Modify Table Data: 00:17:00 •Sort and Filter Records: 00:05:00 •Create Basic Queries: 00:15:00 •Sort and Filter Data in a Query: 00:14:00 •Perform Calculations in a Query: 00:08:00 •Create Basic Access Forms: 00:07:00 •Work with Data on Access Forms: 00:23:00 •Create a Report: 00:12:00 •Add Controls to a Report: 00:12:00 •Enhance the Appearance of a Report: 00:05:00 •Prepare a Report for Print: 00:03:00 •Organize Report Information: 00:15:00 •Format Reports: 00:12:00 •Relational Database Design: 00:16:00 •Create a Table: 00:09:00 •Create Table Relationships: 00:09:00 •Create Query Joins: 00:14:00 •Relate Data Within a Table.avi: 00:04:00 •Work with Subdatasheets from: 00:05:00 •Use Field Validation: 00:16:00 •Use Form and Record Validation: 00:14:00 •Create Parameter Queries: 00:12:00 •Summarize Data: 00:06:00 •Create Subqueries: 00:07:00 •Create Action Queries: 00:05:00 •Create Unmatched and Duplicate Queries: 00:06:00 •Data Normalization: 00:10:00 •Create a Junction Table: 00:04:00 •Improve Table Structure: 00:06:00 •Include Control Formatting in a Report: 00:04:00 •Add a Calculated Field to a Report: 00:05:00 •Add a Subreport to an Existing Report: 00:07:00 •Add Controls to Forms: 00:11:00 •Enhance Navigation and Organization of Forms: 00:14:00 •Apply Conditional Formatting: 00:04:00 •Import Data into Access: 00:08:00 •Export Access Data: 00:06:00 •Link Tables to External Data Sources: 00:05:00 •Create a Mail Merge: 00:02:00 •Create a Macro: 00:08:00 •Restrict Records by Using a Condition: 00:04:00 •Validate Data by Using a Macro: 00:05:00 •Automate Data Entry by Using a Macro: 00:04:00 •Manage a Database: 00:08:00 •Determine Object Dependency: 00:04:00 •Manage a Database: 00:07:00 •Determine Object Dependency: 00:04:00 •Document a Database: 00:04:00 •Splitting a Database for Multiple User Access: 00:05:00 •Implement Security: 00:03:00 •Convert an Access Database to an ACCDE File: 00:04:00 •Package a Database with a Digital Signature: 00:01:00 •Create a Database Switchboard: 00:05:00 •Modify a Database Switchboard: 00:02:00 •Set Start up Options: 00:04:00

Overview This comprehensive course on AutoCAD Programming using C# with Windows Forms will deepen your understanding on this topic. After successful completion of this course you can acquire the required skills in this sector. This AutoCAD Programming using C# with Windows Forms 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 Programming using C# with Windows Forms. It is available to all students, of all academic backgrounds. Requirements Our AutoCAD Programming using C# with Windows Forms is fully compatible with PC's, Mac's, Laptop, Tablet and Smartphone devices. This course has been designed to be fully compatible with tablets and smartphones so you can access your course on Wi-Fi, 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 6 sections • 63 lectures • 09:11:00 total length •Introduction: 00:03:00 •Who is this course for?: 00:02:00 •Tools needed in this course: 00:01:00 •What will you learn from this course?: 00:05:00 •Controls Project Demo - Overview: 00:03:00 •Controls Demo Project Requirement - Explained: 00:03:00 •Create the Controls Demo Project: 00:03:00 •Controls Demo Project - Creating the Form (User Interface): 00:15:00 •Develop the Controls Demo Utility Class: 00:10:00 •Using Combobox Control to select an option: 00:13:00 •Using Textbox Control to select an option: 00:09:00 •Using Radiobutton Control to select an option: 00:06:00 •Using Checkbox Control to select an option(s): 00:18:00 •Developing Projects - Overview: 00:03:00 •Project 1: Creating a Rectangle - Project Overview: 00:03:00 •Project 1: Creating the Rectangle Utility Class: 00:17:00 •Project 1: Creating the User Interface: 00:10:00 •Project 1: Coding the User Interface28:50: 00:29:00 •Project 1: Running and Testing the Draw Rectangle Plugin: 00:08:00 •Project 2: Update Objects Layer - Overview: 00:02:00 •Project 2: Create the User Interface of Update Objects Layer Plugin: 00:09:00 •Project 2: Coding the Form Load Event: 00:07:00 •Project 2: Coding the Browse drawing Button: 00:03:00 •Project 2: Coding the Update Button control: 00:07:00 •Project 2: Coding the Update Layer Utility Class: 00:12:00 •Project 2: Running and Testing the Plugin: 00:08:00 •Project 3: Extracting Block Attributes to Files - Overview: 00:03:00 •Project 3: Creating the AutomaticBlockExtractor Project: 00:02:00 •Project 3: Creating the User Interface for the BlockExtractor Project: 00:09:00 •Project 3: Completing User Interface code: 00:22:00 •Project 3: Coding the AutoBlockExtractor Utility Class: 00:24:00 •Project 3: Running and Testing the AutomaticBlockExtractor Plugin in AutoCAD: 00:15:00 •Project 4: Updating MText Textstyle Project - Overview and Walkthrough: 00:05:00 •Project 4: Creating the UpdateTextStyle Utility Class: 00:19:00 •Project 4: Designing the UpdateTextStyle Plugin User Interface: 00:06:00 •Project 4: User Interface Code: 00:16:00 •Project 4: Running and Testing the UpdateTextstyle Plugin: 00:05:00 •Project 5: Converting Drawing to PDF Plugin - Overview: 00:03:00 •Project 5: Creating the PlotDWGtoPDF Project in Visual Studio 2019: 00:04:00 •Project 5: Creating the User Interface for MultiplePlotDWGtoPDF Project: 00:09:00 •Project 5: Coding the User Interface: 00:16:00 •Project 5: Developing the GetPlotSizes Method: 00:10:00 •Project 5: Developing the PlotCurrentLayout Method: 00:27:00 •Project 5: Testing and Running the MultiplePlotDWGtoPDF Project: 00:10:00 •Project 6: Multiple Object Extractor Project - Overview: 00:03:00 •Project 6: Creating the MultiObjectExtractor Project: 00:02:00 •Project 6: Designing the MultiObjectExtractor User Interface: 00:14:00 •Project 6: Coding the FormLoad Event: 00:07:00 •Project 6: Coding the BrowseDwg Button: 00:12:00 •Project 6: Coding the BrowseFile Button: 00:03:00 •Project 6: Coding the ProcessExtract Button: 00:05:00 •Project 6: Creating the Code Validation Methods: 00:10:00 •Project 6: Coding the ProcessDrawing Method: 00:19:00 •Project 6: Coding the ProcessObjectExtraction Method: 00:11:00 •Project 6: Coding the ExtractLine Method: 00:11:00 •Project 6: Coding the ExtractCircle Method: 00:04:00 •Project 6: Coding the ExtractPolyline Method: 00:11:00 •Project 6: Coding the ExtractMText Method: 00:05:00 •Project 6: Coding the ExtractBlock Method: 00:03:00 •Project 6: Coding the ExtractObjects Method: 00:02:00 •Project 6: Running and Testing the MultiObjectExtractor Plugin: 00:14:00 •Conclusion and Thank you: 00:01:00 •Assignment - AutoCAD Programming using C# with Windows Forms: 00:00:00

Overview This Microsoft Excel Course for Everyone - Complete Excel Course is your passport to spreadsheet mastery.Explore Excel in detail and improve your abilities with practical activities that go beyond boring lectures. Take on spreadsheets like an expert, from data entry to difficult formulas and eye-catching graphics. But the magic doesn't end there! After finishing successfully, you'll not only impress with your proficiency with Excel, but you'll also obtain a respected CPD certification to enhance your CV and make a statement in the job market. Consider it your golden ticket to go up in your job!Enrol right away to see how your confidence and chances rise! Don't wait! 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 Microsoft Excel Course for Everyone - Complete Excel Course. It is available to all students, of all academic backgrounds. Requirements Compatible with a wide range of gadgets, including smartphones, tablets, laptops, Macs, and PCs. Particularly designed to be easily accessed with an internet connection on tablets and smartphones. No strict deadlines; learn whenever it's convenient for you. Individuals with basic English proficiency. Career Path After completing this course, it will increase the value of your CV and open you up to multiple sectors, such as : Data Analyst: £25,000 - £50,000 per year Financial Analyst: £30,000 - £60,000 per year Operations Manager: £35,000 - £70,000 per year Accountant: £25,000 - £50,000 per year Business Intelligence Analyst: £35,000 - £65,000 per year These salary ranges can vary based on factors such as experience, location, and the specific industry of the business. Course Curriculum 15 sections • 80 lectures • 06:51:00 total length •Introduction: 00:03:00 •Course Curriculum: 00:04:00 •Getting started on Windows, macOS, Android, and IOS: 00:01:00 •How to ask great questions: 00:02:00 •FAQ's: 00:01:00 •Starting Excel: 00:04:00 •Introduction: 00:02:00 •Worksheet basics: 00:22:00 •Entering values and formulas: 00:12:00 •Data formats: 00:10:00 •Data handling basics - cut copy and paste: 00:07:00 •Save and print in excel: 00:10:00 •Excel Ranges: 00:05:00 •Introduction: 00:01:00 •Basic formula operations: 00:06:00 •Mathematical functions level 1: 00:20:00 •Mathematical functions level 2: 00:12:00 •Text functions level 1: 00:09:00 •Text functions level 2: 00:13:00 •Logical functions: 00:11:00 •Date time functions: 00:06:00 •V Lookup formula: 00:12:00 •HLookup formula: 00:04:00 •HLookup + Match formula: 00:09:00 •Match + Index formula: 00:05:00 •Introduction: 00:02:00 •XLookup: 00:08:00 •Handling #NA and Approximates match in XLookup: 00:11:00 •Wildcard matching in XLookup: 00:06:00 •Introduction: 00:02:00 •Split text into columns: 00:07:00 •Flash Fill: 00:07:00 •Remove Duplicates: 00:08:00 •Data Validation: 00:07:00 •Get- import Data from Text: 00:06:00 •Get - import Data from CSV: 00:03:00 •Introduction: 00:01:00 •Formatting Font: 00:04:00 •Formatting Alignment: 00:06:00 •Formatting Number: 00:05:00 •Formatting Date: 00:03:00 •Formatting tables: 00:05:00 •Introduction: 00:01:00 •Creating Pivot Table: 00:07:00 •Value field settings: 00:04:00 •Number format: 00:02:00 •Pivot Table Design: 00:03:00 •Excel Exercise: 00:01:00 •Solution for Excel Exercise: 00:02:00 •Introduction: 00:01:00 •Excel Charts - Categories: 00:03:00 •Elements of a chart: 00:04:00 •Easy way to create charts: 00:02:00 •Column or Bar charts: 00:04:00 •Formatting charts: 00:04:00 •Line charts: 00:02:00 •Area charts: 00:02:00 •Pie and Doughnut charts: 00:04:00 •Format AreaPlot or XY chart: 00:08:00 •Scatter or bubble charts: 00:02:00 •Introduction: 00:01:00 •Frequency Distribution and Histograms: 00:04:00 •Waterfall charts: 00:02:00 •Hierarchy charts: sunburst and tree map: 00:03:00 •Combination charts: 00:02:00 •Sparklines: 00:05:00 •Pivot charts: 00:02:00 •Maps chart: 00:04:00 •3D Maps chart: 00:03:00 •Introduction: 00:01:00 •Stock charts: 00:02:00 •Radar charts: 00:02:00 •Surface charts: 00:02:00 •Heat maps: 00:04:00 •Named ranges: 00:05:00 •Indirect Name range Function: 00:06:00 •Import Data table from PDF file - Excel 2021: 00:04:00 •Import Data from Website - Excel 2019 above: 00:09:00 •Project: Sales forecast tracker: 00:07:00 •Product Sale Tax invoice: Tax Calculations: 00:05:00

Overview This comprehensive course on MS Access Databases Forms and Reports Level 3 will deepen your understanding on this topic. After successful completion of this course you can acquire the required skills in this sector. This MS Access Databases Forms and Reports Level 3 comes with accredited certification from CPD, 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 MS Access Databases Forms and Reports Level 3. It is available to all students, of all academic backgrounds. Requirements Our MS Access Databases Forms and Reports Level 3 is fully compatible with PC's, Mac's, Laptop, Tablet and Smartphone devices. This course has been designed to be fully compatible with tablets and smartphones so you can access your course on Wi-Fi, 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 Learning this new skill will help you to advance in your career. It will diversify your job options and help you develop new techniques to keep up with the fast-changing world. This skillset will help you to- Open doors of opportunities Increase your adaptability Keep you relevant Boost confidence And much more! Course Curriculum 2 sections • 16 lectures • 02:49:00 total length •Creating a form with Autoform: 00:14:00 •Using the Form Wizard: 00:09:00 •Changing a form with design view: 00:26:00 •Adding form controls: 00:21:00 •Subforms: 00:15:00 •Creating reports with Autoreport: 00:03:00 •Using the Report Wizard to create a report: 00:07:00 •Changing a report in design view: 00:11:00 •Adding calculations: 00:09:00 •Grouping, sorting and adding totals to reports: 00:16:00 •Using the Label Wizard: 00:04:00 •Form and table properties: 00:06:00 •Exporting a report to Excel: 00:03:00 •Using the Switchboard Manager to create a nice menu: 00:17:00 •Finalizing the application: 00:08:00 •Assignment - MS Access Databases Forms and Reports Level 3: 00:00:00

Overview This comprehensive course on MS Access Tables and Queries for Beginner will deepen your understanding on this topic. After successful completion of this course you can acquire the required skills in this sector. This MS Access Tables and Queries for Beginner comes with accredited certification from CPD, 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 MS Access Tables and Queries for Beginner. It is available to all students, of all academic backgrounds. Requirements Our MS Access Tables and Queries for Beginner is fully compatible with PC's, Mac's, Laptop, Tablet and Smartphone devices. This course has been designed to be fully compatible with tablets and smartphones so you can access your course on Wi-Fi, 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 Learning this new skill will help you to advance in your career. It will diversify your job options and help you develop new techniques to keep up with the fast-changing world. This skillset will help you to- Open doors of opportunities Increase your adaptability Keep you relevant Boost confidence And much more! Course Curriculum 2 sections • 20 lectures • 03:32:00 total length •Module 01: Tour of the screen: 00:11:00 •Module 02: Using Design view to create and edit tables: 00:45:00 •Module 03: Using the lookup wizard: 00:09:00 •Module 04: Importing data from Other Data Sources into Access: 00:18:00 •Module 05: Linking Tables from Other Data Sources into Access: 00:10:00 •Module 06: Exporting data from Access to other data types: 00:03:00 •Module 07: Creating and Managing Table Relationships: 00:10:00 •Module 08: Database Tools: 00:05:00 •Module 09: Sort and Filter a Table: 00:06:00 •Module 10: Basic Queries: 00:22:00 •Module 11: Prompting the user for the criteria: 00:05:00 •Module 12: Creating Calculated Fields in a Query: 00:10:00 •Module 13: Creating Totals Queries: 00:08:00 •Module 14: Multiple table Queries: 00:12:00 •Module 15: Viewing the SQL code for an Access Query: 00:06:00 •Module 16: Using the Query Wizards: 00:09:00 •Module 17: Creating Subqueries: 00:03:00 •Module 18: Creating Make Table, Append, Update and Delete Queries: 00:19:00 •Module 19: Displaying a certain number of records: 00:01:00 •Assignment - MS Access Tables and Queries for Beginner: 00:00:00

Overview This comprehensive course on The Complete Microsoft Outlook Masterclass will deepen your understanding on this topic. After successful completion of this course you can acquire the required skills in this sector. This The Complete Microsoft Outlook Masterclass comes with accredited certification from CPD, 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? At the end of the course there will be an online written test, which you can take either during or after the course. After successfully completing the test you will be able to order your certificate, these are included in the price. Who is This course for? There is no experience or previous qualifications required for enrolment on this The Complete Microsoft Outlook Masterclass. It is available to all students, of all academic backgrounds. Requirements Our The Complete Microsoft Outlook Masterclass is fully compatible with PC's, Mac's, Laptop, Tablet and Smartphone devices. This course has been designed to be fully compatible with tablets and smartphones so you can access your course on Wi-Fi, 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 Learning this new skill will help you to advance in your career. It will diversify your job options and help you develop new techniques to keep up with the fast-changing world. This skillset will help you to- Open doors of opportunities Increase your adaptability Keep you relevant Boost confidence And much more!   Course Curriculum 16 sections • 74 lectures • 04:03:00 total length •You Can Master Microsoft Outlook Promo: 00:02:00 •You Can Ask Me Anytime: 00:01:00 •Your Facebook Support Group: 00:01:00 •Quick Win -How To Send an Email in Outlook: 00:01:00 •Quick Win - How To Print an Email in Outlook: 00:01:00 •Another Quick Win - You Can Work Offline with Outlook: 00:01:00 •Outlook Environment: 00:03:00 •Outlook Opening: 00:02:00 •Outlook Interface Options: 00:04:00 •Sending and Receiving Email in Outlook: 00:03:00 •Sending and Receiving Email in Outlook with Attachments: 00:02:00 •Account Settings in Outlook: 00:06:00 •Automatic Replies in Outlook: 00:04:00 •Mail Box Settings in Outlook: 00:02:00 •Rules and Alerts Settings in Outlook: 00:04:00 •Exporting and Importing Rules and Alerts in Outlook: 00:01:00 •Opening Options in File Outlook: 00:04:00 •Quick Win -How to Create Folder in Outlook: 00:01:00 •Quick Win -How to Change Outlook Style: 00:01:00 •Quick Win - How To Use Quick Access Toolbar: 00:01:00 •New Email Options in Outlook: 00:03:00 •Basic Text in New Email: 00:07:00 •Name, Include and Tags in New Email: 00:03:00 •Inserting Table Into New Email: 00:10:00 •Inserting Images Into New Email: 00:10:00 •Inserting Shapes Into New Email: 00:06:00 •Inserting SmartArt Into New Email: 00:04:00 •Inserting New Chart Into New Email: 00:05:00 •Taking Screenshot Into New Email: 00:02:00 •Links, Text and Symbol: 00:03:00 •Themes, Show Fields, Encrypt, Tracking and More Options in New Email: 00:03:00 •Formatting Text in New Emails: 00:03:00 •Reviewing Menu in New Email: 00:03:00 •New Appointment at Home Menu: 00:06:00 •New Meeting at Home Menu: 00:01:00 •New Contact in Home Menu: 00:05:00 •Create New Task: 00:03:00 •Other New Item in Home: 00:02:00 •Email Deletion in Outlook: 00:02:00 •Responding to An Email in Outlook: 00:02:00 •Quick Steps, Tag and Other Functions: 00:03:00 •Complete Guide of Send and Receive: 00:03:00 •Complete Folder Guide: 00:05:00 •View and Help in Outlook: 00:04:00 •Options Intro: 00:03:00 •General Options in Outlook: 00:05:00 •Mail Options in Outlook: 00:06:00 •Calendar Options in Outlook: 00:03:00 •Contact Options in Outlook: 00:01:00 •Task Options in Outlook: 00:01:00 •Search Options in Outlook: 00:02:00 •Language Options in Outlook: 00:02:00 •Ease of Access Options in Outlook: 00:02:00 •Advanced Option in Outlook: 00:04:00 •Ribbon and Quick Access Toolbar Customization: 00:02:00 •Quick Win - Create Unknown Password: 00:01:00 •Security Is Everything: 00:01:00 •Quick Win - Insecurity Is Coming from You and Others: 00:01:00 •Understand Security Type or Category: 00:02:00 •Life Savers - You Should Know These: 00:04:00 •Have Proper Password - Start Securing You Now: 00:03:00 •Don't Use the Same Password Anymore: 00:02:00 •Should You Use Longer Password or Complicated!: 00:03:00 •Last-Pass & Authy Mobile App: 00:02:00 •The Best and Only Solution to Make and Keep Password Un-Crack-Able: 00:08:00 •Last-pass Setup and Configure: 00:10:00 •Last-Pass Options Part 1: 00:03:00 •Last-Pass Options Part 2: 00:04:00 •Last-Pass Option Part 3: 00:04:00 •2FA Makes You Even Stronger in Password: 00:05:00 •Security Is Everything, Keep Secured Your Devices: 00:07:00 •Security on Your Data and Privacy: 00:08:00 •Congratulation: 00:01:00 •Assignment -The Complete Microsoft Outlook Masterclass: 00:00:00

Overview This comprehensive course on Microsoft Excel - 25 Must-Know Formulas and Functions will deepen your understanding on this topic. After successful completion of this course you can acquire the required skills in this sector. This Microsoft Excel - 25 Must-Know Formulas and Functions comes with accredited certification from CPD, 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 Microsoft Excel - 25 Must-Know Formulas and Functions. It is available to all students, of all academic backgrounds. Requirements Our Microsoft Excel - 25 Must-Know Formulas and Functions is fully compatible with PC's, Mac's, Laptop, Tablet and Smartphone devices. This course has been designed to be fully compatible with tablets and smartphones so you can access your course on Wi-Fi, 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 Learning this new skill will help you to advance in your career. It will diversify your job options and help you develop new techniques to keep up with the fast-changing world. This skillset will help you to- Open doors of opportunities Increase your adaptability Keep you relevant Boost confidence And much more! Course Curriculum 2 sections • 2 lectures • 01:12:00 total length •Must-Know Formulas and Functions: 01:12:00 •Resource - Microsoft Excel - 25 Must-Know Formulas and Functions: 00:00:00

Overview This comprehensive course on Microsoft Excel: Master Power Query in 120 Minutes! will deepen your understanding on this topic. After successful completion of this course you can acquire the required skills in this sector. This Microsoft Excel: Master Power Query in 120 Minutes! 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 Microsoft Excel: Master Power Query in 120 Minutes!. It is available to all students, of all academic backgrounds. Requirements Our Microsoft Excel: Master Power Query in 120 Minutes! 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 1 sections • 25 lectures • 02:25:00 total length •Power Query Intro and Excel version: 00:03:00 •Excel Power Query - Introduction: 00:03:00 •Excel Power Query - Query Editor Ribbon: 00:09:00 •Transform Data - Trim in Excel Power Query: 00:05:00 •Transform Data - Format Dates and Values in Excel Power Query: 00:02:00 •Transform Data - Parsing URLs in Excel Power Query: 00:05:00 •Transform Data - Split Text Fields in Excel Power Query: 00:10:00 •Transform Data - Group By in Excel Power Query: 00:03:00 •Transform Data - Unpivoting Columns in Excel Power Query: 00:05:00 •Transform Data - Pivoting Columns in Excel Power Query: 00:02:00 •Transform Data - Split Columns into Other Columns in Excel Power Query: 00:04:00 •Transform Data - Filtering Rows in Excel Power Query: 00:05:00 •Transform Data - Sorting Columns in Excel Power Query: 00:02:00 •Transform Data - Transform and Add Columns in Excel Power Query: 00:07:00 •From Folder - Import From Folder in Excel Power Query: 00:07:00 •From Folder - Doing Auto Cleanup in Excel Power Query: 00:13:00 •From Folder - Extract Data from Forms in Excel Power Query: 00:13:00 •From Workbook - Extract Multiple Criteria in Excel Power Query: 00:05:00 •From Workbook - Extract Multiple Worksheets in Excel Power Query: 00:04:00 •Joins - Intro to Joins: 00:04:00 •Joins - Merging: 00:08:00 •Joins - Full Outer Join: 00:06:00 •Joins - Right Anti Join: 00:09:00 •Power Query - Convert Reports into Pivot Tables: 00:05:00 •Modulo: 00:06:00

Overview This comprehensive course on Master Microsoft Power BI in 90 Minutes! will deepen your understanding on this topic. After successful completion of this course you can acquire the required skills in this sector. This Master Microsoft Power BI in 90 Minutes! comes with accredited certification from CPD, 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 Master Microsoft Power BI in 90 Minutes!. It is available to all students, of all academic backgrounds. Requirements Our Master Microsoft Power BI in 90 Minutes! is fully compatible with PC's, Mac's, Laptop, Tablet and Smartphone devices. This course has been designed to be fully compatible with tablets and smartphones so you can access your course on Wi-Fi, 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 Learning this new skill will help you to advance in your career. It will diversify your job options and help you develop new techniques to keep up with the fast-changing world. This skillset will help you to- Open doors of opportunities Increase your adaptability Keep you relevant Boost confidence And much more! Course Curriculum 5 sections • 25 lectures • 01:35:00 total length •Overview of Power BI Course: 00:02:00 •Power BI Intro: 00:03:00 •Power BI High Level Flow: 00:02:00 •Install and Sign Up: 00:03:00 •Power Query Intro: 00:05:00 •Power Pivot Intro: 00:01:00 •Power View Intro: 00:02:00 •Big Picture: 00:02:00 •Get Data: 00:07:00 •How to Get More Data: 00:01:00 •Modelling Data: 00:03:00 •Adding Relationships Manually: 00:02:00 •Visualization: 00:05:00 •Visualization Customization: 00:01:00 •More Visualizations: 00:02:00 •Visualization Format and Analytics: 00:03:00 •Ask a Question: 00:02:00 •Real World Example: 00:06:00 •Get Data: 00:13:00 •Modelling Data: 00:05:00 •Visualization with multiple charts: 00:11:00 •Publishing: 00:05:00 •Power BI Website: 00:08:00 •FINAL: 00:01:00 •Resources - Master Microsoft Power BI in 90 Minutes!: 00:00:00

Overview This comprehensive course on Excel Must know Formulas and Functions will deepen your understanding on this topic. After successful completion of this course you can acquire the required skills in this sector. This Excel Must know Formulas and Functions comes with accredited certification from CPD, 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 Excel Must know Formulas and Functions. It is available to all students, of all academic backgrounds. Requirements Our Excel Must know Formulas and Functions is fully compatible with PC's, Mac's, Laptop, Tablet and Smartphone devices. This course has been designed to be fully compatible with tablets and smartphones so you can access your course on Wi-Fi, 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 Learning this new skill will help you to advance in your career. It will diversify your job options and help you develop new techniques to keep up with the fast-changing world. This skillset will help you to- Open doors of opportunities Increase your adaptability Keep you relevant Boost confidence And much more! Course Curriculum 2 sections • 13 lectures • 01:53:00 total length •Building basic math formulas: 00:08:00 •Autosum and Relative references: 00:09:00 •Absolute references: 00:06:00 •Named Ranges: 00:06:00 •Linking sheets and workbooks: 00:06:00 •If, And, Or, and the nested If functions: 00:16:00 •Countif, Sumif, Averageif, Sumifs, and Countifs functions: 00:09:00 •Vlookup and Hlookup functions: 00:15:00 •Match and Index functions: 00:07:00 •Date and time formulas and functions: 00:12:00 •Text functions: 00:11:00 •Tracing formulas: 00:08:00 •Assignment - Excel Must know Formulas and Functions: 00:00:00