Advanced Excel Training is unfortunately unavailable

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

Advanced Excel Training

at General Assembly - Flatiron

(2251)
Course Details
Price:
$99
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.

Location:
Flatiron, Manhattan
10 E 21st St 3rd Fl
Btwn Broadway & 5th Ave
New York, New York 10010
(Map)
Share:
Important:
A computer will not be provided
Purchase Options
Save to WishList

37 people saved this class

Book a private group event
Description
Class Level: Advanced
Age Requirements: 18 and older
Average Class Size: 20
Teacher: Vaughn Caldon

What you'll learn in this excel class:

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 and analyze data and go through situational overviews of time-saving shortcuts to improve your efficiency dramatically.

Takeaways
  • VLOOKUPS & HLOOKUPS
  • INDEX / MATCH
  • Pivot Tables and Charts
  • Record Macros
Preparation
A strong working knowledge of Excel is mandatory. Relative and absolute cell references, nested formulas, and functional understanding of Excel formatting. You do need a laptop w/ Excel loaded. (Google Sheets is an ok substitute, but not preferred)

School Notes:
For students enrolling in 12 week part time and immersive classes, it is not recommended that you book more than one class simultaneously.

Still have questions? Ask the community.

Refund Policy
If you can't make it to a class/workshop, please email us at [email protected] at least 7 days before the scheduled event date. No refunds will be given after this timeframe.

Map

Google Map

General Assembly

All classes at this location

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

Get quick answers from CourseHorse and past students.

Question from Norman H.
What versions of Excel does this class cover?
Answer from Brenda L. CourseHorse StaffCourseHorse Staff
This class will use the latest version of Excel. Also, the instructor may also use google sheets at certain points. Hope this is helpful.
Answer
Cancel

Reviews of Classes at General Assembly (2,236)

(2236 Reviews)
Advanced Excel Training
Reviewed by Anonymous on 2/13/2016
I thought the class was great and was incredibly impressed by the teacher. Class offers tools to empower spreadsheets and some tips and tricks for efficiency.
Advanced Excel Training
Reviewed by Jordana Gluck on 9/24/2014
Michaels teaching style was very good and j would like to see more classes offered by him!
loading...

School: General Assembly

General Assembly

General Assembly is a pioneer in education and career transformation, specializing in today’s most in-demand skills. The leading source for training, staffing, and career transitions, we foster a flourishing community of professionals pursuing careers they love.

What began as a co-working space in...

Read more about General Assembly

CourseHorse Approved

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

Want to take this class?

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

55 Top Choices

Excel for Business Fundamentals

at NYIM Training - Murray Hill 185 Madison Ave 11th Fl, New York, New York 10016

Excel for Business Fundamentals covers the essential applications of Excel used frequently by business professionals. In this introductory course, you will learn basic and multi-input functions, absolute references, charts and tables. We will help you produce polished and presentable work with formatting and printing techniques, while learning crucial...

Friday Oct 18th, 10am - 5pm

Beginner Microsoft Excel 2016

at NYC Career Centers - Midtown 185 Madison Ave Ste 1104, New York, New York 10016

Microsoft Excel Training Course Overview - Level 1 The Career Center, hands on, instructor-led, Beginner Excel training class in New York City will teach you to organize, calculate, analyze, revise, and present your data. Our basic Excel training course is classroom based instruction, with a live instructor, to introduce the basic look and feel...

Wednesday Oct 16th, 6pm - 9pm

  (2 sessions)
$209

2 sessions

Intermediate Excel for Business

at NYIM Training - Murray Hill 185 Madison Ave 11th Fl, New York, New York 10016

Intermediate Excel for Business Intermediate Excel for Business covers the essential applications of Excel used frequently by business professionals. This course is perfect for those with familiarity with basic formulas and functions, charts, and workbook management techniques. In this intermediate-level course, you will learn Pivot Tables, database...

Monday Oct 21st, 10am - 5pm

Excel Programming with VBA

at NYIM Training - Murray Hill 185 Madison Ave 11th Fl, New York, New York 10016

The Excel Power Programming with VBA concentrates on how to automate repetitious Excel tasks and reports. By the end of this course, you will feel confident in writing macros to automate your Excel tasks, even if the data is not consistently formatted, creating custom Excel applications and environments, and creating custom Excel Add-ins to increase...

Tuesday Oct 29th, 9am - 5pm

  (2 sessions)
$595

2 sessions

Intermediate Microsoft Excel 2016

at NYC Career Centers - Midtown 185 Madison Ave Ste 1104, New York, New York 10016

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

Saturday Oct 19th, 10am - 5pm

Microsoft Excel Expert (Level 3)

at Technical Institute of America - Hell's Kitchen 545 8th Ave 4th Fl, New York, New York 10018

We are offering a Microsoft Excel Expert Course. The class will teach you how to create Marco's, conditional formatting, securing your workbooks, expert functions, auditing worksheets, analyzing data, and importing, exporting data.  This course is perfect for someone who uses Microsoft Excel already, or took our Excel essentials course and wants...

Thursday Oct 24th, 10am - 6pm

Advanced Excel for Business

at NYIM Training - Murray Hill 185 Madison Ave 11th Fl, New York, New York 10016

Advanced Excel for Business Advanced Excel for Business covers the advanced applications of Excel used frequently by business professionals. This course is perfect for those with strong working knowledge and practice in Excel looking to apply more complex Excel features. In this advanced course, you will learn Goal Seek, Data Tables, advanced functions,...

Wednesday Oct 16th, 10am - 5pm

Excel for Mac Level 1

at NYIM Training - Murray Hill 185 Madison Ave 11th Fl, New York, New York 10016

Excel for Mac covers the essential applications of Excel used frequently by business professionals. In this introductory course, you will learn basic and multi-input functions, absolute references, charts and tables. We will help you produce polished and presentable work with formatting and printing techniques, while learning crucial tricks to facilitate...

Wednesday Oct 16th, 6pm - 9pm

  (2 sessions)
$209

2 sessions

Microsoft Excel Essentials

at Technical Institute of America - Hell's Kitchen 545 8th Ave 4th Fl, New York, New York 10018

We are offering a Microsoft Excel Course. The class will teach you how to create and modify worksheets, enter complex formulas, create Pivot tables and Charts, inserting objects, and working with tables. Our Small classes allow everyone more time to interact with the instructor, learn faster, and more effectively.  This is a great course for...

Wednesday Oct 23rd, 10am - 6pm

Intermediate Excel: Formulas & Functions

at General Assembly - Flatiron 10 E 21st St 3rd Fl, New York, New York 10010

The Intermediate Excel: Formula and Functions workshop is designed for students who have mastered the material from the Excel at Excel workshop and are looking to build upon those skills. Given that there lacks an enforceable prerequisite, the workshop does review a few topics from the Excel at Excel workshop, including conditional math functions and...

Monday Oct 28th, 6:30pm - 9:30pm

Excel Genius Class 4 : Array Formulas, Tables

at The New York Public Library - Fordham Heights 310 E Kingsbridge Rd, Bronx, New York 10458

Excel Genius Class 4 : Array Formulas, Tables, and Data Validation This Class will cover how to create and use Array Formulas, build and edit Tables, and how to write structured references that make function writing easier and more flexible.  We will also cover data validation and build drop down lists in your spreadsheets. Skills required: ...

Wednesday Oct 16th, 1pm - 3pm

Free

Excel VBA Macros Level I

at NYC Career Centers - Midtown 185 Madison Ave Ste 1104, New York, New York 10016

Microsoft Excel VBA Macros Level I Class Overview Our VBA Excel Macro Classes will instruct you how to use basic Macros to automate Excel. You will be able to use your Excel knowledge more productively by incorporating Macros in your spreadsheets. This Excel Macro Course assumes no previous knowledge of Macros. Excel VBA Macros Level 1 course is...

Tuesday Oct 29th, 9am - 5pm

Excel Bootcamp

at General Assembly - Flatiron 10 E 21st St 3rd Fl, New York, New York 10010

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

Saturday Oct 19th, 10am - 4pm

Excel 2016: Intermediate

at Baruch College - CAPS - Murray Hill 10010

This course builds on the fundamentals in the Excel 2016 Basic course. In this class, you will create financial outlines and subtotals, create, apply and manage cell names, as well as sort and filter data sets. Styles and themes will be covered and you'll learn how to navigate and manage large workbooks. This course also covers publishing Excel worksheets...

Wednesday Oct 16th, 6:15pm - 8:35pm

  (3 sessions)
$265

3 sessions

Excel Genius 4: Tables and Data Validation

at The New York Public Library (Tech) - Manhattan 188 Madison Ave, New York, New York 10016

This Class will cover how to build and edit Tables, and how to write structured references that make function writing easier and more flexible. We will also cover data validation and build drop down lists in your spreadsheets. Skills required: Be able to Write functions Understand Absolute vs Relative Cell References Know how to navigate menu...

Saturday Oct 19th, 10:30am - 12:30pm

Free

Excel Genius Class 5: Pivot Tables

at The New York Public Library - Fordham Heights 310 E Kingsbridge Rd, Bronx, New York 10458

This class will cover Pivot Tables, a powerful tool used to analyze relationships between data.  We will cover setting up data for use in Pivot Tables, how to format results, filtering techniques, and interactive elements.   Skills required: Know how to navigate menu options in Excel Understand formatting and conditional formatting

Monday Oct 21st, 1pm - 3pm

Free

10 Advanced Excel Charts for Business Presentations

at General Assembly - Flatiron 10 E 21st St 3rd Fl, New York, New York 10010

Appealing, focused, and easy to understand graphics can be the deciding factor on how your presentation is received. In more stark terms, making bad data visualizations can diminish your credibility as a business or data professional. In this bootcamp, we will learn how to create 10 Advanced Excel charts that will take your data analysis presentations...

Saturday Oct 19th, 10am - 4pm

Excel Genius 5: Pivot Tables

at The New York Public Library (Tech) - Manhattan 188 Madison Ave, New York, New York 10016

Excel Genius is a new set of classes aimed at students who have taken the Beginner and Intermediate Excel courses, or who have good fundamental knowledge of Excel, and who would like to gain a deeper understanding of the world’s most popular spreadsheet application.  Each class will cover a topic in depth and then give students exercises that...

Saturday Oct 19th, 2:30pm - 4:30pm

Free

Excel Expert Certification

at NYIM Training - Murray Hill 185 Madison Ave 11th Fl, New York, New York 10016

The Excel for Business Series is a three part series that aims to tackle the most common and practical uses of Excel in business, from basic data entry and navigation to advanced functions, data structures and optimizations. The "Excel Expert Certification" includes our Fundamental, Intermediate, and Advanced Excel classes, as well as the Expert Certification...

Monday Oct 21st, 10am - 5pm

Advanced Microsoft Excel 2016

at NYC Career Centers - Midtown 185 Madison Ave Ste 1104, New York, New York 10016

Advanced Microsoft Excel 2016 The Career Center Advanced Excel training in New York City is a hands on, instructor-led class that will teach you more advanced techniques to organize, calculate, analyze, revise, and present your data. This classroom based live Excel class with a live instructor will cover topics such as Using Multiple Worksheet and...

Wednesday Oct 16th, 10am - 5pm