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.
While it lasts, check out some free classes about Python in Excel for better data analysis, DataFrames, charts & visualizations and machine learning. We’re a big fan of Python in Excel and these lessons should help those of us who haven’t yet caught the Python bug. Advance Your Python in
Excel 365 now has Python features included for all business and enterprise customers with a Microsoft 365 software licence Python is a powerful programming language with many great libraries of tools for analysis and charting. It’s a massive extension to Excel that we’ve already raved about. Python Editor for Excel
Excel 365 now has access to the Python language and packages. We’ll explain what that means, who gets it and why Python in Excel is a big deal. Python is a high-end and widely used programming language with many features in its many packages or add-ons. It’s this last bit
Keep up to date with Microsoft Office 2024, the new and latest version of Office. It’s features, price, support and requirements. Office 2024 is what Microsoft calls a ‘perpetual licence’ version of Office. A single payment for ongoing use of the software with no annual payments (aka ‘subscription). It replaces Office
A new collection of Copilot features have been released under the banner “Wave 2” with inclusions for Excel, PowerPoint, Outlook, Word and Teams. Don’t get too excited because there’s ‘fine print’ that limits who can catch this wave. Before we explain a little of what’s in the new set of
What to do if Excel’s columns have numbers across the top instead of letters. There’s a simple setting to switch between two different ways of labelling cells. You open an Excel workbook and the column headings look all wrong – instead of letters (A, B C …) there are numbers.
In-cell charts in Excel provide a powerful method to visualize data trends and patterns. They allow you to quickly derive insights within a worksheet, making information interpretation more straightforward without fussing about with full charts. We’ll explain how to make in-cell charts and then go further and show how to
How to lock your Excel worksheet from editing – the whole thing or some cells. Allow some people to edit a few cells, leaving the rest of the cells and formulas untouchable by others using the worksheet. Here’s a very simple example: Anyone opening the worksheet can enter a US
Here are two ways to quickly make up list or tables of fake data to use in Excel worksheets. Use them to test a workbook or code. GenerateData.com There are a few websites that can make fake lists, we prefer https://GenerateData.com for its simple interface and many options. Just some
The Workplace Discount Program (formerly Home Use Program) offers 30% discounts on Microsoft 365 to employees of many organizations and government agencies. Here’s how the Workplace Discount Program (WDP) works, the tricks and traps. What is the Workplace Discount Program – WDP? Organizations (companies, governments etc.) that have Microsoft 365