Mastering Excel 2016 - 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.
14 students enrolled

Mastering Excel 2016 - Intermediate

The World Is Filled With Two Kinds Of People: A Handful Of People Who Are Masters Of Excel, And The Millions Of Others W
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.
14 students enrolled
Created by Chip Reaves
Last updated 3/2018
English
English, Spanish
Current price: $27.99 Original price: $39.99 Discount: 30% off
5 hours left at this price!
30-Day Money-Back Guarantee
This course includes
  • 3 hours on-demand video
  • 1 downloadable resource
  • 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 Named Ranges and Tables
  • Use Logical, Text, Date, and other Functions
  • Sort, Filter, and Summarize Data
  • Create PivotTables and Pivot Charts
  • Use Conditional Formatting
  • Add Slicers and Timelines to Analyze Information
Requirements
  • The student will need basic computer knowledge.
  • We recommend that the student take our course "Mastering Excel 2016 - Basics" first if they are not yet familiar with Excel.
  • A copy of Microsoft Excel is recommended.
Description

If you’ve mastered Microsoft Excel 2016 then you have one of the most practical and valuable skill sets in all of modern business. A spreadsheet guru can work wonders – from organizing lists, to creating multi-layered, interactive reports, to revealing answers to business critical questions like ROI, budget allocations, tracking expenditures, and more. This course builds on your existing knowledge of Excel basics and teaches you how to manage data, charts, and tables, and how to use powerful tools such as PivotTables, Pivot Charts, Slicers, Timelines, and more. 


Who this course is for:
  • Microsoft Excel users
Course content
Expand all 25 lectures 03:11:31
+ Data
4 lectures 32:22
Sorting Data
05:34
Filtering Data
09:18
Database Functions
07:49
Using Subtotals
09:41
+ Tables and Conditional Formatting
4 lectures 22:09
Create and Modify Tables
09:08
Manipulating Table Data
03:50
Conditional Formatting Rules
03:51
Using Logical Functions with Conditional Formatting
05:20
+ Charts
5 lectures 35:39
Creating Charts
08:37
Modifying and Formatting Charts
09:38
Creating a Dual Axis Chart
07:20
Chart Templates
02:59
Formatting Shapes and Objects
07:05
+ PivotTables, Slicers, and Timelines
4 lectures 29:31
Creating a PivotTable
07:14
Analyzing PivotTable Data
09:47
Pivot Charts
06:26
Slicers and Timelines
06:04