Free Microsoft Excel Tutorial Complete

Spreadsheets in Microsoft Office Excel 2007;


After Completing this course, students will be able to:

1. Define spreadsheet.

2. Know the purpose of worksheet

3. Recognize spreadsheet software-Excel

4. Explain workbook and worksheet

5. Get familiar with excel application window

6. Identity
            Columns    . Rows      . Cells     . Cell address



7. Manipulate data(numeric and non-numeric) into a cell/range of cells by
           Entering data          Editing data             Auto filling data

8. Enter a formula

9. Insert functions
  . SUM     . PRODUCT    . AVERAGE     . POWER   . SQRT       . MAX         . MIN


10. Create a spreadsheet such as the monthly report of expenses, students result from sheet and salary report etc.
              . Save a spreadsheet     . Select a cell/range of cells to
              . Cut/copy.       paste


11. Format text
        Font,  Font size,    Font style,     Font color,    Alignment

12. Applying borders and shading to a cell/range of cells.

13. Insert new rows/columns.
14. Use chart wizard to insert
 
15. Column chart     . Line chart     . Pie chart

   




Introduction to Microsoft Office Excel 2007:

   A spreadsheet is one of the widely used application package installed in the computers to manage data in rows and columns. In this course, students will learn about the spreadsheet package-Excel.  They will learn to manipulate data (numeric and non-nomeric) in the cells available in a spreadsheet. This unit will explain how to perform different arithmetic operations on data convert it to graphical form.






Introduction to Spreadsheet:


   A spreadsheet is a computer application which is used to display data in multiple cells usually in a two-dimensional matrix or grid consisting of rules and columns each cell contains nomadic or non-numeric data formula or functions. 
  Spreadsheets are frequently used for financial information because of their ability to reacalculate the entire sheet automatically after a change to a single cell is made. Microsoft office Excel 2007  is spreadsheet software.



Spreadsheet:

A spreadsheet is a computer program used to enter, analyze, and calculate data for record keeping. It stores and presents data in rows and columns. Data can easily be entered modified and deleted from it. It performs mathematical calculation and projections based on data entered. The common spreadsheet uses include analysis,  charting, and budgeting.


Purpose of Spreadsheets.

Spreadsheets are used in different fields for a variety of purposes like accounting, charting / graphing, financial analysis and scientific applications, etc.

A spreadsheet is used to:

1. Used and maintain data in tabular form.
2. Manipulate and calculate data by using various functions and formulae.
3. Perform complex mathematical calculations.
4. Recalculate formula automatically wherever a value is changed or modified.
5. Create charts/graphs to represent data.
6. Process and display needed information by sorting and filtering entries according to established criteria.

Spreadsheet Software - Excel:

Excel is one of the popular and commonly used spreadsheet software. Excel can be used from home to professional level to preform calculations on data, creating mailing lists and creating budgets, etc.

     Excel is an electronic spreadsheet program that can be used for storing, organizing and manipulating data. Excel screen is in the form of a rectangular table or grid of rows and columns. The horizontal rows are identified by numbers(1,2,3,...) and the vertical 
columns with alphabet(A,B,C or AA, AB, etc).

Introduction to Workbook and Worksheet:

Workbook:

  A workbook is a file created by Excel Spreadsheet application. Excel workbook consists of spreadsheet 'pages', each of which can include separate data. MS Excel 2007 Workbook is stored with extension'.xlsx.' One workbook may contain many worksheets.


Worksheet:

  Worksheet (also known as a spreadsheet )is a single page in workbook. It is a collection of cells on a single"sheet" where user keep and manipulate the data. Worksheets in a workbook can be accessed by the sheet tabs located at the left corner of Excel window. By default three worksheets are provided in a workbook to enter data. More worksheet can be added as and when required in a workbook.

Comments

Post a Comment

Popular posts from this blog

Excel Application Window

Image
Excel Application Window: User can start Excel program as follows: 1. Click Start 2. Select All Programs 3. Point to Microsoft Office Excel 2007 4. Excel window appears as shown in Figure 3.1 Figure: 3.1 Components of Excel Window:   The excel 2007 window is made up of the several components discussed as follows: Office Button:  The Office Button is at the top left of the Excel window. Clicking this button opens  a menu of commands.   Recent documents can be seen on the right of the Office Button Menu. Figure 3.2 Shows Office Button menu with commands. Figure 3.2    Quick Access Toolbar:  Next to the Microsoft Office Button is the Quick Access Toolbar. The quick Access Toolbar gives access to frequently used commands.   By default, Save, Undo and Redo appear on the Quick Access Toolbar. Quick Access Toolbar Title Bar:   It is located at the top of the Excel window. On the Title bar, M...
Keep reading

Data Manipulation in MS Excel

Image
Data Manipulation   Data manipulation involves entering, editing and formating data. Different formulae and functions can also be applied to manipulate data. User should enter some  data before manipulation. Figure 3.10 Entering Data Both side  Entering Data: To enter data:  . Click a cell to select it. As user selects a cell, the cell address appear in the Name Box. . Enter text into the cell using the keyboard. The text appears in the cell and in the formula     bar as shown in the figure 3.10 . Two buttons also appear in the Formula Bar, the cancel button. . When the user has completed typing data, it can be entered permanently into the active       cell by pressing "ENTER" or by clicking the mark in the Formula Bar or  by pressing the TAB key on the keyboard. . User can enter data anywhere in the worksheet by moving to the required cell, using the mouse or arrow keys, and typing the text. Editing Data: Editi...
Keep reading

How to install XAMPP Server On Window 10 - PHP PDO training 2

Image
PHP and MySQLi video tutorial for beginners with complete projects, examples, help and practical script assingments.  In this brand new we'll be learning how we can learn PHP and MySQL from scratch using PDO and OOP methods. In this video we'll be able to setup and install XAMPP local server on your window 7, 8 and 10 with complete guides and help. This series makes the beginners an advance level web developer using the best examples and easy code and script learning method. We'll be using modern and advance web development best-practices throughout this series to ensure that our course and web development sites are secure, easy-to-maintain and efficiently uses resources. This video series is a presentation for our viewers where they will be able to get notify about our php complete web development projects and course contents. You can find that how you can learn programming using PHP, PDO, MYSQL, HTML, css, Bootstrap, jQuery, dom, phpmyadmin, xampp install...
Keep reading