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.
joi, 11 noiembrie 2010
marți, 2 noiembrie 2010
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.
joi, 28 octombrie 2010
sâmbătă, 23 octombrie 2010
Abonați-vă la:
Postări (Atom)