Earn a Michigan Engineering AI Certificate — Stay Ahead of the AI Revolution
Learn AI, Data Science & Business — Earn Certificates That Get You Hired
Overview
Google, IBM & Meta Certificates – 40% Off
One plan covers every Professional Certificate on Coursera.
Unlock All Certificates
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
Taught by
Simon Sez IT