Adding the date and time to Microsoft Excel spreadsheets is commonly needed however when doing it for the first time it can be daunting. We have put together 4 Tips to so you can do this easily and efficiently.
Tips for Microsoft Excel Date and Time
Tag: microsoft excel
Excel tip: How to create a sequence of dates in Microsoft Excel
Need to create a sequence of dates? It’s very easy using Excel’s AutoFill feature.
Excel tip: Use flash fill to extract data in separate columns
Flash Fill recognises a pattern in your data and is a great tool to extract a field and break it down into its component elements.For example, in this video tip Column A has the first and last name in one field. Flash Fill makes splitting the names up into two separate cells (first name and surname column) very easy.
Excel tip: Analysing data by date using PivotTables
One of the simplest changes in Excel 2016 relates to date data when you’re working in a PivotTable. In prior Excel versions date data was added to the PivotTable as is.