Posts Tagged ‘Excel 2007 training courses’

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.

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..

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.

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.

Finding Effective Training On Microsoft Excel 2007

In: computers

7 Jun 2009

When you’ve taken the plunge and upgraded to Excel 2007, you will almost certainly benefit from some training. Which type of training you choose depends on your existing experience in using the program. However, in general, the ideal course will first of all rid you of the disorientation most Excel users feel when faced with the Excel 2007 interface. In addition, your Excel 2007 training course should show you how to make the most of the new features version 2007 has to offer.

Multiple Document Windows In Microsoft Excel

In: computers

1 Jun 2009

When working in Microsoft Excel, it is probable that you will sometimes need to open more than one workbook at a time. Excel allows you to do this and to display and navigate between the workbooks.

Setting Orientation, Margins And Paper Size In Excel 2007

In: computers

10 Apr 2009

Excel’s page formatting features are accessed by clicking on the page layout tab of the Excel ribbon. When working with page formatting, you may also find it useful to enter page layout mode by clicking on the page layout button in the status bar. Adjust the zoom as required and you now have a constantly updated preview of how your document will look when it prints out.

Transferring Excel Worksheets From One Workbook To Another

In: computers

7 Apr 2009

Excel allows you to change the order of worksheets within a workbook at any time. There are two ways of achieving this, the first of which is simply to drag the tabs representing each worksheet left or right. As well dragging individual tabs, it is also possible to highlight several tabs and drag them all at the same time.

Using The Freeze Panes Command In Microsoft Excel

In: computers

2 Apr 2009

A good many of the worksheets that are created Excel contain headings in the top row of the sheet. Normally, whenever we scroll down the sheet, any headings at the top will disappear. Similarly, if one scrolls to the right, any headings on the left will disappear. Excel’s Freeze Panes command, which is located in the View Tab of the Excel Ribbon, allows you to freeze our headings so that, as we scroll the sheet, headings remain in view.


Older Entries

Categories

Archives

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