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 tips
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: How to use Get & Transform to Merge Columns
The Get and Transform feature of Excel 2016 sounds new, but some of you may know it by its old name, Power Query. You now get the data, and then you transform it, hence the new name.
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.