Create, save, and navigate an Excel workbook
Enter data in a worksheet
Selecting techniques
Contruct and copy formulas
Using AutoSum
Create a basic chart
Formatting cells and using cell styles
Merge and Center for Titles
Adding and changing a workbook theme
Modifying workbook layouts: Adding and deleting rows and columns
Changing column widths and row heights
Printing Workbooks, working with print options
Headers and Footers
Half Day Beginner plus these additional topics:
Creating an Excel Table
Print and view options for larger workbooks
Use Functions such as SUM, AVERAGE, MIN, and MAX in a database
Sorting and Filtering
Formatting cells: Merge and center, cell styles
Changing a workbook themes
Additional formulas using arithmetic operators
Using absolute cell references
Calculating percentages
Creating and formatting sparklines
Using Autofill
Column charts
Logical Functions: If and CountIf Functions
Conditional Formatting
Using Goal Seek to perform What-If Analysis
Pie Charts
Creating summary sheets
Creating an Excel Table/Database
Creating summary statistics for an Excel table:
Average, Min, Max, Count
Percent change calculations
Sorting and filtering data
Analyzing trends with a line chart
Half Day Intermediate plus these additional topics:
Naming cells and managing names
Working with Lookup Functions: Vlookup
Setting up a lookup form
Creating PivotTables and working with PivotTable options
Creating and modifying a PivotChart
Recording a Macro
Assigning shorcut keys or buttons to a Macro
Modifying a Macro by changing the Visual Basic code
Gloria K is a NYS Licensed computer training center centrally located in Lake Success, 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.
We are centrally located on Long Island, easily accessible from Nassau, Suffolk and Queens. We serve many communities, including 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.