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

Often we need to carry out manipulations in Excel documents and apply them to multiple rows, columns and sheets. To do this manually takes too much time and allows for errors to creep in, so Excel ...

In Microsoft Excel, the user can use a hyperlink to connect the document in the worksheet to webpages, existing files, and other workbooks. Placing a Hyperlink into a document creates a shortcut to ...

Accounting for a small business using Microsoft's Excel often requires the use of figures from one year as part of the accounting necessary for the next year's figures. Rather than keep a continuous ...

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

Q. There are formulas that I am repeatedly having to create in my Excel workbook, and there are no built-in functions in Excel that can do these calculations. Is there a quicker way to reuse the same ...

How to hide rows and columns and use groups in a shared Microsoft Excel workbook Your email has been sent A few years ago, Microsoft Excel improved collaboration by adding sheet view to shared ...

This book is a resource for professors. It explains how the Excel files on this web site can be used in a variety of ways to help students learn. The files are standalone and freely available. They ...