Training Course:Excel Advanced with VBASchool/Trainer:NobleProg
Birmingham, London, United Kingdom
Course Format: Classroom | E-learning | Virtual Class | Online | On-site | Blended | Self-paced
Course Description:
'' Making Your Life Easier
Shortcuts, Toolbars and Menus
Tuning Excel interface
Paste Special and Transposition
Styles
Selecting cells with "Go To Special"
Dealing with Data
Utilizing cell’s and range’s Names
Formula, Workbook and Worksheet protection
File encryption
Track changes and revisions
Workbook sharing
Formula auditing
Managing templates (charts, worksheets and workbooks)
Data Analysis
Utilizing Logic in Excel
Logic Functions
Lookup Functions
Advanced functions
Scenarios
Reverting formula with Goal Seek
Resolving optimization problems with Solver
Charts
Utilizing Databases, Ranges and Lists
Data consolidation
Grouping and Outline
Data sorting (more than three columns)
Advanced Filter
Database functions
Subtotals
Pivot Tables
Data Exchange
Importing text file
Getting Data from a database through ODBC
OLE (embedding and linking)
Getting data from a web page (Web Queries)
Exporting spreadsheet and pivot table as a HTML page
Publicising Workbooks, Worksheet and pivot table as a Web Page
Work Automation
Creating custom formats
Data validation
Recording and editing macros
Visual Basic for Applications
Creating user functions
Executing code on special events
Creating applications and forms
...''
Please go to the school's official website for training price and schedule:
http://www.nobleprog.co.uk/
Phone:+44 20 7558 8274
School Address:
Dephna House
112/ 114 North Acton Road
NW10 6QH
London
UK
ul. Księcia Józefa 355/8
30-243 Kraków
Poland
Jobs & Resumes: Birmingham, London
Houses & Roommates: Birmingham, London
Travel Agencies: Birmingham, London
Search other schools for Excel Advanced with VBA training resources.
Other training courses offered by NobleProg:
Drupal Installation and Configuration
Building Social Networking Application in Drupal
Drupal for Developers
Drupal 6 for Developers
Drupal 5.x Optimization
Drupal Views Module
Drupal Applications in UML
Drupal Integration with SOAP
Excel Introduction
Excel Advanced
Excel VBA Introduction
Excel VBA Advanced
Analysing Financial Data in Excel
Excel For Statistical Data Analysis
MDA (Model Driven Architecture) development with AndroMDA
Sun Certified Java Programmer (SCJP)
Linux Installation and Configuration
Linux System Administration
Linux Networking
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:
In most cases you will get a unique submit code along with your each posting on this website. Please provide it as well as the message title if you want any assistance for editing/removal. |
|
| 
