Basic Excel for Business 2007/2010

, "The most practical training in New York"

Class Type

  • "Free Retakes for Life!" of that version
  • Any Upgraded version of the class taken is offered at 75% off Original Price!
  • Manual to keep w/ access to student files
  • Access to Online Video Training Tutorials (NEW!)
  • Free forum support for after class
  • Mousepad with shortcuts to keep
  • Hands on, goal based
  • Small Classes of 4 to 9 people
  • Fast NEW computers! (Windows w/ 8GB of ram or MacBook Pros)
  • Comfortable chairs, convenient location
  • Patient, Fun, Experienced Trainer
  • We provide coffee, tea, water

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


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

Excel Training Course Outline

Lesson 1
What you can do with Excel
Cell and Row structure
Creating an efficient Excel workspace
Quickly entering data using Auto-fill
Moving Data
Paste Special
Lesson 2
Creating formulas manually
Creating formulas using paste functions and auto functions
Understanding how to use hundreds of predefined functions
Lesson 3
Absolute References and why they are crucial to you
Solo Project
Monthly global allocation
Lesson 4- Formatting
Format types
Cell width and height
Merging cells
Lesson 5- Advanced Formatting
Custom formatting
Conditional Formatting
Lesson 6- Charting
Quick and dirty charting when you are in a rush
Advanced data series charting
Chart types and when to use them
Controlling every aspect of chart formatting such as color, axis scales, 3-D views, etc
Lesson 7- Databases
How to properly set up an Excel Database to ensure accurate information
Sorting the database
Freezing Rows for easy viewing
Solo Project
Database creating and sorting
Lesson 8- Printing
Setting print area
Using the Page Break Preview
Page Orientation
Repeating heading rows
Adding headers and footers to your printing area
Controlling the annoying “blank pages” and the “stray column” printing problem
Printing areas that are not next to each other
Lesson 9
Where to find answers to more complex Excel problems
Books we have found helpful


-Must feel comfortable with basic computer skills. It is crucial that you understand how to save and retrieve files without trouble. -No Excel experience is needed.
  • Basic Excel for Business 2007/2010

    NYIM Training

    1 Union Square West Suite 903
    New York, NY

    Wed, August 8th, 2012

    9:00 am - 4:00 pm EDT

    Add to Cal

NYIM Training

"The most practical training in New York"

Anthony is Microsoft Office certified and has been a computer trainer since 1985. His Microsoft Office Specialist Master Certification assures an expert level in all of the Microsoft Office products. He has taught employees from the private and public sectors and students at the college level. His list of clients has included NBC, JP Morgan Chase, Martha Stewart Omnimedia Living, HUD, Income Tax department (Albany), Queensborough Community College and many others.

His curriculum repertoire includes MS Word, Excel, PowerPoint, Outlook, Access, Project

View Full Profile

--% Positive Reviews (0 Reviews)

This class hasn't been reviewed yet.

NYIM Training

1 Union Square West

New York, NY

1 / 9 Students

  • 7


  • 3


  • 30