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,
Keep a close eye on the increase/decrease decimals buttons on the Excel ribbon because Microsoft is changing them without warning. Increase / decrease decimals is a very common Excel feature to change the visible accuracy of a number. For example, choosing Currency or Accounting style (which defaults to two decimal
Word can do simple calculations because Word for Windows has its very own built-in calculator. Calculate in Word has some nice tricks but also problems and traps. Type a calculation, hit the button (see below) and the result appears in the status bar AND it’s loaded into the clipboard ready
How to get greater accuracy out of Word’s in-built calculator. Recently, we unearthed Word’s hidden calculator. Word rounds its calculator results to two decimal places. This time, we’ll take a look at the two ways to improve the accuracy of Word calculator results. Use an old maths trick or change
You haven’t heard about it? Don’t worry, even Microsoft has no information about this feature, unless you dig way back into its archives where you’ll find that the calculator – which formerly held a prominent position on the Tools Menu – was driven underground in Word 6.0 to make way
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
Action buttons in PowerPoint are versatile tools that bring interactivity and control to your presentations. By following a few simple steps, you can insert and customize these buttons to perform tasks such as navigating slides or opening external applications. Incorporating action buttons can greatly enhance audience engagement, making your presentation
The famous London Tube Roundel or station sign is easy to recreate for Word, PowerPoint or other Office apps. The best way to do this is SVG graphics in Microsoft 365, Office 2024/2021/2019/2016. SVG’s let you change the colors and set the text easily. They don’t have to be a
My favorite Outlook calendar view is very useful but most people don’t know it’s there. See today and the next week in one screen. I rarely care what’s happened in the past, I want to see what’s happening in the near future. That’s why my ‘Go To’ calendar view is
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
Microsoft is ending their Publisher desktop publishing product completely. Here’s the vital details you need to know, including how to keep your Publisher software after the end date. Publisher is Microsoft’s desktop publishing software that’s been available since 1991 mostly as part of some Microsoft Office bundles but also sold
Yes, Microsoft Word lets you select vertical (up or down) text blocks. Most text selection in Word involves selecting horizontally – selecting a line or a paragraph of text. Sometimes, though, you need to select a vertical slab of text. To do that, hold down the Alt key while you
Here are the exact colour codes and new names for the ‘Overground’ lines in London, plus how to add a thick double line in Office documents just like on a Tube map. The changeover is happening in late November 2024. Some old rail lines in London were coloured Orange on
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
A PowerPoint action button is a shape you can add to your slides, allowing you to hyperlink to another slide or webpage, play a sound, or trigger other actions. It’s an easy way to add interactivity and navigation to your presentation with very little effort. It’s also a way
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
Stop accidentally turns CAPS ON when you don’t want it. There’s a way to change the Caps Lock key to do something else or nothing at all in both Windows and Mac. Maybe I’m getting clumsy in my old age but on some keyboards I keep hitting the CapsLock key
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 a picture to PowerPoint text background look great and is easier than you might think. Even better, are many hidden options to adjust the image and position it exactly as you want. Curious about how to create text effects like in the image below? Look no further—if you have
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
Here’s what you need to know now there’s only a year left for Office 2016 and Office 2019 before their official support ends. End of Support On 14 October 2025, Microsoft will stop making security and bug fixes for Office 2019 and Office 2016 for both Windows and Mac. Office
