Advanced Microsoft Excel - Classroom
1.995,00 EUR
- 20 hours
Master advanced Excel features and functions to boost productivity. Learn to use PivotTables, charts, mathematical formulas, and IF functions efficiently. With real-world examples and hands-on exercises, this virtual course helps you move beyond the basics to tackle statistical tasks, data analysis, and professional reporting. From foundational skills to advanced concepts like correlation, regression, sparklines, and complex formulas, our expert instructors guide you every step of the way.
Key Features
Language
Course material in English
Level
Beginner - intermediate level
20 Hours of Instructor-Led Training
50+ hours recommended study time
Hands-on exercises to supplement
Real-life projects to help you Master Excel
Certification
Program completion certification included
Ask for date confirmation!
Program completion certification included
Learning Outcomes
At the end of this program, you will be able to:
Build advanced proficiency
going beyond basic functions to expert‑level capabilities.
Apply complex formulas and functions
(including statistical, lookup, and logical operations) for data analysis.
Clean, prepare, and validate large datasets
to ensure accuracy and readiness for analysis.
Use PivotTables and interactive tools
like slicers for summarizing and analyzing data efficiently.
Create compelling visualizations
and dashboards using charts, sparklines, and presentation tools.
Automate tasks
and workflows using Macros and introductory VBA scripting.
Perform statistical analysis
such as correlation, regression, and time‑series analysis in Excel.
Enhance decision‑making skills
by leveraging advanced data analysis functions and real‑world scenarios.
Course timeline
Microsoft Excel Fundamentals
Lesson 1
- What are Rows, Cells, and Column
- Customizing Excel Quick Access Toolbar
- Common Excel Shortcuts
- Different Types of Data Types
- Moving the Cells to Different Position
- Understand the Menu and Toolbars
- Use of Function Box
- Use of Cell Reference and Cell Edits
- Use of Name Box and Range
Formatting Concepts
Lesson 2
- Understand the Formatting Techniques
- Data Type Formatting
- Formatting Techniques on Rows and Columns
- Conditional Formatting
Formulas in Excel
Lesson 3
- Text Functions
- Date Functions
- Basic Excel Formulas
Managing Lists
Lesson 4
- Understanding Lists as a Table and Database
- Sorting Lists
- Filters
- Grouping and Outlining Data
Inserting Images
Lesson 5
- Inserting Images in Excel
- Inserting Shapes in Excel
- Working with SmartArt
Using Functions
Lesson 6
- SUM Function
- AVERAGE Function
- PRODUCT Function
- MIN Function
- MAX Function
- COUNT Function
- COUNTA Function
- COUNTBLANK Function
- COUNTIF Function
- SUMIF(): Adding Only the Cells You Specify
- COUNTIFS() and SUMIFS(): Counting and Summing
- IF Function
- AND Function
- OR Function
Advanced Formulas
Lesson 7
- VLOOKUP With Exact Match
- INDEX and MATCH vs VLOOKUP
- VLOOKUP With Approximate Match
- Format as Table
- Data Model Tool
- Slicer in Pivot Table
Templates, Macros and VBA
Lesson 8
- Using Predefined Templates
- Creating Custom Templates
- Creating Macros
- VBA Modules
- Visual Basic Editor
- VBA Coding and Scripting
Data Cleaning and Preparing
Lesson 9
- Text to Columns
- Remove Duplicates
- Data Validation
- Find and Replace
- Data Entry Form
Pivot Table and Grouping for Data Analysis
Lesson 10
- Calculated Fields in Pivot Table
- Grouping Data with Pivot Table
- GetPivotData
- Group and Ungroup
Scenario and Sensitivity Analysis
Lesson 11
- What-If Analysis: Goal Seek
- What-If Analysis: Data Table
- What-If Analysis: Scenario Manager
- Auditing Formulas
Formatted and Interactive Tables
Lesson 12
- Format as Table
- Data Model Tool
- Formatting Pivot
- Value Fields Setting
Charts and Visualization Techniques
Lesson 13
- Sparklines as Mini Charts
- Column Chart and Bar Chart
- Line Chart
- Pie Chart
- Area Chart
- Combo Charts
- Speedometer Chart
- PivotChart
- Creation of Interactive Dashboard
- Presentation of Final Results
Data Analysis ToolPak for Statistics
Lesson 14
- Activation of Data Analysis ToolPak Add-in
- Descriptive Statistics
- Histogram
- Correlation
- Linear Regression
- Explanation of Regression Output
- Multiple Linear Regression
- Probability
- Z-scores
- Download the Results of Statistical Analysis
- Time Series Analysis in Excel
Who Should Enroll in this Program?
No prior prerequisites are required to join this course. A basic familiarity with Microsoft Excel is recommended but not mandatory.
Business Analysts looking to enhance data analysis, reporting, and visualization skills.
Finance and Accounting Professionals who need advanced Excel functions for financial modeling and reporting
Project Managers aiming to streamline project tracking, dashboards, and reporting.
Data Enthusiasts & Aspiring Data Analysts who want to master Excel for insights and analytics.
Statements
Licensing and accreditation
The course is offered according to Partner Program Agreement and complies with the License Agreement requirements.
Equity Policy
Candidates are encouraged to reach out to AVC for guidance and support throughout the accommodation process.
Frequently Asked Question
Need corporate solutions or LMS integration?
Didn't find the course or program which would work for your business? Need LMS integration? Write us, we will solve everything!