Excel Formulas 1: Cell References, SUM, COUNT and Rounding
25 000 Kz + VAT
A full unit on cell references followed by fourteen short lessons on COUNT and SUM, COUNTIF, SUMIF, running totals, counting characters and cells, SUMPRODUCT, rounding, AVERAGE and RANK.
- FieldIT & Digital Productivity
- Level1 · Foundation
- Duration1 h 30 min
- Course languageEnglish
- IncludesNarrated videos, interactive activities, final assessment and a verifiable certificate
Instant course access as soon as payment is confirmed.
A full unit on relative, absolute and mixed cell references, with practice files and a quiz, followed by short screen-recorded lessons on the functions used every day: COUNT and SUM, COUNTIF, running totals, SUMIF, counting characters, the SUM function, counting blank and non-blank cells, the 'not equal to' operator, counting cells with text, SUMPRODUCT, rounding, reducing decimals, AVERAGE and RANK. Recorded in Microsoft 365 (English function names). Based on UK best practice. Course in English. Permanent access to the course. Trident Academy certificate on completion of all fifteen units.
Modules
- Excel Cell References24 min
- COUNT & SUM Functions6 min
- The COUNTIF Function7 min
- Running Totals4 min
- SUMIF Functions7 min
- Counting Characters5 min
- The SUM Function5 min
- Counting Blank & Non-Blank Cells5 min
- The 'Not Equal To' Operator5 min
- Counting Cells with Text4 min
- The SUMPRODUCT Function5 min
- Rounding Functions3 min
- Reducing Decimals3 min
- The AVERAGE Function5 min
- The RANK Function4 min
Only logged in customers who have purchased this product may leave a review.
Related products
-
New
-
New
Reviews
There are no reviews yet.