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

YouTube

Excel Formulas for Beginners

Simon Sez IT via YouTube

Start learning Write review
University of the People Ad

Earn Your CS Degree, Tuition-Free, 100% Online!

Learn More → Noble Desktop Ad

NY State-Licensed Certificates in Design, Coding & AI — Online

Learn More →

Overview

Google, IBM & Meta Certificates – 40% Off
One Coursera Plus subscription covers most Professional Certificates on Coursera.
Unlock All Certificates
This beginner course introduces Excel formulas and functions for calculations and data handling. It covers operators, common statistical and text functions, absolute and relative references, named ranges, logical formulas, VLOOKUP, and error checking.

Syllabus

- Agenda
- What are formulas and functions
- Using SUM, Autosums, and Autofill
- Understanding Excel Operators and the BODMAS rule
- Using Average, MIN, MAX, COUNT and COUNTA
- Absolute vs. Relative Referencing
- Using Named Ranges in Formulas
- Text Functions
- VLOOKUP

Taught by

Simon Sez IT

Reviews

Start your review of Excel Formulas for Beginners

Start learning

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.