Lab no. 8 - November 25th

At this lab we had to do an application (on a given table) posted on the professor's site: processing and analyzing a list of training course.

There were 9 requirements and in order to complete them I used comments text box, Date function, text functions (left, right, concatenate), subtotals, logical function (if), and other.

You can find my work at the following link: https://sites.google.com/site/einfoproj/uploads

Project research

I started researching for the project and I found some interesting information on the following websites.

http://www.businesstown.com/internet/ecomm-definition.asp
http://web-design.lovetoknow.com/Develop_eCommerce_Website
http://www.productcart.com/shopping-cart-software-101.asp
http://www.essortment.com/hobbies/historyamazonc_ttas.htm
http://www.seattlepi.com/business/158315_amazon28.html

Lab no. 6 - November 11

Today I have made my Google website... I have uploaded there the files that I worked on in Excel so far...
https://sites.google.com/site/einfoproj/uploads

In our last laboratory we worked with subtotals, min, max, counting.
For the second assignment we had to do the following:

q1: the total sales for each county

q2: the minimum sales value for each type of product

q3: how many records for each type of product that was recorded on that list?

q4: the maximum sales value

Lab no. 5 - November 4th

I should have posted this on Thursday but I got a bit distracted.. so here is what Alexandra and I have worked in Excel.

At the last lab I've learned how to insert comments in Excel, format them and prepare the page for printing. Comments are useful for a bunch of things such as flagging errors, raising questions, making suggestions. By default, Excel displays comments in a yellow box that points to a single cell. You can modify almost everything: the line, the background of the box, the color of the text, etc. This is done by right clicking the comment box and selecting "Format" form the contextual menu.

Lab no.4

Today we are learning about entering different types of data such as time, date, text, formulas.
We can display formulas in worksheet cells instead of the results of formulas by pressing Ctrl+’ or clicking the Show Formulas button on the Formulas tab

So in order to enter a formula we need to do the following steps

•  Click the cell where you want to enter the formula.  
•  Click in the Formula bar.
•  Enter the equals sign (=).
•  Enter the formula. 
•  Press Enter or click the Enter button (the check mark).

Speed Techniques for Entering Formulas
-Instead of typing a cell reference, you can click the cell you want to refer to in a formula. It works even for blocks of cells.

Excel gives you the opportunity to use data from different worksheets in a formula. This is called a 3D reference. It is almost like creating a regular formula.
 

new

I messed something up with the other blog... for some reason it doesn't appear in my dashboard... I hope this one will be ok..