Generic selectors
Exact matches only
Search in title
Search in content
Search in posts
Search in pages

Course Outline

Excel 2016 Level 3

Excel 2016 Level 3

Course Contents

Working with Lists
Creating a List
Maintaining a List
Editing Records Using the Data Form
Filtering a List
Using Subtotals in a List
Assignment

Working with Macros and User Defined Functions
Recording and Using Macros
Assigning Macros
Using User Defined Functions
Assignment

Using Basic Analysis Tools
Performing “What If” Analyses
Working with Scenarios
Assignment

Using Advanced Analysis Tools and External Data
Querying a Database
Importing and Exporting Files
Protecting Data
Using Data Validation
Using Worksheet Protection
Password Protecting a Workbook
Assignment

Using Business Analysis Tools
Working with Pivot Tables and Pivot Charts
Identifying the Parts of a Basic Pivot Table
Pivot Table Reports
Create a PivotTable from worksheet data
Create a PivotTable from an external data source
Create a PivotChart report from an existing PivotTable report
Delete a PivotTable or PivotChart report
Slicers
Using slicers
Formatting slicers for a consistent look
Sparklines
Types of Sparklines
Create a sparkline
Customize sparklines
Control which value points are shown
Change the style of or format sparklines

Price per delegate

£249

Scheduled Classes

Remote Access:

13 Aug 2021
14 Oct 2021
19 Nov 2021
13 Dec 2021

Please complete the contact form below or call 0141 221 5676 for further course information and available dates.
Alternatively you can email us at info@indiciatraining.com

Contact Us

Leave this field blank