Course Category: |
Technology & Computer Applications |
Course Overview: |
Before attending the Advanced Excel class, you should know how to:
*Use the Insert Function tool
*Select multiple non adjacent columns
*Run a sub-total on data
*Assign and understand the difference between a relative and absolute cell reference
*Create a formula that references cells in different worksheets
*Select multiple worksheets and perform a task once for all of the selected sheets
*Apply filtering to a data set.
*Display formulas versus formula results
*Create a data table
*Use Data Validation to create dropdown lists
This interactive workshop will help you become the Excel guru in your office! Participants will:
1) Customize and protect worksheets.
2) Merge a database.
3) Use the function wizard.
4) Discover the power of using absolute vs. relative values.
5) Nest functions and formulas inside other functions and formulas.
6) Use Pivot Tables to manipulate and report data.
7) Program Macros to speed up tasks.
8) Create formulas that reference other worksheets and workbooks.
9) Manage links between workbooks.
10) Learn more about advanced functions.
Prerequisite: Intermediate Excel or knowledge of Excel is recommended.
NOTE: If you would like to save copies of the examples used, please bring a flash drive to the workshop.
Before attending the Advanced Excel class, you should know how to:
Use the Insert Function tool
Select multiple non adjacent columns
Run a sub-total on data
Assign and understand the difference between a relative and absolute cell reference
Create a formula that references cells in different worksheets
Select multiple worksheets and perform a task once for all of the selected sheets
Apply filtering to a data set.
Display formulas versus formula results
Create a data table
Use Data Validation to create dropdown lists. |