Excel 2016 Intermediate
4.6 (11 ratings)
35 students enrolled
Wishlisted Wishlist

# Excel 2016 Intermediate

Expand your Excel abilities with charts, outlines, workbooks and much more.
4.6 (11 ratings)
35 students enrolled
Last updated 8/2016
English
Current price: \$10 Original price: \$30 Discount: 67% off
30-Day Money-Back Guarantee
Includes:
• 4 hours on-demand video
• 1 Supplemental Resource
• Access on mobile and TV
• Certificate of Completion
What Will I Learn?
• Custom Excel
• Work with Range Names
• Analyze Data with Common Logical Functions
• Analyze Data with Common Lookup Functions
• Sort and Filter Range Data
• Analyze and Organize with Tables
• Use Conditional Formatting
• Outline with Subtotals and Grouping
• Display Data Graphically
• Understand PivotTables and PivotCharts and Filter with Slicers
• Work with Flash Fill
• Work with Date and Time Functions
• Work with Common Text Functions
View Curriculum
Requirements
• Excel 2016 Introduction course or equivalent knowledge or experience
Description

This course is designed to be the intermediate level of Excel 2016. Students will learn how to link workbooks and worksheets, create named ranges and utilize them in formulas, build Logical functions such as IF, AND, and OR, and use Lookup functions to locate and compare data. Students will also be introduced to and work with Excel’s Table feature, learning to create and modify Tables. Students will also create and modify PivotTables and PivotCharts to analyze large data sets, sort the data, and use Slicers and Timeline Slicers to filter the data. Additionally, students will create and modify Charts, work with Flash Fill, work with subtotals and outlining, and learn how to customize the Excel environment.

Who is the target audience?
• Students who want to take their Excel knowledge to the next level.
Students Who Viewed This Course Also Viewed
Curriculum For This Course
75 Lectures
04:00:44
+
Introduction
1 Lecture 01:24
Preview 01:24
+
Customizing Excel
6 Lectures 21:08
Preview 06:09

03:46

Customizing the General and Formula Options
02:28

Preview 03:31

Customizing the Save Defaults
02:25

02:49
+
3 Lectures 12:33
Preview 04:55

02:54

Understanding the Consolidate Feature
04:44
+
Working with Range Names and Advanced Formulas
3 Lectures 12:08
What are Range Names?
02:43

Preview 06:46

Creating Range Names Using Create from Selection
02:39
+
Analyzing Data with Common Logical Functions
5 Lectures 19:09
Working with the Most Common Logical Functions
02:31

Evaluating Data with the AND Function
03:15

Preview 03:07

Understanding IF Functions
04:19

Nesting AND and OR Inside an IF Function
05:57
+
Analyzing Data with Common Lookup Functions
3 Lectures 11:42
What are Lookup Functions?
01:41

Using VLOOKUP
07:39

Preview 02:22
+
Sorting and Filtering Range Data
3 Lectures 08:50
Understanding the Differences Between Sorting and Filtering
01:43

Preview 03:49

Filtering Lists
03:18
+
Analyzing and Organizing with Tables
9 Lectures 23:10
Creating Tables and Understanding the Benefits
02:28

Understanding the Elements of a Table
02:38

Formatting a Table
02:36

Preview 02:05

Filtering Tables
02:38

Filtering with Slicers
02:49

Calculating with Tables
03:42

Removing Erroneous Table Data
02:08

Exporting, Refreshing, and Converting Tables
02:06
+
Using Conditional Formatting
6 Lectures 16:41
Preview 01:18

Conditional Formatting: Highlight Cells and Top Bottom Rules
04:23

Conditional Formatting: Data Bars, Icon Sets, and Color Scales
03:55

Preview 02:15

Using Custom Conditional Formatting
02:46

Modifying or Removing Conditional Formatting
02:04
+
Outlining with Subtotals and Grouping
3 Lectures 06:08
What are Subtotals and Grouping?
01:06

Creating Subtotals
03:00

Grouping and Ungrouping Data
02:02
6 More Sections