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. INDEX and MATCH, VLOOKUP, and XLOOKUP each serve the purpose of looking up data and returning a result. They each work a bit differently and require a specific syntax for the formula. When should you use which? Which is better?
[mai mult...]How to Start a New Line in a Cell in Google Sheets
Thanks to Google Sheets’ ability to create new lines within a single cell, you can prevent your cell’s content from overflowing. Your extra cell content is put on a new line, and here are two ways to make that happen in your spreadsheets.
[mai mult...]How to Undo Typing on a Samsung Galaxy Phone
The ability to “Undo” the last thing you typed is something we take for granted on PCs. The iPhone also happens to have a handy undo gesture—and, if you use a Samsung Galaxy phone, you do too. Samsung Galaxy devices include an undo feature along with the Samsung Keyboard. In this context, “Undo” will remove the last few words you typed, not the individual characters. The one downside is you can’t use swipe typing if you enable this feature.
[mai mult...]How to Create a Graph in Google Slides
A chart or graph is a terrific way to show a snapshot of your data. So when you couple a chart with another visual tool like Google Slides, you can create the perfect presentation of data to your audience.
You can certainly make a graph in Google Sheets and then insert it into your Google Slides presentation. But you can also do the reverse and start the chart from Slides. Here’s how to create a graph in Google Slides.
[mai mult...]How to Delete Multiple Emails in Microsoft Outlook
If you’re looking to get rid of several emails at once, Microsoft Outlook allows you to selectively remove multiple emails at the same time. You can do this in Outlook’s web, desktop, and mobile versions.
[mai mult...]How to Use INDEX and MATCH in Microsoft Excel
While the VLOOKUP function is good for finding values in Excel, it has its limitations. With a combination of the INDEX and MATCH functions instead, you can look up values in any location or direction in your spreadsheet.
The INDEX function returns a value based on a location you enter in the formula while MATCH does the reverse and returns a location based on the value you enter. When you combine these functions, you can find any number or text you need.
[mai mult...]How to Find Downloads on a Chromebook
If you’ve downloaded a file through the Chrome browser on your Chromebook (or in Chrome OS), you might not know where it ended up. Luckily, there’s an obvious place to look—and a way to double-check if you’re not sure.
[mai mult...]How to Count Unique Values in Microsoft Excel
You can use the COUNT function and variations to count cells that contain numbers. But what if you want to count only the distinct values in a cell range? We’ll show you two ways to count unique values in Excel. Both methods we’ll explain use a combination of functions and variations of the COUNT function. And because your cell range could include blank cells, we’re including alternative formulas to account for this.
[mai mult...]How to Fix a Google Drive “Refused to Connect” Error
Google Drive sometimes displays a “drive.google.com refused to connect” error, which is usually the result of an account permission conflict. You can get around that problem using a few different methods, which we’ll walk you through.
[mai mult...]How to Create a Custom Date or Time Format in Google Sheets
If you insert dates or times in your Google Sheet, you aren’t stuck with the default date formats. You can use the word for a month instead of a number or add seconds to the time by creating custom formats.
You might have a spreadsheet you’re presenting and want a more attractive date format using complete words for months or days rather than numbers or abbreviations. Or maybe you include times in your sheet and need it detailed to the millisecond. The custom date and time formats in Google Sheets give you great flexibility.
[mai mult...]