Traci Williams

Productivity Technology
Issue: February / March 2026

Excel Spreadsheets: Dynamic Arrays Part 2

By Traci Williams - February 1, 2026

Traci Williams explains more Dynamic Array formulas to make you look like an Excel ACE

Technology
Issue: December 2025 / January 2026

Excel Spreadsheets: Dynamic Arrays

By Traci Williams - December 29, 2025

Traci Williams explains how one formula can do the work of dozens – and make you look like an Excel ACE

Technology
Issue: October / November 2025

Excel Spreadsheets: Quick Tips

By Traci Williams - September 27, 2025

Traci Williams explains the small wins that’ll make a change every day

Technology
Issue: August / September 2025

Excel Spreadsheets: Using Artificial Intelligence (AI) with Excel

By Traci Williams - July 25, 2025

Traci Williams, a Microsoft Excel Most Valuable Professional, gives us the rundown on which AI tools work best with Excel

Technology
Issue: June / July 2025

Excel Spreadsheets: Tables

By Traci Williams - May 25, 2025

An Excel table is not just formatting, explains Traci Williams

Technology
Issue: April / May 2025

Excel Spreadsheets: Sort and Filter Formulas

By Traci Williams - March 25, 2025

Dynamic sorting and filtering can transform how you work with data in Excel, making complex tasks simpler and more efficient, says Traci Williams

Technology
Issue: February / March 2025

Excel Spreadsheets: Error Checking

By Traci Williams - January 25, 2025

It is imperative that we check, identify and resolve spreadsheet errors efficiently so that the data can be relied on, explains Traci Williams

Technology
Issue: December 2024 / January 2025

Excel Spreadsheets: Groupby and Pivotby

By Traci Williams - 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 Traci Williams - 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 Traci Williams - 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 Traci Williams - 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 Traci Williams - 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 Traci Williams - 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 Traci Williams - 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 Traci Williams - 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 Traci Williams - November 25, 2022

Using ‘Styles’ is a great way to apply lots of formatting styles consistently to spreadsheets, explains Traci Williams