Dashboards provide insight, analysis and alerts by displaying key trends, comparions and data in interactive reports.
The reader can filter data and change views to find answers to their questions and problems.
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.
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.
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 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 & Outlook
For the person who wants to master Excel, Word and Outlook - 3 courses in 1.
Learn the core software tools any professional needs in a modern office environment.
Use Excel's existing tools to make business decisions under uncertainty by performing Monte Carlo simulations, using Decision Trees and Forecasting with the Data Analysis Toolpak.
Ideal for executives, analysts and all levels of business school students.
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.
Leverage Excel tools for financial analysis including Time value of Money functions, What-If analysis, Goal Seek, Amortization, Depreciation, and Solver
Ideal for accountants, executives, analysts and all levels of business school students.
Excel Analysis Toolpak
Statistics for the non-statistician.
Quickly and efficiently calculate and report the statistics of data and make decisions based on statistical output.
Use the Excel Analysis Toolpak to generate descriptive statistics, histograms, correlations, regression, rank & percentile, random numbers, and sampling.