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 EXCEL2002 INTERMEDIATE – 1 DAY COURSE
Module 1: Managing Your Workbooks in Excel 2002
Switching Between Sheets in a Workbook
Inserting and Deleting Worksheets
Renaming and Moving Worksheets
Working with Several Workbooks and Windows
Splitting and Freezing a Window
Referencing External Data
Creating Headers, Footers, and Page Numbers
Specifying a Print Area and Controlling Page Breaks
Adjusting Page Margins and Orientation
Adding Print Titles and Gridlines
Changing the Paper Size and Print Scale
Protecting a Worksheet
Hiding Columns, Rows and Sheets
Viewing a Worksheet and Comparing Workbooks Side by Side
Saving a Custom View
Working with Templates
Consolidating Worksheets
Module 2: More Functions and Formulasin Excel 2002
Formulas with Several Operators and Cell Ranges
Using the Insert Function Feature
Creating and Using Range Names
Selecting Nonadjacent Ranges and Using AutoCalculate
Using the IF Function to Create Conditional Formulas
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.
