Posts Tagged ‘software programs’

Older Entries

Don’t Record Your Macros Write Them With Excel VBA Training

In: computers

8 Jun 2010

Most people’s first knowledge of Excel VBA (or Visual Basic for Applications) is recording a macro. As a user performs a series of operations (e.g. opening a workbook activating a particular worksheet, copying some data, etc) Excel will faithfully record each step and create the necessary VBA code. Each time the user runs the macro, these steps are replayed exactly as they were originally recorded.

Select Text With The Mouse In Word 2007

In: computers

17 Jun 2009

Before you can do anything to your text in the way of formatting in Microsoft Word 2007, you need to highlight it. Highlighting a piece of text is a way of telling Word that you want to work only with the selected text. (Highlighting is also known as selecting.)

Keyboard Shortcuts For Highlighting Text In Microsoft Word

In: computers

17 Jun 2009

As well as using the mouse, Microsoft Word 2007 offers a number of handy options for selecting text via the keyboard. Most of these options involve using the Shift key together with other keys. In addition, there are also some techniques which rely entirely on the keyboard.

Excel 2007 Number, Currency And Accounting

In: computers

17 Jun 2009

When entering numbers into a spreadsheet, you sometimes need to ensure that the number format is consistent. For example, if the numbers in question represent prices, you may want to display a currency symbol or you may simply want to make sure that the number of decimals displayed is consistent..

The Microsoft Word 2007 Mini Toolbar

In: computers

15 Jun 2009

The Mini toolbar is a floating window which automatically pops up whenever you highlight text. Initially all the options it contains are conveniently dimmed. However, as soon as you position the cursor over its controls, the Mini toolbar becomes activated.

File Formats Old And New In Word 2007

In: computers

15 Jun 2009

Microsoft Word 2007 is capable of working with documents in three file formats. The native format uses the file extension “.docx”. Files saved in this format can use the full range of features found in Word 2007, with the exception of macros. Any Word 2007 document which contains macros must be saved in a separate file format using the file extension “.docm”.

Navigating In Microsoft Excel 2007

In: computers

14 Jun 2009

Each Excel document is called a workbook and each workbook can contain up to 255 worksheets. To navigate to a particular worksheet, click on one of the tabs displayed at the bottom of your screen.

File Formats Old And New In Word 2007

In: computers

13 Jun 2009

Microsoft Word 2007 is capable of working with documents in three file formats. The native format uses the file extension “.docx”. Files saved in this format can use the full range of features found in Word 2007, with the exception of macros. Any Word 2007 document which contains macros must be saved in a separate file format using the file extension “.docm”.

Excel 2007 Number, Currency And Accounting Formats

In: computers

11 Jun 2009

When entering numbers into a spreadsheet, you sometimes need to ensure that the number format is consistent. For example, if the numbers in question represent prices, you may want to display a currency symbol or you may simply want to make sure that the number of decimals displayed is consistent..

AutoFill And Custom Lists In Excel 2007

In: computers

10 Jun 2009

Excel’s AutoFill facility relies on the program’s ability to recognize patterns in the values that you enter. For example, say you type “Week 1″ in a cell; you can have the program automatically enter “Week 2″, “Week 3″, etc. by dragging the AutoFill handle. This is situated in the bottom right of the cell. When the cursor moves over it, the cursor changes appearance to a plus sign (+). At this point you simply click, hold, drag in any direction and Excel will pick up the pattern and reproduce it to create automatic data entries.


Older Entries

Categories

Archives

Copyright © 2010 - blabstr.com - is proudly powered by WordPress