Sunday, April 25, 2010

Excel Extended

This week for CIS I was required to complete 4 parts to a Microsoft Excel project. I learned different ways to show data in charts and organize information in excel sheets. Color-coding was part of the project as well as resizing rows and columns and formatting. I used formulas in most parts of the project, but I have learned to create them through my duration of working in data entry at the payroll firm I am currently employed at. One thing I learned this week that I thought was really interesting is the data bars feature. It uses less space than a chart but gives similar results. I will definitely be keeping that tool in mind for future data sets in excel sheets.

Saturday, April 17, 2010

Excel in CIS

This week for my CIS class I had part 1 of a Microsoft Excel project. In the process of completing this assignment I learned new ways to make an excel sheet more attractive and fancy.  Most of what was taught I already knew from experience I have had with using excel for school assignments in my accounting classes and at work.  In fact, most of the shortcuts, etc. I learned from my manager at work, but other than that my knowledge is from just playing around with the program to figure stuff out.  So long for now...