Highlights
- Data Entry – how to get your data into Excel in the first place.
- Data Manipulation – how to arrange, format and augment your data.
- Data Interpretation – how to query your data to derive information and knowledge.
Course Details
Data Entry – how to get your data into Excel in the first place:
Starting with a guided tour of Excel to bring users up to speed with the terminology to be used throughout the course, this block then goes on to cover the various file formats that Excel can deal with and their individual capabilities. Functionality for copying, moving, hiding and displaying data on the page, and extended options for producing hard copy in the print settings are then introduced. Finally, cell referencing, auditing and validation, formulae, and functions are covered.
Data Manipulation – how to arrange, format and augment your data.
In this block of the course, various ways of manipulating the data are covered.
This includes sorting, filtering using both the autofilter and advanced filter options, conditional formatting, and pivoting to reshape the data.
It concludes with a section on macros which are a powerful way of simplifying repetitive tasks.
Data Interpretation – how to query your data to derive information and knowledge.
The final block of the course starts with a section covering the graphing functionality including ways of making the graphing process more interactive.
Also covered is the functionality included in two Excel add-ins: Analysis Toolpak for statistical analysis and Solver for iteratively solving equations.
Who should attend
Regular Excel users who:
- Feel they are not using the software to its full potential
- Think that there are tasks that Excel can help with but don’t know how
Feedback
4.8 out of 5 average
" I enjoyed the depth that we covered analytical techniques such as anomaly detection and cluster analysis, whilst improving my knowledge on DAX and KPIs."BC, Performance analyst, Data Analysis with Power BI, April 2021
Watch live client feedback from Data Analytics courses:
“JBI did a great job of customizing their syllabus to suit our business needs and also bringing our team up to speed on the current best practices - very impressive” Brian F, Team Lead, RBS, Data Analysis Course, 20 April 2022
