Microsoft Excel - from Beginner to Advanced & VBA by IITian
3.6 (93 ratings)
Course Ratings are calculated from individual students’ ratings and a variety of other signals, like age of rating and reliability, to ensure that they reflect course quality fairly and accurately.
6,987 students enrolled

Microsoft Excel - from Beginner to Advanced & VBA by IITian

Master Excel 2016, 2013 and 2010 - Formulas, Functions, Charts, LOOKUP, Pivot Table, What-If Analysis, Macros & VBA
3.6 (93 ratings)
Course Ratings are calculated from individual students’ ratings and a variety of other signals, like age of rating and reliability, to ensure that they reflect course quality fairly and accurately.
6,987 students enrolled
Created by Vishal Srivastava
Last updated 8/2019
English
English [Auto]
Price: $19.99
30-Day Money-Back Guarantee
This course includes
  • 6.5 hours on-demand video
  • 27 downloadable resources
  • Full lifetime access
  • Access on mobile and TV
  • Assignments
  • Certificate of Completion
Training 5 or more people?

Get your team access to 4,000+ top Udemy courses anytime, anywhere.

Try Udemy for Business
What you'll learn
  • 95 Lectures and 15 Assignments
  • 6.5 Hours of Video. 27 Downloads
  • Text, Date, Logical, Math, Financial, Statistical Functions
  • Pivot Table, LookUp, INDEX, MATCH and SEARCH
  • Automation with Macros and VBA
  • Charts, Trendlines, 3D Map and Drawing Tools
  • BONUS - Excel Shortcuts and Function Keys
  • BONUS - Free Excel 2016 eBook worth $4.99
  • Practical Learning with Case Studies
  • All Data files, Assignments and Solutions
  • Microsoft Excel 2016 - Beginner to Advanced Course
Requirements
  • If you know how to use a computer, you can learn Excel 2016
Description

ONLY $11.99 or Rs.500 Today. Sign Up Before It Goes Back to $19.99 / Rs.1,280 Tomorrow.


***This Microsoft Excel course includes 95 Lectures, 15 Assignments (with Solutions), Excel eBook worth $4.99, Data files, Instructor feedback on assignments, Lifetime course access and 100% money-back guarantee form Udemy***

***This Microsoft Excel course is recorded in Indian Voice.***

Microsoft Excel - Excel from Beginner to Advanced & VBA is the most comprehensive Excel course on Udemy.

It comes with full set of course book, data files for exercises, case studies and solutions. This is the Microsoft Excel Bible that includes everything you need to know to become an Excel expert. 

The course is recorded with Microsoft Excel 2016. I point out important differences from Excel 2013 whereever applicable.  Whether you use Excel 2016 or Excel 2013, this course is all you need. In fact, most features should work in Excel 2010 as well.

You will learn everything you need to learn in Microsoft Excel, from basics to advanced features like Pivot Table, Charts, Sparklines, Macros,  Workbook Management and VBA.

A unique feature of this course is the use of exercises and case studies to illustrate how to use Excel formulas, functions and features.   

With this Microsoft Excel course, your Excel skills will go from starter to expert in just a few hours. Whether you want to learn Excel for business, work, or College, this is the right course for you.   

This Microsoft Excel course has been used by thousands of people. It is licensed to multiple colleges, businesses and professional education companies in India, Malaysia and Dubai.    

You will master the following Microsoft Excel features in this course:

  • Excel User Interface

  • Workbook and Worksheets

  • Excel Tables

  • Data Management

  • Excel Formulas & Functions – Date, Financial, Information, Mathematical & Statistical and Text

  • Inserting and Formatting Objects

  • Lookup and Reference Functions

  • Charts, 3D Map and Sparklines

  • Pivot Table

  • What If Analysis, Data Analysis and Validation

  • Printing Excel Files

  • Macros

  • Managing Excel Files

  • Advanced VBA

BONUS CONTENT:

  • PDF with most common Excel 2016 keyboard shortcuts

  • Excel eBook worth $4.99

If you are from the following countries, you will especially love the Charts and Graphs section. I use Sachin Tendulkar's career stats to show you how to use different types of charts to analyze data.

  • India

  • England

  • Ausrtalia

  • SriLanka

  • South Africa

  • Pakistan

  • Bangladesh

  • New Zealand

  • West Indian Island Countries

Enroll now and start mastering Microsoft Excel. Go from an Excel Novice to Excel Expert in just a few hours!

Videos are recorded in Indian voice so people from India and other Asian countries can also follow it easily.


Who this course is for:
  • Sales, Marketing, Accounting, Finance and Other Professionals
  • Entrepreneurs and Business Owners
  • College Students
Course content
Expand all 95 lectures 06:27:00
+ Introduction to Excel 2016
3 lectures 14:26

In this lecture, you will learn different ways of starting Excel 2016.

Preview 02:11

Learn how to use the User Interface to perform tasks in Excel 2016

Preview 08:05

In this lecture, you will learn how to use the backstage view

The Excel 2016 Backstage View
04:10
+ Working with Workbook and Worksheets
5 lectures 16:36

Learn about how the structure of Excel files - Workbooks and Worksheets.

Please download the Excel Course book and Data files you will need throughout this course.

Workbooks and Worksheets
02:46

Learn how to edit Excel Worksheets

Editing Worksheets
04:33

Learn how to enter data in your Excel Worksheet

Entering Data
03:13

Learn how to Name a Cell Range in Excel and how to use it in Formulas

Naming Cell Range
02:28

Learn how to manage your Worksheets in Excel 2016

Handling Worksheets
03:36
This is a hands-on assignment for topics covered in this section
Assignments for the section
1 question
+ Introduction to Microsoft Excel Tables, Formulas and References
5 lectures 16:37

Learn about Tables in Excel 2016 and how to use them

Introduction to Tables in Excel 2016
03:14

Introduction to Functions in Excel 2016

Excel 2016 Functions
04:49

How Operators work in Excel 2016

Operators in Excel 2016
01:50

Learn how Excel 2016 uses relative and absolute referencing to when using data in another cell or worksheet.

Cell Referencing in Microsoft Excel 2016
03:55

Transposing feature in Excel 2016 allows you to convert a row into column after you have already set up the worksheet and entered data.

Using Paste Preview to Transpose Rows into Columns
02:49
This is the practice assignment for section 3. It covers everything you learned in this section.
Assignment for Section 3
1 question
+ Formatting Data in Excel 2016
4 lectures 18:22
Formatting Data in Excel 2016 - 1
04:48

In this lecture, you will learn advanced data formatting techniques in Excel 2016

Formatting Data in Excel 2016 - 2
03:19

In this lecture, you will learn how to format numbers in Excel 2016

Formatting Numbers in Excel 2016
06:08

In this lecture, you will learn how to rotate text and some other formatting techniques in Excel 2016

Text Rotation and Other Formatting Techniques
04:07
This is the practice assignment for section 4. It covers everything you learned in this section.
Practice assignment for section 4
1 question
+ Managing Your Data in Excel 2016
5 lectures 18:48
Using Named Ranges and Sorting Data in Excel 2016
04:57
Filtering Data in Excel 2016 Worksheet
03:12
Using Comments to explain your data in Excel 2016
02:24
Finding and Replacing Data in your Worksheet
03:14

You can use change tracking to record details about changes to your workbook. It helps in identifying changes made to text and data in the workbook. You can review the changes made and accept or reject them.

Tracking Changes to Your Worksheet in Excel 2016
05:01
This is the practice assignment for section 5. It covers everything you learned in this section.
Practice assignment for section 5
1 question
+ Formulas in Excel
14 lectures 01:03:58

Text fields contain non-numeric data. They are generally used as label but can also contain data like Name of months or day of the week. Excel has special functions for use with Text fields.

Text Formulas in Excel
01:44

In this lecture you will learn the solution to the Text Formulas case study introduced in the previous lecture.

Preview 08:16

In this lecture, you will learn about the most useful Date & Time formulas and how to use them

Date and Time Formulas in Excel 2016
01:24

In this lecture you will learn the solution to the Date and Time Formulas case study introduced in the previous lecture.

Date and Time Formulas in Excel 2016 - Case Study Solution
03:48

In this lecture, you will learn about the most useful Logical formulas in Excel and how to use them.

Logical Formulas in Excel 2016
01:49

In this lecture, you will learn the solution to the Logical Formulas case study introduced in the previous lecture.

Solution to Logical Formulas Case Study
05:16

In this lecture, you will learn most useful Information formulas in Excel 2016 and how to use them.

Information Formulas in Excel 2016 - Case Study
00:43

In this lecture, you will learn about Information formulas case study solution.

Information Formulas Case Study - Solution
06:10

In this chapter, you will learn about the most useful Mathematical formulas and how to use them.

Mathematical Formulas Case Study
02:28

In this lecture, you will learn how to solve the Mathematical formulas case study

Mathematical Formulas Case Study - Solution
12:26

In this chapter, you will learn about the most useful Statistical formulas and how to use them.

Statistical Formulas Case Study
01:47

In this lecture, you will learn about the solution to the Statistical formulas case study

Statistical Formulas Case Study - Solution
09:47

In this chapter, you will learn about the most useful Financial formulas and how to use them.

Financial Formulas Case Study
02:57

In this lecture, you will learn about the solution to the Financial formulas case study

Financial Formulas Case Study - Solution
05:23
This is the practice assignment for section 6. It covers everything you learned in this section.
Practice Assignment for Section 6
1 question
+ Inserting and Formatting Objects Some
2 lectures 05:58

This is a case study about using Shapes, Images, SmartArt, Graphics, Objects, Hyperlinks, Symbols and Equations.

Inserting Objects Case Study
01:03

In this lecture, you learn how to solve the case study introduced in the previous lecture.

Inserting Objects Case Study - Solution
04:55
This is the practice assignment for section 7. It covers everything you learned in this section.
Practice Assignment for Section 7
1 question
+ Lookup and Reference Functions
5 lectures 23:50

In this lecture you will learn how to use VLOOKUP AND HLOOKUP functions.

LOOKUP Functions
06:07

In this lecture, you will learn how to use the Transpose function.

Transpose Function
02:53

In this lecture, you will learn how to compare two lists of data in Excel 2016

Comparing Lists
05:21

This is a case study about using Lookup and Reference formulas in Excel 2016

Lookup and Reference Formulas Case Study
01:25

Learn how to solve the Lookup and Reference Formulas Case Study

Lookup and Reference Formulas Case Study - Solution
08:04
This is the practice assignment for section 8. It covers everything you learned in this section.
Assignment for Section 8
1 question
+ Advanced Excel Tables
3 lectures 11:59

This is a case study on how to use Excel Tables

Excel Tables Case Study
01:00

Solution to Excel Tables Case Study

Excel Table Case Study - Solution
09:06

In this lecture, you will learn how to print an Excel table

Preview 01:53
This is the practice assignment for section 9. It covers everything you learned in this section.
Assignment for Section 9
1 question
+ Using Charts in Excel 2016
4 lectures 23:28

This is a case study on how to use Charts in Excel 2016

Charts Case Study
02:00

In this lecture, you will learn how to use Column, Bar, Pie, Histogram and Treemaps in Excel 2016 with the help of the case study.

Column, Bar, Pie, Histogram and Treemaps - Solution
10:53

In this lecture, you will learn how to use Line charts and Sparklines in Excel with the help of the case study.

Line Charts and Sparklines - Solution
04:30

In this lecture, you will learn how to use 3D Maps in Excel with the help of the case study.

Preview 06:05
This is the practice assignment for section 10. It covers everything you learned in this section.
Assignment for Section 10
1 question