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
|
All 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