Mastering Microsoft Excel – Basics Blended with Advanced

Mastering Microsoft Excel – Basics Blended with Advanced, Microsoft Excel As A Solid Foundation for Data Analysis.

Course Description

Mastering Microsoft Excel in a unique way of combining different levels of skills. The course is a good foundation for data analysis en route to skills for Business Intelligence applications. The students will have will be guided by steps on how to accomplish a stated objective. At the end of the lecture, there will be some hands-on assignments that the student must attempt to cement the gained knowledge and skills.

The training course starts by introducing you to common functionalities of spreadsheet processing which are data sorting, data filtering, and formula auditing. Thereafter, the course presents more data analytical lessons such as pivot tables and pivot charts, an interactive Excel dashboard with slicers, and timelines for interactive data analysis.

In the end, the course brings the common Excel functions and winds up with advanced Excel functions. Where there is a video tutorial, the students are encouraged to watch and follow the steps demonstrated in the video.

Other topics have bonus tasks, that students must make sure they have attempted. In some lessons, there are some challenging tasks that are labeled as ‘Diving Deep’. Once a student is able to do and interpret ‘diving deep’ assignments then definitely the student has reached mastery level for that lesson