Excel Easy Learning.

This topic contains 4 replies, has 2 voices, and was last updated by  Despairing Khan 3 months, 1 week ago.

  • Author
    Posts
  • #6815
     Despairing Khan 
    Moderator

    Welcome to Excel Easy

    We offer a tutorial on how to use Excel. Below you can find an overview of all chapters. Want to learn much more about Excel? You can find related examples and features (300 Examples) on the right side of each chapter. We keep it easy!
    Bradley – Jupiter, United States – “Thank you for this website, it taught me so much about using Excel in a quick self-paced course.” [Read More]
    Introduction

    This section is for users with no knowledge of Excel.

    Microsoft Excel is one of the most used software applications of all time. Hundreds of millions of people around the world use Microsoft Excel. You can use Excel to enter all sorts of data and perform financial, mathematical or statistical calculations.

    1 Range: A range in Excel is a collection of two or more cells. This chapter gives an overview of some very important range operations.

    2 Formulas and Functions: A formula is an expression which calculates the value of a cell. Functions are predefined formulas and are already available in Excel.
    Basics

    This section explains the basics of Excel.

    1 Ribbon: The tabs on the ribbon are: File, Home, Insert, Page layout, Formulas, Data, Review and View. Excel selects the ribbon’s Home tab when you open a workbook.

    2 Workbook: A workbook is another word for your Excel file. When you start Excel, click Blank workbook to create an Excel workbook from scratch.

    3 Worksheets: A worksheet is a collection of cells where you keep and manipulate the data. Each Excel workbook can contain multiple worksheets.

    4 Format Cells: When we format cells in Excel, we change the appearance of a number without changing the number itself.

    5 Find & Select: Learn how to use Excel’s Find, Replace and Go To Special feature.

    6 Templates: Instead of creating an Excel workbook from scratch, you can create a workbook based on a template. There are many free templates available, waiting to be used.

    7 Data Validation: Use data validation in Excel to make sure that users enter certain values into a cell.

    8 Keyboard Shortcuts: Keyboard shortcuts allow you to do things with your keyboard instead of your mouse to increase your speed.

    9 Print: This chapter teaches you how to print a worksheet and how to change some important print settings in Excel.

    10 Share: Learn how to share Excel data with Word documents and other files.

    11 Protect: Encrypt an Excel file with a password so that it requires a password to open it.

    1 user thanked author for this post.
  • #6816
     🥀 Pomi 🌼 
    Participant

    Great effort

  • #6852
     🥀 Pomi 🌼 
    Participant

    To dear es tutorial main kia ap nay koi file attach ki hai .. I mean to say k yeh jo Excel ka learn krna hai wo kahan sy krna hai koi source ap nay provide krna tha kia , q k I am sorry to say mujy to koi attached file nazar nae aa rehi hai

  • #6868
     Despairing Khan 
    Moderator

    Range

    Range

    Cell, Row, Column | Range Examples | Fill a Range | Move a Range | Copy/Paste a Range | Insert Row, Column

    A range in Excel is a collection of two or more cells. This chapter gives an overview of some very important range operations.

    Cell, Row, Column
    Let’s start by selecting a cell, row and column.

    1. To select cell C3, click on the box at the intersection of column C and row 3.

    2. To select column C, click on the column C header.

    3. To select row 3, click on the row 3 header.

    Range Examples
    A range is a collection of two or more cells.

    1. To select the range B2:C4, click on cell B2 and drag it to cell C4.

    2. To select a range of individual cells, hold down CTRL and click on each cell that you want to include in the range.

    Fill a Range
    To fill a range, execute the following steps.

    1a. Enter the value 2 into cell B2.

    1b. Select cell B2, click on the lower right corner of cell B2 and drag it down to cell B8.

    Result:

    This dragging technique is very important and you will use it very often in Excel. Here’s another example.

    2a. Enter the value 2 into cell B2 and the value 4 into cell B3.

    2b. Select cell B2 and cell B3, click on the lower right corner of this range and drag it down.

    Excel automatically fills the range based on the pattern of the first two values. That’s pretty cool huh!? Here’s another example.

    3a. Enter the date 6/13/2016 into cell B2 and the date 6/16/2016 into cell B3.

    3b. Select cell B2 and cell B3, click on the lower right corner of this range and drag it down.

    Note: visit our page about AutoFill for many more examples.

    Move a Range
    To move a range, execute the following steps.

    1. Select a range and click on the border of the range.

    2. Drag the range to its new location.

    Copy/Paste a Range
    To copy and paste a range, execute the following steps.

    1. Select the range, right click, and then click Copy (or press CTRL + c).

    2. Select the cell where you want the first cell of the range to appear, right click, and then click Paste under ‘Paste Options:’ (or press CTRL + v).

    Insert Row, Column
    To insert a row between the values 20 and 40 below, execute the following steps.

    1. Select row 3.

    2. Right click, and then click Insert.

    Result:

    The rows below the new row are shifted down. In a similar way, you can insert a column.

     

You must be logged in to reply to this topic.

©[2019] All rights reserved to Buraqq.com

Log in with your credentials

or    

Forgot your details?

Create Account