|
|
|
Microsoft® Excel for Power Users 1b: Formatting, Managing, & Customizing Workbooks
|
Prerequisites
Basic Windows® skills, working knowledge of Excel, and Microsoft® Excel for Power Users 1a: Creating & Modifying Worksheets (S 101).
Course description
Custom Training Course Learn how to be more effective when using Excel. This 1/2 day course is designed to review four major components of the software program in order to help you become more efficient and successful.
Why take this course?
Learn to streamline repetitive tasks and display spreadsheet data in more visually effective ways. In this course, you will use Microsoft® Excel 2003 to streamline and enhance your spreadsheets with improved layout and formulas.
What you will learn
You will learn to format worksheets and develop workbooks, as well as printing and layout techniques.
Topics covered include
Formatting a Worksheet
- Change Font Size and Type
- Add Borders and Color to Cells
- Change Column Width and Row Height
- Merge Cells
- Apply Number Formats
- Create a Custom Number Format
- Align Cell Contents
- Find and Replace Formats
- Apply an AutoFormat
- Apply Styles
Developing a Workbook
- Format Worksheet Tabs
- Reposition Worksheets in a Workbook
- Insert and Delete Worksheets
- Copy and Paste Worksheets
- Copy a Workbook
Printing Workbook Contents
- Set a Print Title
- Create a Header and a 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
Follow up courses
|
Course details
Course: S 201
Duration: 1/2 Day
Fee:
| Members: |
|
112.00 |
| Non-Members: |
|
160.00 |
Instructor:
|
|
|
|
