The Microsoft Excel 2003 Fundamentals and Proficient User courses map to the Microsoft Office Specialist certification objectives for the Excel 2003 Expert exams Learners completing these courses should be well prepared for the certification exams, and have a solid foundation in basic Excel skills The Microsoft Excel 2003 Expert User Part 1 and 2 courses map to the Microsoft Office Expert certification objectives for the Excel 2003 Expert exams Learners completing these courses should be well prepared for the certification exams, and have a solid foundation in basic Excel skills This curriculum consists of four Skill Builder courses:
75032 - Microsoft Excel 2003 FundamentalsCourse OverviewThis course, along with course 75033, maps to the Microsoft Office Specialist certification objectives for the Excel 2003 Expert exams. Learners completing these courses should be well prepared for the certification exams, and have a solid foundation in basic Excel skills. Learn To • To open a template-based workbook • To identify options for managing folders in the Save As dialog box • To identify options for saving a workbook in another file format • To identify options in the Format Cells dialog box • To apply a style to a range of cells • To identify options in the AutoFormat dialog box Audience The target audience will range from new users to power users, although you can expect that the vast majority will have at least had some exposure to previous versions of Excel. Fundamental PC and Windows skills are assumed. Total Learning Time 3 to 4 hours Objectives Unit 1: Basics of Excel 2003 1.5 - 2 hours • Open a template-based workbook • Identify options for managing folders in the Save As dialog box • Identify options for saving a workbook in another file format • Identify Excel 2003 task panes • Identify data types • Identify options for clearing data • Identify options in the Find and Replace dialog box • Identify options in the Go To Special dialog box • Sort data in ascending and descending order • Identify options for filtering data using AutoFilter • Enter a basic formula • Identify methods for revising formulas • Identify types of cell referencing in formulas • Match AutoSum menu commands with their descriptions • Identify categories in the Insert Function dialog box Unit 2: Formatting and Printing 1.5 - 2 hours • Identify options in the Format Cells dialog box • Apply a style to a range of cells • Identify options in the AutoFormat dialog box • Identify options in Print Preview • Set page breaks in a worksheet • Identify options on the Page tab of the Page Setup dialog box • Identify options on the Margins tab of the Page Setup dialog box • Identify options on the Header/Footer tab of the Page Setup dialog box • Identify options on the Sheet tab of the Page Setup dialog box • Identify options in the Print dialog box • Set a print area Microsoft Excel 2003 Proficient UserCourse OverviewThis course, along with course 75032, maps to the Microsoft Office Specialist certification objectives for the Excel 2003 Expert exams. Learners completing these courses should be well prepared for the certification exams, and have a solid foundation in basic Excel skills. Learn To • To cut, copy, and paste cell contents • To identify options in the Paste Special dialog box • To insert and delete cells • To match steps in the Chart Wizard with their descriptions • To identify options in the Format Chart Area dialog box • To identify options in the Diagram Gallery dialog box Audience The target audience will range from new users to power users, although you can expect that the vast majority will have at least had some exposure to previous versions of Excel. Fundamental PC and Windows skills are assumed. Total Learning Time 3 to 4 hours Objectives Unit 1: Manipulating Workbook Elements 1.5 - 2 hours • Cut, copy, and paste cell contents • Identify options in the Paste Special dialog box • Insert and delete cells • Identify Fill Handle commands • Identify options for working with comments in cells • Hide a row and a column • Identify methods for sizing a row and a column • Freeze a row and a column • Insert a worksheet • Identify formatting options on the Sheet menu • Move a worksheet within a workbook by using the Edit menu • Identify methods to split a worksheet • Hide a workbook • Identify options in the Arrange Windows dialog box Unit 2: Charts, Diagrams, and Drawing Objects 1.5 - 2 hours • Match steps in the Chart Wizard with their descriptions • Identify options in the Format Chart Area dialog box • Identify options in the Diagram Gallery dialog box • Identify options on the Diagram toolbar • Identify types of AutoShapes • Identify methods for manipulating AutoShapes • Identify options in the Insert Hyperlink dialog box • Preview a workbook as a Web page • Identify options in the Publish Web Page dialog box 75034 - Microsoft Excel 2003 Expert Part 1Course OverviewThis course, along with course 75035, maps to the Microsoft Office Expert certification objectives for the Excel 2003 Expert exams. Learners completing these courses should be well prepared for the certification exams, and have a solid foundation in basic Excel skills. Learn To • To format a worksheet • To manipulate a graphic • To manage Excel templates • To secure a workbook • To share a workbook • To import data to Excel • To export data from Excel • To group, outline, and consolidate data from two or more worksheets in Excel Audience The target audience will range from new users to power users. It is expected that the vast majority of learners will have at least had some exposure to previous versions of Excel. Fundamental PC and Windows skills are assumed. Total Learning Time 3 to 4 hours Objectives Unit 1: Formatting Worksheets and Graphics 0.5 - 1 hour • Format a worksheet • Manipulate a graphic Unit 2: Using Templates and Securing Workbooks 0.5 - 1 hour • Manage Excel templates • Secure a workbook Unit 3: Working with Shared Workbooks 1 hour • Share a workbook Unit 4: Transferring and Managing Data 1 hour • Export data from Excel • Group, outline, and consolidate data from two or more worksheets in Excel • Create a PivotTable and a PivotChart report • Import data to Excel • Use a list range and an advanced filter 75035 - Microsoft Excel 2003 Expert Part 2Course OverviewThis course, along with course 75034, maps to the Microsoft Office Expert certification objectives for the Excel 2003 Expert exams Learners completing these courses should be well prepared for the certification exams, and have a solid foundation in basic Excel skills Learn To • To manage a named range • To manage a function in Excel • To check data in Excel • To use Evaluate Formula, cell Watch, and Data Validation • To analyze and project data in Excel • To modify default Excel settings • To modify toolbars, menus, and workbook properties • To create, edit, and run a macro Audience The target audience will range from new users to power users. It is expected that the vast majority of learners will have at least had some exposure to previous versions of Excel. Fundamental PC and Windows skills are assumed. Total Learning Time 3 to 4 hours Objectives Unit 1: Managing Named Ranges and Functions 1 hour • Manage a named range • Manage a function in Excel Unit 2: Auditing, Analyzing and Structuring Data 1 - 2 hours • Check data in Excel • Use Evaluate Formula, cell Watch, and Data Validation • Structure data using XML • Analyze and project data in Excel Unit 3: Modifying Excel and Working with Macros 1 hour • Modify default Excel settings • Modify toolbars, menus, and workbook properties • Create, edit, and run a macro Single User License |
|
|
|
|
|
|
|
|
|
**Register Today and Save $$ with Planetlearn.com**
Prices are for single user. If you are looking for internet/intranet or LAN solutions and have specific training needs not listed, please call 207-671-1666 or E-Mail sales@planetlearn.com
Partner Sites
Planetlearn Order securely online or call 207-671-1666 |