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

Create a report using charts: Select Insert > Recommended Charts, then choose the one you want to add to the report sheet. Create a report with pivot tables: Select Insert > PivotTable. Select the ...

Learn how to create Named Ranges in Excel with this tutorial. Topics covered include: - Basics of creating a named range - ...

Excel used to be the poor schmuck’s database, with spreadsheets that just sort of sat there. You could create something more sophisticated with LOOKUP functions, but they were a huge hassle to set up.