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….
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….
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!…
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?…
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 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…
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….
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….
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…
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…
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 …
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….
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….
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….
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….
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….
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…
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….
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….
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…
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….
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….
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…
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…
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.