USING EXCEL 95
Advanced

Netscape 4.05 & earlier & Microsoft IE 4.5 for Macintosh Y2K Browser Bug

Call Us at 317-881-3826

Or

Click here:

Chat Live: Instant Message  

Customizing Excel

  • Creating A Custom Toolbar
  • Naming A New Toolbar
  • Creating A Floating Toolbar
  • Resizing A Toolbar
  • Returning A Floating Toolbar To The Top Of The Screen
  • Adding Notes To A Worksheet
  • Identifying Cells With Notes
  • Viewing An Attached Note
  • Activating The Info Window
  • Displaying Information In The Info Window
  • Viewing All The Notes In A Worksheet Window
  • Moving Cell By Cell Using The Keyboard
  • Creating A Custom AutoFill List
  • Creating Custom Number Format Codes
  • Reviewing Color Choices In Excel
  • Creating Placeholders For Numbers
  • Using Text Formatting Codes
  • Creating Formats For Telephone Numbers And Account Numbers
  • Widening Columns

Special Features

  • Entering Grand Totals With AutoSum
  • Outlining Worksheets
  • Viewing Row Level Buttons
  • Viewing Row Level Bars
  • Viewing The Collapse Button
  • Viewing The Expand Button
  • Hiding Detailed Information Using The Level Buttons
  • Removing An Outline
  • Consolidating Worksheets
  • Linking A Destination Worksheet To A Source Document
  • Expanding Levels To See Detailed Figures
  • Working With Sheets As Groups
  • Adding & Deleting Sheets
  • Moving & Copying Sheets Within A Workbook Or To Another Workbook
  • Inserting A Sheet Or Sheets
  • Entering Data, Formulas & Changes In Multiple Worksheets At The Same Time
  • Deactivating & Activating The Group

Using Cell Styles

  • Creating A Cell Style
  • Redefining A Style
  • Merging Styles Between Documents
  • Applying A Style To A Range Of Cells

Building A List

  • Building A List
  • Discussing Guidelines For Entering Rows & Columns
  • Using A Data Form
  • Changing A Record
  • Deleting A Record
  • Adding A New Record
  • Defining Criteria & Matching Records
  • Using Comparison Operators
  • Using Operators To Find Records
  • Using The Data Sort Command
  • Explaining Ascending Order Sorts
  • Explaining Descending Order Sorts
  • Filtering A List Using AutoFilter
  • Specifying Custom Criteria For Each Column
  • Summarizing Data In An Excel List Using Automatic Subtotals
  • Creating An Automatic Average
  • Creating An Automatic Subtotal By Gender

Additional Features

  • Demonstrating A Template
  • Editing A Template
  • Viewing An AutoTemplate
  • Explaining Pivotm Table Wizard
  • Explaining Scenario Manager
  • Using Text Wizard
  • Recording A Macro To Automate Repetitive Tasks

 

© Copyright PCPAL Solutions, Inc. and New Century Marketing Concepts