SECRET Excel Named Range Shortcuts to Save Time
Defining names in Excel has a load of benefits, from faster formula writing, easier to read workbooks and more robust files. In this video I cover the various types of names you can define and some shortcuts the experts use. Download the Excel file here: https://www.myonlinetraininghub.com/excel-named-range-shortcut
View my comprehensive courses: https://www.myonlinetraininghub.com/
Connect with me on LinkedIn: https://www.linkedin.com/in/myndatreacy/
0:00 Introduction
0:21 Types of Defined Names
0:37 Defining Named Cells
1:37 Defining Named Ranges
2:07 Defining Names from Tables
2:56 Defining Named Constants
4:07 Defining Named Formulas
5:42 Defined Name Scope
8:53 Defined Name Shortcut
Видео SECRET Excel Named Range Shortcuts to Save Time канала MyOnlineTrainingHub
View my comprehensive courses: https://www.myonlinetraininghub.com/
Connect with me on LinkedIn: https://www.linkedin.com/in/myndatreacy/
0:00 Introduction
0:21 Types of Defined Names
0:37 Defining Named Cells
1:37 Defining Named Ranges
2:07 Defining Names from Tables
2:56 Defining Named Constants
4:07 Defining Named Formulas
5:42 Defined Name Scope
8:53 Defined Name Shortcut
Видео SECRET Excel Named Range Shortcuts to Save Time канала MyOnlineTrainingHub
Показать
Комментарии отсутствуют
Информация о видео
Другие видео канала
Excel Keyboard Shortcuts used by ProsExcel XLOOKUP Function Definitive GuideExcel Relative Named Ranges - A Secret of Excel Pro UsersTop 10 Most Important Intermediate Excel FunctionsHow to Use the NEW & IMPROVED Excel XLOOKUP (with 5 Examples)How to easily automate boring Excel tasks with Power Query!Dynamic Excel Drop Down Lists - PLUS how to get SEARCHABLE Drop Down Lists!When Should you Use the Hash Sign #️⃣ in Excel Formulas?Basic Excel Formulas and Functions You NEED to KNOW!Cool Tricks with Excel Hyperlink ButtonsExciting New Excel LET Function - Comprehensive GuideTop Tips for Using Named Ranges in ExcelEASY Power Query Variables 3 Ways5 Dashboard Design Tips - COMMON MISTAKES to avoid!7 Things You're Doing WRONG⚡in Excel10 Excel Things You Should NEVER Do and What to do InsteadBreaking News! We FINALLY get the Excel functions we've been Wanting!Excel OFFSET Function - including Common MISTAKES to Avoid!Excel Dynamic Arrays (How they will change EVERYTHING!)