Let's Excel With Microsoft Excel
Learn & Understand Microsoft Excel Tool starting from Fundamental Level to the Most Advanced Level.
Office Productivity,Microsoft,Excel
Lectures -36
Duration -2.5 hours
Lifetime Access
Lifetime Access
30-days Money-Back Guarantee
Get your team access to 10000+ top Tutorials Point courses anytime, anywhere.
Course Description
'Let's Excel with Microsoft Excel' course would take you through 6 levels:
- 1. Introduction to Microsoft Excel
- 2. Basic data entry & understanding of most-frequently used shortcut keys along-with the reference file of all shortcut keys available in Microsoft Excel
- 3. Understanding of most-frequently used formulae in Microsoft Excel with the help of practical examples along-with reference file for future reference.
- 4. Pivot tables & charts with the help of practical examples along-with reference file for future reference.
- 5. Understanding of functionality of every button given under each main function of the Microsoft Excel's Ribbon with the use of practical example along-with reference file for future reference.
- 6. Understanding of advanced functionalities available in Microsoft Excel such as Advanced Formulae, What-if Analysis, Power Pivot, Power Query, Etc.
Why should you specifically take this course?
This course would particularly help you in gaining confidence while working on Microsoft Excel because of the following reasons:
- The course starts with the discussion of most basic items such as key terminologies used in Microsoft Excel and goes upto the advanced level of using power pivot, power query, Etc.
- The course includes an understanding of the functionality of every button available in Microsoft Excel's Ribbon with the help of a practical example
- Microsoft Excel & PPT files have been attached with the lectures for better understanding as well as future reference.
- The lectures have been sequentially designed so as to understand all the items in a structured manner.
- The lectures have been divided into 35 video lectures with an average duration of 4 mins each for ease of learning & reference.
- Lifetime Access to the course once you are enrolled.
- A Verifiable Certificate of Completion is presented to all enrollers who undertake this MS Excel course.
After the completion of this course, you will learn & understand the utility of Microsoft Excel and would be confident while using it in your professional as well as personal lives.
Should you take this course if you are a beginner or not a beginner?
Yes.
The course starts with the understanding of the most basic items, such as key terminologies used in Microsoft Excel, however, it also goes up to the advanced level, such as understanding of what-if analysis, power pivot, power query, Etc.
Also, this course includes an understanding of the functionality of every button available in Microsoft Excel's Ribbon with the help of practical examples. A lot of these functionalities are not known to people who have been using Microsoft Excel for a long period of time, and these functionalities would help you increase your efficiency and effectiveness.
What you'll be able to learn?
By the end of this course, you'll be confident in showcasing your Microsoft Excel skills in your personal as well as professional lives, allowing you to:
- Understand the utility of Microsoft Excel in personal as well as professional lives.
- Input, analyze & manage data to make informed decisions.
- Use Microsoft Excel hacks to perform your work faster and with more efficiency.
- Create interactive & communicative reports by using Pivot Tables, Charts, Power Pivot, Power Query Etc.
- Be comfortable with the use of frequently-used shortcut keys, and formulae, along with some advanced formulae.
- Automate your day-to-day Microsoft Excel tasks by mastering the power of Macros.
Now, if you would like to understand the overall layout and feel of the course, I would request you to go through the preview video of the course.
However, before that, I assure you that this course would be a fun and learning experience for you and it would transform the way you work with numbers.
Enroll for this course to experience yourself how such a vast and detailed tool like Microsoft Excel can be understood along with practical examples with the help of 35 video-lectures with an average duration of 4 mins each.
Thank you!
Goals
- Learn & understand Microsoft Excel starting from Foundations to Most Advanced Functionalities such as Advanced Formulae, Power Pivot, Power Query, Etc.
- Learn about the functionality of each button given in Microsoft Excel's Ribbon with the use of practical examples.
- Learn & master frequently-used shortcut keys and formulae to accelerate your efficiency & career.
- Learn to create interactive & communicative reports with the help of Pivot Tables, Charts, Slicers, Power Pivot, Power Query, Etc.
- Learn to use several functionalities available under Power Query to enhance efficiency & perform work faster.
Prerequisites
- No Prior Excel Knowledge Required.
- You will need a computer or laptop with Windows, with any version of Excel installed in it, to follow along with the Instructor (some techniques might not work on Mac).
- Willingness to learn, understand and build & enhance confidence while using Microsoft Excel.

Curriculum
Check out the detailed breakdown of what’s inside the course
Introduction to Microsoft Excel
4 Lectures
-
Preview Video - Let's Excel With Microsoft Excel 02:48 02:48
-
Introduction to Microsoft Excel 03:16 03:16
-
Key Terminologies Used in the Microsoft Excel 04:48 04:48
-
Main Functions of the Microsoft Excel's Ribbon 02:41 02:41
Data Entry and Most Frequently Used Shortcut Keys
2 Lectures

Most Frequently Used Formulae
4 Lectures

Pivot Tables & Charts
3 Lectures

Special Functionalities Available in the Microsoft Excel
10 Lectures

Advanced Functionalities available in Microsoft Excel
12 Lectures

Course Wrap Up & Next Steps
1 Lectures

Instructor Details

Supreet Agrawal
Supreet is a Chartered Accountant by profession and is an EY & KPMG Alumni. While working at Ernst & Young (EY), he has been awarded EY I AM EXCEPTIONAL AWARD which aims to celebrate people who live and create 'the exceptional experience' for themselves and for their colleagues. He has extensively used Microsoft Excel while working at Big 4s, as a result of which, he has developed a keen interest and expertise towards Microsoft Excel. He is passionate and enthusiastic about public speaking and aims to provide financial education to people all over the world.
Teaching Philosophy:
Supreet believes in teaching with the use of examples and providing reference files for ease of reference later.
He strongly believes that understanding of the process with a curious mind is much more important & useful than knowing all of it beforehand.
In His Spare Time:
When Supreet is not busy with studies or work, you'll find him watching movies, reading self-help books or exploring new places.
Course Certificate
Use your certificate to make a career change or to advance in your current career.

Our students work
with the Best


































Related Video Courses
View MoreAnnual Membership
Become a valued member of Tutorials Point and enjoy unlimited access to our vast library of top-rated Video Courses
Subscribe now
Online Certifications
Master prominent technologies at full length and become a valued certified professional.
Explore Now