How to Truncate Text in Microsoft Excel
If text is a big part of the data in your spreadsheet, you may need to adjust it to fit properly. The TRUNC function in Microsoft Excel works only with numbers. So if you want to truncate text, here’s how….
How to Highlight Part of an Image in Microsoft PowerPoint
Images are common components in slideshows, adding visual flair to your presentations. So, what if you have a picture with a spot you want to focus on? With a little editing, you can highlight part of an image in PowerPoint….
14 Google Sheets Functions That Microsoft Excel Needs
Microsoft Excel is a full-featured, commonly used spreadsheet application, but it’s not perfect. Its longtime rival Google Sheets offers features that Excel does not, including many helpful functions. Let’s take a look!…
INDEX and MATCH vs. VLOOKUP vs. XLOOKUP in Microsoft Excel
Lookup functions in Microsoft Excel are ideal for finding what you need when you have a large amount of data. There are three common ways to do this; INDEX and MATCH, VLOOKUP, and XLOOKUP. But what’s the difference?…
13 Microsoft Excel Date and Time Functions You Should Know
Whether you use Microsoft Excel for managing monthly bills or tracking time for work, you likely use dates or times. With these functions, you can enter or obtain the dates and times you need.
Microsoft Office on Android Has a New Way to Sort Your Files
Microsoft Office has been available on iPhone, iPad, and Android for years, giving you an easy way to quickly view and edit documents on the go. Office on Android is now rolling out a new way to sort through all your files, f…
How to Use Motion Path Animations in Microsoft PowerPoint
Microsoft PowerPoint offers many types of animations. You can add effects to text, images, and shapes. But if you want to create your own, you can select a motion path animation to move your object wherever you like….
How to Add a Trendline in Microsoft Excel
Adding a trendline to your chart helps your audience better understand the data by way of visualization. Not only can you add a trendline to your already-existing chart in Excel, but you can also format it, too….
How to Insert the Degree Symbol in Microsoft Word
When notating certain measurements like temperature, you’ll want to use the correct?symbol in your documents. Microsoft Word makes it extremely easy to insert the degree symbol in your pages, and we’ll show you two ways to d…
How to Animate Parts of a Chart in Microsoft PowerPoint
Animations in Microsoft PowerPoint can add pizzazz to your presentation. So, if you include a chart in your slideshow, consider animating it as well. With flexible options, you can animate parts of a chart instead of the whol…
The Basics of Structuring Formulas in Microsoft Excel
We’re not all mathematicians, but some tasks in Microsoft Excel are best done using formulas. Maybe you’re new to writing formulas or are trying but keep?getting confusing errors. Here, we’ll cover the basics of structuring …
How to Insert and Animate 3D Models in Microsoft PowerPoint
If you’re looking for a unique way to spruce up your slideshow, check out the 3D model feature in Microsoft PowerPoint. You can insert a 3D image then resize it, rotate it, and even animate it with a nifty effect….
How to Copy Values From the Status Bar in Microsoft Excel
The Status Bar in Microsoft Excel allows you to quickly see the average, sum, or count of selected cells. But what’s better than viewing those values is being able to use them. Here’s how copy directly from the Status Bar….
How to Add Section and Slide Zooms in Microsoft PowerPoint
If you want to move to a different slide or section in your presentation, you can easily add a link on your slide. But by using a Section or Slide Zoom in PowerPoint, you can make that move look professional….
How to Remove a Background or Watermark in PowerPoint
An attractive image or company watermark can make a nice background for your presentation. But if you want to remove that background and use your own or none at all, you have two ways to do it in Microsoft PowerPoint….
How to Use the SUBSTITUTE Function in Microsoft Excel
To replace a string of text, numbers, or symbols, Microsoft Excel offers a function called SUBSTITUTE. This function replaces the specified string with your choice of string. We’ll show you how to use it in your spreadsheets….
13 Essential Excel Functions for Data Entry
Entering data in your spreadsheet is the basic principle behind using Excel.?From adding the current date and time to looking up values to changing the letter case of your text, some?functions can help you?tremendously wit…
How to Concatenate in Microsoft Excel
With concatenation, you can merge two or more values from multiple cells into a single cell in your spreadsheet. Microsoft Excel offers two different ways to perform this task, and we’ll show you how to use those two methods….
How to Undo, Redo, or Repeat an Action in Microsoft Excel
Excel lets you undo, redo, and repeat specific actions. The buttons to undo, redo, and repeat an action are in similar locations on both Mac and Windows, and the keyboard shortcuts are only a little different, as well….
How to Delete a Folder in Microsoft Outlook
If you don’t want to use an email folder in Microsoft Outlook anymore, you can delete that folder as well as all its contents at once. We’ll show you how to do that in Outlook’s desktop and web versions, as the mobile version…
How to List and Sort Unique Values and Text in Microsoft Excel
When you want a list of customers, email addresses, product IDs, or something similar where each one is distinct, Excel has a function to help. We’ll show you how to use this function to list unique values and text….
How to Compare Two Lists in Microsoft Excel
Microsoft Excel offers two different methods to help you compare two lists and highlight the missing items in each one. You can choose to highlight the missing items in both lists or in a single one. We’ll show you how….
How to Make LibreOffice Look Like Microsoft Office
If you’re a longtime Microsoft Office user, you might find?trying out LibreOffice?difficult because of the foreign interface. To make things more comfortable, you can give LibreOffice a look that’s similar to MS Office with…
How to Calculate a Loan Payment, Interest, or Term in Excel
Because of its functions and features, Excel is a great application for budgeting along with managing your money. If you already use it for finances, make your spreadsheet even more effective by calculating loan elements like…
How to Insert Emoji in Outlook Emails
If you want to spice up your emails a bit, make use of various emoji that Microsoft Outlook has to offer. You can add these emoji to your messages on the web, desktop, and mobile. We’ll show you how.
