Microsoft Excel – Advanced

Turn unorganized data into useful information and quickly make spreadsheets your friends. Train IT Midlands’s lets people of any technical level learn exactly what they need to know at their own pace. The course starts with Excel fundamentals and then moves on to advanced topics like functions, PivotTables, and macros.

• All lessons are bite-sized and self-contained, so you can select only what you need.
• Features matching content with Interactive Online Learning and Skills Assessments.

Working with PivotTables
Creating a PivotTable
Specifying PivotTable Data
Changing a PivotTable’s Calculation
Filtering and Sorting a PivotTable
Working with PivotTable Layout
Grouping PivotTable Items
Updating a PivotTable
Formatting a PivotTable
Creating a PivotChart
Using Slicers
Sharing Slicers Between PivotTables

Analyzing Data
Creating Scenarios
Creating a Scenario Report
Working with Data Tables
Using Goal Seek
Using Solver
Using Text to Columns
Grouping and Outlining Data
Using Subtotals
Consolidating Data by Position or Category
Consolidating Data Using Formulas

Working with the Web and External Data
Inserting a Hyperlink
Importing Data from an Access Database or Text File
Importing Data from the Web and Other Sources
Working with Existing Data Connections

Working with Macros
Recording a Macro
Playing and Deleting a Macro
Adding a Macro to the Quick Access Toolbar
Editing a Macro’s Visual Basic Code
Inserting Copied Code in a Macro
Declaring Variables and Adding Remarks to VBA Code
Prompting for User Input
Using the If…Then…Else Statement

Customizing Excel
Customizing the Ribbon
Customizing the Quick Access Toolbar
Using and Customizing AutoCorrect
Changing Excel’s Default Options
Creating a Custom AutoFill List
Creating a Custom Number Format

Related Courses

Microsoft Excel – Introduction

Get to grips with the basics of Excel. This course will enable you to perform simple calculations with confidence using formulas, navigate around the the Excel ribbon quicker and easier and learn the Excel shortcuts that will make your mouse redundant. See how to format your data to look professional both on screen or printed.

Microsoft Excel – Intermediate

Once your conversant with the basics of Excel this course aims to provide you with the knowledge to use more advanced lookup and logical formulas to find and compare data. You will organise your raw data in Tables, possibly the “must know” formatting feature in Excel, before learning how to analyse it with sorting and advanced filtering. You will also learn how to get started with Pivot Tables and present you data as charts.