|
Technology Training Centre ~ Excel Word Training in Edmonton Cancellation Policy
Description: This course is designed for new Excel users who require the skills necessary to set up a spreadsheet and use basic business spreadsheet functions. Students will become familiar with Excels command menus, filing workbooks, and basic editing tools. The course will also show students how to create simple formulas, use built in functions as well as an introduction to relative and absolute references. Participants will learn to manipulate windows for better viewing as well as work with cut/copy/paste features to move data, format their worksheet and prepare headers and footers for printing.
Course Content
Getting Started
- Starting Microsoft Excel 2003
- The Excel 2003 Window
- Excel Toolbars
- Excel Menus
- The Help Menu
- The Help Task Pane
- The Office Assistant
Managing Workbooks
- Creating a Blank Workbook
- Opening an Existing Workbook
- Saving Workbooks
Excel Data
- Types of Data
- Entering Data
- Moving around in Excel
- Changing Column Size
- Selecting Cells
- Entering Data in a Range
- Range
- AutoFill
- AutoComplete
- Replicating Data upon Entry
Editing in Excel
- Edit Mode
- Cut and Paste
- Copy and Paste
- Moving Cells by Dragging and Dropping
- Copying Cells by Dragging and Dropping
- Undo and Redo
- Inserting Cells
- Deleting Content of Cells
- Inserting Rows and Columns
- Deleting Rows and Columns
- Go To Feature
- Spell Checking
Excel Formulas
- Creating Formulas
- Relative and Absolute References
- Circular Reference
- Sum and Average Formulas
- AutoSum and Other Automatic Functions
Formatting in Excel
- Formatting Cells
- Numbers
- Fonts
- Alignment
- Borders
- Patterns/Colour
Window Manipulation
- Zoom
- Freeze and Unfreeze Panes
- Split Panes
Printing in Excel
- Page Setup
- Page Setup Page Tab
- Page Setup Margin Tab
- Page Setup Sheet Tab
- Page Setup Headers and Footers
- Print Preview
- Print
Excel Options
Pre-Requisites: Basic computer concepts/skills and knowledge of Windows
Certificates offered: Certificate of completion
Duration Details: 1 day
9:00am - 4:00pm
Facility Location: Edmonton Training Center
B-11 Cameron Library
University of Alberta
Edmonton
Alberta
Canada
T6G 2J8
| 
