Buying for a Team? Gift This Course
Wishlisted Wishlist

Please confirm that you want to add Microsoft Excel - Level 3 - Advanced to your Wishlist.

Add to Wishlist

Microsoft Excel - Level 3 - Advanced

Learn advanced formatting techniques, how to work with Pivot Tables, Charts, record Macros & trace spreadsheet formulae
4.1 (4 ratings)
Instead of using a simple lifetime average, Udemy calculates a course's star rating by considering a number of different factors such as the number of ratings, the age of ratings, and the likelihood of fraudulent ratings.
30 students enrolled
Created by eLearnExcel
Last updated 9/2013
$10 $20 50% off
2 days left at this price!
30-Day Money-Back Guarantee
  • 1.5 hours on-demand video
  • Full lifetime access
  • Access on mobile and TV
  • Certificate of Completion
Have a coupon?
What Will I 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.
View Curriculum
  • Regular exposure to Excel to an intermediate level

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 is the target audience?
  • 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.
Students Who Viewed This Course Also Viewed
Curriculum For This Course
Expand All 31 Lectures Collapse All 31 Lectures 01:30:47
Advanced Formatting
7 Lectures 26:02

This section includes the exercise files for Excel Level 3. Please download these before you start the course.

Preview 00:24

Pivot Tables and Pivot Charts
5 Lectures 13:37

What is a Pivot table?

How to create a Pivot table

Working with an existing Pivot table

Slicer tool
7 Lectures 16:25

Recording a macro

Recording a macro using relative referencing

Deleting a macro

Assigning a macro to a command button on the Quick Access Toolbar

Applying modifications to a Macro
3 Lectures 07:32

The data form

Inserting form controls and setting their properties
Advanced Window Options
5 Lectures 18:35

Using New window

Linking workbooks

Advanced Worksheet protection
Working with Formulae
4 Lectures 08:36

Tracing formulae

Watch Window

Calculate options
About the Instructor
4.4 Average rating
145 Reviews
1,748 Students
6 Courses
Leading provider of Online Excel training

Our online eLearning courses build on 20 years experience of classroom training. Training is our business. The courses are delivered by our expert tutors and we know where topics become complex and need better explanations because we see it every day in our classrooms.

Some of the world’s most prominent businesses choose us to teach their employees Excel – including Google, Facebook, Pfizer, Zurich, Aer Lingus, Allianz, HSBC, Intel, Dell, KPMG – even Microsoft use our Excel courses to train their employees on Excel.

Report Abuse