Office Articles
How to Remove Duplicate Rows in Excel
But there are a few limitations
Duplicate values in your Excel worksheet can mess up your data. Unless duplicates are intentional, they can cause inaccuracies and skewed reporting. In this tutorial, we’ll show you how to […]
How to Dictate Documents in Microsoft Word
Great for writing speeches or your autobiography
Most people can speak faster than they can type. Take advantage of this superpower by dictating your documents! Using speech-to-text is a great way to quickly get your thoughts down […]
9 Ways to Open a Word Document Without Word
How many of them have you used?
Did you just download or receive a Microsoft Word document on your desktop or mobile device but you don’t have Word installed? Don’t let that DOC or DOCX extension freak […]
4 Ways to Use a Check Mark in Excel
Choose the method most convenient to you
There are many reasons you may want to use a check mark in Excel. In some cases, you may just want a way to place a check mark image either […]
How to Create Multiple Linked Drop Down Lists in Excel
Save time and hassle with data entry tasks
Drop-down lists in Excel are powerful tools. They let you provide users with a drop-down arrow that, when selected, provides them with a list of choices. This can reduce data-entry […]
Random Number Generator in Excel: How and When to Use It
For both fun as well as profit
There are a surprising number of ways you can make use of a random number generator in Excel. But before you do, it’s important to understand the function of a […]
How to Use Absolute References in Excel
Plus how to use relative references
Most people are familiar with using relative references in Excel. This is because cell references in Excel spreadsheets default to the relative reference method. However, there are times when relative […]
How to Find New PowerPoint Design Ideas
Save your presentation from death by boredom
Did you know that PowerPoint was originally for making overhead transparencies on a Mac back in 1987? Yes, death by PowerPoint has been a thing for over 30 years. So […]
How to Insert a Watermark in Word and Google Docs
Protect your intellectual property and prevent theft
Adding a watermark to images or documents before posting them online is a good way of preventing intellectual property theft and demonstrating ownership of a document. This step-by-step guide explains […]
Microsoft Outlook Won’t Open? 10 Ways to Fix
Instead of calling up the IT department
Outlook is an excellent full-featured, powerful and reliable email client from Microsoft. However, there may be times when you may experience issues with Outlook not being able to load or open, […]
How to Delete a Page in Microsoft Word
Why do they make it so hard?
Don’t feel bad for having trouble deleting a page in Microsoft Word. While it seems like it should be a simple task, deleting a page in Word can be extremely […]
19 Best Outlook Mobile App Tips for Android and iOS
Take care of your inbox on the go
Outlook has been the heartbeat of business for a long time. Now, it’s moving into our personal lives too. Is that because work from home has exploded? Is it because […]
How to Add Footnotes in Word
Important formatting for research papers
Have you heard the one about the author who said if he practiced yoga long enough he’d be able to pick up a pencil with his toes? He said, “Then […]
How to Sort by Date in Excel
Plus, a trick to try if it's not working
Sorting data by date seems like it should be a simple task, and, indeed, Microsoft Excel offers a number of ways to sort data by date. However, sometimes Excel’s sorting […]
How to Draw in Microsoft Word
Add a little personality to your project
While Microsoft Word may not be the first drawing tool you think of, its drawing tools are among its little-known features that are simple to learn and easy to use. […]
What Is a .MSG File and How to Open It on Windows and Mac
Important for Outlook users to know
There are thousands of different types of files that exist, split into categories like music or document files, but each with their own function and limitations. For instance, an MP3 […]
Create or Generate Keyboard Shortcuts for Microsoft Office
Make your tasks so much easier
A mouse is a handy tool, but point-and-click is a waste of time. You knew that, so you went and learned the best keyboard shortcuts for Office and Windows already. […]