Even though Excel can accommodate 1,048,576 records, I recommend using a relational database such as Microsoft Access if your database has more than 100,000 records.

Not anymore: Excel 2013’s table tools include features that make it easy to link charts and cells, perform searches, and create dynamically updated reports, just like—yes—a relational database.

How to Set Up a Totaling Spreadsheet in Excel. Understanding how cells behave in relation to one another is essential to getting the most out of Microsoft Excel. When you're working with multiple ...

The Excel 2016 Ribbon is a command powerhouse that helps to dive further into your data. When you purchase through links on our site, we may earn an affiliate commission. Here’s how it works.