Microsoft® Certified Trainer and Excel expert Jackie Kiadii will show you how to build flexibility into your spreadsheets with logical functions. You will learn how to write powerful formulas that you can use immediately.
What You'll Learn:
- IF functions
- Nested IF functions
- AND, OR, NOT functions
- SUMIF
- COUNTIF
- AVERAGEIF
- Pivot table alternatives
Training Overview
IF – Two letters that will save you hours in Excel. Master logical functions quickly.
With a fifth of workers planning to quit in 2022, everyone must quickly adapt to staffing shortages as the Great Resignation continues to plague most organizations. Employees who can take advantage of technology to accomplish more in less time are receiving promotions and inflation-busting raises. Now is the ideal time to upskill and get ahead of the competition.
By mastering Excel’s handy IF function, you can quickly analyze data and make decisions. Robust logical functions can help you do conditional analyses, changing calculations based on the values of other cells. These tools will enable you to reach informed conclusions more quickly, whatever information your dataset includes.
In two 90-minute sessions, you will discover the following powerful logical functions and related features that will save you hours:
- IF functions
- Nested IF functions
- AND, OR, NOT 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
CareerLearning Quality Commitment
CareerLearning wants you to be satisfied with your purchase. If this program does not meet your expectations, email us at support@careerlearning.com.