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

In this Bigger Brains course, you’ll learn how to create simple formulas and how to identify the mathematical operators used for basic calculations. You’ll see how Excel’s order of operations is essential for getting accurate results. You’ll explore the difference between formulas and functions and ways to insert commonly used functions, including AutoSum, Formula AutoComplete, and the Insert Function command, which will help you work faster and more accurately. 

You’ll also learn how to copy formulas efficiently using multiple techniques, as well as how to cut and paste formulas without disrupting your calculations. You’ll explore useful Paste Special options, such as Transpose, to quickly reorganize your data. By the end, you’ll be able to confidently build and reuse formulas and functions to streamline your Excel work. 

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 

Enjoy award winning HD content in the “Uniquely Engaging”™ Bigger Brains Teacher-Learner style! Taught by top subject matter experts, Bigger Brains courses are professionally designed around key learning objectives and include captions and transcripts, downloadable handouts, and optional LinkedIn digital badges on course completion.