Excel 2

The class is geared to beginners and those who seek a refresher in the topic. Students will gain a basic understanding of the worksheet environment, tools for working with data, and resources for continued learning.

This is a hands-on class; students should be able to use the mouse and keyboard. Students are welcome to bring a flash drive to save their work for review and practice.

Summary of Topics:

Class 1: Worksheet basics using a budget - Learn elements of the worksheet, enter and edit budget data, perform calculations, create a pie chart.

Class 2: Format a worksheet for an attractive, easily-readable on-screen presentation as well with the attributes needed for printing.

Class 3: Formulas & Functions – learn more about how to use formulas, and the wide array of built-in functions. Includes the concepts of relative and absolute cell references, named ranges in formulas; and how to create and use a Table to streamline your work. [After this class, students will be ready to work with Pivot Tables, an even more powerful way to work with data.]