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

Whenever you create a new Excel document, you are opening what is called a "workbook." Each workbook can have multiple worksheets. If your small business sells fruit, you might have an Excel workbook ...

If you update recurring data, such as monthly sales figures, you might create a copy of a completed sheet to use as a starting point. For instance, when you’re ready to start tracking February’s sales ...

Please note: This item is from our archives and was published in 2003. It is provided for historical reference. The content may be out of date and links may no longer function. Q. When I create a new ...

Stop using fragile direct links—Power Query creates faster, automated, and more robust workbook connections.