Autoplay
Autocomplete
Previous Lesson
Complete and Continue
Microsoft Excel for Executive Reporting Training
Session 1 - Introduction and Excel Fundamentals
Session Video - Introduction and Excel Fundamentals (29:37)
Assignment - Introduction and Excel Fundamentals
Lab Activity - Creating Your First Excel Workbook Basic Formatting and Data Entry
Session 2 - Advanced Excel Techniques
Session Video - Advanced Excel Techniques (44:54)
Assessment - Advanced Excel Techniques
Assignment - Advanced Excel Techniques
Session 3 - Excel Functions and Final Data Preparation
Session Video - Excel Functions and Final Data Preparation (39:54)
Assessment - Excel Functions and Final Data Preparation
Assignment - Excel Functions and Final Data Preparation
Lab Activity - Using VLOOKUP and XLOOKUP for Data Retrieval
Session 4 - Introduction and Data Preparation Basics
Session Video - Introduction and Data Preparation Basics (41:15)
Session 5 - Advanced Data Management and Excel Functions
Session Video - Advanced Data Management and Excel Functions (48:26)
Assessment - Advanced Data Management and Excel Functions
Assignment - Advanced Data Management and Excel Functions
Lab Activity - Implementing Conditional Logic with IF, SUMIF, and COUNTIF Functions
Session 6 - Visualization
Session Video - Visualization (64:28)
Assessment - Visualization
Assignment - Visualization
Lab Activity - Creating Interactive Dashboards with Pivot Tables and Charts
Assignments
Assessment - Introduction to Executive Reporting
Assessment - Setting Up Your Report
Assessment - CreatingFormatting Tables
Assessment - Pivot Tables
Assessment - Visual Enhancements
Assessment - Table of Contents
Materials Shared by Instructor
Excel Executive Reporting (F1)
Interview Q&As
Set 1 - Interview Q&As
Set 2 - Interview Q&As
Set 3 - Interview Q&As
Quiz
Test your Knowledge
Prepare your Linkedin profile
Linkedin Cheat Sheet
Prepare your Resume
Resume Cheat Sheet
Teach online with
Test your Knowledge
Lesson content locked
If you're already enrolled,
you'll need to login
.
Enroll in Course to Unlock