Excel case-sensitive text comparisons or not
Be careful comparing text in Excel because it looks easy but there are traps when comparing exact text (including upper/lower case) or not. Whether you’re cleaning data or ensuring accuracy in sensitive fields like usernames or product codes, we’ll help you get the results you need every time. Case-insensitive IF statement for text values When […]
Microsoft 365 Copilot Explained: Features, Limitations and your choices
Navigating the evolving landscape of Microsoft 365 and Copilot AI can be challenging amid frequent update, varying features and so much hype. Our independent guide breaks down what Copilot is, its capabilities within Word, Excel, PowerPoint, Onenote and Outlook, and the distinctions between different Microsoft 365 plans. Microsoft has changed Copilot so many times that […]
Add Singular or Plural text in Excel
In Excel there are various options for making sure a text label singular (e.g. person) or plural (people) matches the quantity. There’s the standard answer (IF() functions) or clever cell formatting tricks. For example if the cell has 1 item you want the singular label: 1 cookie But if the value is more than one, […]
🚦 Mastering Excel’s Visual Indicators, icons and emoji
Use Excel with visual indicators to make lists easier to understand. Use IF function together with Conditional Formatting to display icons, text based on specific conditions There are so many possibilities available using Conditional Formatting or simple IF statements like these. Use IF Formula to show icons First, decide the conditions under which icons should […]
Excel Users: Are Your Date Calculations Accurate?
There’s a little trap in Excel when figuring out the number of days between two dates. Excel has one way, but the real world has two others. It’s easy to forget the differences and it can matter when the date calculation is close to some limit, for example in a Schenghen Visa Calculation. How Excel […]
Excel for Mac Finally Learns to Multitask (Sort of)
Good news for Excel on Mac users who like to “live dangerously” with more than one worksheet at a time. Excel for Mac is finally catching up with Windows to view multiple worksheets from the same workbook side-by-side. No more tabbing back and forth like you’re playing Whack-A-Mole with your data. Historically, Excel for Mac […]
Run Linux from Excel? Yes you can!
A tech enthusiast named has achieved the improbable: running the Linux operating system within Microsoft Excel. It’s a clever trick that no-one has been asking for. The 18-year-old named NSG650 created a project, aptly titled “Linux In Excel,” transforms the spreadsheet application into a minimalist Linux terminal. Opening the provided ‘linux.xlsm’ file in Excel, users […]
Excel data galore for the Australian election
Data nerds can have a lot of fun with the Australian election which has a lot of Excel compatible data for the 2025 and past elections. Daily updated stats as 2025 vote counting continues. Australian federal elections are run by an independent body, the Australian Electoral Commission. The AEC manages voting not just across Australia […]
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 […]
