Excel Formulas and Functions 101
Summary
Duration: 60 mins
Although it is perfectly possible to use Excel without ever creating a formula or using a function - if you don’t, you’re missing out on a huge part of the application’s power. Without formulas and functions, you would not be able to perform data analysis and reports.Formulas and functions ensure that your data you are analyzing and reporting on is accurate. They allow you to move through your spreadsheets much faster by automating your quick and long-winded calculations. Join us to learn through live demonstrations of using Excel formulas and functions, starting with the basics and moving to more complex functions.
Topics covered:
- Start with the basic formulas that you can build on later
- Parentheses in formulas - Why it's crucial for data accuracy
- Copying and pasting formulas - The gotchas you need to know about
- Assign names to your cells - Refer to data by name and easily find important figures in elaborate workbooks
- SUM, AVERAGE and COUNT functions - Speed up your work with these functions for large data
- The IFERROR function - Get notified of errors immediately
Why you should attend
Let Excel solve problems for you. Learning how to create formulas will automate your calculations and save you a ton of time. No more using your fingers, mental arithmetic, or the calculator app on your Smartphone!Who should attend
This session is aimed at anyone who uses Excel at a basic level and wants to learn how to create formulas. The training will be delivered using the latest version of Excel for Windows however all of the functionality is also available to users of earlier versions of Excel.
About the Speaker
Mike Thomas has worked in the IT training business since 1989. He is a subject matter expert in a range of technologies including Microsoft Office and Apple Mac. Mike has produced nearly 200 written and video-based Excel tutorials, and hundreds of courses and webinars on a wide variety of technology-related topics.
Mike is a Fellow of The Learning and Performance Institute and has worked with and for a large number of global and UK-based companies and organizations across a diverse range of sectors.
In addition to training, he also designs and develops Microsoft Office-based solutions that automate key business tasks and processes.