Administrative Staff

Assessment Co Ordinators

Bursars And Business Managers

Pastoral Officers

Sencos

Senior Leaders

Teachers

Technical Staff

Microsoft Excel 2016 Part 3

 

Microsoft Office Excel 2016 is the newest version of Microsoft’s popular spreadsheet program. This, the third level of Velsoft’s training program, explores the advanced features in in Excel 2016. Students will cover:

 

SUBTOTAL functions

The SUBTOTAL dialogue box
Summary Totals in Tables

Analysing Data with PivotTables, Slicers and PivotCharts

Create a PivotTable
Prepare the Data Source
Create PivotTable Dialogue Box
Summarise Data in a PivotTable
The PivotTable Fields Pane
Functions in a PivotTable
Filter Fields and the PivotTable
Summarize Values as Percentages
Group Fields
Refresh Data
Change Data Source
Adding Calculated Fields

Import a Delimited Text File

Filter Data Using Slicers

Analyse Data with PivotCharts

Auditing Worksheets

Trace Cells
Troubleshoot Invalid Data and Formula Errors
Watch and Evaluate Formulas
Create a Data List Outline

Presenting Data with Sparklines

Working with Multiple Workbooks
Consolidate Data
Link Cells in Different Workbooks
Merge Workbooks

Automatic Worksheet Functionality
Apply Conditional Formatting
Add Data Validation Criteria

Create and Edit a Macro
The Record Macro Dialogue Box
Naming Macros
Copying Macros Between Workbooks
Macro Security Settings

ATTENDANCE
Full day

Cost: £170.00 per person SLA Rate

If you are unsure whether this is the correct level of course for you, please complete the self-assessment questionnaire.

To book a place on this course please complete the booking form and email to scomis@supportworks.devon.gov.uk.  Click here for the booking form.