Computer Tutorials for Beginners

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

Font formatting in Excel  - You can change the font of your text and numbers, and make it bold. You can also change the size of the font and the font colour. We'll first format the text in the cell A1, from our spreadsheet in the previous section. To format the text in the cell A1, then, do this: Click on cell A1 with your left mouse button Click on Format from the menu bar From the menu that drops down, click the word "Cells" with your left mouse button The Format dialogue pops up again This time, click on the word "Font", instead of "Alignment" Your dialogue box will look like the one below (in Excel 2000) From the dialogue box, change the Font Style to Bold Change the size to 8 Click the OK button at the bottom Your spreadsheet will now look like the one below The cells don't have to be white. You can change them to whatever colour you want. We'll add a spot of colour the ours cells. Changin...

Desktop Background Colors - Advanced Users  - A lot of us like to have a solid color for our desktops, rather than a background image. Unfortunately, Windows 10 only allows you 24 solid colors. These ones: If you're happy with the selections on offer, simply click one of the color squares. If you want to select from a wider range of colors, however, the process is a little more complicated. Right-click the start menu. Then select the   Run   item from the menu that appears. Type the following into the search box that appears: control /name Microsoft.Personalization /page pageWallpaper Make sure you have the spaces in the right place, and that your spelling is the same as above. And notice the dot between   Microsoft   and   Personalization . Click OK on the run box and you should see this screen: Click the   More   link to see a color dialogue box: Select the color you want and click OK. Then click   Save Changes  ...

How to change your Desktop background image in Windows 10  - One of the first thing you might want to do with Windows 10 is to change the desktop picture, which tends to be quite awful by default. To do that, click with your right mouse button anywhere on the desktop, except the taskbar at the bottom, or an icon. You'll then see the following menu: Select   Personalize   from the list and you'll see a screen appear like this one: Make sure   Background   is selected on the left hand side. The Background dropdown menu is showing "Solid Colour" for us. If you like a solid colour for your desktop background, select one of the available colours. If you prefer to have an image, click the dropdown to some choices: The choices are Picture, Solid Colour, and Slideshow. If you select Picture, you'll see some images and options appear underneath the dropdown box: If your picture is not big enough for your screen, click the dropdown beneath   Cho...

Internet Options - Content Advisor  - 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 The Content Advisor allows you to set what sort of content you want to allow on to your computer when surfing the internet. If you don't want the kids coming across adult material then Internet Explorer can block this. It is not, however, entirely effective, and you shouldn't rely on it as your only content blocker, if this is a concern to you. Software like   Netnanny   and   Cybersitter   can do a better job. But to see how the Content Advisor works, click the   Content   tab of the Internet Options dialogue box. You'll see the following: The Content Advisor is at the top. If your button says   Disable   instead of   Enable   it means that you already have Content Advisor switched on. We'll assume th...

Accessibility Options - Windows XP StickyKeys  -This tutorial assumes that you have set the Control panel to Classic View in Windows XP. To see how to do this, click this link (opens in a new window): Set the Control Panel to Classic View The StickyKeys Option is for people who have problems holding down two or more keys on the keyboard at the same time. If you want to bring up the Task Manager, for example, you'd hold down the CTRL and ALT keys on your keyboard, and then press the Delete key. If, for whatever reason, you're not able to do this, then StickyKeys can come in handy. To bring up the StickyKeys dialogue box, click the  Start  button in the bottom left of your screen, then click  Control Panel  on the Start menu. From the Control Panel, double click " Accessibility Options ". You'll see the following dialogue box: Put a tick in the box where it says "Use StickyKeys". Then click the  Settings  button. You'll see this dialo...

Parental Controls in Windows 7 In   the last lesson, you'll learn how to set up a new user account. However, If the user account you're creating is for a child, you may want to set some Parental Control. We'll do that now. Make sure you are logged in to your own account, and that you are Administrator. (if you're not sure what this means, go back to   the last lesson.) To get to the accounts page, click your picture on the Start menu: When the User Accounts screen appears, click the link in the bottom left that says "Parental Controls", circled in red in the image below: This will take you to a screen showing all the user accounts available: Click on the account you'd like to change, which is   User2   in our case. When you click on account, you'll see the following screen: Select the option at the top for "On, enforce current settings". The three options below that will then become available. The first option,   Tim...