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