Sunday, September 26, 2010

Excel Project

I completed the Excel project today with little problems. The centering and bold instructions were very straightforward and simple. The first challenge that I came to was selecting the areas to paste the relative formulae to. When using the shift/control.down arrow keyboard shortcut, the entire column was selected, well paste the data. I used the mouse to scroll down while holding shift, selecting the first and last cells in the column with no issues.

The printing preferences in Excel 2010 are slightly different than in 2007. I feel it was even easier to do these steps with my new desktop than with my laptop running the older version. The headers and footer and footers were very intuitive and I did not need to use the help functions.

Before this class I had no experience with Pivot Tables. The first one gave me a little trouble, but once I realized I was not giving the program enough information to make the table, it went just fine. I really like this feature and can see using it very soon.

Here is the screenshot of the AvgIncrease Pivot Table:

No comments:

Post a Comment