Microsoft Excel Professional
3.8 (9 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.
3,364 students enrolled

Microsoft Excel Professional

Becoming a Professional user of Microsoft Excel
3.8 (9 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.
3,364 students enrolled
Created by ZandaX Training
Last updated 3/2019
English
English [Auto-generated]
Current price: $11.99 Original price: $19.99 Discount: 40% off
23 hours left at this price!
30-Day Money-Back Guarantee
This course includes
  • 2.5 hours on-demand video
  • 2 downloadable resources
  • 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
  • This intensive hands-on one-day training course has been designed to provide delegates with a very advanced set of tools and concepts for Excel 2007, 2010, 2013 or 2016 in order to further increase their knowledge and productivity.
Requirements
  • Delegates should have a good working knowledge and understanding of the concepts covered in the Introduction, Intermediate and Advance courses.
Description

MODULE 1:  Advanced Conditional Formatting

Learning outcomes:  Looking at the more advanced Conditional Formatting features and how to manage them effectively.

Topics covered:

  • Editing Standard Formatting Rules

  • Using Formulas in Conditional Formatting

MODULE 2:  Using Form Controls and Templates

Learning outcomes: Introducing Form controls and using them to manage user interaction  to help ensure they enter/search for information both accurately and  effectively.

Topics covered:

  • Using Form Controls

  • Creating Templates

MODULE 3:  Advanced Lookup Functions

Learning outcomes:  An in-depth look into Excel's specialist lookup functions and the concept of arrays.

Topics covered:

  • Using the Index Function

  • Using the Match Function

  • Using Index and Match Together

  • Using Index and Match with Array Formula

  • Using the Indirect Function

MODULE 4:  Advanced Functions in Excel

Learning outcomes:  Effectively using Error, Logical and Rounding functions along with array formulas.

Topics covered:

  • Using Error Functions

  • Using Logical Functions

  • Using Array Formulas

  • Using Rounding Functions

MODULE 5:  Advanced Pivot Table Tools

Learning outcomes:  How to import Pivot Table data from external source along with adding custom fields and formulas.

Topics covered:

  • Importing Pivot Table Data

  • Calculated Fields in Pivot Tables

  • Showing Pivot Data as a Percentage

  • Creating Custom Pivot Tables Styles

MODULE 6:  Introduction to User Defined Functions Using VBA

Learning outcomes:  Using VBA to create specialist procedure and to define your own Excel functions.

Topics covered:

  • Creating a User Defined Function

  • Creating an Interactive Procedure

  • Create and Share a Function Add-in

Who this course is for:
  • Users with a solid understanding of, and experience with, Microsoft Excel 2007, 2010, 2013 or 2016 who want to increase their ability in a short space of time.
Course content
Expand all 52 lectures 02:44:08
+ Using Form Controls and Templates
5 lectures 20:06
Introduction
01:27
Using Form Controls - Overview
01:03
Using Form Controls
11:21
Creating Templates - Overview
00:39
Creating Templates
05:36
+ Advanced Lookup Functions
11 lectures 31:37
Introduction
02:33
Using the Index Function - Overview
01:18
Using the Index Function
03:19
Using the Index Function
02:44
Using the Match Function - Overview
01:33
Using the Match Function
02:03
Using Index and Match Together - Overview
00:56
Using Index and Match Together
05:27
Using Index and Match Together
05:11
Using the Indirect Function - Overview
02:09
Using the Indirect Function
04:24
+ Advanced Functions in Excel
12 lectures 36:08
Introduction
01:29
Using Error Functions - Overview
01:37
Using Error Functions
06:18
Conditional Error Functions
04:33
Using Logical Functions - Overview
00:48
Using Logical Functions
03:36
Using Array Formulas - Overview
02:08
Using Array Formulas
03:13
Using Array Formulas
02:12
Using Array Formulas
03:33
Using Rounding Functions - Overview
00:54
Using Rounding Functions
05:47
+ Advanced Pivot Table Tools
9 lectures 27:20
Introduction
01:16
Importing Pivot Table Data - Overview
00:57
Importing Pivot Table Data
05:29
Calculated Fields in Pivot Tables - Overview
00:56
Calculated Fields in Pivot Tables
05:21
Showing Pivot Data as a Percentage - Overview
01:00
Showing Pivot Data as a Percentage
06:41
Creating Custom Pivot Tables Styles - Overview
00:47
Creating Custom Pivot Tables Styles
04:53
+ Introduction to User Defined Functions Using VBA
7 lectures 32:23
Introduction
01:35
Creating a User Defined Function - Overview
00:57
Creating a User Defined Function
10:12
Creating an Interactive Procedure - Overview
00:40
Creating an Interactive Procedure
09:26
Create and Share a Function Add-in - Overview
01:10
Create and Share a Function Add-in
08:23