Gloria K Full Day Intermediate Excel Course


Topics covered in Full Day Course

Excel Full Day Intermediate Class

Creating an Excel Table/Database
Creating summary statistics for an Excel table: Average, Min, Max, Count
Working with logical functions: If and CountIf
Sorting data
Filtering data
Using Goal Seek to Perform What-If Analysis



Coverting a table to a range
Financial Functions and Using Goal Seek for Financial Functions
View, Format and Printing Large Worksheets
Working with Lookup Functions: VLookup and HLookup

Contact Us

Gloria K School.
1979 Marcus Avenue, Suite 100
Lake Success, NY 11042
P: (516) 482-2323

About Gloria K

Gloria K is a NYS Licensed computer training center centrally located in Nassau County, Long Island, NY. Our class sizes are small, typically fewer than eight students. All of our courses are taught with an live instructor.

Each student sits at their own computer workstation in a modern classroom setting. We offer additional courses in Microsoft Office, such as Word, Excel, PowerPoint, Access, Outlook, and QuickBooks.

We are centrally located on Long Island, serving Nassau, Suffolk and Queens. We serve many communities, some of which include, but not limited to: Mineola, Manhasset, Westbury, Hicksville, Great Neck, Roslyn, Franklin Square, Garden City, Little Neck, Williston Park, New Hyde Park, Levittown, Bellmore, Massapequa, Huntington, Bayside, and Douglaston.