Microsoft Excel - Level 3 - Advanced
4.4 (18 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.
77 students enrolled

Microsoft Excel - Level 3 - Advanced

Learn advanced formatting techniques, how to work with Pivot Tables, Charts, record Macros & trace spreadsheet formulae
4.4 (18 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.
77 students enrolled
Created by eLearnExcel
Last updated 9/2013
English
English [Auto]
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
  • 1.5 hours on-demand video
  • 1 downloadable resource
  • 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 course introduces the power of Pivot Tables and Recording Macros. Pivot tables let us report and manipulate huge amounts of data quickly and easily. Learning the foundations of Macros can save you huge amounts of time by automating repetitive tasks.
Requirements
  • Regular exposure to Excel to an intermediate level
Description

This course covers the advanced tools in Excel. You’ll learn how to create custom cell formats. You’ll start to learn about Pivot Tables, the slicer tool, Macros and how to record steps to common tasks. You’ll learn how to trace and watch changes with cells and formulae.

Who this course is for:
  • Anyone who has completed the Excel Level 2 course and is looking for more knowledge on Excel – in particular anyone looking to learn the foundations of working with Pivot Tables and basic Macros. If you work with Excel extensively, this course will benefit you.
Course content
Expand all 31 lectures 01:30:47
+ Pivot Tables and Pivot Charts
5 lectures 13:37
What is a Pivot table?
00:42
How to create a Pivot table
04:25
Working with an existing Pivot table
04:35
Slicer tool
03:36
+ Macros
7 lectures 16:25
Recording a macro
01:51
Recording a macro using relative referencing
04:09
Deleting a macro
00:59
Assigning a macro to a command button on the Quick Access Toolbar
02:52
Applying modifications to a Macro
04:01
+ Forms
3 lectures 07:32
The data form
02:06
Inserting form controls and setting their properties
05:10
+ Advanced Window Options
5 lectures 18:35
Using New window
03:17
Linking workbooks
04:27
Advanced Worksheet protection
06:03
+ Working with Formulae
4 lectures 08:36
Tracing formulae
03:44
Watch Window
02:12
Calculate options
02:24