Microsoft Excel Column Formatting Techniques

Microsoft Excel offers a number of different ways of changing the width of columns and the height of rows. The width of columns is expressed in characters. By default, each column has a width of just over eight characters. This means, for example, if you’re using the spreadsheets primarily for numerical data, you can enter eight digits in each column using the default width.

Creating Excel Macros Which Run Automatically

As well as macros that can be run manually, in Excel VBA, it is possible to create macros which are executed automatically when a certain event takes place in the Excel environment. One such event is the opening of a workbook. There are two principal methods of creating macros which run when a particular workbook is opened, both of which involve placing code inside the workbook itself.

Unraveling The Complexities Of PowerPoint Slide Masters And Layouts

Microsoft PowerPoint 2007′s slide master feature has been significantly improved. 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 nifty 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 the associated master slide layouts.