Excel 365 – Using conditional formulas

Overview 

This 8-clip course explores how to use built-in formulas to perform a spreadsheet calculation in Excel for Office 365. You’ll start by learning how to insert a conditional amount using SUMIF formulas to perform a spreadsheet calculation. amount on the selected data values in your range. Next, you’ll learn how to use the IF function to determine whether a condition is met or not, and how to use the IF function with other formulas. This course goes on to show you how to incorporate multiple IF formulas into one to get multiple-choice options. You will learn how to combine qualification and how to alternate conditions using IF and OR in conditional formulas. Next, students will learn how to use conditional formulas to count how many times a value appears. You will learn to use reference positions in conditional formulas. Finally, this course demonstrates how to keep your table updated with conditional formulas using the COUNTA and OFFSET formulas.

Objectives

• Insert a conditional formula
• Insert a conditional message formula
• Apply complex conditional formulas
• Create multiple conditions
• Use IF and OR in conditional formulas
• Use conditional formulas to count how many times a value appears
• Use positions reference in conditional formulas
• updating the table by conditional formulas