This useful application MS Excel uses tables to store and analyze mathematical data using formulas and functions and your office work is incomplete without this app ...

Learning to use Excel worksheets like relational databases can help you save time, eliminating duplication when managing large projects. A relational database is useful because information resides in ...

Q. I have an Excel workbook with dozens of custom-named worksheets. Is it possible to create a list of those worksheet names in Excel without having to retype them? A. Yes, you can create a list of ...

Business owners and their office managers or accountants often need to check formula cells in Excel spreadsheets for potential links to a preceding cell or cells ...

Excel is well known as a program that allows you to create complex tables of data. However, some people are less familiar with a special type of reference that comes with these tables: structured ...

Microsoft Office brings support for Visual Basic for Applications (VBA) macros back to the Mac. But if you haven’t used VBA before, you might be wondering what you can actually use it for and how ...

Microsoft Excel is ubiquitous, but it's far more than a simple spreadsheet app — a huge array of powerful features lay within its cells. When you purchase through links on our site, we may earn an ...

You might be familiar with bookmarks in Microsoft Word, which are invisible way-points in specified locations of a document that you can jump to whenever you need to. Microsoft Excel's alternative to ...