Power BI
Microsoft’s latest business intelligence (BI) & data visualization tool enables you to quickly develop stunning interactive dashboards.
Embed Excel charts, tables, Pivot Tables and dashboards in your Power BI dashboards, then securely share your dashboards to any device.
Excel Dashboards
Dashboards provide insight, analysis and alerts by displaying key trends, comparisons and data in interactive reports.
The reader can filter data and change views to find answers to their questions and problems.
Power Pivot and DAX
Import millions of rows of data, create relationships between different data sources, and build interactive reports.
Quickly transform huge volumes of data into meaningful information to get the answers you need.
Power Query
Get data from almost any source (a database, the web, Excel, Sharepoint, Salesforce, OData etc), then clean, transform, merge and append data to your query.
Load the data into Excel or Power Pivot for analysis, report preparation or export.
Pivot Tables : Quick Start
This short course will quickly have you building your own PivotTables with confidence.
Start with the ideal data layout for creating Pivot Tables.
Then move on to formatting, aggregation, pivot charts, filters, slicers and much more.
Advanced Excel Formulas
Don't learn Excel formulas by trial and error. This course teaches you functions that are going to give you the biggest efficiency gains at work.
Covering the fundamentals for each function, and less obvious uses for them. It's these more advanced techniques that will really set you apart from the crowd.
Excel Expert
Designed to take you from zero to hero so you can confidently list 'Advanced Excel Skills' on your resume/CV.
Starting with the essentials, then covering must-know skills like best workbook design, advanced formulas, pivot tables, conditional formatting, macros and much more.
Excel Tables
Learn everything you need to work with Tables in less than 1 hour.
Make huge efficiency gains by using dynamic named ranges to automatically update formulas, Pivot Tables and charts.
Automate formatting like banded rows or columns; sorting and filtering; and totals and statistics
Financial Modelling
Everyone involved in the business decision making process should understand the Income Statement, Balance Sheet and Cash Flow Statement.
Only by understanding core concepts can you avoid common mistakes when working with these three statements.
Excel Pivot Tables
Learning to use Pivot Tables will allow you to quickly summarise and analyse large amounts of data - with just a few clicks of your mouse.
Quickly transform data into meaningful information and create reports that are easy to update and change.
Excel, Word & PowerPoint
Choose just one of these, or choose any combination of the three.
Learn the core software tools any professional needs in a modern office environment.
Excel for
Customer Service
Designed for professionals working in customer service or call center environments. Efficiently and accurately collect and analyze data. Create forecasts and generate clear, meaningful charts and reports.
Boost your skills in handling customer service and call center information.
Excel VBA & Macros
Learn Excel VBA to automate Excel and and save hours of time even if you have zero prior experience with programming.
Discover the PROVEN Blueprint for Transforming your Excel skills, Supercharging your Productivity, and Standing out in your Career.
Office Scripts
Unlock the power of automation in Excel 365 without any prior programming knowledge.
Whether you're using Windows, Mac, or Excel Online, boost your productivity, automate Excel, and run tasks while you sleep!