Excel Logic Function Playbook

Make sure you’re not reinventing the wheel in your Excel spreadsheets. Logic functions are at the core of automating your work and keeping things up to date. Learn by example how to write and debug the AND, OR, NOT, IF, IFS and IFERROR functions.
Course info
Level
Intermediate
Updated
Sep 12, 2019
Duration
37m
Table of contents
Description
Course info
Level
Intermediate
Updated
Sep 12, 2019
Duration
37m
Description

Excel is often the hammer that is applied to many jobs. Knowing the built-in functions can save you time and frustration. In this course, Excel Logic Function Playbook, you will get an in-depth look at the logic functions in Excel. First, you will learn the AND, OR, and NOT functions. Next, you will discover the IF, IFS, and IFERROR functions. Finally, you will explore how to combine them all so you can write and debug these logic functions in Excel. When you’re finished with this course, you will know how to leverage logic functions to save more time. Software required: Excel.

About the author
About the author

Craig has over 15 years of software development on a variety of teams, including Fidelity.com, Overstock.com, F-16 aircraft, and several startups. Craig is passionate about solving problems with the right tools and enjoys teaching and mentoring others so they can save time and accomplish their goals faster.

More from the author
Excel Statistics and Finance Function Playbook
Intermediate
1h 26m
Oct 10, 2019
More courses by Craig Golightly
Section Introduction Transcripts
Section Introduction Transcripts

Course Overview
Hi everyone, my name is Craig Golightly, and welcome to my course, Excel Logic Function Playbook. I am a senior software consultant. Boolean logic and conditionals are at the core of computing, and can allow you to handle complex scenarios with ease. Whether you are just getting started or need a refresher for a few functions, this course is designed for you as an easy reference for logic functions in Excel. You will learn function syntax, pitfalls to avoid, best practices to follow, and see examples of the functions in action. We will cover the following functions, AND, OR, NOT, TRUE, FALSE, IF, IFS, IFERROR. By the end of this course, you will understand where and how to use these functions in your Excel spreadsheets. Before beginning the course, you should be familiar with Excel. From here, you should feel comfortable continuing to other Excel courses such as Excel Statistics and Finance Function Playbook, Managing Excel Workbooks for Analytics. I hope you'll join me on this journey to learn about logic and control functions in Excel with the Excel Logic Function Playbook course at Pluralsight.