Class Central is learner-supported. When you buy through links on our site, we may earn an affiliate commission.

Skillshare

Top 15 Most Useful Excel Formulas

via Skillshare

Overview

Save Big on Coursera Plus. 7,000+ courses at $160 off. Limited Time Only!

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

Taught by

Ruben Wollerich

Reviews

Start your review of Top 15 Most Useful Excel Formulas

Never Stop Learning.

Get personalized course recommendations, track subjects and courses with reminders, and more.

Someone learning on their laptop while sitting on the floor.