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

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. Like all software, it can have ...

Each cell in an Excel spreadsheet has a unique address, called a cell reference. This reference combines the letter that represents the cell's column with the number that represents its row. Cells in ...

Most people know that you can reference one or more cells, tables and their column headers, or named ranges in Excel formulas. However, fewer know that you can reference specific data points in ...

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

If you’re a full-time spreadsheet jockey, or just a casual number-cruncher, you’ve come to know and either love or hate Excel’s interface. Well, your world just changed. Throw away almost everything ...

There are a great many keyboard shortcuts you can use to work with Excel more efficiently. For a handy reference to all of them, some which work in other Office programs, Microsoft offers these PDF ...