Excel Calculations
+3

Excel Calculations

00030
$325.00
In stock
1
Product Details

Upcoming Classes

5/13/2024 - 9:00am to 4:00pm

WE OFFER FLEXIBLE SCHEDULING, SO PLEASE REQUEST AN ALTERNATE CLASS DATE OR TIMEFRAME IF NEEDED!

Course Description

If you have ever looked through calculations built by other people or perhaps the long list of built-in Excel functions and wondered what it all means, then Excel Calculations is for you! Topics covered offer an in-depth view of building your own simple to more complex formulas, utilizing built-in functions, and special calculation features for interpretation and troubleshooting. Be prepared to crunch some numbers during this session!

Prerequisite

Excel Basics and Intermediate or equivalent experience

Software Version

Microsoft (Office) 365, 2021, 2019, 2016

Course Highlights

  • Relative and absolute cell references
  • Creating linked formulas
  • 3-D References
  • Creating and using named references
  • Nested functions
  • Array formulas
  • Calculating percentages and averages
  • Conditional Calculations (IF, VLOOKUP, HLOOKUP, XLOOKUP, etc)
  • Date and Time functions (TODAY, NOW, DAYS360, NETWORKDAYS, ISO/WEEKNUM)
  • Math and statistical functions (ROUND/UP/DOWN, SUMIF, COUNTIF, MIN, MAX, MEDIAN, MODE)
  • Database functions (DAVERAGE, DCOUNT, DGET, DMAX, DMIN)
  • Text functions (TRIM, UPPER, LOWER, PROPER, CONCAT)
  • Formula Auditing Tools
Save this product for later
Share by: