Training Course:Microsoft Excel (vXP) AdvancedSchool/Trainer:AJP Training & Consultancy
Bristol, United Kingdom
Course Format: Classroom | E-learning | Virtual Class | Online | On-site | Blended | Self-paced
Course Description:
'' Those who have used Excel XP yet require a more in-depth knowledge of more advanced features and macros.
Previous experience of using Excel XP to an intermediate level will be assumed. Delegates who do not have this level of knowledge of Excel should first attend our "Microsoft Excel Intermediate" course.
Course Objectives
This one day course covers Excel’s advanced features. The course will look at the more advanced functions and analysis techniques, and particular emphasis will be given during the course to Excel’s macro commands.
Course Contents
Excel Database Features.
Advanced Filter.
Database Functions.
Pivot Tables.
Sharing Workbooks.
Using Outlines.
Using Consolidation Commands.
Advanced Analysis Techniques.
Scenario Manager.
Goal Seek.
Solver.
Advanced Reporting Techniques.
Custom Views.
Report Manager.
Macros.
Recording a macro.
The Macro Language.
Running a Macro.
Relative Addresses.
Range Names.
Using Input Boxes.
Using Message Boxes.
Using the If Then Control Structure.
Using Loops.
Using Do While and Do Until loops.
More Complex Message Boxes.
Using Dialog Boxes.
userforms.
textboxes, labels and command buttons.
comboboxes.
optionbuttons.
...''
Please go to the school's official website for training price and schedule:
http://www.ajp-training.co.uk
Phone:0117 929 1509
School Address:
18 Park Row, Bristol, BS1 5LJ UK
Jobs & Resumes: Bristol
Houses & Roommates: Bristol
Other training courses offered by AJP Training & Consultancy:
Lotus 123 Advanced
Lotus 123 Intermediate
Lotus 123 Introductory
Lotus Ami Pro Advanced
Lotus Ami Pro Introductory
Lotus Approach
Lotus Freelance Graphics
Lotus Notes Introductory
Lotus Word Pro Introductory
Lotus Word Pro Advanced
Microsoft Access (v2000) Advanced
Microsoft Outlook (vXP)
Microsoft Word (vXP) Advanced
Notice: The course description on this page was captured from the Internet as historical reference or submitted by visitors. It was archived statically and not updated from day to day.
Tips:
If you can not find a training course suitable for you instantly, you can leave your training request here and let trainers contact you later. |
|
| 
