Power Business Intelligence without Coding
Diploma in Data Analytics
Course Overview
“Excel is the only business software that ever worked!”
It is a fact that over the next two years 76% of companies are planning to increase their investment in data analytics. Data analytics is the science of analysing raw data in order to draw conclusions about that information and being able to analyse that data is a powerful skill that will help you make better informed decisions.
Learn Microsoft Excel in our Diploma in Data Analytic. Excel is one of the best tools for data analysis and indeed it’s built-in pivot tables are arguably the most popular analytic tool.
In this Diploma in Data Analytics you will learn how to:
- Filter, Sort and Format Data
- Apply the IF, nested IF, VLOOKUP and the HLOOKUP functions of Excel
- Visually represent Data using a Pivot Table
- Use Pivot Tables and Pivot Charts to Create a Dashboard
- Use Calculated Fields within Pivot Tables to Calculate Profitability and find any Abnormalities
- Use Formulas to Aggregate the Data as an Alternative to Pivot Tables for more Flexible Reports
*This course is intended for anyone who wants to take the data analysis technologies in Excel beyond formulas and add more advanced capabilities such as dashboards, hierarchies, and relationships.
Requirements
A basic understanding of Microsoft Excel
