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
Overview This comprehensive course on Microsoft PowerBI - 25 Must-Know Tips and Tricks will deepen your understanding on this topic. After successful completion of this course you can acquire the required skills in this sector. This Microsoft PowerBI - 25 Must-Know Tips and Tricks 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 PowerBI - 25 Must-Know Tips and Tricks. It is available to all students, of all academic backgrounds. Requirements Our Microsoft PowerBI - 25 Must-Know Tips and Tricks 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:34:00 total length •Must-Know Tips and Tricks of Microsoft PowerBI: 01:34:00 •Resource - Microsoft PowerBI - 25 Must-Know Tips and Tricks: 00:00:00
Overview This comprehensive course on Microsoft Access Tables and Queries will deepen your understanding on this topic. After successful completion of this course you can acquire the required skills in this sector. This Microsoft Access Tables and Queries 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 Access Tables and Queries. It is available to all students, of all academic backgrounds. Requirements Our Microsoft Access Tables and Queries 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 •Tour of the screen: 00:11:00 •Using Design view to create and edit tables: 00:45:00 •Using the lookup wizard: 00:09:00 •Importing data from Other Data Sources into Access: 00:18:00 •Linking Tables from Other data Sources into Access: 00:10:00 •Exporting data from Access to other data types: 00:03:00 •Creating and Managing Table Relationships: 00:10:00 •Database Tools: 00:05:00 •Sort and Filter a Table: 00:06:00 •Basic Queries: 00:22:00 •Prompting the user for the criteria: 00:05:00 •Creating Calculated Fields in a Query: 00:10:00 •Creating Totals Queries: 00:08:00 •Multiple table Queries: 00:12:00 •Viewing the SQL code for an Access Query: 00:06:00 •Using the Query Wizards: 00:09:00 •Creating Subqueries: 00:03:00 •Creating Make Table, Append, Update and Delete Queries: 00:19:00 •Displaying a certain number of records: 00:01:00 •Assignment - Microsoft Access Tables and Queries: 00:00:00