Classes I’m teaching at Santa Monica College
Excel Basics ← Click to register
Saturday Jan 26, 2019
9 am – 4 pm
In a truly introductory class, learn how to use Excel. Start with an overview of the menus and the “ribbon,” and find out how to navigate around a spreadsheet, enter simple data, write simple formulas, and work with lists. Then, learn how to format spreadsheets to make your data stand out and look great, and how to work with text, sort and filter lists, create tables, and more! Then put your new skills to work as you create a simple household budget. You will have an individual computer to work on during class, along with a template you can download and work in during class, and a cheat sheet with keyboard shortcuts.
Intermediate Excel ← Click to Register
Saturday Feb 2, 2019
9 am – 2 pm
In a follow-up class to Basics of MS Excel, get a quick review of basic formatting, and find out about conditional (if/then) and two-color formatting. Also, learn how to write a selection of advanced formulas, and how to work with named ranges and using names in formulas. You will have an individual computer to work on during class.
Advanced MS Excel ← Click to Register
9 am – 2 pm
In a follow-up class to Intermediate MS Excel, continue building your skills as you learn how to use filters, how to work with subtotals, how to link data to a drop-down menu, how to create Sumif formulas, and how to make the most of pivot tables and pivot charts to take large volumes of data and summarize them in seconds, giving you valuable information efficiently. You will have an individual computer to work on during class.