UAH

Go beyond the basics of Introduction to Excel and learn how to manipulate multiple worksheets/books efficiently. Study more advanced formatting options, charting techniques, worksheet auditing and protection, file sharing/merging, and templates. Create outlines, subtotals, and cell names; and work with lists and tables in hands-on labs. Learn to save workbooks as Web pages or as PDF files.

Topics Include:
• Using multiple worksheets and workbooks
• Advanced formatting
• Outlining and subtotals
• Cell and range names
• Tables
• Web and sharing features
• Advanced charting
• Documenting and auditing
• Templates and settings
• PivotTables and PivotCharts

Prerequisites:
Microsoft Excel 2010 Essentials or equivalent experience.