Human Resources
60 Minutes
Friday, November 17,2023
- Sunday, December 31,2023
STA2023138
Overview
Are you new to Excel and need to learn how to write basic formulas in the software? Have you inherited a spreadsheet from someone else, and you need to be able to decipher all of the formula code to figure out what is going on with it, or how to modify it? Learn how to unlock the mysteries of formulas in Excel with this session. Learn how to write basic formulas that can automate your worksheets. Learn the difference between Functions and Formulas and how to use these powerful tools in Excel. Learn tools to help you decipher and create more advanced formulas with the Function Library as you develop your skills.
Who should attend?
Any company/individual who uses Microsoft Office and spreadsheets.
Why should you attend?
New to Excel and need to understand formulas. Inherited a spreadsheet from someone else, and you need to figure out what is going on with it and how it works?
What you'll learn?
- Basic formulas and how they work in Excel
- Order of operations in formulas
- Addition, subtraction, multiplication, and division formulas
- Simple Cell References
- Writing more complex formulas
- Copying and pasting formulas
- 3D formulas
- Overview of functions and syntax
- Function Library helpers