Excel Intermediate 2007
Description
This course will expand upon the skills you learned in the Excel 2007 Level 1 course and give you an opportunity to work with some more advanced features of Excel, including templates; sorting and filtering; importing and exporting; advanced formulas; analysis tools; and collaboration.
Entrance Requirements
Participants should have a basic understanding of MS Excel, the ability to navigate the desktop and work with multiple windows.
Who Should Attend
This course is designed for students desiring to prepare to be a certified Microsoft Office Specialist (MOS) in Excel or for those needing to work within spreadsheets.
Course Outline
Working with large worksheets
- Viewing options
- Hiding, Displaying & Outlining Data
- Printing Large Worksheets
Using Multiple Worksheets and Workbooks
- Using Mulitiple Worksheets
- Linking Worksheets by using 3-D Formulas
- Consolidating Data
- Linking Workbooks
- Managing Workbooks
Customizing Excel
- Using the options Dialog Box
- Customising Toolbars and Menus
Advanced Formatting
- Borders & Shading
- Using Special Number Formats
- Working with Dates
- Working with Styles
- Other Advanced Formatting
List Management
- Examining Lists
- Sorting & Filtering Lists
- Advanced Filtering
Advanced Charting
- Chart Formatting options
- Using Combination Charts
- Using Graphic elements
Documenting & Auditing
- Auditing Features
- Comments and Text Boxes
- Protection
- Workgroup Collaboration
Using Templates
- Built-In Templates
- Creating & Managing Templates
Examinations and Assessments
Learners write the CCS IT examination, the pass mark for which is 70%. Learners may elect to write the International Microsoft examinations at CCS’s Authorized Prometric Testing Centre. The costs for International exams are not included in the course fees.
Learning Materials
All standard learning materials are included in the course fee.
Links and Further Information
Duration and Times
We run this course as both full time (1 day) and part time (2 evenings) course. Contact us for current starting dates and times.