Microsoft Office 2016 Excel Advanced
5.0 (1 rating)
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.
10 students enrolled

Microsoft Office 2016 Excel Advanced

Excel 2016 Advanced
5.0 (1 rating)
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.
10 students enrolled
Last updated 11/2018
English
Current price: $129.99 Original price: $199.99 Discount: 35% off
2 hours left at this price!
30-Day Money-Back Guarantee
This course includes
  • 2.5 hours on-demand video
  • 6 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
  • Work with multiple worksheets and workbooks
  • Use lookup functions and formula auditing
  • Share and protect workbooks
  • Automate workbook functionality
  • Create spaklines
  • Map data
  • Determine potential outcomes using data tables
  • Forecast data trends
Requirements
  • The course requires the students to have hands-on experience and knowledge of Microsoft Office 2007 or Microsoft Office 2010 especially Microsoft Office Excel.
  • In addition to that, a good knowledge of getting around with Microsoft Windows 10 is required as well.
  • The students should also complete the previous level courses before registering for this course.
Description

The Microsoft Excel 2016 L3 course is the third and last course in the three course series on Microsoft Office Excel 2016 that covers the advanced-level topics regarding Microsoft Excel 2016. The course covers the more complex concepts like multiple worksheets, lookup functions, formula auditing, workbook sharing and protection, workbook automation and data mapping. 

Microsoft Office Excel 2016 is an essential application for students, office workers, executives, accountants and financial analysts. This course helps the candidates to get started with the latest version of Microsoft Office Excel. The course enables the candidates to acquire the necessary knowledge to efficiently use the features of Microsoft Office Excel 2016 to achieve excellence in the daily routine tasks.


Who this course is for:
  • Candidates planning to upgrade to Microsoft Office Excel 2016
  • Candidates responsible to manage and maintain Excel workbooks at their workplaces
  • Accounting and finance professionals
  • University students
Course content
Expand all 109 lectures 02:42:42
+ Chapter 01 - Working with Multiple Worksheets and Workbooks
16 lectures 23:53
Topic B: Use 3-D References
01:13
Grouped Worksheets
00:53
3-D References
01:02
3-D References in Summary Functions
00:30
Demo - Using 3-D References
02:11
Topic C: Consolidate Data
00:30
Data Consolidation
00:27
The Consolidate Dialog Box
01:15
Demo - Consolidating Data
02:42
Chapter 01 Review
00:49
Review - Question
7 questions
+ Chapter 02 - Using Lookup Functions and Formula Auditing
16 lectures 30:25
Using Lookup Functions and Formula Auditing
01:16
Topic A: Use Lookup Functions
00:41
The VLOOKUP Function
02:53
Demo - Using Lookup Functions
07:55
Topic B: Trace Cells
01:13
Precedent and Dependent Cells
01:36
The Trace Precedents and Trace Dependents Commands
00:43
Trace Arrows
01:11
The Go To Dialog Box and Trace Arrows
00:34
The Go To Special Dialog Box
00:27
Demo - Tracing Precedent and Dependent Cells
03:19
Topic C: Watch and Evaluate Formulas
01:12
The Watch Window
01:21
The Evaluate Formula Dialog Box
01:21
Demo - Watching and Evaluating Formulas
02:56
Chapter 02 Review
01:47
Review - Question
7 questions
+ Chapter 03 - Sharing and Protecting Workbooks
22 lectures 27:54
Sharing and Protecting Workbooks
01:34
Topic A: Collaborate on a Workbook
01:02
Comments
01:17
Shared Workbooks
01:21
Change Tracking
01:12
The Highlight Changes Dialog Box
00:35
The Select Changes to Accept or Reject Dialog Box
00:51
The Accept or Reject Changes Dialog Box
00:22
The Compare and Merge Workbooks Command
01:07
The Share Options
00:34
Microsoft Accounts and OneDrive
00:29
Excel Online
00:56
The Accessibility Checker
00:53
Demo - Collaborating on a Workbook
07:16
Topic B: Protect Worksheets and Workbooks
00:40
Worksheet and Workbook Element Protection
01:01
The Protect Sheet Command
00:26
The Protect Workbook Command
00:23
The Protect Workbook Options
00:42
The Document Inspector
00:30
Demo - Protecting Worksheets and Workbooks
03:36
Chapter 03 Review
01:07
Review - Question
7 questions
+ Chapter 04 - Automating Workbook Functionality
18 lectures 35:24
Automating Workbook Functionality
01:37
Topic A: Apply Data Validation
01:32
The Data Validation Dialog Box
01:46
Data Validation Criteria
01:28
The Input Message Tab
00:47
The Error Alert Tab
00:54
Demo - Applying Data Validation
05:24
Topic B: Search for Invalid Data and Formulas with Errors
00:46
The Circle Invalid Data Command
01:18
The Error Checking Dialog Box
02:01
Topic C: Work with Macros
01:39
Macro Security Settings
01:49
Microsoft Visual Basic for Applications
01:27
The Record Macro Dialog Box
01:14
The Macro Dialog Box
00:56
The Personal Workbook
00:45
Demo - Creating and Editing a Macro
09:10
Chapter 04 Review
00:51
Review - Question
7 questions
+ Chapter 05 - Creating Sparklines and Mapping Data
12 lectures 14:26
Creating Sparklines and Mapping Data
01:03
Topic A: Create Sparklines
00:42
Sparklines
01:13
The Create Sparklines Dialog Box
00:24
The Sparkline Tools Contextual Tab
00:30
Demo - Creating Sparklines
03:18
Topic B: Map Data
00:23
3D Maps
00:37
3D Map Layer Pane
00:59
Launch 3D Maps Dialog Box
00:27
Demo - Creating a 3-D Map
04:20
Chapter 05 Review
00:30
Review - Question
5 questions
+ Chapter 06 - Forecasting Data
22 lectures 27:45
Forecasting Data
01:31
Topic A: Determine Potential Outcomes Using Data Tables
00:26
What-If Analysis
00:44
One-Variable Data Tables
01:11
Two-Variable Data Tables
00:33
The Data Table Dialog Box
00:27
Demo - Determining Potential Outcomes Using Data Tables
03:52
Topic B: Determine Potential Outcomes Using Scenarios
00:24
Scenarios
01:08
The Scenario Manager Dialog Box
00:43
The Add Scenario Dialog Box
00:21
The Scenario Values Dialog Box
00:22
The Scenario Command
00:31
Demo - Determining Potential Outcomes by Using Scenarios
05:44
Topic C: Use the Goal Seek Feature
00:42
The Goal Seek Dialog Box
00:48
Demo - Using Goal Seek Feature
02:45
Topic D: Forecasting Data Trends
00:25
The Create Forecast Worksheet Dialog Box
00:53
Demo - Forecasting Data with the Forecast Sheet
01:57
Chapter 06 Review
01:09
Course Closure
01:09
Review - Question
5 questions