Microsoft Excel is the leading spreadsheet program used on an international scale across many industries and sectors. It is used for powerful data analysis, creating and sharing workbooks, automating reports and everyday administrative tasks. This complete training course covers beginner, intermediate and advanced lessons in Excel 2019, with tips and shortcuts to help you utilise its ley features and functions.
This course is endorsed by ABC Awards – a regulated organisation that ensures professional, reputable certification for further education. Throughout the course, you will develop your proficiency in Excel, covering every aspect of data management from performing basic calculations, to applying conditional formatting, automating tasks and collaborating on workbooks.
On completion, you will have an excellent understanding of how to use Microsoft Excel for managing everyday data management, with the transferable skills to boost your employment prospects.
- Gain a recognised qualification to boost your professional development
- Familiarise with the key features of Microsoft Excel 2019
- Learn how to perform calculations, modify worksheets, manage workbooks and more
- Understand how to analyse data in Excel and apply conditional formatting
- Discover tips, tricks and shortcuts for automating workbook functionality
- Get step-by-step guidance on how to collaborate on workbooks and share them
- Demonstrate an ability to use the lookup function in Microsoft Excel
- Get trained on how to determine potential outcomes using scenarios
Who is This course for?
This Excel training course is for anyone who wishes to familiarise with Microsoft Excel 2019’s key features and functions. It includes beginner and advanced exercises, ideal for learners of all levels. There are no specific entry requirements for this course, which can be studied on a full-time or part-time basis.
- This course is available to all learners, of all academic backgrounds.
- Learners should be aged 16 or over to undertake the qualification.
- Good understanding of English language, numeracy and ICT are required to attend this course.
At the end of this course successful learners will receive a Certificate of Achievement from ABC Awards and Certa Awards and a Learner Unit Summary (which lists the components the learner has completed as part of the course).
The course has been endorsed under the ABC Awards and Certa Awards Quality Licence Scheme. This means that Course Gate has undergone an external quality check to ensure that the organisation and the courses it offers, meet defined quality criteria. The completion of this course alone does not lead to a regulated qualification* but may be used as evidence of knowledge and skills gained. The Learner Unit Summary may be used as evidence towards Recognition of Prior Learning if you wish to progress your studies in this subject. To this end the learning outcomes of the course have been benchmarked at Level 5 against level descriptors published by Ofqual, to indicate the depth of study and level of demand/complexity involved in successful completion by the learner.
The course itself has been designed by Course Gate to meet specific learners’ and/or employers’ requirements which cannot be satisfied through current regulated qualifications. ABC Awards/Certa endorsement involves robust and rigorous quality audits by external auditors to ensure quality is continually met. A review of courses is carried out as part of the endorsement process.
ABC Awards and Certa Awards have long-established reputations for providing high quality vocational qualifications across a wide range of industries. ABC Awards and Certa Awards combine over 180 years of expertise combined with a responsive, flexible and innovative approach to the needs of our customers.
Renowned for excellent customer service, and quality standards, ABC Awards and Certa Awards also offer regulated qualifications for all ages and abilities post-14; all are developed with the support of relevant stakeholders to ensure that they meet the needs and standards of employers across the UK.
Endorsed Certificate of Achievement
At the successful completion of the course, the learners can order an endorsed certificate by paying the accreditation fee of £108. There is an additional £10 postal charge for international students.
Certificate of Completion from Course Gate
At the successful completion of the course, the learners may order the Certificate of Completion from Course Gate (soft copy) by paying only £2. For the Printed hard copy of the certificate, the learners have to pay £9. There is an additional £10 delivery charge for international students.
A recognised qualification in Microsoft Excel is a valuable asset to any CV and will help you to work more efficiently when performing data-based tasks. This qualification is particularly ideal for the following careers:
- Office Administrator
- Data Entry Clerk
- Administrative Assistant
- Sales Manager
- Financial Analyst
|Module 01: Microsoft Excel 2019 New Features|
|Introduction to Microsoft Excel 2019 New Features||00:07:00|
|Pivot Table Enhancements||00:02:00|
|Power Pivot Updates||00:01:00|
|Module 02: Getting Started with Microsoft Office Excel 2016|
|Navigate the Excel User Interface||00:28:00|
|Use Excel Commands||00:10:00|
|Create and Save a Basic Workbook||00:19:00|
|Enter Cell Data||00:12:00|
|Use Excel Help||00:05:00|
|Module 03: Performing Calculations|
|Create Worksheet Formulas||00:15:00|
|Reuse Formulas and Functions||00:17:00|
|Module 04: Modifying a Worksheet|
|Insert, Delete, and Adjust Cells, Columns, and Rows||00:10:00|
|Search for and Replace Data||00:09:00|
|Use Proofing and Research Tools||00:07:00|
|Module 05: Formatting a Worksheet|
|Apply Text Formats||00:17:00|
|Apply Number Format||00:08:00|
|Align Cell Contents||00:09:00|
|Apply Styles and Themes||00:12:00|
|Apply Basic Conditional Formatting||00:11:00|
|Create and Use Templates||00:07:00|
|Module 06: Printing Workbooks|
|Preview and Print a Workbook||00:10:00|
|Set Up the Page Layout||00:08:00|
|Configure Headers and Footers||00:07:00|
|Module 07: Managing Workbooks|
|Manage Workbook and Worksheet Views||00:07:00|
|Manage Workbook Properties||00:05:00|
|Module 08: Working with Functions|
|Work with Ranges||FREE||00:18:00|
|Use Specialized Functions||00:11:00|
|Work with Logical Functions||00:23:00|
|Work with Date & Time Functions||00:08:00|
|Work with Text Functions||00:11:00|
|Module 09: Working with Lists|
|Query Data with Database Functions||00:09:00|
|Outline and Subtotal Data||00:09:00|
|Module 10: Analyzing Data|
|Create and Modify Tables||00:15:00|
|Apply Intermediate Conditional Formatting||00:07:00|
|Apply Advanced Conditional Formatting||00:05:00|
|Module 11: Visualizing Data with Charts|
|Modify and Format Charts||00:12:00|
|Use Advanced Chart Features||00:12:00|
|Module 12: Using PivotTables and PivotCharts|
|Create a PivotTable||00:13:00|
|Analyze PivotTable Data||00:12:00|
|Present Data with PivotCharts||00:07:00|
|Filter Data by Using Timelines and Slicers||00:11:00|
|Module 13: Working with Multiple Worksheets and Workbooks|
|Use Links and External References||00:12:00|
|Use 3-D References||00:06:00|
|Module 14: Using Lookup Functions and Formula Auditing|
|Use Lookup Functions||00:12:00|
|Watch and Evaluate Formulas||00:08:00|
|Module 15: Sharing and Protecting Workbooks|
|Collaborate on a Workbook||00:19:00|
|Protect Worksheets and Workbooks||00:08:00|
|Module 16: Automating Workbook Functionality|
|Apply Data Validation||00:13:00|
|Search for Invalid Data and Formulas with Errors||00:04:00|
|Work with Macros||00:18:00|
|Module 17: Creating Spark lines and Mapping Data|
|Module 18: Forecasting Data|
|Determine Potential Outcomes Using Data Tables||00:08:00|
|Determine Potential Outcomes Using Scenarios||00:09:00|
|Use the Goal Seek Feature||00:04:00|
|Forecasting Data Trends||00:05:00|