[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