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 SHOULD YOU 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.
AREA 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
LEARNING OBJECTIVES
- Create simple math formulas using the correct order of operations
- Total data quickly with AutoSum
- Use relative and absolute references correctly
- Link formulas across worksheets
- Apply IF, SUMIF, COUNTIF and other built-in functions
- Look up values with VLOOKUP and work with dates
WHO WILL BENEFIT?
- Business owners
- CEO’s / CFO’s / CTO’s
- Managers of all levels
- Anybody who uses Excel on a regular basis, and want to be more efficient and productive
- Administrators
- Salespeople
- Trainers
- Bankers
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.
- 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
- Create simple math formulas using the correct order of operations
- Total data quickly with AutoSum
- Use relative and absolute references correctly
- Link formulas across worksheets
- Apply IF, SUMIF, COUNTIF and other built-in functions
- Look up values with VLOOKUP and work with dates
- Business owners
- CEO’s / CFO’s / CTO’s
- Managers of all levels
- Anybody who uses Excel on a regular basis, and want to be more efficient and productive
- Administrators
- Salespeople
- Trainers
- Bankers
Speaker Profile
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 …
Upcoming Webinars
Medical Device Cybersecurity Following FDA’s 2026 Premarket…
Managing Toxic Employees: Strategies For Leaders To Effecti…
California Meal and Rest Breaks: What You Don't Know Can Co…
Human Error Reduction Techniques for Floor Supervisors
Unlock Employee Loyalty: Stay Interviews Will Keep Them Eng…
Performance of Root Cause Analysis, CAPA, and Effectiveness…
Your AI Advantage: How HR Professionals Can Use Claude to S…
The Anti-Kickback Statute: Enforcement and Recent Updates
Empowering Conflict Resolution: Letting Go to Gain Control
Wage & Hour Laws: Ensuring Compliance with the Fair Labor S…
Using Copilot to Format Legal Documents in Microsoft Word
Dealing With Difficult People: At Work & In Life
Using Stay Interviews To Improve Employee Retention & Engag…
AI in Word - Smarter Writing and Document Creation with Cha…
FDA Current Trends in Compliance and Enforcement for FDA-Re…
Zero Acceptance Sampling to Reduce Inspection Costs
Why EBITDA Doesn't Spell Cash Flow and What Does?
Mastering Tough Conversations: Turn Conflict into Clarity, …
Enhancing Pivot Tables with Images: Visualize Your Data Lik…
Discover how Emotional Intelligence turns AI from a technic…
Understanding Financial Statements for Non-Financial Profes…
SOPs - How to Write Them to Satisfy those Inspectors
Managing Projects When AI Joins the Team: Human Judgment, A…