Seminars both National & Local · Since 1981

TITLE, PROVIDER, OR TOPIC:


CITY, ZIP, OR STATE:


 


Advanced Microsoft Excel Techniques

Fee:

$399

· QuickCode:

QQBSHT

· Print this Page Print Page · Email this Page Email Page


PICK A DATE & SIGN UP
You may use Excel daily, or maybe only casually, but one thing's for sure, you've probably wished you knew more about this dynamic program. That's why you'll want to attend this workshop. In it, you'll learn ways to make your job easier and increase the sophistication of your data reporting and analyzing. Each session focuses on saving-you-time techniques, advanced 'how-to's' exploring those previously 'programmer only' features and more. Along with this practical and usable training, you'll learn how to integrate your work within the Office 'family' for even greater results. If you've ever been frustrated using Excel because you knew there had to be a better way of accomplishing your tasks, you'll soon be on your way to getting more done -- and more efficiently -- with this power-boosting workshop. Enroll today! Fee per person: $399; $349 each for four or more.

CompuMaster

Provider:


CompuMaster

Topic(s):


Computers & Software > Programming & Software

Who Should Attend?


Those needing advanced skills in Excel

We Also Recommend:


You’ll learn:

You may use Excel daily, or maybe only casually, but one thing’s for sure—you’ve probably wished you knew more about this dynamic program. That’s why you’ll want to attend this workshop. In it, you’ll learn ways to make your job easier and increase the sophistication of your data reporting and analyzing. Each session focuses on saving-you-time techniques, advanced “how-to’s,” exploring those previously “programmer only” features and more. Along with this practical and usable training, you’ll learn how to integrate your work within the Office “family” for even greater results. If you’ve ever been frustrated using Excel because you knew there had to be a better way of accomplishing your tasks, you’ll soon be on your way to getting more done—and more efficiently—with this power-boosting workshop. Enroll today!


WORKSHOP AGENDA

Day One: 9:00 a.m. – 4:00 p.m.

Time-saving techniques

To really get the most out of Excel, you need to know not only how to accomplish certain tasks but how to accomplish them fast. That’s what this session is all about. You’ll learn some quick keyboard shortcuts that’ll get you where you want to be many times faster than using your mouse to maneuver through your worksheets. You’ll also uncover some amazing techniques for importing data so you don’t have to re-enter data from other applications. You’ll also learn …

Designing forms and formatting

Using Excel to create custom forms such as invoices, purchase orders and others is a great way to take advantage of some of the advanced features it has to offer. This session will show you how to create virtually any type of form quickly—and with features you might not have thought were even possible. You’ll discover …

Data analysis and formulas

The real power of Excel is in data analysis, and that’s what this session is all about. You’ll dive headfirst into the data analysis techniques and formulas found in Excel, but you won’t have to be a mathematician to make sense of all the possibilities Excel has to offer. We’ll explain the most commonly used functions and analysis tools in plain English so you’ll walk away with the skills you need to get the most out of Excel. You’ll learn …

Advanced charting and graphing functions

Virtually anyone can put some numbers down in a spreadsheet, select them and then click the Chart Wizard button to create a reasonable-looking chart, but it takes advanced skills to make charts and graphs with stunning effects that really capture the reader’s attention. In this session, you’ll learn how to create some amazing special effects that’ll give your charts a professional appearance without taking hours to complete. You’ll find out …

Day Two: 9:00 a.m. – 4:00 p.m.

Getting the most out of PivotTable and PivotChart® reports

Trying to view and understand worksheets that contain hundreds or even thousands of rows of data used to be a nearly impossible task. But now you can use PivotTable reports to view and organize your Excel data quickly and easily, and that’s what you’ll learn in this session. You’ll discover how you can organize your data with just a few simple mouse clicks to see comparisons, reveal patterns and analyze trends. You’ll also find out …

Maximizing the power of Excel with VBA and macros

You don’t have to have a degree in computer programming to take advantage of the power and flexibility of Visual Basic for Applications. In fact, in just this one session, you’ll gain the skills necessary to take Excel to a whole new level and uncover the real potential it has to offer. This session begins by showing you how to use the macro recorder. Then you’ll find out how to manually create macros and how to modify and tweak the code behind them. You’ll discover …

Excel and the Internet

Microsoft has made it easy to publish your data on the Internet or your local intranet, but you have to know the right techniques to use in order to get the right results, and that’s just what you’ll learn in this session. We’ll show you how to save your spreadsheet to the Web quickly and easily, with professional-looking results that look like it took you hours to create. You’ll learn …

Validating and securing your data

Having data in your spreadsheet is only half the battle. Making sure your data is valid and secure is extremely important, and that’s what this session is all about. Your spreadsheets are only as good as the data they contain, and human error in data entry is an extremely common problem. We’ll show you some of the best techniques to help eliminate human error from your data management equation. You’ll learn …


Sponsor Background:

Why Choose CompuMaster?

Since its start, SkillPath has grown from holding just 82 seminars in 1989 to conducting more than 12,000 seminars each year. This growth was recognized in 1994, as SkillPath was placed number 32 on Inc. Magazine's annual listing of the 500 fastest-growing privately held companies in America. In 1995, SkillPath joined forces with Graceland College, a nationally recognized, private, undergraduate institution. For both SkillPath and Graceland, this partnership makes possible a long-sought objective: the potential for many to experience the joy and benefits obtained through lifelong learning and professional development.

Even with this exceptional growth, one original goal remains unchanged-- our attention to high quality. We're so committed to achieving this goal that we offer a guarantee: you'll be satisfied with the quality of the training you receive, or you don't pay. It's that simple, and that's how we maintain the highest satisfaction rating in the industry. We invite you to try one of our seminars and experience the SkillPath difference!

Cancellation Policy: Cancellations received up to five business days before the workshop are refundable, minus a registration service charge, which you may apply toward any future workshop. After that, cancellations are subject to the entire workshop fee, which you may also apply toward a future workshop. 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

97

upcoming dates & cities. To quickly return to this seminar later, you can search by its QuickCode:

QQBSHT

.

 

©2014 Seminar Information Service, Inc.