Discover Classes. Earn Rewards.

Microsoft Excel Expert (Level 3)

at Technical Institute of America - Hell's Kitchen

(553)
Course Details
Price:
$149 5 seats left
Start Date:

Wed, Jun 19, 10:00am - 6:00pm

Next start dates (5)

Location:
Hell's Kitchen, Manhattan
545 8th Ave 4th Fl
Btwn 37th & 38th Streets
New York, New York 10018
(Map)
Share:
Purchase Options
Description
Class Level: Advanced
Age Requirements: 18 and older
Average Class Size: 10

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.
 
Benefits to this course:
  • Small classes.
  • 100% hands-on training. Every student gets their own computer to follow along.Full day of training, or 2 evening. 8 hours of total training time.
  • Conveniently located in Midtown Manhattan, 2 blocks from Penn Station.
  • Expert instructor with more than 10 years of financial experience using and teaching Excel.
  • A free retake if needed
  • We are a Microsoft Office Specialist (MOS) Certified testing center. Take this course along with our Excel Essentials  class and you will be ready to ace your Excel certification exam. Call us to learn more about our Excel certification course and exam package.
  • The class will be held in Midtown Manhattan. The course will include a customize manual with step by step directions and a certificate at the end, showing that you attended a class.

Still have questions? Ask the community.

Refund Policy
You can get a 100% refund if you cancel up to 2 businesses before the start of your class. You can reschedule a class any time before the class starts.

Map

Google Map

Technical Institute of America

All classes at this location

Start Dates (6)
Start Date Time Teacher # Sessions Price
10:00am - 6:00pm TBD 1 $149
10:00am - 6:00pm TBD 1 $149
10:00am - 6:00pm TBD 1 $149
10:00am - 6:00pm TBD 1 $149
10:00am - 6:00pm TBD 1 $149
Start Date Time Teacher # Sessions Price
10:00am - 6:00pm TBD 1 $149

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 1490 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 (523)

(523 Reviews)
Microsoft Excel Expert (Level 3)
Reviewed by Anup J. on 3/16/2019
Teacher was great, a few people in the class slowed us down.
Microsoft Excel Expert (Level 3)
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 (Level 3)
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 (Level 3)
Reviewed by Anonymous on 2/9/2017
Very informative. Well paced. Favorites new functions are Match, Index, Goalseek and Column(). Thanks!
Microsoft Excel Expert (Level 3)
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...
Similar Classes

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.

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