Convert Text to Date | DATEVALUE Function | Text to Columns | Power Query … and more
Microsoft Excel Tips and Tricks In this video I describe how to convert text values into date values. Credit Chester[…]
Read more
Tag: excel
Switch / Reverse First and Last Names In Excel With or Without a Comma
Microsoft Excel Tips and Tricks In this video I show you how to reverse first and last names in Excel.[…]
Read more
Automated Attendance Sheet in Excel with Formula | Download Attendance Sheet Template
Microsoft Excel Tips and Tricks In this video I demonstrate how to create an attendance sheet in Microsoft Excel. Credit[…]
Read more
Create a List of All Sheet Names | Dynamic Excel Table of Contents inc Hyperlinks & Auto Updates
Microsoft Excel Tips and Tricks In this video I demonstrate how to create a list of worksheet names in Excel[…]
Read more
Select / Highlight / Conditionally Format Blank Cells In Excel | Automatically Highlight Blanks
Microsoft Excel Tips and Tricks In this video I demonstrate how to highlight blank cells by changing their background colour.[…]
Read more