- Applying & Using Range Names
- Date Calculations
- Vertical (VLOOKUP) and Horizontal (HLOOKUP) lookup tables
- Basic macros
- Editing Visual Basic code (basic)
- Adding dialog boxes to 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 t to the right of the Name Box and click the range that you want to go to. This 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)
Manual Included
After-course email and telephone support included
Contact us for on-site training prices
Maximum 10 Students.
Please
click here to view schedule
Please
click here to view map
|