An Excel formula is an equation or calculation that is stored in a worksheet cell. A formula enables you to perform simple or complex calculations on numbers. So think of any scenario that involves addition, subtraction, division or multiplication and that's where you'd use a formula.
Functions are built-in formulas that have been programmed to perform a specific calculation. They range from simple such as SUM and AVERAGE (used to calculate the total and average of numbers in a range of cells) to the powerful IF and VLOOKUP.
Functions aren't limited to calculating numeric data. They can save you a ton of time when working with text and dates too.
Need to calculate someone's age from their date of birth? Need to combine text items from several cells into a single cell? Need to convert a list of lower case text items to capital letters? Need to compare items in two lists?
All of the above (and much more!) can be done with using Excel functions.
Course Objectives:
Although it is perfectly possible to use Excel without ever creating a formula if you don't, you're missing out on a huge part of the application's power.
Learning how to create formulas will automate your calculations and save you a ton of time. No more using your fingers. No more mental arithmetic. No more using the calculator app on your Smartphone! Let Excel do the work for you!
Excel has over 450 built-in Worksheet Functions (pre-defined formulas). Nobody needs to know them all however, no matter what your job role is, no matter what industry you work in, there are some key Functions that everyone should know how to use. This training will address those Functions.
Course Outline:
• Creating formulas to perform mathematical calculations
• Copying a formula - the Gotchas you need to know about
• Cell Names - how to make formulas logical and understandable
• Combining text strings from multiple cells
• Converting text from lowercase to uppercase and vice versa
• Performing calculations on dates and times
• Logical functions (IF, COUNTIF, SUMIF and more)
• VLOOKUP, HLOOKUP, INDEX and MATCH
• GETPIVOTDATA
• Trapping Errors - Using functions to bullet-proof your worksheets
• Creating complex functions the easy way
What You Get:
• Training Materials
• Live Q&A Session with our Expert
• Participation Certificate
• Access to Signup Community (Optional)
• Reward Points
Who Will Benefit:
• Any Excel user who needs to go beyond the basics of using formulas or simply wants to become more comfortable and productive in using Excel formulas and functions
• Any Excel user who deals with large lists needs these tools and techniques to effectively manage the lists and become more productive. Nearly all Excel users, except for those just getting started, are candidates for this webinar
2 Hour Excel Bootcamp: Tools / Training for HR Professionals
Get Instant Access 120 Minutes View Program |
3 Hour Excel Automation Boot Camp: Sort and Filter Tools, Conditional Formatting, Data Validation and Visualizing Excel with Smart-Art and Charts
Get Instant Access 180 Minutes View Program |
Mastering Chart and Graph Essentials in Excel 2013 to 2016
Get Instant Access 90 Minutes View Program |
Breaking Down Excel Formulas
Get Instant Access 90 Minutes View Program |
Mastering Microsoft Excel® Macros and VBA
Get Instant Access 60 Minutes View Program |
Nov 18, 2026 | 01:00 PM EST
How to Deal With Clashing Coworkers
Bob Churilla
Human Resources
Nov 19, 2026 | 01:00 PM EST
Excel Pivot Tables 101 - Detailed Data Analysis with Pivot Tables: Calculating Sums, Averages, Counts and More
Mike Thomas
Cross Industry | Skill Enhancement
Nov 19, 2026 | 01:00 PM EST
After the OSHA Inspection: What Do We Do Now? Effectively Handling OSHA’s Settlement Process
Environment Health and Safety | OSHA
Nov 25, 2026 | 01:00 PM EST
3-hr Virtual Seminar: Technical Writing for the Pharmaceutical, Medical Device and Biotech Industries
Joy L. McElroy
Medical Device | Diagnostic | Pharmaceutical | Biologics fields
Nov 19, 2026 | 01:00 PM EST
The Fair Labor Standards Act: Wage & Hour Compliance
Diane L. Dee, SPHR, SHRM-SCP
Human Resources