Learn Microsoft Excel Quickly

This course that will show you how to get the best out of Excel that you can complete in under 7 hours!

Buy our complete Excel 2019 course for ₹499 which comes with an accredited certificate.

Original Price: ₹4999, save 90% now!

What You'll Learn in this Course

Skill Level: Beginner to Advanced

Language: English and Hindi (both are provided)

Lessons: 104

Videos: 6 hours and 44 minutes

Certificate: Get a certificate of completion signed by Microsoft Certified Trainer that can be displayed on LinkedIn

Versions: The course is created in Excel 2019 (365) but works in Excel 2016, 2013, 2010, and 2007

Course Modules

MODULE 1

1.1 Introduction
1.2 Excel Templates

MODULE 2

2.1 Overview
2.2 Knowing the Worksheet
2.3 Recap of file format of excel

MODULE 3

3.1 Understanding Basic Formulas
3.2 Filling Date Range 1
3.3 Basic Functions
3.4 Filling Data Range 2
3.5 Recap of Filling Data

MODULE 4

4.1 Basic Function of IF
4.2 Recap of Basic Functions
4.3 Introduction to SumIF and SumIFS
4.4 Understanding SumIF and SumIFS
4.5 IF Error
4.6 Formatting Data

MODULE 5

5.1 Introduction to Conditional Formatting
5.2 Understanding Conditional Formatting
5.3 Recap of Conditional Formatting
5.4 Introduction to Consolidate Function
5.5 Understanding Consolidate Function
5.6 Recap of Consolidate Function

MODULE 6

6.1 Introduction to Sentence Case
6.2 Understanding Sentence Case
6.3 Recap of Sentence Case

MODULE 7

7.1 Introduction to Concatenate
7.2 Understanding Concatenate
7.3 Recap of Concatenate
7.4 Introduction to Data Validation
7.5 Understanding Data Validation
7.6 Recap of Data Validation

MODULE 8

8.1 Introduction to Flash Fill and Text to Column
8.2 Understanding Flash Fill
8.3 Understanding Text to Column
8.4 Recap of Flash Fill
8.5 Recap of Text to Column
8.6 Sorting and Filtering
8.7 Freeze Panes

MODULE 9

9.1 Introduction to Lookup Values
9.2 Understanding Lookup Values
9.3 Recap of Lookup Values
9.4 Introduction to Nested Lookups
9.5 Introduction to Pivot Table
9.6 Understanding Pivot Table
9.7 Recap of Pivot Table

MODULE 10

10.1 Introduction to Excel Charts
10.2 Understanding Excel Charts
10.3 Charts 2
10.4 Chart Colouring
10.5 Data Charts
10.6 Types of Charts
10.7 Recap of Excel Charts
10.8 Excel Data Security
10.9.1 Introduction to If Function
10.9.2 Understanding If Function 10.9.3 Understanding If Function 2
10.9.4 Understanding If Function 3
10.9.5 Recap of IF function

MODULE 11

11.1 Introduction to Date and Time
11.2 Base Text Solving
11.3 Base Date and Time-Solving

11.4 Advanced Date and Time-Solving Method

11.5 Recap of Date and Time

MODULE 12

12.1 Introduction to Macros and VBA
12.2 Understanding Developer
12.3 Tool and Code
12.4 VBA Colour Code
12.5 Creating a code in VBA
12.6 Macro – Font, Align, Insert and Delete
12.7 Save and Close
12.8 If Project
12.9 Recap of Macros and VBA

Original Price: ₹4999, save 90% now!

Whether you are a complete beginner or even at an intermediate level, this course will rapidly build your skills and confidence and have you doing your work in Excel very quickly and productively.

You can go through the course with the confidence that it’s taught by a highly experienced professional from the UK who has used Excel for over 15 years.

When you sign up, you get immediate access to the course. You can log into the lessons any time and there is no hurry to start as you have LIFETIME access!

Original Price: ₹4999, save 90% now!

What our Students say

“I have thoroughly enjoyed this course, as well as all the courses in the Specialization. It has given me the confidence to tackle advanced problems The instructor does an excellent job of breaking down each subject in an easy-to-understand logical progression.”

PARAS BHAMBHANI

“ This was one of the best courses I have ever taken in my experience as a student I really appreciate the effort your team had put on this”

RIYA MEHTA

“ I enjoyed this course so much. I learned a lot about how I can become a better learner. This course was very interesting and useful. I have some tools that I can use to optimize my learning potential.”

KASHISH SHAH

Live Reviews

Some of the Companies Our Students Work At

Frequently Asked Questions

How do you deliver your courses?

Once you have signed up then we will send you an email with a link to access our training dashboard, you can access all of our courses from this dashboard. All courses consist of video lessons that can be viewed on your device of choice and also to truly enhance your learning you will access lots of exercise files relevant to the lessons.

There are many options these days to learn, why go with your courses?

Great question, well frankly we make the best courses because all of our trainers have spent 10+ years using these skills in the real world! True knowledge is passed on from people who have been in the trenches, putting in long hours, solving real problems creatively. Our mission is to empower you with the very best of what works and more importantly, leave out what is unnecessary and thus a waste of your precious time.

I made the payment but didn’t receive any email

Please write to us at [email protected] and our support team will get back to you as soon as possible.

I have bought the course where should i login?

If you have bought the course please go to the My Courses page and login with details received on email

Buy the complete Excel 2019 course for only ₹499.

Original Price: ₹4999, save 90% now!