|
EXC-300
Excel 2003 Advanced
Course Length: 1 day
*Prerequisite*
Intermediate Excel
Introduction to Windows or equivalent working knowledge
General knowledge of other MS Office applications (i.e. Word, Outlook)
What past students had to say
about this class:
The instructor was extremely
efficient and effective and engaged the class well throughout the whole day. As
a teacher, I always appreciate having instructors who focus on the methodology
just as much as the subject content! A very valuable course. ~A.C. \ Viasat
Focused on what we will use in
the workplace. Direct application of class topics to the day to day functions of
my position put my skill level above my peers.~ E.Q. \ USMC
It was an excellent learning
experience for myself. ~E.B. \USMC Learned
a lot about advanced features of Excel. This will definitely help with my job.
Instructor was fantastic, the receptionist has a very uplifting personality. ~T.F.
\USMC
Course Contents
Introduction
Creating and Using
Personal Macros
- What is a Macro?
- Recording a Personal Macro
- Running a Personal Macro
- Displaying Macro Instructions
- Editing a Macro
Including
relative cell references in a macro
Creating and
Using Workbook Macros
- Recording and Running a Workbook Macro
- Adding a Macro Button to a Worksheet
Using Visual Basic to
Write Macros
- Opening a New Module in the Visual Basic Editor
- Displaying a Data Prompt During Macro Execution
- Using a Conditional Statement in a Macro
- Using a Control Loop in a Macro
- Additional Control Statements
Using Logical Functions
- Using the
IF Function
-
Nesting IF Functions
Using
Advanced Functions
- Using the VLOOKUP Function
- Using the HLOOKUP Function
- Using the DSUM and DAVERAGE
Functions
Auditing
a Worksheet
- Tracing
Precedents and Dependents in a worksheet
- tracing
errors in a worksheet
- watch
and evaluate formulas
Working with Other Excel Users
- Tracking
changes in a workbook
- Responding to
proposed changes and comments in a workbook
-
Protecting a
shared workbook
-
Protecting an
unshared workbook
-
Merging
revised copies of a workbook
-
Additional
Security Features
Creating a Macros
Toolbar
- Creating a New
Toolbar
- Adding a Button to a Toolbar / Assigning a Macro to a Toolbar Button
Creating a
Macros Menu
- Creating a New Menu
- Adding an Item to a Menu / Assigning a Macro to a Menu Item
Final Case
Study
|
