You can do a lot in Microsoft Excel and Google Sheets, beyond the obvious spreadsheet-style organization and data collating. A lot of this is tied to both of their programming-like functions that can ...

You can use VLOOKUP with Google Sheets similar to how the search function is used to find information in Excel.

Office Q&A: An advanced Excel filter to match multiple values and a PowerPoint picture timesaver Your email has been sent This month, Susan Harkins introduces an Excel user to advanced filtering and ...