Need to match elements from two spreadsheet lists? Discover what VLOOKUP is, how to use VLOOKUP in Excel (with proper written formulas), and fix common issues.

In this tutorial, learn how to calculate percentages in Excel with step-by-step workflows. Get the formulas, functions, and techniques to help you work with...

Learn how to compare multiple sets of data in Excel with the What if Analysis Scenerio Manager. It helps you find a solution or make a decision based on data...

Learn how to use Excel more efficiently. With the powerful Excel techniques and tips in this article, you’ll get your work done faster and without a lot of...

If you do any project management, you’ll eventually need to create a Gantt chart. A good Gantt chart illustrates the lifecycle of individual tasks that make...

Yes, it's possible to have fun using Excel. Here's how to make a traditional animated flip book with pixel art, using just an Excel workbook.

How to use the Data Model in Excel 2013 to combine data from multiple sheets into one PivotTable.

Style is typically the last thing you think about with spreadsheets; they're business first tools that aren't designed to look nice. And yet, Excel Styles...

You don't need a fancy app to run a giveaway. Here's how you can run a giveaway and pick your random winners using any spreadsheet app.

There's tons of open data available that's locked away inside tables in PDFs. Here's how to extract the data with the free tools Tabula and OpenRefine to...

There's easier ways to find and move data in a spreadsheet than copy and paste. Here's how to use the VLOOKUP, MATCH and INDEX functions to extract specific...

Microsoft has finally released full-featured Office apps for the iPad. Here's a quick look at what each app offers, and how you can start using Office on...