Microsoft Excel

Learn how to do the following with Microsoft Excel:

Creating Spreadsheets

The standard features of the spreadsheet are covered here. Entering and editing data; using the toolbars: inserting, deleting, and re-sizing columns and rows: creating common formulas and functions; formatting text and numbers; are covered.

Functions, Lists, Charts

This course assumes that the Basics course was taken, or that the user is sufficiently familiar with the features covered in that course. More advanced and useful functions are introduced. Lists are created, and techniques for organizing them are shown. Finally a simple chart is created from existing data using the chart wizard.

Charts

This course goes beyond the simple automated features of the Excel chart wizard. It presents the many features that can be customized in a variety of chart types. Features include: changing titles, adding data labels, modifying legends, customized use of colors and patterns, tick marks, text formatting.

Protecting Spreadsheets; Macros

Once a spreadsheet is created, it is often advisable to assign certain levels of protection. The entire file, a particular sheet, or particular sections of the spreadsheet can be protected from unauthorized alterations or viewers. The course shows the application of passwords and write protection. Backup issues are discussed, and printed copy as a backup and auditing tool are demonstrated.

Spreadsheets often involve routine and repetitious steps that can be consolidated by use of a macro. Use of macros can save time and eliminate the monotony of repetitious manual operations. The course demonstrates how to record, save, and play a macro: as well as how to assign a macro to a button.

Printing

Excel spreadsheets have many varied options, unlike word processing documents, for printing. Spreadsheets often are not confined to the standard 8 1/2 x 11 inch format, that we see in MS Word. This class shows how to deal with large spreadsheets and organize them for printing. The features covered in the course include: freezing and splitting screens, assigning range names, zooming, previewing, set up options, page breaks, scaling printouts, setting headers and footers, setting the print area, showing/hiding gridlines and row/column headings, printing formulas and functions.