Intermediate Microsoft Excel 2016

at NYC Career Centers - Midtown

(681)
Course Details
Price:
$219 10 seats left
Start Date:

Fri, Jul 17, 10:00am - 5:00pm Eastern Time

Next start dates (8)

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

Flexible Reschedule Policy: This provider has flexible, free rescheduling for any-in person workshop. Please see the cancellation policy for more details

What you'll learn in this excel class:

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.

Operating System Note: A PC or Mac with Excel will be provided (choose your operating system at checkout). The instructor will present on a PC but will explain the differences for Mac students, and the class files clearly outline the differences.

Prerequisite
Attendees must have beginner Excel skills equivalent to our Beginner Microsoft Excel course, including basic functions and formulas, printing, formatting, basic charts, and tables.

What You'll Learn

  • Navigation tricks & shortcuts
  • Summarize data with Pivot Tables
  • VLOOKUP function
  • Join and split text
  • Create drop-down menus
  • Sort & filter data
  • Tricks to speed up workflow
  • Logical functions: IF, AND, OR

Please CLICK HERE for the Course Syllabus


Remote Learning

This course is available for "remote" learning and will be available to anyone with access to an internet device with a microphone (this includes most models of computers, tablets). Classes will take place with a "Live" instructor at the date/times listed below.

Upon registration, the instructor will send along additional information about how to log-on and participate in the class.

Still have questions? Ask the community.

Refund Policy

Note: This provider has a temporary cancellation policy for COVID-19 related cancellations which is as follows: 

We are allowing attendees to reschedule at no charge or keep class credit for up to two years. Email us at [email protected] 

---- 

Original cancellation policy (non-COVID-19):

  • 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 (9)
Start Date Time Teacher # Sessions Price
10:00am - 5:00pm Eastern Time TBD 1 $219
10:00am - 5:00pm Eastern Time TBD 1 $219
10:00am - 5:00pm Eastern Time TBD 1 $219
6:00pm - 9:00pm Eastern Time TBD 2 $219
This course consists of multiple sessions, view schedule for sessions.
Thu, Jul 30 6:00pm - 9:00pm Eastern Time TBD
10:00am - 5:00pm Eastern Time TBD 1 $219
Start Date Time Teacher # Sessions Price
10:00am - 5:00pm Eastern Time TBD 1 $219
10:00am - 5:00pm Eastern Time TBD 1 $219
6:00pm - 9:00pm Eastern Time TBD 2 $219
This course consists of multiple sessions, view schedule for sessions.
Thu, Aug 27 6:00pm - 9:00pm Eastern Time TBD
10:00am - 5:00pm Eastern Time TBD 1 $219

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

Get quick answers from CourseHorse and past students.

Question from Anonymous
Can you take this class using a Mac computer?
Answer from Nick S.
Yes, this class is available on a Mac computer. Once you receive an email confirmation, please reply back ask to be set up on a Mac
Answer
Cancel
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 7 questions

Reviews of Classes at NYC Career Centers (666)

(666 Reviews)
Intermediate Microsoft Excel 2016
Reviewed by Anonymous on 3/25/2020
The instructor Jeanette was great, very knowledgeable. The only thing I would have changed was that she was doing both online instructing and instructing us in the actual physical classroom. I would not have both happen at the same time. The students online kept asking questions that held us up on a few things, we didn't get to finish everything bc of that. If they would have been in the room that would have probably helped. Jeanette was patient and at times she had to let them know we needed to move on in order to keep up but will address them afterwards. Besides that, she walked us through as much of the course as she could.
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.
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
Booking this class for a group? Find great private group events here