ADVANCED MICROSOFT
EXCEL
FOR POWER USERS
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
AGENDA
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
.jpg)
