[3-Part Series] Excel IF Function Series


with
Jackie Kiadii
Live Session
$279.00
  • October 26, 2021, 12:30 pm   EST
Training Includes:
  • Certificate of Attendance
  • All resources and training materials
  • An on-demand recording will be available after each live presentation.

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
When:
Tuesday, October 26, 2021 - Thursday, October 28, 2021; 12:30 PM Eastern
3 Sessions scheduled for 90 minutes including question and answer period.

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?

 

  • Everyone who uses or could use Excel, including:

    • Human resources professionals

    • Business owners

    • Plant managers

    • Finance professionals

    • Operations managers

    • Contract managers

    • Contract administrators

    • Commercial managers

    • Supply chain managers

    • Supplier relationship managers

    • Supply base managers

    • Strategic sourcing managers

    • Procurement managers

    • Supervisors

    • Development staff

    • Program directors

    • Hiring staff

    • Nonprofit chief executives

    • Executive directors

    • Development staff

    • Consultants

    • Marketing staff

    • Fundraising staff

    • School district administrators

    • Charter school board members

    • Principals

    • Assistant principals

    • Department chairs

    • Curriculum specialists

    • Community engagement professionals

 

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

For Teams

Have a team that needs training? Our enterprise customers receive custom branding, reporting and analytics tools, and of course, preferred pricing.