Microsoft Excel 2016 Modules Training Course Outline

Audience: This course is aimed at those who wishing to tailor Excel 2016 course to specific requirements, for ideas of course content below we have listed example areas.

Course Duration: 1 day.

Course Availability: Monday – Saturday

Course Types: Group bookings, public courses, 1-2-1 sessions, bespoke tailored courses and office migrations.

Course Types: Group bookings, 1-2-1 sessions and Saturday club.

Course Location: This Microsoft Excel 2016 modules training course can be delivered either at our London training venue or at your offices. 

Tailored Course Content: Course content can be customised to meet your specific requirements, with scheduled dates to suit you.

Choose from the follow topics:

Getting started with Excel

  • Creating and saving workbooks
  • Opening and closing workbooks
  • Working with Backstage
  • Changing the file type and converting to PDF
  • Entering dates, numbers and text
  • Font formatting
  • Cell alignment
  • Number formatting
  • Entering formulas
  • Printing documents
  • Smart Lookup

Essential Excel formulas

  • Moving and copying data
  • Using Paste Special and Format Painter
  • Inserting, deleting and changing rows and columns
  • Borders and shading
  • Autofill and creating series
  • Entering and copying formulas
  • Relative and absolute cell references
  • Order of calculation
  • Using AutoSum
  • AVERAGE, COUNT, COUNTA, MIN and MAX functions

Excel Charts

  • Using Recommended Charts
  • Selecting the data to plot
  • Different types of charts
  • Adding titles and labels
  • Chart sheets and embedded charts
  • Gridlines, data tables and legends
  • Changing the chart type
  • Adjusting, adding and removing a data series
  • Formatting chart elements
  • Adding a picture to your chart

Excel Charts Continued…

  • Adding text boxes and arrows
  • Printing chart
  • Creating chart templates
  • Inserting Sparklines

Analysing Excel data

  • Creating tables
  • Moving around and selecting a table
  • Adding a total row
  • Sorting data
  • Filtering data
  • Creating Subtotals
  • Creating nested subtotals
  • Analysing data with Pivot Tables
  • Reorganising the Pivot Table
  • Formatting the data in Pivot Tables
  • Refreshing a Pivot Table
  • Grouping Pivot Table data such as dates into calendar periods
  • Slicers and Timelines
  • Aggregation functions; SUMIFS and COUNTIFS

Further Excel formulas

  • Review of basic formulas and functions
  • The structure of functions
  • Nesting functions
  • IF and nested IF functions
  • Lookup functions
  • Date and Time functions
  • Information functions
  • Financial functions
  • Text functions
  • Arrays and array functions

Essential Excel utilities

  • Using FlashFill
  • Conditional formatting
  • Data Validation
  • Creating drop down lists
  • Goal Seek
  • Data tables
  • Scenarios
  • Protection
  • Sharing Workbooks
  • Tracking Changes
  • Removing duplicates
  • One Click Forecasting