GET LIFETIME ACCESS TO ALL OUR COURSES FOR ONLY £199 £99 GET NOW
Take This Course
- Original price was: £300.00.£21.00Current price is: £21.00.
- 1 year
- Level 3
- Course Certificate
- Number of Units72
- Number of Quizzes0
- 10 hours, 52 minutes Gift this course
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. Microsoft Excel Course covers beginner, intermediate and advanced lessons in Excel 2019, with tips and shortcuts to help you utilise its ley features and functions.
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.
Learning Objectives
- 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.
Entry Requirement
- This course is available to all learners, of all academic backgrounds.
- Learners should be aged 16 or over to undertake the course.
- Good understanding of English language, numeracy and ICT are required to attend this course.
CPD Certificate from Course Gate
At the successful completion of the course, you can obtain your CPD certificate from us. You can order the PDF certificate for £9 and the hard copy for £15. Also, you can order both PDF and hardcopy certificates for £22.
Career path
A certificate in Microsoft Excel is a valuable asset to any CV and will help you to work more efficiently when performing data-based tasks. This certificate is particularly ideal for the following careers:
- Office Administrator
- Data Entry Clerk
- Administrative Assistant
- Sales Manager
- Financial Analyst
Course Curriculum
| Module 01: Microsoft Excel 2019 New Features | |||
| Introduction to Microsoft Excel 2019 New Features | 00:07:00 | ||
| CONCAT | 00:02:00 | ||
| IFS | 00:01:00 | ||
| MAXIFS | 00:01:00 | ||
| MINIFS | 00:01:00 | ||
| SWITCH | 00:02:00 | ||
| TEXTJOIN | 00:01:00 | ||
| Map Chart | 00:02:00 | ||
| Funnel Chart | 00:01:00 | ||
| Better Visuals | 00:06: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 | ||
| Insert Functions | 00:17: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 Worksheets | 00:05:00 | ||
| Manage Workbook and Worksheet Views | 00:07:00 | ||
| Manage Workbook Properties | 00:05:00 | ||
| Module 08: Working with Functions | |||
| Work with Ranges | 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 | |||
| Sort Data | 00:10:00 | ||
| Filter Data | 00:10:00 | ||
| 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 | |||
| Create Charts | 00:13:00 | ||
| 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 | ||
| Consolidate Data | 00:05:00 | ||
| Module 14: Using Lookup Functions and Formula Auditing | |||
| Use Lookup Functions | 00:12:00 | ||
| Trace Cells | 00:09: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 | |||
| Create Sparklines | 00:07:00 | ||
| MapData | 00:07:00 | ||
| 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 | ||
| Certificate and Transcript | |||
| Order Your Certificates or Transcripts | 00:00:00 | ||
Take This Course
- Original price was: £300.00.£21.00Current price is: £21.00.
- 1 year
- Level 3
- Course Certificate
- Number of Units72
- Number of Quizzes0
- 10 hours, 52 minutes Gift this course
Gift this courseShare Link on 
Instructors
Buying more than one of the same courses?
- 45% discount for orders of 10+ courses
- 55% discount for orders of 50+ courses
- 65% discount for orders of 100+ courses
Looking for a more personalised package?
contact us now
