Excel Complete Course - Beginner, Intermediate & Advanced- CPD Accredited

Get ready to become an Excel wizard with our complete course - from beginner to advanced levels, you'll be CPD accredited in no time!

The Excel Complete Course – Beginner, Intermediate & Advanced (CPD Accredited) is a comprehensive, globally recognized program designed to turn learners into proficient Excel professionals. Whether you are just starting or looking to enhance your existing knowledge, this course covers every essential aspect of Microsoft Excel 2019, ensuring you develop real-world skills applicable across industries.

With a structured curriculum focusing on data management, formulas, functions, PivotTables, and automation, this course equips you with advanced Excel tools that help improve accuracy, efficiency, and productivity. You will learn how to create, manage, and analyze data, visualize insights through dynamic charts, automate workflows with macros, and use Excel’s newest features to make smarter business decisions.

Learning Outcomes

1. Apply Excel formulas and functions for advanced data analysis.
2. Create professional spreadsheets with clear formatting and structure.
3. Automate repetitive tasks using Excel macros and templates.
4. Interpret business insights through charts, graphs, and PivotTables.
5. Forecast data trends using Excel’s predictive analytics tools.
6. Collaborate effectively using shared and protected Excel workbooks.

Course Curriculum

Module 1: Microsoft Excel 2019 New Features

• Discover updates and improvements introduced in Excel 2019
• Explore dynamic arrays and new data types
• Utilize enhanced formulas and charting capabilities

Module 2: Getting Started with Microsoft Office Excel

• Understand Excel interface, ribbons, and menus
• Create, open, and save workbooks
• Navigate worksheets and manage basic Excel operations

Module 3: Performing Calculations

• Learn basic arithmetic and logical formulas
• Use relative, absolute, and mixed references
• Apply essential functions like SUM, AVERAGE, and IF

Module 4: Modifying a Worksheet

• Insert, delete, and move cells, rows, and columns
• Adjust row heights and column widths
• Manage worksheet tabs and rearrange data effectively

Module 5: Formatting a Worksheet

• Apply number formats, styles, and cell themes
• Use conditional formatting for visual insights
• Create a professional and readable spreadsheet layout

Module 6: Printing Workbooks

• Set up page layout, margins, and scaling options
• Create headers, footers, and page numbers
• Manage print areas and print multiple sheets efficiently

Module 7: Managing Workbooks

• Save, close, and organize multiple workbooks
• Use version history and recovery options
• Protect workbook structure and manage file properties

Module 8: Working with Functions

• Explore text, date, logical, and statistical functions
• Combine multiple functions for advanced calculations
• Understand nested functions and troubleshooting formulas

Module 9: Working with Lists

• Sort and filter data effectively
• Use data validation for input control
• Create and manage structured tables

Module 10: Analyzing Data

• Utilize built-in tools for data analysis
• Perform what-if analysis and goal seeking
• Apply data consolidation and scenarios

Module 11: Visualizing Data with Charts

• Create and format charts and graphs
• Use chart templates and combo charts
• Customize chart elements and design layouts

Module 12: Using PivotTables and PivotCharts

• Summarize large datasets using PivotTables
• Customize PivotTable layouts and fields
• Visualize summarized data with PivotCharts

Module 13: Working with Multiple Worksheets and Workbooks

• Link data across worksheets and workbooks
• Consolidate information from multiple sources
• Manage interlinked workbooks efficiently

Module 14: Using Lookup Functions and Formula Auditing

• Use VLOOKUP, HLOOKUP, and XLOOKUP for data retrieval
• Apply INDEX and MATCH for advanced lookups
• Trace, evaluate, and debug complex formulas

Module 15: Sharing and Protecting Workbooks

• Share Excel files securely with colleagues
• Set password protection and editing restrictions
• Track changes and manage version control

Module 16: Automating Workbook Functionality

• Record and run macros for repetitive tasks
• Understand VBA basics for automation
• Create customized automated reports

Module 17: Creating Sparklines and Mapping Data

• Add sparklines for quick data trend visualization
• Use geographical mapping tools in Excel
• Interpret patterns through mini charts

Module 18: Forecasting Data

• Apply forecasting formulas and functions
• Use trendlines for predictive insights
• Build and interpret forecast sheets

Module 19: Excel Templates

• Use pre-designed Excel templates for productivity
• Customize templates for reports and invoices
• Save and share reusable template files

Disclaimer:

This is an online course with pre-recorded lessons. You will get access to the course within 48 hours after your enrolment.