Microsoft Excel Complete Course

Description

Course Overview
The "Microsoft Excel Complete Course" is designed to equip learners with the essential skills to master Microsoft Excel, one of the most widely used tools in data analysis and business operations. This course covers a comprehensive range of topics, including Excel's new features, formula creation, data visualisation, and workbook management. It offers practical knowledge that will help learners work more efficiently, whether they are managing large datasets, analysing trends, or presenting information. By the end of this course, learners will be confident in using Excel for various business tasks, gaining a strong foundation for further professional development.

Course Description
This course covers all key aspects of Microsoft Excel, from the basics to advanced techniques. Learners will explore Excel’s new features in the 2019 version, as well as how to perform calculations, modify worksheets, and apply formatting. The course delves into functions, lists, and data analysis tools, including PivotTables and charts. Learners will also learn how to work with multiple worksheets and workbooks, use lookup functions, and automate workbook functionality. With a focus on essential Excel tools and techniques, learners will gain the ability to efficiently manage and analyse data for business or personal use.

Course Modules
Module 01: Microsoft Excel 2019 New Features
Module 02: Getting Started with Microsoft Office Excel
Module 03: Performing Calculations
Module 04: Modifying a Worksheet
Module 05: Formatting a Worksheet
Module 06: Printing Workbooks
Module 07: Managing Workbooks
Module 08: Working with Functions
Module 09: Working with Lists
Module 10: Analyzing Data
Module 11: Visualizing Data with Charts
Module 12: Using PivotTables and PivotCharts
Module 13: Working with Multiple Worksheets and Workbooks
Module 14: Using Lookup Functions and Formula Auditing
Module 15: Sharing and Protecting Workbooks
Module 16: Automating Workbook Functionality
Module 17: Creating Sparklines and Mapping Data
Module 18: Forecasting Data
(See full curriculum)

Who is this course for?

Career Path