Top 15 Most Useful Excel Formulas

Offered By: Skillshare

Course Description

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

Taught by

Ruben Wollerich

Related Courses

Introduction to Computational Finance and Financial Econometrics
University of Washington via Coursera Excel 2010
Miríadax The Finance of Retirement & Pensions
Stanford Graduate School of Business via NovoEd Einführung in die Wahrscheinlichkeitstheorie
Johannes Gutenberg University Mainz via iversity Introduction to VBA/Excel Programming
Cal Poly Pomona via Open Education by Blackboard