Learn how to turn Excel into a powerful, cost-effective CRM system. Manage customer data, track leads, and automate workflows ...

When collaborating in Excel, sometimes the collaboration can be distracting. Here's how to make a static image so you can do your own work without interruption.

Select your database in Excel and click Insert at the top. Select Table. Confirm your table range, select the My table has headers box (and ensure that it does), then click OK.

How to Subset Data in Excel. Filters are used to create subsets of data in a Microsoft Excel worksheet. The "AutoFilter" or "Sort and Filter" function in Excel allows you to create views of data ...

Are you constantly changing your Excel chart's data range as new information becomes available? Mary Ann Richardson shows how to set up the chart to automatically update as you add new rows of ...

Microsoft Excel has features that are reminiscent of a database, although it’s not a database application and never will be.

Are you still putting your data in plain, old spreadsheets? Excel 2013 makes it easy to link tables, create reports and more.

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