Microsoft Excel - Beginner, Intermediate & Advanced - CPD Professional Course
Unlock the full potential of Microsoft Excel with this comprehensive course, designed to take you from beginner to advanced levels. Whether you’re starting fresh or looking to refine your skills, this course provides step-by-step guidance on mastering Excel for work, study, or personal projects. From basic calculations to advanced data analysis and automation, you’ll gain the confidence to use Excel efficiently and effectively.
Main Features:
- Easy-to-follow modules covering beginner, intermediate, and advanced Excel skills
- Detailed guidance on Excel 2019’s new features and updates
- Practical exercises for calculations, data analysis, and visualization
- Insights into managing and protecting workbooks efficiently
- Expert tips on using PivotTables, formulas, templates, and automating tasks
Benefits:
- Build confidence using Excel for work, projects, or study purposes
- Improve efficiency through advanced functions, formulas, and automation
- Gain skills in analyzing and visualizing data for better decision-making
- Learn best practices for managing, sharing, and protecting workbooks
- Equip yourself with a skillset widely recognised and valued across industries
This course makes learning Microsoft Excel engaging, practical, and directly applicable, transforming your ability to handle data confidently and professionally.
Course Curriculum:
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
Module 19: Excel Templates
