Advanced Excel Training

Name: Advanced Excel Training
Rating: 4.1 (200 reviews)

Looking To Finally Be An Advanced Excel User?

Created byCorinne Bonet

Last updated 10/2017

English

What you'll learn

Create complicated, problem-solving formulas with advanced logic, master Pivot Tables, automate complex tasks and much more...

Course content

1 section • 38 lectures • 3h 48m total length

Introduction3:19
The ROUND Function7:08
Using ROUND3:47
TEXT3:42
Explore how the Excel text function converts numbers to text strings, enabling currency formatting and character-level edits to digits, and how to integrate it into formulas.
Using TEXT5:29
The LEN Function3:42
The REPLACE Function5:19
Using REPLACE And LEN7:11
The IF Function5:34
Using IF6:41
More On IF9:36
Using LEFT, RIGHT & MID3:49
The CONCATENATE Function2:23
Using UPPER, LOWER & PROPER3:17
The TRIM Function4:52
Using VALUE7:18
Working With Multiple Sheets4:29
Drop Down6:05
A Real World Scenario3:13
Using COUNTIF & COUNTA7:26
COUNT Together9:45
Relative & Absolute4:21
Mulitiplying Text4:03
The PMT Function11:28
Introduction To Macros9:40
More On Macros9:46
Editing Macros7:36
Macro Notes3:41
Using VLOOKUP5:33
Creating a VLOOKUP Invoice5:55
VLOOKUP & IF6:43
Use vlookup and if to populate invoice fields only when a product id exists, leaving blanks otherwise, with a default quantity and dropdowns to build a mini database.
SUBTOTAL8:04
Using HLOOKUP11:15
Introduction To Pivot Tables4:53
Pivot Table Options9:36
Pivot Charts4:07
Goal Seek6:40
Conclusion0:54

Requirements

A working knowledge of Excel

Description

Do you have an intermediate understanding of Excel but are keen to break through to true mastery? Want to finally use the programme with ease and confidence at work and become known as an expert user?

With this course you will learn how to create and format Pivot Tables, automate complex tasks with Macros, learn few functions and formulas and much more. You can learn what you need as quickly as possible, with as little
hassle as possible.

When you're finished with this course, you'll be a pro at Excel.

Who this course is for:

Our Advanced Excel course is suitable for those with a sound working knowledge of Excel who wish to progress to the most complicated functions and features.