Excel Practice for Free

Excel Beginner Cover

Training for Beginners

  1. Create an invoice
  2. 4 situations to do basic calculations with Excel
  3. How to use the functions SUM, MIN, and MAX?
  4. Use Dollars in your formula
  5. Calculate the income of the week.
  6. Create a drop-down menu

Advanced Cover

Conditional functions

  1. Logical Test – Beginner Level
  2. Logical Test – Intermediate Level
  3. Training Logical Test – AND and OR functions
  4. Manage the inventory of your products (IF function)
  5. Training to learn how to write Nested IF
  6. Evaluate your level with the IF, IFS, and IFERROR functions
  7. Test Your Skills with COUNTIF and COUNTIFS
  8. Training with the SUMIF and SUMIFS functions
  9. Step-by-step guide SUMIF function
  10. Exercise SUMIF – Questions and Answers

Excel Practice for Free

Tutorial for Beginners