Getting the Most from Microsoft Excel Training Class

Excel essentials-10 techniques every

power user should know

_ Installation tips and tricks-including which installation options will enhance your productivity and which

   ones are simply a waste of hard drive space

_ What you need to know about the Excel screen so you can get to work on your projects-fast

_ How to use both a worksheet and a workbook to organize related data in one convenient location

_ How to add flexibility and speed with special keyboard and mouse techniques

_ Discover the quickest methods for selecting cells or ranges of cells in your worksheet

_ Making sense of Excel's unfamiliar terms, tools and commands so you don't always have to refer to the

   Help screen

_ Time-saving shortcuts you can substitute for those cumbersome pull-down menus

_ Keep the right information at your fingertips by learning how to name your worksheets effectively

_ How to get more out of the Help system ??? and stop spending valuable time searching through mounds of

   Useless information

Data, reports, graphs and formulas-

Making the most of Excel's many talents

_ Understanding the difference between data and formulas and when to use each to make your life easier

_ Do your worksheets look the way you want them to? Here's how to use Excel's built-in formatting features

   to make sure

_ How to put things in the correct order by using the Sort function

_ Dramatically speed up data input with the powerful AutoFill feature

_ How to quickly find the data you're looking for on a crowded worksheet

_ Unlocking the secrets of the mysterious fx button so you can easily create the right formula for the job

_ Format or Style? Which to use to get the look you want

_ Demystifying the Chart Wizard feature so you can create professional-looking graphs quickly

   and easily

_ Learn how to make specific cells "stand out from the crowd" with the amazing Conditional

   Formatting feature

_ Printing customized spreadsheets can be a pain unless you know the tricks of Report Manager!

_ Boost your productivity with fast and convenient toolbar formula buttons

_ Master the mysteries of relative and absolute cell addressing- "must-know" information for

   working with formulas

Excel printing made easy-How to solve print problems and get your information to look like  

                                           you want

_ How to make sure your worksheet looks the way you want it to-without printing lots of "test"  

   copies

_ 3 great methods of using the View feature to see your spreadsheet in different ways

_ Too much data? Learn how to print just the section of the worksheet you need

_ Take a guided tour of the Page Setup dialog box and learn how to print your worksheets so

   they're most useful to you

_ Can't get all of your information to print on one page? Learn this secret and you can!

_ Control your data layout with Excel's handy Page Break Preview function

_ Gridlines or no gridlines?

We'll show you how to print either way

_ How to get your pages numbered correctly-no matter what number you start with

_ How to choose the right fonts, borders and text alignments to create eye-catching documents

Excel on the Internet? Special ways to get even more out of this powerful program

_ Introducing the Web toolbar-how to find it and what it's used for

_ How to create and use hyperlinks and move from your spreadsheet to the

World Wide Web in a single mouse click!

_ How to cut down your "surfing" time by using Excel's versatile Favorites folder

_ 7 great built-in tools that'll make browsing faster and more efficient

_ Getting to know HTML-a "must" for working with the World Wide Web

_ How to quickly and accurately publish charts and data on the Internet

_ The quick way to search the Internet-right from within your spreadsheet

_ How to open publicly available workbooks on the Internet or your company's intranet

_ One simple tip that can save you lots of time-and it's just one button

Excel tips, tricks and shortcuts-Get more done in less time and with better results!

_ The secrets to using editing commands that will drastically reduce time consuming data re-entry

_ Paste or Paste Special?- which to use to get the result you really want

_ How to fix the 8 most common errors on the fly with AutoCorrect

_ Secrets of the Merge and Center button and how to use it to create professional-looking headings

_ Working faster and smarter with Excel's multilevel Undo and Redo functions

_ How to avoid needless duplication of effort by using OLE to link your spreadsheet with other Microsoft?? Office documents

_ Want faster editing than cutting and pasting? Try inserting rows and columns!

_ Learn how to format large blocks of cells quickly and efficiently with the power of Format Painter

_ How to maximize your efficiency by turning on only the toolbars you need

_ Automate your everyday tasks by designing your own custom Excel macros

_ Working on a lot of projects? We'll show you how to access more of your recently used files in just 2 steps

_ Multiply the power of the already amazing AutoFill feature by using Custom Lists

Spreadsheets, charts and more-

Easy ways to make spreadsheets and figures into colorful, clear and precise presentations

_ Bar chart, pie chart, line chart-how to choose and use the right graphic to get your point across

_ Using the special features of Chart Wizard to create customized graphs and charts for high-powered presentations

_ How to format data markers on a line chart for maximum clarity and visibility

_ Discover your formatting options and create charts and graphs that demand your audience's attention

_ It's simple-here's how to use Excel's preset fill options to add color and excitement to any chart or graph

_ Using the Series Order feature to rearrange your data for maximum clarity and impact

_ How to use the Trendline command to make complex data more understandable

_ Doughnuts, Bubbles, Radar and more-learn how advanced chart types can capture your audience's  attention

_ Learn the graphic secrets to focusing attention where you want it by removing unnecessary screen elements

_ Fine-tune your charts and graphs for maximum readability with the indispensable Chart Options dialog box

Free to every workshop participant

Comprehensive workshop manual

You'll walk away from this workshop with a workbook containing materials, tips and techniques that took thousands of hours of research to put together-all in one convenient manual you can use over and over again.

Registration. As soon as we receive your pre-registration, you'll receive a confirmation receipt via email from support@trainup.com.You will receive an Express Admission Ticket in addition to your confirmation order receipt, simply take the express ticket with you to the program and hand it to the registrar. If your ticket doesn't arrive before the seminar, be sure to go anyway. The instructors are expecting you! You may register up until the day before the course date.

Cancellations and substitutions. Cancellations received up to five working days before the conference are refundable, minus a $10 registration service charge. After that, cancellations are subject to the entire conference fee, which you may apply toward a future conference. 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.

The check-in table opens at 8:15 a.m. When you arrive at the hotel, please check the directory for the exact location of the workshop. The registrars will greet you, and collect your Express Admission Ticket, hand you  workshop materials and direct you toward your seat. You'll also want to take the opportunity to meet other professionals from your local area. Introduce yourself! You may meet a new friend. Plan to be registered and ready to go by 8:50 a.m.

This class begins at 9:00 a.m. on the dot and wrap up at 4:00 p.m. Lunch is on your own from 11:45 a.m. to 1:00 p.m. Why not invite another participant to dine with you? You can share information, review the morning and make the day even more enjoyable.

Parking.  The best efforts are made to find workshop facilities that have all the pluses : Convenient location, great meeting rooms, courteous staff and plenty of free parking. However, some facilities have paid parking only. You may want to check with the facility personnel to determine parking fees-often they can direct you to free parking just around the corner.

Tape recording.  These programs-both what you see and what you hear-are fully copyrighted. No audio recording or videotaping, please.

Program agenda:

8:15 a.m. - 9:00 a.m. Register and collect materials

9:00 a.m. - 11:45 a.m. Workshop session

11:45 a.m. - 1:00 p.m. Lunch on your own

1:00 p.m. - 4:00 p.m. Workshop session

Seminar materials

And you won't go home empty-handed. You'll leave this workshop with a Certificate of Attendance;

a soundly researched, unabridged workbook; your Personal Action Plan for implementing what you've

learned; and step-by-step guidelines for sharing the new ideas with your associates back at work.

Need one more reason to choose this seminar? The guarantee.

It's simple. If you're not happy, th