Excel Formulas You Need to Know in 30 Minutes!
Excel Formulas You Need to Know in 30 Minutes!
Duration: 34m | .MP4 1280x720, 30 fps(r) | AAC, 48000 Hz, 2ch | 236 MB
Genre: eLearning | Language: English
Duration: 34m | .MP4 1280x720, 30 fps(r) | AAC, 48000 Hz, 2ch | 236 MB
Genre: eLearning | Language: English
Learn essential Excel formulas and functions in 30 minutes!
Excel is an incredibly useful piece of software, but you can only begin to make the most of it once you have a basic understanding of formula writing, functions, and cell referencing. In this class, we'll cover all of those topics.
Who is this class for?
If you're a beginner who is completely new to Excel, or are looking for a refresh of the basics, then this class is for you!
At the end of the class you'll:
Understand how to use many of the most popular and commonly used formulas, helping you to analyze information in Excel quickly and easily.
What does the class cover?
The class is broken out into nine short videos covering the following topics:
Introduction
Arithmetic and basic formulas
Cell Referencing
SUM, COUNT, COUNTA, AVERAGE, MIN, MAX
SUMIF, COUNTIF, AVERAGEIF
SUMIFS, COUNTIFS, AVERAGEIFS
VLOOKUP
HLOOKUP
LOWER, UPPER, TRIM, PROPER
CONCAT
How do I practice or follow along?