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
- How to use Excel
- Functions, Ranges and Shortcuts
- Printing, Formatting and Conditional Formatting
- Formulas and Functions, Lookups, Pivots, Macros & VBA
- Beginner to Advance
- Lifetime Access
- Over 7 hours of lessons
- Certificate from Microsoft Certified Trainer
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