Author Archives: Karl

How to add, remove or reposition text used to label each axis? | Excel 2007

Click on the chart and go under Chart Tools and Layout tab. In Labels section click on “Axis Titles” and from the appearing menu choose which axis you wish to edit. From the next selection determine whether you wish for the title to show up or not. Also choose the placement for the title if you decide to show it on the chart. Unfortunately no live preview is shown however you get a pretty good image of the display from the little picture before every selection.

Continue reading

How to print the slides so that you would have an area for notes on the side? | Powerpoint 2007

If you want for your printed slides to have an area for notes on the side, you need your slides to be printed out as handouts. Having the slides prepared click on the Office button and choose “Print” from the menu. Click on “Print” from the right handed menu and notice a new window appear.

Continue reading

How to add subtotals to an Excel table? | Excel 2010

Select your table and sort the column where the groups are displayed. To sort, go under Home and Editing section. Click on „Sort & Filter” and choose on of the first two. Next go to Data and click on Subtotal. Under „At each change in” select the column the group is in. In the next section select the function you want to be used and in the third bit select the column the subtotal is added to. Click on OK when you’re done.

Continue reading