Excel 2003 Power User, 2nd Edition Study Guide

1-4188-9065-0 © 2007 Publish date: February 27, 2006 124 pages

Buy Now: $25.99

Course ID: excel-2003-power-user-2nd-sg

Have you worked through our series of Excel computer training books from beginning to advanced and find yourself craving more? If so, you're ready to move on to the Excel 2003 Power User study guide. This course, rated 4.8/5.0 in overall quality by ProCert Labs, is specially designed for advanced Excel users who want to learn the more powerful features of Excel including using formulas, functions, arrays, and add-ins to manipulate and analyze data.

As a power user, you will know how to use the advanced formulas, arrays, and functions, how to paste data using the Paste Special command, analyze and share data, perform advanced formatting, and customize the Excel environment. In addition, you will know how to automate many tasks.

The Excel 2003 Power User courseware also shows you how to use wizards and tools for adding commands and functions along with how to use the tools found in the Analysis ToolPak to analyze your data.

You will be well on your way to becoming a Power User by choosing this manual. The Microsoft Excel training course consists of five self-directed units and contains many hands on assignments designed to teach you these advanced techniques. As you learn how to work with these complex functions, you will learn how to take your data and analyze it. The Excel 2003 Power User courseware is an excellent tool to teach you these techniques.

Course Objectives

By following this course, you will learn how to work with the text and information functions, how to enter array formulas, and how to apply labels in formulas. You will also learn how to paste only certain parts of cell data, how to select cells containing certain types of data or formatting, and how to use advanced formatting techniques.

You will also learn about the built-in, custom chart types used to display data in unusual ways, how to graphics in your worksheets and charts, and how to create user-defined chart types.

Other topics include wizards for adding commands and functions, the advanced Solver features, Analysis ToolPak tools, embedding and linking objects, custom lists, changing default settings, AutoRecover, AutoCorrect, and smart tags.

Course Contents

Unit 1 introduces advanced formulas, functions, and arrays

• Text functions
• Information functions
• Array formulas
• Labels

Unit 2 covers advanced editing and formatting

• Paste Special command
• Go To Special dialog box
• Advanced formatting features

Unit 3 discusses advanced graphics

• Creating custom charts
• Using pictures and images

Unit 4 covers analyzing and sharing information

• Working with add-ins
• Solver models and reports
• Statistical analysis tools
• Embedding and linking

Unit 5 discusses advanced customization

• Custom lists
• Changing default settings
• Automating Excel