General
The Ultimate Guide to Pivot Tables for Beginners
Written by Hannah Sharon   
Monday, 15 July 2019

Pivot tables are one of Excel's most powerful features. Used in the context of data processing a Pivot table can be used to summarize, sort, reorganize, group, count, total or average data stored in a database. For time-saving, efficient pivot tables that help create outstanding reports, here’s the ultimate guide to using pivot tables.

Last Updated on Monday, 15 July 2019
Read more...
 
Moving to Excel 2010
Written by Janet Swift   
Wednesday, 13 October 2010

Moving from an earlier version of Excel to the latest one can come as a culture shock. Here's an exploration of the differences and some new features.

Last Updated on Wednesday, 13 October 2010
Read more...
 
Calculating with Dates in Excel
Written by Janet Swift   
Tuesday, 05 January 2010

Our freezer contents tracker puts the spreadsheet's date serial numbers to practical use. We look at date formatting and introduce a shortcut for entering and fixing the current date.

Last Updated on Friday, 07 August 2020
Read more...
 
Monthly Calendar
Written by Janet Swift   
Monday, 14 December 2009
This spreadsheet produces a versatile reusable calendar that can be printed out month by month
Last Updated on Friday, 16 April 2010
Read more...