Excel is getting a new function TrimRange() which should solve a long-standing calculation performance problem. As well as speeding up workbooks, TrimRange() comes with some new range options that add to the well-known colon. Ever since Microsoft added dynamic arrays to Excel there’s been a problem … how to reference
Excel 365 has two new translation functions to identify language from text or translate text from one language to another. Let’s see how the work, some problems and unknowns. New in Excel 365 are: DetectLanguge() to identify the language of the text supplied, hopefully correctly (see below) Translate() converts text
There’s a simple but not so obvious way for Excel to take a list of values and show them grouped into segments or groups. As an example, here’s the results of a class exam with their scores grouped into blocks of 20. It’s done with a tricky use of PivotTables
We went hunting for koalas in Microsoft Office. Found more than 18 of the cuddly marsupials for Word, PowerPoint or Outlook. There are emoji, Office icons, SVG, online images and more making a colony or cling of koala (either can be the collective noun for koala). None of the endangered
Microsoft 365 for Windows might crash while someone is just typing (you read that right). All the Office apps, Word, Excel, PowerPoint, Outlook or OneNote can be affected according to Microsoft, which knows about the problem and offers some workarounds. The problem is caused by an out-of-date language pack which
As promised, Excel 365’s Regular Expression support has been extended to include both Xlookup() and XMatch() functions. Regex adds a huge amount of power to matching results from a table. Back in July, Excel 365 added three Regular Expression (regex) functions, RegexTEST(), RegexEXTRACT() and RegexREPLACE(). At the time Microsoft promised
There are quicker ways to use the View Zoom slider in Microsoft Word and one little-known trick that works in other Microsoft Office apps, Excel and PowerPoint. Plus a related Windows volume tip. Scroll to View Zoom Hover the mouse pointer over the Zoom slider (bottom right in Word, Excel
Excel 365’s Linked Data Types are technically impressive. However, the reliability of the data is a problem Microsoft doesn’t talk about. We discovered mistakes with the data without actively looking for them. In general, the data sources are ‘scraped’ from sites like Wikipedia which explains some, but not all, of
Excel 365’s Geography data type isn’t totally reliable or accurate. Looking at its results for the UK (United Kingdom) vs Great Britain is just one example of the problems you need to watch out for. If you’re not clear on the difference between United Kingdom and Great Britain, see below.
We’ve expanded our live Paris Olympics medal table to compare countries’ performances to their population or wealth. Along the way we explain how to cope with some problems that can arise when Excel theory hits the Real World. Our newsletter readers get a working example workbook to try themselves. We
Excel for Mac is now getting the ‘From Folder’ option in PowerQuery. An important part of the PowerQuery puzzle. PowerQuery’s ‘From Folder’ lets you add more data to a query simply by adding data files into a folder. PowerQuery will then scoop up all the data and add it to
Use Excel to get your own automatically updating Medal Table for the 2024 Paris Olympics then make charts and maps too. Our newsletter readers get a working example workbook to try themselves. Not interested in the Olympic medal count? This article and download are a good, working example of how
Here’s where to get the real official Olympic logo (color or monochrome) for Microsoft Office documents, sheets, slides or emails. Also the correct color codes to match the rings. As usual, the most reliable place for a common logo is Wikipedia which has both SVG (Microsoft 365, Office 2021/2019) and
Here’s some more ordinal rank (First, 2nd etc.) options for Excel including with joint or equal results plus special fun wording. In a previous article we looked at options for showing ordinal numbers in Excel, now we’ll go a step further to cope with joint or equal results plus special
Discover the exciting way to insert Olympic-style rankings into Microsoft Excel, featuring Gold, Silver, Bronze, and even fourth place, with equal/joint placings beautifully noted!” 🥇🥈🥉 Use this to make the right wording for a published table of results in the Olympic-style (Gold, Silver, Bronze) with joint or multiple equal winners
Microsoft Office 365 for Mac is getting KeyTips for faster ribbon navigation from the keyboard in Word, Excel, PowerPoint and OneNote. It’s another “About Bloody Time” late innovation from Microsoft. Office for Windows has Keytips since Office 2007, it’s only taken Microsoft over 15 years to do the same for
Wanna be a better, faster Office user? Impress your friends? Be the envy of women and men for miles around? Try out Office KeyTips – the keyboard shortcuts you don’t have to memorize because they are on the screen. Simply press a few keys to accomplish tasks quickly, no matter
A US government department has accidentally revealed a secret by overlooking the obvious in Office document security, the file name. Microsoft Office helps you scrub documents of private or secret information before sending. It’s easy to overlook the obvious data leaks that ‘Inspect Document’ doesn’t cover. ‘Inspect Document’ checks for
Excel on the web has a new look and some nifty extra features like better ways to arrange rows/columns – move, resize, insert. A clever Freeze Pane option too. Some of these we’d love to see in desktop Excel. Overall, the web version of the Office apps now look more
Microsoft Office has a Remove Background tool for images but there are two better, faster and free ways to do the same job. Background removal lets you get an image with a transparent surround which can be merged/overlaid into any other slide or document more seamlessly (left) than a separate
Add Spain’s national flag into Office documents, Word, Excel or PowerPoint, then use some Office picture tools to enhance the image. Get the Spain Flag Image There are many, many copies of the Spanish flag available. We’ve opted for the Wikipedia site because it has an SVG scalable version (preferred)
You don’t need to pay for Microsoft’s AI service, Copilot, to get some of its benefits in Microsoft Office, especially Word, Outlook and Excel. Try converting text to a table or vice versa. The trick to grabbing text from an image. Along the way you’ll also discover some of the
Don’t miss this often overlooked Office trick, changing the color of an image or graphic in Word, Excel, PowerPoint, or Outlook. We did this in our article about inserting Prince’s ‘Love Symbol Number 2’ in Office documents. The image is available in various formats but always black, not purple. As
The nifty Excel ‘Data from Picture’ feature is in all Excel 365. It’ll convert a picture of text & numbers into a worksheet … almost. And there’s alternatives if you don’t have Microsoft 365. Data from Picture is already all versions of Excel 365 for Windows and Mac and Excel