News

What’s the difference between a table and a range of columns and rows on an Excel spreadsheet? How do I create and populate tables? And, once a table is created, how do we custom filter, format ...
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 lets you swiftly create a variety of useful records to log sales calls, service calls and other kinds of call information you need to run your business.
Pivot tables generate great reports in Microsoft Excel, but adding a filter or two can make them even more flexible. Here's how.
To create data bars in Excel, select your cells and then choose data bars from Conditional Formatting.
Step-by-step tutorial on creating an analytical dashboard in Excel that updates automatically using a pre-designed template or from scratch.
Graphs in Excel help break down your data into an easily digestible format. Here’s how to make a graph in Microsoft Excel.