Excel 2010 Advanced

This course builds on the skills and concepts taught in Excel 2010: Beyond Basics course. Students will learn to work with PivotTables and PivotCharts. They will learn how to create and apply cell names, create and modify charts, and manage large workbooks. They will start working with more advanced formatting options including styles, themes, and backgrounds. Students will learn about running and recording macros, work with advanced formulas, as well as lookup functions such as VLOOKUP, MATCH, and INDEX. In addition, students will learn about data validation. Finally, students will learn advanced charting techniques, use of trend lines, worksheet auditing and protection, file sharing and merging.