Name: Microsoft Excel - from Beginner to Advanced & VBA by IITian
Rating: 3.9 (106 reviews)

Udemy Business

Teach on Udemy

Turn what you know into an opportunity and reach millions around the world.

Learn More

Your cart is empty.

Keep shopping

Created byVishal Srivastava

Last updated 8/2019

English

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

Course content

22 sections • 95 lectures • 6h 27m total length

Starting Excel 20162:11
In this lecture, you will learn different ways of starting Excel 2016.
Excel 2016 user Interface8:05
Learn how to use the User Interface to perform tasks in Excel 2016
The Excel 2016 Backstage View4:10
In this lecture, you will learn how to use the backstage view

Workbooks and Worksheets2:46
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.
Editing Worksheets4:33
Learn how to edit Excel Worksheets
Entering Data3:13
Learn how to enter data in your Excel Worksheet
Naming Cell Range2:28
Learn how to Name a Cell Range in Excel and how to use it in Formulas
Handling Worksheets3:36
Learn how to manage your Worksheets in Excel 2016
Assignments for the section

Introduction to Tables in Excel 20163:14
Learn about Tables in Excel 2016 and how to use them
Excel 2016 Functions4:49
Introduction to Functions in Excel 2016
Operators in Excel 20161:50
How Operators work in Excel 2016
Cell Referencing in Microsoft Excel 20163:55
Learn how Excel 2016 uses relative and absolute referencing to when using data in another cell or worksheet.
Using Paste Preview to Transpose Rows into Columns2:49
Transposing feature in Excel 2016 allows you to convert a row into column after you have already set up the worksheet and entered data.
Assignment for Section 3

Formatting Data in Excel 2016 - 14:48
Formatting Data in Excel 2016 - 23:19
In this lecture, you will learn advanced data formatting techniques in Excel 2016
Formatting Numbers in Excel 20166:08
In this lecture, you will learn how to format numbers in Excel 2016
Text Rotation and Other Formatting Techniques4:07
In this lecture, you will learn how to rotate text and some other formatting techniques in Excel 2016
Practice assignment for section 4

Using Named Ranges and Sorting Data in Excel 20164:57
Filtering Data in Excel 2016 Worksheet3:12
Using Comments to explain your data in Excel 20162:24
Finding and Replacing Data in your Worksheet3:14
Tracking Changes to Your Worksheet in Excel 20165:01
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.
Practice assignment for section 5

Text Formulas in Excel1:44
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 Case Study Solution8:16
In this lecture you will learn the solution to the Text Formulas case study introduced in the previous lecture.
Date and Time Formulas in Excel 20161:24
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 - Case Study Solution3:48
In this lecture you will learn the solution to the Date and Time Formulas case study introduced in the previous lecture.
Logical Formulas in Excel 20161:49
In this lecture, you will learn about the most useful Logical formulas in Excel and how to use them.
Solution to Logical Formulas Case Study5:16
In this lecture, you will learn the solution to the Logical Formulas case study introduced in the previous lecture.
Information Formulas in Excel 2016 - Case Study0:43
In this lecture, you will learn most useful Information formulas in Excel 2016 and how to use them.
Information Formulas Case Study - Solution6:10
In this lecture, you will learn about Information formulas case study solution.
Mathematical Formulas Case Study2:28
In this chapter, you will learn about the most useful Mathematical formulas and how to use them.
Mathematical Formulas Case Study - Solution12:26
In this lecture, you will learn how to solve the Mathematical formulas case study
Statistical Formulas Case Study1:47
In this chapter, you will learn about the most useful Statistical formulas and how to use them.
Statistical Formulas Case Study - Solution9:47
In this lecture, you will learn about the solution to the Statistical formulas case study
Financial Formulas Case Study2:57
In this chapter, you will learn about the most useful Financial formulas and how to use them.
Financial Formulas Case Study - Solution5:23
In this lecture, you will learn about the solution to the Financial formulas case study
Practice Assignment for Section 6

LOOKUP Functions6:07
In this lecture you will learn how to use VLOOKUP AND HLOOKUP functions.
Transpose Function2:53
In this lecture, you will learn how to use the Transpose function.
Comparing Lists5:21
In this lecture, you will learn how to compare two lists of data in Excel 2016
Lookup and Reference Formulas Case Study1:25
This is a case study about using Lookup and Reference formulas in Excel 2016
Lookup and Reference Formulas Case Study - Solution8:04
Learn how to solve the Lookup and Reference Formulas Case Study
Assignment for Section 8

Charts Case Study2:00
This is a case study on how to use Charts in Excel 2016
Column, Bar, Pie, Histogram and Treemaps - Solution10:53
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.
Line Charts and Sparklines - Solution4:30
In this lecture, you will learn how to use Line charts and Sparklines in Excel with the help of the case study.
3D Maps in Excel - Solution6:05
In this lecture, you will learn how to use 3D Maps in Excel with the help of the case study.
Assignment for Section 10

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

What you'll learn

Explore related topics

Course content

Introduction to Excel 20163 lectures • 14min

Working with Workbook and Worksheets5 lectures • 17min

Introduction to Microsoft Excel Tables, Formulas and References5 lectures • 17min

Formatting Data in Excel 20164 lectures • 18min

Managing Your Data in Excel 20165 lectures • 19min

Formulas in Excel14 lectures • 1hr 4min

Inserting and Formatting Objects Some2 lectures • 6min

Lookup and Reference Functions5 lectures • 24min

Advanced Excel Tables3 lectures • 12min

Using Charts in Excel 20164 lectures • 23min

Requirements

Description

Who this course is for: