Excel 2016 Intermediate

Expand your Excel abilities with charts, outlines, workbooks and much more.

Course 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.

Learning Outcomes

  • 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

  • Pre-requisites

    Excel 2016 Introduction course or equivalent knowledge or experience

    Who is this course intended for?

    Students who want to take their Excel knowledge to the next level.

    Course Curriculum

    Available in days
    days after you enroll
      Analyzing Data with Common Lookup Functions
    Available in days
    days after you enroll
    Available in days
    days after you enroll

    Frequently Asked Questions

    When does the course start and finish?
    The course starts now and never ends! It is a completely self-paced online course - you decide when you start and when you finish.
    How long do I have access to the course?
    How does lifetime access sound? After enrolling, you have unlimited access to this course for as long as you like - across any and all devices you own.
    What if I am unhappy with the course?
    We would never want you to be unhappy! If you are unsatisfied with your purchase, contact us in the first 30 days and we will give you a full refund.

    This course is closed for enrollment.