Register Now and enjoy 25% off on your first 5 courses (Published Courses & Group / Batch Classes)
This course focuses on covering all aspects of the Microsoft Excel starting from Fundamentals such as Key Terminologies used to Most Advanced Functionalities such as Power Query in just 2.5 hours.
'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 YOU SHOULD SPECIFICALLY TAKE THIS COURSE?
This course would particularly help you in gaining confidence while working on Microsoft Excel because of the following reasons:
1. 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.
2. The course includes understanding of functionality of every button available in Microsoft Excel's Ribbon with the help of practical example
3. Microsoft Excel & PPT files have been attached with the lectures for better understanding as well as future reference.
4. The lectures have been sequentially designed so as to understand all the items in a structured manner.
5. The lectures have been divided into 35 video-lectures with an average duration of 4 mins each for ease of learning & reference.
6. Lifetime Access to the course once you are enrolled.
7. 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 most basic items such as key terminologies used in Microsoft Excel, however it also goes upto the advanced level such as understanding of what-if analysis, power pivot, power query, Etc.
Also, this course includes the understanding of 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:
1. Understand utility of Microsoft Excel in personal as well as professional lives
2. Input, analyze & manage data to make informed decisions
3. Use Microsoft Excel hacks to perform your work faster and with more efficiency
4. Create interactive & communicative reports by using Pivot Tables, Charts, Power Pivot, Power Query Etc.
5. Be comfortable with use of frequently-used shortcut keys, formulae along-with some advanced formulae.
6. 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-lecturs with an average duration of 4 mins each.
Thank you!
Background & Experience:
Supreet Agrawal is a Chartered Accountant (India) with multiple years of work experience in the Assurance Division of Ernst & Young (EY) Pune, India.
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 Ernst & Young (EY) 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.
Click for more0 Rating
In this lecture, you will be introduced to the Microsoft Excel along with the importance of Microsoft Excel in your personal as well as professional life.
In this lecture, you will understand the key terminologies used in the Microsoft Excel so that you could understand the technical terminologies used in later part of the course.
In this lecture, you will be introduced to the main functions of the Microsoft Excel Ribbon i.e. File, Home, Insert, Page Layout, Formulas, Data, Review, View, Etc.
00:02:03
In this lecture, you will understand how to enter basic data and format that data using several basic options into the Microsoft Excel.
00:02:57
In this lecture, you will learn about several shortcut keys available in the Microsoft Excel which would help you to perform your tasks faster and with more efficiency.
In this lecture, you will learn about basic rules to be followed while applying any formula in the Microsoft Excel.
00:02:12
In this lecture, you will learn about some of the most frequently used formulae in the Microsoft Excel with the help of practical examples.
In this lecture, you will learn about basic rules to be followed while applying a VLOOKUP formula in the Microsoft Excel.
In this lecture, you will learn about the application of VLOOKUP formula with the help of a practical example
In this lecture, you will learn about the basics of Pivot Tables.
00:02:02
In this lecture, you will learn about the application and uses of Pivot Tables with the help of a practical example.
00:04:57
In this lecture, you will learn about converting data into several pictorial charts with the help of practical examples.
00:03:54
In this lecture, you will learn about functionality of each button given under the File tab of the Ribbon of the Microsoft Excel with the help of a practical example.
00:06:54
In this lecture, you will learn about functionality of each button given under the Home tab of the Ribbon of the Microsoft Excel with the help of a practical example.
00:06:20
In this lecture, you will learn about functionality of each button given under the Insert tab of the Ribbon of the Microsoft Excel with the help of a practical example.
In this lecture, you will learn about functionality of each button given under the Page Layout tab of the Ribbon of the Microsoft Excel with the help of a practical example.
In this lecture, you will learn about functionality of each button given under the Formulas tab of the Ribbon of the Microsoft Excel with the help of a practical example.
00:11:12
In this lecture, you will learn about functionality of some buttons given under the Data tab of the Ribbon of the Microsoft Excel with the help of a practical example. The functionality of other buttons given under the Data tab would be covered in the other lectures.
00:06:07
In this lecture, you will learn about functionality of each button given under the Review tab of the Ribbon of the Microsoft Excel with the help of a practical example.
00:07:31
In this lecture, you will learn about functionality of each button given under the View tab of the Ribbon of the Microsoft Excel with the help of a practical example.
In this lecture, you will learn about functionality of each button given under the Help tab of the Ribbon of the Microsoft Excel with the help of a practical example.
In this lecture, you will learn about several File Extensions available in the Microsoft Excel that can be used to fulfill different purposes.
In this lecture, you will learn about functionality of Consolidate button given under the Data tab of the Ribbon of the Microsoft Excel with the help of a practical example.
In this lecture, you will learn about the functionality of Relationships button and Power Pivot with the help of a practical example.
In this lecture you will learn about the functionalities of several options given under What-if Analysis button given under the Data Tab of the Ribbon of Microsoft Excel with the help of practical examples.
In this lecture, you will learn about the functionality of Forecast Sheet button and Outline section given under the Data Tab of the Ribbon of Microsoft Excel with the help of a practical example.
In this lecture, you will learn about several advanced formulae used in the Microsoft Excel such as AND, Concatenate, if, IFERROR, sumif, Index, Match, Hlookup, Left, Mid & Right, Trim along with practical examples.
In this lecture, you will learn about several readymade templates available in the Microsoft Excel.
00:04:00
In this lecture, you will learn about Text Functions given under the Power Query functionality of the Microsoft Excel.
00:02:47
In this lecture, you will learn about Date Functions given under the Power Query functionality of the Microsoft Excel.
In this lecture, you will learn about a functionality to merge tables in a single workbook given under the Power Query functionality of the Microsoft Excel.
In this lecture, you will learn about a functionality to merge queries from different workbooks given under the Power Query functionality of the Microsoft Excel.
00:04:25
In this lecture, you will learn about a special functionality given under the Power Query functionality of the Microsoft Excel which is used to calculate the working days out of the total given dates.
00:02:31
In this lecture, we will discuss the summary of the course and the next steps to be taken.
25% off Welcome to the ultimate Microsoft Office course! In this course, you'll learn everything you need to know to become proficient in Word, Excel, Power
25% off Welcome to Microsoft Excel Crash Course: Master Class for Weekend, With its latest version, this course teaches top essential concepts of an Excel e
25% off Welcome to Microsoft Excel Zero to Hero: The Complete Excel Course, With its latest version, this course teaches every essential concept of an Excel e
25% off The electronic report is a software(application) developed by Me using EXCEL VBA (Microsoft Visual Basic for Applications )to manage and issue any E
25% off VBA stands for Visual Basic for Applications an event-driven programming language from Microsoft that is now predominantly used with Microsoft office
25% off The main idea of the transparency forms appears in 90's I use it in some desktop games and some funny birthday animation cards for my family and my
25% off There's now an explosion of data and statistics that businesses and non-profits need to track, manage, analyze, and interpret. To handle this, you'd n
