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.
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.
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.
Tom Fragale
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 …
Project Management For Administrative Professionals
Elevate Your Workplace Wellness: 10 Critical Wellness Facto…
Managing Complex Projects - Project Management
Onboarding is NOT Orientation - How to Improve the New Empl…
Utilizing HR Metrics to Illustrate & Improve Human Resource…
Negotiating Skills For Professional Results - Winning Strat…
NEW Nacha Rule - Third-Party Sender (TPS) Roles and Respons…
FDA Technology Modernization Action Plan (TMAP) and Impact …
Paying and Receiving Payments for Referrals: You Can Go to …
Construction Lending And Real Credit Administration: Evalua…
Human Factors Usability Studies Following ISO 62366 and FDA…
Validation Statistics for Non-Statisticians
Thriving in a Hybrid Workplace: Keys to Leadership and Team…
Excel Power Skills: Master Functions, Formulas, and Macros …
Batch Record Review and Product Release
Discover how Emotional Intelligence turns AI from a technic…
Female to Female Hostility @Workplace: All you Need to Know
Copilot and HR: An Introduction for HR Professionals
ChatGPT for HR - Build HR Policy Framework and Strategy
Excel Spreadsheets; Develop and Validate for 21 CFR Part 11…
Major cGMP Issues: FDA Concerns in 2026
Language is Code - Intro to AI - Generative AI - ChatGPT an…
The Perfect Storm Coming to Healthcare: Value Based Care Me…
I-9 Audits: Strengthening Your Immigration Compliance Strat…
Pivot tables beginner to advanced + 20 advanced Pivot table…
Emotional Intelligence: Mastering the Emotions of Great Lea…