Excel Nyheder

Before we dig into Modern Excel, can you please help me out? What, exactly, is “Modern Excel”? I can’t find a standard definition on the Microsoft site, or anywhere else! What Is Modern Excel? On the weekend, I watched a video meetup, “Modern Excel … a Replacement for the Spreadsheet?” The video was interesting, and … Continue reading “Do Your Excel Files Collapse Like Jenga Blocks?”

Are you taking the day off, to celebrate Microsoft Excel’s 40th birthday? Or will you have a big party with your co-workers, at the office or remotely? And what were you doing on September 30, 1985, when the first version of Excel was released, for the Macintosh? 40 Days of Celebrating Leading up to today’s … Continue reading “Happy 40th Birthday Excel September 30 2025”

You can make quick lists with Excel’s AutoFill feature. In the short video below, I show two tricks for making weekday lists – only the Monday to Friday dates, with no weekend dates included. Video: Make Weekday Lists in Excel In this quick video, I show two easy ways to make an Excel weekday list, … Continue reading “AutoFill Weekdays in Excel: Skip Weekends”

In the video below, I show how to get started with the Excel FILTER function, which is available in Office 365. You can enter a formula in one cell, and the results spill down onto the worksheet, to show all the results. And unlike other filters in Excel, the FILTER result list will update automatically, … Continue reading “How to Get Started With Excel FILTER Function”

Which student got the top score? If you have test results, or another list of numbers in Excel, you could sort them to see which scores are at the top. But if you want to leave the list in alphabetical order, you can use the RANK function to show the rank for each score. Video: … Continue reading “Compare List of Numbers With Excel RANK Function”