With my Excel Series at Santa Monica College you can increase your skills and marketability.
Whether you're an employee looking to move up, or a consultant looking to add more value for your clients.
Excel skills are more critical than ever now!
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.
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.
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.
Look what you can do with Google Sheets!