Upon successful completion of this course, students will be able to: Manage cell and range names, calculate data across worksheets, use specialized functions and analyze data with logical and lookup functions.  Create and modify tables, format tables, sort or filter worksheet or table data, and calculate data in a table of worksheet.  Create, modify and format charts.  Create a PivotTable report and analyze data using PivotCharts.  Insert and modify pictures and ClipArt.  Draw and modify shapes.  Illustrate workflow using SmartArt graphics and layer and group graphic objects.  Customize the Excel environment and workbooks.  Manage themes.  Create and use templates.