Microsoft Excel Expert is unfortunately unavailable

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

Microsoft Excel Expert

at Technical Institute of America - Hell's Kitchen

(646)
Course Details
Price:
$169
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:
Hell's Kitchen, Manhattan
545 8th Ave 4th Fl
Btwn 37th & 38th Streets
New York, New York 10018
(Map)
Purchase Options
Save to WishList

123 people saved this class

Book Private Class
Description
Class Level: Advanced
Age Requirements: 18 and older
Average Class Size: 10

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:

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 to become an expert user. 

The topics covered in this course can be applied to Excel 2007, 2010, 2013 and 2016.

Students will learn:

  • How to macros to automate our spreadsheets.
  • Using conditional formatting to formats specific cells in a range.
  • Protecting workbooks and sheets. If you share your workbooks with others, protecting certain sheets or range will ensure the integrity of the sheets stays intact.
  • How to use a combo IF and Vlookup to lookup values base on certain conditions and criteria.
  • When you would use the ISBLANK or ISERROR functions. Ever had a function return error because a cell was blank? We will show how to stop this.
  • Using SUMIF, AVERAGEIF, COUNTIF. These will allow us to sum, count and average base on certain criteria.
  • Inputting financial functions.
  • Tracing errors in functions using formula auditing. Excel has a great set of tools to help us troubleshoot errors in formulas.
  • Working with scenarios. what are they, and how they help us save time.
  • Inserting a trendline on a chart and having Excel forecast your next quarter or months finance.
  • How to import and export data into excel. Also includes using web data. Have a web page you constantly monitor, to update excel? Have excel update itself when the web page changes.
What does the Excel Expert training course include?

  • Course covers Excel 2007, 2010, 2013, 2016, and 2019 versions.
  • This is 100% hands-on course; every student will have his or her own computer to work on.
  • The most flexible schedule. We have weekday, evening and weekend courses available.
  • FREE retake for up to 6 months.Come back and retake our course free of charge for up to 6 months from your original course date.
  • Flat rate $169 tuition includes 8 hours of training and physical training manual.
  • Full day of training or 2 evening. 8 hours of total training time
  • You’ll be given a Certificate upon completion of the training.
  • Expert instructor with more than 10 years of financial experience using and teaching Excel
  • Convenient location in Midtown Manhattan. 2 blocks from Penn Station.
  • The course will include a customize manual with step by step directions and a certificate at the end, showing that you completed the class.
FAQ

Is this an online or a live classroom training?

This class is a live classroom training in New York City.

Would I get a certificate after completing the class?

Yes you will get a certificate of completion at the end of the class.

Is the training manual included?

Yes the course fee includes a training manual.


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.

School Notes:

In light of concerns around COVID-19 and to serve you better, we are shifting to Live Online training for our public courses until the end of April- you can attend from your home: 

  • All public classes are running as scheduled Live Online Only. 
  • If you’re already registered as a live online student, no changes to your classes. 
  • If you’re registered as in-person, we will be switching your registrations to Online access. 
  • For course that cannot be taught online we will rescheduled them to a later date. 

As the virus subside, we hope to be offering all in-person classes in May.

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: 

Cancellations made 3 or more days in advance will receive a full credit for a rescheduled date with this provider   

----

Original cancellation policy (non-COVID-19):

  • Cancellation made up to 7 days prior to the start of the class will receive a refund.

  • Refunds will not be given to anyone who has taken the whole or part of the class.

  • Refunds will not be given for any cancellations made 6 business days prior to the start of the class or on the day of the class.

  • Refunds will not be given for anyone that does not show up on the day of the class.

  • All refunds will be charged a 15% processing fee.
  • Rescheduling is not permitted 6 business day prior to the start of the class or on the day of the class.

  • Students must attend 80% or more of class total duration to receive a Certificate of Completion.

Map

Google Map

Technical Institute of America

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 1690 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 Caroline
The course description says the topics can be applied to Excel 2007, 2010, and 2013. What about 2016?
Answer from Brenda L. CourseHorse StaffCourseHorse Staff
Hi, Caroline! This can also be applied to Excel 2016. I have updated the class description so it's clear. Thanks!
Answer
Cancel

Reviews of Classes at Technical Institute of America (616)

(616 Reviews)
Microsoft Excel Expert
Reviewed by Anup J. on 3/16/2019
Teacher was great, a few people in the class slowed us down.
Microsoft Excel Expert
Reviewed by shulem g. on 11/20/2017
I really enjoyed it and Vincent the instructor was actually very informative and knowledgeable about the various topics that the class covered and even gave some extra tips which weren’t included
Microsoft Excel Expert
Reviewed by Anonymous on 4/10/2017
The content of the class was very informative. However, the logistics of the class was not. The instructor arrived approximately 20 minutes late to the class, so we lost 20 minutes at the end of the class and were pretty much kicked out of the classroom for the next class to start. The instructor is very knowledgeable, but at times went a little too fast. He asked us to pay attention instead of writing down notes and missing out on the next steps because he thought the manual they provided us would have notes on the topics, but that was not really the case. There was a topic he was covering that was not in the manual and so he had to repeat it in order for us to take notes. Another downside was that the files for the class were not set up properly. They were supposed to provide us with clean files, but instead we all had files of the work from the previous class, so this caused us to delay in the learning portion because the teacher had to go around clearing out the work of the previous class in order for us to go over the work ourselves. That was very frustrating.
Microsoft Excel Expert
Reviewed by Anonymous on 2/9/2017
Very informative. Well paced. Favorites new functions are Match, Index, Goalseek and Column(). Thanks!
Microsoft Excel Expert
Reviewed by Saedel P. on 6/27/2016
Overall, the content was useful and practical. The instructor - Vincent Ty - is great and very knowledgeable. The classroom was full, yet he was able to manage the pace and was able to teach all the objectives in time. We were provided with exercises file, and a manual (for version 2010), but was assured it would work the same for version 2013.
loading...
loading...

School: Technical Institute of America

Technical Institute of America

The Technical Institute of America is a technology training company. Our passion for helping individuals and businesses learn technology has made us the number one technology company in New York City. Every year we train thousands in a variety of Microsoft®, Adobe®, Cisco®, CompTIA®, and PMI® courses....

Read more about Technical Institute of America

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

8 Top Choices

Excel Bootcamp

This class is temporarily being offered remotely.

at General Assembly - Online Online Class
Livestream, New York, New York 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...

Sunday Sep 26th, 1pm - 7pm Eastern Time

Excel Level 1

at Certstaffix Training - Flatiron 276 5th Ave Ste 704, New York, New York 10001

This course will introduce students to spreadsheets and the fundamentals concepts of Microsoft Excel. Learn these features of Microsoft Excel and get more done quickly.  Learn how to:  Quickly set up workbooks Enter data, and format it for easier viewing Perform calculations and find and correct errors Visualize data with charts and...

Thursday Oct 14th, 10am - 5pm Eastern Time

Excel VBA Programming

at Certstaffix Training - Flatiron 276 5th Ave Ste 704, New York, New York 10001

This 3-day Excel VBA Programming course is designed to give experienced Microsoft Excel users proficiency in creating procedures that run in response to specific events, working with control structures, developing user forms to accept or display data, validating the data entry in user forms, debugging and handling errors in code, and much more! Excel...

Tuesday Nov 9th, 10am - 5pm Eastern Time

  (3 sessions)
$995

3 sessions

Excel 2019 - Intermediate

This class is temporarily being offered remotely.

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 and manage cell range names, as well as create and modify column and pie charts. Sorting, filtering and calculations using calendar date functions will be covered as well as Pivot tables and charts. You'll also...

Wednesday Oct 13th, 6:15pm - 8:35pm Eastern Time

  (3 sessions)
$265

3 sessions

Excel Level 2

at Certstaffix Training - Flatiron 276 5th Ave Ste 704, New York, New York 10001

This course will teach students how to perform more advanced calculations and work with larger worksheets in Microsoft Excel. In this intermediate Excel course, you will learn how to:  Perform Calculations on Data Manage Worksheet Data Reorder and Summarize Data Combine Data from Multiple Sources Analyze Alternative Data Sets and Collaboration...

Monday Oct 11th, 10am - 5pm Eastern Time

Excel Level 3

at Certstaffix Training - Flatiron 276 5th Ave Ste 704, New York, New York 10001

This course will teach students advanced tasks in Microsoft Excel. In this advanced Excel course, you will learn about:  Alternative Data Sets Dynamic Worksheets with PivotTables Automating Repetitive Tasks with Macros Working with Other Microsoft Office Apps Business Intelligence Analysis and Forecasts and Visualizations Excel Versions...

Monday Oct 25th, 10am - 5pm Eastern Time

Excel Dashboards

at Certstaffix Training - Flatiron 276 5th Ave Ste 704, New York, New York 10001

This course builds upon the foundation knowledge presented in the Excel - Level 1 course and will help start you down the road to creating advanced workbooks and worksheets that you can use to create a dashboard. The ability to analyze massive amounts of data, extract actionable intelligence from it, and present that information to decision makers...

Tuesday Oct 26th, 10am - 5pm Eastern Time

Excel Data Analysis with PivotTables

at Certstaffix Training - Flatiron 276 5th Ave Ste 704, New York, New York 10001

Advances in technology have made it possible to store ever-increasing amounts of data. Along with this, the need to analyze that data and gain actionable insight is greater than ever. You already have experience working with Excel and creating basic PivotTables to summarize data. But Excel is capable of doing much more.  Being able to harness...

Tuesday Nov 9th, 10am - 2pm Eastern Time