How do I analyse time-down data in Excel?
The most straightforward Excel analysis tool is the PivotTable and it’s perfect for analysing time-down data. There are thousands (millions?!) of tutorials for PivotTables; when writing, searching “Excel pivot table tutorials” on Google generates over 16m results!
Whatever your start point or learning style, you can find a tutorial that works for you, with articles, videos and step-by-step training courses available online for everyone, from absolute beginners to advanced Excel users.
PivotTables can only go so far though; presenting data in tables is fine for small data sets, like monthly sales over a year, but once you want to deal with larger volumes of data, you need to be visualising your data to spot patterns.
Read the full article here.
Related questions:
