Course details

Microsoft Excel is by far the most widely used and useful software there is! It is the most basic tool that is used when dealing with data - data in any format.

This simple yet sophisticated tool has a use for everyone, from keeping a simple tab your daily expenses, to analyzing and presenting a complex profit and loss statement, from keeping a tab on attendance of students to analyzing and presenting data on world hunger!

Excel when used intelligently makes for one of the most powerful yet simple reporting engine. Such is the power of Excel. But despite this, Microsoft Excel in most cases is not used to its full potential even though it one of the most easiest skill to pick up.

With this course, aimed at beginners, intermediate and Expert users we begin by introducing the basic functionality of this software and then work upwards, along the way covering very simple tips that will profoundly increase your speed and efficiency while using Excel.

At a high level the course is structured in the below format.

- Data Cleaning

- Data Processing

- Data Summarizing (As A Template)

- Data Presentation (As A Dashboard)

- Automation of the above process using VBA Macros

The course comprises of videos, key points /summary of each video is available as downloadable material. We suggest that you give a quick run through the downloadable material before you begin watching any video. This is will allow you to understand what it is that you will be learning in the attached video. The short videos take you through each concept step-by-step and allow you to practice while studying.

This course as indicated is one for those just beginning with Excel and for those who need to master their Excel skills.

Updated on 22 March, 2018
Courses you can instantly connect with... Do an online course on Microsoft Excel starting now. See all courses