Excel 2016 Intermediate

This course builds upon the foundational knowledge presented in the Excel Fundamentals course and will help start you down the road to creating advanced workbooks and worksheets that can help deepen your understanding of organizational intelligence. The ability to analyze massive amounts of data, extract actionable information from it, and present that information to decision makers is at the foundation of a successful organization that is able to compete at a high level.

Upon successful completion of this course, you will be able to: 

Leverage the power of data analysis and presentation in order to make informed, intelligent organizational decisions.

Course Description:

Module 1: Organizing Workbooks

• Overview Of Workbooks And Worksheets
• Working With Sheets In Groups

Module 2: Linking & Consolidating Data

• Working With Hyperlinks
• Working With Formulas That Link Worksheets And Files
• Consolidating Data From Various Worksheets

Module 3: Enhancing Workbook Navigation

• Adjusting Window Layout
• Organizing Data In An Outline

Module 4: Working With Lists of Data

• Overview Of Excel Lists
• Rules For Designing A List
• Flash Fill
• Remove Duplicate Values

Module 5: Sorting and Subtotaling

• Sorting a Worksheet List
• Sorting By Columns
• Creating Custom Sort Orders
• Producing Subtotals On A Sorted List

Module 6: Creating Tables, Using Filters and Criteria

• Automating Your List For Day-To-Day Activity
• Setting A Custom Autofilter
• Working With Criteria Ranges

Module 7: Working With Charts

• Creating A Chart
• Excel’s Assumptions About Your Data
• Modifying The Chart
• Enhancing The Chart
• Changing Series Orientation From Rows To Columns
• Working With Data Tables
• Updating A Chart’s Data Series
• Changing The Data Series Order
• Working With Series-Related Options
• User-Defined Custom Types
• Printing Charts
• Creating Sparklines
• Deleting Sparklines