Excel Quick Tips – How to convert dates from text using keyboard shortcuts

Grab my FREE Excel for Analytics Ultimate Guide here: https://www.tmbanalytics.com/excel-for-analytics-guide

Want to learn some helpful Excel shortcuts? In this short I show you how to quickly convert a series of dates formatted as text into actual, usable dates using only your keyboard – no mouse!

Select Cells in Column: Ctrl + Shift + Down Arrow
Cycle Text To Columns: Alt + A + E + F

This will activate each cell and change it from a date text to an actual date.

#excel #exceltips #analytics #data #dataanalytics #hotkeys #excelshortcuts #tmbanalytics #nomouse

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