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 at our affiliate school, NYIM Training, located at 185 Madison Avenue in Midtown Manhattan.

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

Schedule & Enrollment

$219
7 Hours
NYC or Live Online
Full setup assistance provided

This course is offered by our affiliate school, NYIM Training.
Please see NYIM Training for class dates and enrollment.

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.
Until July 5, 2020, all classes are available live online only. In-person expected to be available starting July 6th. Learn more about our reopening plan.

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.

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

This Course is Available Live Online

See What Students Are Saying About Live Online

Online Training Demo

Corporate & Onsite Excel Training

Private Training

Group Class Vouchers

Learn Excel Essentials

Learn Essential Excel Concepts

Lifetime Access to a Video Suite

Industry Professional Instructors

Highly Reviewed by Our Alumni

6 Students Rated Our Excel Level 1 5 Stars

Related Classes & Certificates

Excel Bootcamp

Excel Level 2

Excel Level 3

Excel Programming with VBA