Discover Classes. Earn Rewards.

Intermediate Microsoft Excel 2016

at NYC Career Centers - Midtown

(615)
Course Details
Price:
$209 10 seats left
Start Date:

Mon, Jun 24, 10:00am - 5:00pm

Next start dates (30)

Location:
Midtown, Manhattan
185 Madison Ave Ste 1104
At E 34th St
New York, New York 10016
(Map)
Share:
Purchase Options
Description
Class Level: Intermediate
Age Requirements: 18 and older
Average Class Size: 7

What you'll learn in this excel class:

Intermediate Microsoft Excel 2016 Class Overview

The intermediate Excel class focuses on more advanced functions (including VLOOKUP, COUNTIFS and SUMIFs), Sort & Filter, and Pivot Tables. You'll also learn crucial text-related features like splitting and joining text, removing duplicates, and data validation. Embedded in the course are pivotal time-saving tricks like Paste Special, keyboard shortcuts, and navigation techniques.

  • Video Suite: The course includes a revolutionary Excel video suite, a $95 value, at no additional charge. Review the course materials on high-quality video on phone, tablet or desktop with lifetime access to this unique perk.
  • Free Retake: Retake the class for free once within six months (provided the class is running with an available seat).
  • Hands-on Training: Our intermediate Excel class is hands-on and uses real-world examples throughout the training. The instructor will first explain the concept along with a example, and then you'll perform an exercise on your own.
  • Training Manual Included: Our step-by-step training manual is the perfect reference guide for during and after the class.
  • Computer Provided: We provide you with a computer with Excel so you can travel light

Upon successful completion of this course, students will be able to:

  • Navigate Worksheet with Keyboard Shortcuts
  • Create Dropdown Menus
  • Analyze Data
  • Use Logical Functions
  • Use Statistical Functions
  • Analyze Data with PivotTables

Intermediate Microsoft Excel 2016 Class Outline

Lesson 1: Worksheet Management

  • Navigation
  • Paste Special

Lesson 2: Text

  • Splitting Text
  • Joining Text

Lesson 3: Database Management

  • Named Ranges
  • Data Validation
  • Sort & Filter
  • Remove Duplicates

Lesson 4: Database Functions

  • Vlookup
  • Hlookup
  • Vlookup - Closest Match

Lesson 5: Logical Functions

  • True, False, Not
  • And, Or
  • IF statements

Lesson 6: Statistical Functions

  • Rank.eq
  • Countifs
  • Sumifs

Lesson 7: Pivot Tables

  • Table review
  • Pivot Tables
  • Pivot Tables & Grouping
  • Multiple Pivot Tables

End of Class Project

  • Project

Still have questions? Ask the community.

Refund Policy
  • Registration Fee: All courses include a non-refundable registration fee of 10%.
  • Cancellations: Students may cancel up to seven business days prior to the course and receive all monies paid, less the non-refundable registration fee. Cancellation requests within the policy should be made directly to CourseHorse.
  • Rescheduling: Students may reschedule once up to three business days prior to the start date of the course at no charge. Reschedules within three business days incur a $20 rescheduling fee. Reschedule requests should be emailed to [email protected]

Map

Google Map

NYC Career Centers

All classes at this location

We are located in New York City on 34th street and Madison Avenue, a few blocks from Penn Station, Port Authority and Times Square.

Start Dates (31)
Start Date Time Teacher # Sessions Price
10:00am - 5:00pm TBD 1 $209
10:00am - 5:00pm TBD 1 $209
10:00am - 5:00pm TBD 1 $209
10:00am - 5:00pm TBD 1 $209
6:00pm - 9:00pm TBD 2 $209
This course consists of multiple sessions, view schedule for sessions.
Tue, Jul 09 6:00pm - 9:00pm TBD
Start Date Time Teacher # Sessions Price
10:00am - 5:00pm TBD 1 $209
10:00am - 5:00pm TBD 1 $209
10:00am - 5:00pm TBD 1 $209
10:00am - 5:00pm TBD 1 $209
10:00am - 5:00pm TBD 1 $209
Start Date Time Teacher # Sessions Price
10:00am - 5:00pm TBD 1 $209
6:00pm - 9:00pm TBD 2 $209
This course consists of multiple sessions, view schedule for sessions.
Thu, Aug 01 6:00pm - 9:00pm TBD
10:00am - 5:00pm TBD 1 $209
10:00am - 5:00pm TBD 1 $209
10:00am - 5:00pm TBD 1 $209
Start Date Time Teacher # Sessions Price
6:00pm - 9:00pm TBD 2 $209
This course consists of multiple sessions, view schedule for sessions.
Tue, Aug 13 6:00pm - 9:00pm TBD
10:00am - 5:00pm TBD 1 $209
10:00am - 5:00pm TBD 1 $209
10:00am - 5:00pm TBD 1 $209
10:00am - 5:00pm TBD 1 $209
Start Date Time Teacher # Sessions Price
6:00pm - 9:00pm TBD 2 $209
This course consists of multiple sessions, view schedule for sessions.
Thu, Aug 29 6:00pm - 9:00pm TBD
10:00am - 5:00pm TBD 1 $209
10:00am - 5:00pm TBD 1 $209
10:00am - 5:00pm TBD 1 $209
6:00pm - 9:00pm TBD 2 $209
This course consists of multiple sessions, view schedule for sessions.
Tue, Sep 10 6:00pm - 9:00pm TBD
Start Date Time Teacher # Sessions Price
10:00am - 5:00pm TBD 1 $209
10:00am - 5:00pm TBD 1 $209
10:00am - 5:00pm TBD 1 $209
10:00am - 5:00pm TBD 1 $209
6:00pm - 9:00pm TBD 2 $209
This course consists of multiple sessions, view schedule for sessions.
Thu, Sep 26 6:00pm - 9:00pm TBD
Start Date Time Teacher # Sessions Price
10:00am - 5:00pm TBD 1 $209

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 2090 points. Points give you money off your next class!
Questions about this class?
Get help now from a knowledge expert!
Questions & Answers (6)

Get quick answers from CourseHorse and past students.

Question from Anonymous
Is the Excel class scheduled for 11/7 from 6-9 noted as 2 sessions all on the same evening?
Answer from Brenda L. CourseHorse StaffCourseHorse Staff
Yes, the Intermediate Microsoft Excel 2016 sessions are both in the evening, 6 pm - 9 pm.
Answer
Cancel
Question from Assel T.
Hi, do you get the certificate after completing the course? Thanks.
Answer from Brenda L. CourseHorse StaffCourseHorse Staff
Hi Assel! Yes, a certificate of completion is provided for students.
Answer
Cancel
Question from Anonymous
Is there a handout or workbook you can keep for reference?
Answer from Kristle C. CourseHorse StaffCourseHorse Staff
Hi there! A step-by-step training manual will be provided and its the perfect reference guide for during and after the class. Hope that helps!
Answer
Cancel
Question from Keisha C.
Hi, Does this course include VLookup?
Answer from Jenn C. CourseHorse StaffCourseHorse Staff
Hi! Yes, the Vlookup function will be discussed in this course most especially in Lesson 1: Working with Functions (where ranges, specialized functions, logical functions and such will be covered). You will find more details about the topics to be covered in this course on the class description page.
Answer
Cancel
Question from Rochelle F.
Will I need to bring my own laptop?
Answer from Jenn C. CourseHorse StaffCourseHorse Staff
Hi! No need to bring your own laptop as all of the school's classes are offered on PCs, although, we do not have any Macs in our classrooms.
Answer
Cancel
Question from Nayantara R.
Hello! Will computers be provided or will students need to bring their own? Thanks!
Answer from Andrea P. CourseHorse StaffCourseHorse Staff
Hi, Nayantara! Computers are provided with the software necessary for the course.
Answer
Cancel
View all 6 questions

Reviews of Classes at NYC Career Centers (597)

(597 Reviews)
Intermediate Microsoft Excel 2016
Reviewed by Vivian L. on 5/6/2019
There were way too many topics to go over in 7 hours. The teacher skimmed over each topic then before I could grasp the topic we are already onto the next. It was a total blur and although the materials will be useful the class seemed like a quick review. I would have rather taken this class in parts.
Intermediate Microsoft Excel 2016
Reviewed by Katie T. on 4/8/2019
Instructor and materials were well paced and right to the point.
Intermediate Microsoft Excel 2016
Reviewed by Lily T. on 1/11/2019
I really enjoyed and learned so much! Looking to take the next class!
Intermediate Microsoft Excel 2016
Reviewed by Ghizela S. on 8/5/2018
Michael was a wonderful teacher, so patience with all my questions. This class is very good for people who wants to improve their skills in Excel. Computers are provided, which is very good and convenient. I have been to General Assembly and was a waist of time. Here people will go above and beyond to explain and teach you all their knowledge. Thank you Michael.
Intermediate Microsoft Excel 2016
Reviewed by Mariana S. on 7/31/2018
Instructor was super knowledgable. But, would have liked more time to practice the excel formulas.
loading...
loading...
Similar Classes

School: NYC Career Centers

NYC Career Centers

Career Centers
Since 1988, Career Centers has been a leader in software training courses for individuals and businesses, including Microsoft Excel, VBA, PowerPoint, SQL Server, Adobe Photoshop, InDesign, Illustrator, and AutoCAD. Our courses are instructor-led...

Read more about NYC Career Centers

CourseHorse Approved

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

Ready to take this class?
BOOK NOW
Taking this class for work? Get exclusive perks & discounts for free.
Loading...