If you import data into Excel then you will have probably used Excel’s CSV import routines and have no doubt got frustrated that Excel’s default is to see all the number columns as numbers and format them accordingly. Sounds like a reasonable idea but if you are importing data where a zero at the front is important then it is not sure a great idea. Take for example Zip Codes. 07047 is different to 7047 and that leading zero is important. Excel CSV import routine is explained in this video and the all important step where most of us click [More]
Excel Pivot tables are in our opinion the best and most powerful way to analyse data in Excel and so watching this video is a must for everyone who has lists of data to look at and try to summarise. In this Video you will learn:- Pivot Tables Basics Group By Date Format Fields Format Pivot Table Pivot the table Page Filter Report Filter We hope you enjoy the enthusiasm of the presenter we have selected here. If you have learnt something from this video then please share it or like it using the buttons above or leave us a [More]
 
  Advertisement
Skip Ad
Skip Panel
 
Skip Survey
Test
Name
Email
×
It would be awesome to hit "like" or "share" and start playing.