Microsoft Office Excel
2010 | 2007 | 2003
Basic | Intermediate | Advance
Microsoft Office Excel Advance
The course focuses on:
Perfecting Excel. At the end of the day you will be able to write and record macros, do file collaboration and do advance formulae and data formatting with Excel. You will be able to anaylise data, create and modify PivotTables and work with multiple workbooks. You will also have a better understanding of XML
Who should attend this course?
This course is aimed at anyone who wishes to give their Microsoft Office Excel skills a boost.
The following people will find this course helpful:
- Anyone who are familiar with Excel and has worked with it for some time
- Accountants
- Business Analysts
- Debtor and creditor clerks
- Data capturers
- Project Managers
Duration: 1 Day
Outline:
Automating Worksheets
Create a Macr
Edit a Macro
Delete a Macro
Assign a Macro to the Quick Access Toolbar
Create a Macro Button
Edit a Macro Button
Adjust Macro Settings
Create Digital Signatures
Apply Digital Signatures
Data Structure and Default Settings
Apply Conditional Formatting
Add Data Validation Criteria
Locate Invalid Data and Formulas
Group and Outline Data
Update a Workbook's Properties
Modify Excel's Default Settings
File Collaboration
Apply File Protection
Protect a Worksheet
Share a Workbook
Set Revision Tracking
Review Tracked Revisions
Merge Workbooks
Auditing Features
Trace Cell Precedents
Trace Cell Dependents
Locate Errors in Formulas
Add a Watch
Evaluate Formulas
Data Analysis
Apply a Trendline to a Chart
Create Scenarios
Perform What-If Analysis with Goal Seek
Perform What-If Analysis with Solver
Create a PivotTable© Report
Edit the PivotTable© Report
Create a PivotChart© Report
Perform Statistical Analysis with the Analysis ToolPak
Work with Multiple Workbooks
Create a Workspace
Consolidate Data
Link Different Workbooks
Edit Links between Workbooks
Data Import with XML
Import XML Maps / Data
Export XML Data
Return to
soft skills course list | computer course list
To book for this course click here