Format: On-demand
This course is for Microsoft® Windows Excel 2013 and newer versions, including 365. This course will be an overview of:
- Learn how to create range names.
- Learn how to use range names in formulas.
- Learn how to use Excel’s Auditing Tool to understand a workbook’s structure.
Becker’s Microsoft® Excel Series features Wayne Winston, Microsoft® Press author for more than a decade with 40 teaching awards for his instruction. Wayne is sought out by many of the Big 4 and larger corporations to bring their personnel to a level playing field with Microsoft® Excel, necessary today for success in the accounting profession.
Wayne’s success as a Microsoft® Excel instructor is closely tied to his teaching style that has students watch and then do realistic, engaging problems in the software. Students learn through using Microsoft® Excel to cement their understanding before progressing to the next building block.
Learning Objectives
After completing this course, the learner should be able to:
- Learn how to use the Name Box and Create from Selection to create range names.
- Learn how to use range names and Implicit Intersection in formulas.
- Learn how to refer to an entire row or column in formulas.
- Learn how to use formulas to create range names.
- Understand the difference between workbook and worksheet level names.
- Learn how to use Microsoft® Excel’s Auditing Tool to understand a workbook’s structure.