American Computer Utopia.  Register for a workshop today (301) 559-0234

American Computer Utopia

Info Request Form

Go


 

 

This workshop is designed to provide a fast track process for those who are interested in mastering MS Excel 2000 in 6 comprehensive sessions.  It covers fundamental to advanced topics.

I. Essentials (Two 3 Hour Sessions) One Day 

 Workshop Highlights

  • Navigating the Excel Workbook and Worksheet Environment
  • Customizing your Excel Layout

  • Using Built in Features to Create an Invoice

  • Adding Pictures and Other Color Graphics to the Worksheet

  • Creating Easy to use Formulas and Calculation

  • Dressing up Worksheets to Create a Professional Look

  • Formatting Your Worksheets to Incorporate Headers, Footers, and Page Margins

  • Developing a Year-To-Date Summary and Chart

  • Use of Filters to Search for a Set of Records

  • Adjustment and Printout of Project Revenues

II. Intermediate (Two 3 Hour Sessions) One Day

Workshop Highlights

  • Using the Sorting, Summarizing and Outline Feature
  • Standardization of Tasks and Procedures using a Macro
  • Importing Data from Other Programs
  • Distribution of Page Reports to Individuals
  • Creating a Pie PivotChart Report to Graphically Convey Data
  • Comprehension of Data Trends and Relationships
  • Setting Up Your Print Area for Selective Print Jobs
  • Converting Your Excel Document into a Web Page
  • Maintaining Your Worksheets as Web Pages Online
  • Analyzing Data and Sharing Your Workbook With Others
  • Converting an Excel Worksheet into an Access Table

III. Advanced (Two 3 Hour Sessions) One Day

Workshop Highlights

  • Creating a Flowchart and Other Personalized Graphics for Presentation
  • Retrieving and Validating Data from Other Applications
  • Modifying and Automating Macros to Fit your Daily Tasks
  • Extracting and Filtering Data from a List
  • Customizing a Filter to Fit Your Needs
  • Develop a Gant Chart Manually or Through the use of the Chart Wizard
  • Create Data Maps to Track Sales, Expenses, Resources, and Other Business Data

 


American Computer Utopia
Main Campus and Corporate Headquarters
2781 Hamilton Street, Hyattsville, MD 20782
Tel: (301) 559-0234 Fax (301) 559-3938
Internet: http://www.HighTechTraining.com
E-mail: webmaster@HighTechTraining.com

* Not all workshops & programs are offered in our Maryland location.