Microsoft Office 97 - Excel 97 - E97B

Description

ATS expert Reed Jacobson will show you how to make Microsoft Excel a powerful tool for your personal and business productivity. You'll learn to perform fundamental tasks, as well as exciting but little-known techniques. This series uses simple, practical examples to teach you all the basic skills you need to be effective using Excel 97.

Course Outline

Module 1

Section A: Introduction • Introduction & Explanation •Ways to Use Spreadsheet

Section B: Using a Spreadsheet • Entering Text & Numbers • Adding Numbers in Cells • Combining Words • List vs. Grid

Section C: Getting Help • Office Assistant Tool • Touch, Contents, Index & Find

Section D: Getting Around on a Workbook • Cell & Range • Moving a Cell or Range • Insert & Delete

Section E: Getting Around in a Workbook • Adding, Deleting & Naming Worksheets • Viewing Multiple Worksheets • Changing Multiple Sheets • Rearranging Worksheets

Section F: Managing Workbooks • Saving, Opening & Creating Workbooks • Renaming Workbooks • Default File Location & Changing Default

Section G: Formatting Values • Formatting Currency • Formatting Dates & Sizing Cells • Formatting Numbers & Labels • Copying Format to Another Cell

Section H: Formatting Ranges • Using Auto Format & Borders • Underlining & Creating • Gaps Between Cells • Centering Over Multiple Cells • Merge Cell Feature & Vertical Text

Section I: Making Calculations • Sales Tax Loan Payment

Section J: Validating Worksheets • Spell Checking • Color Coding Formula • Changing a Formula for Different Cells • Undo & Redo Features • Calculate a Formula in Reverse

Section K: Printing • Print Preview & Command • Headers & Footers • Selecting Author of Workbook • Printing Part of a Worksheet • Repeating Rows & Columns for Printing

Section L: Charting • Creating with Chart Wizard • Changing Existing Chart • Printing Charts

Module 2

Section A: Introduction

Section B: Getting Efficient • Keyboard Shortcuts • Efficient Mouse Use • Customize a Toolbar

Section C: Controlling the Worksheet Appearance • Hide Rows & Columns • Custom Views

Section D: Copying • Formulas Options • Make a Cell Pointer that Adjusts Columns or Rows Only

Section E: Working with Formulas • Work with Formulas as a Block • Keeping Formula Block the Same

Section F: Creating Practical Formulas • Running Total Formula • Calculate a Growth Rate

Section G: Making Formulas Readable • Using Labels • Name vs. Label • Redefine Names

Section H: Creating Sample Data • Create a List • Making Specific Random Numbers Round Numbers to the Nearest 5

Section I: Looking Up Values • Discount Percent • Lookup Product Name • Lookup State

Section J: Making Decisions • Make Her Appear Only When it Changes • Assign One Field to Another

Section K: Working with Lists • Show Only Specific Rows • Subtotal • Get Unique List

Section L: Working with Dates • Date Format • Number of a Month • First Day of a Month

Module 3

Section A: Introduction

Section B: Making Sophisticated Charts • Custom Charts • Mixing Big & Little Numbers • Cause & Effect Charts

Section C: Making Rules • Protecting the Worksheet • Limit Values that Can G into the Spreadsheet • Point Out Unusual Values

Section D: Linking Beyond the Worksheet • Link to a Cell Outside Your Workbook • Importing Multiple Cells • Fix a Broken Link

Section E: Sharing Workbooks • Edit Multiple Copies of a Workbook • Save Changes when Working with Multiple Copies of a Workbook • Conflict Manager

Section F: Creating Pivot Tables • Prepare Data • Create a Pivot Table • Determine which Areas Have Totals • Group Dates

Section G: Accessing External Databases • Make a Pivot Table Retrieve Part of a Database • Switch Retrieved Portion

Section H: Creating Jumps • Make Somebody Jump to Another Worksheet • Jump to a Word Document • Jump to a Web Page

Section I: Integrating with the Internet • Web Toolbar • Turn a Worksheet into a Web Page

Section J: Using ActiveX Controls • Nature of the Controls • Two-Column Box List

Section K: Creating Macros • Creating a Macro • Editing a Macro • Enhancing a Macro "With" in a Macro • Toggle Macro

Section L: Making Macros Easy to Run • Simplify Running the Macro • Run a Macro from a Toolbar • Run a Macro from a Worksheet

Price £ 358 (Bundle of 3)

Complementary Courses
Word 97
Access 97
Powerpoint 97
Outlook 98
Office 97 Bundle

<<Back <<Contact Us