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

 

(continued)

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 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.