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 Multiply in Excel  - In the previous parts of this Excel tutorial, you have been working on a spreadsheet that now looks like this: To get the weekly cost of each chocolate bar, we need to multiply the   Number   of bars eaten in one week by the   Price . This can then go in the   Cost   column. The standard way to multiply things is like this: 12 x 10 = 120 The "x" means multiply. In a spreadsheet, however, the letter "x" is not used to multiply things. Spreadsheets use the asterisk symbol instead (the one above the number 8 on your keyboard, in the UK). The previous sum would then look like this: 12   *   10 = 120 Actually, in Excel, you don't need much more than that to multiply. The only other thing you need is an equals sign before the formula. So to get the answer 120, you'd just enter this into any cell: = 12   *   10 Instead of entering numbers directly, though, we'll enter a cell reference instead. To ...

How to Place an Image onto an Excel Spreadsheet  - Inserting an image into Excel is fairly straightforward. Below is a spreadsheet with a picture in it. The picture serves to illustrate a lesson on the circumference of a circle. The image above was inserted like this: From the Excel menu bar, click on  Insert From the drop down menu, select  Picture From the sub menu that appears, click on  From File  (Click the Clip Art option if you want to insert a clip art image.) The following dialogue box appears: Navigate to where on your computer your picture is Then click  Insert Once the picture is inserted into Excel, you can resize it and move it to a new location. You can even crop it down a bit by using the Crop tool on the Picture toolbar ( View > Toolbars > Picture ). And that's it for the Excel course! Hope you enjoyed it, and that you're inspired to create even more complex spreadhseets than the ones you've c...

Formatting an Excel Pie Chart  - When you click the Finish button after step 4 of the Chart wizard, the wizard closes, and your new chart appears in your spreadsheet. Your new chart will have the black squares surrounding it, indicating that it is selected. Click anywhere on a white area (Top left corner of the chart is ideal). Hold down your left mouse button and drag the chart downwards into some space. When you have moved the chart, you need to resize it. Hold down your left mouse button on the centre black square at the bottom. Drag downwards to increase the height of your chart. When you have finished, you should have a pie chart on your spreadsheet like the one below: If part of your title "Viewing figures in millions" is hidden, you can move it over. Click on your title with your left mouse button. You'll see a border appear around the title: Click on the shaded border with your left mouse button. Keep your left mouse button held down and drag it ...

Internet Options - Privacy - For this tutorial, you'll need the Internet Options dialogue box. To see how to bring it up, click this page (opens in a new windows): How to bring up the Internet Options Dialogue Box Another tab on the Internet Options dialogue box is   Privacy . This allows you to choose your Cookie settings, and whether to allow popup windows. The Privacy tab looks like this: Before you play around with the slider above, you need to know what Cookies are. What is a Cookie? A Cookie is a small text file that a website places on your computer. It does this because web pages are not good at remembering things. If you select an option a form, and then go to another page on the same site, the next page won't know what you selected on the previous one. This is important if you do any online shopping, for example. If you order two things on two different pages, and then click the "Check Out" button on the second page, only one of them will ...

Windows XP User Accounts  - This tutorial assumes that you have set the Control panel to Classic View. To see how to do this, click this link (opens in a new window):   Set the Control Panel to Classic View If you have only one computer in the house, but more than one person who uses it , you can set up a separate user account for each person. That way, they can have their own settings, and customisation. For example, they can have their own desktop wallpaper that you won't see when you login to your account. Here's how to set up a new user account. User Accounts To get at the settings for the User Accounts, click   Start   and then   Control Panel . From the Control Panel, double click   User Accounts . This will bring up the following dialogue box: In the image, we have two accounts already set up. We have an account called   kc , and one called   limited . Each has its own icon. But notice that one account has "administrator" n...

Copy and Paste Pictures to a New Folder  - In this tutorial, you will learn how to copy and paste pictures to a new folder. Once you've done that, you will learn how to add information to each image, so that they can be located and referenced more easily. Let's start by creating a new folder. Start the Windows 7 Explorer by clicking its icon to the right of the Start button: When Windows Explorer starts, click on  Pictures  in the  Libraries  section of the Navigation pane (If you can't see the Navigation pane, click the  Organize  button at the top. Then select  Layout > Navigation pane ): On the right, you'll see folders that are in this library. Windows 7 has some Sample Pictures in this library. But you can add your own, and create folders for them. Create a folder by clicking the New Folder button at the top: The new folder appears, with blue highlighted text: The blue highlight means that you can go ahead and type ...