In this beginner Excel workshop, you’ll learn the essentials of Microsoft Excel, including calculations, basic functions, graphs, formatting, and printing. This basic Excel class is perfect for those with limited experience looking to expand their proficiency.

The course comes with our revolutionary Excel video suite, so you can review the materials anytime after the class.

Take this class as part of the Excel Bootcamp and get a 15% discount. The package includes Excel Fundamentals, Intermediate Excel, and Advanced Excel.

This beginner Excel class is taught in partnership with NYIM Training.

What You’ll Learn

Become familiar with the interface and data entry
Learn essential formulas and functions
Format and print your work
Create charts, including line, column, and pie charts
Learn tips and tricks for easy workbook management
Review key concepts in a final project

Learn with Hands-on Projects

Learn practical skills by working on real projects with instructor guidance and lectures to strengthen and improve your skill.

Course Syllabus

Download Syllabus PDF

Introduction

Interface

Provides a brief description of the user interface for Microsoft Excel

Data Entry

Examines and describes multiple means of entering data

Formulas

Autofill

Explores Excel's amazing ability to predict and extrapolate patterns

Calculations

Perform mathematical expressions and review the Order of Operations rule

True or False

Tests to see whether criteria is true/false

AutoSum Functions

Review the five key functions: Sum, Average, Max, Min, and Count Numbers

Text Functions

Introduces functions used to modify text in Excel

Multi-Input Functions

More advanced functions that require more than one input

Absolute Cell References

Changing a cell reference into a constant, which is necessary in certain calculations

Formatting

The addition of effects to an excel document to provide visual instruction

Format Painter

The ability to copy format from one cell/range of cells to another cell/range of cells

Conditional Format

Apply a predetermined format based on specified rules

Charts & Tables

Line Chart

Create a Line chart and Spark lines to visually examine data

Column Chart

Create a Column chart to visually examine data

Tables

Explores the special functionality created when data is converted to a Table

Workbook Management

Printing

Rules and strategies to make printing easy

Worksheets

Insert, move, copy and delete worksheets

Repeat Action

Use the F4 key to duplicate a prior action

Shortcuts

5 Fundamental keyboard shortcuts and a review of others previously covered

End of Class Project

Project

End of class project to review key concepts from the class

Save and Close

Save, close and email the completed workbook

This Course is Available Live Online

You can attend this training live online at the scheduled time the course is offered (New York, Eastern Time) through screen-sharing software Zoom (free for you).
Our live online training is interactive and hands-on, just like our in-person classes. There are no extra fees and we’ll work with you to ensure your setup is perfect

Classes are activity-based and taught by a live instructor.
You can hear the instruction, ask questions, and share your screen—all in real-time.
Retake the course for free (in-person or live online) within one year.

See What Students Are Saying About Live Online

“Overall experience on Zoom was maybe even better than in IRL classroom because the instruction takes place right on your own screen, with less distraction. Great overall experience.”
“Given the fact that we had to do this entire class remotely due to Covid-19, I didn’t have very high expectations it would run so smoothly. However, I don’t think it could’ve gone any better. Not only do I feel very comfortable with the program now, but I’m actually excited to use it!”
“This was the first online class I’ve taken with ND and it was a great experience. Looking forward to the other classes I’ve signed up for!”

Learn more about how our live online training works

Online Training Demo

1-Minute Overview

Corporate & Onsite Excel Training

Purchase group class vouchers at a discount for our regularly-scheduled group classes in NYC, or create a custom training program at your offices.

Private Training

Available onsite at your location
Modern computer labs available at our offices
Customize or choose from our existing courses
Free instructor consultations to finalize content

Group Class Vouchers

Send employees to our group classes
Extensive offerings and flexible scheduling
Simple billing and logistics
Computers and training resources provided

We’ve trained thousands of companies!
Let us create the perfect program for your team.

(212) 226-4149

Learn Excel Essentials

This is a hands-on beginner Excel course in which you will work on real-world examples, so that you gain extensive practice throughout the class. You’ll learn the essentials of Excel from industry professionals, as well as apply the concepts you learn to a final project. This class also comes with access to NYIM’s Excel Fundamentals video suite, including lifetime access to several hours of valuable content.

Learn Essential Excel Concepts

Throughout the class you’ll learn essential concepts, including formulas, charts, Autofill, absolute cell references, conditional formatting, and more! By the end of the class, you’ll apply all the concepts learned to a final project.
Lifetime Access to a Video Suite

This class comes with access to the Excel Fundamentals video suite that contains individual videos of each of the exercises covered in the course.
Industry Professional Instructors

Our instructors are industry professionals who draw on their experience to teach real-world applications and time-saving techniques. Learn tips, tricks, and keyboard shortcuts you can use right away.

Highly Reviewed by Our Alumni

From our hands-on training style to world-class instructors and proprietary curriculum, we deliver a learning experience our alumni can be proud of.

6 Students Rated Our Excel Level 1 5 Stars

Fast-paced class, a lot of information in a short amount of time—condensed to most useful tips and tricks. Very glad I was able to participate as I learned a lot more than I already knew. Michael was a great instructor with a very easygoing vibe.

Roksana B.

Just came out of my Excel Business Level Training at NYIM. Garfield, the instructor, is really nice And very helpful. They are very professional and they provide all the necessary tools for the students to acquire all the info they need, and, in case you want to refresh your memory you can always retake the course for free within 6 months. Cool, huh? :-)

Dana D.

It was a full day from 10am-5, fast-moving and packed with information on all the Excel basics, including on-the-spot exercises. Really useful for skills in managing all kinds of information and projects. I'd highly recommend this course, and would like to take the L2 when I'm ready!

Kathleen H.

This course exceeded my expectations. Saba is a great instructor! She answered all my questions and went beyond to link it to real life examples.

Laura H.

Had a one on one training with Garfield - he was patient, professional, and incredibly knowledgeable. Would highly recommend for anyone looking to expand their excel capabilities in business.

Alexandria A.

Great class! The content was well organized and the instructor was excellent. He was engaging, knew the material very well and was able to adjust to the various levels of ability of the students! Would definitely recommend!

Rebecca H.

Compare Excel Level 1 to Similar Courses

Select up to two courses and tap Compare Courses to view a side-by-side comparison of Excel Level 1 with your selected courses.

Compare

Excel Bootcamp

21 hours $549

Learn functions, formulas, Pivot Tables, Macros, and time-saving techniques in this hands-on Excel Bootcamp. You'll conquer all the keys skills to become proficient in Microsoft Excel.
More details
Compare

Excel Level 2

7 hours $219

In this intermediate Excel class, you'll learn functions such as VLOOKUP and SUMIFs; summarize data with Pivot Tables; Sort & Filter databases; and split and join text.
More details
Compare

Excel Level 3

7 hours $219

In this advanced Excel training, you'll learn advanced database functions such as INDEX and MATCH; create basic macros; and use What-If Analysis for Goal Seek and Data Tables.
More details
Compare

Excel Programming with VBA

14 hours $549

This Excel VBA course concentrates on practical automation of repetitious Excel tasks and reports. In this hands-on training, you will write macros to automate your Excel tasks even if the data is not consistently formatted, create custom Excel applications and environments, and create custom Excel Add-ins to increase the functionality of the program.
More details

Learn the Skills Guarantee™

Hands-on training in small groups

Time-tested curriculum and supporting materials

Learn from industry experts with teaching experience

Retake the course for free within one year

What You’ll Learn

Learn with Hands-on Projects

Course Syllabus

Introduction

Interface

Data Entry

Formulas

Autofill

Calculations

True or False

AutoSum Functions

Text Functions

Multi-Input Functions

Absolute Cell References

Formatting

Formatting

Format Painter

Conditional Format

Charts & Tables

Line Chart

Column Chart

Tables

Workbook Management

Printing

Worksheets

Repeat Action

Shortcuts

End of Class Project

Project

Save and Close

Schedule & Enrollment: Excel Level 1

Discounts

March 7

Sunday, 10–5pm

March 8

Monday, 10–5pm

March 8–9

Monday to Tuesday, 6–9pm

March 11

Thursday, 10–5pm

March 19

Friday, 10–5pm

March 30

Tuesday, 10–5pm

April 7

Wednesday, 10–5pm

April 10

Saturday, 10–5pm

April 14

Wednesday, 10–5pm

April 20

Tuesday, 10–5pm

April 21–22

Wednesday & Thursday, 6–9pm

April 26

Monday, 10–5pm

April 30

Friday, 10–5pm

May 6

Thursday, 10–5pm

May 8

Saturday, 10–5pm

May 12

Wednesday, 10–5pm

May 20

Thursday to Friday, 10–5pm

May 26

Wednesday, 10–5pm

June 2

Wednesday, 10–5pm

June 6

Sunday, 10–5pm

June 7–8

Monday to Tuesday, 6–9pm

June 8