Overview:

This course is designed for students who desire to gain the skills necessary to create macros, collaborate with others, audit and analyse worksheet data, create PivotTables and PivotCharts, incorporate multiple data sources, and import and export data.

Course Outline:

Lesson 1: Streamlining Workflow
   Create a Macro
   Edit a Macro
   Customise access to Excel Commands
   Apply conditional formatting
   Add data validation criteria
   Update a workbook’s properties
   Modify Excel’s default settings

Lesson 2: Collaborating with Others
   Protect files
   Share a workbook
   Set revision tracking
   Review tracked revisions
   Merge workbooks
   Adjust macro settings
   Administer digital signatures

Lesson 3: Auditing Worksheets
   Trace cell precedents
   Trace cell dependents
   Locate errors in formulas locate invalid data
and formulas
   Watch and evaluate formulas
   Group and outline data

Lesson 4: Analysing Data
   Create a trendline
   Create scenarios
   Perform what-if analysis
   Develop a PivotTable report
   Develop a PivotChart report
   Perform statistical analysis with the Analysis
Toolpak

Lesson 5: Working with multiple workbooks
   Create a workspace
   Consolidate data
   Link cells in different workbooks
   Edit links

Lesson 6: Importing and Exporting Data
   Export to Microsoft Word
   Import to Word Table
   Import Text Files