College:
|
College SA |
| School: |
Computer School |
| Course: |
MS Excel 2007 Proficient and Expert
|
Award type:
|
Certificate |
Programme type:
|
College SA Programme |
SAQA Programme ID:
|
N/A |
| NQF Level: |
N/A |
| Certificate issued by: |
College SA |
What is MS Excel 2007?
MS Excel is a tool used to create, edit, format as well as to analyze data. MS Excel is also used to customize and enhance workbooks utilizing advanced functions necessary to create macros, collaborate with others, audit and analyze worksheet data, incorporate multiple data sources, and import and export data.
Why should I study MS Excel 2007 Proficient and Expert?
This course is for you if you want to gain the skills necessary to create, edit, format, and print basic Microsoft Office Excel 2007 worksheets as well as the advanced functions such as lists and tables, advanced charting, exporting and importing and analytical options.
If you want to pursue your Microsoft Office Specialist certification (MOS) in Microsoft Office Excel 2007 (exam 77-602), this is also the right course for you.
Microsoft Office Specialist Certification (MOS)
The Microsoft Office Specialist Certification (MOS) credential is a globally recognised standard that validates skills in the use of Microsoft Office 2007 as well as with the Windows Vista operating system. MOS meets the demand for the most up-to-date skills using the latest technologies from Microsoft.
By earning your MOS credential, you will prove your expertise using the latest Microsoft Office programs. This certification can help you stand out in today’s competitive job market.
You must pass one certification exam in order to earn your MOS credential.
MOS: Windows Vista for the Business Worker
|
Exam 77-600 |
| MOS: Microsoft Office Word 2007 |
Exam 77-601 |
| MOS: Microsoft Office Excel 2007 |
Exam 77-602
|
MOS: Microsoft Office PowerPoint 2007
|
Exam 77-603 |
MOS: Microsoft Office Outlook 2007
|
Exam 77-604 |
MOS: Microsoft Office Access 2007
|
Exam 77-605 |
To find out more about your MOS credential please go to: http://www.microsoft.com/learning/en/us/certification/mbc.aspx#tab2
MS Excel 2007 Course Structure
Proficient
- Tactics for Winning
- Getting started
- Entering and editing data
- Modifying a worksheet
- Using functions
- Formatting worksheets
- Printing
- Creating charts
- Managing large workbooks
- Using multiple worksheets and workbooks
- Lists and tables
- Web and Internet features
- Templates and settings
Expert
- Advanced formatting
- Outlining and subtotals
- Cell and range names
- Lists and tables
- Advanced charting
- Documenting and auditing
- Advanced functions
- Lookups and data tables
- Advanced list management
- PivotTables and PivotCharts
- Exporting and importing
- Analytical options
- Macros and custom functions
- Conditional formatting and SmartArt
MS Excel 2007 Proficient: Programme Outcomes
Tactics for winning
- This is the first module that all students have to complete once they have registered with College SA. This module is designed to introduce students to the College. In this module, you will learn more about how Distance Learning works and what the best ways are to study and to prepare for assessments.
Getting started
- Spreadsheet terminology
- Exploring and Excel window
- Getting help
- Navigating workbooks
Entering and editing data
- Entering and editing text and values
- Entering and editing formulas
- Working with pictures
- Saving and updating workbooks
Modifying a worksheet
- Moving and copying data
- Moving and copying formulas
- Absolute and relative references
- Inserting and deleting ranges, rows, and columns
Using functions
- Entering functions
- AutoSum
- Other useful functions
Formatting worksheets
- Formatting text
- Formatting rows and columns
- Formatting numbers
- Conditional formatting
- Copying formats and applying table formats
Printing
- Preparing to print
- Page setup options
- Printing worksheets
Creating charts
- Chart basics
- Modifying charts
- Printing charts
Managing large workbooks
- Viewing large worksheets
- Printing large worksheets
- Using multiple worksheets
Using multiple worksheets and workbooks
- Using multiple workbooks
- Linking worksheets with 3-D formulas
- Linking workbooks
- Managing workbooks
Lists and tables
- Examining lists
- Sorting and filtering lists
- Advanced filtering
- Working with tables
Web and Internet features
- Saving workbooks as web pages
- Using hyperlinks
- Distributing workbooks
Templates and settings
- Application settings
- Built-in templates
- Creating and managing templates
MS Excel 2007 Expert: Programme Outcomes
Advanced formatting
- Using special number formats
- Using functions to format text
- Working with styles
- Working with themes
- Other advanced formatting
Outlining and subtotals
- Outlining and consolidating data
- Creating subtotals
Cell and range names
- Creating and using names
- Managing names
- Cell and range names
Lists and tables
- Examining lists
- Sorting and filtering lists
- Advanced filtering
- Working with tables
Advanced charting
- Chart formatting options
- Combination charts
- Graphic elements
Documenting and auditing
- Auditing features
- Comments in cells and workbooks
- Protection
- Workbook collaboration
Advanced functions
- Logical functions
- Math and statistical functions
- Financial functions
- Displaying and printing formulas
Lookups and data tables
- Using lookup functions
- Using MATH and INDEX
- Creating data tables
Advanced list management
- Validating cell entries
- Exploring database functions
PivotTables and PivotCharts
- Working with PivotTables
- Rearranging PivotTables
- Formatting PivotTables
- PivotCharts
Exporting and importing
- Exporting and importing text files
- Exporting and importing XML data
- Querying external databases
Analytical options
- Goal seek and solver
- The analysis ToolPak
- Scenarios
- Views
Macros and custom functions
- Running and recording a macro
- Working with VBA code
- Creating functions
Conditional formatting and SmartArt
- Conditional formatting with graphics
- SmartArt graphics
Course Duration
This course should take you approximately 6 - 12 months to complete
Assessment and Award
You have to successfully complete and submit assignments in order to pass this course. Once you have successfully completed the assignments prescribed by College SA, you will be awarded a College SA Certificate of completion in MS Excel 2007 Proficient and Expert.
Other Career Skills Courses You May Be Interested In
- MS Word 2007 Proficient
- MS Word 2007 Proficient and Expert
- MS PowerPoint 2007 Proficient
- MS Outlook 2007 Proficient
- MS Outlook 2007 Proficient and Expert
- MS PowerPoint 2007 Proficient and Expert
- MS Vista Proficient
- MS Vista Proficient and Expert
If you are interested in one of these courses, please contact one of our Student Registrars and ask them for more information. They will be happy to help you.
|
