[2-Part Series] Excel IF Function Series

with
Jackie Kiadii
Series
$259.00
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 build flexibility into your spreadsheets with logical functions. You will learn how to use a few short functions to write powerful formulas.

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. Learn how to use powerful logical functions.

The world is increasingly full of uncertainties. “If” plays a big role in your professional life, whether you are beginning to plan your organization’s 2022 budget, contemplating salary costs at various levels of inflation, or making the countless decisions that confront you daily.

Excel can help you do these conditional analyses with its robust set of logical functions. They allow you to change calculations based on the values of cells. For example, you could add overhead allocation only to the cost of employees who work in the office while omitting it from those who opt for ongoing remote work.

In only 90 minutes, you can discover 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?

  • 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