Video, page 2
Video: how to vlookup multiple values in Google Sheets
This video tutorial shows the easiest way to vlookup by multiple criteria in Google Sheets. The add-on finds all matches and pulls data from another sheet as values or as ready-made Google Sheets QUERY formula. Continue reading
Video: how to merge 2 Google sheets
This video tutorial explains how to keep your Google Sheets tables up-to-date with the Merge Sheets add-on. The tool will scan two tables for matches and do a quick vlookup. It will update old records, add missing info, and pull new rows and columns to your main table. Continue reading
Video: Excel date formulas made easy
This video will show you how to get Excel date formulas of any complexity without actually writing them. Learn how you can find the number of days between two dates, calculate age, add and subtract dates in Excel with your personal date&time formula assistant. Continue reading
Video: 6 ways to merge Excel sheets with 1 add-in
Combining data from multiple sheets becomes effortless if you have Consolidate Worksheets Wizard for Excel. See all the ways this add-in lets you copy, consolidate, and merge data from your tables. Continue reading
How to combine duplicate rows, merge values, and add subtotals in Google Sheets
Whether or not you're new to Google Sheets add-ons, you’ll love the news: now it takes three simple steps to combine duplicate rows and keep all unique information safe. Continue reading
Video: Conditional formatting based on another cell
Learn how to quickly highlight entire rows based on another cell value in Excel. Continue reading
How to compare two Excel files for differences
In this video you will learn 4 ways you can find differences in excel tables: view files side by side, use formulas or conditional formatting to see updates, Compare and Merge shared spreadsheets, and see a special add-in for comparing two Excel files. Continue reading
Excel VLOOKUP explained - how to video
If the VLOOKUP function in Excel ever intimidates you, see how you can easily read it and learn how to Vlookup yourself, or with a special add-in Continue reading
Video: How to remove blank rows in excel
If empty rows interfere with your work in Excel, see how to pick the right way to deal with them and avoid a common mistake. You will learn about a special tool to delete all blank rows in a click, the formula that lets you quickly find them, and a way to remove rows that miss certain records. Continue reading
Video: How to remove line breaks in Excel
See our quick tips for deleting carriage returns from the cells in your Excel table Continue reading
Video: How to merge cells and preserve original values in Google Sheets
See how you can quickly combine the cells with all their data in Google Sheets. Join text in columns, rows, or ranges with simple and flexible settings that our free add-on offers. Continue reading
Video: How to merge duplicate cells in Excel
Learn different ways you can combine unique values or sum numbers that refer to the same record in Excel Continue reading
Video: How to remove duplicates in Google Sheets
Learn how to work with Remove Duplicates add-on for Google Sheets: quickly find unique entries, compare two columns or even tables for duplicate rows. Continue reading
Video: How to find and remove duplicates in Excel
See three simple ways you can find and remove duplicates in Excel: use standard functions, Conditional Formatting, or a special add-in. Continue reading
Video: How to compare two columns in Excel
There are quite a few ways you can find matches and differences between columns. We suggest trying one of three reliable methods described in this video any time you need to compare columns in the same or in different sheets. Continue reading
Video: How to change text case in Excel
In this video you’ll learn several ways you can change case of your records in Excel spreadsheets. We’ll look at a special tool that allows you to capitalize the first character in each cell or update the selected values to uppercase, lowercase, or proper case; we’ll learn the standard Excel functions we can use, and see how we can employ Flash Fill in Excel. Continue reading
Video: How to remove extra spaces in Excel
Learn how to trim leading and trailing spaces, delete all blanks between numbers, and remove extra spaces between cell values in Excel using standard functions or a special add-in. Continue reading
Video: how to merge and combine rows in Excel
This video will show four different solutions for merging rows of data, blocks of rows, or duplicate records from different lines in your table. Learn what formulas and tools you can use to combine rows in Excel and keep all important information intact. Continue reading
Video: Three ways to merge columns in Excel without losing any data
We often need to combine columns in Excel to get names, addresses, and similar records in one cell. As there are no built-in tools for merging values from multiple columns, see three ways you can go in this video. Continue reading
Video: Merge two Excel sheets in 6 simple steps
We have introduced some exciting changes to one of our best time-savers. This video will show you how Merge Tables Wizard can quickly and efficiently combine data from two Excel files. No formulas, no redundant work, just 6 simple steps to get the job done. Continue reading