1. Use Visual Basic for Applications to create macros that will execute scores of commands with a single click.
2. Analyze millions of cell values and distill that data into meaningful information you can use.
3. Let VBA walk you through setting up simple macros that can create reports, generate statistics, and develop new data files.
4. Build macros that not only create monthly reports but automatically reset each team member’s worksheets with new YTD and quarterly totals.
5. Use the Visual Basic Editor to enhance the power and flexibility of your existing macros.
6. Create interactive macros that will prompt users for required data and check entries for accuracy.
7. Quickly develop dialog sheets with text boxes, radio buttons, check boxes, and pull down lists for more accurate data entry.
8. Set macros to utilize logical constructs such as If … Then statements to perform data evaluation and correction for your users.
9. Automatically generate reports, graphs, statistics, and totals from data entered by multiple users in a shared workbook.
10. Quickly publish your Excel workbook with graphs, charts, and reports as a Web page – complete with interactive options.
11. Easily create sophisticated graphs that shine with professional polish with the tips and tricks you’ll learn.

This training has been designed for Excel users who’re ready to tap into the advanced features and functions for increased efficiency and productivity, and for greater capability to analyze and share data.

• Managers and supervisors
• Office managers
• Accounting and finance professionals
• Administrative assistants
• Project managers
• Sales managers
• Business professionals
• Anyone who generates reports, analyzes data, or uses spreadsheets in their work

Easy Editing Techniques

• Using the Advanced Filter and AutoFilter to display the information you need
• Controlling multiple ranges with AutoFill
• Extracting filtered ranges
• Using multiple criteria for creating advanced filters, databases, and list management
• Time-saving keyboard shortcuts
  

Sharing Workbooks

• Setting up shared workbooks
• View users sharing a workbook
• Change the updated frequency
• Merging shared files
• Creating pull-down menus for shared workbooks
  

More Than Your Basic Macro

• Macro review: Running, stopping, and pausing macros
• Assign macros to buttons and objects
• Starting Visual Basic Editor (VBE)
• Using VBE to create new macros and edit existing ones
• Using Variables in macros
• Creating interactive macros
• Debugging macros with the Step feature Editing Steps for Macros
• Editing existing macros from the macros menu
• Editing existing macros using Editor
• Streamlining your access to VBA modules with Project Explorer
• Where to find free Visual Basic Code for macros
  

Formulas and Functions

• Building complex formulas quickly and easily
• Using the Function Palette and cutting your work time in half
• Using key logic functions If, And, Or, and Not to make data more usable
• Creating conditional formulas
• Using Match, Index, V, and HLookup in large worksheets
• Manipulating text entries with Excel’s extensive set of functions and formulas
  

Using Analytical Options

• Using Goal Seek and Solver
• Working with the Analysis Toolpak
• Working with scenarios to analyze data and equations
• Working with view options

Advanced Charting, Tables, Databases, and Lists

• Using auditing to create a visual map of your data
• Creating custom charts for added interest and relevance to your reporting
• Exploring database functions
• Working with data forms
• Creating data tables
• How to create and manage PivotCharts and Tables

"The instructor was able to bring the ideas and 'how-to's' down to a friendly and easily understandable language."
P. Earp
MicroComputer Tech II
Texas A&M University-Kingsville

"Chuck is not only knowledgeable and aware of a user's practical needs, but a very effective instructor."
B. Goodman
Electronic Access Librarian VC/UHV Library

"The seminar was very useful and informative. I will definitely apply the information to make myself more productive."
A. Kite
Secretary
Christ's Haven for Children

"The workbook anticipated a lot of my questions as it went along. Good presentation of material. Thanks tons!"
S. Schmitz
System Analyst
King Ranch, Inc.

" ... I would highly recommend this program to anyone!"
Larry Owens
Director of Business Administration
Golden Van Lines

" ... Thank you — this has been a great help!"
Judith Steinacher
Secretary
St. Vrain Valley School District