Home / Course catalog / Excel level 1 – 3 Core calcula... (Bus_Excel_01-03)

Business tools

Excel level 1 – 3 Core calculations for totals and counts (Bus_Excel_01-03)


Description

This module helps you apply core calculations confidently to support billing and basic reporting. It directly addresses the need to use SUM, AVERAGE, COUNT and related functions to produce reliable totals and counts, including percentages and simple date calculations that are common in operational follow‑up.

Content
  • Quick Calculations with the Status Bar
  • Basic formulas and functions
  • How to calculate a percentage of a number
  • How to calculate average (mean)
  • Date functions
  • Optional : COUNTIF function
  • Optional : SUMIF function
  • Use ROUND to Fix Money Math Errors
Completion rules
  • All units must be completed