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. Software required: Excel.Topics:
- Course Overview
- Checking Conditions with Boolean Logic
- Making Decisions with IF, IFERROR