Excel Formulas for Beginners

Overview

Save Big on Coursera Plus. 7,000+ courses at $160 off. Limited Time Only!

Grab it

Learn essential Excel formulas and functions in this comprehensive 1-hour webinar. Master the basics of calculations, including the BODMAS rule, and progress to advanced formulas like VLOOKUP and nested IF statements. Explore SUM, AVERAGE, MIN, MAX, and COUNT functions, as well as Autofill and Named Ranges. Gain proficiency in Absolute vs Relative Referencing, Text Functions, and error checking. Follow along with downloadable instructor files and benefit from useful keyboard shortcuts, tips, and tricks to enhance your Excel skills.

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