Intermediate Excel

Program Length: 2 Days

Program Overview
Creating a worksheet with formulas and charts:
• Rotate text in a cell
• Create a series of month names
• Use the Format Pointer button to format cells
• Copy, paste, insert, and delete cells
• Format numbers using format symbols
• Freeze and unfreeze titles
• Show and format the system date
• Use absolute cell references in a formula
• Use the IF function to perform a logical test
• Show and dock toolbars
• Create a 3-D Pie chart on a separate chart sheet
• Color and rearrange worksheet tabs
• Change the worksheet view
• Goal seek to answer What-if questions
• Print titles on every page
• Setting up a worksheet to print
• Protect a Worksheet
• Hide and Unhide row, columns, and sheets
• Create and use a template
• Use the ROUND function
• Add a worksheet to a workbook
• Assign comments to a cells
• Add a header or footer, change margins and insert a page break
• Linking workbooks
• Create a formula that integrates several worksheets

There will be hands-on practice exercises in class. This will help reinforce techniques taught by 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