Microsoft Excel is a spreadsheet application that you can use to record data, make calculations and create charts. In this article I’ll introduce you to the basics of working in Excel. We’ll look at ...

Follow the steps below to use the Command button to navigate between worksheets in Microsoft Excel. Close the VBA Editor window. Now click on the button in the spreadsheet, and it will go on worksheet ...

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. Is there a list of standard Excel design rules we should be following as we create new Excel worksheets? A. By following a common set of spreadsheet design rules, companies can produce more ...

When you have such sheets which should be grouped, but they cannot be put next to each other, you can use colors. First, select them using Ctrl, and then right-click on any of them. In the menu, you ...

Combine the navigational features of hyperlinks with the organizational capabilities of a table of contents, and you get a powerful new way to manage large Excel workbooks. You can create an Excel TOC ...

Drop-down lists in an Excel sheet can greatly facilitate data entry. Here's a look at how to use Microsoft Excel's data validation feature to create handy lists within your worksheets. An Excel ...

Microsoft Excel is arguably the greatest spreadsheet application from Redmond, and there’s a good reason so many number crunchers use it for all of their number crunching needs. While using Microsoft ...

Dana Miranda is a Certified Educator in Personal Finance, creator of the Healthy Rich newsletter and author of You Don't Need a Budget: Stop Worrying about Debt, Spend without Shame, and Manage Money ...