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

Editor’s note: These charts accompany our story Excel 2007 Cheat Sheet. Click through to that story for detailed information on getting up and running with Excel 2007. Wondering where your favorite ...

Using multiple sheets in the same Excel workbook helps organize data into distinct categories. For example, you might have sales data for each of your four main departments on four separate sheets. If ...

When creating Microsoft Excel formulas, you can generate calculations using specific values—also known as hard-coding—or referencing other cells in the workbook. In this guide, I'll explain why ...

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

How to use VBA procedures to generate a list of sheet names in an Excel workbook Your email has been sent Image: Aajan Getty Images/iStockphoto Must-read Windows coverage CrowdStrike Outage Disrupts ...