Excel for Beginners – Formula Bootcamp
In this members-only recorded webinar, we show you how to get started creating formulas in Excel. This 1-hour session is perfect if you are new to Excel or are just looking to brush up on the basics. Download the Excel workbook and follow along!
In this session you will learn:
- What are formulas and functions
- How calculations work
- Using SUM, Autosum, and Autofill
- Understanding Operators and the BODMAS rule
- Using Average, MIN, MAX, COUNT, and COUNTA
- Absolute vs. Relative Referencing
- Using Named Ranges in formulas
- Useful Functions – Text Functions, UNIQUE, CONCAT
- The VLOOKUP function
- Error checking functions
- Useful keyboard shortcuts, tips and tricks
Download the file that Debs uses and follow along here.
Adam Lacey
Adam Lacey is an Excel enthusiast and online learning expert. He combines these two passions at Simon Sez IT where he wears a number of different hats.When Adam isn't fretting about site traffic or Pivot Tables, you'll find him on the tennis court or in the kitchen cooking up a storm.
