LESSON 5
Excel Functions
Skills you will learn in this section:
- Overview & Finding Excel Functions from Insert Function
- COUNT, COUNTA, COUNTBLANK
- COUNT based on a Condition (COUNTIFS)
- SUM & AVERAGE Functions in Excel
- SUM by Criteria (SUMIFS, AVERAGEIFS)
- MAX & MIN (MAXIFS & MINIFS)
- Rounding Values (ROUND, ROUNDUP & ROUNDOWN)
- Essential Excel Date Functions
- Time Calculations in Excel – Total Time Worked
- Handling Excel Formula Errors
- IF (Then, Else) Excel Function – Conditional Formulas
- VLOOKUP Function – Lookup Values from Another Place
- Summary: Important Excel Functions (text file)
Watch the video lessons below, you can post your questions in the comment box below this page.
