Effective Usage Of Microsoft Office Excel 2007 - Advanced Training
Education PC users
Code:
MsExcel_Adv
Duration:
1 Days (8 Hours)
Exam:
Price:
* The price for all services specified in the Sales Department – tel: (044) 538-00-60, e-mail: edu@knowledgeforit.com
Order:
This training is for people who has some MS Excel-related skills and want to improve their knowledge. This course covers the following topics: data visualization and data analysis, macros, document sharing and collaborating, document protection. Prerequisites: basic training.
Introduction
Introduction
Course materials
Prerequisites
Course outline
MOS program
Facilities
Module 1.Data Visualization in MS Excel 2007
Diagramming in MS Excel
Kinds of diagrams
Data sources
Diagram formatting
Practice
Short summary
Questions and answers
Module 2. Data Analysis with PivotTables and Data Tables
PivotTables Wizard
Data analysis. Grouping data. Subtotals.
Calculated fields and additional calculations
PivotTable options
Pivot Charts
Using auto format
Conditional formatting
Data analysis. Goal seek. Solver
Data tables and scenarios
Practice
Short summary
Questions and answers
Module 3.Macros and Advanced Data Tools
What is macro?
How to record macro. Absolute and relate references
How to replay macro
How to assign key tips to macro and add it to Quick Access toolbar
How to deal with external data. Web query
Working with data arrays
Data validation and data consolidation
Using MS Office 2007 applications in complex
Practice
Short summary
Questions and answers
Module 4. Document Access Restriction
How to protect MS Excel document
Kinds of protection
How to protect workbook/cells/worksheets/formulas
How to hide formulas
How to restrict data input
Document collaboration and reviewing. Office Live Workspace
Course Schedule 
