Excel for Business Fundamentals

Beginner Excel Classroom Training in NYC

Master the core Excel functions in this one-day course. Learn calculations and data entry. Apply formatting to text and cells to make your spreadsheet scannable and visually appealing. In this hands-on training, you will learn all the basics to use Microsoft Excel as your primary data processing tool. You'll produce polished and print ready spreadsheets while learning tricks to accelerate your workflow.

Save 15% on Enrollment with our Excel Bootcamp

Do you want to become an advanced Excel user in just three days? Sign up for our Microsoft Excel Bootcamp and get a 15% package discount. 

Class Notes

  • Prerequisites: Prior experience with Excel is not required; however, attendees must be comfortable with computer basics.
  • A PC or Mac with Excel will be provided (choose your operating system at checkout). The instructor will present on a PC but will explain the differences for Mac students, and the class files clearly outline the differences.
  • icon for small classesSmall classes
  • icon for small classesComputer provided
  • icon for small classesBook included
  • icon for small classesFree retake

Register for a Class 

$209 7 Hours 185 Madison Avenue, NYC In-person classroom training

Corporate training available

Email us for information

Apr 22 Mon, 10am–5pm
Apr 24–25 Wed–Thu, 6–9pm
Apr 25 Thu, 10am–5pm
May 2 Thu, 10am–5pm
May 4 Sat, 10am–5pm
May 6–7 Mon–Tue, 6–9pm
May 8 Wed, 10am–5pm
May 13 Mon, 10am–5pm
May 19 Sun, 10am–5pm
May 20 Mon, 10am–5pm
May 22–23 Wed–Thu, 6–9pm
May 24 Fri, 10am–5pm
May 30 Thu, 10am–5pm
Jun 1 Sat, 10am–5pm
Jun 3–4 Mon–Tue, 6–9pm
Jun 5 Wed, 10am–5pm
Jun 11 Tue, 10am–5pm
Jun 16 Sun, 10am–5pm
Jun 17 Mon, 10am–5pm
Jun 19–20 Wed–Thu, 6–9pm
Show more dates

What You'll Learn

  • AutoSum functions
  • Calculations and data entry
  • Absolute cell references
  • Formatting and printing
  • Multi-input functions
  • Line, bar, and pie charts
  • Tables

Full Course Syllabus

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

Beginner Excel Classes New York City

Learn best practices in data management—Enter, Analyze, and Create Charts

Microsoft Excel is a powerful tool used to enter and track data for analysis. Excel for Business Fundamentals covers the essential applications of Excel used frequently by corporate professionals. Learn to produce polished work with formatting techniques and crucial tricks to accelerate your workflow.

In this hands-on class, you will work on real-world examples, reinforcing the concepts with practice throughout the class, as well as a cumulative project at the end. You’ll be able to take what you’ve learned in class and apply it directly to projects on your job. At the end of the course you’ll be able to do the following:

  • Create automatic calculations to save time entering data
  • Apply colors and formatting to text or data cells
  • Design spreadsheets with headers and print-ready worksheets
  • Learn shortcuts to perform repetitive tasks quickly

Save 15% by Enrolling in Our Excel Bootcamp

Are you eager to master the advanced functions and formulas of Excel? This course is the first class in our Excel for Business Bootcamp. Take our three Excel for Business classes and get a 15% package discount!  Sign up for the Excel Bootcamp

Continue Learning with our Free Excel Video Suite

Every student that enrolls in Excel for Business Fundamentals will have lifetime access to our Excel video suite with tutorials on Excel’s functions and techniques. Review the course materials with high-quality video with lifetime access on desktop, tablet or mobile, a $95 value, included at no additional charge.

Beginner Course Video Overview

This video will recap some of the essential concepts we'll cover in this class, including formulas, charts, Autofill, absolute cell references, conditional formatting & more. Play the video full-screen in HD for the best viewing experience.

Learn More About Our Beginner Course