Microsoft Excel Advanced Workshop
You will have mastered the material in this workshop when you can:
- Rotate text in a cell
- Create a series of month names
- Copy, paste, insert, and delete c ells
- Format numbers using format symbols
- Freeze and unfreeze titles
- Show and format the system date
- Use absolute cell references in a formula
- Use the IF function to perform a logical test
- Use the Format Painter button to format cells
- Create a 3-D Pie chart on a separate chart sheet
- Color and rearrange worksheet tabs
- Change the worksheet view
- Answer what-if questions
- Goal seek to answer what-if questions
To achieve these objectives, we will create a Financial Projection Worksheet with What-If Analysis and a Chart during the course of this workshop.
In order to complete this workshop successfully, you need to have knowledge of the fundamental computing process, components of the computing system, and basic computer terminology, plus minimum keyboarding skills. In addition, you need to be able to perform the tasks from the Intermediate Workshop.