About this Course

Microsoft® Office Excel 2007 teaches the new information worker how to work with worksheets and workbooks toanalyze data using a variety of features to create, modify and format common business reports such as budgets,inventory reports, invoices, and charts. This course is designed for those people who require the skills necessary to usea spreadsheet program on a daily basis to manage and audit numerical reports. 

Course Length :

The Microsoft Business Certification Series can adapt to meet various course length requirements. There are two typesof exercises in this book: Learn the Skill and Practice the Skill (refer to the Conventions and Graphics section to identifythe different icons used for each type).For the shortest course lengths, students can perform just the Learn the Skill exercises.For longer course lengths, students can complete both the Learn the Skill and Practice the Skill exercises.Instructors should refer to the Instructor Resources for this book to learn more about how the material can be adapted. 

Course Prerequisites :

This course is designed for students who are familiar with personal computers, using a keyboard and using a mouse.The course assumes that students have completed the Microsoft Windows Level 1 course or have equivalent MicrosoftWindows knowledge and experience.Students who wish to become proficient using the features of Microsoft Office Excel 2007 will benefit from taking thiscourse

Course Objectives :

After completing this course, you will be able to:

 understand how Microsoft Office Excel handles numerical information for analysis or tracking purposes

 identify and work with the screen, Screen Tips, the Ribbon, and the Quick Access toolbar

 create, edit, save, open, and close workbooks

 select cells for further action such as formatting, deleting, copying and pasting

 change the view mode for specific types of editing tasks

 create and edit simple and more complex formulas

 apply text and numeric formatting options

 control the data flow using appropriate page breaks

 set headers and footers for a worksheet

 change margins, orientation, or layout for printing a worksheet

 preview and print worksheets or workbook

 create, edit, and format simple charts

 use a variety of advanced functions to find and calculate information or data

 insert, modify and format clip art images, pictures, and shapes

 customize charts

 audit worksheets

 work with database functions in Excel

 sort data

 work with named ranges

 use AutoFill to copy or fill data

 find and replace specific types of data

 consolidate or summarize data

 group or outline data

 convert text to columns

 use AutoFill to set up a series of data

 find and replace data in a worksheet

 use Paste Special to create different types of data

 create groups and subtotals from the data in the worksheet

 convert text to columnar formats

 validate data and remove duplicate rows of data

 use pick lists

 working with existing templates, or create your own template

 create, modify or remove a hyperlink

 save a worksheet or a range of cells in a HTML format

 publish a worksheet to the Internet

 work with shared workbooks including adding protection or tracking changes

 changing workbook properties and using the Document Inspector appropriately

 set up a what-if scenario with a worksheet

 use the Goal Seeking and Solver tool

 work with a single or two variable data table

 create and modify PivotTables or PivotCharts

Course Duration : 3days / 22hours

Entry Requirement : Basic Computer Knowledge

Rate this course:

Log in to submit

Comments