Here's $10 towards your first class. Join for free

Discover Classes. Earn Rewards.

Excel for Business Level 1 (for PC)

N.Y.I.M. Training »
Price:
$199
2 seats left
Start date: Wed, Aug 31 6:00pm - 9:00pm (2 sessions)
Next start dates (19)
Wed, Aug 31: 6:00pm - 09:00pm
Thu, Sep 01: 6:00pm - 09:00pm
Location: Union Square, Manhattan
One Union Square West Ste 805
At E 14th St
New York, New York 10003 (Map)
Important:

No Booking Fees!

Saved 106 Times

Class Information

  • Class Level: Beginner
  • Age Requirements: 18 and older
  • Average Class Size: 10
  • Teacher: Michael M.

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. By the end of the Excel training course, you will feel confident managing Excel lists, databases, charts, common formulas, formatting, shortcuts and printing. 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 class is relevant to Excel 2007, Excel 2010 and Excel 2013 for PC.

Course Outline:

Lesson 1

  • What you can do with ExcelCell 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 
We do not accept students under 18 years old. We are an adult training facility only. 

School Notes: Enrollments for students signing up through CourseHorse are NOT confirmed until students receive an email confirmation from N.Y.I.M. Training.

Refund & Cancellation Policy

  • Cancellations more than 7 business days before the start of class, no charge/cancellation fee will apply and the student is eligible for a 100% refund or reschedule.

  • 4-7 business days before the start of class, 20% cancellation fee will apply (for both refund and reschedule requests).

  • 1-3 business days before the start of class, 50% cancellation fee will apply (for both refund and reschedule requests).

  • Less than 1 business day before the start of class, no refunds given or rescheduling permitted.

Start Dates (20)

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

Teacher:
Michael M.

Schedule:
Wed, Aug 31 6:00pm - 9:00pm
Thu, Sep 01 6:00pm - 9:00pm

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

Notes:

Map

Google Map
N.Y.I.M. Training
Union Square, Manhattan
One Union Square West Ste 805
At E 14th St
New York, New York 10003

All classes at this location

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!

Questions about this class?

Get help now from a knowledgeable expert!

Reviews of Classes at N.Y.I.M. Training

(344 Reviews)

7/23/2016
Brittany L.

Attended: Excel for Business Level 1 (for PC)

Brittany L. gave this class 4 out of 5 CourseHorse stars.

6/16/2016
Danielle D.

Attended: Excel for Business Level 1 (for PC)

Danielle D. gave this class 3 out of 5 CourseHorse stars.

6/15/2016
Joshua D.

Attended: Excel for Business Level 1 (for PC)

Joshua D. gave this class 5 out of 5 CourseHorse stars.

6/15/2016
Anonymous

Attended: Excel for Business Level 1 (for PC)

Anonymous gave this class 4 out of 5 CourseHorse stars.

6/14/2016
Jessica H.

Attended: Excel for Business Level 1 (for PC)

Jessica H. gave this class 5 out of 5 CourseHorse stars.

See 36 More Course Reviews
See reviews for other classes at N.Y.I.M. Training
Hide Reviews

School: N.Y.I.M. Training

Whatever 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 N.Y.I.M. Training »

CourseHorse Approved School

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

Ready to take this class?

Book Online

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

Need help finding a class? Contact us!
Need help? Contact us!