Microsoft Office 365: Excel 2016

Course Overview

In this instructor-led, online training course, students will be provided with a foundation for Excel knowledge and skills, which you can build upon to eventually become an expert in data manipulation.

Instructor: Ashley Hunt

Skills Learned

At the end of this course students will be able to:

  • Sort a range
  • Use text to columns
  • Set up a form
  • Use conditional formatting
  • Utilize excel functions
  • Secure their workbook
  • Utilize macros
  • Create and modify charts, graphs, and tables

Who Should Attend This Course

Any current or future user of Excel 2016 who is looking to better understand and utilize the application.

Course Outline

  • Apply A Simple Filter To a Range
  • Apply A Top 10 And Custom Filter To a Range
  • Apply an Advanced Filter With Multiple OR Criteria
  • Apply an Advanced Filter With Complex Criteria
  • Apply an Advanced Filter With Function-Driven Criteria
  • Convert A Range into A Table and Add a Total Row
  • Format A Table Using Table Styles and Convert a Table into A Range
  • Create A Custom Table Style
  • Sort A Range or Table by Rows
  • Sort A Range by Columns
  • Sort A Range or Table by Custom List
  • Split Fixed Width Data Using Text to Columns
  • Split Delimited Data Using Text to Columns
  • Consolidate Data from Multiple Data Ranges
  • Use Data Consolidation to Generate Quick Subtotals from Tables
  • Remove Duplicate Values from A Table
  • Flash Fill
  • Quick Analysis
  • Transposing Columns into Rows (And Vice Versa)
  • Setting Up a Form
  • Adding A Dropdown List
  • Conditional Formatting
  • Add Group Box and Option Button Controls to A Worksheet Form
  • Add A Combo Box Control to A Worksheet Form
  • Add A Check Box Control to A Worksheet Form
  • SUM
  • MAX AND MIN
  • IF
  • TRIM
  • SUMIF
  • COUNTIF
  • AND
  • OR
  • LEFT, RIGHT, CONCATINATE
  • PROPER, UPPER, LOWER
  • NOW
  • VLookup
  • Use Range Names to Make Formulas More Readable
  • Use The Watch Window to Monitor Cell Values
  • Prevent Unauthorized Users from Opening or Modifying Workbooks
  • Control The Changes Users Can Make to Workbooks
  • Restrict The Cells Users Are Allowed to Change
  • Allow Different Levels of Access to A Worksheet with Multiple Passwords
  • Add an Invisible Digital Signature to A Workbook
  • Add A Visible Digital Signature to A Workbook
  • Accept and Reject Changes to Shared Workbooks
  • Use Check Box Data in Result Cells
  • Totally Hide Cell Content from Prying Eyes
  • Record A Macro
  • Record A Macro with Relative References
  • Use Shapes to Run Macros
  • Run A Macro from A Button Control
  • Can’t Code? No Worries! Can You Copy and Paste?
  • Intro to VBA and The Unnecessary Need for Coding Because Someone Already Figured It Out!
  • Charts, Sparkline and Filters Oh MY!
  • Use Pictograms and Blow Their Mind!
  • Create A Pivot Table Because Your Boss Loves Them!
  • Filter A Pivot Table Visually Using Slicers
  • Add A Timeline Control to A Pivot Table
  • Use Slicers to Create a Custom Timeline
  • Format A Pivot Table Using Pivot Table Styles
  • Create A Custom Pivot Table Style
  • Understand Pivot Table Report Layouts
  • Add/Remove Subtotals and Apply Cell Styles to Pivot Table Fields
  • Display Multiple Summations Within a Single Pivot Table
  • Add A Calculated Field to A Pivot Table
  • Add A Calculated Item to A Pivot Table
  • Group by Text, Date and Numeric Value Ranges
  • Show Row Data by Percentage of Total Rather Than Value
  • Use Pivot Table Values in Simple Formulas