Excel 365 in 30 Minutes – Named Ranges & Functions (Basics 5 of 10)

In this Bigger Brains course, you’ll learn the difference between relative and absolute references and see how to convert cell references to absolute or mixed to make your formulas more reliable. You’ll explore the purpose of named ranges and see how to create them using the Name Box, Create from Selection, and other built in Excel tools. You’ll also learn the rules for naming ranges and how to insert named ranges into formulas automatically, through the Use in Formula and Paste Names options, or by using AutoComplete. 

You’ll learn the fundamentals of logical values and logical functions, review comparison operators, and learn to write formulas using the IF function to add decision making power to your spreadsheets. By the end of the course, you’ll be able to apply named ranges, use absolute references, and build smarter formulas that make your Excel work more consistent and easier to manage. 

Topics covered include: 

• Describing the difference between a Relative and Absolute Reference. 

• Changing a cell reference to be absolute or mixed. 

• Identifying the purpose of a Name Range 

• Creating a Named Range from the Name Box on the ribbon and from the Create from Selection option 

• Listing the restrictions on the names of Named Ranges 

• Inserting a Named Range into a formula automatically 

• Inserting a Named Range into a formula from the Use in Formula and Paste Names options 

• Inserting a Named Range into a formula using AutoComplete 

• Defining a logical value and a logical function 

• Listing comparison operators 

• Writing a formula with the IF function 

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.