Ultimate Microsoft Excel Bootcamp Bundle
Unlock the secrets of Excel and master spreadsheets.
Hone your skills in one of the most important, universal areas in the modern knowledge workers day to day job, and become indispensable.
However, we know Excel can be mystifying and intimidating to many people.
This bundle is perfect for beginners all the way through to data and financial analysts interested in solving complex business problems. We’ve established ourselves as the Excel experts in the last 12 years, and you won’t find better, or more thorough content anywhere else.
+ View All Courses & Syllabi
PRE-ASSESSMENT
+ SECTION 1 | FOUNDATION - 11 MODULES
Unit 1 | Excel Introduction
1. What's New in Excel 2019?
Unit 2 | The Excel Interface
1. The Excel Screen and Interface
2. The File Tab
3. Spreadsheet and Views
4. Themed Exercise
Unit 3 | Basic Navigation and Editing
1. Selection and Navigation
2. Basic Formatting
3. Multiple Worksheets
4. Themed Exercise
Unit 4 | Getting Going
1. Simple Formulae
2. Basic Functions
+ SECTION 2 | ORIENTATION AND EFFICIENCY - 21 MODULES
Unit 5 | Editing
1. Copying
2. Pasting
3. Inserting, Deleting, and Clearing
4. Fill Handle and Flash Fill
5. Themed Exercise
Unit 6 | Viewing
1. Views
2. Splitting the Screen
3. Themed Exercise
Unit 7 | Spreadsheet Structure
1. Grouping Rows and Columns
2. Changing Cell Shape
3. Themed Exercise
Unit 8 | Cell References
1. Relative References
2. Fixed References
3. Themed Exercise
Unit 9 | Named Ranges
1. Simple Range Names
2. Managing Named Ranges
3. Themed Exercise
Unit 10 | Basic Macros
1. Getting Started
2. Simple Recorded Macros
3. Practical Applications
4. Themed Exercise
+ SECTION 3 | ADMINISTRATION - 7 MODULES
Unit 11 | Connecting Workbooks
1. Basic Technique
2. Managing Links
3. Themed Exercise
Unit 12 | Protecting and Sharing
1. Protection
2. Sharing
3. Sharing Via the Cloud
4. Themed Exercise
+ SECTION 4 | DATA HANDLING - 28 MODULES
Unit 13 | Sorting and Filtering
1. Basic Sorting
2. Basic Filtering
3. Advanced Filter
4. Introduction to PivotTables
5. Themed Exercise
Unit 14 | Controlling User Input
1. Data Validation
2. Facilitating Data Entry
3. Introduction to IS and IF Functions
4. Themed Exercise
Unit 15 | Working With Dates and Times
1. Date and Time Formatting
2. Date and Time Math
3. Basic Date and Time Functions
4. Advanced Date and Time Functions
5. Themed Exercise
Unit 16 | Working With Text
1. Entering and Formatting Text
2. Extracting Parts of Text
3. Concatenating Text
4. Manipulating Text
5. Themed Exercise
Unit 17 | Lookup and Reference
1. Looking Up Information in a Table
2. Looking Up Information More Flexibly
3. Advanced Lookups
4. Themed Exercise
Unit 18 | Logical Functions
1. Automatic Decision Making
2. Using Logic to Apply Conditions
3. Error Handling
4. Advanced Logical Tests
5. Themed Exercise
+ SECTION 5 | DATA ANALYSIS - 40 MODULES
Unit 19 | Working With Numbers
1. Basic Math
2. Rounding
3. Themed Exercise
Unit 20 | Summarizing Data
1. Totals and Counts
2. Other Statistics
3. Conditional Totals and Counts
4. Advanced Conditional Sums
5. Themed Exercise
Unit 21 | PivotTables 1 - Simple Summaries
1. Uses of PivotTables
2. Basics of PivotTables
3. Filtering
4. Sorting and Grouping
5. Themed Exercise
Unit 22 | PivotTables 2 - Manipulating Data
1. Understanding Data Structures
2. Formatting and Layout
3. Value Field Settings
4. GETPIVOTDATA()
5. Themed Exercise
Unit 23 | PivotTables 3 - Interpreting Data
1. Slicers and Timelines
2. PivotCharts
3. Conditional Formatting In PivotTables
4. Building an Interactive Dashboard
5. Themed Exercise
Unit 24 | Power Pivot: Handling Big Data
1. Introduction
2. Power Pivot Data Tools
3. Data Analysis Expressions (DAX)
4. Advanced Techniques
5. Themed Exercise
Unit 25 | Formula Auditing
1. Tracing Calculations
2. Monitoring Effects of Changes
3. The Inquire Add-In
4. Themed Exercise
Unit 26 | Advanced Macros and VBA
1. Writing Code Directly - Sub Procedures
2. Writing Code Directly - User-Defined Functions
3. Structure and Worksheet Change Event
4. Interactive VBA
5. Themed Exercise
Unit 27 | Modeling
1. Principles
2. Techniques
3. Themed Exercise
+ SECTION 6 | PRESENTATION - 25 MODULES
Unit 28 | Cell Formatting
1. Basic Font Formatting
2. Alignment
3. Styles
4. Formatting Tools
5. Themed Exercise
Unit 29 | Number Formatting
1. Types of Numbers
2. Clarity and Impact
3. Custom Number Formats
4. Advanced Custom Formats
5. Number Formats and Styles
6. Themed Exercise
Unit 30 | Conditional Formatting
1. Basic Conditional Formatting
2. Graphical Conditional Formats
3. Advanced Conditional Formats
4. Themed Exercise
Unit 31 | Charts and Graphs
1. Creating Simple Charts
2. Editing Charts
3. Advanced Charts
4. Sparklines
5. Themed Exercise
Unit 32 | Page and Print Setup
1. Displaying Spreadsheets as Pages
2. Adjusting Page Setup
3. Printing Very Large Sheets of Data
4. Finally, Printing!
5. Themed Exercise
FINAL ASSESSMENT
PRE-ASSESSMENT
+ SECTION 1 | INTRODUCTION - 1 MODULE
Unit 1 | What's New in Excel 2019?
1. What's New in Office 2019?
+ SECTION 2 | EFFICIENCY AND RISK - 13 MODULES
Unit 2 | Templates
1. Introduction
2. Default Templates and Creating Modular Workbooks
3. Customized Interface
4. Exercise
Unit 3 | Increasing Efficiency and Reducing Risk
1. Introduction to Design Standards
2. Controls and Checks
3. Techniques
4. Review and Documentation
5. Exercise
Unit 4 | Data Validation
1. Data Validation Formulae
2. Data Validation With Dependent Lists
3. Data Validation Alternatives
4. Exercise
+ SECTION 3 | ADVANCED TECHNIQUES - 29 MODULES
Unit 5 | Functions With Superpowers
1. Introduction
2. MOD
3. OFFSET
4. INDIRECT
5. LOOKUP From Right to Left - CHOOSE
6. Dynamic Ranges vs Tables
7. Exercise
Unit 6 | Array Formulas
1. Array Formulae Explained
2. Alternatives to Array Formulae
3. Exercise
Unit 7 | Tables
1. Automatic Expansion
2. Table Formulae
3. Working With Data in Tables
4. Slicers in Tables
5. Table Benefits and Drawbacks
6. Exercise
Unit 8 | Advanced Range Names
1. Advanced Range Names
2. Using Names in Formulae
3. Formula in Range Names
4. Exercise
Unit 9 | WhatIf Analysis
1. Goal Seek
2. Data Tables
3. Solver Add-In
4. Scenario Manager
5. Exercise
Unit 10 | Problem Solving
1. Introduction
2. Boolean Logic and Arrays in Action
3. Using Tables
4. Exercise
+ SECTION 4 | EXCEL INTERACTIVITY - 9 MODULES
Unit 11 | Form Controls
1. Basic Form Controls
2. Advanced Controls
3. Exercise
Unit 12 | Visual Basic and Macros
1. Writing Code Directly: Sub Procedures
2. Writing Code Directly: User-Defined Functions
3. Structure and Worksheet Change Event
4. Interactive VBA
5. VBA Projects
6. Exercise
+ SECTION 5 | SPREADSHEET IMPACT - 16 MODULES
Unit 13 | Conditional Formatting
1. Conditional Format Formulae
2. Advanced Conditional Formatting
3. Creative Conditional Formatting
4. Exercise
Unit 14 | Charts That Inspire
1. What Makes a Good Chart?
2. Advanced Charts and Techniques Part 1
3. Advanced Charts and Techniques Part 2
4. Advanced Charts and Techniques Part 3
5. Exercise
Unit 15 | Sparklines
1. Sparklines
2. Advanced Uses: Dynamic References
3. Exercise
Unit 16 | Graphics Tricks and Techniques
1. Excel Camera
2. Power View
3. 3D Map
4. Exercise
+ SECTION 6 | TURNING DATA INTO DECISIONS - 21 MODULES
Unit 17 | Working With External Data
1. Introduction
2. Understanding Data Structures
3. Get & Transform: From Database to Spreadsheet
4. Data Model
5. Exercise
Unit 18 | Advanced Uses of PivotTables
1. Advanced PivotTable Techniques
2. Using PivotTables as a Management Report Engine
3. Understand Data With Slicers and Timelines
4. Working With PivotCharts
5. Building an Interactive Dashboard
6. Exercise
Unit 19 | Power Pivot
1. Introduction
2. Power Pivot Data Tools
3. Basic Data Analysis Expressions
4. Advanced Data Analysis Expressions
5. Time Intelligence Functions
6. Exercise
Unit 20 | Reporting With Power Pivot
1. Additional Features
2. Advanced Techniques
3. Creating a Dashboard
4. Exercise
FINAL ASSESSMENT
+ SECTION 1 | PIVOTTABLES - 19 MODULES
Unit 1 | Introduction and Basics
1. Uses and Benefits of PivotTables
2. Basics of PivotTables
3. Manipulating PivotTable Data
4. Exercise
Unit 2 | Filter and Group to Compare and Contrast
1. Filtering
2. Sorting and Grouping
3. Exercise
Unit 3 | Presentation – Clarity and Impact
1. Layout and Formatting
2. PivotCharts
3. Conditional Formatting in PivotTables
4. Exercise
Unit 4 | Calculations – Adding Value to Values
1. Value Field Settings
2. Calculated Fields and Values
3. Exercise
Unit 5 | Your Data Your Way – Flexible Reporting
1. Using PivotTables As Management Report Engines
2. Cube Values
3. Exercise
Unit 6 | Power to the User – Interactivity
1. Understand Data With Slicers and Timelines
2. Exercise
+ SECTION 2 | PIVOTTABLES FOR DATA ANALYSIS - 18 MODULES
Unit 7 | Dominate Your Data
1. Understanding Data Structures
2. The Power Query Add-In
Unit 8 | Power Pivot and Big Data
1. Introduction to Power Pivot
2. Power Pivot Data Tools
3. Exercise
Unit 9 | Make Your Data Work Harder
1. Basic Data Analysis Expressions (DAX) Introduction
2. Advanced Data Analysis Expressions (DAX)
3. Time Intelligence Functions
Unit 10 | From Data to Decisions
1. Introduction
2. Additional Features
3. KPIs
4. Cube Functions
5. Creating a Dashboard
6. Exercise
Unit 11 | Present Data Analysis With Impact
1. What Makes a Good Chart?
2. Advanced Charts
3. Waterfall Chart
4. Sparklines
Unit 12 | Give Me More Power
1. Power View
2. Power Map
PRE-ASSESSMENT
+ SECTION 1 | INTRODUCTION - 2 MODULES
Unit 1 | Turning Numbers Into Better Business Decisions
1. Course Introduction Video
2. Successful Business and Financial Models
+ SECTION 2 | THE BUSINESS ANALYST EXCEL TOOLBOX - 7 MODULES
Unit 2 | Essential Excel for Business Analysis
1. Range Names for Business Models
2. Focus On Results
3. Validation of Numbers and Lists
4. Matching and Ranking Data
Unit 3 | Professional Tools for Business Analysts
1. Maintaining Control of Your Worksheets
2. Testing and Simulating Models
3. Error-Free Worksheets
+ SECTION 3 | COLLECTING AND MANAGING BUSINESS DATA - 6 MODULES
Unit 4 | Professional Tools for Business Analysts
1. Importing Business Data
2. Extracting Business Data
3. Exporting Business Data
Unit 5 | Power Functions for Managing Business Data
1. Dynamic Ranges
2. Extracting Data With Logical Functions
3. Using Frequency Distributions
+ SECTION 4 | COMMUNICATING YOUR MESSAGE - 5 MODULES
Unit 6 | Your Stakeholders and Their Needs
1. Matching Stakeholders' Requirements
2. Text, Table, or Chart?
Unit 7 | Data Presentation Formats That Work
1. Effective Tables, Charts, and Presentation Media
2. Presenting Key Data Relationships
3. Graphical Text and Tables
+ SECTION 5 | WINNING CHARTS FOR BUSINESS COMMUNICATION - 7 MODULES
Unit 8 | Professional Charting
1. Charts That Work
2. Chart Styles and Templates
3. 'Conditional Format' Charts
Unit 9 | Dynamic Charts
1. Charting From Large Datasets
2. Techniques for Dynamic Charts
3. Charts That Pan and Zoom
Unit 10 | Some Special Charts for Business Analysis
1. Some Special Charts
+ SECTION 6 | LOOKING INSIDE YOUR DATA (ANALYSIS) - 7 MODULES
Unit 11 | Analyzing Data With PivotTables
1. Grouping and Cross Tabulating Data
2. Large Data Analysis With PivotTables
3. Comparisons in PivotTables
Unit 12 | Managing PivotTables Output
1. Slicers and Filters
2. PivotCharts
3. PivotTable Frequency Distributions
4. Keeping PivotTables Current
+ SECTION 7 | COMPARING BUSINESS SCENARIOS - 4 MODULES
Unit 13 | Decision-Making With Compared Scenarios
1. Single Variable Data Tables
2. Multiple Variable Data Tables
Unit 14 | The Scenario Manager
1. Selecting Scenarios
2. Scenario Manager Outputs
+ SECTION 8 | LOOKING OUTSIDE YOUR DATA (FORECASTING) - 5 MODULES
Unit 15 | Time Series and Forecasting
1. Curve Fitting and Trendlines
2. Linear Forecasting
Unit 16 | Working With Moving Averages
1. Smoothing Data
2. Seasonal Factors
Unit 17 | Introduction to Regression
1. Introduction to Regression
+ SECTION 9 | ENDING - 1 MODULE
Unit 18 | Ending
1. End of Course Video
FINAL ASSESSMENT
+ About the Authors
Deborah Ashby specialises in Microsoft Office training courses and content creation. Deborah has been an IT Trainer for almost fifteen years and has worked at Microsoft, training its employees in its own software. Deborah is a Microsoft Office Specialist (MOS) and Microsoft Certified Trainer (MCT), and she is TAP certified.
Simon Hurst is a Chartered Accountant and has been involved in computer software for 26 years during which he has provided a wide range of training services to professionals of all levels. His expertise lies in all the main Microsoft applications and he's been running hands-on Excel training courses for over 20 years, dealing with all aspects of Excel from basic competence to advanced data analysis.
Featured Reviews - ⭐⭐⭐⭐⭐
I truly recommend this business - M. Bhogaita
[EwB] offers a great range of packages so you can pick the one that suits your own needs, and learn at a pace that suits you … I truly recommend this business, it’s effectively helping you improve your skillset.
Great way to learn something new. - C. Neelson
Great way to learn something new. Very easy to use and you just keep learning at your own pace.
- Sale price
- £176.00
- Regular price
-
- Sale price
- £176.00
- Regular price
-
- Unit price
- /per
Learners:
Level:
Duration:
Accreditation:
Length of Access:
Adding product to your cart
Unlock the secrets of Excel and master spreadsheets.
Hone your skills in one of the most important, universal areas in the modern knowledge workers day to day job, and become indispensable.
However, we know Excel can be mystifying and intimidating to many people.
This bundle is perfect for beginners all the way through to data and financial analysts interested in solving complex business problems. We’ve established ourselves as the Excel experts in the last 12 years, and you won’t find better, or more thorough content anywhere else.
+ View All Courses & Syllabi
PRE-ASSESSMENT
+ SECTION 1 | FOUNDATION - 11 MODULES
Unit 1 | Excel Introduction
1. What's New in Excel 2019?
Unit 2 | The Excel Interface
1. The Excel Screen and Interface
2. The File Tab
3. Spreadsheet and Views
4. Themed Exercise
Unit 3 | Basic Navigation and Editing
1. Selection and Navigation
2. Basic Formatting
3. Multiple Worksheets
4. Themed Exercise
Unit 4 | Getting Going
1. Simple Formulae
2. Basic Functions
+ SECTION 2 | ORIENTATION AND EFFICIENCY - 21 MODULES
Unit 5 | Editing
1. Copying
2. Pasting
3. Inserting, Deleting, and Clearing
4. Fill Handle and Flash Fill
5. Themed Exercise
Unit 6 | Viewing
1. Views
2. Splitting the Screen
3. Themed Exercise
Unit 7 | Spreadsheet Structure
1. Grouping Rows and Columns
2. Changing Cell Shape
3. Themed Exercise
Unit 8 | Cell References
1. Relative References
2. Fixed References
3. Themed Exercise
Unit 9 | Named Ranges
1. Simple Range Names
2. Managing Named Ranges
3. Themed Exercise
Unit 10 | Basic Macros
1. Getting Started
2. Simple Recorded Macros
3. Practical Applications
4. Themed Exercise
+ SECTION 3 | ADMINISTRATION - 7 MODULES
Unit 11 | Connecting Workbooks
1. Basic Technique
2. Managing Links
3. Themed Exercise
Unit 12 | Protecting and Sharing
1. Protection
2. Sharing
3. Sharing Via the Cloud
4. Themed Exercise
+ SECTION 4 | DATA HANDLING - 28 MODULES
Unit 13 | Sorting and Filtering
1. Basic Sorting
2. Basic Filtering
3. Advanced Filter
4. Introduction to PivotTables
5. Themed Exercise
Unit 14 | Controlling User Input
1. Data Validation
2. Facilitating Data Entry
3. Introduction to IS and IF Functions
4. Themed Exercise
Unit 15 | Working With Dates and Times
1. Date and Time Formatting
2. Date and Time Math
3. Basic Date and Time Functions
4. Advanced Date and Time Functions
5. Themed Exercise
Unit 16 | Working With Text
1. Entering and Formatting Text
2. Extracting Parts of Text
3. Concatenating Text
4. Manipulating Text
5. Themed Exercise
Unit 17 | Lookup and Reference
1. Looking Up Information in a Table
2. Looking Up Information More Flexibly
3. Advanced Lookups
4. Themed Exercise
Unit 18 | Logical Functions
1. Automatic Decision Making
2. Using Logic to Apply Conditions
3. Error Handling
4. Advanced Logical Tests
5. Themed Exercise
+ SECTION 5 | DATA ANALYSIS - 40 MODULES
Unit 19 | Working With Numbers
1. Basic Math
2. Rounding
3. Themed Exercise
Unit 20 | Summarizing Data
1. Totals and Counts
2. Other Statistics
3. Conditional Totals and Counts
4. Advanced Conditional Sums
5. Themed Exercise
Unit 21 | PivotTables 1 - Simple Summaries
1. Uses of PivotTables
2. Basics of PivotTables
3. Filtering
4. Sorting and Grouping
5. Themed Exercise
Unit 22 | PivotTables 2 - Manipulating Data
1. Understanding Data Structures
2. Formatting and Layout
3. Value Field Settings
4. GETPIVOTDATA()
5. Themed Exercise
Unit 23 | PivotTables 3 - Interpreting Data
1. Slicers and Timelines
2. PivotCharts
3. Conditional Formatting In PivotTables
4. Building an Interactive Dashboard
5. Themed Exercise
Unit 24 | Power Pivot: Handling Big Data
1. Introduction
2. Power Pivot Data Tools
3. Data Analysis Expressions (DAX)
4. Advanced Techniques
5. Themed Exercise
Unit 25 | Formula Auditing
1. Tracing Calculations
2. Monitoring Effects of Changes
3. The Inquire Add-In
4. Themed Exercise
Unit 26 | Advanced Macros and VBA
1. Writing Code Directly - Sub Procedures
2. Writing Code Directly - User-Defined Functions
3. Structure and Worksheet Change Event
4. Interactive VBA
5. Themed Exercise
Unit 27 | Modeling
1. Principles
2. Techniques
3. Themed Exercise
+ SECTION 6 | PRESENTATION - 25 MODULES
Unit 28 | Cell Formatting
1. Basic Font Formatting
2. Alignment
3. Styles
4. Formatting Tools
5. Themed Exercise
Unit 29 | Number Formatting
1. Types of Numbers
2. Clarity and Impact
3. Custom Number Formats
4. Advanced Custom Formats
5. Number Formats and Styles
6. Themed Exercise
Unit 30 | Conditional Formatting
1. Basic Conditional Formatting
2. Graphical Conditional Formats
3. Advanced Conditional Formats
4. Themed Exercise
Unit 31 | Charts and Graphs
1. Creating Simple Charts
2. Editing Charts
3. Advanced Charts
4. Sparklines
5. Themed Exercise
Unit 32 | Page and Print Setup
1. Displaying Spreadsheets as Pages
2. Adjusting Page Setup
3. Printing Very Large Sheets of Data
4. Finally, Printing!
5. Themed Exercise
FINAL ASSESSMENT
PRE-ASSESSMENT
+ SECTION 1 | INTRODUCTION - 1 MODULE
Unit 1 | What's New in Excel 2019?
1. What's New in Office 2019?
+ SECTION 2 | EFFICIENCY AND RISK - 13 MODULES
Unit 2 | Templates
1. Introduction
2. Default Templates and Creating Modular Workbooks
3. Customized Interface
4. Exercise
Unit 3 | Increasing Efficiency and Reducing Risk
1. Introduction to Design Standards
2. Controls and Checks
3. Techniques
4. Review and Documentation
5. Exercise
Unit 4 | Data Validation
1. Data Validation Formulae
2. Data Validation With Dependent Lists
3. Data Validation Alternatives
4. Exercise
+ SECTION 3 | ADVANCED TECHNIQUES - 29 MODULES
Unit 5 | Functions With Superpowers
1. Introduction
2. MOD
3. OFFSET
4. INDIRECT
5. LOOKUP From Right to Left - CHOOSE
6. Dynamic Ranges vs Tables
7. Exercise
Unit 6 | Array Formulas
1. Array Formulae Explained
2. Alternatives to Array Formulae
3. Exercise
Unit 7 | Tables
1. Automatic Expansion
2. Table Formulae
3. Working With Data in Tables
4. Slicers in Tables
5. Table Benefits and Drawbacks
6. Exercise
Unit 8 | Advanced Range Names
1. Advanced Range Names
2. Using Names in Formulae
3. Formula in Range Names
4. Exercise
Unit 9 | WhatIf Analysis
1. Goal Seek
2. Data Tables
3. Solver Add-In
4. Scenario Manager
5. Exercise
Unit 10 | Problem Solving
1. Introduction
2. Boolean Logic and Arrays in Action
3. Using Tables
4. Exercise
+ SECTION 4 | EXCEL INTERACTIVITY - 9 MODULES
Unit 11 | Form Controls
1. Basic Form Controls
2. Advanced Controls
3. Exercise
Unit 12 | Visual Basic and Macros
1. Writing Code Directly: Sub Procedures
2. Writing Code Directly: User-Defined Functions
3. Structure and Worksheet Change Event
4. Interactive VBA
5. VBA Projects
6. Exercise
+ SECTION 5 | SPREADSHEET IMPACT - 16 MODULES
Unit 13 | Conditional Formatting
1. Conditional Format Formulae
2. Advanced Conditional Formatting
3. Creative Conditional Formatting
4. Exercise
Unit 14 | Charts That Inspire
1. What Makes a Good Chart?
2. Advanced Charts and Techniques Part 1
3. Advanced Charts and Techniques Part 2
4. Advanced Charts and Techniques Part 3
5. Exercise
Unit 15 | Sparklines
1. Sparklines
2. Advanced Uses: Dynamic References
3. Exercise
Unit 16 | Graphics Tricks and Techniques
1. Excel Camera
2. Power View
3. 3D Map
4. Exercise
+ SECTION 6 | TURNING DATA INTO DECISIONS - 21 MODULES
Unit 17 | Working With External Data
1. Introduction
2. Understanding Data Structures
3. Get & Transform: From Database to Spreadsheet
4. Data Model
5. Exercise
Unit 18 | Advanced Uses of PivotTables
1. Advanced PivotTable Techniques
2. Using PivotTables as a Management Report Engine
3. Understand Data With Slicers and Timelines
4. Working With PivotCharts
5. Building an Interactive Dashboard
6. Exercise
Unit 19 | Power Pivot
1. Introduction
2. Power Pivot Data Tools
3. Basic Data Analysis Expressions
4. Advanced Data Analysis Expressions
5. Time Intelligence Functions
6. Exercise
Unit 20 | Reporting With Power Pivot
1. Additional Features
2. Advanced Techniques
3. Creating a Dashboard
4. Exercise
FINAL ASSESSMENT
+ SECTION 1 | PIVOTTABLES - 19 MODULES
Unit 1 | Introduction and Basics
1. Uses and Benefits of PivotTables
2. Basics of PivotTables
3. Manipulating PivotTable Data
4. Exercise
Unit 2 | Filter and Group to Compare and Contrast
1. Filtering
2. Sorting and Grouping
3. Exercise
Unit 3 | Presentation – Clarity and Impact
1. Layout and Formatting
2. PivotCharts
3. Conditional Formatting in PivotTables
4. Exercise
Unit 4 | Calculations – Adding Value to Values
1. Value Field Settings
2. Calculated Fields and Values
3. Exercise
Unit 5 | Your Data Your Way – Flexible Reporting
1. Using PivotTables As Management Report Engines
2. Cube Values
3. Exercise
Unit 6 | Power to the User – Interactivity
1. Understand Data With Slicers and Timelines
2. Exercise
+ SECTION 2 | PIVOTTABLES FOR DATA ANALYSIS - 18 MODULES
Unit 7 | Dominate Your Data
1. Understanding Data Structures
2. The Power Query Add-In
Unit 8 | Power Pivot and Big Data
1. Introduction to Power Pivot
2. Power Pivot Data Tools
3. Exercise
Unit 9 | Make Your Data Work Harder
1. Basic Data Analysis Expressions (DAX) Introduction
2. Advanced Data Analysis Expressions (DAX)
3. Time Intelligence Functions
Unit 10 | From Data to Decisions
1. Introduction
2. Additional Features
3. KPIs
4. Cube Functions
5. Creating a Dashboard
6. Exercise
Unit 11 | Present Data Analysis With Impact
1. What Makes a Good Chart?
2. Advanced Charts
3. Waterfall Chart
4. Sparklines
Unit 12 | Give Me More Power
1. Power View
2. Power Map
PRE-ASSESSMENT
+ SECTION 1 | INTRODUCTION - 2 MODULES
Unit 1 | Turning Numbers Into Better Business Decisions
1. Course Introduction Video
2. Successful Business and Financial Models
+ SECTION 2 | THE BUSINESS ANALYST EXCEL TOOLBOX - 7 MODULES
Unit 2 | Essential Excel for Business Analysis
1. Range Names for Business Models
2. Focus On Results
3. Validation of Numbers and Lists
4. Matching and Ranking Data
Unit 3 | Professional Tools for Business Analysts
1. Maintaining Control of Your Worksheets
2. Testing and Simulating Models
3. Error-Free Worksheets
+ SECTION 3 | COLLECTING AND MANAGING BUSINESS DATA - 6 MODULES
Unit 4 | Professional Tools for Business Analysts
1. Importing Business Data
2. Extracting Business Data
3. Exporting Business Data
Unit 5 | Power Functions for Managing Business Data
1. Dynamic Ranges
2. Extracting Data With Logical Functions
3. Using Frequency Distributions
+ SECTION 4 | COMMUNICATING YOUR MESSAGE - 5 MODULES
Unit 6 | Your Stakeholders and Their Needs
1. Matching Stakeholders' Requirements
2. Text, Table, or Chart?
Unit 7 | Data Presentation Formats That Work
1. Effective Tables, Charts, and Presentation Media
2. Presenting Key Data Relationships
3. Graphical Text and Tables
+ SECTION 5 | WINNING CHARTS FOR BUSINESS COMMUNICATION - 7 MODULES
Unit 8 | Professional Charting
1. Charts That Work
2. Chart Styles and Templates
3. 'Conditional Format' Charts
Unit 9 | Dynamic Charts
1. Charting From Large Datasets
2. Techniques for Dynamic Charts
3. Charts That Pan and Zoom
Unit 10 | Some Special Charts for Business Analysis
1. Some Special Charts
+ SECTION 6 | LOOKING INSIDE YOUR DATA (ANALYSIS) - 7 MODULES
Unit 11 | Analyzing Data With PivotTables
1. Grouping and Cross Tabulating Data
2. Large Data Analysis With PivotTables
3. Comparisons in PivotTables
Unit 12 | Managing PivotTables Output
1. Slicers and Filters
2. PivotCharts
3. PivotTable Frequency Distributions
4. Keeping PivotTables Current
+ SECTION 7 | COMPARING BUSINESS SCENARIOS - 4 MODULES
Unit 13 | Decision-Making With Compared Scenarios
1. Single Variable Data Tables
2. Multiple Variable Data Tables
Unit 14 | The Scenario Manager
1. Selecting Scenarios
2. Scenario Manager Outputs
+ SECTION 8 | LOOKING OUTSIDE YOUR DATA (FORECASTING) - 5 MODULES
Unit 15 | Time Series and Forecasting
1. Curve Fitting and Trendlines
2. Linear Forecasting
Unit 16 | Working With Moving Averages
1. Smoothing Data
2. Seasonal Factors
Unit 17 | Introduction to Regression
1. Introduction to Regression
+ SECTION 9 | ENDING - 1 MODULE
Unit 18 | Ending
1. End of Course Video
FINAL ASSESSMENT
+ About the Authors
Deborah Ashby specialises in Microsoft Office training courses and content creation. Deborah has been an IT Trainer for almost fifteen years and has worked at Microsoft, training its employees in its own software. Deborah is a Microsoft Office Specialist (MOS) and Microsoft Certified Trainer (MCT), and she is TAP certified.
Simon Hurst is a Chartered Accountant and has been involved in computer software for 26 years during which he has provided a wide range of training services to professionals of all levels. His expertise lies in all the main Microsoft applications and he's been running hands-on Excel training courses for over 20 years, dealing with all aspects of Excel from basic competence to advanced data analysis.
Featured Reviews - ⭐⭐⭐⭐⭐
I truly recommend this business - M. Bhogaita
[EwB] offers a great range of packages so you can pick the one that suits your own needs, and learn at a pace that suits you … I truly recommend this business, it’s effectively helping you improve your skillset.
Great way to learn something new. - C. Neelson
Great way to learn something new. Very easy to use and you just keep learning at your own pace.
Enter Your Voucher Code Here
Note: We ask for your billing address for our tax records only. We do not ask for card details for pre-paid items.