This course will quickly have you building your own PivotTables with confidence.
|
|
|
|
$39Add to cart |
$79Add to cart |
Learn to use Excel Tables and save lots of time as they automate things like formatting, sorting and filtering.
They provide dynamic named ranges that automatically update in formulas, Pivot Tables and charts.
|
|
|
|
$19Add to cart |
$39Add to cart |
Get quickly up to speed with the functions that are going to give you the biggest efficiency gains.
Using real world examples to cover the fundamentals for each function as well as advanced, less obvious, uses for them.
|
|
|
|
$69Add to cart |
$138Add to cart |
Your cart is currently empty.
Add Other Courses And Get 20% Off Each One
Excel Tables
- Learn to use Excel Tables and save lots of time as they automate things like formatting, sorting and filtering.
- Online Only
$19Add to cart
$19Add to cart
- Online + Download
$39Add to cart
$39Add to cart
Course Videos : 0hr 51min- Getting started with Tables
- Sorting, Filters and Slicers
- Formulas
- Structured References and Absolute References
- Limitations and Workarounds
- Sample Excel Workbooks and Data
Advanced Excel Formulas
- Get quickly up to speed with the functions that are the heart of Excel.
- Online Only
$69Add to cart
$69Add to cart
- Online + Download
$138Add to cart
$138Add to cart
- Course Videos : 5hr 4min
- Course includes: Conditional Functions
- Lookup Functions and Formula Errors
- Text Functions, Math Functions
- Array Formulas and Dynamic Arrays
- Named Ranges, and more ...
- Practice Questions and Sample Excel Workbooks
Pivot Tables Quick Start
- This course will quickly have you building your own PivotTables with confidence.
- Online Only
$39Add to cart
$39Add to cart
- Online + Download
$79Add to cart
$79Add to cart
- Course Videos : 1hr 27min
- Learn the correct data layout, and
- Pivot Charts, Filters, Slicers and Timelines
- Formatting, Grouping and Sorting
- GETPIVOTDATA Function
- Calculated Fields and Items, and much more
- Download Sample Excel Workbooks and Data
Premium
- Master the core tools any professional needs : Excel, Word & Outlook.
- Online Only
$199Add to cart
$199Add to cart
- Online + Download
$399Add to cart
$399Add to cart
- 30+ hours of videos : Excel 2007, 2010, 2013, 2016, 2019 & O365
- 20+ hours of videos : Word 2007, 2010, 2013, 2016, 2019 & O365
- 30+ hours of videos : Outlook 2007, 2010, 2013, 2016, 2019 & O365
- Download Sample Excel Workbooks and Word Documents
- Customized Learning : Only Learn What You Need
Xtreme Pivot Tables
- Quickly summarise, analyse and transform large amounts of data into meaningful reports.
- Online Only
$149Add to cart
$149Add to cart
- Online + Download
$299Add to cart
$299Add to cart
- 9h 28m of videos
- Download Sample Excel Workbooks and Practice Data
- Real Life Case Studies
Excel Expert
- Start with the essentials then cover must-know skills to go from Zero to Hero in Excel
- Online Only
$119Add to cart
$119Add to cart
- Online + Download
$239Add to cart
$239Add to cart
- 35+ hours of videos
- Download Sample Excel Workbooks
- 102 Excel Tips & Tricks Videos
- BONUS eBook : CTRL + SHIFT + ENTER Mastering Excel Array Formulas by Mike Girvin
Financial Modelling
- This course breaks down the process of Financial Modelling into small parts that are easily digestible.
- Online Only
$298Add to cart
$298Add to cart
- Online + Download
$597Add to cart
$597Add to cart
- Course Videos : 6+ hours
- 465 Interactive Slides
- 1 financial model broken into 28 easy steps
- 25 Questions
- 30+ hands-on Excel workbooks
- Interactive Case Study
Excel for Finance
- Leverage Excel's tools for financial analysis. Ideal for accountants, executives, analysts and busines school students.
- Online Only
$19Add to cart
$19Add to cart
- Online + Download
$39Add to cart
$39Add to cart
- 1h 24m of course videos
- Time Value of Money
- What-if Analysis
- Future Value
- Amortization
- Depreciation
- Case Study
Excel for Customer Service
- Efficiently and accurately collect and analyze data in customer service or call center environments.
- Online Only
$49Add to cart
$49Add to cart
- Online + Download
$99Add to cart
$99Add to cart
- 2h 52m of course videos
- Download Workbooks & Practice Data
- Download 36 Excel Software Models
- Detailed 215 Page Reference Guide
Excel for Decision Making
- Make business decisions using Monte Carlo simulations, Decision Trees and Forecasting with the Data Analysis Toolpak
- Online Only
$49Add to cart
$49Add to cart
- Online + Download
$99Add to cart
$99Add to cart
- 2h 14m of course videos
- Download Workbooks and Practice Data
- Examine Real Business Case Studies
- Practice Exercises
Excel Analysis Toolpak
- Statistics for the non-statistician. Histograms, correlations, regression, rank & percentile, random numbers and sampling.
- Online Only
$19Add to cart
$19Add to cart
- Online + Download
$39Add to cart
$39Add to cart
- 1h 20m of course videos
- Download Workbooks and Practice Data
- Examine Real Business Case Studies
- Practice Exercises
Excel for Operations Management
- Ideal for those involved in managing the daily operations of a business.
- Online Only
$19Add to cart
$19Add to cart
- Online + Download
$39Add to cart
$39Add to cart
- Course Videos : 1hr 31m
- Calculating Breakeven
- Introduction to Excel Solver
- Assignment Problem and Shipping Optimization
- Allocating Capital Investment
- Optimizating Staff Scheduling
- Sample Excel Workbooks and Exercises
