Become the office Excel Diva or Guru by learning how to unlock the power of functions. Learn 40 must-know functions like SumIf, Concatenate, If, VLookup, and many more. Nest (combine) functions to take them to the next level. Learn how to use Excel’s “What If” tools (Goal Seek, Solver, Scenarios, & Data Tables), create simple recorded Macros, and add user-friendly Worksheet Controls to your spreadsheets such as buttons, sliders, checkboxes, and spin buttons.
Topics Covered:
- Basic Functions: Sum, Average, Max, and Min
- Counting Functions: Count, CountA, CountBlank, CountIf, & CountIfs
- Summing Functions: SumIf, SumIfs, & SumProduct
- Average Functions: AverageIf & AverageIfs
- If Functions: If, Ifs, IfError, If And, & If Or
- Lookup Functions: VLookup, HLookup, & XLookup
- Financial Functions: PMT & FV
- Text Functions: Concatenate, Text Join, Trim, Upper, Lower, Proper, Left, Right, & Mid
- Date & Time Functions: Today, Now, Day, Month, & Year
- Nested Functions (combine different functions)
- "What If" Tools: Goal Seek, Solver, Scenarios, & Data Tables
- Basic Recorded Macros
- Worksheet Controls: Buttons, Sliders, Checkboxes, & Radio Buttons
Sign in
Gift vouchers
Category