Microsoft Excel Courses

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

We offer group as well as one-on-one training. Our facility is located in Great Neck, NY.

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 Date in a Worksheet
• Construct and Copy Formulas, Use the Sum Function, and Edit Cells
• Format Data, Cells, and Worksheets
• Close and Reopen a Workbook
• Chart Data
• Use Page Layout View, Prepare a Worksheet for Printing l
• Design a Worksheet
• 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
• Format and Print Multiple Worksheets in a Workbook
• Design a Worksheet for What-If Analysis
• Perform What-If Analysis
• 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
• Designing a Loan Worksheet
  

Excel Intermediate/Advanced

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.

Course Outline:

• 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
• 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
• Create PivotChart Reports
• Compare Dates and Round Numbers
• Apply Business Decisions with Logical Operators
• Insert Comments and Document a Workbook

If you are interested in our Microsoft Excel courses you can call the school directly at 516-482-2323 or
718-423-4444.

If you would like to view our other offerings, we have provided a listing and descriptions for our other courses.

Our class sizes are small, usually no more than eight students per class. Each student will work on their own computer in a comfortable environment.

All of our instructors are experienced and licensed by the New York State Education Department. The school is also licensed by New York State.

We offer flexible schedules, including day, evening and Saturdays.

So contact us today so that you can be prepared for the future!