Updated 29 February, 2012
| Microsoft™ Excel 2010 (MOS Certification) |
 |
Course Details
|
Microsoft Excel 2010 is a financial tool for performing calculations and other tasks automatically. It lets you accomplish a variety of business or personal tasks in a fraction of the time it would take using pen and paper. This course shows you how to work efficiently with Excel, and prepares you for the Microsoft Office Specialist 77-882 exam and Microsoft Office Specialist (MOS) certification.
The course is completed online, at your own time, at a location that suits you. You progress through the course materials and complete the online lessons and tests.
Students are provided with Flash-based instructional demonstrations, Instructional audio with graphics highlighting key points. Simulations teach learners to perform specific tasks in applications through guided, multi-step exercises. Activities allow learners to apply course concepts in an interactive questioning environment. Exercises allow learners to practice in the actual application being studied. Full-page images allow learners to experience an application as if it were open on their computer. The course challenge the learner with a variety of question formats, including multi-step simulations, true/false, multiple choice, and fill-in-the-blank, and a skill assessment generates a customised learning path based on the results of a pre-test. Bookmarking tracks the learner's progress in a course.
|
|
|
Topics Covered in this Course
Becoming Familiar with Excel
- Use the Ribbon and toolbars
- Create new workbooks
- Open existing workbooks
- Move around in workbooks
- Save workbooks
- Recover workbook backups
Basic Tasks
- Selecting Cells, Rows, and Columns
- Entering Labels and Values
- Editing and Clearing Cell Contents
- Copying, Moving, and Pasting Content
- Inserting, Deleting, and Replacing
- Using AutoCorrect and Actions
Formulas and Functions
- Working with Formulas
- Editing Formulas and Using References
- Naming Cell Ranges
- Performing Calculations
Correcting Errors
- Audits and Circular References
- Creating Functions
- Array Formulas and Nested Functions
Workbook and Worksheets
- Working with Excel Worksheets
- Moving, Copying, and Hiding Worksheets
- Selecting and Hiding Columns and Rows
- Inserting and Deleting Columns and Rows
- Adjusting Column Width and Row Height
- Freezing and Splitting Worksheets
- Creating Views and Saving Layouts
Viewing and Printing
- Setting Up Pages for Printing
- Adjusting Page Margins
- Adding Headers and Footers
- Inserting Page Breaks
- Customizing the Print Area
- Previewing and Printing
Working with Graphics
- Using Clip Art and Media Clips
- Inserting Pictures and Screenshots
- Applying Styles, Shapes, and Borders
- Correcting and Recoloring Pictures
- Adding Transparency
- Creating WordArt Text
- Building SmartArt Graphics
- Drawing and Modifying Shapes
Who should complete this course?
- People who wish to learn how to use Microsoft Excel 2010 and learn at their own pace.
- Students, or those new to the workforce, who wish to learn how to use this software program.
- Existing users who wish to get more out of Microsoft Excel 2010.
Entry Requirements / Prerequisites
- You must have a basic working knowledge of Microsoft Windows and access to the internet to complete the course.
Assessment
- Once you successfully pass the programme, you will receive a Certificate in Microsoft Excel 2010 from CMIT.
Technical Requirements
- The following technical requirements apply: 128MB of RAM; Windows 2000, 2003, XP, Vista, Minimum screen resolution 800x600, Internet Explorer 5.5 or higher; Windows Media Player 9.0 or higher; Flash 8.0 or higher; 56K minimum connection; broadband (256 kpbs or higher) connection recommended; Javascript, DHTML and cookies enabled; Sound card with speakers or headphones strongly recommended.
Accreditation
- Following completion of the online assessment you will receive a Certificate in Microsoft Excel 2010 from College of Management and IT (CMIT). You may optionally complete the Microsoft Office Excel 2010 Specialist 77-882 exam. Contact the college for details.