|
|
 |
 |
 |
 |
 |
 |
|
|
|
 |
|
|
Microsoft Excel - Level 2 |
|
|
 |
|
|
|
 |
 |
 |
|
 |
 |
|
 |
 |
|
 |
 |
 |
 |
|
 |
 |
|
|
 |
|
At the completion of this course participants will be able to:
• work with one or more workbooks at once
• use a range of techniques to work with worksheets
• adjust the sizing of columns and rows in a workbook
• use a variety of viewing techniques to view worksheets
• format cells in a workbook
• understand and use absolute referencing in a workbook
• use the fill technique to enter data into cells
• use names and labels
• use a range of logical functions
• use the various Lookup functions
• sort data in lists in a workbook
• use autofilter to display data in lists selectively.
Target Audience
This course is intended for current Microsoft Excel users who wish to extend their
knowledge and skills beyond building simple workbooks.
Prerequisites
This course is designed for current Microsoft Excel users who can build basic
workbooks. It is assumed that the user will know how to create and save a workbook,
enter simple formulas, and print and chart data.
Duration:
1 Day
|
|
|
|
|
|
 |
 |
|
 |
 |
 |
 |
|
 |
 |
|
|
|
|
