In Microsoft Excel, a program packaged with Microsoft Office, you can create databases of information and then make calculations, graphs and charts based on that data. It's a handy program to have if ...

There are several ways to add forms in Microsoft Excel 2007, without the need to learn Visual Basic and type complex code. A basic form can be very useful if you need to enter a lot of data into Excel ...

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

If you have a number of Microsoft Excel worksheets that contain related data, you'll likely need to create a report that consolidates and summarizes the data. If those worksheets are laid out ...

Nearly every Microsoft Excel workbook I own—especially those I share with others—contains a hidden backend worksheet. It's essentially the engine room of my workbook and helps me keep my spreadsheets ...

Learn practical HYPERLINK tips, from dynamic sheet links and navigation buttons to XLOOKUP row jumps and tidy anchor text for ...