Excel Formulas

Jenny Douras

Duration:
60 Minutes
Speaker:
Jenny Douras

Recorded Version:

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?


Agenda:

• 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.

Recorded Version:


Instructor:

Jenny Douras

Speaker

Jenny Douras is President and founder of AdvantEdge Training & Consulting and is a national speaker conducting workshops across the country. She has over 25 years of experience in management, employee development, operations, knowledge management, technology, organizational development, and instructional design and training. She has written over 40 courses on Microsoft Office and Professional Development topics, that have been sold around the world.