Discover Classes. Earn Rewards.

Microsoft Excel Essentials

at Technical Institute of America - Hell's Kitchen

(555)
Course Details
Price:
$149 6 seats left
Start Date:

Mon, Jul 01, 10:00am - 6:00pm

Next start dates (12)

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
 
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.
  • 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
  • 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 attended the class.
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
Note: 

This Class is Microsoft Excel Level 1-2 Combo.

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 (13)
Start Date Time Teacher # Sessions Price
10:00am - 6:00pm TBD 1 $149
10:00am - 6:00pm TBD 1 $149
6:00pm - 10:00pm TBD 2 $149
This course consists of multiple sessions, view schedule for sessions.
Wed, Jul 10 6:00pm - 10:00pm TBD
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
10:00am - 6:00pm TBD 1 $149
10:00am - 6:00pm TBD 1 $149
10:00am - 6:00pm TBD 1 $149
6:00pm - 10:00pm TBD 2 $149
This course consists of multiple sessions, view schedule for sessions.
Wed, Aug 14 6:00pm - 10:00pm TBD
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

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

Get quick answers from CourseHorse and past students.

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

Reviews of Classes at Technical Institute of America (525)

(525 Reviews)
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.
Microsoft Excel Essentials
Reviewed by Anonymous on 3/11/2019
Instructor was knowledgeable, content was well organized. Would recommend without hesitation.
Microsoft Excel Essentials
Reviewed by Anonymous on 2/27/2019
Don’t think this is a basics course, more of a refresher for people who use Excel. For that, thought the class was really good. Fast-paced, organized, instructor was excellent.
Microsoft Excel Essentials
Reviewed by Rosalind J. on 2/21/2019
The professor was excellent,but the class was not for beginners.
Microsoft Excel Essentials
Reviewed by Anonymous on 2/5/2019
The class’ objective is good. But it is important to cover all the class hours. Also it would be very helpful if the attendees could create an excel sheet with the information received, to test the content, and not just to focus in the theorical content.
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...