Advanced Excel Training
3.8 (26 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.
100 students enrolled

Advanced Excel Training

Looking To Finally Be An Advanced Excel User?
3.8 (26 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.
100 students enrolled
Created by Corinne Bonet
Last updated 10/2017
English
English [Auto]
Current price: $11.99 Original price: $19.99 Discount: 40% off
3 days left at this price!
30-Day Money-Back Guarantee
This course includes
  • 4 hours on-demand video
  • 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
  • Create complicated, problem-solving formulas with advanced logic, master Pivot Tables, automate complex tasks and much more...
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.
Course content
Expand 38 lectures 03:48:20
+ Introduction
38 lectures 03:48:20
Using ROUND
03:47
TEXT
03:42
Using TEXT
05:29
The LEN Function
03:42
The REPLACE Function
05:19
Using REPLACE And LEN
07:11
The IF Function
05:34
Using IF
06:41
More On IF
09:36
Using LEFT, RIGHT & MID
03:49
The CONCATENATE Function
02:23
Using UPPER, LOWER & PROPER
03:17
The TRIM Function
04:52
Using VALUE
07:18
Working With Multiple Sheets
04:29
Drop Down
06:05
A Real World Scenario
03:13
Using COUNTIF & COUNTA
07:26
COUNT Together
09:45
Relative & Absolute
04:21
Mulitiplying Text
04:03
The PMT Function
11:28
Introduction To Macros
09:40
More On Macros
09:46
Editing Macros
07:36
Macro Notes
03:41
Using VLOOKUP
05:33
Creating a VLOOKUP Invoice
05:55
VLOOKUP & IF
06:43
SUBTOTAL
08:04
Using HLOOKUP
11:15
Introduction To Pivot Tables
04:53
Pivot Table Options
09:36
Pivot Charts
04:07
Goal Seek
06:40
Conclusion
00:54