Excel 365 in 30 Minutes – Formulas & Functions (Basics 4 of 10)

Topics covered include: 

• Creating a simple formula 

• Identifying the mathematical operators used for basic math 

• Describing how order of operations is important in Excel formulas 

• Describing the difference between a formula and a function 

• Inserting AutoSum functions using the Ribbon and keyboard shortcut 

• Inserting a basic function using Formula AutoComplete 

• Inserting a basic function using the Insert Function command 

• Copying formulas using fill down and fill across 

• Copying multiple formulas at once using fill  

• Cutting and paste formulas 

• Using Paste Special to Transpose as you paste