|
Provided by: Evergreen Team Concepts ADVANCED MICROSOFT EXCEL For Power UsersExcel |
 |
Training
Provided by Evergreen Team Concepts
Course Description
ADVANCED Microsoft Excel for Power Users brings you more: More shortcuts, more resources and more ways to analyze and share data.
Course Objectives
Real Power Users Are Never Satisfied! You know there are easier and faster ways. You re tired of searching for errors and fixing other people s mistakes. You re a Power User, and the learning curve is steeper now. Your demands and questions are more complicated. In this comprehensive training, you will:
Find out if there s a faster way to check for programming errors
Get a complete understanding of the 4 fundamental building blocks of macro
Learn to smoothly integrate changes from multiple users of a shared workbook
Discover the 9 steps for easily turning a Pivot Table into an HTML file for the Web
See how to set limits and maintain control of data that s input by users without your level of expertise
Who Should Attend
Average Excel users are happy with what they already know. But Power Users like you never are. You need this workshop! If you want to kick your skills up a notch or discover what you could be doing with Excel, then this one-day workshop is for you. Advanced users will learn additional shortcuts and tips that will boost their speed and productivity in Excel.
But don t worry unnecessarily about your Excel abilities. We feature a unique hands-off approach to learning. Even intermediate or self-taught users will be able to follow our step-by-step instructions to streamline procedures and save time. Bring this training on to your site or have it in our interactive computer lab.
Course Overview
There will be no introduction to spreadsheets or how-to-print procedures in this workshop! We ve packed this day with practical, common sense material that will streamline your workload and make you more efficient.
Discover Powerful Shortcuts and Tips the Pros Use!
Use the Visual Basic Editor (VBE) to customize your macros to make decisions and perform very complex tasks
Develop more user-friendly and professional worksheets, reports and workbooks
Learn 3 ways to create shared workbooks, then track individual changes, read comments and combine data from multiple users
Add professional polish with dialog boxes complete with text, check-boxes, radio buttons and drop-downs
Discover how to easily link to important data on the Internet
Understand how decision-making statements give macros the ability to think and adapt to changing conditions
See how easy it can be to make changes to macros with the Visual Basic Editor, rather than re-recording from scratch
Get hundreds of keyboard shortcuts (and learn to create your own)
Stop bad data before it happens by setting limits on user inputs
Take home a workbook with step-by-step instructions for everything you need to get ADVANCED results
ADVANCED Microsoft Excel for Power Users brings you more: More shortcuts, more resources and more ways to analyze and share data.
Course Objectives
Real Power Users Are Never Satisfied! You know there are easier and faster ways. You re tired of searching for errors and fixing other people s mistakes. You re a Power User, and the learning curve is steeper now. Your demands and questions are more complicated. In this comprehensive training, you will:
Find out if there s a faster way to check for programming errors
Get a complete understanding of the 4 fundamental building blocks of macro
Learn to smoothly integrate changes from multiple users of a shared workbook
Discover the 9 steps for easily turning a Pivot Table into an HTML file for the Web
See how to set limits and maintain control of data that s input by users without your level of expertise
Who Should Attend
Average Excel users are happy with what they already know. But Power Users like you never are. You need this workshop! If you want to kick your skills up a notch or discover what you could be doing with Excel, then this one-day workshop is for you. Advanced users will learn additional shortcuts and tips that will boost their speed and productivity in Excel.
But don t worry unnecessarily about your Excel abilities. We feature a unique hands-off approach to learning. Even intermediate or self-taught users will be able to follow our step-by-step instructions to streamline procedures and save time. Bring this training on to your site or have it in our interactive computer lab.
Course Overview
There will be no introduction to spreadsheets or how-to-print procedures in this workshop! We ve packed this day with practical, common sense material that will streamline your workload and make you more efficient.
Discover Powerful Shortcuts and Tips the Pros Use!
Use the Visual Basic Editor (VBE) to customize your macros to make decisions and perform very complex tasks
Develop more user-friendly and professional worksheets, reports and workbooks
Learn 3 ways to create shared workbooks, then track individual changes, read comments and combine data from multiple users
Add professional polish with dialog boxes complete with text, check-boxes, radio buttons and drop-downs
Discover how to easily link to important data on the Internet
Understand how decision-making statements give macros the ability to think and adapt to changing conditions
See how easy it can be to make changes to macros with the Visual Basic Editor, rather than re-recording from scratch
Get hundreds of keyboard shortcuts (and learn to create your own)
Stop bad data before it happens by setting limits on user inputs
Take home a workbook with step-by-step instructions for everything you need to get ADVANCED results
|
|
||||||||||||||||||||||||
ADVANCED MICROSOFT EXCEL For Power Users
Excel and the Web: Harnessing the Power of HTML and Hyperlinks
Worksheet to Web: Learn to preview and save a workbook as a Web page
Make documents easier to navigate (for yourself or for other users) using 5 types of hyperlinks
Use Web queries to import information from the Web rather than copying and pasting, or worse, manually entering information into a worksheet
Managing Data: No More Daunting Data Faster Ways to Create User-Friendly Tables and Reports
Beyond Pivot Tables: Step-by-step ways to create, customize and use them more efficiently
Stop wasting time retyping and inserting; let Excel s automatic features do it for you
Use the AutoFilter and Advanced Filter to display information you need
Create interactive Pivot Tables in HTML format for multiple users without affecting the original worksheet
Sharing Workbooks: Silence the Dreaded File-in-Use Message for Good
Untangle the problems of shared workbooks by setting limits and assigning responsibility
See how to track changes and display comments of all or some of the users
Set time limits for tracking and applying changes to a workbook
Avoid problems of merging revised workbook files with a checklist of criteria
Recorded Macros: Going Beyond the Basics
See how to use recorded macros as a starting point or to learn about Excel objects
Learn where to store macros: Your Personal Macro Workbook or Add-in
Customize macros with buttons on a worksheet, toolbar or custom menu (and add printing options)
Understand the 2 ways that commands can be recorded and when to use them
Editing Macros: Make the Most of the Visual Basic Editor (VBE)
Fearlessly find macros, create user forms, pinpoint mistakes and edit macros
Understand the 3 categories of macro programming mistakes (one of which Excel can t find automatically)
Learn how to experiment with actions before adding them to macro
Pause your macro to allow for user input
Worksheet to Web: Learn to preview and save a workbook as a Web page
Make documents easier to navigate (for yourself or for other users) using 5 types of hyperlinks
Use Web queries to import information from the Web rather than copying and pasting, or worse, manually entering information into a worksheet
Managing Data: No More Daunting Data Faster Ways to Create User-Friendly Tables and Reports
Beyond Pivot Tables: Step-by-step ways to create, customize and use them more efficiently
Stop wasting time retyping and inserting; let Excel s automatic features do it for you
Use the AutoFilter and Advanced Filter to display information you need
Create interactive Pivot Tables in HTML format for multiple users without affecting the original worksheet
Sharing Workbooks: Silence the Dreaded File-in-Use Message for Good
Untangle the problems of shared workbooks by setting limits and assigning responsibility
See how to track changes and display comments of all or some of the users
Set time limits for tracking and applying changes to a workbook
Avoid problems of merging revised workbook files with a checklist of criteria
Recorded Macros: Going Beyond the Basics
See how to use recorded macros as a starting point or to learn about Excel objects
Learn where to store macros: Your Personal Macro Workbook or Add-in
Customize macros with buttons on a worksheet, toolbar or custom menu (and add printing options)
Understand the 2 ways that commands can be recorded and when to use them
Editing Macros: Make the Most of the Visual Basic Editor (VBE)
Fearlessly find macros, create user forms, pinpoint mistakes and edit macros
Understand the 3 categories of macro programming mistakes (one of which Excel can t find automatically)
Learn how to experiment with actions before adding them to macro
Pause your macro to allow for user input
About The Training Provider: Evergreen Team Concepts
Evergreen Team Concepts - Evergreen Team Concepts is your one stop team development resource for high quality training. Evergreen Team Concepts provides training in over 100 topics, with 8 professional certification programs. Our main training facility is in Bellingham, Washington. We are also able to design and tailor training to your company or individual needs. The only training provider that offers a cooperative...
