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

LinkedIn Learning

Excel Formulas and Functions Quick Tips

via LinkedIn Learning

Write review
Unihackers Ad

Launch Your Cybersecurity Career in 6 Months

Learn More → Simplilearn Ad

Become an AI & ML Engineer with Cal Poly EPaCE — IBM-Certified Training

Learn More →

Overview

Google, IBM & Meta Certificates – 40% Off
One plan covers every Professional Certificate on Coursera.
Unlock All Certificates
Learn essential Excel skills, from basic formulas and functions to advanced data manipulation techniques in order to efficiently calculate, analyze, and organize data.

Syllabus

Introduction
  • Calculate data with ease in Excel
1. Formula and Function Basics
  • Build a formula in a cell with =
  • Create a named range
  • Reference cells and worksheets
  • Join text with an ampersand
  • Follow along with Excel when creating functions
2. Identifying Values
  • Calculate a total with SUM
  • Sum values that meet specific criteria with SUMIF
  • Find the mean value with AVERAGE
  • Test for valid data with IF
  • Create complex tests with AND and OR
  • Find record values with MAX, MIN, SMALL, and LARGE
  • Perform date calculations with TODAY()
3. Count Functions
  • Count cells that contain numbers with COUNT
  • Count nonblank cells with COUNTA
  • Return a number of occurrences with COUNTIF
  • Checking in on your course progress
4. Text Functions
  • Format numbers and dates with TEXT
  • Extract characters with LEFT AND RIGHT
  • Extract substrings with MID
  • Count characters with LEN
  • Identify where a character occurs with FIND
  • Join strings with delimiters with TEXTJOIN
  • Change text with SUBSTITUTE and REPLACE
5. Index, Match, and Lookups
  • Retrieve a specific value with XLOOKUP
  • Use INDEX and MATCH to retrieve a value
  • Use GROUPBY to aggregate data
  • Use PIVOTBY to aggregate data with more columns
6. Avoiding Errors and Invalid Formulas
  • Remove leading spaces with TRIM
  • Include IFERROR to trap errors in formulas

Taught by

Jess Stratton

Reviews

4.7 rating at LinkedIn Learning based on 2163 ratings

Start your review of Excel Formulas and Functions Quick Tips

Never Stop Learning.

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

Sign up for free
Someone learning on their laptop while sitting on the floor.