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
Session Video - Introduction and Excel Fundamentals
Complete and Continue