Discover Classes. Earn Rewards.

Excel 2007-2010

NYIM Training »
Price:
$199
5 seats left
Start date: Wed, Nov 26 9:00am - 4:00pm
Other start dates (2)
Location: Union Square
One Union Square West Suite 805
(At E 14th St)
New York, New York 10003
(Map)
Important:

No Booking Fees!
Call us: 212-729-4088

Saved 30 Times

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 1990 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 class:

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 

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.

Teacher: Karen M.

See Classes Taught by This Teacher »

Karen is Microsoft Office certified. She is known for making people laugh, making them feel comfortable, bringing students together and delivering practical content that will not be forgotten. Her personality is large, warm and friendly. Her Microsoft Office Specialist Master Certification assures an expert level in all of the Microsoft Office products. She has taught many clients from the private sector, public sectors and students at the college level. Her curriculum repertoire includes MS Word, Excel, PowerPoint, Outlook, Access and the Internet.

Start Dates (2)

Start Date # of Sessions Price
1 $199 Book
1 $199 Book

Notes:

Teacher:
Karen M.

Schedule:
Wed, Nov 26 9:00am - 4:00pm

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

Map

This class isn't on the schedule at the moment, but save it to your Wish List to find out when it comes back!

Save to Wish List

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

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 instructors...

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

(41 Reviews)


Attended: Access Essentials

Maria R. gave this class 4 out of 5 CourseHorse stars.


Attended: Quickbooks 2013 Level 1 for PC

Vikram Y. gave this class 2 out of 5 CourseHorse stars.


Attended: Excel 2010 level 1

The course was very informational, and the teacher was great.


Attended: Powerpoint 2011 For Mac

Lynn L. gave this class 5 out of 5 CourseHorse stars.


Attended: Photoshop Essentials

Lea M. gave this class 5 out of 5 CourseHorse stars.


Attended: Photoshop Essentials

Renske G. gave this class 4 out of 5 CourseHorse stars.


Attended: Illustrator for Fashion: Level 1

Lina X. gave this class 3 out of 5 CourseHorse stars.


Attended: Photoshop Essentials

Very good class, knowladgable teacher, great instructions. Computers not working perfectly though.


Attended: Photoshop Essentials

Eugenio is a great teacher who is super smart and engaged The NYIM facilities are nice and clean, and there is a helpful front desk. There were a few technical glitches with certain people's computers, but for the most part it was fixed pretty promptly.


Attended: Excel 2010 level 1

Karen was great! She was a great instructor and was detailed.


Attended: Quickbooks 2013 Level 1 for Mac

Donna D. gave this class 4 out of 5 CourseHorse stars.


Attended: Excel 2011 for Mac

Samantha K. gave this class 4 out of 5 CourseHorse stars.


Attended: InDesign Essentials

Isabelle R. gave this class 5 out of 5 CourseHorse stars.


Attended: Photoshop Essentials

Anonymous gave this class 4 out of 5 CourseHorse stars.


Attended: Excel Power Programming with VBA Phase 1

Paige R. gave this class 4 out of 5 CourseHorse stars.


Attended: Illustrator Essentials

Great course! Eugene is a great teacher and all his experience is a plus when you have questions. Faye also was very helpful!


Attended: Illustrator Essentials

Excellent teacher who adapted perfectly to the comfort level of his students. Highly recommend!


Attended: Photoshop Advanced Realistic Photomontage & Ad Creation

Jon R. gave this class 5 out of 5 CourseHorse stars.


Attended: Powerpivot Fundamentals

Class was very well run, with friendly, accessible, clear instruction. From the class description I was expecting to have more general Excel overview included, which would have been helpful, as the level of data being used for the class examples was quiet high. But even without that, the information was still manageable even for unexperienced Excel users like myself.


Attended: Powerpivot Fundamentals

This class was great, but my only feedback would be that I don't think it's accurate in the description to say: 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. This was a much more advanced class than beginner excel level. The examples and formulas were complicated. But overall I learned a lot and I liked the format and the manual is very helpful. Thank you!


Attended: Advanced Excel 2007-2010

Kenny Ng gave this class 5 out of 5 CourseHorse stars.


Attended: Excel 2010 level 1

Kristin Davis gave this class 4 out of 5 CourseHorse stars.


Attended: Quickbooks 2013 Level 1 for Mac

alina gabay gave this class 5 out of 5 CourseHorse stars.


Attended: Excel 2011 for Mac

Debby Connors gave this class 5 out of 5 CourseHorse stars.


Attended: Quickbooks Online Level 1

Small class, lots of individualized instruction. Paul was very knowledgeable & clear in instruction. I feel confident I can set up and maintain basic quick books for my small business.


Attended: Excel 2007-2010

Nice class, good practice for basic Excel


Attended: How to Create a Dynamic Website or Blog with WordPress

Jenny Seo gave this class 4 out of 5 CourseHorse stars.


Attended: How to Create a Dynamic Website or Blog with WordPress

This class was an excellent and thorough introduction to Wordpress. The class moved at the perfect pace and was easy to follow, but also very informative and hands-on.


Attended: Illustrator for Fashion: Level 1

I thought this class was great. Only 5 sessions in which to learn a lot, but instructor Mikelle was incredibly knowledgeable and paced the classes evenly. She was also available by email to answer questions outside of class. Bonus that she brought current, real world experience to her instruction abilities. Grateful to have taken the class with her. Also, head client manager Faye was so helpful and cheerful the whole way through! 5 stars for NYIM and this class.


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

Barbara Gyde 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.


Attended: How to Create a Dynamic Website or Blog with WordPress

I erroneously assumed that given the cost and length of this class, it would be well worth the investment. The room was uncomfortably hot and the instruction was dry and not as helpful as expected. At the end of the day, I walked out with minimal understanding of Wordpress and a hefty manual to study on my own. The organization offers the opportunity to return for the same class, but who wants to risk yet another disappointing day?


Attended: Quickbooks 2013 Level 1 for Mac

This was a VERY helpful class. Paul was a great teacher and went over everything you need to function for Quickbooks 2013 for Mac. I highly recommend this class!


Attended: Outlook Efficiency Techniques 2007-2010

What a fun way to learn! Karen incorporated laughter into the curriculum and helped me unleash my skills. Can't wait to take it again. Thanks!


Attended: Photoshop Essentials

This was really nice boot camp to me. I learned a lot of basic menu and concept of photoshoto, which were much more than I originally expected. The course had just a few people and I could ask any kind of questions and the pace of learing is pretty confortable. recommended!


Attended: Excel 2011 for Mac

Fabulous excel class. Scott was a great teacher. I would like to sign up for the WORD class now. When are they offered? Also, I would like a certificate for the EXCEL class to prove that I took it. Thank you, Kate Kate Maitland


Attended: Advanced Excel 2007-2010

Excellent class and teacher


Attended: Photoshop Essentials

My class turned out to be great. I was the only student so I got a private lesson and we moved along at my pace. This turned out especially well since I knew some Photoshop before the class.

See 36 More Reviews Hide 36 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]
Customer Service: 212-729-4088