NYIM Training Rated #1 in Excel Class Training in NYC, New York

Jan. 6, 2012 - PRLog -- NYIM Training offers the most complete EXCEL training in NYC, New York. We teach Excel 2003, Excel 2007, and Excel 2010 classes. Whether it's Excel for Business for administrative needs, Advanced Excel classes for the professional analyzing large amounts of data, or Excel for the Financial Industry, our Excel training will give you the skills you need to save time and money. We train at all levels of Excel: Basic, Advanced, Power Users and VBA. For more information, click on the Excel group class links below, or call 718.795.3608 or email us.


http://newyorkinteractivemedia.com/excel_courses_new_york_city.html


Basic Excel 2007/2010

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

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

# # #

NYIM provides the most practical Computer Training in Excel, PowerPoint, Photoshop, Quickbooks, Flash, Dreamweaver, Illustrator, SPSS, InDesign, AfterEffects, VBA, Fashion Industry training & many more