Computer Tutorials for Beginners

Add Data Labels to an Excel Pie Chart  - In the   previous tutorial , you created an Excel Pie Chart that looks something like this: At the moment, though, there's no information about what each segment represents. We're going to add the numbers from our ITV viewing figures. These ones: To add the numbers from our E column (the viewing figures), left click on the pie chart itself to select it: The chart is selected when you can see all those blue circles surrounding it. Now right click the chart. You should get the following menu: From the menu, select   Add Data Labels . New data labels will then appear on your chart: The values are in percentages in Excel 2007, however. To change this, right click your chart again. From the menu, select   Format Data Labels : When you click Format Data Labels , you should get a dialogue box. This one: If there's a tick in Percentage, untick this and select Value: Your chart will then have...

Excel Projects - Project One - The picture below shows a simple spreadsheet. There are no formulas in it, and nothing is being added up or subtracted (we'll do that in the next section). For Project Number 1, reproduce the spreadsheet above (the famous junk food diet!). Your spreadsheet must include the following: Centred text and numbers Widened columns Bold font for the text and numbers Background colours or patterns for the cells In the prices column, you'll notice that the Currency sign has been included. To get theCurrency signs in your spreadsheet, do this: First enter a number for the price, but enter a zero then a full stop first, then the numbers. So enter 0.35 for the first price and not just 35 When you have all five prices, highlight the cells C4 to C8 With the cells highlighted, click on Format from the menu bar From the menu that drops down, click on "Cells" You'll get the familiar Format ...

Customize Your Folder Views in Windows XP  -As well as the folder options from the dialogue box, you can do a certain amount of customization of you folders. Here's how. Change how the Files are displayed In the image below, the files in the folder are displayed as Tiles: To change how the files are displayed, either click the View menu at the top, or click the Views icon in the toolbar: The black dot shows you which View is currently selected. The five different Views in XP are Thumbnails, Tiles, Icons, List, and Details. When you click  Thumbnails , you'll see your files set out like this: When you click  Icons , you'll see your files set out like this: When you click  List , you'll see your files set out like this: When you click  Details , you'll see your files set out like this: The only two views where file information is directly displayed are Tiles and Details. Otherwise, you have to move your mouse over a file to get mo...

Accessibility Options - Windows XP FilterKeys  -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 or a member of the family have difficulties using the keyboard (trembling hands that produce multiple keystrokes, or difficulty pressing and releasing the keys quickly enough), then Windows XP has an option called   FilterKeys . This is on the Accessibility Options dialogue box. To see it, click the   Start   button in the bottom left of your screen. From the Start menu, click on   Control Panel . Double click the   Accessibility Options   icon to see the following screen. With FilterKeys, you can control how long the keyboard takes to respond before the next key press is ready (under normal circumstances this is immediately), and tell XP to ignore repeated keystrokes. To see what you can do with FilterKeys,...

Microsoft Certificates - Office Specialist (MOS)  -The Microsoft Office Specialist qualification is aimed at those wanting to become more expert in the software packages that come with Microsoft Office. There are three grades on offer: Master Expert Specialist You can become a Specialist by passing just one of the following exams: Word Excel PowerPoint Access Outlook As an Expert, you'll concentrate on either Word or Excel. To attain the title of Master, you need to pass the Word, Excel, and PowerPoint exams, plus either Access or Outlook. To give you an example of what's involved, if you've already done the first half of our Excel course, you should have no problems becoming a Specialist. Our full Excel course is equivalent to the Expert grade. The Exams The MOS exams are said to be performance based. That is, you are given a set of instruction to follow, typically modifying a business document. For example, if you were doing the Excel exam, you...

Javascript Tutorials for the Beginner - Welcome to the Home and Learn course for Javascript. Although it is aimed at complete beginners to the subject we do assume that you have some knowledge of HTML and a little CSS. You don't have to be an expert, though. Just the basics will do. (If you're not sure about the HTML then see our Web Design course.) You don't need to buy any software for this Javascript course - you probably already have everything you need to get started.   > Section One: Getting Started 1. Software needed 2. Our Javascript Templates 3. A little word about debugging Home Page > Section Two: The Browser 1. A First Script 2. Javascript Tag Placement 3. The Browser Object Model 4. Browser Window Methods 5. The Document Object Model > Section Three: Javascript Programming Basics 1. Javascript Variables 2. Math Operators 3. Operator Precedence 4. IF Statements 5. IF ... Else 6. Comparison Operators 7...

Visual C# .NET Contents Page  - This computer course is an introduction to Visual C# .NET programming. It is aimed at complete beginners, and assumes that you have no programming experience whatsoever. You don't need to buy any software for this course! You can use the free version of Visual Studio from Microsoft. To see which version you need, click below: Getting the free Visual Studio - Which version do I need? To work your way through our C# .NET course, simply click a link below - no need to sign up for anything! > C# .NET: Getting Started with C# 1. Getting Started - A C# Console Application 2. Saving your work 3. Your first line of C# code 4. How to Run your C# Programmes 5. Your First C# Windows Form Home Page 6. Adding Controls to a Form 7. Properties of a Control 8. Adding Code to a Button 9. C# Message Boxes 10. More about Message Boxes   > C# .NET: Variables 1. String Variables in C#. NET 2. Assigning Text...

Android Programming - Contents Page This Home and Learn computer course is an introduction to Android programming for beginners. Read the first section below to see what you need to download to make a start. Android uses Java as its programming language. Although you do need some Java skills, you don't need to be an expert, by any means. In fact, for the first few sections, you won't need much in the way of programming skills at all. Give it a try and see how you get on! > Section One - Getting Started with Android 1. What you need to download 2. Getting Started with Android Studio 3. A First Android Project 4. How to Run Apps in Android Studio Home Page >   Section Two - Android Layouts 1. Android Layouts Introduction 2. Layout Widgets 3. Adding Images to Android Studio 4. Linear Layouts 5. Android Buttons 6. Android XML Strings > Section Three - Android Activities 1. Android Activity Introduction 2. The Activity...