| Workshop Agenda
Day One: 9:00 a.m. - 4:00 p.m.
Session 1:
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
_ How to format large blocks of cells quickly and efficiently with the power of Format Painter
_ Simple techniques to import and export your data to and from XML files
_ Quick and easy techniques to import data from virtually any kind of file or database system,
such as Microsoft SQL Server, into Excel
_ How to quickly create custom AutoFilters to view your data the way you want to
_ How to create custom fill lists that allow you to save time on commonly entered lists of data
Session 2:
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
_ How to use Excel to quickly create professional-looking forms that look like they took hours to
create
_ How to add control items to your worksheets, including combo boxes, list boxes, option buttons
and many others
_ How to implement conditional formatting and a dozen other formatting tips and techniques
_ How to create stunning 3-D effects with your cells
_ How to achieve some great formatting effects with just 4 mouse clicks
Session 3:
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
_ What the Excel Solver is and how to load and use it
_ How to use the Goal Seek function in Excel
_ A technique that allows you to sum only the data that meets conditions you specify
_ How to use the Scenario tool to do a what-if analysis
_ The right way to use the Lookup Wizard to help you write a formula that finds the value at the
intersection of a column and a row
Session 4:
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
_ How to know which chart or graph type to use
_ How to replace data markers such as bars with pictures to create exciting charts
_ How to quickly create a basic chart with a single keystroke
_ How to add a chart- or virtually any kind of image-to a comment that displays when the user
moves the mouse over a cell
_ How to create a user-defined chart type A quick technique to create a cell that contains a drop-
down list How to load and use the Analysis ToolPak to perform a multitude of data analysis
tasks How to create a waterfall chart in Excel
Day Two: 9:00 a.m. - 4:00 p.m.
Session 5:
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
_ The in's and out's of Excel PivotTable and PivotChart reports, including the terminology used in
PivotTable reports
_ How to use the PivotTable Wizard
_ The right way to modify an existing PivotTable, including how to insert a chart in your
PivotTable report
_ How to quickly drill down in your PivotTable without having to go back to your source data to
identify specific information
_ How to change your PivotTable field settings to a variety of options such as average, minimum,
maximum or even custom settings
Session 6:
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
_ A quick way to learn VBA syntax, including how to reference specific cells, a range of cells,
Worksheets and more
_ How to use the Project Explorer and Visual Basic Editor to view and modify modules, forms and
other worksheet code
_ How to use loops to repeat commands multiple times
_ How to write conditional If/Then statements in your code that can be used to execute other
functions, control program flow, allow user input and perform many other functions
_ How to use VBA to control which menu items are available to users
Session 7:
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 publish your graphs, charts and PivotTable reports quickly and easily, with professional-looking results
that look like it took you hours to create.
You'll learn
_ How to create interactive Web pages from your Excel workbooks
_ What it takes to publish a chart to a Web page and make it interactive
_ How to get continuously updated data from a Web site into a worksheet
_ The special step you have to take when publishing a PivotTable report to an
interactive Web page
_ How to create a macro that will update a chart published to a Web page at regular intervals
Session 8:
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. This course will show you some of the best techniques to help eliminate
human error from your data management equation. You'll learn ???
_ How to use Information Rights Management (IRM) to protect your Excel files
_ How to lock values and formulas in your Excel worksheets
_ How the Formula Auditing tool can help catch errors and avoid data corruption
_ How to share your Excel workbook and not worry about someone making changes that'll rui
your work
_ How to use Data Validation to make sure the data going into any cell meets the criteria you've
Specified
Still haven't registered?
Five more good reasons why you will want to attend this program ???
1.The trainers are the bestperiod. Only the pros who have a proven track record of training effectiveness, professionalism and expertise. And what's more, they're exciting communicators who'll provide you with two of the most interesting days you've ever spent.
2. You only the most important, important information. There's a lot of information out there that could take you years to gather on your own. In two fast-paced days, we'll give you what we believe is the best, most important information to help you be the best you can be.
3.Practicality is emphasized. You will leave this workshop with specifics you can apply immediately. You'll get results on your very next day back at work.
4.The value is unbeatable. Not only is the enrollment fee among the lowest you'll find, when four or more enroll from the same organization, you'll enjoy a significant discount.
5.This course guarantee is unconditional, straightforward and the very best in the industry.
How can we be so confident? Because the hard work is done before the workshop to make sure you're happy after the workshop. Pertinent, up-to-date information you can really use, a convenient meeting location, workshop registrars who are courteous and helpful and a trainer who grabs your attention and takes you on an exciting journey full of fun and facts. You'll love every minute of it. Millions of satisfied participants from around the country are sold on CompuMaster workshops. Why not join them?
|