Intermediate Excel Training Lesson 5 Module 5 - Using Logical Functions

In this module, we will discuss the theory behind logical comparisons between a value and what to expect by testing for a condition and returning a result if that condition is True or False. Table of Contents 00:00 Introduction 01:23 Learning Objectives 01:58 If Statement Elements 02:54 IF Statements Examples 04:24 Logical Operators 06:39 The If Function 09:33 If Function in Practice (Hands on Practice) 24:36 Budget Emojis 31:00 Considerations When Using the If Function 35:06 What Did We Learn? 36:01 End of Module 5 36:10 Sneak Preview Lesson 6 Getting and Transforming Data Link for Hands-on Practical and Download Instructions: Excel Link: https://www.dropbox.com/scl/fi/fbp1vyymzzrzzb0bldaa4/Excel-Lesson-5-IF-Statement-Practice-Worksheet.xlsx?rlkey=1k41jzi5ykzu70tyx6qli5dhi&st=4corrzpd&dl=0 Instructions: Load link in URL. Click the dropdown arrow to the right of the "comments" icon. Select “Or continue with download only.” File downloads to your computer’s downloads folder.