Boost your productivity, simplify data management, and streamline everyday tasks using the
revolutionary new features and functions of this powerful program!
It's frustrating to know what Excel can do, but not understand the techniques to accomplish it. In one day,
you will learn not only the formulas, database techniques, and macro commands that make work go faster, but you
will learn the tips and keystroke commands the pros rely on to make data more useful and worksheets easier to
manipulate.
Our Excel 2007 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 and Microsoft
Excel: Beyond the Basics.
Does this sound familiar?
- You taught yourself Excel 2007, and sometimes you wonder if you're doing things the most
efficient way.
- You know a lot about Excel 2007, but not the newest time-saving shortcuts.
- Coworkers have asked you questions about Excel 2007, and you're not always sure of the answers.
- You know the Excel 2007 techniques you use every day, but little else about other features.
- You have questions about Excel 2007 that no one in your office can answer.
- You feel like you've barely scratched the surface of Excel 2007's capabilities, and you want to
be a pro.
If this sounds like you, Microsoft Excel: Beyond the Basics can provide the help you're looking
for!
Read Seminar Agenda
Microsoft Excel: Beyond the Basics — Seminar Overview
Microsoft Excel 2007 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 2007 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
Back to Seminar Overview
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 2007 and Other Applications
- Specific steps for exchanging Microsoft
Excel 2007 data with Microsoft PowerPoint, Access, Word, and other
platforms
- How to save your Excel work in HTML
Back to Seminar Overview
Demystifying Excel 2007 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 1-800-780-8476.
|
Seminars
Share this Page
CD-ROM
