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

Excel Spreadsheets: Budget Management

By - 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 - 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 - 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 - 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 - 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 - 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: February / March 2022

Please Excuse My Dear Aunt Sally

By - January 25, 2022

Use mnemonics to help you remember tips, shortcuts and formulas across Microsoft Office, explains Karen Roem
Technology
Issue: February / March 2022

Excel Spreadsheets: Using Vlookup and Index / Match

By - January 25, 2022

Traci Williams explains the similarities and differences between Vlookup and Index / Match
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
Technology
Issue: January / February 2020

Creating a Good List in Excel

By - January 25, 2020

In this extract from “Dirty Data: Excel techniques to turn what you get into what you need” Melissa Esquibel explains the importance of a good list in excel