Keep up to date with Microsoft Office 2024, the next version of Office. It’s features, price, support and requirements. The page will be updated as information is released so bookmark this page and return to see what’s happening. Office 2024 is what Microsoft calls a ‘perpetual licence’ version of Office.
Computers are being infected with at least eight different viruses in an attack that uses steganography to hide nasty code in images linked from Word and Excel documents. But there’s good news for most Office users. Steganography is a way to hide text or code in an image or object.
Quickly switch accounts while using Microsoft Office 365, Office 2019 and Office 2021 for Windows and even have different logins in separate programs. Many people wear different ‘hats’ while using Office. There’s a Work ‘hat’ or ‘hats’ with more than one job. Plus your personal or home role. Sometimes even
There are many ways to make pictures smaller, in both senses of the word. Here are three more options plus an important warning. Converting images into a smaller file size is sometimes essential. The large digital camera images (can be 4-6MB each) can be too big for some situations, especially
Pictures in Word, Excel, PowerPoint and Outlook can make the file sizes at lot larger than you expect. Here’s how to make images smaller (in file size) for Office documents without changing the look of the document, slide etc. The images in a document are what take up a lot
How to insert the Coin 🪙 symbol or emoji into Microsoft Word, Excel, PowerPoint or Outlook. Both in Office for Windows and Office for Mac. How Coin 🪙 looks in different fonts Only Segoe UI Emoji font has the coin symbol in standard Windows. Coin 🪙 codes These are the
Pivotby() is a new and easy way to make PivotTables in Excel. It’s one of two new ‘aggregation functions’ but we prefer to call them fast summary powers. We’ll dig into the detail of what PivotBy() can do. Excel has been able to group or combine data for many years
More common Excel desktop features are being added to the browser based version too. Drag and Drop pasting, Autofill, right-click for more Paste options and also export to text file (CSV) format. All these features will be familiar to Excel desktop (Windows/Mac) users and work in much the same way.
There’s a useful but niche Excel warning about date with two digits for the century. That’s a useful precaution but sometimes the warning is wrong! Those of us around at the turn of the century will remember the Y2K problems and possible mistakes with a date that has only two
Copilot AI makes writing Excel formulas a lot easier but you still need to check the results to make sure Copilot has understood want you want and gives the right answer. There’s a lot of hype and promises about how AI can help make work easier. That’s not as true
Grouping in Excel lets you collapse or expand sections of a sheet so you can see the ‘big picture’ but still drill-down to how totals were made. Another use for grouping is hiding rows or columns from view. You can organize and manage data more effectively by grouping together rows
GPT-2 can be squeezed into a Microsoft Excel spreadsheet, providing a functional demonstration of the Transformer architecture used in large language models (LLMs). GPT-2 is an older version of the AI system – Microsoft Copilot and ChatGPT use GPT-4. Ishan Anand made the 1.25GB Excel file as a low-code introduction
A respected author has a warning about the future of AI using the mixed history of spreadsheet mistakes as an example. Tim Harford is an excellent columnist and author known as “the Undercover Economist”. Check out his “More or Less” podcast for the BBC. In a recent article he argues
Excel has some nice choices for clearing out cells quickly. You can remove the contents, the formatting only or both contents and formatting plus choices for deleting just notes, comments and cleaning up links. As you can see the drop-down menu Home | Editing | Clear offers options such as:
Get rid of the over large ‘AutoSave’ slider on the Word, Excel or PowerPoint status bar. The Autosave button (strictly a label plus slider) takes up a lot of room on the top row of modern Office apps. That space is quite crowded and you need it to fit as
Excel has some useful options for printing less than an entire workbook. Printing a selection, active sheets or just a table. As Office-Watch.com has discovered before, there’s a lot more available in Office than a quick look suggests. See Print options are at File | Print then choose the menu
Hex color codes in Microsoft 365 for Windows and Mac aren’t just good for HTML coders, it’s a fantastic shortcut for anyone managing colors in Word, PowerPoint or other Office documents. Hex color codes are an option in Microsoft 365, Office 2021 and Office 2019. It seems like a simple
Make an unpleasant point with the world’s ugliest color. A ‘drab dark green’ can be used in any Word document, Excel sheet or PowerPoint slide. And we’ll explain the recommended complement color and font. It’s not our opinion, but the market researched result of an effort to find the most
There are two options for changing the default fonts in Excel, either for new blank workbooks or existing spreadsheets. Maybe you prefer another font. Perhaps the old default font until mid-2023, Calibri. Or a spreadsheet specialist font like Goldman Sans. Maybe your organization or client has a preferred font? Go
Here’s the simplest way to switch from Aptos fonts in Excel 365/2021/2019 to either the previous font (Calibri) or some other font. In Excel, Aptos Narrow is the new (mid-2023) default font style with a font size of 11, Black. What if you don’t like the new default font? Aptos
Two economics professors have been caught using Excel’s Autofill feature to fill in the blanks to complete a published academic paper. A study on green innovations and patents in 27 countries by two professors has come under scrutiny by a student as reported, by Retraction Watch. The paper was said to use
Compare one set of numbers with another list of values using ChiTest() in Excel. It compares two sets of numbers and gives a single number to show how different the sets are. ChiTest() or ChiSq.Test() sounds like a complex formula that only expert statisticians can understand – not at all!
You can do incredible things in Excel but here’s something truly amazing. Someone has made a 16-bit computer chip (CPU) emulation entirely in Excel. We have links to the source code and fascinating video that explains it all. @Inkbox has recreated the basic logic of a CPU to make a
At long last, there’s a way to get Microsoft Forms results synchronized with an Excel workbook. It’s not what Excel users were expecting but it’s a start. Microsoft is calling this a ‘highly anticipated feature’ which is corporate weasel term for a long-standing customer request that’s finally fulfilled (in part).
Like almost any web site, we use technologies like cookies to store and/or access device information. We aim to keep that to a minimum. Consenting to these technologies will allow us to process data such as browsing behavior or unique IDs on this site. Not consenting or withdrawing consent, may adversely affect certain features and functions. We apologize for this box but it's legally required in some regions.
Functional
Always active
The technical storage or access is strictly necessary for the legitimate purpose of enabling the use of a specific service explicitly requested by the subscriber or user, or for the sole purpose of carrying out the transmission of a communication over an electronic communications network.
Preferences
The technical storage or access is necessary for the legitimate purpose of storing preferences that are not requested by the subscriber or user.
Statistics
The technical storage or access that is used exclusively for statistical purposes.The technical storage or access that is used exclusively for anonymous statistical purposes. Without a subpoena, voluntary compliance on the part of your Internet Service Provider, or additional records from a third party, information stored or retrieved for this purpose alone cannot usually be used to identify you.
Marketing
The technical storage or access is required to create user profiles to send advertising, or to track the user on a website or across several websites for similar marketing purposes.