Create Microsoft Excel from complete beginner to Pro
4.2 (80 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.
11,563 students enrolled

Create Microsoft Excel from complete beginner to Pro

Get yourself equipped with knowledge in Excel and master your analytical skills.
4.2 (80 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.
11,563 students enrolled
Last updated 6/2020
English
English [Auto]
Current price: $17.99 Original price: $29.99 Discount: 40% off
3 days left at this price!
30-Day Money-Back Guarantee
This course includes
  • 3.5 hours on-demand video
  • 4 downloadable resources
  • Full lifetime access
  • Access on mobile and TV
  • 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
  • Microsoft excel beginner guide
  • Basic analytics
  • Data Validation, Pivot table, Vlookup
Requirements
  • Basic computer knowledge
Description

Get yourself equipped with knowledge in Excel.


What you will become after going through this course:

  • Master Microsoft Excel from Beginner to Advanced

  • Build a solid understanding on the Basics of Microsoft Excel

  • Learn the most common Excel functions used in the Office

  • Harness the full power of Microsoft Excel by automating your day to day tasks through Macros and VBA

  • Maintain large sets of Excel data in a list or table

  • Create dynamic reports by mastering one of the most popular tools, PivotTables, Data validation

  • Wow your boss by unlocking dynamic formulas with IF, VLOOKUP, INDEX, MATCH functions and many more

  • Access to a Professional Trainer with 10+ years of Excel Training- @chandrucric9@gmail.com


This course will provide learning in the below mentioned topics

  1. Basics in Excel

  2. Graphical representation in Excel

  3. Analytics in Excel.

  4. Data validation, Advanced Pivot tables, Advanced lookup operations.

Advanced excel topics will be provided as part my advanced course.

Basics covers all the topics related to introduction, What are the options available in excel

Graphical representation covers Graphs, Tables and other presentation materials

Analytics in Excel covers all the formulas and validation that can be performed in excel.

Who this course is for:
  • College students and office goers
  • Newbies willing to learn excel
Course content
Expand all 38 lectures 03:23:55
+ Introduction
10 lectures 01:07:25

This section will provide what is covered in the excel. This will help everyone understand how to start working in excel.

Preview 08:01

How to edit and enter the content in excel?

Preview 09:48
Names and Ranges
08:54
Cell formatting and copy and paste
09:04
Searching and commenting
05:39

This lecture will provide knowledge on essential operations in excel

Essential operation in excel
04:53

How tables works in excel.

Working with tables
04:42
Fonts in Excel
08:08
Styles and Themes
05:26
File recovery and protection of Excel
02:50
+ Formulas and functions in Excel
5 lectures 33:07
Formulas and functions in Excel- Introduction
04:45
Working with formulas and function
04:26
Frequently used functions and formulas
06:09
Frequently used formulas in Excel - Part2
13:49
Working with dates in excel
03:58
+ Chart and graphical representation
4 lectures 19:19
Charts - An Introduction
04:01
Conditional formatting and Sparklines
06:47
Frequently used functions and formulas
03:50
Formulas and functions in Date format
04:41
+ Lookup functional
3 lectures 24:29
Vlookup in Excel
08:13
Hlookup in Excel
05:26
Index and Match in Excel
10:50
+ Data validation in Excel
5 lectures 18:22
Data validation in Excel and creation of list in Excel
05:24
Other data validation options
03:19
Error messages in data validation
03:11
Input messages in data validation
03:58
Dynamic LOV creation using Data validation
02:30
+ Pivot tables in Excel
5 lectures 20:36
Pivot table Introduction
05:13
Pivot table modification and formatting
06:03
Styles and gathering data in Pivot table
03:31
Pivot chart
02:52
Filter in pivot table and Slicer tool in pivot
02:57
+ Power pivot
6 lectures 20:37
Powerpivot Introduction
03:06
Activation of power pivot
01:37
Customising data model in power pivot
03:42
Creating power pivot
02:09
Power pivot calculated fields
03:59
Power pivot KPI
06:04