Here's $10 towards your first class. Join for free
Discover Classes. Earn Rewards.
Questions about this class?
Get help now from a knowledge expert!

Advanced Excel for Business Level 2 (for PC)

N.Y.I.M. Training

Price:
$199 6 seats left
Start Date:

Fri, Oct 21 10:00am - 5:00pm

Next start dates (8)

Location:
Union Square, Manhattan
One Union Square West Ste 805
At E 14th St
New York, New York 10003
(Map)
Share:
No Booking Fees Book Online Save to WishList

107 people saved this class

Give as a Gift
Class Level: Advanced
Age Requirements: 18 and older
Average Class Size: 10
Teacher: Michael M.

What you'll learn in this excel class:

The Advanced Excel for Business group class concentrates on the most common topics we see NYC businesses using on a daily basis. By the end of the Excel training course, you will feel confident in extracting data from large databases based on dynamic criteria, pull in data using Vlookups, save time by recording and replaying straight forward macros, quickly organize and analyze large amounts of raw data with Pivot Tables and Charts, and become much faster by using efficiency techniques, advanced formulas and collaborating tools. 

This Excel course is perfect for those who want to continue their Excel knowledge, 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 & Excel 2013 for PC.

Materials:
  • Custom Printed Manual
  • Multiple XLS and XLT examples for in class and after class
  • Shortcut sheets
  • After class resources
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
School Notes: Enrollments for students signing up through CourseHorse are NOT confirmed until students receive an email confirmation from N.Y.I.M. Training.
  • 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 (9)

Start Date # of Sessions Price Information
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
Save to WishList

Map

Google Map
N.Y.I.M. Training


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 knowledge expert!

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

(357 Reviews)
8/14/2016
Iryna D.

Attended: Advanced Excel for Business Level 2 (for PC)
This was my second class I took with NYIM through coursehorse and it was great. Karen, the instructor did a good job delivering the material. We also received take home handouts and an option to retake the class anytime you want. I will definitely be taking more courses with NYIM and already recommended it to my friends.

8/7/2016
Guillermo A.

Attended: Advanced Excel for Business Level 2 (for PC)
Karen is the best

6/29/2016
Brittany L.

Attended: Advanced Excel for Business Level 2 (for PC)
Brittany L. gave this class 5 out of 5 CourseHorse stars.

6/13/2016
Anonymous

Attended: Advanced Excel for Business Level 2 (for PC)
Anonymous gave this class 5 out of 5 CourseHorse stars.

5/15/2016
Rebecca F.

Attended: Advanced Excel for Business Level 2 (for PC)
Rebecca F. gave this class 5 out of 5 CourseHorse stars.

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

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. Learn More
Loading...