Course Description
Students will gain the knowledge the skills and the confidence to create, format, enhance and print simple spreadsheets.
PREREQUISITES
The prerequisites for this course are an introductory course to Windows or a solid working knowledge of Windows.
CREATE, OPEN AND SAVE WORKBOOKS
What is Excel?
Create a New Blank Workbook
Create a Workbook From a Template
Open Excel Files
Get Help
Save Workbooks
Navigate a Workbook
Use Zoom
EXPLORE THE USER INTERFACE
Work with Menus
Standard and Formatting Toolbar Overview
Work with Task Panes
Status Bar
Move Toolbars
WORK WITH DATA
Enter, Edit and Delete Data
Data Selection Methods
Use Autofill and Autocomplete
Cut, Copy, Paste and Paste Special
Resize Columns and Rows
Insert and Delete Columns, Rows, Cells
Use Undo, Redo and Repeat
Spellcheck and AutoCorrect
Use Find, Replace and Go To
Use Basic Functions
Use SmartTags and Options Buttons
Add, Edit, and Remove Comments
FORMAT A WORKBOOK
Formatting Toolbar
Format Cells Options
Use Auto format
Use the Format Painter
Create and Modify Styles
Add, Name, Move, Delete and Colour Sheets
CHARTS
Create and Format a Chart
Modify Chart Layout and Structure
Change Chart Types, Options, Location and Data Source
PRINTING AND VIEWING A WORKBOOK
Use the View Menu
Create a Custom View
Split and Freeze
Hide/Unhide Columns, Rows, Sheets and Workbooks
Manage Multiple Windows
Use Page Layout, Print Preview and Basic Print Options
Comments
Prices for locations in Canada are in Canadian Dollars ($CAD)