1:55 to 2:55pm New Zealand Time 11:55 to 12:55 Australia East Coast Time 9:55 to 10:55 Australia West Coast Time
Description:
In the ideal world, we receive information in nicely formatted CSV files that can be easily transferred into Excel. Unfortunately, this is not always the case - in this webcast, we will go through a number of the more useful hacks for sorting, formatting and manipulating various data types.
The following are some of the main points:
(intro) Importing CSV files to Excel and specifying formats.
Importing txt files into Excel (mapping columns)
Extracting usable data from txt tiles with no columns or delineation.
Lookup table, IF Statement, FIND Statement & much more...
1:55 to 2:55pm New Zealand Time