Topics covered in Full Day Course
| 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 |
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.