Modern Excel lets you make a whole monthly calendar from just one cell formula. We’ll explain how it’s done with a sample workbook for our supporters. At its simplest, Excel can make a single month like this from a formula in cell A6 which fills all the cells with the
Get Economic data or graphs from FRED (Federal Reserve Economic Data) to load into your Excel workbooks or PowerPoint slides. From unemployment rates to the price of potato chips. FRED has 825,000 data sets for the USA and around the world. Tip: search FRED for your country (Canada, United Kingdom,
How to show currency amounts in Excel with the country and correct currency symbol included. Excel doesn’t support the standard way that different currencies are displayed with their country codes like this: Dig into the Accounting/Currency Formats and you’ll find these among a VERY long list of currency symbol options.
Pantone’s color of the year for 2025 is “Mocha Mousse”. You can use that exact color in Word, Excel, PowerPoint, Outlook and Designer using the Hex/RGB color code. And we’ll look at the flowery prose that’s become a hallmark of this annual promotion. The color of 2025 is … Mocha
Enter the Ctrl + – (minus) shortcut in Excel. This powerful shortcut instantly deletes entire rows or columns without any confirmation. But there’s hidden trickery going on and some misleading info online. Ctrl + – is commonly said to “delete the selected row or column” but, as usual, the reality
Dig into a Microsoft Office document file, such as Word, Excel, or PowerPoint, and see its inner workings, here’s a straightforward method. It reveals the small files that comprise an Office document, mostly XML files, which you can easily explore with a text editor. Very occasionally it’s helpful or necessary
There are many ways to get a list of file names and folders, here’s four simple ways including one that might be a surprise. Copy from Explorer In Windows Explorer, select the files you want then right-click and choose “Copy as path” or Ctrl + Shift + C. The list
The existing Office app “Recent documents” widgets for iPhone and iPad are now available on Mac computers. There are widgets for Excel, Outlook, PowerPoint and Word. Each app has four widget options from small (one file) to a six file with thumbnails ‘extra large’ choice. The fastest way to find
OneDrive isn’t the only choice for sharing Office documents. Dropbox can also share Word, Excel or Powerpoint documents including real-time collaboration. The Dropbox and Microsoft Office integration allows users to open, edit, and save Office files directly from Dropbox. Use either Office apps on the web (Office Online) or modern
There’s a hidden trap in Microsoft Excel’s DateDif function that rarely gets a mention and is too easy to overlook. DateDif() is a long-standing Excel function that returns the duration between two dates. It’s not a ‘full’ Excel function because it was added for compatibility with Lotus 123 and has
Understanding the difference between Excel’s stored value for a cell and its displayed value is important. It happens a lot and can make a big difference to the results. Back in the day we detailed a bug in Excel 2007 where the wrong number appears on the screen yet Excel
How to get the official Porsche color “Turbonite” in Microsoft Office for Word documents, PowerPoint slides and more. The color has been announced by Pantone with the code PMS-2336-C. Porsche Turbonite is described in the usual flowery terms by Pantone: Turbonite color codes It’s easy to apply the Turbonite color
Excel is now 40 years old and it’s capable of some amazing things. Let’s not forget some of the mistakes made by users and serious bugs by Microsoft along the way. First a reminder of some Excel bugs and how Microsoft never seems to learn from their mistakes. Excel bug
Microsoft 365 for Mac can now use the Apple Handoff option to pass a document between a Mac computer, iPhone or iPad. We’ll also explain how to get a similar feature on any combination of devices Apple or Android. Apple Handoff lets you pass control of an open document between
Quickly add a Halloween ghost, pumpkin, witches’ hat and more to your Outlook email, Word document or PowerPoint slides which have many in-built icons, graphics and pictures to enhance your “All Hallows’ evening” Icons, Stock Images, Stickers and Illustrations are all available in Microsoft 365 for Windows or Mac. Some
My ‘go to’ way to get random numbers in Excel is the new-ish RandArray because can do everything that Rand() or RandBetween() can and more. RandArray() fills cells with random numbers for as many rows and columns as you want. It’s in Excel 365, Excel 2024 and Excel 2021. The
Excel is everywhere including in crime fiction here’s some examples. Jo Livingstone has compiled some excerpts from novels that mention Excel. “George spent the next week glued to the chair in front of his computer, plugging new figures into his Excel spreadsheet, moving them about from column to column like
If you’ve used OneNote recently, you’re probably aware of the feature allowing you to draw shapes and make lines straight. Then Word for Windows got “Draw and Hold”. Now Excel and PowerPoint can draw straight lines and draw neat shapes (circle, square and more). We’ll explain how it works and how
A nice extra coming to Excel 365 highlights the selected cell, row and column with a single click or use an Excel trick to get the same and even better look now. Until now, that’s only been possible with some conditional formatting and a touch of VBA. Excel 365 will
Make it easier to see your current cell in an Excel workbook by dynamically highlighting the selected row, column, cell or headings. Here’s obvious and more subtle highlighting options plus the downside of highlighting, real world tips and debugging tricks if you’re having trouble. There are many different variations on
Excel can make bar charts in-cell without bothering with the full Chart system. Despite what you might have seen, there’s plenty of options in Excel Data Bars. The usual example of Excel Data Bars has the colored bar in the same cell as the value. In this article we’ll show
The new version of Microsoft Office 2024 is now on sale to the general public all around the world. This is the ‘perpetual licence’ or single purchase release with no subscription fee. Office 2024 is now available direct from Microsoft.com and some retailers at the same prices as Office 2021.
An 85-year-old blunder has just been fixed at Westminster Abbey to change the spelling to Brontë with the important diaresis. Here’s how to type an ë in Word and other matters arising. Here’s how the memorial to the Brontë sisters looked in Poets Corner until a few days ago. For
A short video which brings up some interesting points in the early development history of Microsoft Office, some might surprise you. Microsoft Office started as separately sold products (Word, Excel, PowerPoint and Outlook) and only gradually did they become an integrated package with shared components, consistent interface and some interconnections.
