Skip to content

andrewcharlesmoss/excel-files

Folders and files

NameName
Last commit message
Last commit date

Latest commit

 

History

97 Commits
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 

Repository files navigation

excel-files

This table contains links to Medium articles and complementary Excel/Sheets files.

# Published Article Workbook
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