Getting The Most Of Excel Formulas And Functions
Learn to build Excel formulas with the right order of operations and cell references, link sheets, and use functions such as IF, SUMIF, COUNTIF, VLOOKUP and DATE.
Speaker
Tom Fragale
Microsoft Office trainer · 30+ years in computing
Overview
Every spreadsheet, from budgets and forecasts to financial and scientific models, relies on formulas and functions. This 60-minute Excel formulas and functions training shows you how to build and manage them.
Formulas are equations you write; functions are formulas Excel provides. You'll start with simple math formulas, the order of operations, AutoSum, and relative and absolute references, then link formulas across worksheets.
The session then covers built-in functions including IF, SUM, COUNT, AVERAGE, SUMIF, COUNTIF, VLOOKUP and DATE, so you can build spreadsheets that calculate the results you need without relying on someone else.
Why attend: Building formulas is a core Excel skill. Once you can create your own, you'll work faster, produce better spreadsheets and become a more valuable part of your team. The webinar suits business owners, executives, managers, administrators, salespeople, trainers, bankers and anyone who uses Excel regularly and wants to be more productive.
What’s covered
- Creating simple math formulas
- The mathematical order of operations
- AutoSum
- Relative and absolute references
- Linking formulas from one sheet to another
- Built-in functions: IF, SUM, COUNT, AVERAGE, SUMIF, COUNTIF, VLOOKUP and DATE
Who should attend
What you get
About the speaker
Tom Fragale is a computer professional with over 30 years of professional experience. He has trained over 30,000 business people in on-line webinars, public seminars, and on-site training. His clients include many Fortune 500 companies, government agencies, military bases, and companies large and small across many industries, including manufacturing, banking, pharmaceutical, education, retail, etc. He started his career as a database application programmer and has served as a consultant and project manager on many successful projects. His topics of expertise include: Access, Excel, Word, PowerPoint, Outlook, Crystal Reports, SQL Server, Visio, QuickBooks, and SharePoint, among others. His passion is training people and helping people get the most out of their computers, and he is a published author having written a book on Microsoft Access. He graduated in 1988 from LaSalle University in Philadelphia, PA with a BA in Computer Science.
Staci Warne · 60 min
Cathy Horwitz · 180 min
Craig Brody · 60 min