How to Build A Database in Microsoft Office Excel 2007. Small databases of a few rows, to a few thousand rows, can often be created more quickly and easily in Microsoft Excel, than by using a ...

If you've have lots of data and lots of analysis to do, but little time or skill, you need Excel's Power Pivot feature. Here's how to get started with it.

Learn how to parse data in Microsoft Excel easily using our step-by-step guide.

Set data validation If you want to insert different task priorities (High, Medium, or Low) and Status (Pending, Ongoing, Skipped, Completed) in your Excel sheet, you need to use Data validation.

If you come across a table on the web or in another source that you want to import into Excel, there's an import feature that does the work for you.

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.