Advanced Excel Training: Beyond the Basics

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

1-Day Seminar - US $99.00; For groups of 5 or more, 89.00

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

"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.

Our "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.

Our 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.

• Microsoft Excel Set up and Editing
• Advanced Excel Formulas and Functions
• Making the Most of Excel Macros
• Exchanging Data Between Excel and Other Applications
• Demystifying Excel Tables, Databases and Lists

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

* NOTE: This is not a hands-on workshop. Instead, you'll learn via "computer-less" training that makes every moment count.

Find a Seminar Near You
USA	State AK AL AR AZ CA CO CT DC DE FL GA HI IA ID IL IN KS KY LA MA MD ME MI MN MO MS MT NC ND NE NH NJ NM NV NY OH OK OR PA PR RI SC SD TN TX UT VA VT WA WI WV WY
CANADA	Prov AB BC PE MB NB NS ON QC SK NF NT NU YK
POSTAL CODE (US, UK, or Canada)   + Miles
Back to top

To find out more about Microsoft Excel: Beyond the Basics, contact our customer service department at customerservice@pryor.com or by phone at 1-800-780-8476.