Microsoft Excel 2007 Advanced
- The Course
- Contents of the Training
- Shedule
NHK starting the advanced course of Excel 2003 including all advanced concepts of the calc sheet most used on personal PC’s.
Objectivs
The main objective is that you’ll know all the functions and tools of the Excel 2003.
For whom?
To any user that needs to use the advanced functions of the calc sheet.
Requirements
For this course you must know basic commands of windows and basic excel.
Pedagogical Methodology
Mixed sessions of teory and practic lessons, with full descriptions by the teacher and experimentation on your PC. Exercises and simulations of practical situations.
Duration
10 hours (5 sessions of 2 hours each)
Price
111,63€
Exemption of VAT - n.º 53 of the Art. 9º Cod. of the IVA from 30/01/2003
If you liked this course, then we sugest:
1st. Session
Financial;
Statistical;
Date and time;
Lookup;
Logic;
Text;
Find and change information;
Go to a specific reference on the calc sheet;
2nd. Session
Insert diagrams;
Create lists;
Filter information;
Organized information;
Advanced filter;
Subtotals;
Remove subtotals;
Protect part and all of the calc sheet;
3rd. Session
Use deferent kind of formats;
Create new books from models;
Work with hyperlinks;
Audit of formulas;
4th. Session
Dynamic work sheets – Pivot Tables;
Dynamic graphics – Charts Pivot;
Import and export info;
Pivot tables Reports;
5th. Session
Introduction of macros;
Work with macros;
Attribute macros;
Personalizes menus and tools;
To know more about this course please contact us.
