Spreadsheet Success in a Box

Introduction

This 3 part webinar box set will provide you with a guide to the fundamentals of Excel formulas, how to use the write, add, subtract, multiply and divide functions along with tips and tricks for spreadsheet success.

What You Will Learn

The box set includes the following:

Module 1 - A Beginner’s Guide to Excel Formulas

This module 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. 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

Module 2 - Creative & Effective Excel Charts - Tips & Tricks for Spreadsheet Success

This module will provide you with an introduction to creating charts and some tips and tricks for working with them:

• How to create charts
• Useful formatting options
• Working chart templates
• Build charts to measure actuals against targets
• Make your Excel charts interactive
• Using dynamic and creative chart labels

Module 3 - Dynamic Arrays for 365 Users

This is an important topic only available to those users on Microsoft 365 and it seriously changes how formulas work so is important for users to know.

• What are dynamic arrays and how do they affect the formulas you write including existing functions such as IF, SUMIFS, VLOOKUP
• Key things to know about using dynamic arrays
• The new #CALC! and #SPILL! formula errors
• Using the new Excel functions - FILTER, SORT, UNIQUE, SEQUENCE
• Dynamic arrays with existing Excel features such as tables, charts and data validation

This webinar was recorded on 15th December 2020