How Column Charts Work in Excel 2007

In this tutorial will look at creating and customising a column chart. The first step is to select the data that we want to plot, taking care to include any column and row headings. Row headings will be used as the names of the chart series and will be displayed in the legend. Column headings will be used as category labels. If the selection includes two sets of column headings, Excel will automatically recognize this and create two sets of headings on the category axis for us.

PowerPoint 2007′s Slide Masters Offer Total Control Over Your Presentation

PowerPoint 2007′s slide master feature has been significantly enhanced. It now offers users very powerful and flexible control over the appearance of related slides within a presentation. To access the slide master, activate the View Tab of the PowerPoint Ribbon and click on the button marked “Slide Master”. There is also a handy shortcut for switching between normal view and slide master view: hold down the shift key and click on the Normal View icon on the right of the status bar (next to the zoom icons). The slide master is displayed in the pane on the left of your screen along with all the various master slide layouts.

Mastering COUNT, COUNTA And COUNTBLANK In Microsoft Excel 2007

Excel contains a wide range of functions which are conveniently arranged into categories. The COUNT functions are found in the statistical category. There are five of them; COUNT, COUNTA, COUNTBLANK, COUNTIF and COUNTIFS. We will examine the COUNTIF and COUNTIFS functions in another article. In this article, we will be looking at COUNT, COUNTA and COUNTBLANK.