Microsoft Excel: Excel Basics

Complete Seminar Details

Covers Excel 2003 and all previous versions.

Are your staff members worn out by trying to teach themselves how to use Excel?

Most people learn Excel by trial and error. That is probably how your staff has "learned" it. They've spent a lot of time trying to figure out how to do some basic tasks, never scratching the surface of this powerful package. They are likely frustrated and more than a little intimidated by the dozens of mysterious tools and features. Is this a good use of company time?

Let us spend one day with your Excel users and we'll turn that problem around! Once they understand the tools, shortcuts, and efficient techniques, a whole world of possibilities will open up for them!

Participants will learn how to:

• Navigate using an indispensable "map" to the Excel environment
• Build a worksheet framework that will accomplish objectives
• Customize the Excel toolbar and options for maximum personal productivity

Who will benefit...

This seminar is perfect for both beginners and users with some experience. We suggest that you have some knowledge of Excel basics. The course is especially effective for beginners who want to learn more as well as intermediate users who want to sharpen their skills and tap into Excel's more powerful functions.

How we present this material...

This is not a hands-on training and for a good reason. Everyone works on computers at a different speed. Some people like to experiment, others get lost and need help. In the long run, a hands-on class slows everyone down. Besides, you don't need practice moving your mouse. You do need to know how your new system's features work, how to use them and where to activate them.

Key learning points…

• How to move around in big worksheets with lightning speed
• Customize Excel for the way you work - You can set up Excel as if you designed it yourself!
• Simplify cryptic formulas and functions · Constructing macros to save time and reduce errors
• Printing options that enhance your final worksheet output
• Taking control of toolbars
• Speed commands and automate repetitive work

As a result of this training...

Your staff will gain the confidence that comes with knowing a great software tool. In just six hours, they will learn an array of techniques, how to troubleshoot common problems, and how to save time using Excel's powerful capabilities.

Program Agenda

• How to use the toolbar buttons to perform tasks quickly
• Learn how to access commands for any task using drop-down menus and shortcut menus
• How to find the Help you need without endless searching and scrolling
• Two methods for selecting cells and ranges of cells
• Step-by-step, how to create, open and close Workbooks
• Finding a file or workbook quickly

Entering and editing data

• Tips for entering text and numbers
• How to "backtrack" with Excel's Undo feature
• Use routines to replace data, correct errors, or see "what if" scenarios
• How to copy and move data without anxiety
• How to change the organization of your worksheet by inserting and deleting rows and columns
• The quick, fail-safe procedure to erase a cell or range of cells

Formulas made easy

• Formula and Function basics that will end confusion once and for all
• How to subtract, multiply, and divide data using mathematical formulas
• Basic Excel functions to calculate averages, percentages, and more using "built-in" formulas
• Save time by copying formulas to appropriate cells in the worksheet

Formatting your worksheet

• Five formatting guidelines for attractive, readable worksheets
• Controlling alignment, dollar signs, decimals, and more in one easy operation
• How to format dates to be more readable and understandable

Perfect printing

• Understanding the many choices Excel offers to customize printing
• How to print a portion of a worksheet by selecting the print area
• Ensuring that titles and labels print on every page
• Using Print Preview to eliminate wasteful "printer surprises"

Producing charts and graphs

• Easy-to-understand glossary of terms used in charting and graphing data
• How to choose the appropriate type of chart for your data
• Product vivid, exciting charts using the Chart Wizard
• How to change the size, shape, or type of chart in just a few steps

Tips, techniques, and time-savers

• How to "hide" sensitive data
• Managing large worksheets with Split Windows
• How to give ranges a name that will be easier to remember than obscure cell addresses
• A practical guide to database basics to get you started
• Take the mystery out of macros to automate tasks and save time

Sponsor Background:

Today, with more than 5,000,000 satisfied customers, we continue to pride ourselves in providing the superior training you’ve come to expect from Fred Pryor Seminars and CareerTrack. Our cutting-edge research and course development are designed to meet the adult learning needs of your employees and your organization.

Fred Pryor and CareerTrack are your number one choices for training because we offer:

• In-depth experience in the training industry
• Consistent and comprehensive course offerings
• High energy and content-rich presentations
• Multiple training tools, including on-site training, on-line learning, seminars, and a/v products
• 100% Satisfaction Guarantee

As we continue to grow, expand, and change to meet client and market needs, we always remember that every individual customer matters and that collectively, they are our most valuable assets. That’s why our goal is the same today as it was 30 years ago – to provide the best choice in business skills training with maximum convenience to help you – our customer – achieve success!

Cancellation Policy: You may cancel your registration up to 10 business days before the seminar. Your registration fee will be refunded less a cancellation fee. If you need to cancel less than 10 business days prior to the seminar you may (1) send a substitute from your organization or (2) transfer your registration fee within 12 months to another seminar or conference of your choice. Please note that if you don't cancel and don't attend, you are still responsible for payment. Substitutions may be made at any time.