Microsoft Excel – Advanced Level

Curriculum

Overview

Course Overview:

This course has been designed for the extreme excel users with the most essential advanced excel features, functions, tools, tricks, and reporting techniques so that the excel users can perform their daily and periodic excel related works professionally and can be the Excel Star in their departments and office. The participants will also learn how to map and manage the big data and get the core information within a very short time.

Course Duration: 07 Hours
Total Sections: 12
Total Resources: 98 (Video + Excel Files)

Supported Versions for Practice:

2013, 2016, 2019, office 365 and most will work in 2007 & 2010

What You’ll Learn:

How to prepare the dynamic summary report in a tabular way
Writing the complex functions in the same formula
Customizing the dynamic and static charts
Describing the data using PivotTable, PivotChart with Slicers
Wow your boss with most popular dynamic functions VLOOKUP, INDEX, MATCH and OFFSET
Data reconciliation techniques in an easy way
Business modeling and various analysis techniques
Analyzing and visualizing data using advanced conditional formatting
Access to 13+ years experienced Professional Trainer who have conducted 150+ professional training programs and educated 4000+ participants through live classroom training

Other Available Complete e-Learning Courses by the Same Trainer?

Microsoft Excel – Most Common Features of Excel for Professionals (07 Hours for basic to intermediate excel users)
Microsoft Excel – VBA & Macro (04 Hours complete VBA & Macro course for pure Excel users started from the very beginning)

Training Methodology:

Professional best quality video tutorial with workings
Bite-sized small project-based business examples
Student can download the same excel data for practice
After each session, you can take quiz participation
Bengali language with a clear easy description
One to one Excel questions and supports

Requirements:

Basic level excel knowledge
You should have an internet-connected PC, mobile or TV

Who This Course is for:

Regular excel users and want to enhance their excel productivity
Intermediate level users who want to sharpen their excel skill
Data drivers, working with the large data set
Managers engaged with reporting
Daily and periodic reporters
Anyone who wants to improve their job or career prospects in an office environment.

Notes:

After completing each lesson, you have to click on the “COMPLETE” button then go to the next lesson.
Must fill up your first name, last name then display name for your certificate.
You have to complete all quizzes with a minimum 70% correct answer & within 5 Re-take.
Complete every lesson of this course serially.
Don’t click on “FINISH COURSE” button.
If you click on the “FINISH COURSE” button then the course will be finished, you will unable to complete the next lessons or parts of this course and a Certificate will be generated.
Download the documents of this course from Lecture 1.1

Course Instructor: