Microsoft Excel - Level 3 - Advanced
4.3 (5 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.
38 students enrolled
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.3 (5 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.
38 students enrolled
Created by eLearnExcel
Last updated 9/2013
English
Current price: $10 Original price: $20 Discount: 50% off
2 days left at this price!
30-Day Money-Back Guarantee
Includes:
  • 1.5 hours on-demand video
  • Full lifetime access
  • Access on mobile and TV
  • Certificate of Completion
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
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 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
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?
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
About the Instructor
eLearnExcel
4.2 Average rating
174 Reviews
1,838 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.