Microsoft Office 2013: Excel (Advanced)
This workshop builds on the Excel Basics workshop to provide students with advanced knowledge of Excel spreadsheets. Learn how to define named ranges, link multiple workbooks, import data, use pivot tables and charts, 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).