Intermediate Microsoft Excel is unfortunately unavailable

Thankfully we have 74 other Excel Classes for you to choose from. Check our top choices below or see all classes for more options.

Class Tags:
Questions about this class?
Get help now from a knowledge expert!
Course Details
Price:
$219
Start Date:

This class isn't on the schedule at the moment, but save it to your Wish List to find out when it comes back!
If you're enrolled in an upcoming date, this simply means that date has now sold out.

Purchase Options
Save to WishList

207 people saved this class

Book Private Class
Description
Class Level: Intermediate
Age Requirements: 18 and older
Average Class Size: 7
System Requirements: Any Mac or PC with Microsoft Excel.
Class Delivery: Zoom

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]
Start Dates (0)

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

Similar Classes

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 (673)

(673 Reviews)
Intermediate Microsoft Excel
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
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
Reviewed by Katie T. on 4/8/2019
Instructor and materials were well paced and right to the point.
Intermediate Microsoft Excel
Reviewed by Lily T. on 1/11/2019
I really enjoyed and learned so much! Looking to take the next class!
Intermediate Microsoft Excel
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...

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 Online educator.

Want to take this class?

Save to Wish List
Booking this class for a group? Find great private group events here

74 Top Choices

Excel Bootcamp

This class is temporarily being offered remotely.

at General Assembly - Online Online Class
Livestream, New York, New York 00000

The bootcamp is designed to provide students with a general overview of Excel topics and specifically more knowledge of several different functions. It combines most of the material from the two workshops into an intense one-day session. Given the short timeframe and large amount of topics covered, students are expected to be able to learn quickly....

Friday Mar 12th, 11am - 5pm Eastern Time

Excel Bootcamp

This class is temporarily being offered remotely.

at General Assembly - Online Online Class Livestream, Online, Massachusetts 00000

If you know the basics of Microsoft Excel and want to take your knowledge to the next level, then this hands-on bootcamp is for you. Whether you are in business, management, or simply interested in getting more organized, this Excel bootcamp will cover the tools and functions you need to automate or enhance the way you analyze and restructure your...

Thursday Mar 11th, 11am - 5pm Eastern Time

Excel at Excel: Getting Down the Basics

This class is temporarily being offered remotely.

at General Assembly - Online Online Class
Livestream, New York, New York 00000

The Excel at Excel workshop is designed for students who are relatively familiar with other office productivity software, for example, Microsoft Word. (The students who succeed the most are comfortable using a computer and navigating around desktop programs on their own). It introduces a range of Excel topics giving students a taste of the potential...

Sunday Mar 28th, 12pm - 3pm Eastern Time

Excel at Excel: Getting Down to the Basics

This class is temporarily being offered remotely.

at General Assembly - Online Online Classroom, Los Angeles, California 00000

The Excel at Excel workshop is designed for students who are relatively familiar with other office productivity software, for example Microsoft Word. (The students who succeed the most are comfortable using a computer and navigating around desktop programs on their own). It introduces a range of Excel topics giving students a taste of the potential...

Sunday Mar 28th, 9am - 12pm Pacific Time

Virtual Excel Beginning Class

This class is temporarily being offered remotely.

at Computers Etc Software Training Center - Online

Build formulas to add, subtract, multiply, divide, average, and figure percentages. Create different spreadsheets from scratch, learn many tips and shortcuts, as well as Charts. What you will learn: Create Formulas that add, subtract, multiply divide, etc: Learn how to create Formulas that add, subtract, multiply, and divide numbers, calculate...

Tuesday Mar 9th, 9am - 4pm Pacific Time

Data Literacy

This class is temporarily being offered remotely.

at New York City College of Technology - Online Virtual Learning, New York, New York 00000

This course is designed to provide students with a basic to mature ability to collect, enter, and perform calculations with data in MS-EXCEL spreadsheets, and to utilize basic statistical techniques to analyze and present the data in words, graphs and charts. These skills will be useful in securing entry level IT positions in industry. Key topics...

Tuesday Mar 9th, 6pm - 9pm Eastern Time

  (22 sessions)
$700

22 sessions

Excel 2016 for Windows

This class is temporarily being offered remotely.

at West Los Angeles College - Online Online via Zoom, Los Angeles, California 00000

This class will be held remotely through live videoconferencing. Excel 2016, the most popular spreadsheet program, has powerful features that allow you to analyze and manipulate financial and mathematical data. It’s great for budgets, simple bookkeeping, an easy database, or making charts and graphs.  In this hands-on beginning class, you’ll...

Tuesday Mar 9th, 7pm - 10pm Pacific Time

  (2 sessions)
$125

2 sessions

Excel Dashboards for Interactive Reporting - Online

This class is temporarily being offered remotely.

at Colorado Free University - Online 00000

A dashboard is a single screen used for reporting that displays charts, tables, and other visual data components on a related subject. Learn how to create Dashboards that will transform business data into actionable information. You will: Create an interactive, dynamic information source within Excel without creating a monster workbook or submitting...

Wednesday Mar 10th, 9am - 4pm Mountain Time

Excel PivotTables: Data Summarization and Analysis

This class is temporarily being offered remotely.

at Accelerate Computer Training - Long Beach 200 Pine Ave Ste 280, Long Beach, California 90802

A PivotTable is Excel's most powerful data summarization tool. In this three-hour session for Windows and Mac users, you will learn what kinds of data works best for PivotTables and how to prepare your data. You will create PivotTables based on various data sources, summarize data by multiple categories using sum, average and count, format the PivotTable,...

Monday Mar 15th, 9am - 12pm Pacific Time

Excel Bootcamp

This class is temporarily being offered remotely.

at General Assembly - Online Online Class, Houston, Texas 00000

If you know the basics of Microsoft Excel and want to take your knowledge to the next level, then this hands-on bootcamp is for you. Whether you are in business, management, or simply interested in getting more organized, this Excel bootcamp will cover the tools and functions you need to automate or enhance the way you analyze and restructure your...

Thursday Mar 11th, 10am - 4pm Central Time

Online Excel Genius 2: Conditional Stat Functions

This class is temporarily being offered remotely.

at The New York Public Library (Tech) - NYPL Online Classroom

This class covers how to take the basic logic from Class 1 and use it to create functions that process data based on conditions. Topics include SUMIF/AVERAGEIF/COUNTIF and SUMIFS/AVERAGEIFS/COUNTIFS. Skills required: Be able to write a basic formula and function Be able to write Relative and Absolute cell references Have Taken Class 1 or understand...

Thursday Mar 11th, 10:30am - 12:30pm Eastern Time

Free

Excel Bootcamp

This class is temporarily being offered remotely.

at General Assembly - Online Online Class Livestream, Atlanta, Georgia 00000

If you know the basics of Microsoft Excel and want to take your knowledge to the next level, then this hands-on bootcamp is for you. Whether you are in business, management, or simply interested in getting more organized, this Excel bootcamp will cover the tools and functions you need to automate or enhance the way you analyze and restructure your...

Thursday Mar 11th, 11am - 5pm Eastern Time

Advanced Excel Training

This class is temporarily being offered remotely.

at General Assembly - Online Online Class
Livestream, New York, New York 00000

Virtually everyone who works with data could benefit by gaining a better understanding of Microsoft Excel. This class will extend beyond the simple addition of data and will put participants in a position where Excel is no longer a chore, but a powerful tool to assist in manipulating data efficiently. You’ll learn various functions to help you organize...

Saturday Mar 20th, 12pm - 3pm Eastern Time

Excel Bootcamp

This class is temporarily being offered remotely.

at General Assembly - Online Remote Online, Online, California 00000

If you know the basics of Microsoft Excel and want to take your knowledge to the next level, then this hands-on bootcamp is for you. Whether you are in business, management, or simply interested in getting more organized, this Excel bootcamp will cover the tools and functions you need to automate or enhance the way you analyze and restructure your...

Thursday Mar 11th, 8am - 2pm Pacific Time

Excel Bootcamp

This class is temporarily being offered remotely.

at General Assembly - Online Online Class, Seattle, Washington 00000

If you know the basics of Microsoft Excel and want to take your knowledge to the next level, then this hands-on bootcamp is for you. Whether you are in business, management, or simply interested in getting more organized, this Excel bootcamp will cover the tools and functions you need to automate or enhance the way you analyze and restructure your...

Thursday Mar 11th, 8am - 2pm Pacific Time

Excel Bootcamp

This class is temporarily being offered remotely.

at General Assembly - Online Online Class Livestream, San Francisco, California 00000

If you know the basics of Microsoft Excel and want to take your knowledge to the next level, then this hands-on bootcamp is for you. Whether you are in business, management, or simply interested in getting more organized, this Excel bootcamp will cover the tools and functions you need to automate or enhance the way you analyze and restructure your...

Thursday Mar 11th, 8am - 2pm Pacific Time

Excel Bootcamp (Online)

This class is temporarily being offered remotely.

at General Assembly - Online Online Classroom, Los Angeles, California 00000

If you know the basics of Microsoft Excel and want to take your knowledge to the next level, then this hands-on bootcamp is for you. Whether you are in business, management, or simply interested in getting more organized, this Excel bootcamp will cover the tools and functions you need to automate or enhance the way you analyze and restructure your...

Thursday Mar 11th, 8am - 2pm Pacific Time

Excel Advanced (Online)

This class is temporarily being offered remotely.

at Computer Training Source, Inc. - Virtual Classroom

Learn advanced formulas, VLOOKUP, IF functions, data validation, database functions, formulas with dates, macros & more! Course Outline: Unit 1: Logical and statistical functions Topic A: Logical functions (IF, OR, AND, NOT, IFERROR) Topic B: Math and statistical functions (SUMIF, COUNTIF, AVERAGEIF, ROUND) Unit 2: Financial and date functions...

Friday Mar 12th, 9am - 4pm Central Time

Microsoft Excel 2016: Level 1 (Online)

This class is temporarily being offered remotely.

at Colorado Free University - Online 00000

Analyze, manage, and share data of all kinds, from personal and professional budgeting to scheduling. The Level 1 class provides all the basics for creating and editing spreadsheets and workbooks and performing simple calculations. Students must have MS Office Excel software installed on their computer to participate in class. Target Student: This...

Friday Mar 12th, 9am - 4pm Mountain Time

Excel Bootcamp

This class is temporarily being offered remotely.

at General Assembly - Online Online Class Livestream, Chicago, Illinois 00000

If you know the basics of Microsoft Excel and want to take your knowledge to the next level, then this hands-on bootcamp is for you. Whether you are in business, management, or simply interested in getting more organized, this Excel bootcamp will cover the tools and functions you need to automate or enhance the way you analyze and restructure your...

Thursday Mar 11th, 10am - 4pm Central Time