Advanced Training for Microsoft® Excel On-Site Training
An intensive day of training that puts you in command of Excel’s most advanced features and functions
Thanks to an exciting training opportunity coming to your area, you can get up to speed fast on the most advanced features for improving your efficiency and expanding your capabilities in Excel. Advanced Training for Microsoft® Excel, a comprehensive one-day learning event, has been developed for Excel users who’re ready to put this amazing software to work for amazing results.
Excel, the longstanding powerhouse of spreadsheet software, is one of the most commonly used business applications on the planet. As an Excel user, you know that the software has unlimited capabilities for making your job easier and less stressful. But learning the countless features available to you can be a daunting task. This workshop will teach you the most advanced features and functions Excel offers – taking your level of proficiency from basic to advanced. After one day of training you’ll be amazed at how this powerful program can work for you.
What You'll Learn:
Use Visual Basic for Applications to create macros that will execute scores of commands with a single click. Analyze millions of cell values and distill that data into meaningful information you can use. Let VBA walk you through setting up simple macros that can create reports, generate statistics, and develop new data files. Build macros that not only create monthly reports but automatically reset each team member’s worksheets with new YTD and quarterly totals. Use the Visual Basic Editor to enhance the power and flexibility of your existing macros. Create interactive macros that will prompt users for required data and check entries for accuracy. Quickly develop dialog sheets with text boxes, radio buttons, check boxes, and pull down lists for more accurate data entry. Set macros to utilize logical constructs such as If … Then statements to perform data evaluation and correction for your users. Automatically generate reports, graphs, statistics, and totals from data entered by multiple users in a shared workbook. Quickly publish your Excel workbook with graphs, charts, and reports as a Web page – complete with interactive options. Quickly, cleanly draw out crucial records with the AutoFill and Advanced Filter options. Let Excel’s PivotTable and PivotChart features manage millions of cell values to create useful statistics in just seconds. Use statistical, financial, database, and other functions to provide unmatched accuracy and reliability to your department and corporate reports. Easily create sophisticated graphs that shine with professional polish with the tips and tricks you’ll learn. Download extensive Internet data onto an Excel spreadsheet and quickly organize it into useful reports and statistical analysis.
Who Should Attend?
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
More Than Your Basic Macro
Formulas and Functions
Using Analytical Options
Advanced Charting, Tables, Databases, and Lists
Add to favorites
Email this page