This one-day instructor-led course will provide a thorough understanding of the introductory and intermediate concepts and skills that will enable the participant to effectively use Microsoft Excel 2003 through group and individual instruction, hands-on practical exercises, visual aids, and comprehensive training manuals and materials.
Skills Gained:
Upon successful completion of this course, students will be able to create and edit basic Microsoft Office Excel worksheets and workbooks.
Course Modules:
Getting Started in Excel • The Microsoft Excel Screen Layout • Accessing Menus • Personalised Menus • Toolbars • Working with Dialog Boxes • About the Task Panes • Accessing Different Task Panes in Excel 2002 and 2003 • Moving Around the Worksheet • Creating a Workbook • Saving a Workbook with a Different Name • Opening Workbooks • Exiting Microsoft Excel • Editing Worksheets
Selecting Cells • Entering Data in Preselected Cells4 • Editing the Contents of a Cell • Undo and Redo • Clearing Cell Contents and Formats • Cut, Copy and Paste Data into Cells • Cutting and Pasting Data in Cells • Copying and Pasting Data in Cells • Collect and Paste in Excel 2002 and 2003 • Using Autocomplete • Using Autofill • Filling a Series Using Autofill • Creating a Fill Based on Multiple Values • Using List Autofill • Using Find • Finding and Replacing Data • Using the Go to Function • Creating Simple Formula
Mathematical Operators • Creating a Formula • Typing Vs. Pointing • Using the Autosum Button • Copying Formulae • Using Autofill to Copy Formulae • Absolute Cell References • Quickly Calculating a List of Numbers • Working with Functions
Date and Time • Using the Now Function • Using the Today Function • The Insert Function or Paste Function Command • Using Insert or Paste Function Command • Statistical Functions • The Average Function • The Max Function • The Min Function • The Count Function
Formatting Cells • Selecting Rows and Columns • Inserting and Deleting Rows and Columns • Row Heights and Column Widths • Hiding Rows and Columns • Unhiding Rows and Columns • Formatting Cells • Formatting Numbers • Aligning Cell Contents • Centering Text Across Cells • Unmerging Cells • Formatting Fonts • Applying Borders to Cells • Using the Border Drawing Tool in Excel 2002 and 2003 • Applying Shading and Patterns to Cells • Finding and Replacing Formatting in Excel 2002 and 2003 • Autoformatting a Worksheet • Conditional Formatting • Deleting Conditional Formatting • Page Setup and Printing
Changing the Page Setup • Setting Margins • Working with Headers and Footers • Setting the Print Options • Print Preview • Printing a Workbook • Working with Charts
Creating a Chart Using the Chart Wizard • Resizing and Moving a Chart • Rotating a 3-D Chart • Changing the Chart Data • The Chart Toolbar • Using the Chart Toolbar • Adding Extra Data • Formatting a Chart • Changing Display Units for Charts • Inserting Pictures as a Data Series • Creating Charts with Non-Contiguous Data • Printing a Chart • Deleting a Chart • Viewing Worksheets
Using Different View Modes • Using the Zoom Feature • Arranging Workbook Windows • Customising View Options • Freezing Panes • Splitting the Worksheet • Removing the Split • Hiding Worksheets • Unhiding a Worksheet • Hiding a Workbook • Unhiding a Workbook • Displaying Cells Using the Watch Window • Removing a Cell from the Watch Window • Spell Checking the Worksheet
Using the Spell Checker • Using Spelling Options • Using Autocorrect • Adding an Entry into Autocorrect
Who Should Attend:
This course is designed for persons preparing for certification as a Microsoft Office Specialist in Excel, who already have knowledge of Microsoft Office, and who desire to gain the skills necessary to create, edit, format, and print basic Microsoft Office Excel 2003 worksheets.
Prerequisites:
Attendance at an introduction to PCs course or equivalent experience.
