The data analysis with MS Excel is for technical officers and managers and is targeted at helping them make informed decisions based on insights from analytics. From beginner to advanced, the course offers practical skills designed also to enhance productivity through efficient data management. The following is an outline of the key study areas:
Introduction to Spreadsheets and functionality features.
The introductory part delves into Spreadsheets, types, Worksheets, Workbooks. Formulas and Functions are outlined by their types – Logical Functions, Loops, Math Functions, Statistical Functions, Array Formulas, Lookup Functions, Text Functions as well as Date and Time Functions.
Charting and visualizations.
Learners are taken through the various chart types supported by MS Excel from introduction to advanced. Emphasis on data preprocessing is emphasized to ensure the achievement of the five data quality dimensions. Column charts, line charts, area charts, bar charts, and scatter plots are explored. Best principles of visualizations including the need to capture sufficient detail and the need for simplicity will be observed.
Advanced data analysis with Excel
In this module, we further explore advanced data analysis including through the use of ad-ins in Excel. Adins to MS Excel such as the Analysis tool pack, the Solver ad in for performing what if/Goal seek analysis. Introduction to and practical applications of Macros and VBA (Including user defined functions as ad-ins) will be undertaken under the course.
PIVOT Tables and Power Query
An introduction to Pivot Tables is given including for analysis, summarizing, and visualizing large sets of data with ease. Practical examples tracking sales figures, analyzing trends, and creating reports will be undertaken with Pivot Tables under the “turning raw data into meaningful insights” principle. An outline and practical applications of Power Query, a data transformation and data preparation engine will be undertaken.