Sign Up for Seminars from Over 600 Providers

Excel: Beyond the Basics 2007

Fee:

$99

· QuickCode:

QQBVCF

· Print Page · Email Page

Provider:
Fred Pryor Seminars

Topic(s):
Computers & Software > Programming & Software

Who Should Attend?
Those who want to learn more about Excel 2007

• Mastering Microsoft Excel - Hands Off
• Microsoft Excel 2007

Full Seminar Description

An accelerated one-day workshop to make you a Microsoft Excel 2007 Pro!

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 2007 Basics and Microsoft Excel 2007: 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 2007: Beyond the Basics can provide the help you're looking for!

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

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

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

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

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

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

Sponsor Background:

Today, with more than 5,000,000 satisfied customers, we continue to pride ourselves in providing the superior training you’ve come to expect from Fred Pryor Seminars and CareerTrack. Our cutting-edge research and course development are designed to meet the adult learning needs of your employees and your organization.

Fred Pryor and CareerTrack are your number one choices for training because we offer:

• In-depth experience in the training industry
• Consistent and comprehensive course offerings
• High energy and content-rich presentations
• Multiple training tools, including on-site training, on-line learning, seminars, and a/v products
• 100% Satisfaction Guarantee

As we continue to grow, expand, and change to meet client and market needs, we always remember that every individual customer matters and that collectively, they are our most valuable assets. That’s why our goal is the same today as it was 30 years ago – to provide the best choice in business skills training with maximum convenience to help you – our customer – achieve success!

Cancellation Policy: You may cancel your registration up to 10 business days before the seminar. Your registration fee will be refunded less a cancellation fee. If you need to cancel less than 10 business days prior to the seminar you may (1) send a substitute from your organization or (2) transfer your registration fee within 12 months to another seminar or conference of your choice. 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 395 upcoming dates & cities. To quickly return to this seminar later, you can search by its QuickCode: QQBVCF.

Get updated when new dates are added for this seminar.
Get a free personalized recommendation from our experts!