Putting in data in Excel can be a slow process and errors can be made. AutoComplete and dropdown list are two features currently available in Excel. AutoComplete happens when you start typing in an item you have used previously in a column. Drop-down lists are created with Data Validation and ensure only the correct items that belong in a column are entered. For example, a department column shouldn't show the Accounting department as "Accounting" and later as "Acct". Rolling out for Microsoft 365 users is AutoComplete and Drop-down list combined. This is a great time-saving feature. What is especially nice is the feature can match text from anywhere in the list. For example, if you have a list of 300 cars and you start typing Tahoe, Excel will pick up that it is in the drop-down list as Chevrolet Tahoe. It can pick up from the start, middle, or end of the list.
Chapters:
0:00 Intro
0:56 AutoComplete in Excel
1:38 Great Keyboard Shortcut
2:00 Dropdown list
4:05 AutoComplete w/ Dropdown list
4:40 Sort Data Validation List
Microsoft article insider.office.com/fr-ca/blog...
AutoComplete and Drop-down list working together is one of many topics I'll cover in my in-person session at the Administrative Professionals Conference (APC) in Orland FL on September 13, 2022.
* chrismenardtraining.com/post/...
* www.apcevent.com/speaker/chri...
#chrismenardtraining #admininstrativeprofessionalconference #exceltraining #msexcel #microsoft365 #officeinsider
And make sure you subscribe to my channel!
- EQUIPMENT USED --------------------------------
○ My camera - amzn.to/3vdgF5E
○ Microphone - amzn.to/3gphDXh
○ Camera tripod - amzn.to/3veN6Rg
○ Studio lights - amzn.to/3vaxyy5
○ Dual monitor mount stand - amzn.to/3vbZSjJ
○ Web camera - amzn.to/2Tg75Sn
○ Shock mount - amzn.to/3g96FGj
○ Boom Arm - amzn.to/3g8cNi6
- SOFTWARE USED --------------------------------
○ Screen recording - Camtasia - chrismenardtraining.com/camtasia
○ Screenshots - Snagit - chrismenardtraining.com/snagit
○ RU-vid keyword search - TubeBuddy - www.tubebuddy.com/chrismenard
DISCLAIMER: Links included in this description might be affiliate links. If you purchase a product or service with the links I provide, I may receive a small commission. There is no additional charge to you! Thank you for supporting my channel, so I can continue to provide you with free content each week!
22 июл 2024
