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 of 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 you should 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?
Areas Covered in the Session:
- 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
Speaker
Jenny Douras is President at AdvantEdge Training & Consulting. She has over 25 years of experience in management, employee development, operations, instructional design and training. Jenny has managed teams of up to 300 people across multiple states and countries, working with several Fortune 500 clients. From this experience she developed her Remote Employee Management Class. She also sat on the board of directors for the Rocky Mountain Chapter of the American Society for Training and Development for three years, and is an active member of the Colorado training community.
Who Should Attend
- Business users who use Microsoft Office and use spreadsheets.
