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

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

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

Within excel you can conduct calculations on multiple worksheets and workbooks open at the same time. Each workbook acts as its own separate window on your PC or Mac, while each worksheet acts as a ...

Regular users of Microsoft Excel know about Workbooks and Worksheets, but do they know the differences? You see, many people confuse the terms Workbooks and Worksheets more often than not, and that is ...

Professor Johnson teaches a Nursing course that has several assignments in which students answer questions on a worksheet. As a Miami instructor, Professor Johnson has access to a Google Drive account ...

One of Excel’s greatest tricks is the dimensional or 3D reference. This feature, which allows you to create formulas that refer to the same cell or range on multiple worksheets, simplifies the ...

Excel allows you quite a lot of freedom to customize your user experience via the use of macros. This tutorial will show you how to create and name worksheets using an existing list via a macro. You ...

Please note: This item is from our archives and was published in 2001. It is provided for historical reference. The content may be out of date and links may no longer function. To help readers follow ...

How to create a VBA procedure that closes all open workbooks in Excel Your email has been sent Some of us work with several Microsoft Excel workbooks open at the same time. Either we open them and ...