Intermediate Microsoft Office Excel Syllabus

<%@LANGUAGE="VBSCRIPT" CODEPAGE="1252"%> Intermediate Microsoft Office Excel Syllabus

Back to Technology Professional Development Main Page
Intermediate Microsoft Office Excel Syllabus
Prerequisites	Beginning Microsoft Office Excel
Session 1 Working with templates	Creating a document based on a template Saving a copy of a document
Session 2 Formatting Documents	Beyond Bold and Italic Format Pasting
Session 3 Formatting Documents	Inserting Rows Inserting Columns Inserting Worksheets Merging Cells Borders and fill colors
Session 4 Formatting Documents	Moving Data Hiding Data Freezing Panes
Session 5 Working with Functions	Custom Functions Creating cell constants
Session 6 Working with Functions	Multilayer and multi sheet functions The function library
Session 7 Working with Charts	Creating a chart Formatting a chart
Session 8 Working with Data	Custom Filtering Custom Sorting
Session 9 Making Excel More Efficient	Using toolbars Customizing toolbars Keyboard Shortcuts