Webinars > All COMPUTERS / SOFTWARE Categories > Office Software Webinars SkillPath Seminars presents
One-Day Advanced Training for Microsoft® Excel® Webinar
This intensive training puts you in command of Excel's most advanced features and functions.
Course Description/Agenda As an
Excel user, you know that the software has nearly unlimited
capabilities for making your job easier and less stressful. But
learning the countless features available to you can be a daunting
task. This LIVE, virtual workshop will teach you the most advanced
features and functions Excel offers — taking your level of
proficiency from mid-level to advanced. After a few hours of
training you’ll be amazed at how this powerful program can work
for you.
This
intensive training puts you in command of Excel’s most advanced
features and functions. We strongly recommend that you be an
experienced or mid-level Excel user in order to get the most
out of this incredible training.
What You
Will Learn
- Time-saving keyboard shortcuts
- How to personalize the look of
your tables, charts and more to give your work added pizazz
- Insider secrets to creating
even more amazing macros that do the hard work for you
- Techniques that make sharing
workbooks much easier for everyone
WORKSHOP AGENDA
Program
time: 3 hours
Session 1: 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
Session 2: 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
Session 3: 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
Session 4: 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
Session 5: 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, VLOOKUP
and HLOOKUP in large worksheets
- Manipulating text entries with
Excel®’s extensive set of functions and formulas
Session 6: 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
Session 7: 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
Session 8: Special Section: Data Exchange,
the Web and Excel
- How to do a quick Internet
search for information—right from your Excel spreadsheet
- Creating hyperlinks in your
spreadsheet that will take users straight to a Web page
- Importing and exporting text
files and XML data
- How to publish your Excel
charts and data on the Web more quickly
More Webinar Information |
SkillPath Seminars
|
Course Summary |
This intensive training puts you in command of Excel's most advanced features and functions. |
Delivery
Method |
Virtual Classroom (Live) |
Who Should Attend |
We strongly recommend that you be an experienced or mid-level Excel user in order to get the most out of this incredible training. |
|
|
Search similar training
Email this page
Print this document
Frequently Asked
Questions
Payment Options
Bill Me/Invoice
Credit Card
Register
Online
Fax Form
Availability
Select a date from the list at the bottom of the page for specific information about that class.
Other Information
Virtual Classroom (Live) |
|