|
C L Douglas ~ Quickbooks, Word, PowerPoint, Project, Excel Training Halifax Cancellation Policy
Description: Level 3 of Excel 2003...
- Streamlining with macros including:
- What is a macro
- Creating and editing a macro
- Documenting, invoking and cancelling a macro
- Useful everyday macros
- Assigning macros to the toolbar
- Assigning macros to buttons and quick keys
- Saving your macros
- Advanced formula creation including:
- Using the IF function
- Using vertical and horizontal lookups
- Working with date functions
- Using auditing features
- Testing for NA
- Customizing the work area including:
- Customizing the toolbars
- Creating your own toolbars
- Creating styles
- Creating templates
- Protecting your worksheets
- Using Data validation
- Creating lookups
- Miscellaneous features including:
- Creating pivot tables
- Creating pivot table from multiple ranges
- Modifying your pivot table
- Creating scenarios
- Using goal seek and solver
- Tips and tricks
- Excel and the Internet
Pre-Requisites: Excel 2003 Intermediate
Certificates offered: Included will all courses are course notes, a pad for note taking and telephone support following the class.
Participants will receive a Certificate of completion
Duration Details: 1 Full day
9:00am - 4:00pm
Facility Location: CL Douglas Training Facility Centre
1142 Bedford Highway
Halifax
Nova Scotia
Canada
B4A 1B8
| 
