Excel: Beyond the Basics Training Class

Excel: Beyond the Basics Training Seminar

You know the basics. Now become a Microsoft Excel Pro!Covers 2003 and all previous versions of Microsoft Excel!

Shortcuts, new techniques, key codes - you thought Excel was amazing before. Now experience it on a whole new level.

Seminar Overview:

• Microsoft Excel Setup and Editing Success
• 7 Rules that make worksheet setup easy
• How to conceal data in cells, columns, and rows without losing it
• 3 steps to protect your data
• 9 keyboard shortcuts that will cut hours from your work
• How to add graphics - easy when you know how to customize your drawing tools
• Tips on changing chart attributes without losing data
• How to manipulate multiple ranges with Autofill
• The overlooked problem-solver for naming ranges
• The end of data entry drudgery - how to get the software to do it for you Advanced Excel Formulas and Functions That Cut Work Down to Size
• Tips for building complex formulas quickly and accurately
• The amazing Function Palette - hundreds of functions at your fingertips
• How to use absolute, mixed, and circular cells
• Logic Functions - the If, And, and Or statements that make data more usable Making the Most of Excel Macros
• When to use an automated procedure or macro - and when not to
• Tips for recording a complex macro and ensuring it runs easily
• How to assign command buttons to macros
• Techniques for debugging an Excel macro, as easy as 1, 2, 3
• How to start - and use - the Microsoft Visual Basic Editor Advanced Excel Data Exchange with Other Applications
• Specific steps for exchanging Microsoft Excel data with Microsoft PowerPoint, Access, Word, and other platforms
• How to save your Excel work in HTML Demystifying Excel Tables, Databases, and Lists
• How to sort to maximize the data's usability
• Auditing: a visual map of your Excel formulas
• How to build and manage an Advanced Excel Pivot Chart that's everything management wants
• The best way to analyze equations with Scenario Manager
• An advanced shortcut for calculating trends and projecting future ones

"I didn't know I could do that!" - you'll say it often at Microsoft Excel: Beyond the Basics.  One day never delivered so much practical, advanced Excel training. You'll improve your productivity tenfold.  Complicated charts that once took hours to compile will now take only minutes to set up and assemble. You'll learn when it makes sense to use a macro, how to debug a macro, and how to create and manage a Pivot Chart. Key code shortcuts you learn will transform multistep processes into single, simple moves. Even the advanced linking and data exchange operations you once dreaded will become easier.

This "hands-off" training method means you won't waste time entering data, correcting mistakes, or waiting for the entire group to catch up. Instead, you'll learn exactly how to do it from an expert; then, try it at your leisure, in the privacy of your own office.

This advanced Excel training is just what you'll need to increase your productivity and take your current Excel skills to the next level! Save over 25% when you attend both  Microsoft Excel Basics- A One-Day Seminar and Microsoft Excel: Beyond the Basics.