Excel

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: April / May 2024

Excel Spreadsheets: Budget Management

By Traci Williams - March 25, 2024

Traci Williams explains how to use Excel’s functions and features to create a budget for your project

Technology
Issue: February / March 2024

Excel Spreadsheets: Creating Impactful Excel Charts and Graphs

By Traci Williams - January 25, 2024

Excel can be a powerful ally in creating charts and graphs that not only communicate data but also tell a compelling story, says Traci Williams

Technology
Issue: August / September 2023

Excel Spreadsheets: Common Excel Questions

By Traci Williams - July 25, 2023

Traci Williams shares her answers to the most common Excel questions she is asked

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: Take Your Pivot Tables to the Next Level

By Mike Thomas - January 25, 2023

Mike Thomas explains how to use the data model to work around some of Excel's pivot table limitations

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

Technology
Issue: October / November 2022

Excel Spreadsheets: Protecting Spreadsheets

By Traci Williams - September 25, 2022

Traci Williams explains how to protect formulas from being overwritten

Technology
Issue: June / July 2022

Fabulous Formatting for Excel Spreadsheets

By Traci Williams - May 25, 2022

Traci Williams offers useful formatting tips for your Excel spreadsheets

Technology
Issue: April / May 2022

Track Your Time

By Traci Williams - March 25, 2022

Traci Williams explains how to set up a spreadsheet so that you can track your time

Technology
Issue: February / March 2022

Please Excuse My Dear Aunt Sally

By Karen Roem - January 25, 2022

Use mnemonics to help you remember tips, shortcuts and formulas across Microsoft Office, explains Karen Roem