Microsoft Excel becomes a powerhouse once you get into its expansive list of sorting options. Here we’ll cover its most straightforward option for sorting, a simple option that enables us to reorder data in specific columns….
Sorting and filtering data offers a way to cut through the noise and find (and sort) just the data you want to see. Microsoft Excel has no shortage of options to filter down huge datasets into just what’s needed….
Finding the sum of squares in Microsoft Excel can be a repetitive task. The most obvious formula requires a lot of data entry, though there’s a lesser-known option that gets you to the same place.
Microsoft Outlook uses vCalendar files to exchange information about meetings and appointments with others in your home or organization. With vCalendar files, you can easily schedule appointments with others even if they’re…
Creating random data to fill an Excel workbook is as simple as adding a few little-known formulas. These formulas come in handy when honing your Microsoft Excel skills, as they give you fake data to practice with before you r…
A vCard is a virtual business card that you can attach to emails in Outlook (or elsewhere) and send digitally. Here’s how to create a vCard, send one, or import one in both Outlook and Gmail.
There are a number of ways to insert contact information into a Word document. Perhaps the easiest is just adding an Address Book button to the Quick Access Toolbar so that you can add contacts on-the-fly and at the touch of …
Microsoft Word makes it easy to add the same text to multiple documents. This is especially handy for text with special formatting, the kind of text that often breaks when pasting it into a new document. The time you find you…
PowerPoint files come in two formats: PPTX files are editable PowerPoint presentations and PPSX files are a view-only format intended for presentations. You can edit a PPSX file, but you must first convert it back to a PPTX f…
Adding a bulleted list in an Excel worksheet isn’t straightforward, but it’s possible. Unlike Microsoft Word—or even PowerPoint—there’s not much in the way of visual cues to guide you when adding these lists. Instea…
Microsoft Excel may be known for complex calculations and formulas, but it’s no slouch at simple arithmetic. There are a number of ways to find solutions to simple math problems, like finding the sum of numbers in multiple …
Exponents are simply repeated multiplications. For example, four to the third power (4³) isn’t 4 x 3, it’s 4 x 4 x 4, which equals a total of 64. If that sounds complicated, fear not; Excel can do the heavy lifting for you…
There are several ways to add a customized title to a spreadsheet in Microsoft Excel. Titles aren’t just for file names—you can place one right above your spreadsheet data so viewers can understand it more easily….
Emoji work basically anywhere these days, including in Microsoft Word documents. Jazz up your documents with colorful emoji icons that work on all modern operating systems, including Windows 10, macOS, iPhone, iPad, Android, …
Is your version of Office still getting security updates? It depends which version you’re using. Microsoft has a published support lifecycle, but it can be difficult to dig up the info. Here’s what you need to know….
Every Microsoft Office app has a quick access toolbar that shows one-click commands. Here’s how to customize this toolbar to show any command that appears on the ribbon and some that aren’t on the ribbon at all….
Microsoft Word is part of Microsoft Office and requires an up-front purchase or a Microsoft 365 subscription. If you’re using a computer without Word installed, there are other ways to view that DOCX or DOC file….
Emails are convenient for many, but a wide range of disabilities can make the format difficult to use for many of our friends, family, and colleagues. Make sure that your emails are fully accessible by using Microsoft Outlook…
The Microsoft Office ribbon contains most of the commands you need, but sometimes it would be useful to add to it. Here’s how to find and choose other buttons to add to the ribbon in whichever tab you want….
While Microsoft Office is still the ubiquitous choice for word processing, slideshow presentations, spreadsheet calculations, and many more digital tasks, there are still plenty of free alternatives. Avoid freeware full of ad…
If you’ve ever displayed multiple calendars in one view in Outlook Online, you’ll know how useful it is but also how confusing it can get. Use colors and charms to know at a glance which appointment belongs to which calendar….
PowerPoint allows you to format and present the content of your slides in different ways. If you want to print out or display your PowerPoint slides in a bigger or smaller-than-average size, you can change the slide sizes to …
Billions of images are on the internet—but not all of them are free to use. When you add licensed photos to PowerPoint documents, you’ll probably need to cite where it’s from and who made it. Here’s how….
Up until 20 years ago, thanks to typewriters, it was common to see sentences written with two spaces the period. At long last, Microsoft Word has started marking double spaces as an error by default. If you’re a two-spacer wh…
If you’re wanting to delete a page containing text, graphics, or other content in a Microsoft Word document, or if you’re wanting to get rid of that blank white page at the end of your report that won’t appear to go awa…
