Excel 2000 (Program Details)
COURSE OUTLINE
Session 1
Section A: Introduction
- Uses for a Spreadsheet
- Understanding the Excel Workspace
- Selecting a Range of Cells
Section B: Entering Values
- Entering Text, Numbers & Dates
- Formatting Dates & Editing Values
- Sorting a List
Section C: Managing Workbooks
- Saving a Workbook
- Opening & Closing Workbooks
- Workbook Add, Delete, Rename & Move
Section D: Creating a Form or Document
- Creating a Form or Document
- Changing Fonts, Colour & Alignment
- Formatting Dates
- Resizing Columns & Rows
- Creating Backgrounds & Borders
- Inserting Columns
- Merging Cells
Section E: Summarizing Numbers
- Using Auto Fill
- Using Tab to Enter Values
- Creating Totals Automatically
- Understanding the SUM Function
- Creating & Validating Formulas
Section F: Formatting Numbers
- Currency Style
- Auto Formatting Regions & Moving Cells
Section G: Creating Charts
- Adding a Chart
- Adding New Values to a Chart
- Creating a Custom Chart
- Using the Chart Toolbar & Menu
- Chart Location
Section H: Creating Charts
- Print Preview & Page Setup Options
- Preview Colour in Black & White
- Selecting Multiple Sheets
- Printing
Section I: Customizing Excel
- Changing Workbook Options
- Using Adaptive Menus & Toolbars
- Context Sensitive Toolbars
Section J: Discovering More
- Screen Tips
- Use Help in Dialogue Boxes
- Using the Office Assistant
- Help Context
Session 2
Section A: Managing References
- Relative References
- Using Auditing Toolbar
- Mixed & Absolute References
- Saving Workbooks
Section B: Named Ranges
- Naming Cells
- Naming Ranges
- Applying Names
Section C: Manipulating Ranges
- Importing Files
- Special Formatting Features
- Find/Replace
Section D: Basic Functions
- Summarizing Functions
- 3D Formulas
- Logical Functions
- Date Functions
Section E: Look-up Functions
- Types of Look-ups
- Vertical Look-up
- Applying Names to Vertical Look-up
Section F: Financial Functions
- Types of Financial Functions
- Calculating Payments
Section G: Considering Alternatives
- Using Scenarios
- Report Manager
- Using Goal Seek
- Using the Solver
Section H: Enhanced Formatting
- Formatting Numbers
- Formatting Text
- Applying Styles
Section I: Dynamic Formatting
- Applying Conditional Formats
- Using Data Validation
Section J: Graphical Objects
- Using the Drawing Toolbar
- Adding Comments
- Inserting Pictures
Session 3
Section A: Managing Workbooks
- Introduction
- Adding a File Password
- Protecting a Workbook
- Freezing Row & Column Headers
- Changing Page Breaks
- Printing Portions of a Worksheet
- Setting Workbook Properties
- Creating a Workspace
Section B: Using Templates
- Saving & Editing a Template
- Changing the Default Template
- Changing the Default Worksheet Template
Section C: Sharing a Workbook
- Sharing a Workbook
- Editing a Shared Workbook
- Tracking Changes to a Shared Workbook
- Merging Workbooks
Section D: Query a Database
- Retrieving Data from a Database
- Filtering the Data using Microsoft Query
Section E: Working with Lists
- Sorting Lists
- Using a Form to View/Search a List
- Using AutoFilter
- Using the Advanced Filter
- Adding Subtotals to a List
- Tracing Errors
Section F: Working with PivotTables
- Creating a PivotTable
- Formatting a PivotTable
- Creating a PivotChart
Section G: Excel & the Internet
- Saving a Workbook as HTML
- Saving HTML with Interactivity
- Saving an Interactive PivotTable as HTML
- Importing Values from a Web Site
- Creating Hyperlinks in a Worksheet
- Using the Office Clipboard
- Round Tripping to HTML & Back Again
Section H: Creating Macros
- Creating & Running a Macro
- Looking at a Macro's Code
- Creating Another Macro
- Editing the Macro
- Creating a Button to Run a Macro
Section I: Preparing for Certification
- The Testing Method
- Tips for the Exam
Return To Main Product Page
Price: £149.00
(incl. VAT and Delivery)
for Single User Licence
