Microsoft® Excel®: Beyond the Basics

"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 when you attend both Microsoft Excel Basics — A One-Day Seminar and Microsoft Excel:Beyond the Basics.

Microsoft Excel: Beyond the Basics — Seminar Overview

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

Back to Seminar Overview

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

Back to Seminar Overview

Exchanging Data Between Excel and 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

Back to Seminar Overview

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

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