Computer Tutorials for Beginners

How to Create a Pie Chart in Excel  - Pie charts are quite easy to create in Excel. In case you're not sure what a Pie Chart is, here's the basic one you'll be creating. Later, you'll add some formatting to this: To make a start, you need to highlight some data. If you've been following along with the   previous tutorials , then you'll have some viewing figures data. You've created a 2D chart with the BBC data. This time we'll use the ITV data. If you don't have this data, create the following simple spreadsheet. The cells to use are D4 to E14: Click inside cell E4 and change "Millions" to ITV, if you already have the data from a previous lesson Highlight the cells D4 to E14 Click the   Insert   menu at the top of Excel Locate the   Chart   panel, and the   Pie   item: In Excel 2013 and 2016, the Pie chart is harder to spot. But it's highlighted in green in the image below: Click the down arrow and select the...

How to Use Microsoft Excel Tables   - In Excel, a data Table is a way to see how altering the values in a formula effects the result. Excel will work out the new results for you, based on the new values you give it. Take the following as an example: You decided to take out a loan of ten thousand pounds. You want to pay back the loan over 5 years. The first bank you try sets a interest rate of 9 percent per year. You use the PMT formula to work out how much you have to pay back every month: =PMT(9% / 12, 12 * 5, -10000) The formula gives you a figure of £207.58 per month. However, another three banks are after your business. They are offering interest rates of 8 percent, 7 percent, and 6 percent. You can use the PMT function again to work out the monthly payments for these interest rates, or you could just use a cell reference for that 9% figure in the formula. Another way to work out the monthly payments for the new interest rates is to use a Table. Excel will then use th...

Setting up an Outlook Express Email Account (part 2)  - In the   last part , we left it at the point where the Email Account Wizard pops up. We'll continue right now. When the Wizard first starts, it will look like this: Type in a name you want for display purposes. You can type in anything you like here. It doesn't really matter because Outlook Express will completely ignore the name you pick! Click the "Next" button when you're done. The screen will change: You need to type in an email address. Type in the email address you got from your Internet Service Provider. Once you have entered the email address, click Next. You'll get the following screen It looks a very daunting screen, so let's break it down. Your   Incoming mail server is   probably a POP3 one, so leave the drop down box as it is. The first text box is   Incoming mail (POP3, IMAP or HTTP) server . You can usually get these details from your Service Provider...

Beginners Guide to going Wireless -US Robotics Wireless MAXg ADSL2+ Gateway  - The US Robotics Wireless MAXg ADSL2+ Gateway is for those who have an ADSL connection. Here's a picture of the MAXg, though. Use with : MAXg Network adaptor   Review The MAXg in the title is a technology that was designed to improve the speed of the wireless signal, and how much data can be carried. This US Robotics router works well at ranges of up to 10 metre, and decent (but hardly impressive) results over longer ranges. Signal range is vastly improved with with a MAXg Network adaptor like the one above. Centrino laptop users will pleased to hear that this router plays well with your notebook at ranges below 20 metres. Above that is a different story! Another good feature is the built-in ADSL2+ modem. This is designed to support ADSL speeds of up to 24 megabits per second. If you're in the UK, you won't be getting speeds above this any time soon, so it's a good buy. ...