212-828-7089
Excel on YouTubeExcel Class NYC Faceook PageExcel Class on LinkedInExcel Class on TwitterExcel Class on YelpExcel on BloggerExcel on Wordpress

Return to Excel

Introduction

Introduction to Excel Training

Introduction to ExcelLearn Excel fundamentals in a one day class. Formulas include Vlookup, SumIfs, and PivotTables. Database topics include sort and filter. Extensive lesson on formatting. Brief lesson on charts. Courses are hands-on and include practice exercises. Course includes an 85 page manual! The only class to offer a library of over 150 self assessment tests. The only class to offer 40 minutes of Vlookup and 40 minutes of Pivot Tables! A fast paced intensive boot camp.

class schedules

Course Schedules

Individuals
July 3rd 9am Full
July 8th 9am Full
July 16th 9am
July 22nd 9am
July 25th 10am
August 7th 9am
August 16th 10am
August 19th 9am
August 29th 10am
Companies
Register 4 or more students for a discount – Choose one full day or two half days
Contact Us Or Click For Quote
registerLength: 1 full day
Price: $209

Frequently Asked Questions

frequently asked questions

  • What time does class start?
    Weekday classes start at 9am
    Weekend classes start at 10am
  • Do I need to bring a computer?
    We provide a Windows computer.
  • Do I receive a certificate?
    Yes, upon completion you will receive an attractive gold foil certificate.
  • Are there any prerequisites?
    Ability to use a mouse and a keyboard. Familiarity with advanced Excel Index Match functions helpful.
  • Where are you located?
    31 West 34th StreetNear Penn Station, NJ Transit, and the N, Q, R, W, B, D, F, 1, 2, 3, A, C, E trains.
  • Can I retake the class?
    Yes, where most training has a time and retake limit we offer unlimited retakes.

About The Instructor

Glenn Harris is a Microsoft Certified Technical Trainer and Office Master Instructor with 20 years of classroom experience. He has published many training manuals on Microsoft products. NYC Training is the only class that offers programmed self-assessment labs and online access to videos of Glenn teaching class (to himself).
microsoft certified trainer
microsoft office master
certified technical trainer

Select Corporate Clients

AIGAmerican ExpressBarneysColumbia UniversityDouglas EllimanGoldman SachsHarvard ClubMRM McCannNBCRalph LaurenUBSUnivision

Introduction Outline

pdf outlineDownload a PDF

  • Lesson 1: Terminology
    • Start Excel
    • Open Excel Workbooks
    • Worksheets
    • Cells
    • Ribbon
    • Keyboard
    • Mouse
    • Zoom
  • Lesson 2: Navigation
    • Navigate cells
      • Keyboard navigation techniques
      • Mouse navigation techniques
    • Navigate sheets
      • Keyboard navigation techniques
      • Mouse navigation techniques
    • Goto
  • Lesson 3: New workbooks
    • Templates
    • Blank
    • Add sheets
    • Name sheets
    • Move sheets
    • Copy sheets
    • Tab color
    • Freeze panes
    • Table
    • Insert/delete rows/columns
  • Lesson 4: Edit Text
    • Data entry techniques
    • Cut, Copy, Paste
    • Shortcuts
    • Autofill
    • Undo
  • Lesson 5: Formulas
    • Addition, subtraction, multiplication, division
    • PEMDAS and the order of operations
    • Autosum
    • Average
    • Absolute references
    • Today Function
    • Payment Function
    • SumIfs
    • Vlookup
    • PivotTables
  • Lesson 6: Format
    • Column widths and row heights
    • Font
      • Name
      • Size
      • Bold
      • Borders
      • Cell fill color
      • Font color
    • Alignment
      • Horizontal and vertical
      • Orientation and rotation
      • Wrap text
      • Merge and center
      • Number formatting
      • Currency and accounting
      • Percentages
      • Decimals
      • Dates
      • Zip codes
      • Tables
  • Lesson 7: Print
    • Views
    • Orientation
    • Rows to repeat
    • Headers and footers
    • Export a PDF
  • Lesson 8: Charts
    • Create charts
    • Column charts
    • Pie charts
    • Apply chart styles
    • Change colors
    • Format axis
    • Add data labels
    • Move chart
    • Switch row and column
    • Edit data series
  • Lesson 9: Excel resources
  • Appendices:
    • Keyboard shortcuts
    • Paste special
    • Excel cursor shapes
Summary
Event
Introduction to Excel Training
Location
Excel Class, 31 West 34th Street,New York City,New York-10001
Starting on
July 16, 2020
Ending on
July 16, 2020
Description
Learn Excel fundamentals in a one day class. Formulas include Vlookup, SumIfs, and PivotTables. Database topics include sort and filter. Extensive lesson on formatting. Brief lesson on charts.
Offer Price