Microsoft Excel Essentials

at Technical Institute of America - Hell's Kitchen

(587)
Course Details
Price:
$169 6 seats left
Start Date:

Wed, Oct 23, 10:00am - 6:00pm

Next start dates (11)

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: All levels
Age Requirements: 18 and older
Average Class Size: 10

What you'll learn in this excel class:

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 someone looking for a job that requires the use of Excel or to feel more comfortable using the program. This one day course will turn any Excel user into a Power Users. The topics covered in this course can be applied to Excel 2007, 2010, 2013 & 2016

Topics Covered:

Lesson 1: Creating a Basic Worksheet

  • Explore the User Interface and the Ribbon
  • Navigate and Select in Excel
  • Obtain Help
  • Enter Data and Save a Workbook
  • Customize the Quick Access Toolbar

Lesson 2: Performing Calculations

  • Create Basic Formulas
  • Calculate with Functions
  • Copy Formulas and Functions

Lesson 3: Modifying a Worksheet

  • Manipulate Data
  • Insert and Delete Cells, Columns, and Rows
  • Search for Data in a Worksheet
  • Spell Check a Worksheet

Lesson 4: Formatting a Worksheet

  • Modify Fonts
  • Add Borders and Color to Cells
  • Change Column Width and Row Height
  • Apply Number Formats
  • Position Cell Contents
  • Apply Cell Styles

Lesson 5: Printing Workbook Contents

  • Print Workbook Contents Using Default Print Options
  • Set Print Options
  • Set Page Breaks

Lesson 6: Managing Large Workbooks

  • Format Worksheet Tabs
  • Manage Worksheets in a Workbook
  • Manage the View of Large Worksheets

Lesson 7: Calculating Data with Advanced Formulas

  • Manage Cell and Range Names
  • Calculate Data Across Worksheets
  • Use Specialized Functions
  • Analyze Data with Logical and Lookup Functions

Lesson 8: Organizing Worksheet and Table Data

  • Create and Modify Tables
  • Format Tables
  • Sort or Filter Worksheet or Table Data
  • Calculate Data in a Table or Worksheet

Lesson 9: Presenting Data Using Charts

  • Create a Chart
  • Modify Charts
  • Format Charts

Lesson 10: Analyzing Data Using Pivot

  • Tables and PivotCharts
  • Create a PivotTable Report
  • Analyze Data Using PivotCharts

Lesson 11: Inserting Graphic Objects

  • Insert and Modify Pictures and ClipArt
  • Draw and Modify Shapes
  • Illustrate Workflow Using SmartArt Graphics
  • Layer and Group Graphic Objects

Lesson 12: Customizing and Enhancing Workbooks and the Excel Environment

  • Customize the Excel Environment
  • Customize Workbooks
  • Manage Themes
  • Create and Use Templates
What does the Excel Essential 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
  • A customized manual with step by step directions is included with the course.
  • You’ll be given a Certificate upon completion of the training.
  • A FREE retake is included should you ever need a refresher.
  • Learn to create simple to advance formulas, from SUM functions to IF, VLOOKUP, HLOOKUP, and nested functions
  • Learn to create a variety of charts and data sets
  • Learn to create PIVOT Tables and Charts
  • 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.

Note: 

This Class is Microsoft Excel Level 1-2 Combo.

Still have questions? Ask the community.

Refund Policy
  • Cancellation made up to 7 days prior to the start of the class will receive a refund.
  • Refunds will not be given for anyone who has taken the whole or part of the class.
  • Refunds will not be given for any cancellations made 6 business day 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 Certificate of Completion.

Map

Google Map

Technical Institute of America

All classes at this location

Start Dates (12)
Start Date Time Teacher # Sessions Price
10:00am - 6:00pm TBD 1 $169
10:00am - 6:00pm TBD 1 $169
10:00am - 6:00pm TBD 1 $169
6:00pm - 10:00pm TBD 2 $169
This course consists of multiple sessions, view schedule for sessions.
Wed, Nov 13 6:00pm - 10:00pm TBD
10:00am - 6:00pm TBD 1 $169
Start Date Time Teacher # Sessions Price
10:00am - 6:00pm TBD 1 $169
10:00am - 6:00pm TBD 1 $169
10:00am - 6:00pm TBD 1 $169
10:00am - 6:00pm TBD 1 $169
6:00pm - 10:00pm TBD 2 $169
This course consists of multiple sessions, view schedule for sessions.
Wed, Dec 11 6:00pm - 10:00pm TBD
Start Date Time Teacher # Sessions Price
10:00am - 6:00pm TBD 1 $169
10:00am - 6:00pm TBD 1 $169

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 (5)

Get quick answers from CourseHorse and past students.

Question from Halina K.
Does the institute provide the computer on-site while we are in session?
Answer from Brenda L. CourseHorse StaffCourseHorse Staff
Hi Halina! Every student will have his or her own computer to work on. Hope this helps!
Answer from John L. Verified Student
Yes it does.
Show all 2 answers
Answer
Cancel
Question from Anne G.
I am a real beginner with excel, would this class be good for me?
Answer from Brenda L. CourseHorse StaffCourseHorse Staff
Hi Anne! Yes, this class is for All Level so beginners can also attend this class.
Answer
Cancel
Question from Luna
Please advise if computers with the Excel program are provided for this class and students are not required to bring any equipment.
Answer from Georgia C. CourseHorse StaffCourseHorse Staff
Hi Luna! The school provides a computer with the software installed to follow along.
Answer
Cancel
Question from Anonymous
hello, I would like to know whats difference between the excel for business fundaments class and Microsoft excel essentials
Answer from Georgia C. CourseHorse StaffCourseHorse Staff
Hi there! Microsoft Excel Essentials class mainly focus on excel for daily use while Excel for Business Fundamentals class is for business professionals.
Answer
Cancel
Question from Valarie B.
I would like to know if you can retake the class for free.
Answer from Andrea P. CourseHorse StaffCourseHorse Staff
Hi Valarie! Yes, there's a free retake if needed.
Answer from Michele B. Verified Student
You can retake the class once for free. I believe there is a time limit on when that could happen, but I do not recall what it is.
Answer from Sofia P. Verified Student
Yes, you can.
Answer from shulem g. Verified Student
Yeah
Show all 4 answers
Answer
Cancel
View all 5 questions

Reviews of Classes at Technical Institute of America (557)

(557 Reviews)
Microsoft Excel Essentials
Reviewed by Felicia G. on 10/6/2019
Instructor was knowledgeable and made the subject easy to comprehend.
Microsoft Excel Essentials
Reviewed by jessica d. on 7/24/2019
grood teacher! i was a bit overwhelmed but i want to re-take the class.
Microsoft Excel Essentials
Reviewed by John L. on 7/10/2019
The instructor, Andrew, was very informative, helpful and tried to motivate everyone to ask questions and get the most out of the class.
Microsoft Excel Essentials
Reviewed by Anonymous on 7/10/2019
The instructer was rude. He wasn't welcoming or patient. He rushed through the class it was over at 5pm. I would not take a class with him again. The classroom and computers were good. The receptionist was friendly and welcoming.
Microsoft Excel Essentials
Reviewed by Anonymous on 4/12/2019
This class was full of information. You absolutely must be familiar with excel to follow the class comfortably. Thank you the updates, refresher and new information.
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
Booking this class for a group? Find great private group events here