Once you've learned the basics of Microsoft Excel, ambitious users will want to take their skills to the next level.  This level 2 course is designed to provide detailed explanations and relevant applications of elements of Microsoft Excel 2013 to take students beyond the basics.  The focus of this course is advanced formulas, data visualization and workbook administration.

Course Highlights

• Advanced Formulas: Create and use a range name; How to use customized functions
• Data and Lookup Functions: Write advanced formulas; Use advanced lookup functions
• Data and Tables: Create & modify a table; Sort & filter data; How to use advanced functions to calculate data
• Data Visualization: Create a chart; Modify a chart; How to create a trend line; Working with Advanced Chart
• Analyzing Data Using PivotTables and Charts: Build a PivotTable; Filter data using Slicers; How to build PivotCharts for data analysis
• Workbook Enhancements: how to use comments, hyperlinks, watermarks and other customizations; Themes; Create workbook templates; Protect files

Lunch will be provided.