Excel 2016 Intermediate
4.6 (11 ratings)
Instead of using a simple lifetime average, Udemy calculates a course's star rating by considering a number of different factors such as the number of ratings, the age of ratings, and the likelihood of fraudulent ratings.
35 students enrolled
Wishlisted Wishlist

Please confirm that you want to add Excel 2016 Intermediate to your Wishlist.

Add to Wishlist

Excel 2016 Intermediate

Expand your Excel abilities with charts, outlines, workbooks and much more.
4.6 (11 ratings)
Instead of using a simple lifetime average, Udemy calculates a course's star rating by considering a number of different factors such as the number of ratings, the age of ratings, and the likelihood of fraudulent ratings.
35 students enrolled
Last updated 8/2016
English
Curiosity Sale
Current price: $10 Original price: $30 Discount: 67% off
30-Day Money-Back Guarantee
Includes:
  • 4 hours on-demand video
  • 1 Supplemental Resource
  • Full lifetime access
  • Access on mobile and TV
  • Certificate of Completion
What Will I Learn?
  • Custom Excel
  • Link Workbooks and Worksheets
  • 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
+
Customizing Excel
6 Lectures 21:08

Customizing the Quick Access Toolbar
03:46

Customizing the General and Formula Options
02:28


Customizing the Save Defaults
02:25

Customizing Advanced Excel Options
02:49
+
Linking Workbooks and Worksheets
3 Lectures 12:33

Linking Worksheets with 3D References
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


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


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

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


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


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

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

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


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
About the Instructor
Intellezy Trainers
4.4 Average rating
4,573 Reviews
26,731 Students
137 Courses
Computer Training Specialists

At Intellezy, we believe learning should be simple, engaging, and relevant. We make this possible by building innovative, short-segment eLearning videos and easy-to-use quick reference cards designed to educate and empower companies and individuals. In today’s rapidly evolving workplace it is imperative to make sure you have the skills required to succeed. Our library provides dynamic, task-focused videos right at your fingertips, right when you need them. Our goal? To educate the world, one video at a time.