Monday, September 24, 2012

Chapter 3 Excel

I personally think...
  1. The first bar chart shows data clearly. However, it does not contain all the information.
  2. The two dimensional line chart was the easiest one to be made among all three charts. Moreover, we can tell how the prices go from this chart and compare the prices just by looking at it.
  3. The three dimensional column chart looks way too complicated. It is hard for people to read the data. I personally do not like looking at this kind of chart.

In conclusion, I like the two dimensional line chart the best out of the three charts due to the reasons above.

Sunday, September 16, 2012

Excel (Chapter 2)

I took Accounting 211 in the first semester at Behrend so I am actually quite familiar with the income statement and balance sheet and stuff. I also took SCM 200 last semester, so that I did not have too much problem while doing the Excel assignment.

There was still something new I learned from this assignment - formating the workbook for printing. Turning off the gridlines was easy. However, it took me a while to set the page breaks. I got some help from my friend, Alvin, and eventually got it done.

I personally think the instruction for this assignment was not clear enough. For example, the ninth point on the first page said we had to break it into three pages. On the third page, it said we had to give page four and five as well. Moreover, It said the output requirements should be without formulas yet, the pictures shown below were with formulas. That was quite confusing.

Sunday, September 9, 2012

Excel

Excel is a spreadsheet program. It allows us to setup charts and reports which makes it
powerful. We can also easily get the totals and figures. I have learned to use Excel for k
eeping track of my personal finances and I definitely love it because I can figure out how much I spend in a period of time without any difficulties.


Nowadays, the use of Excel is indispensable in financial modeling and analysis. It is used for data input, consumer data, and other types of analysis information that a business will keep track of. The functions and formulas in Excel help the financial analysts out and make their work easier. Excel helps organizing a company as well.