I.T. Skills (S)

(L16) Excel 2016 Advanced (Select your topic)

Excel’s tricky. No shame in admitting that. It’s easy to use, don’t get me wrong, but to fully appreciate everything the platform has to offer? That takes time. Luckily, we’ve condensed all the main stuff into bitesize learning. Check it out. Mastering Excel can take you from employee to star employee! If you believe hyperbole like that, you’ll believe anything. But, genuinely, it’s a hugely useful platform, especially in a work environment. If you can use it to its fullest, it will put you at an advantage. And that can only be a good thing, right? This course has the tips that’ll help you master this software.

Course Topics
*Database functions
*Pivot tables uncovered
*Data analysis tools
*Simple macros

  • Excel 2016 Advanced - Description
  • Advanced Options
  • Changing Pivot Table Data
  • Create a Pivot Table Chart
  • Create an Outline Group
  • Create and Run a Simple Macro
  • Creating a Pivot Table
  • Creating and Using Scenarios
  • Creating Scenarios Reports
  • Customising a Pivot Table
  • Flash Fill
  • Formatting a Pivot Table
  • Formula Options
  • Goal Seek
  • Grouping data in a Pivot Table
  • Managing Scenarios
  • Pivot Table Timeline
  • Pivot Table Tools Ribbons
  • Protecting Workbooks and Worksheets
  • Recommended Pivot Tables
  • Remove Duplicates
  • Sharing Workbooks and Track Changes
  • Splitting Data
  • Subtotals
  • Using external data in Pivot Tables
  • Using Slicers to Filter Pivot Tables
Completion rules
  • All units must be completed
  • Leads to a certificate with a duration: 2 years