Top 15 Most Useful Excel Formulas

Go to class
Write Review

Free Online Course: Top 15 Most Useful Excel Formulas provided by Skillshare is a comprehensive online course, which lasts for 1-2 hours worth of material. The course is taught in English and is free of charge. Top 15 Most Useful Excel Formulas is taught by Ruben Wollerich.

Overview
  • In this class I discuss the 15 most useful Excel formulas. 

    Everyone lesson covers a (group of) formula(s). The videos are built up in three ways:
    1. What does the formula do?
    2. What is it used for?
    3. Demonstration

    This class helps you to gain a head start in using Excel. These formulas are the basis of building more complex and useful formulas. 

    Attached, is the file used for the formulas. In case you want to look back into how the formulas are built up, feel free to download the spreadsheet and dive into it!

    Enjoy the class!

Syllabus
    • Introduction
    • Class Outline
    • NOW & TODAY
    • SUM(IFS)
    • COUNT(IFS)
    • AVERAGE(IFS)
    • MIN & MAX
    • CONCAT / &
    • TRIM
    • UPPER, lower & Proper
    • IF
    • AND / OR
    • NOT
    • RIGHT, LEFT & LEN
    • PMT
    • VLOOKUP
    • IFERROR