Placeholder image

Microsoft Excel Courses

    Call 516 482-2323 for more information

Microsoft Excel

Gloria K offers both beginning and intermediate/advanced courses in Microsoft Excel. These courses may be taken individually, but many students take both levels.

We offer group as well as one-on-one training. The course is hands on with you performing the exercises and real-world projects. An experienced, New York State licensed instructor will guide you, clarify information and answer questions. Our facility is located in Lake Success, NY.

Daytime Classes

    Our day classes meet five days Mon-Fri from 9 am to 12:50 pm.
    The course is 20 hours in total.
    Class sizes are small (usually 5 or 6 students).
    Textbooks are available for loan (no charge) or purchase.

If you are interested in day classes, please call us at 516 482-2323 or fill out the form on this page. Appointments are available to visit the school and observe a class in progress.

We also offer Evening and Saturday clases. If you are interested, click the corresponding link below:

Excel Beginning

This course is designed for those that want to learn Excel from the start or refresh a basic knowledge of the program. Even with some familiarity with Microsoft Excel, there is always something new to be learned from our Excel beginning course.

  • Create, save, and navigate an Excel workbook
  • Enter and edit data in a Worksheet
  • Construct and copy formulas, Use the sum function, and edit cells, use the Autofill feature
  • Format data, cell, and Worksheets
  • Close and reopen a Workbook
  • Chart data
  • Use Page layout View, Prepare a Worksheet for Printing
  • Design a Workseet
  • Creating and formatting Sparklines
  • Construct formulas for Mathematical Operations
  • Format percentages and move formulas
  • Create a pie chart and chart sheet
  • Use the Excel Help system
  • Create and Save a Workbook from an Existing Workbook
  • Navigate a Workbook and Rename Worksheets
  • Enter Dates, Clear Contents, and Clear Formats
  • Move, Copy, and Paste Cell Contents
  • Edit and Format Multiple Worksheets at the Same Time
  • Create a Summary Sheet (more)
  • Format and Print Multiple Worksheets in a Workbook
  • Design a Worksheet for What-If Analysis
  • Perform What-If Analysis (more)
  • Use SUM, AVERAGE, MEDIAN, MIN, and MAX Functions
  • Use COUNTIF and IF Functions, and Apply Conditional Formatting
  • Using the NOW Function
  • Freeze Panes and Create an Excel Table
  • Format and Print a Large Worksheet
  • Use Financial Functions, PMT
  • Designing a Loan Worksheet

Excel Intermediate

This course is for students that are already comfortable with their basic knowledge of Excel and want to take their knowledge to the next level.

  • Use Goal Seek
  • Create a Data Table
  • Open an Excel Template
  • Customize a Template
  • Save a Workbook as a Template
  • Enter Data in a Customized Template
  • Create Range Names
  • Ensure Data Integrity/Validation
  • Use Lookup Functions - VLookup and HLookup (more)
  • Protect the Worksheet and Save it as a Template
  • Import Data into Excel
  • Clean-up Data from External Sources
  • Analyze Data with Excel Database Tools
  • Use Database Functions
  • Create and Modify PivotTable Reports (more)
  • Create PivotChart Reports
  • Compare Dates and Round Numbers
  • Apply Business Decisions with Logical Operators
  • Insert Comments and Document a Workbook
  • Record a Macro

Fill out the form below and click submit

Instead of the form, I would rather:

About Us

Gloria K is a NYS Licensed computer training center centrally located in Nassau County, Long Island, NY. We offer corporate training and training to individuals. Our class sizes are small, typically fewer than eight students. All of our courses are taught with a live instructor. Each student sits at their own computer in a modern setting. We offer additional courses in Microsoft Office, such as Word, Excel, PowerPoint, Access and Outlook, and we also offer a QuickBooks course.

We serve all of Nassau, Suffolk and Queens including areas such as Mineola, Westbury, Great Neck, Manhasset, Roslyn, Franklin Square, Garden City, Hicksville, Little Neck, Williston Park, New Hyde Park, Levittown, Bellmore, Massapequa, Huntington, Bayside, and Douglaston.

Contact Us

Gloria K School
1979 Marcus Avenue, Ste C100

Lake Success, NY 11042
P: (516) 482-2323

Copyright © All rights reserved.