Beginner Microsoft Excel in NYC or Live Online

Master Calculations, Formulas, & Functions

  • tag-solid $219
  • clock-solid 7 Hours
  • display-solid Mac or PC provided help-solid
  • users-solid Small in-person class
  • repeat-line Free retake help-solid
  • map-marker-solid 185 Madison Avenue, NYC
  • cloud-line Also available live online
All Microsoft Excel Courses Beginner Microsoft Excel

Get the hang of Excel formulas, functions, charts, and workbook formatting. This beginner course is the perfect introduction to Excel for self-taught users and complete beginners alike. Develop a command of time-saving Excel shortcuts and hotkeys.

Practical Real-World Training

Our Excel course includes practical exercises that walk you through the basics. Learn the concept, watch an example, complete an activity with the new concept on your own. At the end of the course, you’ll keep your training guide for reference whenever you use Excel.

Comprehensive Excel Video Suite

 Students in our Beginner Excel course, receive access to our companion video suite, featuring beginner level video lessons available for viewing on desktop, mobile, and tablet. These video tutorials explain popular Excel concepts in simple steps. 

Free Retake

Need a refresher? No problem! After you’ve signed up for the course, you can retake within 6 months of your original enrollment free of charge (and so long as there is an available seat in the class). 

Get 15% off by Enrolling in Bootcamp

Is your goal to become an advanced Excel user? Save money and sign up for our three-day Excel Bootcamp and save 15% on your enrollment fees.

Upcoming Class Dates

video-gallery-solid

Video Training Included

This course includes lifetime access to self-paced training videos, a $95 value.

Corporate training classroom
Career Centers teacher helping a student

Looking for corporate training?

We offer custom onsite training and discounted class vouchers.

envelope-solid nyc@careercenters.com
phone-handset-solid 212 • 684 • 5151
file-group-solid Download Syllabus

Course Overview

  • Get started with Microsoft Office Excel 2016
  • Perform Calculations
  • Modify Text
  • Format a Worksheet
  • Create Charts and Tables
  • Manage Workbooks
block-quote-line

This course is outstanding! Anyone who wants to learn all the basics for excel for business, beginner should take this course. The instruction was excellent and the format of actually working through excel problems to reinforce the different areas covered was outstanding!!!

Lisa R., Deutsche Bank

Took the Word and Excel basics as a refresher. The teachers covered the key features well. I like that you can do a free retake if needed. So much is covered that it acts to further reinforce the learning. A thoughtful addition is water, coffee, and bagels free to each student.

Emily Ann M.

Instructor was very knowledgeable and helpful. He answered all of my questions. Overall great class!

Kristi Manolias, Serene Home Nursing Agency

I enjoyed the dynamic of the class and will definitely recommend it to any one who wants to learn or needs a refresh

Maria Florencia Velasco

Excel made easy for beginners- Class for every professional.

uche oboh

Michael was a great teacher. He had a great knowledge of the subject matter. His patience and calm demeanor was very helpful when dealing with a beginner level course. He was a terrific teacher. I would definitely take another class with him. - Jane

Jane Kirby, Infraday

Thoughtful, digestible approach to honing Excel skills.

Elyse Goodman, NA

Great class. Michael kept excel interesting, which is quite a feat. I would highly recommend.

Heather Sporn

Garfield was an excellent instructor and answered all questions no matter of your level. This was a great learning experience.

Constance Padmore

Perfect for beginners and those that have forgotten what they already knew about Excel.

Quinn Dunham, Housing Works

These courses are not easy for the average person to get a grasp of. The instructor helped me to break through what I thought would be a very difficult thing for me to learn. I left with a strong feeling of self-confidence and I will use what I have learned here today. Thanks Patrick.

Oliver Ortiz, Housing Works

Great class for both beginners and more experienced students.

Nitza Rochez

Career Center is an excellent tool for advancement in the job market.

Victoria Batista

Fantastic approach to learning Excel. I would highly recommend the course to friends and colleagues.

Jacob Dachs

Great class that can greatly improve your excel skills!

Evan Metz, Tishman Speyer

Zoom is a great way of Learning.

Laura O'Rourke, RUSA Inc.

I highly recommend everyone who is in the workforce, or entering the career world to enroll with NYC Career Centers. The team wants their clients to succeed in their career. The classes I enrolled in are effective and efficient. They are worth a shot.

Julie Zirdok

This class really taught me a lot and everything I learned will help me in my professional work.

Mayu McCarthy, Mitsubishi Corporation Americas

circle-arrow-solid circle-arrow-solid

Full Course Syllabus

file-group-solid Download PDF Outline

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 for certain calculations

Formatting

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

Pie Chart

  • Create a Pie chart to visually examine data

Tables

  • Explore 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