Excel 2013 – Level II
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 work sheet 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.
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 2013 Level I or similar experience.
Textbook: Microsoft Excel Comprehensive ITEM: 1-59136-483-3