Modern Excel - The Supercomputer Hiding on Everyone’s Desktop

Overview

Discover game-changing Excel tools for data-driven decisions. Learn multi-source import, rapid data shaping, portable formulas, and insightful reporting techniques to supercharge your spreadsheet skills.

Syllabus

• Overview of Modern Excel
Introduction to Excel as a Data Tool
Understanding Excel’s Capabilities in Data Analysis
• Data Import Techniques
Importing Data from Various Sources
Leveraging Power Query for Data Import
• Data Shaping and Transformation
Cleaning and Preparing Data
Using Power Query for Data Shaping
• Advanced Formulas and Functions
Introduction to Dynamic Arrays
Implementing Lookup and Reference Functions
Understanding and Creating Portable Formulas
• Data Analysis and Visualization
Utilizing PivotTables for Data Analysis
Creating Dynamic Charts and Graphs
• Reporting and Dashboard Creation
Designing Interactive Dashboards
Best Practices for Report Presentation
• Integration with Other Tools
Connecting Excel with Power BI
Automating Tasks with Power Automate
• Case Studies and Practical Applications
Real-World Data Scenarios
Problem-Solving with Excel
• Course Wrap-Up
Review of Key Concepts
Resources for Further Learning

---

Subjects

Conference Talks