[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 Control
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