Useful Logical, Statistical, Information and Math Functions

Who is this course for?

This specialist hands on session is for you if you would like to analyse data. If you are unfamiliar or new to formulas or calculations then attending our “Introduction to Formulas and Functions” session could benefit you before attending this session.

What are the benefits

At the end of this session you will be able to create simple and nested IF functions, work with the logical functions and become familiar with some of Microsoft Excel’s Math and Statistical functions

Enquire about this course

Course Enquiry

Please type your full name.
Invalid email address.
Invalid email address.
Invalid Input

Course Duration

2 Hours

Course Content

Getting Started

  • Review Function writing
  • Recap basic functions and function structure

Logical Functions

  • Create IF functions to calculate values based on criteria
  • Use the AND & OR function to return true or false values
  • Incorporate the AND & OR functions to expand the usefulness of the IF function
  • Work with multiple nested IF statements to calculate values
  • Check for errors using the IFERROR and IFNA (Excel 2013) functions

Information Functions

  • Add the information functions to check if errors in formulas exist:
    • ISERROR
    • ISNUMBER
    • ISBLANK
    • ISNA

Math Functions

  • Work with the SUMIF functions to add cells in a range which match values:
    • SUMIF
    • SUMIFS

Statistical Functions

  • Use the COUNT functions to count cells in a range that match values:
    • COUNT
    • COUNTA
    • COUNTBLANK
    • COUNTIF

What our users say

 

  • A very good course, trainer had good knowledge and delivered well
  • I like the fact that you have selected topics/functions on the basis of their interest/possible use - course is much more than pertinent and a better use of time
  • Very friendly and helpful trainer
  • Ray is the only IT Trainer who has ever inspired me with enough confidence to learn effectively
  • It was very good, I really enjoyed it and learnt a lot
  • I will definitely use the Pivot Tables at work in the future! Thank you for such a great training day!
  • Will ensure my team all attend (they all work remotely)
  • Exactly what I was hoping to learn, thanks

  • Contact Us
  • 44 (0) 208 681 1485
  • 44 (0) 7794 0689 6985

E Mail Us