Become A Microsoft Excel Formulas Pro (Part 2 - Name Ranges, Drop Down Lists & Data Validation)

Part 2: Beyond Excel Formula Basics: Name Ranges, Drop Down Lists & Data Validation

Are you ready to dive deeper into the world of Excel formulas? Go beyond the basics and learn how to use name ranges, drop-down lists and validate data with a few clicks of your mouse!

Did you know that you can use the range name feature to name a cell or range of cells? You can, and once cells are given names, they can be referenced from any spreadsheet within your workbook. Plus, a range name becomes an absolute reference and will refer to the same location no matter where you copy the formula. It’s such a power tool when writing formulas!

During this webinar, you’ll learn how to:

• Create a range name using the name box.
• Create and edit range names using the name manager dialog box.
• Use range names in a formula.
• Quickly create range names from column and row headings.
• Use to use a range name to populate a data validated list.
• Use range names to navigate spreadsheets in a workbook.

Take your Excel formula skills to the next level and put the name range, drop-down list, and data validation features to work for you with this webinar!

About Julie Perrine: Julie Perrine is an executive assistant turned founder of All Things Admin. She is an enthusiastic trainer, author, Certified Myers-Briggs Type Indicator Administrator, and perpetual planner. As an advocate of the administrative profession, Julie encourages admins to be prepared, hone their skills, and always keep their minds open to new career opportunities.