Human Resources
Excel Formulas
CWS2024250
60 Minutes
Dec 20,2024 - Jan 31,2025
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
Ms. Jenny Douras
Jenny Douras is the 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 specializes in Managing Remote Employees and has managed teams of up to 300 people across multiple states and countries. She has worked with many Fortune 500 clients and government organizations including Samsung, Lexmark, Burger King, Discount Tire, Microsoft, Fisher Investments, National Park Service, and the SEC.
Jenny sat on the board of directors for the Rocky Mountain Chapter of the American Society for Training and Development for 3 years. She received the STAR award (Strategic Training that Attains Results) from ATD in 2009, for the creation of a program helping the unemployed develop skills to return to the workforce. Her training manuals are internationally sold, and her articles have been published in many locations including the Denver Business Journal and International Association of Business Communications CW bulletin.