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
Module 2: Logical and Text Functions
IF and Nested IF Statements1 Decks1 QuizAND, OR, NOT: Logical Combinations1 Decks1 QuizText Functions: CONCAT, LEFT, RIGHT, MID, LEN, TRIM1 Decks1 QuizUPPER, LOWER, PROPER, SUBSTITUTE, and FIND1 Decks1 QuizDate Functions: TODAY, NOW, DATEDIF, WORKDAY1 Decks1 QuizTime Functions and Calculating Duration1 Decks1 Quiz
Module 3: Lookup and Reference Functions
Module 4: Data Management and Formatting
Named Ranges and Dynamic Named Ranges1 Decks1 QuizData Validation: Drop-Downs and Rules1 Decks1 QuizConditional Formatting: Rules and Colour Scales1 Decks1 QuizSorting Data: Single and Multi-Level1 Decks1 QuizFiltering: AutoFilter and Advanced Filter1 Decks1 QuizRemoving Duplicates and Data Cleaning1 Decks1 QuizText to Columns and Flash Fill1 Decks1 Quiz
Module 5: PivotTables and Charts
Introduction to PivotTables1 Decks1 QuizGrouping, Filtering, and Slicing PivotTables1 Decks1 QuizCalculated Fields and Items in PivotTables1 Decks1 QuizPivotCharts: Dynamic Visualisation1 Decks1 QuizCharts: Bar, Line, Pie, and Scatter1 Decks1 QuizDual-Axis Charts and Combination Charts1 Decks1 QuizSparklines: In-Cell Mini Charts1 Decks1 Quiz
Module 6: What-If Analysis
Module 7: Power Query
Module 8: Power Pivot and DAX
Module 9: VBA and Macros
Module 10: Professional Excel Skills
Protecting Cells, Sheets, and Workbooks1 Decks1 QuizCollaboration: Comments, Track Changes, Shared Workbooks1 Decks1 QuizExcel and Power BI: The Connection1 Decks1 QuizFinancial Modelling Principles in Excel1 Decks1 QuizAudit-Proof Spreadsheets: Best Practices1 Decks1 QuizBuilding 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