Getting The Most Of Excel Formulas And Functions

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.

• 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

• 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

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.

• 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

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.