The Complete Excel for 2018: Zero to Mastery
4.8 (7 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.
26 students enrolled

The Complete Excel for 2018: Zero to Mastery

Learn MS Excel 2016 from Basic to Advanced and Level Up your Career
4.8 (7 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.
26 students enrolled
Created by Dennis B T
Last updated 4/2018
English
Current price: $69.99 Original price: $99.99 Discount: 30% off
5 hours left at this price!
30-Day Money-Back Guarantee
This course includes
  • 5.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 4,000+ top Udemy courses anytime, anywhere.

Try Udemy for Business
What you'll learn
  • By the end of the course, you will know everything about Excel 2016 and able to apply that knowledge in a practical manner
  • Pivot Table and Charts
  • Learn COUNTIF and VLOOKUP
  • Learning Macros
  • Filtering Data and Editing sheets
  • Creating Formulas and Functions
Requirements
  • Able to use a pc
  • MS Excel 2010/2013/2016
Description

"The Complete Excel for 2018: Zero to Mastery", is a course that contains each and everything about Excel 2016, backed with 30 day money back guarantee from Udemy. Start mastering Excel, the world's most popular and powerful spreadsheet program, with Excel expert. Learn how to enter and organize data, perform calculations with simple functions, work with multiple worksheets, format the appearance of your data and cells, and build charts and PivotTables. Other lessons cover the powerful IF, VLOOKUP, and COUNTIF functions; the Goal Seek, Solver, and other data analysis tools; and automating tasks with macros.

Who this course is for:
  • Anyone who want to become a Excel Expert
  • People want to learn Advanced Excel
Course content
Expand all 53 lectures 05:16:01
+ Getting Started
9 lectures 40:14
Lec 3
06:49
Lec 4
04:44
Lec 5
01:37
Lec 6
05:20
Lec 8
04:25
Lec 9
02:37
Lec 10
05:28
+ Entering Data
6 lectures 24:09
Lec 11
04:29
Lec 12
03:56
Lec 13
04:28
Lec 14
04:13
Lec 15
02:52
Lec 16
04:11
+ Creating Formulas and Functions
7 lectures 40:59
Lec 1
07:11
Lec 2
03:48
Lec 3
03:49
Lec 4
07:37
Lec 5
05:32
Lec 6
05:18
Lec 7
07:44
+ Formatting
9 lectures 01:02:51
Lec 1
03:17
Lec 2
05:40
Lec 3
06:34
Lec 4
02:55
Lec 5
08:01
Lec 6
07:18
Lec 7
08:13
Lec 8
11:18
Lec 9
09:35
+ Adjusting Worksheet Layout and Data
4 lectures 21:57
Lec 1
06:19
Lec 2
04:33
Lec 3
05:35
Lec 4
05:30
+ Printing
3 lectures 23:14
Lec 1
07:57
Lec 2
05:53
Lec 3
09:24
+ Charts
6 lectures 47:50
Lec 1
06:45
Lec 2
09:53
Lec 3
07:12
Lec 4
06:25
Lec 5
07:16
Lec 6
10:19
+ Adjusting Worksheet Views
3 lectures 16:42
Lec 1
05:01
Lec 2
05:19
Lec 3
06:22
+ Multiple Worksheet and Workbook
5 lectures 35:51
Lec 1
09:44
Lec 2
04:13
Lec 3
06:07
Lec 4
08:57
Lec 5
06:50