For the most part, you're probably accustomed to using Microsoft Excel for tasks such as preparing reports, forecasts, and budgets. However, Excel is much more powerful than that. It can be used to ...

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.

Although many people often use Microsoft Access to store text information, you can add files to a database as well. Access makes this possible by defining a special attachment field that can hold ...

In order to be able to use Excel’s PDF importer feature, you must first connect a PDF document to the Excel spreadsheet you are working on. Following are the steps that will guide Office 365 users on ...

To convert a PDF to Excel, open the PDF file in Word. Save the PDF in Word as a webpage, then open that webpage file in Excel. You can also export a PDF to Excel ...

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

How to create a YOY comparison chart using a PivotChart in Excel Your email has been sent Need to know your organization's YOY results? Susan Harkins will show you how to make a PivotChart in ...

How to create a sorted unique list in an Excel spreadsheet Your email has been sent Microsoft 365's UNIQUE() function is a great reason to upgrade. Combine UNIQUE ...

Have you ever found yourself drowning in spreadsheets, endlessly scrolling through rows of data, or manually fixing errors that seem to multiply by the hour? For many, Excel is both a lifeline and a ...