A Beginner’s Guide to Excel Formulas

Introduction

This short webinar will provide a complete beginner’s guide to writing formulas in Excel.

Build a strong understanding of the fundamentals to using Excel formulas and learn 'real world' applications such as calculating percentages, working with dates and different techniques for referencing data.

What You Will Learn

This webinar will cover the following:

• How to write formulas to add, subtract, multiply, divide
• Calculating percentages in Excel
• Using Excel functions to sum, count, average
• Working with dates in formulas
• Difference between relative and absolute references
• Referencing data on other worksheets, workbooks, named ranges and within tables

This webinar was recorded on 18th August 2020