Microsoft Excel Data Analysis Course
Gaining an in-depth understanding of how to apply Excel functions to data and cultivate numbers into insights
1-Day Course Content
- Cleansing data using functions, building tables, sort and filter, and sparklines
- Prepare and cleanse data using functions
- Build powerful tables and apply jaw dropping conditional formatting to visualize your data
- Analysing data sets by using database functions, creating sub totals and reporting with amazing charts
- Set criteria and extract information from tables using database functions
- Learn to structure and summarise your data with the sheer power of the subtotal, and then visualise your data with magnificent charts
- Analyse data using pivot tables and learn to use power view, a completely new interactive and visual way to present and analyse large sets of data.
- Pivot tables and modelling for power pivot
- Discover the magic of powerpivot
- Learn to build an unbelievably efficient data model
- Introducing relationships and DAX functions let powerpivot and the data model dazzle.