Excel - A Step by Step Complete Course
3.6 (43 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.
2,886 students enrolled

Excel - A Step by Step Complete Course

Learn Microsoft Excel 2016. Excel is the best tool for Data Analysis. Excel 2016 from Beginner to Advanced
3.6 (43 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.
2,886 students enrolled
Last updated 7/2017
English
English [Auto]
Current price: $139.99 Original price: $199.99 Discount: 30% off
5 hours left at this price!
30-Day Money-Back Guarantee
This course includes
  • 6 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
  • Master Microsoft Excel 2016
  • Get Accustomed with Excel dashboard, tabs and ribbons.
  • Learn Formatting Options
  • Create Charts & Add Graphics
  • Use the most commonly used Excel functions
  • Learn Pivot Tables
  • Create Data Lists
  • Master Linking, Automating & Sharing
  • Implement Macros
Requirements
  • Microsoft Excel 2016 Trial or Full Version
Description

Microsoft Excel is the most popular and widely used spreadsheet software. 

Employee having a good knowledge of Excel is beneficial for any company. 

This course will build a solid understanding on the basics of Microsoft Excel. It will cover all important topics of Microsoft Excel 2016 from Beginner to Advanced in a Step by Step approach.

Topics include Working with the Excel interface, Entering data, Creating formulas and functions, Formatting rows, columns, cells, and data, Creating charts and PivotTables, Inserting and deleting sheets and Creating and running macros

Lifetime access to this Excel class allows you to easily continue learning new version, whenever they are launched.

Join in, As for learning Excel 2016, this course is the authority and equally important you will even get a certification of completion that validates your skills.

Who this course is for:
  • Anyone who wants to learn Excel
Course content
Expand all 53 lectures 05:46:42
+ The Excel 2016 - User Experience
13 lectures 01:32:42
Entering Data
09:08
Customising Quick Access Toolbox
09:29
Surfing Work Area
09:39
Formula Bar
07:15
Keyboard Keys
06:02
Entering Date Time
04:45
Fabricating Formulas
08:15
Formula Flub-ups
10:36
Autofill
06:53
Inserting Functions
03:56
Autofill and Flash
07:02
Finding Totals
05:27
Saving Excel File
04:15
+ To Make it all Look Pretty
7 lectures 47:54
Format as Table
06:50
Custom-able Style & Cell Formatting
08:56
Number Formats
09:28
Rows and Columns
06:17
Fonts and Alignment
04:25
Formatting via Quick Analysis Tool
04:24
+ Going Through Changes
7 lectures 46:56
Drag, Drop & Copying
07:04
Find Workbook Files
04:07
Cut & Paste
07:13
Paste from Clipboard Task Pane
06:50
Deleting & Inserting Stuff
08:01
Spelling Errors
04:35
+ Printing the Sheets
3 lectures 17:37
Preview Pages & Print Screen
05:32
Page Set Up
05:44
Header and Footer
06:21
+ Maintaining the Worksheet
5 lectures 31:42
Page Breakup Problems
04:34
Zooming In and Out
09:16
Managing Comments
04:13
Range Name
08:55
Controlling Recalculation and Protection
04:44
+ What-If Analysis
2 lectures 13:46
Goal Seek and Scenarios
09:00
One & Two Variable Data Table
04:46
+ Charts & Graphics
2 lectures 18:28
Charts
08:27
Adding Graphics
10:01