Advanced Excel (AE206)
This workshop builds on the Excel Basics to provide students with advanced knowledge of Excel spreadsheets. Learn how to define named ranges, link multiple workbooks, import data, use pivot tables and chars, work with templates and styles, create macros, analyze data, protect files, customize toolbars, and collaborate through shared workbooks and consolidated data. This workshop assumes a working knowledge of Excel (how to create columns and rows, format cells, and use basic formulas)