Excel® 2010 Core. SDF Course Code / Ref No. : CRS-N-0026514. Course
Description : Microsoft® Excel 2010 Core teaches the skills to create and edit ...
iEnabler – THE IT ENABLING COMPANY
Brought to you by
Microsoft® Office Excel® 2010 Core SDF Course Code / Ref No. : CRS-N-0026514 Course Description : Microsoft® Excel 2010 Core teaches the skills to create and edit professional-looking speadsheets for a variety of purposes and situations. As you begin to build your skills, you will then create a variety of flyers and other professional materials as well as explore different ways to share the information with internal and external customers. Participants who complete this course will have reviewed all of the exam objectives and be on their way to preparing for Microsoft Excel 2010 Core Exam #77-882. Prerequisite:
Certificate Of Attendance :
Working knowledge on computing and desktop application (Windows).
Certificate Of Attendance will be awarded to participants completing the course achieving minimum 75% attendance.
Training Methodology & Materials: Practical hands-on sessions, 75% lab-based and 25% theory-based. Well-designed lab sessions to enhance further understanding of the courseware. Training Duration:
Course Training Fee :
Full-time: 3 Weekdays / 3 Sats Time : 9.30am – 5.30pm
Course Fee : $600 includes 1 MOS Exam Regn Fee : $25
Part-time: 6 sessions Time : 6.30pm-10.00pm (twice a week)
All fees subject to GST 7%. Eligible for SDF Grant and Absentee Payroll. Terms and conditions apply.
DETAILED COURSE OUTLINE Module 1: Introducing Excel 1.1 1.2 1.3 1.4 1.5. 1.6.
What is an Electronic Spreadsheet? Looking at the Screen Entering Data in a Worksheet Working with Workbooks Selecting Cells Review Questions
Module 2: Constructing Cell Data 2.1 2.2 2.3 2.4 2.5 2.6 2.7
Copying and Moving Data Inserting and Deleting Rows and Columns Adjusting the Columns and Rows Finding and Replacing Data Using AutoFill Managing Worksheets Review Questions
Module 3: Using Formulas 3.1 3.2 3.3 3.4 3.5
Using Formulas Using Functions Using Absolute and Relative Cell References Displaying and Printing Formulas Review Questions
Module 4: Formatting the Worksheet 4.1 Formatting a Cell 4.2 Clearing Cell Contents and Formatting 4.3 Themes 4.4 Using Cell Styles 4.5 Conditional Formatting 4.6 Review Questions
Module 5: Viewing and Printing Workbooks 5.1 5.2 5.3 5.4 5.5
Changing Worksheet Views Printing and Previewing the Workbook Customizing the Page Layout Changing Excel Default Settings Review Questions
Module 6: Working with Charts 6.1 6.2 6.3 6.4 6.5 6.6 6.7 6.8
Creating a Basic Chart Moving and Resizing Charts Changing Chart Types Working with Pie Charts Changing the Chart Layout and Location Using Sparklines Printing Charts Review Questions
Module 7: Working with Graphics 7.1 7.2 7.3 7.4
Drawing Shapes Modifying Graphic Objects Using SmartArt Graphics Review Questions
Module 8: Analyzing, Organizing and Sharing Workbooks 8.1 8.2 8.3 8.4 8.5 8.6 8.7 8.8
Sorting Data Filtering Information Working with Named Ranges Using Hyperlinks Using Comments Importing and Exporting Data Sharing Workbooks Review Questions
MOS Excel 2010 Core
6333-4843 IT Enabler Consultancy Pte Ltd 35 Selegie Road #09-06 Parklane Shopping Mall S(188307)
[email protected] www.ienabler.com.sg Company Reg. No.: 200211025Z
