Скачать или смотреть Excel Tutorial 03: Assigning Cell Names

Welcome to the video series called Two-Minute Excel Tutorials. These short videos teach you how to use Microsoft Excel effectively. This is Lesson 03: Assigning Cell Names.

Sometimes in Excel, especially when working with many equations, a large workbook, or a workbook with multiple sheets, it is more convenient to use cell names rather than dollar ($) signs to lock cell references. In this short video, Professor Cimbala explains how to assign names to cells in order to enter these assigned names into equations (formulas) in Excel cells. He also shows how this works even across multiple sheets. Finally, he shows how to use Excel's Formulas tab and Name Manager to edit or delete the names you have assigned.

Dr. John M. Cimbala is Professor of Mechanical Engineering at Penn State. He is an educator, textbook author, Christian author, husband, father, and grandfather. He also created and maintains a website for helping people grow in their faith called Christian Faith Grower at https://www.christianfaithgrower.com/
Subscribe to his YouTube channel at    / @johncimbala   to be notified when more videos are posted.