Advanced Excel 2003 for Business in New York City

Advanced Excel 2003 for Business
Price: $ 199	Total Hrs: 7
	View Outline
09-08-2010 - SIGN UP Days: Wed 9/08 Time: 10AM-5PM
09-15-2010 - SIGN UP Days: Wed 9/15 Time: 10AM-5PM
10-03-2010 - SIGN UP Weekend: Sun 10/3 Time: 10:30AM - 5:30PM
10-27-2010 - SIGN UP Days: Wed 10/27 Time: 10AM-5PM
11-30-2010 - SIGN UP Days: Tues 11/30 Time: 10AM-5PM
This schedule does not work for me. Please send me more options.

Advanced Excel For Business Class Type: Can retake the class, for free, up to 6 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: Extract data from large databases based on dynamic criteria Save time with recording and replaying straight forward macros Quickly organize and analyze large amounts of raw data with Pivot Tables and Charts Increase your Excel knowledge with efficiency techniques, advanced formulas and collaborating techniques. Examples of people who will benefit greatly from this class: Those working with databases Those who have been working with Excel and would like to cut out hours of work from their weekly tasks. Those looking to quickly analyze large amounts of data Materials Detailed reference sheet of everything covered Multiple XLS and XLT examples for in class and after class Shortcut sheet Resource sheet Prerequisites Those who have taken our "Excel for Business" Course or has equivalent knowledge. Please note, that you will not do well in this class if you are uncomfortable with less than 80% of or our Excel for Business class. You will generally need about 14- 16 hours of Excel class time from other training schools to compare with our Excel for Business class. Course Outline Lesson 1- Quick review Formula fundamentals Database fundamentals Lesson 2 Creating reusable drop down lists Naming ranges Validation Lesson 3 Extracting database information quickly Vlookups Hlookups Match formula- returning the position of a cell Index Formula- returning values at the intersection of a row and column. Combining the VLookup and Match formulas to create a modifiable database lookup. Combining and nesting the Index and Match Lesson 4 - Commonly used functions Commenting cells Protecting documents Saving workspace and multiple worksheets Saving documents as templates Sending spreadsheets for review Copying and pasting only unique records from a database list Lesson 5 If statement Using the If statement to sum and analyze Sum If Tracing Cell Precedents Today and Now functions to auto insert today's date and time upon opening a document Numbering databases that will be sorted with the ROWS() function Rounding numbers and currency up and down Goal Seek Lesson 6 - Pivot Tables Analyzing raw data with Pivot Tables Raw data dumps from external applications or databases Grouping by categories, months, days, quarters, etc Lesson 7 Pivot Charts Use the same data Lesson 8- Introduction to Macros Recording and Playing Macros Recording a Macro to prepare data from a data dump for use in Pivot Table Lesson 9 Where to find answers to more complex Excel problems for free Download PDF © NYIM 2010 Untitled Document Untitled Document

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

Advanced Excel 2003 for Business

Advanced Excel For Business

Course Outline