Published in CodeX·PinnedMember-onlyThe Ultimate Guide to Excel TablesA 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…Excel19 min read
Published in CodeX·PinnedMember-onlyHow to Use VLOOKUP in ExcelThe 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…Excel7 min read
PinnedMember-onlyCup Draw Simulator — Excel EditionEver 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! …Excel4 min read
Published in CodeX·PinnedMember-onlyAnalysing 10 Million Rows in ExcelProving 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…Excel13 min read
Published in CodeX·PinnedMember-onlyIntroducing the New LAMBDA Function in ExcelAnother 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…Excel10 min read
Jul 28Member-onlyHow to Join the Office Insider ProgramBe 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…Microsoft6 min read
Published in CodeX·Jul 25Member-onlyHow to Insert Data From a Picture in ExcelFor 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…Excel4 min read
Published in CodeX·May 27Member-onlyHow to Generate Random Numbers in ExcelWhat 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…Excel8 min read
Published in CodeX·Mar 11Member-onlyHow to Create an Excel CalendarThree 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…Excel14 min read
Feb 21Member-onlyHow to Automatically Import macOS Screenshots into PhotosUsing 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…Photos5 min read
