Microsoft Excel 2007

  • The Course
  • Contents of the Training
  • Shedule

NHK starting the course of Excel 2003 allowing the student to accomplish the basic operations associated with developing, formatting and using Excel spreadsheets.

Objectivs

The main objective is that you’ll know most of the Excel 2003 functions and formatting and creating graphics.

For whom?

To any user that needs to use a calc sheet.

Requirements

For this course you must know basic commands of windows.

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:

Microsoft Excel Advanced


1st. Session

Introduction;
Concept Basics;
Row, Columns, Address, Book and worksheets;
Manipulation of files;
Edit worksheets;
Series;
Create list;
Simple Formula;
Formatting Table;

2nd. Session

References Relative, Absolute and mixed;
Function basics: SUM, AVERAGE, MIN, MAX, COUNT;
Fixed value;
Selection cells;
Copy, cut, paste and delete;
Insert and remove sheet;
Rename Sheets;
Copy sheets;
AutoFormat;

3rd. Session

Clear Forms;
Insert Comments;
Functions;
Advanced Functions: If, Countif;
Conditional Formatting;

4th. Session

Insert Charts;
Wizard charts;
Graphics: pie, column, bar;
Formatting charts;
Validating cells;
Sort cells;

5th. Session

Header and Footer;
Page setup;
Print;
Automatic filters;
Form;
Subtotals;


To know more about this course please contact us.