[Udemy 100% Free]-Microsoft Excel Professional - 100% Free Udemy Discount Coupons For Online Courses


Friday, January 25, 2019

[Udemy 100% Free]-Microsoft Excel Professional

[Udemy 100% Free]-Microsoft Excel Professional


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

No comments:

Post a Comment