TIA Logo TIA Logo
BBB Logo
Call Us: 212-564-2351
  • Related Courses
  • Excel Essential
  • PowerPoint
  • Outlook
  • Word
  • Access
  • Project

Microsoft Excel Expert Training Course

New York City

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.

All courses are live instructor-led. If you have a group of employees looking for Excel training, call us for a customized quote. We offer great discounts and onsite training for groups of two or more.

This class covers topics from Excel Level 3. Click here for level 3.

Students will learn

  • Covers level 3 topics
  • Works with Excel 2007, 2010, 2013 and 2016,
  • 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.
Click Here
to pay $99 for Excel Expert! When you sign up for both Excel Classes!

Benefits of this course

  • Small class
  • 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
  • Convenient location 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
  • The course will include a customize manual with step by step directions and a certificate at the end, showing that you completed the class.
TIA Locations
New York City
545 8th Avenue, 4th Floor
New York, NY 10018
Between 37th and 38th street.
Click Here for Directions
Take any of the following Subway lines to Times Square
1 2 3 7 A CE BD F M G J Z L S N Q R W
Take any of the following NJ Trasit Buses to Port Authority
108 111 129 160 161 190 192
Microsoft Office Savings Package

Sign up for multiple courses and save

Reasons for taking the course with us - Click Here
  Other Training Companies
Microsoft Learning Solutions Partners (Non Authorized training)
Better Business Bureau Accredited Business. (Not an Accredited Business. No assurance if they are a real company)
Ultra Fast 4/6-Core Desktops with 19'-24' monitors (old outdated computers)
Easy Refund Policy. Cancel before the course starts and receive a refund the same day. Reschedule at any time with our no fee rescheduling policy. (Most companies charged a cancellation fee of up to $400 and take more than 20 days to issue refunds. Please check before you sign up)
Flexible Schedule (Weekday, Evening, and Weekend). (Just Weekday classes)
Instructor with real world Experience. (Instructors with no real world Experience)
Live instructor-led training.
Great Location. A few blocks from Penn Station and Port Authority. (Have to take additional trains and buses to get there)
American owned and operated company. (Non-American company)
New York State Licensed Regulated School. (Non-licensed illegal school)
One (1) free retakes of the course for up to six months. (no retakes allowed)
Luxurious facilities. (Poorly maintained spaces)
Frequently Asked Questions (FAQ) - Click Here

Where is the school located?

New York City Location
545 8th Avenue, 4th Floor
New York, NY 10018
Click Here for Directions

Is this an online or a live classroom training?

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

Is this a hands on class, where everyone gets a computer?

Yes this is a 100% hands on class where all students gets their own computer to use throughout the class. You will not be sharing a computer with anyone.

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.

Why is the tuition much lower than other schools?

Our tuition is much lower than other training providers because we have optimized our business processes to ensure quality training at a reasonable price. As a smaller school with lower overhead we are able to provide a great class and better value to our students.

What are your instructors like?

We only hire the best instructors. Our instructors are all Microsoft Certified Trainers. All instructors have over 10 years’ experience in the filed they teach and over 5 years of experience teaching Microsoft Office.

Why should I choose your training over other schools?

Choosing a training provider can be tough choice. We all claim to offer the best value, in terms of price and training quality. The Technical Institute of America offers the lowest price and teaches more Microsoft Office than any other school in New York City. As a New York State licensed school and Better Business Bureau Accredited business we can honestly say what we offer is the truth and you can verify it. 

Do you ever cancel a class because you don’t have enough students?

No, we never cancel a class. If unforeseen circumstances arise such as bad weather, instructor health or family problems and we have to cancel a class, we will offer all students a 100% refund or reschedule to another class.

 

Course Topics - Click Here

Lesson 1: Streamlining Workflow

  • Create a Macro
  • Apply Conditional Formatting
  • Add Data Validation Criteria

Lesson 2: Collaborating with Others

  • Protect Files
  • Share a Workbook
  • Set Revision Tracking
  • Review Tracked Revisions
  • Merge Workbooks

Lesson 3: Expert Functions

  • Financial Functions
  • Date and time functions
  • Nested Logical Functions
  • Working with Math Functions

Lesson 4: Auditing Worksheets

  • Trace Cells
  • Troubleshoot Errors in Formulas
  • Troubleshoot Invalid Data and Formulas
  • Watch and Evaluate Formulas

Lesson 5: Analyzing Data

  • Create a Trendline
  • Create Scenarios

Lesson 6: Working with Multiple Workbooks

  • Create a Workspace
  • Consolidate Data
  • Link Cells in Different Workbooks
  • Edit Links

Lesson 7: Importing and Exporting Data

  • Export Excel Data
  • Import a Delimited Text File
Tuition $249
$149
Sale ends Mar 01, 2019

Filter Location

New York

Online

All

Upcoming Dates

Mar 10
Sun 10am - 6pm

New York City

Mar 14
Thu 10am - 6pm

New York City

Mar 27
Wed 10am - 6pm

New York City

Apr 07
Sun 10am - 6pm

New York City

Apr 11
Thu 10am - 6pm

New York City
corporate voucher button
Google Reviews

Testimonials

"A very good class. I absolutely came away feeling comfortable with the program."

Helena

"Instructor was extremely knowledgeable and a pleasure to work with!"

Denise

"Instructor was very friendly and through he is very good and helped me tremendously."

Blake

"Instructor was absolutely terrific. Best software training I ever had."

Greg

"Instructor made learning pivot tables and charts very easy. I recommend this class to anyone looking to learn Excel."

Tiffany

"Presentation was well done. Instructor was very knowledgeable and friendly. Made learning the complex formulas easy."

Albert

"I had taken classes at other schools. This class was one of the best I ever had. The instructor was great, class was small and computers were new."

Latoya

"I love the Small classes and smart teacher. He made learning easy and fun."

Angel

"Although I have had Excel training before. I have not had it with such clarity. I appreciate his presentation. I'm sure I will be able to retain and use everything I learned. Special Thanks."

Sharon

"Juan is an excellent instructor."

Joyce

"The instructor was very clear when explaining every aspect of Excel. I really feel I learned a lot and will take other courses in the future."

Julia

""I was really impressed with how clear the instructor's instructions were, which made the course enjoyable."

Izzy

Click Here for more
Courses
  • PMP / CAPM
  • PMI-ACP
  • ITIL
  • Six Sigma: Green Belt
  • CISSP
  • CEH
  • Bookkeeping Basics
  • Certified Bookkeeper
  • AutoCAD Level 1
  • AutoCAD Level 2
  • AutoCAD Level 3
  • Revit Level 1
  • ESL
Courses
  • Microsoft Excel Essentials
  • Microsoft Excel Expert
  • Microsoft PowerPoint
  • Microsoft Outlook
  • Microsoft Word
  • Microsoft Project
  • Microsoft Access
  • QuickBooks Basic
  • QuickBooks Advanced
  • Photoshop Level 1
  • Illustrator Level 1
  • InDesign Level 1
  • Dreamweaver Level 1
Courses
  • CompTIA A+
  • CompTIA Network+
  • CompTIA Security+
  • CCNA/CCENT
  • CCNP
  • MCSE: Cloud Platform and Infrastructure
  • MCSA: Server 2016
  • Medical Assistant
  • Medical Billing & Coding

New York City Location

545 8th Avenue, 4th Floor
New York, NY 10018

Contact Us

Phone: 212-564-2351
Fax: (800) 490-7341
Email: info@tiaedu.com


f
© Copyright tia.edu 2019. All Rights Reserved.
PMP, CAPM, PMI-ACP, PgMP, PMI-RMP, PMI-SP, PMBOK, Project Management Professional, Certified Associate in Project Management (CAPM), Project Management Professional (PMP), PMI Agile Certified Practitioner (PMI-ACP), Program Management Professional (PgMP), PMI Risk Management Professional (PMI-RMP), PMI Scheduling Professional (PMI-SP), A Guide to the Project Management Body of Knowledge (PMBOK Guide), The PMI REP Logo are registered marks of the Project Management Institute, Inc.
ITIL, PRINCE2, MSP, M_o_R, P3M3, P3O, MoP and MoV are registered trademarks of AXELOS Limited. The Swirl logo™ is a Trade Mark of AXELOS.