Price:
$199 $179.10
(1 session)
4 seats left
Session:
Tue, Jul 29
10:00am - 05:00pm
Location: Union Square
One Union Square West Suite 805
(At E 14th St)
New York, New York 10003
(Map)
Book Online

Need help booking?
Call us: 212-729-4088

Save to Wish List
Saved 28 Times

Give as a gift
Book a private event

Benefits of Booking through CourseHorse

  • Booking is safe. When you book with us your details are protected by a secure connection.
  • Lowest price guaranteed. Classes on CourseHorse are never marked up.
  • This class will earn you 1791 points. Points give you money off your next class!

Class Information

  • Class Level: Beginner
  • Age Requirements: 18 and older
  • Average Class Size: 10

What you'll learn in this excel training:

By the end of the Excel training course, you will feel confident managing Excel lists, databases, charts, common formulas, formatting, shortcuts and printing. 

The Excel for Business group class concentrates on the most common topics that we see in NYC businesses using on a daily basis. This Excel class is perfect for those who are new to Excel, have been using Excel without any training or need to gain a solid grasp of how to use it effectively.

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
Materials:
  • Custom printed Manual
  • Multiple XLS and XLT examples for in class and after class
  • Shortcut sheet
  • After class resources 

Interested in an On-Site Class or Custom Program from NYIM Training? Request info about private training

Teacher: Eddy C.

See Classes Taught by This Teacher »

Eddie comes with over 10 years in the Import- Export Industry, developing and supporting software application solutions, currently in use for complex calculations, involving Industry type Logistical Ocean Freight handling, Project cargoes, Intermodal, stevedoring, and warehousing all with the use of MS Office applications such as Excel, Access, VBA, built into an Industry made very efficient software application. In addition to the involvement of managerial/financial responsibilities, as to compile business progress into a computer generated reports, reflecting data affecting the profitability, and the accuracy of records/transactions involved on daily operations. Customers currently requesting such services, and assistance, to name a few: Discover Freight Forwarder and Container Innovations.

His experience has built a very capable and very resourceful reliable trainer, whose knowledge of MS Office has become a major asset. Eddie's experience puts practical knowledge into perspective and allows us to bring a deep knowledge to each training.

It is common for the participants in his trainings to walk out of class with a satisfied feeling of learning something useful as his experience, knowledge, diligence, and patience are valuable attributes. 

Eddie teaches the following for N.Y.I.M. Training: Excel, PowerPoint,Word, Outlook, Access, VBA, and QuickBooks.

Start Dates (1)

Start Date # of Sessions Price
1 $179.10 Book

Can't make these dates? Find out first about new class dates by saving it to your wish list or request info about private training.

Save to Wish List

Teacher:
Eddy C.

Schedule:
Tue, Jul 29 10:00am - 5:00pm

Location:
Union Square, Manhattan
One Union Square West
Suite 805
At E 14th St
New York, New York 10003

Map

Map

Google Map
NYIM Training
Union Square
One Union Square West
Suite 805
At E 14th St
New York, New York 10003

All classes at this location

Refund & Cancellation Policy

  • No charge for substituting students at any time.
  • No charge to reschedule or cancel before 5 business days of class. 
  • There is a $25 rescheduling, cancellation or retake rescheduling fee within 3-5 business days from the start of class. 
  • No refund or rescheduling permitted within 2 business days of start of class. No refund given for cancellations or "no-shows" within 2 business days from the start of class. 
  • If a retake is cancelled within 2 business days from the start of class, another retake may not be scheduled.

School: NYIM Training

What ever your needs, group or corporate, NYIM provides you with the most practical and efficient hands-on computer training in New York City since 1998. Conveniently located on Union Square, our staff are experienced professionals with 10+ years of training experience in their field. Each of our i...

Read more about NYIM Training »

CourseHorse Approved School

This school has been carefully vetted by CourseHorse and is a verified NYC educator.

Reviews of Classes at NYIM Training

(12 Reviews)


Attended: SPSS Essentials

My only suggestion would be that the instructor distribute something in writing to correspond with the basic points covered. It is pretty much impossible to take notes during the session because it is so fast moving. Very hard to retain any of the instructions. If he would distribute basic written instructions on what he covers, the student could come away with something that they could continue to work with after the course. For this reason the course is very overpriced for what you get from it.


Attended: Advanced PowerPoint 2007-2010

Anonymous gave this class 5 out of 5 CourseHorse stars.


Attended: Excel 2007-2010

Great teacher, and pace was excellent.


Attended: Excel 2013

I'm really happy with this class, I think it was well structured in terms of the assigned tasks and I was properly assisted by the teacher in each of the opportunities I demanded. This is a very useful course. Thanks


Attended: Advanced Excel Power Users 2010

I thought this class was a wonderful overview of ways to improve your efficiency in using excel and touched upon some Macros and match index examples at the end. The teacher was good and it was only me and one other person so we were able to ask a lot of questions.

See 7 More Reviews Hide 7 Reviews

Ready to take this class?

Book Online
Or call 212-729-4088

Taking this class for work? Get exclusive perks & discounts for free.

Need help finding a class? Call 212-729-4088 or email [email protected]