Course ID: 13344 | Course Duration: 1 Day | CEUs: CEU Credits: 0.5 CPE Credits: 6

Course Dates:

Getting the Most from Microsoft Excel Training Class

Course ID: 13344

Getting the Most from Microsoft Excel Training Seminar

Packed with practical, ready-to-use techniques and time-saving tips that will help you accomplish much more every time you use this powerful program-without using student computers. It's designed to teach specific "how-to" and problem-solving skills to users who already know the basics of computers and software.

Here's what you'll learn:

Excel essentials

10 techniques every power user should know

Data, reports, graphs

and formulas

Making the most of Excel's many talents

Excel printing made easy

How to solve print problems and get your

information to look like you want

Excel on the Internet?

Special ways to get even more out of this

powerful program

Excel tips, tricks and shortcuts

Get more done in less time and with

better results!

Spreadsheets, charts and more

Easy ways to make spreadsheets and figures into

colorful, clear and precise presentations

Full course schedule listed below!

Includes all versions of Excel for both Windows?? and Macintosh

What can this Workshop do for you?

You'll get more done in less time

Do you have more to do than you can get done each day? This new workshop will show you how to work smarter, not harder. You'll learn how to breeze through all types of spreadsheets, forecasts, graphs and other financial reporting using little-known shortcuts and time-saving techniques that will leave you with professional results and time to do other things.

You'll increase your abilities

Do you ever find yourself searching through an Excel manual ??? wishing you had an Excel expert to ask ??? or even giving up in frustration by "working around" features that you know Excel is capable of because you don't know how to use them? Well, this workshop will show you how to use (and remember) those important features, how to troubleshoot and fix common problems and how to end your Excel frustrations for good plus much more. After the workshop, you'll be the one others are coming to for advice and assistance!

You'll build skills and learn techniques you can use immediately

This workshop isn't full of dry theories or textbook explanations. It's a fast-paced, comprehensive day of practical, useful information ??? rich with details and "how-to" methods that reflect how real people use Excel to do their jobs every day. The instructors are great speakers, but they're also chosen for their real-world experience and plain-spoken teaching style, so what you get is exactly what you can use your next day at work.

You'll learn and retain more in one day than you can imagine

Studies of Excel training have been done to show that adults excel and retain that knowledge better through this unique "reinforced demonstration" teaching methods-without using student computers. After all, this workshop isn't about teaching beginners how to use the keyboard or increase "point-and-click" skills. It's designed to teach specific "how-to" and problem-solving skills to users who already know the basics of computers and software. Plus, you won't be waiting for others to finish so you can progress!

You'll get great resource materials

Not only will your head be full of useful information at the end of the day, you'll also go home with a comprehensive, detailed workbook full of examples, screen capture photos, step-by-step instructions and your notes from the day. Your workbook will be the perfect refresher for questions or clarification on what you've learned, and it's a great resource for any other Excel functions or operations you'd like to learn about.

This course comes with a money-back guarantee

This course guarantee you'll be happy with what you learn during this workshop or a return your registration fee. It's that simple-and the workshop is that good.


	Agenda
	*WORKSHOP AGENDA* Program hours: 9:00 a.m. - 4:00 p.m. 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.


	Pre-requisites
	This workshop qualifies for 6 contact hours (.6 CEUs) in accordance with guidelines set forth by the International Association for Continuing Education and Training-Authorized Provider number 3307. You must attend the entire program to qualify for CEUs. Many national, state and local licensing boards and professional organizations will grant Continuing Education credit for attendance at our workshops You may want to contact your own board or organization to find out what's required. Registered with the National Association of State Boards of Accountancy (NASBA) as a sponsor of continuing professional education on the National Registry of CPE Sponsors. State boards of accountancy have final authority on the acceptance of individual courses for CPE credit. Complaints regarding registered sponsors may be addressed to the National Registry of CPE Sponsors, 150 Fourth Avenue North, Nashville, TN 37219-2417. This workshop qualifies for 6 CPEs. No prerequisite courses, advance preparation or


	Comments
	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, the instructors are not happy. If you're not absolutely delighted with the value and benefits to be gained from this workshop, tuition is fully refundable or choose to attend another seminar given by this course sponsor. You'll learn: Essentials build your arsenal of commands, formats, functions and tools, plus learn tricks and shortcuts that'll make your spreadsheets sizzle Troubleshooting skills ??? solve your toughest and most frustrating problems-including printing, editing, formula errors, deciphering and eliminating error messages and more How to easily create flawless spreadsheets, financial reports, presentation-ready graphs, charts and maps and professional-looking graphics Excel for the Internet and intranet ??? format data and files for e-mail, insert hyperlinks, prepare, spreadsheets, graphs and more for presentation and storage, even build a Web page using Excel! Power user's tips, techniques and shortcuts ??? all the special secrets you'd love to know on making Excel an even faster, more powerful and flexible resource: Macros, Auto functions, hidden tools and commands, templates, importing/exporting, reports, customizing and many more If you are looking for a "hands-on" instructor-led training please see the suggested Training Courses: Excel 2003 - Level 1 Training Class (Beginners Course) Course ID: 5972 http://www.trainup.com/Information-Technology-Training/Microsoft-Office/Microsoft-PowerPoint/Microsoft-Excel/Excel-2003---Level-1-5972.htm Excel 2003 - Level 2 Training Class (Intermediate Course) Course ID: 5973 http://www.trainup.com/Information-Technology-Training/Microsoft-Office/Microsoft-PowerPoint/Microsoft-Excel/Excel-2003---Level-2-5973.htm Excel 2003 - Level 3 Training Class (Advanced Course) Course ID: 5974 http://www.trainup.com/Information-Technology-Training/Microsoft-Office/Microsoft-PowerPoint/Microsoft-Excel/Excel-2003---Level-3-5974.htm\