YoVDO

Microsoft Excel Formulas You Need to Know in 30 Minutes!

Offered By: Skillshare

Tags

Microsoft Excel Courses Data Analysis Courses VLOOKUP Function Courses

Course Description

Overview

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:

  1. Introduction
  2. Arithmetic and basic formulas
  3. Cell Referencing
  4. SUM, COUNT, COUNTA, AVERAGE, MIN, MAX
  5. SUMIF, COUNTIF, AVERAGEIF
  6. SUMIFS, COUNTIFS, AVERAGEIFS
  7. VLOOKUP
  8. HLOOKUP
  9. LOWER, UPPER, TRIM, PROPER
  10. CONCAT

How do I practice or follow along?

You can download the Excel file that's used in the videos to practice all the formulas and functions either as you watch the class, or afterwards :)


Syllabus

  • Introduction
  • Why Excel
  • 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

Taught by

Excel Classes

Related Courses

Microsoft Excel بحث و ترتيب وتصفية البيانات فى
Coursera Project Network via Coursera
Analyzing Data in Spreadsheets
DataCamp
Usar Funciones y Fórmulas Básicas en Excel
Coursera Project Network via Coursera
Introduction to Data Analysis using Microsoft Excel
Coursera Project Network via Coursera
Working with Real-Time Data in Excel
LinkedIn Learning