Computer Tutorials for Beginners

Hi interesting readers, Prathysha NGO, Chennai. Bala gurukul orphange, chennai. Pratyusha support, Hyderbad. Krr oldage home, Vizag. Disa foundation.......................................................... so on..................... Join hands with us for a good cause. Thank you all. Contact  us on our  whatsapp no:  8939374254    for the more details. You can pay through Paytm scanner. for each donor we will give an online PDF book as a gift. Thank you Pratyusha Home

Combining Arithmetic Operators in Excel  - The basic operators you've just met can be combined to make more complex calculations. For example, you can add to cells together, and multiply by a third one. Like this: = A1 + A2 * A3 Or this: = A1 + A2 - A3 And even this: =SUM(A1:A9) * B1 In the above formula, we're asking Excel to add up the numbers in the cells A1 to A9, and then multiply the answer by B1. You'll get some practise with combining the operators shortly. But there's something you need to be aware of called Operator Precedence. Operator Precedence Some of the operators you have just met are calculated before others. This is known as Operator Precedence. As an example, try this: Open a new Excel spreadsheet In cell A1 enter 25 In cell A2 enter 50 In cell A3 enter 2 Now click in cell A5 and enter the following formula: =(A1 + A2) * A3 Hit the enter key on your keyboard, and you'll see an answer of 150. The thing to pay atten...

Extending the Trendline - In   the first part   of this tutorial you saw how to add a Trendline Chart. The type of Trendline we used was an Linear Regression one. You can get Excel to extend the linear regression line on your chart. Click on your chart to highlight it. Click on the plus symbol again (Or bring up the Format Trendline dialogue box again, if you're using Excel 2007 and 2010.). Expand the Trendline option and select More Options. From the Trendline Options, have a look at the Forecast boxes. Type a 6 into Forward: Press the Enter key on your keyboard and you should see the line extend on your chart: New values have been added to the X-Axis. It now goes from 0 to 14. Trace the vertical line up from 12 until you come to the sloping line. Now trace a straight horizontal line the left, all the way to the Y-Axis, and you can see it reads a value of just above 20000: If you look in cell B14 of your spreadsheet, you can see that the value is a more pr...

How to Centre Text and Numbers  - You saw   that by clicking inside of a cell it makes it active, so that you can make changes. We want to centre all our numbers and the text. Here's the spreadsheet we have: So we need cells A1, A2, A3 and A4 to be active. In Excel, you can do this by highlighting the cells. Place your mouse over cell A1 Your pointer should now be in the shape of a white cross When your pointer changes to the white cross, hold your left mouse button down and drag to cell A4 Let go of the left mouse button when cells A1, A2, A3 and A4 are highlighted The image below shows what you are aiming for The cells highlighted in the image above have a different colour to the normal white colour of a cell. When you highlight cells, you can do things to all the cells as a group. To centre the text and numbers in our highlighted cells, try this: From the Excel Ribbon at the top of the screen, locate the   Alignment   panel. Here's the Ali...

How to use the AND and SUMIF Functions in Excel  - Two more useful Conditional Functions are AND( ) and SUMIF( ). We'll stay with the students exam results to examine these two functions. If you haven't yet downloaded the spreadsheet we're using for these lessons, click below. (If you've been following along, you can use this new spreadsheet: it has the CountIF already done!) Download the spreadsheet for this section The AND Function Here's the scenario. The government have decided to take a closer look at school averages. If 4 or more students in a subject get a score of 70 or above, then the school gets a cash bonus for that subject. There are 8 subjects, so 8 cash bonuses are up for grabs. First, we'll use the AND function to work out if 4 or more students have scores of 70 or above. The AND( ) function checks a list of arguments and determines whether they are true or false. If all the arguments are true then the function gives you an answer of...

Microsoft Excel  Tutorials -Excel Spreadsheets -In this section of the course, you're going to learn what spreadsheets are, and what they can do. You'll get a first glimpse of the Microsoft Excel software, and how it works. You'll also learn about cell coordinates, rows and columns, and how to enter data into a cell. So, let's make a start. What is a Spreadsheet? A spreadsheet is a piece of software for handling and manipulating numbers. You can write numbers down on a piece of paper and add them up. Like this: 23 12 10 45 = But that's not a spreadsheet. However, if you bought Microsoft Excel and entered the same numbers into the software, you'd have a spreadsheet. The best part about a spreadsheet is - you don't have to do any adding up yourself! The programme will add the numbers up for you. A spreadsheet doesn't only add up, of course. It can do a whole lot more besides simple arithmetic. It can handle financial calculations, statistica...