Objective: Learn skills and techniques to simplify the process of analysing data in Microsoft Excel including process automation.

Rather than attending a full-day course that covers a range of topics that may or may not be relevant to you, Donna Hanson has put this course together to help you fast-track data analysis in Microsoft Excel in a way that is simple, easy, and, more importantly, RELEVANT to business.

So, if you are interested in learning complicated Microsoft Excel formulas that you may never use, this course is NOT for you!

If you are interested in increasing your efficiency with data analysis, then

This course :

* Explains in simple terms how Microsoft Excel needs data set up to make analysis SIMPLE
* Covers basic troubleshooting tips to ‘tidy up’ imported data to make analysis easier
* Shares simple and advanced ways to sort and filter data by more than one criteria saving time and
frustration - without using any formulas, functions or math!
* Covers a range of data analysis tools that require NO knowledge of formulas to enable reports or
summaries of data to be easily produced within minutes not hours!

Topics covered include:

* Data list set up - how knowing Microsoft Excel's rules for data set up can save you hours of wasted time and
frustration.
* Features and functions to make "tidying" up imported data fast and easy to enable you to ensure your data
is ready for analysis.
* Sort and filtering tips and features to make sorting simple, easy and fast.
* Excel tools to highlight and summarize data that meets specified criteria.
* Pivot tables and pivot charts - what they are and how to use them along with a inbuilt tools in Excel to
enable users to create simple dashboards to dynamically display pivot table data.
* How to take what you've learnt and automate data analysis.