Computer Tutorials for Beginners

How to Enter Text and Numbers in a Cell  - To make a start, we'll create this really simple spreadsheet: All we're going to be doing here is entering some text and some numbers. We're not adding anything up yet. Before you tackle this first exercise, though, you may want to take note of the  Undo  feature, just in case you make a mistake. The Undo option is the left curved arrow, right in the top-left of your screen. This one for Excel 2007 users: And this one for Excel 2010 and Excel 2013 users: For later version, thie icon is this: Click the left curved arrow to Undo something, and click the right curved arrow to redo it. The Undo arrow also has a dropdown box. Click the small arrow next to Undo to see the following: This list is for multiple Undo's. Move your mouse down the list and click to undo several steps at once. But back to the spreadsheet. Click inside of cell A1 on your spreadsheet, and do the following: Type the word "Nu...

Microsoft Excel and Pivot tables - As you'll shortly see, Pivot Tables can become quite complex. So we'll take it easy and just design a simple one. But first, what is a Pivot table? What is a Pivot table? A Pivot table is to a way to extract data from a long list of information, and present it in a readable form. Remember the data we had from the student scores spreadsheet? You could turn that into a pivot table, and then view only the Maths scores for each pupil. Or view just Paul's scores, and nobody else's. To get a clearer idea of just what a Pivot Table is, examine the one below. You'll be designing this very Pivot Table yourself shortly. In this school, there is a test every month (it's a tough school!). The Pivot Table above shows the marks that Elisa got in January, February, and March. There were tests for only 6 subjects. Notice the black down-pointing arrows in the Pivot Table. On Row 1 we have Student Elisa. If the black arrow were c...

How to use the Date Functions in Excel - There are a numbers of different reasons why you would want a Date or Time function in a spreadsheet: If you're running your own company, you might want to record when an order was received and when it was processed. You could then calculate the difference between the two, so that you check how fast the orders were being processed. We'll do that now. Date Functions Set up this simple spreadsheet in Excel Click inside cell A3. To enter a date Function, do the following: Click on   Insert   from the menu bar From the drop down menu, click on   Function The Paste Function dialogue box appears In the   Function category   section, click on   Date & Time In the   Function name   section, click on   Date Click the OK button at the bottom The formula palette appears on your spreadsheet What Excel wants you to do here is to enter some figures for the date. So: C...

Excel Formulas - Combining the Mathematical Operators - There are times when you will want to combine the arithmetic operators in your calculations. Here are a few examples of combining the operators: Example 1 Start a new spreadsheet Enter the number 25 in cell A1 Enter the number 50 in cell A2 Enter the number 2 in cell A3 In cell A5 enter the following formula =(A1 + A2) * A3 Press the Return key on your keyboard to get the answer The answer you should have got was 150. Notice the brackets in the formula. The brackets group part of your sum together. Without them, Excel will normally calculate from left to right. But it does some calculation before others. Excel sees multiplication as more important than adding up. To see what happens without the brackets, do this: Click on cell A5 Click inside the formula bar at the top Delete both the brackets from the formula Press the return key on your keyboard to see the answer Now the answer i...

Project Two - You have just created a spreadsheet on Chocolate addiction. Time now to reveal your addiction! Create a spreadsheet like the one in the last section, but substitute Chocolate Addiction for something else. Examples might be: smoking, drinking, eating out, clothes, make-up - in fact, anything that someone might be spending too much money on. (It doesn't have to be you doing the spending; it can be entirely made up.) Your spreadsheet must include the following: Daily totals Individual totals Weekly total Columns for Prices Columns for Number and Cost Weekly cost Annual cost You can format the spreadsheet any way you like. The colour scheme is entirely up to you. Just make sure that your spreadsheet is easy to follow.

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

Search With Cortana  - If you can't find a file or a program on your computer, you can use the Cortana search box at the bottom of Windows 10. You can even use the search box to open up programs, if you use voice search. You can simply click inside of the box and type whatever you're searching for. In the image below we're searching for Windows 10: Notice the various categories: Best Match, Settings, Web, Store. These categories help you narrow down your search. Click the   More   arrow at the top to see more categories: So, for example, if you were searching for an image, you could click the Photos category to narrow down your search. Cortana would then only search for images. Click the X in the top right to go back to the first list of categories. If you have a look at the top of the first list, you'll see three icons: These are shortcuts to search the Web, search the Documents folder on your computer, and search for Apps. Click one of these, if ...

Computer Mouse Settings in Windows 10  - You can adjust the settings for your mouse, if you're not happy with things like the speed it goes across your screen. To adjust your mouse settings, bring up your   Settings   screen. A shortcut for this is to hold down the Windows key on your keyboard (in between the CTRL and ALT keys on the left-hand side). With the Windows key held down, press the letter   i   on your keyboard. On the settings screen, select   Devices : The screen will then look like this: Select Mouse &Touchpad from the list of items on the left. You'll then see these options appear: There's not a great deal of options to change on this screen. But if you're left handed, you may want to change the primary mouse button. The primary mouse button is the one you use most often, and is clicked when selecting things. Click the dropdown box and you'll see that this can be changed from Left to Right. To see a wider range of mouse s...

Windows 10 Tutorials and Lessons-   Getting Started with the Windows 10 Desktop   Change your Desktop Background Image   Desktop Background - Solid Colors (Advanced)   Tweak your Mouse Settings   The Windows 10 Start Menu   Search with Cortana   Cortana Voice Search   The Windows 10 Start Menu - Tiles   The Windows 10 Taskbar   Taskbar Settings   Taskbar - Notifications   Windows 10 Privacy Settings   Windows 10 Privacy Settings - Part 2 Home page

Create your own Stationery in Outlook Express  - You can create your own stationery in Outlook Express, and add any images you like. Your new stationery will then be available any time you need it. From a new email, click   Format > Apply Stationery > More Stationery   from the menu bar. This will bring up the Select Stationery dialogue box: Click the button   Create New . You'll then get a Wizard popping up. Click next to see the following screen: From this screen, you can select an image to use as your stationery, and specify where it should go on the page. Click the Browse button to select the image you want to use for your stationery. (You don't want to select images that are very large, because the size of the file would be too big. Aim for an image that's no more than 10 to 15 kilobytes in size.) In the images below, we've clicked the Browse button to navigate to an image we want to use: In the two images above, we've chosen a p...