Master Advanced Excel Skills with Our Online Advanced Excel Course

Introduction | Editing Sheet | Formatting | Project 1

Course Duration: 10 Days

Course Overview

Our Research and Development team designed this basic level for beginners who want to learn the fundamental concepts and skills to use Microsoft Excel effectively. Participants will gain a solid foundation in spreadsheet navigation, data entry, formatting, and basic calculations.

Part 1: Getting Started with Excel

• Introduction to Microsoft Excel
• Excel interface and navigation
• Creating, saving, and opening workbooks
• Entering and editing data
• Basic cell formatting (font, alignment, borders)

Part 2: Essential Excel Functions

• Understanding formulas and functions
• Common mathematical functions (SUM, AVERAGE, MAX, MIN)
• Relative vs. absolute cell references
• AutoFill and AutoSum
• Introduction to data sorting and filtering

Duration: 25 Days

Including Level 1

Course Overview

The Advanced Level enhances Excel skills with advanced filter functions, data analysis techniques, and creating simple dashboards. Participants will learn how to transform data into actionable insights.

Part 7: Advanced Data Filtering

• Advanced filter functions (FILTER, SORT, UNIQUE)
• Working with data tables
• Creating custom views

Part 8: Advanced Formulas for Data Analysis

• Aggregate functions (SUBTOTAL, AGGREGATE)
• Calculated columns and tables

Part 9: Advanced PivotTable Techniques

• Slicers, timelines, and calculated fields
• Building hierarchies in PivotTables
• Advanced PivotTable data analysis

Part 10: Introduction to Dashboard Design

• Understanding the importance of dashboards
• Planning a dashboard project
• Data visualization best practices

Part 11: Creating Interactive Dashboards

• Building dynamic dashboards

Part 12: Advanced Visualization Techniques

• Advanced chart types (waterfall, Gantt, radar)
• Heatmaps and conditional formatting
• Custom visuals and graphics

Part 13: Dashboard Automation

• Data refresh and automation options
• Building interactive forms and buttons

This comprehensive two-level Excel training program equips participants with the skills necessary to excel in their careers, from mastering the basics and essential formulas to becoming proficient in data analytics, advanced filter functions, and creating dynamic dashboards.