Microsoft Excel – Advanced

Program Length: 2 Days

Program Overview
Creating a worksheet with formulas and charts:
• Use name command
• Custom borders and background
• Conditional formatting
• Use If, VLOOKUP functions
• Protect a worksheet
• Define a range
• Validate data
• Creating a data form
• Sort a list
• Automatic subtotals
• AutoFilter
• Advanced filter command
• Extracting records
• Create and use a template
• 3D reference
• Record a Macro
• Auditing formulas
• Import Data
• Create a Pivot Table
• Compare and Merge Workbooks
• Add a trend line to a Chart

There will be hands-on practice exercises in class. This will help reinforce techniques taught by the instructor.
This course requires a minimum number of participants. Please contact us should you wish to set up a training date or would like to request further information.

Contact Information
training@northern.on.ca