Professional Development · IT & Digital

Excel for Professionals — Beginner to Power User

A 50-topic flagship programme covering Microsoft Excel from fundamentals through Power Query, Power Pivot, DAX, VBA, and dashboard design — for professionals who need to master Excel for data analysis, reporting, and automation.

50 Lektionen

50 Karteikarten-Decks

50 Quizze

Lehrplan

Module 1: Excel Fundamentals

The Excel Interface: Ribbons, Cells, and Workbooks1 Decks1 Quiz Entering and Editing Data Efficiently1 Decks1 Quiz Cell References: Relative, Absolute, and Mixed1 Decks1 Quiz Essential Formulas: SUM, AVERAGE, COUNT, MIN, MAX1 Decks1 Quiz

Module 2: Logical and Text Functions

IF and Nested IF Statements1 Decks1 Quiz AND, OR, NOT: Logical Combinations1 Decks1 Quiz Text Functions: CONCAT, LEFT, RIGHT, MID, LEN, TRIM1 Decks1 Quiz UPPER, LOWER, PROPER, SUBSTITUTE, and FIND1 Decks1 Quiz Date Functions: TODAY, NOW, DATEDIF, WORKDAY1 Decks1 Quiz Time Functions and Calculating Duration1 Decks1 Quiz

Module 3: Lookup and Reference Functions

VLOOKUP: How It Works and Its Limits1 Decks1 Quiz HLOOKUP and Two-Way Lookups1 Decks1 Quiz INDEX and MATCH: The Flexible Alternative1 Decks1 Quiz XLOOKUP: The Modern Lookup (Excel 365/2021+)1 Decks1 Quiz SUMIF, COUNTIF, and AVERAGEIF1 Decks1 Quiz SUMIFS and COUNTIFS: Multiple Conditions1 Decks1 Quiz

Module 4: Data Management and Formatting

Named Ranges and Dynamic Named Ranges1 Decks1 Quiz Data Validation: Drop-Downs and Rules1 Decks1 Quiz Conditional Formatting: Rules and Colour Scales1 Decks1 Quiz Sorting Data: Single and Multi-Level1 Decks1 Quiz Filtering: AutoFilter and Advanced Filter1 Decks1 Quiz Removing Duplicates and Data Cleaning1 Decks1 Quiz Text to Columns and Flash Fill1 Decks1 Quiz

Module 5: PivotTables and Charts

Introduction to PivotTables1 Decks1 Quiz Grouping, Filtering, and Slicing PivotTables1 Decks1 Quiz Calculated Fields and Items in PivotTables1 Decks1 Quiz PivotCharts: Dynamic Visualisation1 Decks1 Quiz Charts: Bar, Line, Pie, and Scatter1 Decks1 Quiz Dual-Axis Charts and Combination Charts1 Decks1 Quiz Sparklines: In-Cell Mini Charts1 Decks1 Quiz

Module 6: What-If Analysis

Goal Seek: Working Backwards from a Target1 Decks1 Quiz Scenario Manager: Comparing Multiple Outcomes1 Decks1 Quiz Data Tables: One- and Two-Variable Sensitivity Analysis1 Decks1 Quiz Solver: Optimisation Problems1 Decks1 Quiz

Module 7: Power Query

Power Query: Connecting to External Data Sources1 Decks1 Quiz Transforming Data in Power Query1 Decks1 Quiz Merging and Appending Queries1 Decks1 Quiz

Module 8: Power Pivot and DAX

Introduction to Power Pivot and the Data Model1 Decks1 Quiz DAX Fundamentals: Calculated Columns and Measures1 Decks1 Quiz CALCULATE, FILTER, and Context in DAX1 Decks1 Quiz

Module 9: VBA and Macros

Recording Macros: Automating Repetitive Tasks1 Decks1 Quiz Understanding and Editing Recorded VBA1 Decks1 Quiz Writing Your First VBA Procedure1 Decks1 Quiz Building a User Form in VBA1 Decks1 Quiz

Module 10: Professional Excel Skills

Protecting Cells, Sheets, and Workbooks1 Decks1 Quiz Collaboration: Comments, Track Changes, Shared Workbooks1 Decks1 Quiz Excel and Power BI: The Connection1 Decks1 Quiz Financial Modelling Principles in Excel1 Decks1 Quiz Audit-Proof Spreadsheets: Best Practices1 Decks1 Quiz Building a Complete Management Dashboard1 Decks1 Quiz

Jetzt Excel for Professionals — Beginner to Power User lernen

Alle 50 Lektionen mit Karteikarten, Quizzen und KI-Lernhilfen. 7 Tage kostenlos.

Kostenlos testen