Loading…

Track Spreadsheets Fundamentals

Introduction to Formulas

10 / 13

Spreadsheets Fundamentals

Course Progress0/13

Getting Started

Introduction to Spreadsheets Understanding the Spreadsheet Interface

Working with Data

Sorting Data Filtering Data

Formatting

Format Numbers as Currency Format Numbers as Percentages Adjusting Decimal Places

Tables & Basic Summaries

Introduction to Data Summaries Creating a Summary Table

Basic Formulas

Introduction to Formulas SUM and AVERAGE Formulas MIN and MAX Formulas COUNT and COUNTA Formulas

Spreadsheets (Excel/Google Sheets)Spreadsheets FundamentalsBasic Formulas

Introduction to Formulas

5 min read

Reading

Introduction to Formulas

What is a Formula?

A formula is an instruction that tells the spreadsheet to calculate something. Formulas always start with an equals sign (=).

Basic Formula Types

Arithmetic

=A1+B1 (addition)
=A1-B1 (subtraction)
=A1*B1 (multiplication)
=A1/B1 (division)

Functions

Functions are pre-built formulas:

=SUM(A1:A10) - Add up values
=AVERAGE(A1:A10) - Calculate mean
=COUNT(A1:A10) - Count numbers
=MIN(A1:A10) - Find smallest
=MAX(A1:A10) - Find largest

How Formulas Update

The magic of spreadsheets: when you change data, formulas automatically recalculate!

Change a sales number → Totals and averages update instantly.

In This Module

You'll master:

SUM and AVERAGE
MIN and MAX
COUNT and COUNTA

Let's start calculating!

Lesson 1 of 4 in Basic Formulas