Arlene Ross
Head Client Manager, NYIM

Compare to Competitors »

Client Testimonials  More »

"Overall, I would rate the preparation, use of time, knowledge of material and general kindness as one of the best training classes/sessions that I have ever attended. I have and will continue to recommend Joe Tandle and the folks at NYIM to others.”

— K. Burton of Microsoft Corp.,
     received Excel & PowerPoint
     Private Training


Excel 2003 For Business

Price: $ 135
Total Hrs: 7
 
   
09-11-2010 - SIGN UP
Weekend: Sat 9/11
Time: 10:30AM-5:30PM
09-22-2010 - SIGN UP
Evenings: Wed 9/22, Thurs 9/23
Time: 5:45PM-8:45PM
10-05-2010 - SIGN UP
Days: Tues 10/05
Time: 10AM-5PM
11-15-2010 - SIGN UP
Days: Mon. 11/15
Time: 10AM-5PM
12-28-2010 - SIGN UP
Days: Tues 12/28
Time: 10AM-5PM

This schedule does not work for me.
Please send me more options.

 

Untitled Document

Excel For Business

Class Type:

  • Can retake the class, for free, up to 3 months.
  • Free forum support for 1 year after class
  • Hands on, goal based
  • Small Classes of 4 to 9 people
  • Fast computers
  • Comfortable chairs, convenient location
  • Patient, Fun, Experienced Trainer
When you are finished with this class you will be able to:

  • Create and manipulate advanced charts
  • Understand how to manage Excel databases
  • Create complex formulas
  • Format text and numbers
  • Efficiently maneuver around Excel
  • Understand how to use any predefined functions
  • Feel confident when printing large spreadsheets
Examples of people who will benefit greatly from this class:

  • Those seeking to feel comfortable with most Excel office tasks
  • Those looking to interview for positions that require up to an intermediate level of Excel

Materials

  • Detailed reference sheet of everything covered
  • Multiple XLS and XLT examples for in class and after class
  • Shortcut sheet
  • Resource sheet

Course Outline

Lesson 1-Introduction: Navigation and Entering Data
Excel’s Purpose
Saving Files
The Excel Application Workspace
Getting Familiar with Your Workspace
Changing the Default Options
Always Showing Full Menus
Adding/Removing Toolbars
Moving Toolbars
Navigating Within a Workshet
Navigating Between Worksheets
Selecting Range of Cells
Entering Data
Editng Data
Deleting Data
Moving and Copying Data using the Mouse
Moving and Copying Data Using Cut, Copy and Paste
Paste Special Options
Data Series and The AutoFill Handle
Using Auto-fill

Lesson 2-Creating Content
Creating formulas
Common Operators
Using Functions
Using Relative and Absolute Cell Addressing
Creating 3-D Formulas (optional)

Lesson 3-Formatting
Fonts, Font Sizes, Font Styles, and Font Colors
Alignment
Indenting text
Sizing Rows and Columns
Wrapping Text in a Cell
Centering Text across cells
Formatting Values
Borders
The Format Painter
Conditional Formats

Lesson 4- Databases
Sorting
Forms
Adding and Autofilter
Subtotals

Lesson 5-Printing &Workbook Management
Controlling Output: The page setup Command
Force a Page Break
Workbook Management
Viewing Data and Worksheet Management

Lesson 6-Charts
Creating a Chart
Parts of the Chart
Modifying a Chart
Common Changes
Using Pie Charts
Adding a Secondary Value Axis (optional)
Adding Trendlines (optional)

Download PDF

© New York Interactive Media 2009

NYC Training CPE CreditsAll NYIM Classes are approved for CPE CreditS IN ALl STates
NYIM, LLC is registered with the National Association of State Boards of Accountancy (NASBA), as a sponsor of continuing professional education on the National Registry of CPE Sponsors. State boards of accountancy have final authority on the acceptance of individual courses for CPE credit. Complaints regarding registered sponsors may be addressed to the National Registry of CPE Sponsors, 150 Fourth Avenue North, Suite 700, Nashville, TN, 37219-2417 www.nasba.org

Hourly Private Training Rates
# of
People
Fundamentals to Intermediate Computing
Regular Rate Special Rate
1 $125 $80
2 $150 $120
3 $175 $140
4-7 $200 $160
8-12 $275 $220
13-18 $350 $280
18+ Please contact us for quote  

*Please contact us for groups of 4 or more

SPECIALS

$135 Excel or
PowerPoint for Business
Blowout! (Normally $280)

15% off all Web Design
Classes

(book before 9/15)

Current Sales Packages

Partial Client List   More »

American Express • dELiA*s • Deloitte & Touche USA LLP • Executive Office of The President of the United States • Fitch Ratings • HBO • HSBC Bank • Major League Baseball • Marks, Paneth & Shron • Maxim Magazine • McGraw – Hill • Microsoft • Morgan Stanley • Motorola Inc. • MTV Networks • Salomon Brothers • Scholastic • Starbucks Coffee Company • T-Mobile • Corcoran Group • New York Post • Village Voice • Toyota • Victoria's Secret •

Main Training Facility
One Union Square West, Suite 903
New York, NY 10003

Private and Group Hands-on Computer Training Classes in New York City

Excel Courses in New York | Powerpoint Classes NYC | Photoshop Classes NYC | Dreamweaver Classes NYC | InDesign Classes NYC | Flash Classes NYC | QuickBooks Classes NYC | SPSS Classes NYC | Access NYC Classes | VBA Training NYC | SiteMap

Information and Booking
(718) 795-3608
faye@newyorkinteractivemedia.com