Microsoft Office 2016 Excel Intermediate
0.0 (0 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.
5 students enrolled

Microsoft Office 2016 Excel Intermediate

2016 Excel Intermediate
0.0 (0 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.
5 students enrolled
Last updated 11/2018
English
Current price: $129.99 Original price: $199.99 Discount: 35% off
18 hours left at this price!
30-Day Money-Back Guarantee
This course includes
  • 3.5 hours on-demand video
  • 5 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 functions and ranges
  • Use specialized and logical functions
  • Sort and filter data
  • Query data with database functions
  • Create and modify tables
  • Apply advanced conditional formatting
  • Visualize data with charts
  • Use PivotTables and PivotCharts
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 course before registering for this course.
Description

The Microsoft Excel 2016 L2 course is the second course in a three course series on Microsoft Office Excel 2016 that covers the intermediate-level topics regarding Microsoft Excel 2016. The course covers the more advanced concepts like functions, lists, data analysis, data visualization and pivot tables. The course also provides a smooth transition opportunity to students to upgrade to Microsoft Office Excel 2016.

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 156 lectures 03:43:17
+ Chapter 01 - Working with Functions
48 lectures 01:12:13
Demo - Naming and Editing Ranges
06:34
Cell and Range Names in Formulas
00:31
The Use in Formula Command Method
00:32
The Formula AutoComplete Method
00:35
Demo - Using Defined Names in a Formula
02:37
Topic B: Use Specialized Functions
00:34
The Excel Function Reference
01:41
Function Syntax
01:20
Date Calculations
01:19
Demo - Locating and Using Specialized Functions
06:44
Topic C: Work with Logical Functions
02:27
Comparison Operators
00:59
The IF Function
02:25
The AND Function
01:11
The OR Function
00:25
The NOT Function
00:40
Demo - Working with Logical Functions
06:33
Nesting
01:13
Nested Function Syntax
03:51
Demo - Combining Functions
03:45
Topic D: Work with Date & Time Functions
00:20
The TODAY Function
00:24
The NOW Function
00:22
The DATE Function
00:50
The NETWORKDAYS Function
01:05
The WEEKDAY Function
00:52
The WORKDAY Function
01:01
The ISOWEEKNUM Function
00:36
Demo - Work with Date & Time Functions
02:36
Topic E: Work with Text Functions
00:25
The LEFT Function
01:56
The RIGHT Function
00:29
Convert Text to Columns Wizard
00:55
The MID Function
00:49
The CONCATENATE Function
00:41
Text Concatenation with the Ampersand
00:25
The UPPER Function
00:19
The LOWER Function
00:13
The PROPER Function
00:15
Demo - Working with Text Functions
03:49
Chapter 01 Review
00:37
Review - Question
9 questions
+ Chapter 02 - Working with Lists
26 lectures 37:35
Working with Lists
00:33
Topic A: Sort Data
00:28
Sorting
02:13
Multiple Column/Row Sorting
01:05
Quick Sorts
00:47
The Sort Dialog Box
01:10
The Sort Options Dialog Box
00:31
Demo - Sorting Data
03:12
Topic B: Filter Data
00:30
Filtering
00:52
AutoFilters
00:46
The Custom AutoFilter Dialog Box
00:52
Advanced Filtering
00:59
The Criteria Range
01:45
Demo - Filtering Data
04:02
Topic C: Query Data with Database Functions
00:19
Database Functions
01:40
Database Function Syntax
02:21
Demo - Using Database Functions
04:41
Topic D: Outline and Subtotal Data
00:39
Outlines
00:45
The SUBTOTAL Function
02:00
The Subtotals Feature
01:23
The Subtotal Dialog Box
00:35
Demo - Using Subtotals to Summarize Data
03:04
Chapter 02 Review
00:23
Review - Question
5 questions
+ Chapter 03 - Analyzing Data
20 lectures 28:09
Analyzing Data
00:43
Topic A: Create and Modify Tables
00:41
Tables
00:52
Table Components
01:18
The Create Table Dialog Box
00:32
The Table Tools Design Contextual Tab
00:52
Table Styles and Quick Styles
00:23
The New Table Style Dialog Box
00:45
Quick Analysis
01:08
Demo - Creating and Modifying Tables
05:00
Demo - Using Summary Functions in Tables
03:27
Topic B: Apply Intermediate Conditional Formatting
00:22
The New Formatting Rule Dialog Box
01:42
The Conditional Formatting Rules Manager Dialog Box
00:36
Rule Precedence
00:24
Demo - Applying Intermediate Conditional Formatting
03:44
Topic C: Apply Advanced Conditional Formatting
00:20
The Use a Formula to Determine Which Cells to Format Rule
01:08
Demo - Using Logical Functions to Apply Conditional Formatting
03:19
Chapter 03 Review
00:53
Review - Question
7 questions
+ Chapter 04 - Visualizing Data with Charts
26 lectures 37:51
Visualizing Data with Charts
01:07
Topic A: Create Charts
00:32
Charts
01:02
Chart Basics
01:45
Chart Types
02:08
Recommended Charts
00:40
The Insert Chart Dialog Box
00:39
Demo - Creating Charts
05:21
Topic B: Modify and Format Charts
00:41
Chart Modifications
00:49
Chart Formatting
00:32
Chart Elements
01:38
The Design Tab
01:09
The Format Tab
00:38
The Format Task Pane
01:08
The Chart Tools Buttons
00:49
The Select Data Source Dialog Box
00:33
Demo - Modifying and Formatting Charts
04:14
Topic C: Use Advanced Chart Features
01:04
Dual-Axis Charts
01:08
Trendlines
01:24
The Format Trendline Task Pane
00:43
Demo - Creating a Dual-Axis Chart
04:08
Chart Templates
00:57
Demo - Creating a Chart Template
01:52
Chapter 04 Review
01:10
Review - Question
6 questions
+ Chapter 05 - Using PivotTables and PivotCharts
33 lectures 44:34
Using PivotTables and PivotCharts
01:28
Topic A: Create a PivotTable
00:28
Pivoting
02:18
PivotTables
01:32
Transactional Data
01:32
The Create PivotTable Dialog Box
00:33
The PivotTable Fields Task Pane
01:27
Demo - Creating a PivotTable
04:29
Topic B: Analyze PivotTable Data
00:04
The Analyze Tab
03:13
The Design Tab
00:25
The Value Field Settings Dialog Box
00:48
SUM Function Only
00:41
Percentage of Total
00:28
Difference From Option
00:40
The GETPIVOTDATA Function
01:29
Demo - Analyzing PivotTable Data
04:07
Topic C: Present Data with PivotCharts
00:05
PivotCharts
00:44
The PivotChart Fields Task Pane
00:31
PivotChart Filters
00:36
Demo - Presenting Data with PivotCharts
05:38
Topic D: Filter Data by Using Timelines and Slicers
00:05
Slicers
02:04
The Insert Slicers Dialog Box
00:21
The Slicer Tools Contextual Tab
00:56
The Report Connections Dialog Box
00:51
Timelines
00:34
The Insert Timelines Dialog Box
00:18
The Timeline Tools Contextual Tab
00:35
Demo - Filtering Data by Using Slicers and Timelines
03:26
Chapter 05 Review
00:40
Course Closure
01:28
Review - Question
6 questions