Skip to content
Andrew Moss
  • Home
  • About Me
  • Contact Me
Linkedin Linkedin
Andrew Moss
Linkedin Linkedin

Andrew Moss

Excel Aficionado

A simple guide to web scraping in Power Automate

5 minute read
A simple guide to web scraping in Power Automate

If you’re a technophobe, you probably want to avoid coding at all costs. Thankfully, Microsoft Power Automate empowers you to create powerful workflows without a jot of code. No-code (and…

Read More

The Ultimate Guide to Excel Tables

19 minute read
The Ultimate Guide to Excel Tables

A table is defined as “a set of facts or figures systematically displayed, especially in columns.” They structure data in a way that ensures fast and efficient readability. In Excel,…

Read More

Building an Excel Football League Table — Traditional vs Dynamic Array Methods

10 minute read
Building an Excel Football League Table — Traditional vs Dynamic Array Methods

Introduction I am going to show you the different ways you can build a football league table in Excel. Some of the methods are old school, but others utilise Excel’s…

Read More

How to Create a Star Rating System in Excel

12 minute read
How to Create a Star Rating System in Excel

Star rating systems are commonly used to rank things like films, TV shows, hotels, and shopping products. Typically, they are done on a scale of 1–5 (or 0–5), although you…

Read More

How Fast is Fast Data Load in Power Query?

8 minute read
How Fast is Fast Data Load in Power Query?

In my previous article, Analysing 10 Million Rows in Excel, I showed you how to load a dataset into Power Query consisting of 10 million rows. In truth, it can…

Read More

How to Build a Custom Ribbon in Excel

18 minute read
How to Build a Custom Ribbon in Excel

Microsoft’s ribbon interface has been with us since the launch of Office 2007. Although met with mixed reaction, over time many acknowledged it was a viable replacement for the ageing…

Read More

Building a Premier League Results Matrix in Excel

25 minute read
Building a Premier League Results Matrix in Excel

Maybe you’re a football fan — maybe you’re not. Besides, the new Premier League season started last weekend. Amidst the empty stadiums and general doom and gloom, you’d be forgiven for not…

Read More

How to Join the Office Insider Program

5 minute read
How to Join the Office Insider Program

Want to get ahead of the curve in your favourite Office app? Join the Office Insider Program to test and explore new features in Office apps before they are released…

Read More

Analysing 10 Million Rows in Excel

12 minute read
Analysing 10 Million Rows in Excel

Big data is a term used since the early 1990s to describe “huge, overwhelming, and uncontrollable amounts of information”. The rapid rise of the internet has meant the volume of…

Read More

Combining Multiple Excel Tables Into One

16 minute read
Combining Multiple Excel Tables Into One

A few months ago I encountered a scenario I hadn’t faced before. I was dealing with a large number of financial transactions from multiple bank accounts that were being housed…

Read More

Cup Draw Simulator — Excel Edition

3 minute read
Cup Draw Simulator — Excel Edition

Ever watched a cup draw on television? I’m sure you have. Arguably, the most famous one is football’s FA Cup. I’ve built the virtual equivalent in Excel. Of course, it…

Read More

How to Insert Data From a Picture in Excel

3 minute read
How to Insert Data From a Picture in Excel

Want to digitise that document, receipt, or book page? Data from Picture is an Excel feature that allows you to extract the text from an image and insert it into…

Read More

Load More
Load More
Linkedin Linkedin

Copyright © 2025 by Andrew Moss. All Rights Reserved.

  • Home
  • About Me
  • Contact Me