Looking for Excel training for you or your team in Australia? Learn what practical, workplace-focused Excel courses should include and how to avoid the common traps.
How To Choose Practical Excel Training For Your Team (And Avoid Wasting Time)
Tag: excel
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: 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.