Content
Excel Forms
Scenario Manager
Goal Seek
Installing Solver
Solver
Subtotals
Grouping & Outlining
Pivot Tables
Pivot Charts
Slicers
Tables
Cleansing Data
Excel Macros
Macro Security
Saving a Macro Workbook
Recording & Running a Macro
Relative Cell References (Macros)
Viewing & Editing a Macro
Assigning Macros
Global Macros
Object to run Macros
VBA Code
Content
Introduction to Excel Power Business Intelligence
Enable Power Pivot
Import and reshape CSV files & more
Power Query
Power Query Editor
Query Editor Tools
Loading Data
Pivoting and Unpivoting
Merging Queries
Appending Queries
Data Model Views
Database Normalisation
Data and Lookup Tables
Power Pivot
DAX Measures
Data Analysis Expressions (DAX)
Basic Measures
SWITCH and SWITCH(TRUE) Functions
Date and Time Functions (Basic)
Suite 163
Milton Keynes Business Centre
Foxhunter Drive
Linford Wood
Milton Keynes
MK14 6GD
Tel: 01908 92 50 58
0330 32 100 58
(Calls may be recorded for quality purposes)
By continuing to use the site, you agree to the use of cookies. more information
The cookie settings on this website are set to "allow cookies" to give you the best browsing experience possible. If you continue to use this website without changing your cookie settings or you click "Accept" below then you are consenting to this.