If you’re already using colour to organise your Excel spreadsheets, here’s some good news — you can filter by that colour too. Excel filter by colour lets you instantly show only the rows that match a specific colour — whether that’s a background fill or a font colour. It’s one of those features that feels […]
Why Your Colour-Coded Excel Data Deserves a Better Filter Read More »
If you’ve ever copied something in Excel and ended up with a completely different result than you expected, you’ve probably fallen foul of one of Excel’s little quirks. The good news is that once you understand Excel Paste Values, you’ll know exactly how to handle it – and it only takes a couple of extra
Excel Paste Values – Get Exactly What You See, Every Time Read More »
If you’ve ever stared at a column of numbers and thought “I just want to see the pattern” — Excel Sparklines are about to become your new favourite thing. These miniature charts sit inside a single cell, right next to your data, giving you an instant visual snapshot without the faff of building a full
Excel Sparklines: The Tiny Charts Making a Big Difference Read More »
If you’ve ever exported data and thought “why is everything jumbled together in one column?”, Excel Flash Fill is about to become your new best friend. It’s one of those features that looks impressive but is actually really simple to use — and once you know it, you’ll find yourself reaching for it again and
Do You Know All the Excel Flash Fill Tricks? Read More »
When most people think about keyboard shortcuts, Microsoft Word typically comes to mind first. However, as an Excel enthusiast, I’m here to tell you that Excel has its own powerful set of keyboard shortcuts that can dramatically improve your productivity. Today, I’ll guide you through the complete A-Z of Excel’s keyboard shortcuts for Windows users.
The Complete A-Z Guide to Excel Keyboard Shortcuts: Master Your Productivity Read More »
Unsure of which online spreadsheet program to choose? Find out here the features and benefits of both Microsoft’s Excel and Google Sheets, as well as some tips on how to pick the right one for your needs.
How to choose your favourite online spreadsheet Read More »
What are the information functions in MS Excel? How can you make use of the data they add into your spreadsheet. Read the post to learn more.
What’s the point of the Excel Information Functions? Read More »
Unsure how to work with dates and times in Excel? This guide will show you how, with a variety of date and time functions explained.
How to use Date and Time Functions in Excel Read More »
Learn how to use the VLookup function step by step and you’ll find that it’s actually not as difficult as you might think. Check out this guide to some of the basics!
VLookup in Excel: What Do You Need to Know Step by Step Read More »
Unsure of how the IF statement in Excel works? This guide will walk you through all the basics, as well as some more advanced features, so that you can start using this function to its full potential.
Excel IF Statement: What do you need to know Read More »
