Create Microsoft Excel from complete beginner to Pro
4.2 (15 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.
3,259 students enrolled

Create Microsoft Excel from complete beginner to Pro

Get yourself equipped with knowledge in Excel and master your analytical skills.
4.2 (15 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.
3,259 students enrolled
Last updated 1/2019
English
English [Auto-generated]
Current price: $11.99 Original price: $29.99 Discount: 60% off
4 days left at this price!
30-Day Money-Back Guarantee
This course includes
  • 1.5 hours on-demand video
  • Full lifetime access
  • Access on mobile and TV
  • Certificate of Completion
Training 5 or more people?

Get your team access to Udemy's top 3,000+ courses anytime, anywhere.

Try Udemy for Business
What you'll learn
  • Microsoft excel beginner guide
  • Basic analytics

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

  • 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.

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 14 lectures 01:29:51
+ Introduction
6 lectures 51:14

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

This lecture will provide knowledge on essential operations in excel

Essential operation in excel
04:53

Working with cells and ranges

Working on cells and ranges
13:48

How tables works in excel.

Working with tables
04:42
Worksheet formatting and understanding files
10:02
+ Formulas and functions in Excel
4 lectures 19:18
Formulas and functions in Excel- Introduction
04:45
Working with formulas and function
04:26
Frequently used functions and formulas
06:09
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