Microsoft Excel Advanced

Date: 24 December 2025 | Posted by: AD-TEAM

What you'll learn

This intensive hands-on one-day training course has been designed to provide delegates with a solid understanding of advanced Excel 2007, 2010, 2013 or 2016 tools and concepts in order to increase their knowledge and productivity.

Requirements

Delegates should have a good working knowledge and understanding of the concepts covered in the Introduction and Intermediate courses.

Description

MODULE 1: Grouping & Outlining and Subtotals

Learning outcomes: Useful Excel functions to summarise a spreadsheet making the data easier to identify and explain.

Topics covered:

Outlining and Grouping Data

Using the Subtotals Tool

MODULE 2: What-If Analysis

Learning outcomes: Tools designed to help with forecasting and finding solutions to complicated problems involving your spreadsheet's data and formulas.

Topics covered:

Exploring Scenarios

Goal Seek and Data Tables

Using Solver

MODULE 3: PivotTables

Learning outcomes: Creating Pivot Tables in order to display and summarise large quantities of data effectively.

Topics covered:

Getting Started with PivotTables

Displaying Data in a PivotTable

Formatting a PivotTable

Using the Classic PivotTable Layout

Slicers

MODULE 4: Charting Pivoted Data

Learning outcomes: Introducing Pivot Charts, adding specialist pivot charts to the already excellent Pivot Table feature.

Topics covered:

Getting Started with PivotCharts

Using the PivotChart Tools Tabs

Formatting a PivotChart

MODULE 5: Advanced Excel Tasks

Learning outcomes: Here we will look at sharing Excel files along with adding hyperlinks and Custom AutoFill Lists.

Topics covered:

Excel and Hyperlinks

Using Custom AutoFill Lists

Sharing Workbooks

MODULE 6: Creating HLOOKUP and VLOOKUP Functions

Learning outcomes: Exploring the different Lookup functions, and how to add further functionality to a spreadsheet to reference particular data quickly and effectively.

Topics covered:

Using the VLOOKUP Function

Using the LOOKUP Function

MODULE 7: Introduction to Macros in Excel

Learning outcomes: Explore how to create your own Macros and introducing Visual Basic for Applications, the application Macros are created in.

Topics covered:

Recording and Playing Macros

Copying and Deleting Macros

Visual Basic and Macros

Who this course is for:

Users with a good understanding of Microsoft Excel 2007, 2010, 2013 or 2016 who want to expand on their capabilities in a short space of time.

RapidGator

https://rapidgator.net/file/8f04692470b7fa48c770f9ea1802cdae/microsoft.excel.advanced.formulas..functions..pivottables.part1.rar
https://rapidgator.net/file/d0e2a6b2d7bcafd345ef9a73c8cf67f1/microsoft.excel.advanced.formulas..functions..pivottables.part2.rar
https://rapidgator.net/file/30319fa0462e853ff17620626b8d6afd/microsoft.excel.advanced.formulas..functions..pivottables.part3.rar
https://rapidgator.net/file/73a75d5c677d8fd643cd4c55896f59d8/microsoft.excel.advanced.formulas..functions..pivottables.part4.rar

NitroFlare

https://nitroflare.com/view/8A9C94D7EB08B17/microsoft.excel.advanced.formulas..functions..pivottables.part1.rar
https://nitroflare.com/view/7D77137ACB7960E/microsoft.excel.advanced.formulas..functions..pivottables.part2.rar
https://nitroflare.com/view/F2A32B8611BF68B/microsoft.excel.advanced.formulas..functions..pivottables.part3.rar
https://nitroflare.com/view/36B8C9518D1AA75/microsoft.excel.advanced.formulas..functions..pivottables.part4.rar

DDownload

https://ddownload.com/oetetonsirux/microsoft.excel.advanced.formulas..functions..pivottables.part1.rar
https://ddownload.com/csdiq8nt8vx5/microsoft.excel.advanced.formulas..functions..pivottables.part2.rar
https://ddownload.com/fubnpa391fwb/microsoft.excel.advanced.formulas..functions..pivottables.part3.rar
https://ddownload.com/pt1fbzec6rfk/microsoft.excel.advanced.formulas..functions..pivottables.part4.rar

See full article