What You Need to Know Before
You Start
Starts 8 June 2025 06:30
Ends 8 June 2025
00
days
00
hours
00
minutes
00
seconds
Modern Excel - The Supercomputer Hiding on Everyone’s Desktop
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.
PASS Data Community Summit
via YouTube
PASS Data Community Summit
2544 Courses
1 hour 19 minutes
Optional upgrade avallable
Not Specified
Progress at your own speed
Conference Talk
Optional upgrade avallable
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
- Data Import Techniques
- Data Shaping and Transformation
- Advanced Formulas and Functions
- Data Analysis and Visualization
- Reporting and Dashboard Creation
- Integration with Other Tools
- Case Studies and Practical Applications
- Course Wrap-Up
Introduction to Excel as a Data Tool
Understanding Excel’s Capabilities in Data Analysis
Importing Data from Various Sources
Leveraging Power Query for Data Import
Cleaning and Preparing Data
Using Power Query for Data Shaping
Introduction to Dynamic Arrays
Implementing Lookup and Reference Functions
Understanding and Creating Portable Formulas
Utilizing PivotTables for Data Analysis
Creating Dynamic Charts and Graphs
Designing Interactive Dashboards
Best Practices for Report Presentation
Connecting Excel with Power BI
Automating Tasks with Power Automate
Real-World Data Scenarios
Problem-Solving with Excel
Review of Key Concepts
Resources for Further Learning
Subjects
Conference Talks
