Tutorialspoint

April Learning Carnival is here, Use code FEST10 for an extra 10% off

Let's Excel With Microsoft Excel

person icon Supreet Agrawal

4.2

Let's Excel With Microsoft Excel

Learn & Understand Microsoft Excel Tool starting from Fundamental Level to the Most Advanced Level.

updated on icon Updated on Apr, 2024

language icon Language - English

person icon Supreet Agrawal

category icon Office Productivity,Microsoft,Excel

Lectures -36

Duration -2.5 hours

4.2

price-loader

30-days Money-Back Guarantee

Training 5 or more people ?

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 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 an understanding of the functionality of every button available in Microsoft Excel's Ribbon with the help of a 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 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:

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 the use of frequently-used shortcut keys, and 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-lectures with an average duration of 4 mins each.

Thank you!

Goals

What will you learn in this course:

  • 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

What are the prerequisites for this course?

  • 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 Instructor (some techniques might not work on Mac).
  • Willingness to learn, understand and build & enhance confidence while using Microsoft Excel.
Let's Excel With Microsoft Excel

Curriculum

Check out the detailed breakdown of what’s inside the course

Introduction to Microsoft Excel
4 Lectures
  • play icon Preview Video - Let's Excel With Microsoft Excel 02:48 02:48
  • play icon Introduction to Microsoft Excel 03:16 03:16
  • play icon Key Terminologies Used in the Microsoft Excel 04:48 04:48
  • play icon Main Functions of the Microsoft Excel's Ribbon 02:41 02:41
Data Entry and Most Frequently Used Shortcut Keys
2 Lectures
Tutorialspoint
Most Frequently Used Formulae
4 Lectures
Tutorialspoint
Pivot Tables & Charts
3 Lectures
Tutorialspoint
Special Functionalities Available in the Microsoft Excel
10 Lectures
Tutorialspoint
Advanced Functionalities available in Microsoft Excel
12 Lectures
Tutorialspoint
Course Wrap Up & Next Steps
1 Lectures
Tutorialspoint

Instructor Details

Supreet Agrawal

Supreet Agrawal

e


Course Certificate

Use your certificate to make a career change or to advance in your current career.

sample Tutorialspoint certificate

Our students work
with the Best

Related Video Courses

View More

Annual Membership

Become a valued member of Tutorials Point and enjoy unlimited access to our vast library of top-rated Video Courses

Subscribe now
Annual Membership

Online Certifications

Master prominent technologies at full length and become a valued certified professional.

Explore Now
Online Certifications

Talk to us

1800-202-0515