Datrix Training offers Office Excel is a powerful tool you can use to create and format spreadsheets, and analyze and share information to make more informed decisions. With the Microsoft Office Fluent user interface, rich data visualization, and PivotTable views, professional-looking charts are easier to create and use. Microsoft Excel 2007 also offers more room for you to work in and delivers faster performance.
MS EXCEL 2002 INTRODUCTION – 1 DAY COURSE
Module 1: The Fundamentals in Excel 2002
Starting Excel
Understanding the Excel Program Screen
Opening a Workbook
Saving a Workbook
Moving the Cell Pointer
Navigating a Worksheet
Entering Labels in a Worksheet
Entering Values in a Worksheet and
Selecting a Cell Range
Calculating Value Totals with AutoSum
Entering Formulas
Using AutoFill
Previewing and Printing a Worksheet
Closing a Workbook and Exiting Excel
Module 2: Editing a Worksheet in Excel 2002
Entering Date Values and using AutoComplete
Editing, Clearing, and Replacing Cell Contents
Cutting, Copying, and Pasting Cells
Moving and Copying Cells with Drag and Drop
Collecting and Pasting Multiple Items
Working with Absolute and Relative Cell References
Using the Paste Special Command
Inserting and Deleting Cells, Rows, and Columns
Using Undo, Redo, and Repeat
Checking Your Spelling
Finding and Replacing Information
File Management
Inserting Cell Comments
Understanding Smart Tags
Recovering Your Workbooks
Module 3: Formatting a Worksheet in Excel 2002
Formatting Fonts with the Formatting Toolbar
Formatting Values
Adjusting Row Height and Column Width
Changing Cell Alignment
Adding Borders
Applying Colours and Patterns
Using the Format Painter
Using AutoFormat
Creating a Custom Number Format
Formatting Cells with Conditional Formatting
Merging Cells, Rotating Text, and using AutoFit
Finding and Replacing Formatting
Module 4: Creating and Working with Charts in Excel 2002
Note: It is possible to customise and tailor each Microsoft Excel course ot meet your training objectives. There is usually no extra charge for customising your training course.
