Free courses from frontend to fullstack and AI
Live Online Classes in Design, Coding & AI — Small Classes, Free Retakes
Overview
Google, IBM & Meta Certificates — All 10,000+ Courses at 40% Off
One annual plan covers every course and certificate on Coursera. 40% off for a limited time.
Get Full Access
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