Getting the Most from Microsoft Excel

 View Dates & Sign Up ·  Print Brochure ·  Email Reminder ·  Bring On-site

Detailed Overview/Outline

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!

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, 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 users' tips, techniques and shortcuts ... all the special secrets you'd love to know on macros, Auto functions, hidden tools and commands, templates, reports, customizing, and many more
• Plus much more!

• You'll get more done in less time, by learning how to work smarter, not harder.
• You'll increase your abilities so you'll know how to use (and remember) important features, plus know how to troubleshoot and fix common problems.
• You'll build skills and learn practical, real-world techniques you can use immediately, learning and retaining more in one day than you can imagine. And you'll take home great resource materials you can refer to again and again.

Workshop Agenda
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

Sponsor Background:
Why Choose CompuMaster?

Since its start, SkillPath has grown from holding just 82 seminars in 1989 to conducting more than 12,000 seminars each year. This growth was recognized in 1994, as SkillPath was placed number 32 on Inc. Magazine's annual listing of the 500 fastest-growing privately held companies in America. In 1995, SkillPath joined forces with Graceland College, a nationally recognized, private, undergraduate institution. For both SkillPath and Graceland, this partnership makes possible a long-sought objective: the potential for many to experience the joy and benefits obtained through lifelong learning and professional development.

Even with this exceptional growth, one original goal remains unchanged-- our attention to high quality. We're so committed to achieving this goal that we offer a guarantee: you'll be satisfied with the quality of the training you receive, or you don't pay. It's that simple, and that's how we maintain the highest satisfaction rating in the industry. We invite you to try one of our seminars and experience the SkillPath difference!

Cancellation Policy: Cancellations received up to five business days before the workshop are refundable, minus a registration service charge, which you may apply toward any future workshop. After that, cancellations are subject to the entire workshop fee, which you may also apply toward a future workshop. 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.

This seminar has 132 available dates/locations. Click the button below to view them all and to sign up for this seminar. To quickly return to this seminar at a later time, you can search by its QuickCode: QQBJFL.

Get updated when new dates are added for this seminar.

Get a free personalized recommendation from our experts!

Questions? Please call us Toll-free at (877) SEM-INFO.