Microsoft Office 2000 - Excel 2000 - CE2B

Description

In ATS’s Excel 2000 training series, expert, Reed Jacobson, guides you through spreadsheet fundamentals and provides inside tips for powerful business applications. You’ll learn formatting, summarizing, and charting methods, along with some little-known techniques that will help you get up to speed and working efficiently. This course meets MOUS Certification requirements. This course meets MOUS Certification requirements.


Course Outline

Module 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 • Changing Fonts, Color & 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 Color 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

Module 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


Module 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 Overview • Saving & Editing a Template • Changing the Default Template • Changing the Default Worksheet Template

Section C: 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 Pivot Tables • 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

Price £ 358 (Bundle of 3)

Complementary Courses
Word 2000
Powerpoint 2000
Access 2000
Outlook 2000
FrontPage 2000
Publisher 2000
Photodraw 2000
Office 2000 Bundles

<<Back <<Contact Us