|
Provided by: NobleProg - IT training courses Excel Advanced Training CourseExcel |
 |
Training
Provided by NobleProg - IT training courses
This course is designed of you who want to use excel to its full potential at a more advanced level
|
|
||||||||||||||||||||
Excel Advanced Training Course
Presenting Scenarios (What if... analysis)
Spreadsheet Databases
Data Exchange
Subtotals
Pivot Tables
Workbooks and Worksheet Templates
Presenting Scenarios (What if... analysis)
Functions
Text Functions
Date and Time functions
Spreadsheet Databases
Sorting Database
Autofilter
Advanced Filter
Database functions
Data Exchange
CSV Files
Importing Data
Exporting Data
Outline
Subtotals
Pivot Tables
Creating pivot tables from different sources
Calculated field and calculated item
Consolidating data in a pivot table
Macros
Recording Macros
Reading and modyfing VBA macro code
Assigning macro to an icon or a button
Creating and utilizing forms
About The Training Provider: NobleProg - IT training courses
NobleProg - IT training courses - NobleProg specializes in bespoke computer and management training courses.
NobleProg provides computer training courses in the following areas:
* Drupal
* Java
* Linux
* MySQL
* OpenOffice
* Oracle
* PHP
* Project Management
* SVN and CVS
* UML
* Web Application Testing
* CSS
* VBA
* BPM
* SOA
* LPI (We are...
