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.