Everybody loves FRED, including Excel
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, Australia etc) to see what […]
Show currency in Excel with country and symbol
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. All those options let you […]
Pantone’s 2025 color ‘Mocha Mousse’ in Word, Excel and PowerPoint
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 Mousse We make fun of […]
An Excel shortcut that can speed (or confuse) your day
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 is more complicated. Some online […]
How to look inside an Office document
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 to dig into the structure […]
Four different ways to copy a list of file names or folders
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 includes path. If you don’t […]
Office widgets come to Mac computers
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 the Office/Microsoft 365 widgets is […]
Share your Office documents from Dropbox
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 Office/Microsoft 365 desktop apps. You […]
The hidden trap in Excel’s DateDif()
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 a known bug. Despite that, […]
The big difference between what Excel shows and what Excel knows
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 ‘knows’ the right value for […]
How to get the official Porsche color in Word and Office
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 to Office documents using these […]
Excel blooper history – mistakes by users and Microsoft
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 adding rows and columns Back […]
Apple Handoff now in Word, Excel and PowerPoint
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 Apple devices. For example a […]
Halloween icons and symbols for Word, Powerpoint and more
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 Icons are also available in […]
RandArray – Excel’s best way to get random numbers
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 most basic version of the […]
Excel in Fiction
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 some elaborate chess game.” “Safety […]
