Objective:
The course equips the trainee with the understanding of advance feature of Excel 2003 such as how to use the spreadsheet for analyzing data, import/export data, creating database and create simple macros to automate their spreadsheet.
Participants will sit for Microsoft Office Specialist Exam at the end of the course. Course Outline
Organizing and Analyzing Data
- Use Subtotal
- Defind and apply advanced filters
- Group and Outline Data
- Use data validation
- Create and modify list ranges
- Add, show, close, edit, merge, and summarize scenarious
- Perform data analysis using automated tools
- Create Pivot Table and Pivot Chart reports
- Use Lookup and Reference functions
- Use Database functions
- Trace formula precedents, dependents and errors
- Locate invalid data and formulas
- Watch and evaluate formulas
- Define, modify and use named ranges
- Structure workbooks using XML
Formatting Data and Contents
- Create and modify custom data formats
- Use conditional formatting
- Format and resize graphics
- Format charts and diagrams
Collaborating
- Protect cells, worksheets and workbooks
- Apply workbook security settings
- Share workbooks
- Merge workbooks
- Track, accept, and reject changes to workbooks
Managing Data and Workbook
- Import data to Excel
- Export data from Excel
- Publish and edit Web worksheets and workbooks
- Create and edit templates
- Consolidate data
- Define and modify workbook properties
Customizing Excel
- Customize toolbars and menus
- Create, edit and run macros
- Modify Excel default Setting
|