Microsoft Excel 2016 Training Course Advanced Hammersmith

Hammersmith Advanced Microsoft Excel 2016 Course Overview

If you're wanting to book your Microsoft Excel 2016 Training Course and are wondering about the following:

• You don't know what course to take!
• You have no idea of your skill level.
• You are wanting training for your team.

Then we'll be happy to help you choose or design a course that suits you. We can come to you but should you want to get away to do the Microsoft Excel 2016 Training Course then the offices we use in Hammersmith are at:

Hammersmith
Crown House
72 Hammersmith Rd
Hammersmith
London W14 8TH

An ideal location for your Microsoft Excel 2016 Training Course Advanced training course. The training centre is situated in the heart of west London between Hammersmith and Kensington.

The building, Crown House, is bright and modern with large windows giving the training course location a spacious, airy and comfortable feel. Within easy walking distance of Hammersmith High Street.

The training course location is close to major roads, local bus routes and several London Underground stations the closest being Barons Court.

There are many other computer training courses in Hammersmith & Fulham available. Please see if there is a course for you.

Hammersmith is a lively area with a thriving arts scene, including the famous Hammersmith Apollo.

Course Duration: 1 Day

Course Prerequisites for your training in Hammersmith

This is an advanced course, so to ensure that you get the most out of it check that you are familiar with the following:

You may want to familiarise yourself with our Excel Beginners and Intermediate Outlines.

Microsoft Excel 2016 Training Course Beginners

Microsoft Excel 2016 Training Course Intermediate

Complete Course Outline

Importing & Exporting Data in Excel 2016

• Importing External Data into Excel
• Importing Text Data into Excel
• Converting Text into Columns
• Removing Duplicate Rows of Data
• Importing Data form a Database
• Linking to Another File
• Linking & Embedding Objects
• Exporting Data from Excel
• Publishing Worksheets & Workbooks to the Web

Formatting Numbers

• Creating Custom Number Formats
• Using and Applying Conditional Formatting
• Applying Specialised Conditional Formatting
• Creating your own Formatting Rules
• Managing Conditional Formatting

Working with Ranges

• Naming & Using a Range
• Managing Range Names
• Using the VLOOKUP Function

Working with Macros

• Creating, Running and Editing a Macro
• Saving and Opening a Workbook with Macros
• Adding a Macro to the Quick Access Toolbar

Data Analysis Tools

• Tracing Formula Precedents
• Tracing Cell Dependents
• Tracing and Fixing Errors
• Error Checking a Worksheet
• Working with Advanced Pivot Table Functions

Summarising Data

• Adding Subtotals to a List
• Nesting Subtotals
• Applying Advanced Filters
• Adding Group and Outline Criteria to Ranges
• Using Data Validation
• Previewing Data Using Quick Analysis

Analysing Your Data

• Using Goal Seek
• Using Solver
• Creating and Displaying Scenarios
• Using Data Tables
• Forecasting Future Values

Workgroup Collaboration

• Locking / Unlocking Cells in a Worksheet
• Protecting a Worksheet and Workbook
• Showing or Hiding Formulas
• Creating a Shared Workbook
• Tracking Changes to a Workbook
• Accepting and Rejecting Changes to a Workbook
• Encrypting a Workbook
• Marking a Workbook as Final
• Merging Copies of Share Workbooks
• Inspecting Workbooks
• Checking Document Compatibility & Accessibility

Have a look at our range of Excel Training Courses

If you use macros and have already dipped your toes into the world of VBA, you might want to think about taking our VBA for Excel training course. This training course will set you up to be a VBA expert in Excel.

Other Courses that may interest you:

Microsoft Excel 2019 Beginners Training Course

Microsoft Excel 2016 Training Course Beginners

Microsoft Excel 2016 Training Course Intermediate

Microsoft Excel Pivot Tables Training Course Beginners

Microsoft Excel PowerPivot Training Course Intermediate

Microsoft Excel 2013 Training Course Intermediate

Microsoft Excel 2013 Training Course Advanced