Excel Tutorials

Learn how to prevent Excel replacing the last 5 digits with zeros

How to change a number that displays E+ at the end so that it displays correctly

Create a dynamically-updating copy of specific columns from a Table

Convert text from one case to another using formulas or Power Query

Embed an image inside a cell using a feature that is available to ALL Excel users

Show progress against actual using automatically-updating traffic lights

Build a simple Excel-based tracker to track match results and attendances

How to add shapes and icons to a dashboard and link them to cells

The IF function in Excel doesn’t support the use of wildcards. Here’s a workaround