Excel Logic Function Playbook

Focused View

Craig Golightly

36:34

98 View

1. Course Overview

1. Course Overview.mp4

01:25

02. Checking Conditions with Boolean Logic

01. Using TRUE, FALSE, AND.mp4

02:06

02. AND Examples.mp4

03:04

03. Using OR.mp4

01:22

04. OR Examples.mp4

03:22

05. Using NOT.mp4

00:43

06. NOT Examples.mp4

02:47

07. Nested Functions.mp4

01:42

08. Evaluate Formula Tool Example.mp4

01:13

09. Demo - Nested Function Solution.mp4

04:04

10. Demo - Evaluate Formula Tool.mp4

01:10

11. Caution! Nesting.mp4

00:43

3. Making Decisions with IF, IFERROR

1. Using IF Statements.mp4

02:21

2. IF Examples.mp4

02:55

3. Using IFS and Nested IF Statements.mp4

02:35

4. IFS and Nested IF Examples.mp4

02:25

5. Using IFERROR Statements.mp4

00:56

6. IFERROR Examples.mp4

01:41

Description

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.

What You'll Learn?

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.

More details

User Reviews

Rating

average 0

Total votes0

Focused display

Excel

Craig Golightly

Instructor's Courses

Craig is passionate about solving problems with the right tools. He has over 20 years of software development experience with large enterprises and small startups on everything from search engines to fighter jets. He has a bachelor's and master's degree in computer science with extensive experience in AWS, microservices, and artificial intelligence. Craig enjoys teaching and mentoring others so they can save time and accomplish their goals faster.

Pluralsight

View courses Pluralsight

Pluralsight, LLC is an American privately held online education company that offers a variety of video training courses for software developers, IT administrators, and creative professionals through its website. Founded in 2004 by Aaron Skonnard, Keith Brown, Fritz Onion, and Bill Williams, the company has its headquarters in Farmington, Utah. As of July 2018, it uses more than 1,400 subject-matter experts as authors, and offers more than 7,000 courses in its catalog. Since first moving its courses online in 2007, the company has expanded, developing a full enterprise platform, and adding skills assessment modules.