featured

Microsoft Excel Expert Live Online Training Course - Instructor-Led Class

Tuition

Sale ends Friday, Dec. 09th

We are offering a Microsoft Excel Expert Course. The class will teach you how to create macros, 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.

When this course is over you will be able to create and edit macros, use nested functions, enter database and financial functions, tracing errors in functions, using trendlines and forecast, and how to automate the collection of web data into excel. Students will be able to take home their files they created during the course to practice. Also, students are welcome to come back for a free retake of the course, good for up to 6 months after their first course.

If your goal is to learn Excel from great instructors without breaking the bank, this course is for you. We deliver our Live Online training using the latest technology. You will be able to see your instructor, ask questions, and follow along with them. You are required to have Microsoft Excel installed on your computer. You can download a free 30 day trial directly from Microsoft by clicking this link.

What students will learn in this Excel Expert course?

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

FREE retake of the course for up to 6 months.

Come back and retake our course, free of charge for up to 6 months from your original course date.

4.9 out 5 Stars on Google

We pride ourselves on being able to offer a great course at a great price. With over 500 reviews, our students seem to agree. They compliment our great instructors the most.

3 Full days of Live Training

This course provides 24 hours of live interactive training.

FREE retake of the course for up to 6 months.

Come back and retake our course, free of charge for up to 6 months from your original course date.

Corporate & Government Training Available

Reduced pricing & customized training available for companies and government agencies.

100% Hands-On Training

This is NOT a lecture class where you just watch someone draw while you try to imagine yourself doing the same.

Affordable Training

Self Improvement should not require someone going into debt; that is why TIA offers the best value in quality training.

Tuition

Sale ends Friday, Dec. 09th

Upcoming Dates

Select a Time Zone

ALL times are EST. Online courses are delivered from our location in Virginia.

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

Upcoming Dates

ALL times are EST. Online courses are delivered from our location in Virginia.

See How we Compare

Curious about the online experience? Watch Now!

Our Live Online course allows you to attend our great live online training from the comfort of your desk at home or at work. It's the same great course with our excellent instructors. Here a few points about our online class.

  • Exactly as being in a classroom, just from the comfort of your desk at work or home.
  • You will get a live camera view of our classroom, allowing you to see your instructor. Our instructors will be wearing a high quality headset, so their voice will sound crystal clear.
  • The classroom will have a loudspeaker allowing you to ask questions that your instructor and the other students can hear.
  • Live training class. This is not an online class where you will study on your own.
  • 100% instructors led. Interact with our instructor exactly like you would do in a classroom setting.
  • Same course content as our regular classroom course.
  • All course material is mailed or emailed to you a week before the course starts.
  • All you need is a computer with an internet connection and a telephone, or any computer with a microphone and speaker.
  • Work's with any PC, MAC, Tablets, and Smartphones.
  • Save time and money on travel costs.
  • If you don't like the online experience after the first day, you can get a refund of the tuition.
  • Call us for a free demo of the live online class.

FAQ : Frequently Asked Questions

Course Outline

Tuition

Sale ends Friday, Dec. 09th

Corporate & Government On-Site training available

Upcoming Dates

Select a Time Zone

Online courses are delivered from our location in Virginia.
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