On this class you will learn advanced functions including LOOKUPS, Date and Time Functions, Text Functions, Statistical Functions, and Financial Functions. You will learn how to import and export data using the Power Pivot Data model and analysis data using What-If Analysis, Scenarios and Goal Seeker. Finally you will learn to automate tasks using Macros and capture user input using Forms.
What's Included:
- An Excel training manual
- Certificate of course completion
- Small class sizes
- FREE repeat valid for 6 months
DETAILED COURSE OUTLINE
Logical and Lookup Functions:
- The IF Function
- Conditional Calculations
- Using SUMIF
- VLOOKUPS and HLOOKUPS
- Range LOOKUPS
Advanced Formulas
- Auditing and Error Trapping
- Formula Options
- Array Functions
- Using TRANSPOSE
Special Functions:
- Date and Time Functions
- TODAY
- NOW
- DATE
- Date Calculations
- Text Functions
- Using CONCATENATE and TRIM
- Using UPPER, LOWER and PROPER
- Extracting Text
- Statistical Functions
- Using MIN and MAX
- Using COUNT, COUNTA and COUNTBLANK
- Financial Functions
- Using FV
- Using PMT
Importing and Exporting:
- The Power Pivot Data Model
- Importing Data
- Using Power Pivot
- Exporting Data
Data Analysis:
- What-if Analysis
- Scenarios
- Using Goal Seek
- The Analysis Toolpak
Macros and Forms:
- Recording Macros
- Running Macros
- Running Macros when Workbook is Open or Closed
- Using Forms to Record Input
