Microsoft Excel: Advanced Training (11 units)
Pivot Tables, Statistical Functions, Charts, and Data Management in Excel
About This Course
Course Information
Create dynamic reports by mastering management tools such as pivot tables. It is not just the tools for calculation but also how to present these results using charts to communicate your findings with senior management. This course covers all the excel requirements for you to reimagine how you do your job.
Certificate on Completion
This course is made up of videos, questions and additional reading materials and accounts for 11 units of CPD. One unit is the equivalent of one hour of learning. A certificate will be issued once you have completed all 11 units.
Course Sections
This track is made up of the following sections:
- MS Excel 5: Sorting, Checking and Importing Data (3 units)
- MS Excel 6: Statistical Functions (3 units)
- MS Excel 7: Using Charts (2 units)
- MS Excel 8: Pivot Tables and Workbook Management (3 units)
What You Will Learn
- Apply sorting, data checking, and data importing techniques to manage large datasets in Excel
- Calculate statistical measures using Excel's built-in statistical functions
- Apply chart formatting techniques to present data clearly to management and other audiences
- Describe how to build pivot tables to summarise and analyse large volumes of data
- Describe best practices for workbook management, including organising sheets and protecting data
- Evaluate which chart types and statistical functions are most appropriate for different business scenarios
Who This Course Is For
- Accountants and finance professionals who use Excel daily and want to move beyond basic formulas
- Analysts who need to present data using charts and pivot tables
- Professionals who manage or import large datasets and need better data handling skills in Excel
Prerequisites
- Proficiency in basic Excel functions, formatting, and data entry
- Familiarity with common formulas such as SUM, IF, VLOOKUP, and basic cell referencing
- Access to Microsoft Excel (2016 or later recommended)
Frequently Asked Questions
Course Details
Pricing
Invest in your professional development with flexible payment options.
Everything included in your subscription:
Ready to Start Learning?
Join thousands of finance professionals who have advanced their careers with Learnsignal CPD courses.
Enrol Now (30% Off)