| Price per person: | $99 |
| Length of class: | three hours |
| Version covered: | for Office 365 |
| Delivery format: | live over Zoom |
This three-hour session for Windows and Mac users introduces you to Excel’s interface and fundamental capabilities. By the end of the session, you will be easily getting around in Excel’s Ribbon-based interface, able to enter and edit labels, values and dates, extend series of dates and months, cut and paste entries, insert and delete cells and sheets, and set print attributes like headers and footers, print area and print titles.
This class is ideally suited for people with at least basic computing skills, such as using a mouse and opening and closing windows. Typing skills are helpful, but no spreadsheet experience is required.
We have a self-assessment tool to help determine if this class would benefit you. Download this skills assessment file and open it up. See if you can perform the tasks listed in it. It will test you on the exact skills you would learn in this class.
Introduction to Excel
- what can I do with Excel?
- learning the Ribbon-based interface
- selecting cells in a worksheet
- zooming and switching views
- setting view options
- closing a workbook and exiting Excel
Making and Editing Entries
- creating a new workbook
- entering labels and values
- switching between worksheets
- entering dates and months
- extending a series of dates or months
- editing and clearing entries
- undoing mistakes
- moving and copying entries
Managing Cells and Worksheets
- inserting and deleting cells, rows and columns
- changing column width and row height
- inserting and deleting worksheets
- renaming a worksheet
- applying color to a worksheet tab
- rearranging worksheets
Printing Worksheets
- controlling paper size, orientation and scaling
- determining the print area
- setting print titles to repeat on each page
- adding headers and footers
- inserting and removing page breaks
- managing print options