The VLOOKUP function is one of the most useful when pulling information from an Excel database. Here's how it works and how you can start using it in your work.

Excel macros let you automate repetitive tasks for substantial time savings. Here’s how to put them to work for you.

Before we dive into pivot tables in Excel, letâ s have a quick word about it. A pivot table is a powerful tool in Excel to summarize and analyze your vast database in different ways.

Here's how to create a pivot table in Excel to slice and dice your data, letting you perform in-depth analyses and spot important trends.

Part Two of this three-part article covers how to import your Outlook contact list—the CSV file—into Excel, then how to refine, maintain, and manage that database so, in Part Three, you can ...

Microsoft Excel has more dataviz capabilities than you may realize. Find out how to make your data stand out with charts, PivotTables, sparklines, slicers and more.

PDF Data Connector from Microsoft will help you import and use PDF data into Microsoft Excel spreadsheets. Learn how to use it.