|
TCET ~ Microsoft Training ~ Adobe Training ~ Macromedia Training Cancellation Policy
Description:
In this course, students will create basic worksheets and charts, enter text and values, work with cells, cell data and copy and move data, use formulas, functions and format worksheets, work with multiple sheets by formatting, repositioning, copying, moving, adding and deleting worksheets, create a chart and set the page display and printing options.
CORE TOPICS
| Getting Started |
Modifying a Worksheet |
- An overview of Excel
- Navigate in Excel
- Select, enter data
- Save a workbook
- Obtain help
|
- Move and copy data between cells
- Fill cells with series of data
- Edit cell data
- Insert and delete cells, columns and rows
- Find, replace and go to cell data
- Spell check a worksheet
|
| Performing Calculations |
Formatting a Worksheet |
- Create basic formulas
- Calculate with functions
- Copy formulas and functions
- Create an absolute reference
|
- Change font size and type
- Add borders sand colour to cells
- Change column width and row height
- Merge cells
- Apply number formats
- Apply an Autoformat and styles
|
| Developing a Workbook |
Printing Workbook Contents |
- Format worksheet tabs
- Reposition worksheets in a workbook
- Insert and delete worksheets
- Copy and paste worksheets
- Copy a workbook
|
- Set a print title
- Create a header and footer
- Set page margins
- Change page orientation
- Insert and remove page breaks
- Print a range
|
| Customizing Layout |
- Split a worksheet
- Arrange worksheets
- Freeze and unfreeze rows and columns
- Hide and unhide worksheets
|
Pre-Requisites: Computer Basics
Certificates offered: Certificate of completion
Duration Details: 1 Day
9:00am - 4:00pm
Facility Location: HBI College
190 Robert Speck Parkway
Mississauga
Ontario
Canada
L4Z 3K3
|
