Discover Classes. Earn Rewards.

Excel for Business Fundamentals

Enhance your productivity and master Excel's core functions with this hands-on course designed to boost your business skills.

  • Beginner
  • 18 and older
  • $249
  • 185 Madison Ave, New York, NY & Virtually Online

Start Dates (37)

  • $249
  • NYIM @ 185 Madison Ave 3rd Floor, New York, NY 10016
20 seats left
Book
20 seats left
Book
20 seats left
Book
20 seats left
Book
Show all 2 sessions
  • Tue, Apr 16 at 6:00pm - 9:00pm
  • Thu, Apr 18 at 6:00pm - 9:00pm
20 seats left
Book
Showing 15 of 37

Class Description

Description

What you'll learn in this excel class:

Get started in Excel with this fundamental Excel course. Get comfortable using Excel and learn to boost your productivity with formulas, charts, and formatting techniques.

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.

Prerequisites:

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

What You’ll Learn at a Glance

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

Course Syllabus

  • Introduction
    • Interface
    • Worksheets
    • Data Entry
    • Rows & Columns
  • Formulas
    • Autofill
    • Calculations
    • AutoSum Functions
    • Absolute Reference
    • True or False
    • Text Functions
    • Multi-Input Functions
  • Formatting
    • Formatting
    • Cell Styles
    • Conditional Formatting
  • Charts & Tables
    • Tables
    • Column Chart
    • Line Chart
    • Pie Chart
  • Workbook Management
    • Freeze Panes
    • Printing
    • Windows
    • Templates
    • Excel Tricks
  • End of Class Projects
    • Projects

Learn more about Excel for Business Fundamentals at NYIM Training

Syllabus

Introduction

Interface

  • Provides a brief description of the user interface for Microsoft Excel

Worksheets

  • Manage elements of worksheets

Data Entry

  • Examines and describes multiple means of entering data

Rows & Columns

  • Insert, delete, hide, and group rows and columns

Formulas

Autofill

  • Explores Excel's amazing ability to predict and extrapolate patterns

Calculations

  • Perform mathematical expressions and review the Order of Operations rule

AutoSum Functions

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

Absolute Reference

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

True or False

  • Tests to see whether criteria is true/false

Text Functions

  • Introduces functions used to modify text in Excel

Multi-Input Functions

  • More advanced functions that require more than one input

Formatting

Formatting

  • The addition of effects to an Excel document to provide visual instruction

Cell Styles

  • Apply consistent formatting to specific types of cells or values

Conditional Formatting

  • Apply a predetermined format based on specified rules

Charts & Tables

Tables

  • Explore the special functionality created when data is converted to a Table

Column Chart

  • Create a Column chart to visually examine data

Line Chart

  • Create a Line chart and Spark lines to visually examine data

Pie Chart

  • Create a Pie chart to visually examine data

Workbook Management

Freeze Panes

  • Enable a portion of the screen to stay visible at all times

Printing

  • Rules and strategies to make printing easy

Windows

  • Change how your worksheet displays data

Templates

  • Use prefabricated templates to build a spreadsheet

Excel Tricks

  • Fundamental keyboard shortcuts and other Excel tricks

End of Class Projects

Projects

  • End of class projects to review key concepts from the class

Refund Policy

  • Students may cancel up to 11 business days before the class/program start date and receive a refund, less the registration fee (10% of the undiscounted course price).
  • Cancellations within 11 business days are not permitted, but students may reschedule up to 4 business days before the class start date.

For cancellations and reschedules, please email us at [email protected]

Reviews of Classes at NYIM Training (742)

(4.5-star rating across 742 reviews)
  • Excel for Business Fundamentals

    Anonymous review on 2/10/2020
    It was a good class and information was well presented.
  • Excel for Business Fundamentals

    Reviewed by Melanie A. on 12/27/2019
    Great class, helpful instructor; I would recommend to someone who lacks experience with Excel and finds themselves needing to use it at work. The great thing is you can retake the class within 6 months for a refresher.
  • Excel for Business Fundamentals

    Reviewed by Yasmin C. on 9/8/2019
    Very detailed.
  • Excel for Business Fundamentals

    Reviewed by Samir I. on 6/25/2019
    class was good ,teacher was great ,just not enough time to practice.
  • Excel for Business Fundamentals

    Reviewed by Gayle R. on 5/28/2019
    It was good. The person next to me was more advanced and was trying to rush the progress of the class which was distracting.
  • Excel for Business Fundamentals

    Reviewed by NICHOLAS M. on 2/25/2019
    Garfield is an excellent teacher. Really enjoyed this class
  • Excel for Business Fundamentals

    Reviewed by Susanna K. on 2/12/2019
    Was too much new things for me Do you offer a slower class? Do you offer privat lessons?
  • Excel for Business Fundamentals

    Anonymous review on 1/11/2019
    The instructor was amazing - the content was well made, in an order that made sense and easy to follow. The instructor's timing was spot on - it was clear she had done this many times before. She was helpful, patient & kind. This class went by surprisingly fast for as long as it was because of how structured the agenda was. I will be taking other courses here.
  • Excel for Business Fundamentals

    Reviewed by John L. on 12/7/2018
    Great class! Excellent instructor!
  • Excel for Business Fundamentals

    Reviewed by Jen R. on 10/7/2018
    The class i took is the one with Garfield (private tutor)
  • Excel for Business Fundamentals

    Anonymous review on 8/29/2018
    Course was very informative and the instructor did an excellent job going over the material. I will be looking to attend the additional courses in the nearby future. Thank you
  • Excel for Business Fundamentals

    Reviewed by Cristina H. on 6/18/2018
    Great class. Thanks
  • Excel for Business Fundamentals

    Anonymous review on 5/17/2018
    The course was overall good. Although the booklet they gave out did not exactly correlate with what we were doing so it made it a little hard to take notes.
  • Excel for Business Fundamentals

    Reviewed by Marjan K. on 4/27/2018
    Great teacher.. a lot more needs to be covered that one day alone will not be enough. Thanks
  • Excel for Business Fundamentals

    Anonymous review on 4/4/2018
    This class was really good and I really liked the Instructor. Oddly when we Registered we thought we were registering for Mr. Garfield's class but ended up being Pete and we were pleased! When we register for Excel #2 we hope that we get Pete again and not by accident this time : )
See 118 More Course Reviews
loading...
See reviews for other classes at NYIM Training
loading...
Hide Reviews

Review Summary by CourseHorse

Students who took the Excel for Business Fundamentals class generally had positive things to say about their experience. They appreciated the helpful and knowledgeable instructors, specifically mentioning Garfield and Pete as standout teachers. The class covered a range of topics and was well-structured, allowing students to learn and practice various Excel skills. Many students mentioned that they gained valuable knowledge and were able to apply what they learned in their work. Overall, students found the class informative and worth their time. Quotes: 1. "The instructor was amazing - the content was well made, in an order that made sense and easy to follow." 2. "Very good at teaching and answers all questions. Very knowledgeable." 3. "The range of topics covered was very good and the pace of the class was excellent."

Questions & Answers (4)

Get quick answers from CourseHorse and past students.

Question from Theresa R.
Does the classroom provide class computers or do you have to bring your own?
Answer from Georgia C. CourseHorse StaffCourseHorse Staff
Hi Theresa! For in-person classes, the school will provide a computer for use during the course.
Answer Show answer
Cancel
Question from Anonymous
Can I join this class online?
Answer from Brenda L. CourseHorse StaffCourseHorse Staff
Hi, there! You may check their online class here: https://coursehorse.com/online/classes/tech/all-software/microsoft/microsoft-office/excel/excel-for-business-level-i-fundamentals1 Hope this helps!
Answer Show answer
Cancel
Question from Anonymous
Does it matter what version of excel software I am currently using, to be able to follow and use skills taught in class?
Answer from Daniel N. CourseHorse StaffCourseHorse Staff
Students are taught on 2016. For the most part, the skills are transferable, but yes there will be slight differences.
Answer Show answer
Cancel
Question from Kamil B.
Is there a certificate or something after completing this class?
Answer from Georgia C. CourseHorse StaffCourseHorse Staff
Hi there, the school automatically email students their Certificate of Training after the class.
Answer from Kamil B.
Awesome thank you so much
Answer Show all 2 answers
Cancel

Similar Classes

NYIM Training

For nearly two decades, NYIM has trained thousands of business professionals in the latest computer software programs, including Excel, Financial Modeling, Microsoft Office, Adobe, SQL, AutoCAD, QuickBooks, and many more.

The company is known for its practical and hands-on approach to its instructor-led...

Read more about NYIM Training

CourseHorse Approved

This school has been carefully vetted by CourseHorse and is a verified NYC educator.

NYIM Training

NYIM Training

All classes at this location

We are located in New York City on 34th street and Madison Avenue, a few blocks from Penn Station, Port Authority and Times Square. You may also attend this class live online (virtual training) via Zoom. We will reach out with additional information, including the Zoom info and class files.

Also available virtually online

Google Map

Give This Course as a Gift Card

  • Thousands of classes
  • No expiration
  • Unique and memorable gifts for any occasion
  • Personalized
  • Explore a passion, gain a new skill, discover a new hobby, engage in a memorable experience
  • Instant delivery
  • Lock in a price with the Inflation Buster Gift Card Price Adjuster™

Buy a Gift Card

Book this Class as a Group Event

Booking this class for a group? Find great private group events

Or see all Excel Group Events

Explore group events and team building activities ranging from cooking, art, escape rooms, trivia, and more.

CourseHorse Gift Cards

  • Creative & unique gift for any occasion
  • Thousands of classes & experiences
  • No expiration date
  • Instant e-delivery (or choose a date)
  • Add a personalized message
  • Lock in a price with the Inflation Buster Gift Card Price Adjuster™
Buy a Gift Card
gift card with the CourseHorse logo gift card with the CourseHorse logo
Loading...