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.

My lab 6

Today, at the laboratory I have learn how to sort data -> Home - > Sort & Filter, from A to Z.
Also, I have exercised Subtotals: Data -> Subtotal -> use functin Sum, select County and Sales, and Summary Data Below for the Question 1 (? the total sales for each county). If we want to know how many records (lines) are for each type of product that was recorded on list we use the function Count.

my 3rd laboratory

I continued working in Excel. I have learnt how to define a range of cells. For eg. if we write A3:C3 it will take every cell from A3 to C3 (A3, B3, C3) and when we take A1:C3 we will have (A1, A2, A3, B1, B2, B3, C1, C2, C3). Than I have exercised to work with formulas such as SUM. After that I spoke with my coleg about our project.

my 2 laboratory

In my first laboratory at economic informatics I have seen that there ar important diferences between Excel 2003 and Excel 2007 wich I thaught I know to work in. First of all I tried to find diferences between those two... there are a lot... So, I started to work on general application in Excel 2007, like deleting cells, shift cell left, shift cell up, deleting entire row, entire column, merge and center, merge across, merge cell, unmerge cell.

The lab.no.4

My economic informatics