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.
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?
LEARNING OBJECTIVES
- 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
WHO WILL BENEFIT?
Any company/individual who uses Microsoft Office and spreadsheets.
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?
- 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
Any company/individual who uses Microsoft Office and spreadsheets.
