In this course, students will learn how to apply conditional logic to data using formulas, which allows for in-depth data analysis. This can mean anything from checking whether ranges of data meet certain criteria, to applying functions to specific categories of the data, to executing functions only under particular circumstances.


* Actual course outline may vary depending on offering center. Contact your sales representative for more information.

Learning Objectives

Upon successful completion of this course, students will be a better, faster, and more efficient Microsoft Excel user

  • Excel Skills Builder II

  • Functions and Logical Formulas
    Reading Worksheets in Formula View
    Year to Date Totals
    Percentage Change
    Working with Relative, Absolute, Mixed and Named References
    Introduction to Logical Functions Using IF
    Nested IF Functions IF AND / IF OR
    Power Functions, COUNTIF, AVERAGEIF and SUMIF Functions


This course is intended for individuals who want to boost there Excel skills to the next level, and greatly increase their proficiency.




There are no stated prerequisites for this course. Please check with your representative for details.


Length: 1.0 day (8 hours)


Not Your Location? Change

Course Schedule:

To request a custom delivery, please chat with an expert.