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


      Introduction
    Available in days
    days after you enroll
      Customizing Excel
    Available in days
    days after you enroll
      Linking Workbooks and Worksheets
    Available in days
    days after you enroll
      Working with Range Names and Advanced Formulas
    Available in days
    days after you enroll
      Analyzing Data with Common Logical Functions
    Available in days
    days after you enroll
      Analyzing Data with Common Lookup Functions
    Available in days
    days after you enroll
      Sorting and Filtering Range Data
    Available in days
    days after you enroll
      Analyzing and Organizing with Tables
    Available in days
    days after you enroll
      Using Conditional Formatting
    Available in days
    days after you enroll
      Outlining with Subtotals and Grouping
    Available in days
    days after you enroll
      Displaying Data Graphically
    Available in days
    days after you enroll
      Understanding PivotTables and PivotCharts and Filtering with Slicers
    Available in days
    days after you enroll
      Working with Flash Fill
    Available in days
    days after you enroll
      Working with Date and Time Functions
    Available in days
    days after you enroll
      Working with Common Text Functions
    Available in days
    days after you enroll
      Conclusion
    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.