Technology
Issue: December 2024 / January 2025

Excel Spreadsheets: Groupby and Pivotby

By - November 25, 2024

Traci Williams introduces us to two brand new and shiny formulas in Excel!
Technology
Issue: October / November 2024

Excel Spreadsheets: Stock Management

By - September 25, 2024

Traci Williams explains how to use Excel as the tool of choice for creating an effective stock management system
Technology
Issue: August / September 2024

Excel Spreadsheets: Tips for Maintaining Data Accuracy and Integrity in Excel

By - July 25, 2024

Traci Williams introduces techniques to give you confidence that your data integrity is of a very high standard
Technology
Issue: June / July 2024

Excel Spreadsheets: Shortcuts and Time-Saving Tips

By - May 25, 2024

Traci Williams shares some essential shortcuts and tips to help you work with Excel faster and smarter
Technology
Issue: December 2023 / January 2024

Excel Spreadsheets: The Aggregate Function

By - November 25, 2023

The aggregate function is a powerful tool that enhances data analysis by offering a range of functions while allowing for exclusions, explains Traci Williams
Productivity Technology
Issue: October / November 2023

Excel Spreadsheets: Streamlining Administrative Tasks with Excel Macros

By - September 25, 2023

Traci Williams provides a comprehensive guide on how to leverage Excel macros to enhance your productivity
Technology
Issue: June / July 2023

How to Use an Excel Spreadsheet to Manage Your Tasks

By - May 25, 2023

Upgrade your manual to-do list with Traci Williams’ top tips on using Excel to manage your tasks
Technology
Issue: February / March 2023

Excel Spreadsheets: Mistakes

By - January 25, 2023

Errors in your spreadsheet? Traci Williams shares her recommendations for dealing with mistakes in Excel
Technology
Issue: December 2022 / January 2023

Excel Spreadsheets: Styles

By - November 25, 2022

Using ‘Styles’ is a great way to apply lots of formatting styles consistently to spreadsheets, explains Traci Williams
Technology
Issue: October / November 2022

Excel Spreadsheets: Protecting Spreadsheets

By - September 25, 2022

Traci Williams explains how to protect formulas from being overwritten
Technology
Issue: June / July 2022

Fabulous Formatting for Excel Spreadsheets

By - May 25, 2022

Traci Williams offers useful formatting tips for your Excel spreadsheets
track your time
Technology
Issue: April / May 2022

Track Your Time

By - March 25, 2022

Traci Williams explains how to set up a spreadsheet so that you can track your time
Technology
Issue: December 2021 / January 2022

Using Pivot Tables and Pivot Charts

By - November 25, 2021

Traci Williams shares her Excel expertise and unlocks the mysteries of Pivot Tables and Pivot Charts
spreadsheet: tables and grpahs on laptop screen
Technology
Issue: October / November 2021

Excel Spreadsheets: Where to Start

By - September 25, 2021

Traci Williams guides us through the best ways to set up a spreadsheet