Cons of using Excel as a database Limited security Before you fully embrace Excel as a database tool, make sure to keep the following cons in mind.

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.

I'd like to type " XYZ1234 " as the Item_ID in cell A2 and have it return " ACME Rocket Car 2.0 " as the Item_Name in B2 and " 5 " as my OnHandQty in C2.

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.