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.
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.
Author Name: Craig Golightly
Author Description:
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.
Table of Contents
- Course Overview
1min - Checking Conditions with Boolean Logic
22mins - Making Decisions with IF, IFERROR
12mins
User Reviews
Be the first to review “Excel Logic Function Playbook”
Related Products
Mastering Excel Functions
This course will teach you essential Excel functions along with data analysis techniques and macros, enabling efficient data management and insightful analysis.
Power Pivot in Excel
Master Power Pivot in Excel to help import data, create relationships, and utilize DAX. Build dynamic dashboards to uncover actionable insights.
Intermediate Google Sheets
Expand your Google Sheets vocabulary by diving deeper into data types, including numeric data, logical data, and missing data.
Pivot Tables in Google Sheets
Learn how to create pivot tables and quickly organize thousands of data points with just a few clicks.
Excel Statistics and Finance Function Playbook
Save time and reduce errors by using the right functions in Excel. Statistics and finance functions can help you make quick work of reports and evaluations. Learn by example how to use the SUMIFS, AVERAGEIFS, COUNTIFS, NPV, FV, and PV functions.
Financial Modeling in Excel
Learn about Excel financial modeling, including cash flow, scenario analysis, time value, and capital budgeting.
There are no reviews yet.