Microsoft Excel Advanced
4.4 (63 ratings)
Course Ratings are calculated from individual students’ ratings and a variety of other signals, like age of rating and reliability, to ensure that they reflect course quality fairly and accurately.
3,708 students enrolled

Microsoft Excel Advanced

Becoming an Advanced user of Microsoft Excel
4.4 (63 ratings)
Course Ratings are calculated from individual students’ ratings and a variety of other signals, like age of rating and reliability, to ensure that they reflect course quality fairly and accurately.
3,708 students enrolled
Created by ZandaX Training
Last updated 2/2019
English
English [Auto-generated]
Current price: $13.99 Original price: $19.99 Discount: 30% off
5 hours left at this price!
30-Day Money-Back Guarantee
This course includes
  • 3 hours on-demand video
  • 2 downloadable resources
  • Full lifetime access
  • Access on mobile and TV
  • Certificate of Completion
Training 5 or more people?

Get your team access to 4,000+ top Udemy courses anytime, anywhere.

Try Udemy for Business
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.
Course content
Expand all 47 lectures 02:54:53
+ What-If Analysis
8 lectures 34:22
Introduction
01:00
Exploring Scenarios - Overview
01:25
Exploring Scenarios
08:42
Goal Seek and Data Tables - Overview
03:17
Goal Seek
03:10
Data Tables
06:11
Using Solver - Overview
01:48
Using Solver
08:49
+ PivotTables
9 lectures 35:31
Introduction
01:02
Getting Started with PivotTables - Overview
01:00
Getting Started with PivotTables
04:53
Displaying Data in a PivotTable - Overview
01:09
Displaying Data in a PivotTable
09:07
Formatting a PivotTable - Overview
01:08
Formatting a PivotTable
08:19
Slicers - Overview
01:59
Slicers
06:54
+ Charting Pivoted Data
5 lectures 14:27
Introduction
00:58
Getting Started with PivotCharts - Overview
00:56
Getting Started with PivotCharts
04:33
PivotChart Tools and Formatting - Overview
00:43
PivotChart Tools and Formatting
07:17
+ Advanced Excel Tasks
8 lectures 29:22
Introduction
00:39
Excel and Hyperlinks - Overview
01:12
Excel and Hyperlinks
08:29
Using Custom AutoFill Lists - Overview
00:41
Using Custom AutoFill Lists
05:23
Sharing Workbooks - Overview
00:43
Sharing Workbooks
06:26
Tracking Changes
05:49
+ Creating HLOOKUP and VLOOKUP Functions
5 lectures 15:53
Introduction
00:54
Using the VLOOKUP Function - Overview
02:41
Using the VLOOKUP Function
05:44
Using the LOOKUP Function - Overview
01:48
Using the LOOKUP Function
04:46
+ Introduction to Macros in Excel
6 lectures 30:21
Introduction
01:05
Recording and Playing Macros - Overview
01:01
Recording and Playing Macros
13:05
The VBA Editor - Overview
01:48
The VBA Editor
05:25
Visual Basic and Macros
07:57