Advanced Spreadsheets

Catalog description

This course presents instructional material, self-study guides, and online practices where students will learn to use advanced functions of Excel to improve productivity, enhance spreadsheets with templates, charts, graphics, and formulas and streamline their operational work. Students will apply visual elements and advanced formulas to a worksheet to display data in various formats, apply advanced analysis techniques to more complex data sets, learn how to automate common tasks, and leverage on Excel’s advanced functionality to simplify and streamline day-to-day work. Topics covered include Pivot tables, advanced charts and tables, advanced and imbedded formulas, Macros, and What If scenarios, and collaboration features.