SKILLSHARE ULTIMATE EXCEL COURSE 3 LOGICAL FUNCTIONS THE DECISION MAKING FORMULAS OF EXCEL-iLLiTERATE
Submitted by milohaze on Fri, 04/26/2019 - 16:15
Category:
Genre:
This is class #3 in a series called the Ultimate Excel Course.
In this class of the Ultimate Excel Course you will learn how to use Logical Functions - the Decision Making Formulas of Excel.
Logical functions enable us to create intelligent automated spreadsheets that can react when data is added or changed and calculate to correct formula or automatically change the values on a spreadsheet.
If you want to create awesome spreadsheets that will impress your colleagues and wow your boss then learning logical formulas is a must.
This class will cover:
- Three examples of the IF function.
- These include testing if a value is larger than a specific value, testing if specific text is in a cell and tracking due dates alerting us when a date has passed or showing how many days until that due date.
- Writing nested IFs so that we can test a value more than once.
- Using the AND and OR functions to test multiple conditions.
In this class of the Ultimate Excel Course you will learn how to use Logical Functions - the Decision Making Formulas of Excel.
Logical functions enable us to create intelligent automated spreadsheets that can react when data is added or changed and calculate to correct formula or automatically change the values on a spreadsheet.
If you want to create awesome spreadsheets that will impress your colleagues and wow your boss then learning logical formulas is a must.
This class will cover:
- Three examples of the IF function.
- These include testing if a value is larger than a specific value, testing if specific text is in a cell and tracking due dates alerting us when a date has passed or showing how many days until that due date.
- Writing nested IFs so that we can test a value more than once.
- Using the AND and OR functions to test multiple conditions.