1. Getting Started with Excel 2016
• Components of the Excel window
• Learn about the Ribbon, Quick Access Toolbar, Backstage view, Office terminology, and all the components that make up an Excel screen
• Features of Excel’s Ribbon
• Quick Access toolbar
• Mini toolbar
• Status bar
• Using the Help menu
2. Excel Best Practices
• Organize folders / files
• Plan worksheet on paper
• List of “Always / Never”
• How to select contiguous / non-contiguous ranges
• Contextual menus
3. Modifying Worksheet Contents
• Understanding Excel cursors
• Edit options
• Undo / Redo
• Save As versus Save
o Different file types that work with Excel
• Move / Copy / Paste
• Fill cells with series of data
• Insert / Delete entire rows & columns
4. Formatting a Worksheet
• Format cells
o Number (General, Currency, Date, Percentage, Text)
o Alignment
o Merge cells
o Font
o Borders
o Fill
• Format Painter
• Change column widths / row heights
5. Performing Basic Calculations
• Excel formulas
• Order of Operations – BEDMAS
• AutoSum
• Functions – Basic Math
o =SUM()
o =AVERAGE()
o =COUNT()
o =MIN(), MAX()
• Relative / Absolute/Mixed Cell Addresses
6. Sort
• How to sort effectively
7. Print Workbook Contents
• Add print commands to the Quick Access toolbar
• Set print range
• Page orientation (Portrait / Landscape)
• Fit to page(s)
Price Based Country test mode enabled for testing Canada. You should do tests on private browsing mode. Browse in private with Firefox, Chrome and Safari
We use cookies to ensure that we give you the best experience on our website. If you continue to use this site we will assume that you are happy with it.Ok
1. Getting Started with Excel 2016
• Components of the Excel window
• Learn about the Ribbon, Quick Access Toolbar, Backstage view, Office terminology, and all the components that make up an Excel screen
• Features of Excel’s Ribbon
• Quick Access toolbar
• Mini toolbar
• Status bar
• Using the Help menu
2. Excel Best Practices
• Organize folders / files
• Plan worksheet on paper
• List of “Always / Never”
• How to select contiguous / non-contiguous ranges
• Contextual menus
3. Modifying Worksheet Contents
• Understanding Excel cursors
• Edit options
• Undo / Redo
• Save As versus Save
o Different file types that work with Excel
• Move / Copy / Paste
• Fill cells with series of data
• Insert / Delete entire rows & columns
4. Formatting a Worksheet
• Format cells
o Number (General, Currency, Date, Percentage, Text)
o Alignment
o Merge cells
o Font
o Borders
o Fill
• Format Painter
• Change column widths / row heights
5. Performing Basic Calculations
• Excel formulas
• Order of Operations – BEDMAS
• AutoSum
• Functions – Basic Math
o =SUM()
o =AVERAGE()
o =COUNT()
o =MIN(), MAX()
• Relative / Absolute/Mixed Cell Addresses
6. Sort
• How to sort effectively
7. Print Workbook Contents
• Add print commands to the Quick Access toolbar
• Set print range
• Page orientation (Portrait / Landscape)
• Fit to page(s)
Details
Organizer
Venue
Fergus, ON N1M 1T7 Canada + Google Map