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.

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.

The database capabilities of Excel are very powerful. In fact, not only can Excel be used to create a simple searchable database, it also can be used to create a proper relational database.

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.

Learn how to master dense ranking in Excel to fix ranking gaps and improve data analysis with this step-by-step guide. Fix Excel ranking by ...

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 ...

Concatenate merges the data you have inserted into columns into its own cell or column in Excel. Let’s take a look at how to use concatenate in Excel.

How to Make a Query to Excel From Oracle Database. Microsoft's Excel software is an indispensable tool for small businesses because of its flexibility and the ease with which you can set up ...

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