Excel 2007 For Business in New York City

Excel 2007 For Business
Price: $ 135	Total Hrs: 7
	View Outline
09-17-2010 - SIGN UP Days: Fri 9/17 Time: 10AM-5PM
10-04-2010 - SIGN UP Days: Mon 10/04 Time: 10AM-5PM
10-19-2010 - SIGN UP Evenings: Tues 10/19, Wed 10/20 Time: 5:45PM-8:45PM
11-08-2010 - SIGN UP Days: Mon 11/08 Time: 10AM-5PM
11-21-2010 - SIGN UP Weekend: Sun 11/21 Time: 10:30AM-5:30PM
12-01-2010 - SIGN UP Days: Wed 12/01 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 What you can do with Excel Cell and Row structure Creating an efficient Excel workspace Quickly entering data using Auto-fill Auto-entries Moving Data Paste Special Lesson 2 Creating formulas manually Creating formulas using paste functions and auto functions SUM, AVERAGE, COUNT, MINIMUM, MAXIMUM, STANDARD DEVIATION 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 Alignment Size Direction Format types Borders 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 Auto-filtering Sorting the database Subtotals 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 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
# of People	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

Excel 2007 For Business

Excel For Business

Course Outline