[ad_1]
Formatting allows viewers to distinguish values by type and even sections. Applying the right formatting is critical to readability, and most users learn how to format cells and regions early on. After learning the basics, users quickly move on to using Format Painter to…
[ad_1]
Reporting lots of large values in Excel is probably a good thing, but if you want them to be readable, try this easy technique.
Image: 200dgr/Shutterstock
The article, Use a custom format in Excel to display easier…
[ad_1]
Use Microsoft Excel's TODAY() function in simple expressions to highlight the current date and past and future dates.
Many applications track dates for lots of different reasons. You might track due dates, delivery dates, appointments…
[ad_1]
After years of struggling with Microsoft Excel's internal conversion feature, users can now disable Excel's internal data conversion feature.
Excel tries to determine an input value’s data type — and, for most of us, that’s helpful.…
[ad_1]
Learn how to create a summary slide that you can add to the end of a presentation to support a Q&A session with your audience using older stand-alone versions of PowerPoint and Microsoft 365.
Adding a…
[ad_1]
Learn how to use MID() and FIND() and then combine them to parse substrings from inconsistent data.
Parsing data is a common task in Excel. For the most part, you’ll do so when you need to…
[ad_1]
To use Microsoft Lists data in Power BI, you can use a SharePoint connector for quick access. I'll show you how.
Microsoft Lists is a great way to share data; other users can view and even…
[ad_1]
If you receive a picture of data, don’t panic: You don’t have to enter it by hand. Microsoft Word can convert the image into text for you.
If you’re putting together a Microsoft Office document and…
[ad_1]
Word clouds can be used as images in PowerPoint presentations. If you’re an editor or business writer, you might create a word cloud to see which terms are overused or to make sure the focus isn’t overrun. You could even use them as an…
[ad_1]
Editor’s note: In the video, Brandon Vigliarolo walks you through a couple of ways for suppressing 0 values in Excel charts. For this demo, he uses Microsoft Office 365. The steps are similar to what Susan Harkins describes in the following tutorial.
A drop…