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 3 days? Sign up for our Microsoft Excel Bootcamp and get a 15% package discount. 

Prerequisites: Prior experience with Excel is not required; however, attendees must be comfortable with computer basics.

Class Notes: 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.

Excel Fundamentals

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

Register for a class

Dec 19–20 Wed–Thu, 6–9pm
Dec 20 Thu, 10am–5pm
Dec 27 Thu, 10am–5pm
Dec 29 Sat, 10am–5pm
Jan 3 Thu, 10am–5pm
Jan 9 Wed, 10am–5pm
Jan 12 Sat, 10am–5pm
Jan 14–15 Mon–Tue, 6–9pm
Jan 15 Tue, 10am–5pm
Jan 21 Mon, 10am–5pm
Jan 25 Fri, 10am–5pm
Jan 27 Sun, 10am–5pm
Jan 30–31 Wed–Thu, 6–9pm
Jan 31 Thu, 10am–5pm
Feb 6 Wed, 10am–5pm
Feb 9 Sat, 10am–5pm
Feb 11–12 Mon–Tue, 6–9pm
Feb 12 Tue, 10am–5pm
Feb 19 Tue, 10am–5pm
Feb 24 Sun, 10am–5pm
Show more dates

Corporate training available

Call 212-658-1918 or email us

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
  • icon for small classesSmall classes
  • icon for small classesComputer provided
  • icon for small classesBook included
  • icon for small classesFree retake

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