Open in app
Home
Notifications
Lists
Stories

Write
Andrew Moss
Andrew Moss

Home

About

Published in CodeX

·Pinned

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, they have official status. A table is an object with its own features and capabilities. Simply dumping some data onto…

Excel

19 min read

The Ultimate Guide to Excel Tables
The Ultimate Guide to Excel Tables

Published in CodeX

·Pinned

How to Use VLOOKUP in Excel

The VLOOKUP function enables you to search for a value in one column and return another from the same row in a different column. As it works from top to bottom, the ‘V’ stands for vertical. Arguably, it’s the most famous function in Excel and one of the first you’ll…

Excel

7 min read

How to Use VLOOKUP in Excel
How to Use VLOOKUP in Excel

Pinned

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 cannot replicate the experience of picking balls out of a bag, pot or capsule, but it’s the next best thing! …

Excel

4 min read

Cup Draw Simulator — Excel Edition
Cup Draw Simulator — Excel Edition

Published in CodeX

·Pinned

Analysing 10 Million Rows in Excel

Proving it does have a place in big data. — 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 data has increased exponentially over the past two decades. There is no universal threshold determining where big data starts. However…

Excel

13 min read

Analysing 10 Million Rows in Excel
Analysing 10 Million Rows in Excel

Published in CodeX

·Pinned

Introducing the New LAMBDA Function in Excel

Another game-changer from Microsoft — It’s fair to say that Excel formulas are becoming like a programming language. Over the past couple of years, Microsoft has fundamentally changed Excel’s calculation engine and introduced a set of functions that allow us to construct formulas to do much more with less. It doesn’t stop there. If you…

Excel

10 min read

Introducing the New LAMBDA Function in Excel
Introducing the New LAMBDA Function in Excel

Jul 28

How to Join the Office Insider Program

Be amongst the first to test new features. — 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 to the wider public. In doing so, you are helping developers improve them by submitting diagnostics data and feedback. Whether…

Microsoft

6 min read

How to Join the Office Insider Program
How to Join the Office Insider Program

Published in CodeX

·Jul 25

How to Insert Data From a Picture in Excel

For Windows users. — 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 a worksheet. This can be a real timesaver and prevents the need to carry out data entry work manually. It’s…

Excel

4 min read

How to Insert Data From a Picture in Excel
How to Insert Data From a Picture in Excel

Published in CodeX

·May 27

How to Generate Random Numbers in Excel

What do lottery balls, dice, and a roulette wheel have in common? They are based on randomness, which cuts across numerous fields and exists in different forms. You might want to generate random numbers to test a financial model, create sample data, or simulate sports fixtures. This article takes a…

Excel

8 min read

How to Generate Random Numbers in Excel
How to Generate Random Numbers in Excel

Published in CodeX

·Mar 11

How to Create an Excel Calendar

Three worksheet examples explained. 📅 — Calendars are useful for scheduling events, constructing to-do lists, and managing projects. Many applications exist for mobile and desktop, such as Outlook, iCloud Calendar, and Google Calendar. Whilst these are feature-packed and great for day-to-day use, nothing beats an Excel calendar for true customisation. This article looks at three modern…

Excel

14 min read

How to Create an Excel Calendar
How to Create an Excel Calendar

Feb 21

How to Automatically Import macOS Screenshots into Photos

Using Automator. — Apple loves to bang on about creating seamless and synergistic experiences. After all, Steve Jobs used to trot out the phrase “It just works” to describe any new product or service. Dig a bit deeper though and you’ll find a few anomalies that don’t align with their philosophy. The one…

Photos

5 min read

How to Automatically Import macOS Screenshots into Photos
How to Automatically Import macOS Screenshots into Photos
Andrew Moss

Andrew Moss

Technical Writer | Spreadsheet Creator | Excel Aficionado | LinkedIn: https://www.linkedin.com/in/andrewcharlesmoss/

Following
  • TDS Editors

    TDS Editors

  • Sinem Günel

    Sinem Günel

  • Tim Denning

    Tim Denning

  • Medium Creators

    Medium Creators

  • Tony Stubblebine

    Tony Stubblebine

Help

Status

Writers

Blog

Careers

Privacy

Terms

About

Knowable