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

andrewcharlesmoss / excel-files Goto Github PK

excel-files's Introduction

excel-files

excel-files's People

Contributors

Stargazers

Watchers

Recommend Projects

React

Vue.js

Typescript

TensorFlow

Django

Laravel

D3

Recommend Topics

javascript

web

server

Machine learning

Visualization

Game

Recommend Org

Facebook

Microsoft

Google

Alibaba

D3

Tencent