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 https://insider.office.com/fr-ca/blog/speed-up-data-entry-and-validation-with-autocomplete-for-dropdown-lists-in-excel-for-windows

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.
* https://chrismenardtraining.com/post/september-13-2022-microsoft-365-new-and-upcoming-features-administrative-professionals-conference
* https://www.apcevent.com/speaker/chris-menard/

#chrismenardtraining #admininstrativeprofessionalconference #exceltraining #msexcel #microsoft365 #officeinsider

And make sure you subscribe to my channel!

— EQUIPMENT USED ———————————
○ My camera – https://amzn.to/3vdgF5E
○ Microphone – https://amzn.to/3gphDXh
○ Camera tripod – https://amzn.to/3veN6Rg
○ Studio lights – https://amzn.to/3vaxyy5
○ Dual monitor mount stand – https://amzn.to/3vbZSjJ
○ Web camera – https://amzn.to/2Tg75Sn
○ Shock mount – https://amzn.to/3g96FGj
○ Boom Arm – https://amzn.to/3g8cNi6

— SOFTWARE USED ———————————
○ Screen recording – Camtasia – https://chrismenardtraining.com/camtasia
○ Screenshots – Snagit – https://chrismenardtraining.com/snagit
○ YouTube keyword search – TubeBuddy – https://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!

Please take the opportunity to connect and share this video with your friends and family if you find it useful.