Microsoft Certified Trainer and Excel expert Jackie Kiadii will show you how to harness the power of IF, teaching at a steady pace to make it easy to follow along. You will learn how to make your work in Excel faster and more efficient.
What You'll Learn:
- Four key skills needed for logical functions
- IF functions
- How to handle multiple IFs
- IFs()
- Boolean functions (AND, OR, NOT)
- SUMIF
- COUNTIF
- AVERAGEIF
- Pivot table alternatives
Training Overview
Save time working in Excel with IF function. Learn how to use powerful logical functions
Microsoft Excel's user base continues to grow and hundreds of thousands of currently open positions require Excel proficiency.
- If you want to understand your data,
- If you want to impress your manager,
- If you want to do your work in a fraction of the time,
- If you want to advance your career
You need to master logical functions in Excel, including the powerful IF. These two letters can do more work in a second than you could do in hours. When combined with other functions, they can draw meaningful conclusions from enormous data sets.
We have assembled a series of three engaging and information-packed webinars to make you an IF function expert.
Excel IF Function Series
Session 1
Logical Function Overview
- Four key skills needed for logical functions
- IF functions
- How to handle multiple IFs
Session 2
Nested IF Functions
- Four key skills needed for logical functions
- IF functions
- How to handle multiple IFs
Session 3
Introduction To Aggregate IF Functions
- SUMIF
- COUNTIF
- AVERAGEIF
- Pivot table alternatives
Who Should Attend?
|
|
Expert Presenter
Jackie Kiadii
-
Founder of Phoenix Computer Consultants, LLC, an Atlanta-based IT services firm
-
Helping clients leverage technology to increase their productivity and profitability since 2001
-
Provides curriculum development, consulting, and training in Microsoft 365 applications
-
Microsoft Certified Trainer and Microsoft Certified Expert – Excel