Beginner Microsoft Excel

Master Calculations, Formulas, & Functions

  • tag-solid $209
  • 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
All Microsoft Excel Courses Beginner Microsoft Excel

This beginner Excel course covers the fundamentals, including basic formulas, functions, formatting, printing, charts, & calculations. We'll also introduce you to some essential shortcuts to start boosting your speed. This class is the perfect introduction to Excel that will help you set a solid foundation in the software.

Hands-on Beginner Excel Training

Our intro Excel class is hands-on and uses real-world examples throughout the training. The instructor will first explain the concept along with a example, and then you'll perform an exercise on your own. Our step-by-step training manual is the perfect reference guide for during and after the class.

Revolutionary Excel Video Suite & Free Retake

You'll also receive access to our premium Beginner Excel video suite, which has the lessons on high-quality video that can be viewed on desktop, mobile and tablet.

And just in case you need a refresher, you can retake the class anytime within 6 months of the course (provided there is an available seat in the class).

With all these revolutionary resources, you're virtually guaranteed to walk away with a solid foundation in Excel.

Upcoming Class Dates

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

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