1 |
18/07/2020 |
Building an Excel Football League Table — Traditional vs Dynamic Array Methods |
League-Table-Examples.xlsx |
2 |
19/07/2020 |
Introducing the New LET Function in Excel |
LET-Function-Example.xlsx |
3 |
18/09/2020 |
Building a Premier League Results Matrix in Excel |
Results-Matrix.xlsb |
4 |
26/09/2020 |
United States 2020 Presidential Election Simulator |
2020-US-Election-Simulator.xlsm |
5 |
12/10/2020 |
United States 2020 Presidential Election Simulator v2 |
2020-US-Election-Simulator-v2.xlsm |
6 |
03/11/2020 |
What Would Happen if the Election Was Tied? |
|
7 |
22/11/2020 |
Combining Multiple Excel Tables Into One |
Combining-Lists.xlsx |
8 |
26/12/2020 |
Excel’s Little-Known Cell Modes |
|
9 |
25/01/2021 |
How to Build a Custom Ribbon in Excel |
Ribbon-Example.xlsm |
10 |
26/01/2021 |
Medium Has an Image Problem |
|
11 |
08/02/2021 |
Introducing the New LAMBDA Function in Excel |
LAMBDA-Examples.xlsm |
12 |
15/02/2021 |
Five Times Excel Led to Disaster |
|
13 |
02/03/2021 |
How Does Excel Handle Unfiltered and Hidden Rows? |
Unfiltered-Rows-v-Hidden-Rows.xlsb |
14 |
16/03/2021 |
10 Features in Sheets Excel Needs |
Sheets-v-Excel |
15 |
20/04/2021 |
20 Amazing Google Sheet Functions You Won’t Find in Microsoft Excel |
|
16 |
29/04/2021 |
How to Extract Unique Values in Excel |
Extracting-Unique-Values.xlsb |
17 |
08/06/2021 |
How Excel Stores and Displays Data |
How-Excel-Stores-and-Displays-Data.xlsm |
18 |
30/06/2021 |
Finally. A Historic Night at Wembley to Savour. |
|
19 |
12/07/2021 |
The Definitive Guide to Data Validation in Google Sheets |
|
20 |
13/07/2021 |
Euro 2020 Stats Tracker |
Euro 2020 Stats Tracker |
21 |
18/07/2021 |
Euro 2020 Stats Review |
|
22 |
23/07/2021 |
Why Every Excel User Needs Microsoft 365 |
|
23 |
05/08/2021 |
How to Use Goal Seek in Excel |
Goal-Seek-Example.xlsb |
24 |
18/08/2021 |
Why You Should Stop Using Merge & Center in Excel |
|
25 |
10/09/2021 |
25 Outlook Calendar Tips and Tricks |
|
26 |
23/09/2021 |
How to Calculate Multiple Values in the Same Cell |
Calculate-Values-in-Same-Cell-Examples.xlsb |
27 |
19/10/2021 |
Celebrating the Unsung Hero: The Spreadsheet |
|
28 |
01/11/2021 |
Excel Cell Errors Explained |
Cell-Error-Examples.xlsb |
29 |
19/11/2021 |
Analysing 10 Million Rows in Excel |
|
30 |
11/12/2021 |
How Fast is Fast Data Load in Power Query? |
|
31 |
25/12/2021 |
How to Create an Animated Christmas Tree in Excel |
Christmas-Tree.xlsb |
32 |
01/01/2022 |
Happy New Year! |
|
33 |
19/01/2022 |
How to Create a Star Rating System in Excel |
Star-Rating-Systems.xlsb |
34 |
17/02/2022 |
Medium’s Problem with Transparent Images |
|
35 |
21/02/2022 |
How to Automatically Import macOS Screenshots into Photos |
|
36 |
11/03/2022 |
How to Create a Calendar in Excel |
Calendar-Examples.xlsb |
37 |
14/05/2022 |
Cup Draw Simulator — Excel Edition |
Cup-Draw-Simulator-v1.00.xlsb |
38 |
27/05/2022 |
How to Generate Random Numbers in Excel |
Random-Number-Examples.xlsb |
39 |
18/06/2022 |
How to Use VLOOKUP in Excel |
VLOOKUP-Examples.xlsb |
40 |
08/07/2022 |
The Ultimate Guide to Excel Tables |
|
41 |
25/07/2022 |
How to Insert Data From a Picture in Excel |
|
42 |
28/07/2022 |
How to Join the Office Insider Program |
|
43 |
01/11/2022 |
A simple guide to web scraping in Power Automate |
|