Our one-day Excel Essentials class is the most popular Excel training course in the city. This live instructor-led hands-on course will cover basic to intermediate topics in Excel. All students will be given a computer to follow along and a custom training manual with all the steps and description of Excel functions.
When this course is over you will feel very comfortable using Microsoft Excel to create simple to complex spreadsheets with formulas, tables, objects, and charts. Students will be able to take home their files that was created in class 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.
What students will learn in this Excel Essential course?
This course is great for someone looking for a job that requires the use of Excel or to feel more comfortable using the program. This course will turn any Excel user into a Power Users.
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.
|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)|
|Small classes Size.||(Classes with 18+ students)|
|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)|
|Free retake of the course with in 6 months.||(No retakes allowed)|
|Flat tuition.||(Some providers charge for books or for using a credit card to pay)|
This class is a live classroom training in New York City.
Yes you will get a certificate of completion at the end of the class.
Yes the course fee includes a training manual.
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.
We only hire the best instructors. All instructors have over 10 years’ experience in the filed they teach and over 5 years of experience teaching.
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 Excel 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.
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.
Lesson 1: Creating a Basic Worksheet
Explore the User Interface and the Ribbon
Navigate and Select in Excel
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
Insert and Delete Cells, Columns, and Rows
Search for Data in a Worksheet
Spell Check a Worksheet
Lesson 4: Formatting a Worksheet
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: 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 7: Organizing Worksheet and Table Data
Create and Modify Tables
Sort or Filter Worksheet or Table Data
Calculate Data in a Table or Worksheet
Lesson 8: Presenting Data Using Charts
Create a Chart
Lesson 9: Analyzing Data Using PivotTables and PivotChart
Create a PivotTable Report
Analyze Data Using PivotCharts
"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