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...
|
|
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...
|
|
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...
|
|
|
|
|