2015 – Microsoft Excel 2013 ExpertDownload Course Outline
Title: Microsoft Excel 2013 Expert 2015; 1 days; Instructor-led
Description: This course examines many of the expert tools that Excel provides to manage, analyze and present data. Starting with working with macros, then moving on to analyzing data. The new tools that enhance Pivot tables and extend Excel’s reach into external data sources PowerPivot and Power View are explored. What-if tools such as Scenarios and Goal-seek are discussed. Add-in tool sets, including the Analysis Tool Pack and Solver are examined. Finally, students experience PowerPivot and all its wonderful features.
At Course Completion:
Audience & Prerequisites:
Course Outline Details: Module 1: Macros Lessons Record a macro Run a macro Edit a macro Module 2: Analyzing Data Lessons Enable and use the Analysis ToolPak Use Goal Seek Module 3: Using Power View Lessons Enable Power View Create a Power View Add and remove fields Arrange fields Filter and sort data Refreshing Data Choosing a Visualization Changing Tile display Setting Display options Module 4: Using the Inquire Add-In Lessons Install the Inquire Add-in Generate a workbook analysis report View a relationship diagram or report View cell relationships Compare two workbooks Module 5: Working with Tables Lessons Creating tables Expanding tables Choosing table styles Module 6: Working with Records and Fields Lessons Add fields by inserting columns Records by inserting rows Delete records or fields Module 7: Using Excel as a Database Lessons Filter data Validate data Use database functions Module 8: Using Custom AutoFill Lists Lessons Create and use custom AutoFill lists Modify a custom AutoFill list Delete a custom AutoFill list Module 9: Using Comments Lessons Insert comments Edit comments Navigate through comments Edit and delete comments Module 10: Track Changes Lessons Track and review changes Set options for tracking changes Stop tracking changes Module 11: Linking, Consolidating and Combining Data Lessons Link and consolidate workbooks Consolidate worksheets Pivot consolidated data Module 12: Creating Scenarios Lessons Create and load scenarios Edit and delete scenarios Merge scenarios Create a scenario summary report Module 13: Using Solver Lessons Enable Solver Set up a worksheet for Solver Run Solver Generate reports and scenarios Modify Solver constraints Set Solver options Module 14: Using PowerPivot Lessons Enable PowerPivot Import Access and Excel data into PowerPivot Integrate data with relationships Create a PivotTable with PowerPivot data
Start Date: 10/08/2019
End Date: 10/09/2019