Microsoft Excel - Level 3 - Advanced

Learn advanced formatting techniques, how to work with Pivot Tables, Charts, record Macros & trace spreadsheet formulae
4.2 (3 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.
29 students enrolled
$19
$20
5% off
Take This Course
  • Lectures 31
  • Length 1.5 hours
  • Skill Level All Levels
  • Languages English
  • Includes Lifetime access
    30 day money back guarantee!
    Available on iOS and Android
    Certificate of Completion
Wishlisted Wishlist

How taking a course works

Discover

Find online courses made by experts from around the world.

Learn

Take your courses with you and learn anywhere, anytime.

Master

Learn and practice real-world skills and achieve your goals.

About This Course

Published 9/2013 English

Course 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.

What are the requirements?

  • Regular exposure to Excel to an intermediate level

What am I going to get from this course?

  • 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.

What 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.

What you get with this course?

Not for you? No problem.
30 day money back guarantee.

Forever yours.
Lifetime access.

Learn on the go.
Desktop, iOS and Android.

Get rewarded.
Certificate of completion.

Curriculum

Section 1: Advanced Formatting
00:24

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

Orientation of text
Preview
04:02
Merge and centre options
Preview
04:00
Wrap text
Preview
03:31
Custom formats
Preview
06:34
Find and Select Options
Preview
02:59
Paste special options
Preview
04:32
Section 2: Pivot Tables and Pivot Charts
Introduction
Preview
00:19
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
Section 3: Macros
Introduction
Preview
00:31
Running an existing Macro
Preview
02:02
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
Section 4: Forms
Introduction
Preview
00:16
The data form
02:06
Inserting form controls and setting their properties
05:10
Section 5: Advanced Window Options
Introduction
Preview
00:33
Arrange windows
Preview
04:15
Using New window
03:17
Linking workbooks
04:27
Advanced Worksheet protection
06:03
Section 6: Working with Formulae
Introduction
Preview
00:16
Tracing formulae
03:44
Watch Window
02:12
Calculate options
02:24

Students Who Viewed This Course Also Viewed

  • Loading
  • Loading
  • Loading

Instructor Biography

eLearnExcel, 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.

Ready to start learning?
Take This Course