College:
|
College SA |
| School: |
Computer School |
| Course: |
MS Excel 2007 Proficient
|
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: Proficient?
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?
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.
MS Excel 2007: Proficient 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
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
Course Duration
This course should take you approximately 3 - 6 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.
Other Career Skills Courses You May Be Interested In
- MS Word 2007 Proficient
- MS Word 2007 Proficient and Expert
- MS Excel 2007 Proficient and Expert
- MS Access 2007 Proficient
- MS Access 2007 Proficient and Expert
- MS PowerPoint 2007 Proficient
- MS PowerPoint 2007 Proficient and Expert
- MS Vista level Proficient
- MS Vista level 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.
|
