- Applying & Using Range Names
- Date Calculations
- Vertical (VLOOKUP) and Horizontal (HLOOKUP) lookup tables
- Basic Excel macros
- Editing basic Visual Basic code in Excel
- Adding dialog boxes to Excel macros (making them interactive)
- Adding macros to the toolbar
- Pivot tables
- Creating
- Customizing
- Removing items from a table
- Changing/removing sub-totals
- The Format Report button
Hot Tip: See the “Name Box” just above columns A & B? Once you use the Name command to name ranges of cells, you can click the down-arrow to the right of the Name Box and click the range that you want to go to. This nifty Excel feature is terrific for moving around really large spreadsheets quickly. This is
just one of the many tips that you will discover in our 1-day Excel computer training courses (onsite and classroom).
COURSES COST:
$165 per person (+ GST)
9am - 4pm (approx)
Excel manual included
After-course email and telephone support included
Contact us for on-site (Toronto, GTA, or anywhere in Ontario) Excel training prices
Maximum 10 Students.
Please
click here to view schedule
Please
click here to view map
|
