Ultimate Excel Course #3 - Logical Functions: The Decision Making Formulas of Excel | Alan Murray | Skillshare

Ultimate Excel Course #3 - Logical Functions: The Decision Making Formulas of Excel

Alan Murray, IT Trainer, Coffee Lover and Lifelong learner

Play Speed
  • 0.5x
  • 1x (Normal)
  • 1.25x
  • 1.5x
  • 2x
7 Videos (39m)
    • Introduction

    • IF Function 1 - Testing if a Value is Larger than Specific Value

    • IF Function 2 - Testing if Contains Certain Text

    • IF Function 3 - Tracking Due Dates by Testing if they have Passed

    • Using Nested IFs to Test More than Once

    • AND and OR Functions for Testing Multiple Conditions

    • Thank You


About This Class


In this class of the Ultimate Excel Course you will learn how to use Logical Functions - the Decision Making Formulas of Excel.

Logical functions enable us to create intelligent automated spreadsheets that can react when data is added or changed and calculate to correct formula or automatically change the values on a spreadsheet.

If you want to create awesome spreadsheets that will impress your colleagues and wow your boss then learning logical formulas is a must.

This class will cover;

  1. Three examples of the IF function.
  2. These include testing if a value is larger than a specific value, testing if specific text is in a cell and tracking due dates alerting us when a date has passed or showing how many days until that due date.
  3. Writing nested IFs so that we can test a value more than once.
  4. Using the AND and OR functions to test multiple conditions.

The logical-functions.xlsx spreadsheet used during the lessons is available for download from the Project area. You can use this to follow along with me.

The class project provides some challenges to recap on what we covered during the class. Any questions, please post them in the discussion area.

Grab a coffee, enrol and let's do this.

Please note that this is class #3 in a series called the Ultimate Excel Course.

You can find direct links to the other classes in the series below.

Class #1 - Excel Formulas Made Easy - Get up to Speed with Excel Formulas Fast

Class #2 - Essential Skills for Working with Large Spreadsheets

Class #3 - Logical Functions: The Decision Making Formulas of Excel

Class #4 - Conditional Formatting: Make your Data Come to Life

Class #5 - Lookup Functions: The Powerful VLOOKUP Function and Beyond

Class #6 - Validating and Protecting Excel Data

Class #7 - Advanced Formulas for Analysing Data

Class #8 - Excel Charts for Simple and Effective Data Presentation

Class #9 - Cleaning and Preparing Data Ready for Analysis

Class #10 - Formatting your Data Ranges as Tables for Superior Management

Class #11 - Master PivotTables for Powerful Analysis and Reporting

Class #12 - Get & Transform Data with Power Query

Class #13 - Introduction to the Data Model and PowerPivot





  • --
  • Beginner
  • Intermediate
  • Advanced
  • All Levels
  • Beg/Int
  • Int/Adv


Community Generated

The level is determined by a majority opinion of students who have reviewed this class. The teacher's recommendation is shown until at least 5 student responses are collected.

Alan Murray

IT Trainer, Coffee Lover and Lifelong learner

Hello, my name is Alan Murray and I have been training and consulting in Excel now for over 17 years. I have had the pleasure in helping individuals and businesses from all around the world improve their Excel skills.

I set up Computergaga about 8 years ago to help spread the latest Excel tips and to engage with other Excel experts and learners. It has grown beyond my expectations and I hope to get the chance to speak with many of you soon.

I have a real passion for Excel and I ...

See full profile

Report class