Computer Mentor – Healthy Computer

Posts Tagged ‘training’

In this article, we will look at Excel selection techniques which involve using the mouse in conjunction with the keyboard. One of the easiest and most useful is click followed by Shift-click. This is particularly handy for highlighting large ranges of data since it allows you to simply click on two opposite corners of the rectangular range of cells which you want to select. To perform this technique, first click in the top left cell of the range you want to select. Next, make sure that the bottom right cell of the proposed range is visible. Finally, holding down the Shift key, click in the bottom right cell. All the cells between the two clicks will then be highlighted.

Well before pondering upon that doubt let’s have a prompt review of what we are verbalizing about. When we verbalize about SAP, we are verbalizing about a worldwide industry leader in ERP (Enterprise Resource Planning) software. In fact SAP is the 3rd broadest software company of the world, with over12000 enterprises using SAP, having close to 80,000 installations and over 12,000,000 people making use of it. Therefore rest assured whatsoever you are planning to do with SAP, you are handling with some thing serious and proved over the years.

Big name companies look towards SAP when they think of revamping their IT infrastructures or to gain competitive reward by enabling business process change. SAP guarantees a seamless integration of procedures and applications across the board.

Whenever new cells are inserted into a worksheet, existing cells have to shift in order to make room to the newly inserted cells. When you insert entire rows or columns, the direction in which data will be moved is predetermined. If you insert an entire column, existing data is shifted to the right. If you insert an entire row, any existing data is shifted down. However, when you insert cells rather than entire rows or columns, Excel will always ask you in which direction we want the existing data to be shifted: to the right or down.

To insert a row of cells, begin by selecting the cells above which you would like the new cells inserted then choose Home – Cells – Insert – Insert Cells. Excel will then display a dialogue box asking you to specify what to do with the existing data and, naturally, you should choose “Down”. When you click OK, the existing data moves down and a range of cells is inserted matching the size as the range that was highlighted.

SAP or Systems, Applications, Products in Data Processing is a German placed organization which was launched in 1972. Since the organisation is Germany founded so it is full and official name is SAP AG which signifies Systeme, Andwendungen, Produkte in der Datenverarbeitung. The unique thing about SAP is that the 5 founders of the organization previously worked for IBM.

The company is the 3rd widest software making enterprise in the world and has got subsidiaries in more than fifty countries and is endlessly booming. At the moment it has got more than 17,500 customers and 27,000 individuals working for it with revenues of $7.34 billion. SAP has got 44,500 installations to it’s name in more than 120 states practiced by more than 10 million users.

When formatting text within an Excel worksheet, you have the choice of working at the cell level or at the text level. If you wish to work at the cell level you simply highlight one or more cells and choose your format settings. Any formatting that you choose will then apply to all text within the cell or cells.

For example, if you wish to change the font size of your data in Microsoft Excel, you can of course use the drop-down menu next to the font name and choose one of the preset sizes. Another method of changing the size is to use the Grow Fond and Shrink Font buttons located on the right of the font size. These two buttons simply use the same preset sizes available on the preset size drop-down. Having activated the font size text box, you can also use the cursor keys on your keyboard to move through different sizes. Yet another method is to enter a particular size then press the enter key. When you do so, you are permitted to enter decimals, such as 10.5.