Schedule	Course List
		Excel Intermediate
	Microsoft Excel  Introduction One Day Course	Excel Advanced

Course Outline This course is designed to give the delegate a good understanding of the basic concepts of spreadsheet design, commands, data manipulation and presentation. Delegates Requirements It is essential that the delegate has attended a Windows Introductory Course or gained similar knowledge in the work place. Who should attend New users of Microsoft Excel who want to gain a good understanding of how to use the software in a short space of time.

MS Excel Introduction What is a Spreadsheet?   Getting Started with Excel Starting Excel The Title Bar; The Menu Bar; Toolbars Scroll Bars; Active Cell, Column and Row Headers Sheet Tabs; The Status Bar; Menus and Submenus SpeedKeys; Dialogue Boxes; Exiting Excel   Getting Assistance with Excel Using the Office Assistant Getting Help Without the Office Assistant Manipulating the Help Window Finding Out What is On the Screen   Starting a Workbook Creating a New Workbook Moving Around the Sheet Scrolling; The Mouse Pointer Selecting Cells with the Mouse Selecting Cells with the Keyboard Spreadsheet Data Types Entering and Editing Data Editing Long Entries Undoing Incorrect Edits AutoFill; Custom Lists Saving, Closing, Opening and Deleting a Workbook   Excel Intermediate Excel Advanced

Working with Worksheets and Cells Using Go To Drag-and-Drop, Cut, Copy and Paste Using the Office Clipboard Using Find and Replace   Building Formulas Simple Calculations and Priorities Creating and Manipulating 3D Formulas Functions and the Function Wizard Relative and Absolute Cell Referencing Using AutoCalc and AutoSum Data Series   Formatting Cells Auto Format and Styles Changing Cell Alignment Applying Borders, Fonts and Colour Formatting Numbers Resizing Columns and Rows Clearing a Worksheet   Structuring the Worksheet Inserting and Deleting Rows and Columns Inserting and Deleting Worksheets   Printing Worksheets Print Preview Changing the Page Setup; Printing

Site Map