Home Specialist skills Data and Analytics Excel Data Analysis
Excel Data Analysis
-
Leverage features of Microsoft Excel to facilitate business decisions
-
Develop intelligent worksheets to quickly identify KPIs
-
Perform "What-If" analyses for developing budget and project plans
-
Summarise and analyse large amounts of data using PivotTables and Excel features
-
Automate Excel processes
Overview
Off the shelf (OTS)
This hands-on Excel data analysis training course will expand your ability to analyse large amounts of data and professionally present your results. Gain the knowledge and skills to build more sophisticated spreadsheets, perform What-If analyses, apply functions, manipulate PivotTables, and use the advanced features of Excel to make and present better business decisions.
In this excel data analysis course, you use advanced Excel techniques to build sophisticated spreadsheets. You learn to perform "What-If" analyses, leverage features and apply functions, manipulate PivotTables to analyse large amounts of data, and present your results to make better business decisions for planning and budgeting. You also learn how to automate processes and enhance worksheet models.
Â
Delivery method
Face to face
Virtual
Course duration
15 hours
Competency level
Working
Delivery method
-
Face to face
-
Virtual
Course duration
15 hours
Competency level
-
Working
Spark login – Alpha testing