20.01.2011

 At this laboratory we have done the recapitulation and we tried to resume all what we did until now. It was a very usefull laboratory, which help us to refresh our minds.
  I have exercised to insert a Chart (pie, bars etc.), to use the functions DCOUNT, DCOUNTA, YEAR etc. I have work also on sorting data, defineing the names for tables, columns ect. I have also exercised creating the criteria for useing diferent functions. My files are on my site.

My lab no 12

We have continued the application from the last time, and we name the colums with different informatin, we have worked with many diferent sheets, and also exercised the functions from the previous laboratory.

My lab no 11

 We have learned how ti use database functions and not only (DCOUNT, DCOUNTA, VELOOKUP, AVERAGE, COUNT IF etc. ) and we exercised on an application related to databases. I will post the files with aplications on my site.

My lab no 10

At this laboratory we have continued to work on the previos aplication. I will attach the applications on my site.

My lab no. 9

At this laboratory we have had to do the application with VLOOKUP function, and also we exercise the functions SUM, AVERAGE, PMT etc .
     

My lab no 8

In this laboratory I have learned how to make a chart. We should select the Data Series and then go to Insert tab - Charts Group of Buttons and select there the chart we want to be created, also I have learned how to "design" the charts, to change colours, to add the title for horizontal and vertical axis etc.

My lab no 7

At this laboratory I have exercised fomatting a table, formulas like CONCATENATE and others. Also I have solved first 4 problems, as can be seen on my site in the attachment called  My lab no 7.