Case 6

Case 6 was an incredible case. So much stuff in it...amazing. It tests on the editing and formatting of multiple worksheets at the same time. This is very important for when you have similar tables from different affiliates of a company, for example, that have different data but same style of table. By grouping different sheets it is possible to change the formatting of a cell or to enter a formula into all the grouped sheets at the same time. You win so much time by doing it that way. When entering a formule in one sheet it is possible to refer to a cell in a different worksheet. This case also tests on creating a link to an other workbook and also to insert a hiperlink in a cell. At the end it is also asked to save two different workbooks into one workspace. So when you open this particular workspace both workbooks will open together one next to the other (titled). It also asks to create a static web page and a custom template. A custom template is very important in the business world. All companies use templates for letters etc. They always use the same layout, header and footer. So they create one or more custom templates so that they do not have to rework the layout, header and footer every time.

The Pivot table is very useful and it is easy to "play around with it". You can decide what to take as column and row very easy by just dragging it in the boxes of column and row. It is also possible to see what to use as value and so much more...thank you for that class. It was nice ending it like that before pessach with case 6 and Pivot table and chart. Have a nice pessach and congratulation to Professor Jorisch for being elected Professor of the year!