• Complain

Gerard Strong - How to Use Microsoft Excel 2010

Here you can read online Gerard Strong - How to Use Microsoft Excel 2010 full text of the book (entire story) in english for free. Download pdf and epub, get meaning, cover and reviews about this ebook. year: 2012, genre: Computer. Description of the work, (preface) as well as reviews are available. Best literature library LitArk.com created for fans of good reading and offers a wide selection of genres:

Romance novel Science fiction Adventure Detective Science History Home and family Prose Art Politics Computer Non-fiction Religion Business Children Humor

Choose a favorite category and find really read worthwhile books. Enjoy immersion in the world of imagination, feel the emotions of the characters or learn something new for yourself, make an fascinating discovery.

Gerard Strong How to Use Microsoft Excel 2010
  • Book:
    How to Use Microsoft Excel 2010
  • Author:
  • Genre:
  • Year:
    2012
  • Rating:
    4 / 5
  • Favourites:
    Add to favourites
  • Your mark:
    • 80
    • 1
    • 2
    • 3
    • 4
    • 5

How to Use Microsoft Excel 2010: summary, description and annotation

We offer to read an annotation, description, summary or preface (depends on what the author of the book "How to Use Microsoft Excel 2010" wrote himself). If you haven't found the necessary information about the book — write in the comments, we will try to find it.

This easy to follow book helps employees, students, teachers and parents wanting their children to get a head start in their use of Spreadsheet software.
This book shows you how to use the basic tasks in Microsoft Excel 2010.
This simple step by step tutorial introduces you to the main functions of spreadsheets using Microsoft Excel 2010.
It is suitable for absolute beginners and those looking for a refresher guide into Excel 2010.
The book is divided into clear sections that demonstrate the separate skills that you can follow at your own pace.
The book offers a gradual introduction to the correct vocabulary to ease the learning of the software and improve future communication.
Overview
o An introduction to the basics of Microsoft Excel 2010.
o It can be used by professionals, teachers, parents or children.
o It shows you how spreadsheet may be used in a range of different situations.
o It is divided in a series of lessons/chapters which you can follow at your own pace.
o You will need no additional assistance.

Gerard Strong: author's other books


Who wrote How to Use Microsoft Excel 2010? Find out the surname, the name of the author of the book and a list of all author's works by series.

How to Use Microsoft Excel 2010 — read online for free the complete book (whole text) full work

Below is the text of the book, divided by pages. System saving the place of the last page read, allows you to conveniently read the book "How to Use Microsoft Excel 2010" online for free, without having to search again every time where you left off. Put a bookmark, and you can go to the page where you finished reading at any time.

Light

Font size:

Reset

Interval:

Bookmark:

Make
How to Use Excel 2010
o An introduction to the basics of Microsoft Excel 2012. o It can be used by professionals, teachers, parents or children. o It shows you how spreadsheet may be used in a range of different situations. o It is divided in a series of lessons/chapters which you can follow at your own pace. o You will need no additional assistance. Contents Chapter 1 Chapter 2 Chapter 3 Chapter 4 Chapter 5 Chapter - photo 1
Contents
Chapter 1
Chapter 2
Chapter 3
Chapter 4
Chapter 5
Chapter 6
Chapter 7
Chapter 8
Copyright Gerard Strong 2012 Trademarks All terms mentioned in this book that are known to be trademarks or service marks have been appropriately capitalised.

We cannot be attest to the accuracy of this information. Use of a term in this book should not be regarded as affecting the validity of ay trademark or service mark. Access 2007 and Microsoft are registered trademarks of Microsoft Corporation. Contact; mrgerardstrong@gmail.com

Chapter 1
What is a Spreadsheet
o Open Microsoft Excel Either double click on the short cut which looks like this. Or you can open it from the start button on the bottom left hand side of the - photo 2 Or you can open it from the start button on the bottom left hand side of the screen. o The main area is called the Worksheet You can see it has been divided into - photo 4 o The main area is called the Worksheet . o The main area is called the Worksheet You can see it has been divided into - photo 4 o The main area is called the Worksheet .

You can see it has been divided into a grid with columns and rows . Each box is called a Cell . o The rows go across the worksheet and are labelled as numbers . The columns are vertical and are labelled as letters . o The active cell is the one highlighted and is called A1 , as it is in column A and in row 1. o You can see the name of the active cell in the white box above the o The - photo 5 o You can see the name of the active cell in the white box above the o The workbook contains blank worksheets named Sheet 1 Sheet 2 Sheet 3 etc - photo 6 o The workbook contains blank worksheets named Sheet 1, Sheet 2, Sheet 3 etc.

You can see the name of these on the tabs at the bottom of your worksheet. o Use your left button on your mouse to click in any other cell o Use the - photo 7 o Use your left button on your mouse to click in any other cell. o Use the arrow keys to go up, down, left, or right. o Use the Page Up or Page Down keys notice the row numbers on the left hand - photo 8 o Use the Page Up or Page Down keys (notice the row numbers on the left hand side).

Entering Data
Suppose we are going to make a list of data in Excel with the number of pens your friends have on their desk. Your job is to make a text list of their names and the number of pens each person has.

The cell reference is the name of each cell. o Click in Cell A1 (cell reference) o Type the name John(or your own name) o Press the right arrow key. o Type the number 8 in cell B1 o Press Enter, Excel will move the active cell down to the one under B2. o Copy the Rest of the list. If you make a mistake we will correct them after the rest of the list is done. Editing Data o Click on the cell containing the Name Simon You will see - photo 9

Editing Data
o Click on the cell containing the Name Simon .

You will see that the name appears in the formula bar. The formula bar is above the worksheet and you can see where the text shows Simon. o Click in the formula bar o Use the Backspace key to delete the Name - photo 10 o Click in the formula bar o Use the Backspace key to delete the Name Simon You will see that the text - photo 11 o Use the Backspace key to delete the Name Simon . You will see that the text in cell A3 will change at the same time. o Type Stephen in the formula bar o Another way to change text in a cell - photo 12 o Type Stephen in the formula bar o Another way to change text in a cell is to type over it click in the cell - photo 13 o Another way to change text in a cell is to type over it, click in the cell reference A6. o Delete the name Ali o It will now look like this Inserting and deleting rows and columns - photo 16 o It will now look like this. Inserting and deleting rows and columns We can delete the whole row 2 so that - photo 17

Inserting and deleting rows and columns
We can delete the whole row 2 so that no gap is left. o Left click on the row heading 2. o Right click on the number 2 heading for the row Select Delete from the menu - photo 18 o Right click on the number 2 heading for the row. o Right click on the number 2 heading for the row Select Delete from the menu - photo 18 o Right click on the number 2 heading for the row.

Select Delete from the menu which appears. The row for Stephen moves up to Row 2 Now you are going to add a heading - photo 19 The row for Stephen moves up to Row 2. Now you are going to add a heading at the top of the worksheet We need to - photo 20 Now you are going to add a heading at the top of the worksheet. We need to insert a row. o Right Click in the row header for row 1 o Select Insert from the menu and left click on the mouse o Type Pens on - photo 21 o Select Insert from the menu and left click on the mouse. o Type Pens on Desk in cell A1 Press Enter Insert another blank line - photo 22 o Type Pens on Desk in cell A1.

Press Enter. Insert another blank line below the title o Right click on Row 2 header - photo 23 Insert another blank line below the title. o Right click on Row 2 header. Select insert. Saving your work If you want to keep your work so that you can look at it - photo 24

Saving your work
If you want to keep your work so that you can look at it again or change it in the future, you need to save it. o Click on Save o Excel gives your workbook the default name Book1xls - photo 25
Next page
Light

Font size:

Reset

Interval:

Bookmark:

Make

Similar books «How to Use Microsoft Excel 2010»

Look at similar books to How to Use Microsoft Excel 2010. We have selected literature similar in name and meaning in the hope of providing readers with more options to find new, interesting, not yet read works.


Reviews about «How to Use Microsoft Excel 2010»

Discussion, reviews of the book How to Use Microsoft Excel 2010 and just readers' own opinions. Leave your comments, write what you think about the work, its meaning or the main characters. Specify what exactly you liked and what you didn't like, and why you think so.