Excel 2010/2013 – Level II
You can take Excel 2010 or Excel 2013. Expand your Excel 2013 skills by learning to use the tables feature, outlines and templates. Write, run and edit macros to automate routine tasks. Use digital signatures to authenticate your work, and use the protection feature to protect a worksheet or workbook. Use some of Excel’s financial functions, such as Hlookup, Vlookup, GoalSeek, Solver, PMT and FV. Use data analysis tools such as PivotTables and PivotCharts, as well as formula auditing tools for locating errors. Students will integrate Excel with other MS Office programs, import external data into a workbook, and save workbook elements as a web page. Video tutorials will be provided in class.
Transferable credit: This class has been approved for 1 unit of credit through Mission College and San Jose City College. Please see your instructor for more information.
Type: Self-paced on computers; Instructor available.
Prerequisite: Excel 2010 Level I or similar experience.
Instructor: Postlewait (email@example.com)