Excel Best Practices for safely importing CSV and text
Importing text files into Excel can sometimes lead to unexpected data conversions—like turning product codes into dates or trimming leading zeros from IDs. To avoid these issues, Excel’s Get & Transform feature (also known as Power Query) offers a more reliable method for importing text data. You can ensure your data remains accurate and intact […]
Avoid Date and Number Mistakes with better data conversion in Excel 365/2024
Excel 365 and Excel 2024 let you control automatic text data conversions with stop mistakes creeping into your sheets. Whether you’re opening a CSV file or pasting from the web, you can now decide how Excel handles your text, numbers, and dates—finally putting you in charge of your own data. Opening .csv files directly in […]
What’s the difference? Microsoft 365 Copilot app or the Copilot app.
Microsoft has two mobile apps with the “Copilot” AI name. “Microsoft 365 Copilot” and “Copilot” apps for iPhone, iPad or Android. What’s the difference and which is best for you? Microsoft’s Copilot hype “Your AI companion for everyday life” (see below) always reminds me of “Your plastic pal who’s fun to be with” with Marvin […]
What the best choice to make and fix Office VBA code with AI?
AI systems have got a lot better at making and fixing Microsoft Office VBA code. We compare Copilot and ChatGPT to see which is best choice for coping with the complexities of Office VBA. Early in 2024 we tried asking ChatGPT for Office VBA code in some simple examples, the results weren’t great. A lot […]
Free Google Fonts in Office: A Simple Step-by-Step Guide
Google offers a great variety of free open-source fonts that can be used in Microsoft Office, Windows or Mac. You just need to know the right trick to access them for Word, Excel or PowerPoint. Over 1,800 Google Font families There are 877 1,816 Google Font families currently available at https://fonts.google.com Google Fonts are intended […]
Score with Solid and Hollow Emoji in Excel
Display scores or ratings visually in Excel using solid and hollow emojis or symbols, you can use a combination of simple formulas and conditional formatting. This approach is useful for representing ratings, progress, or performance in an intuitive and engaging way. With a little Excel trickery, you can show multi-colored symbols with alternates for the […]
Convert Office docs to text with Markitdown
Check out this clever Python tool that converts Word documents, Excel sheets, PowerPoint decks and PDFs into a plain text format. Markitdown is a Python library released by Microsoft via Github, converts many documents into nearly plain text (called MarkDown). It’ll convert all these formats into text. Some conversions need extra pip flags like ([pdf], […]
Get Office Startup Boost for any Office app and any version
The Startup Boost feature coming to Word 365 is really a sly trick by Microsoft. It’s a trick that anyone can do with any Office app and any version of Office. Startup Boost starts the app but hides it away. Word lurks in the background until the user clicks on a Word icon (or starts […]
Fix F9 Fn Keys don’t work in Word, Office or Windows
Office Watch reader Steve G is having a problem in Word. The F9 key isn’t updating fields in a Word document. He suspects a buggy patch of Windows or Office. Here’s how to find the source of the Function key or any keypress problem and fix it. Hint – it’s probably not a bug or […]
Copilot in Office – grumbles and ‘modest proposals’
Copilot could become a ‘toxic brand‘ because of pushy way Microsoft is adding it to Microsoft Office. We have some ‘modest proposals’ for how Microsoft can improve their AI offering and keep paying customers onside. Or, put another way, some grumbles about the way Microsoft is force-feeding Copilot to its Microsoft 365/Office customers. Why ‘Copilot’ […]
Office help on the right-click menu ‘Search the menus’
There’s a little undocumented surprise on the right-click menu. Tucked away at the top is ‘Search the menus’ help. Sadly the underlying help system is still woefully inadequate. Right-click in a document (Word, Excel, PowerPoint or Outlook) and the top item isn’t ‘Cut’ but a “Search the menus” box. This is different from the main […]
Upload a phone image to Copilot chat
Microsoft has introduced a new feature allowing users to upload images directly from their mobile devices to Microsoft 365 Copilot. A nice trick but there are other ways to do the same thing, including two from Microsoft itself! The idea is to streamline tasks such as transcribing handwritten notes, summarizing charts, and digitizing receipts. Copilot […]
Excel Value Tokens – what are they good for?
Excel is getting Value Tokens but what are they good for? Do they add any ‘value’ or are they just a ‘token’ extra? The ‘Value Token’ appears in the formula bar when you select a data linked cell e.g. Stocks, Currencies, Geography or custom data types. According to Microsoft “This enhancement provides a clear visual […]
Create A Variance Chart in Excel
There are better ways to chart differences between matching values like budget vs actual than the simplistic one offered by Excel. A variance chart in Excel shows differences and trends at a glance and is easy to make. In Excel, a variance chart visually compares data sets, such as actual performance versus budget, last year […]
OneDrive messages pushed into Microsoft 365 apps.
Microsoft is adding yet another push for customers to save all their documents to OneDrive. This time inside Word, Excel and PowerPoint documents. OneDrive is Microsoft’s preferred place to save files and they cite various benefits to cloud storage. The company ignores the downsides to OneDrive and the right of customers to choose where to […]
Group and Ungroup objects in Word, PowerPoint and Office
Shapes, images, and other items can be grouped together and often should be in Word, PowerPoint and other Microsoft Office apps. When you group shapes or objects, you can move, resize, rotate, flip them all at once, as if they were a single object. If you’ve ever had trouble moving something in Office but found […]
