Basic Excel Skills For Beginners

This topic has been explained in great detail in the video shown below, to learn this topic just play the video and the notes are mentioned below the video.


Basic Excel Skills For Beginners






Basic Excel Skills For Beginners

Excel is an incredibly powerful tool for getting meaning out of vast amounts of data. But it also works really well for simple calculations and tracking almost any kind of information. The key for unlocking all that potential is the grid of cells. Cells can contain numbers, text or formulas. You put data in your cells and group them in rows and columns. That allows you to add up your data, sort and filter it, put it in tables, and build great-looking charts. Let’s go through the basic steps to get you started.

  1. What is A cell In Excel
  2. What Is a Column In Excel
  3. What Is a Row In Excel
  4. What is a range In Excel
  5. How to Insert value In Excel
  6. How to delete In Excel
  7. How to copy In Excel
  8. How to paste In Excel
  9. How to cut In Excel
  10. How to edit data In Excel
  11. How to insert comment In Excel
  12. How to edit comment In Excel

This Excel tutorial has been created to help you learn microsoft excel online. On http://www.myelesson.org you get excel help and online file download facility. This video lesson covers the entire topic in simple and easy to understand step by step approach. 

 

Basic tasks in Excel

Excel is an incredibly powerful tool for getting meaning out of vast amounts of data. But it also works really well for simple calculations and tracking almost any kind of information. The key for unlocking all that potential is the grid of cells. Cells can contain numbers, text, or formulas. You put data in your cells and group them in rows and columns. That allows you to add up your data, sort and filter it, put it in tables, and build great-looking charts. Let’s go through the basic steps to get you started.

 
Create a new workbook

Excel documents are called workbooks. Each workbook has sheets, typically called spreadsheets. You can add as many sheets as you want to a workbook, or you can create new workbooks to keep your data separate.

  1. Click File, and then click New.

  2. Under New, click the Blank workbook.

    New blank workbook

 
Enter your data
  1. Click an empty cell.

    For example, cell A1 on a new sheet. Cells are referenced by their location in the row and column on the sheet, so cell A1 is in the first row of column A.

  2. Type text or a number in the cell.

  3. Press Enter or Tab to move to the next cell.

 
Apply cell borders
  1. Select the cell or range of cells that you want to add a border to.

  2. On the Home tab, in the Font group, click the arrow next to Borders, and then click the border style that you want.

    Excel  Ribbon Image

For more information, see Apply or remove cell borders on a worksheet .

 
Apply cell shading
  1. Select the cell or range of cells that you want to apply cell shading to.

  2. On the Home tab, in the Font group, choose the arrow next to Fill Color Button image , and then under Theme Colors or Standard Colors, select the color that you want.

For more information about how to apply formatting to a worksheet, see Format a worksheet.

 
Use AutoSum to add your data

When you’ve entered numbers in your sheet, you might want to add them up. A fast way to do that is by using AutoSum.

  1. Select the cell to the right or below the numbers you want to add.

  2. Click the Home tab, and then click AutoSum in the Editing group.

    AutoSum on the Home tab

    AutoSum adds up the numbers and shows the result in the cell you selected.

For more information, see Use AutoSum to sum numbers

 
Create a simple formula

Adding numbers is just one of the things you can do, but Excel can do other math as well. Try some simple formulas to add, subtract, multiply, or divide your numbers.

  1. Pick a cell, and then type an equal sign (=).

    That tells Excel that this cell will contain a formula.

  2. Type a combination of numbers and calculation operators, like the plus sign (+) for addition, the minus sign (-) for subtraction, the asterisk (*) for multiplication, or the forward slash (/) for division.

    For example, enter =2+4=4-2=2*4, or =4/2.

  3. Press Enter.

    This runs the calculation.

    You can also press Ctrl+Enter if you want the cursor to stay on the active cell.

 
Apply a number format

To distinguish between different types of numbers, add a format, like currency, percentages, or dates.

  1. Select the cells that have numbers you want to format.

  2. Click the Home tab, and then click the arrow in the General box.

    Format Number box on the Home tab

  3. Pick a number format.

    Number format gallery

    If you don’t see the number format you’re looking for, click More Number Formats

 
Put your data in a table

A simple way to access Excel’s power is to put your data in a table. That lets you quickly filter or sort your data.

  1. Select your data by clicking the first cell and dragging to the last cell in your data.

    To use the keyboard, hold down Shift while you press the arrow keys to select your data.

  2. Click the Quick Analysis button Quick Analysis button in the bottom-right corner of the selection.

    Selected data with Quick Analysis Lens button visible

  3. Click Tables, move your cursor to the Table button to preview your data, and then click the Table button.

    Quick Analysis Tables gallery

  4. Click the arrow Filter drop-down arrow in the table header of a column.

  5. To filter the data, clear the Select All check box, and then select the data you want to show in your table.

    Select All box in the Sort and Filter gallery

  6. To sort the data, click Sort A to Z or Sort Z to A.

    Sorting commands in the Sort and Filter gallery

  7. Click OK.

 
Show totals for your numbers using Quick Analysis

The Quick Analysis tool (available in Excel 2016 and Excel 2013 only) let you total your numbers quickly. Whether it’s a sum, average, or count you want, Excel shows the calculation results right below or next to your numbers.

  1. Select the cells that contain numbers you want to add or count.

  2. Click the Quick Analysis button Quick Analysis button in the bottom-right corner of the selection.

  3. Click Totals, move your cursor across the buttons to see the calculation results for your data, and then click the button to apply the totals.

    Quick Analysis Totals gallery

 
Add meaning to your data using Quick Analysis

Conditional formatting or sparklines can highlight your most important data or show data trends. Use the Quick Analysis tool (available in Excel 2016 and Excel 2013 only) for a Live Preview to try it out.

  1. Select the data you want to examine more closely.

  2. Click the Quick Analysis button button image in the bottom-right corner of the selection.

  3. Explore the options on the Formatting and Sparklines tabs to see how they affect your data.

    Quick Analysis Formatting gallery

    For example, pick a color scale in the Formatting gallery to differentiate high, medium, and low temperatures.

    Data with a color scale conditional format

  4. When you like what you see, click that option.

 
Show your data in a chart using Quick Analysis

The Quick Analysis tool (available in Excel 2016 and Excel 2013 only) recommends the right chart for your data and gives you a visual presentation in just a few clicks.

  1. Select the cells that contain the data you want to show in a chart.

  2. Click the Quick Analysis button button image in the bottom-right corner of the selection.

  3. Click the Charts tab, move across the recommended charts to see which one looks best for your data, and then click the one that you want.

    Quick Analysis Charts gallery

    Note:  Excel shows different charts in this gallery, depending on what’s recommended for your data.

 
Sort your data

To quickly sort your data

  1. Select a range of data, such as A1:L5 (multiple rows and columns) or C1:C80 (a single column). The range can include titles that you created to identify columns or rows.

  2. Select a single cell in the column on which you want to sort.

  3. Click A to Z command in Excel that sorts A to Z or smallest number to largest to perform an ascending sort (A to Z or smallest number to largest).

  4. Click Z to A command in Excel that sorts Z to A or largest number to smallest to perform a descending sort (Z to A or largest number to smallest).

To sort by specific criteria

  1. Select a single cell anywhere in the range that you want to sort.

  2. On the Data tab, in the Sort & Filter group, choose Sort.

  3. The Sort dialog box appears.

  4. In the Sort by list, select the first column on which you want to sort.

  5. In the Sort On list, select either ValuesCell ColorFont Color, or Cell Icon.

  6. In the Order list, select the order that you want to apply to the sort operation — alphabetically or numerically ascending or descending (that is, A to Z or Z to A for text or lower to higher or higher to lower for numbers).

    For more information about how to sort data, see Sort data in a range or table .

 
Filter your data
  1. Select the data that you want to filter.

  2. On the Data tab, in the Sort & Filter group, click Filter.

    The Sort and Filter group on the Data tab

  3. Click the arrow Filter drop-down arrow in the column header to display a list in which you can make filter choices.

  4. To select by values, in the list, clear the (Select All) check box. This removes the check marks from all the check boxes. Then, select only the values you want to see, and click OK to see the results.

 
Save your work
  1. Click the Save button on the Quick Access Toolbar, or press Ctrl+S.

    Save button on the Quick Access Toolbar

    If you’ve saved your work before, you’re done.

  2. If this is the first time you’ve save this file:

    1. Under Save As, pick where to save your workbook, and then browse to a folder.

    2. In the File name box, enter a name for your workbook.

    3. Click Save.

 
Print your work
  1. Click File, and then click Print, or press Ctrl+P.

  2. Preview the pages by clicking the Next Page and Previous Page arrows.

    Next and Previous buttons in the Print Preview pane

    The preview window displays the pages in black and white or in color, depending on your printer settings.

    If you don’t like how your pages will be printed, you can change page margins.

  3. Click Print.








Our Other Services




Read Free Ebooks

myeboook.com

Myebook has 1000's of free ebooks for you. On productivity, health, online income, learning, music and many more, it's free of course!



Buy Excel Course

myelesson.org/product

Become an Excel Guru, Buy the best Excel course. Learn on your mobile, tv & laptop without internet. For COD, Call 9752003788



Create Best Looking Resume

http://www.makecv.org/

At Makecv.org you get to create a amazingly professional looking resume in just 3 steps with our intuitive resume builder!


Download Excel Crash Course


This Excel Crash Course contains the list of topics that cover the most important and used features and formula of Excel . This Excel Crash Course lists 43 major topics in Excel so that you can start using Excel like a pro in the shortest possible time.



Learn Photoshop Web Designing


You can Buy the Photoshop Course to learn Photoshop and start a career in Web Designing and Photo Editing. .



Learn HTML CSS


You can Buy the HTML CSS Course to learn HTML CSS and start a career in Web Designing and Photo Editing. .


Download Full list of Excel Shortcuts


This Excel Shortcuts Complete list is to help you become save time and use Excel like a Master level user. Excel is best used when you know the Keyboard shortcuts because the use of keyboard shortcuts in Excel helps you in completing tasks faster.

I have created a Excel Shortcuts complete list for you to use Excel better, this list has 242 excel keyboard shortcuts which means that it covers almost everything that can be done using shortcuts in Excel.




Full List of Excel Formulas

This is a complete alphabetical list of all the Formula in Excel with a description. You can learn all these formulas on www.Myelesson.org




Convert Numbers to Text in Excel

Now easily convert numbers to Text in Excel with this inbuilt sheet from myelesson.org .  Many times we need the amount in figures to be converted into words. This is a typical requirement for writing checks or any other financial reports. Microsoft Excel does not have standard function available for this requirement. Just download this sheet and then you can convert any number to text in Excel.




List of Most Commonly Asked Excel Questions in Interviews

Here is the list of most asked excel related questions in interviews.  Prepare for this excel questions and you would be able to most of the excel interviews. This list of excel questions covers excel formula, excel analysis, excel reporting, excel charts and more.





Myelesson © 2010 - 2014. All rights reserved.

Do You Want to Become a Expert in Excel ?
Buy The Full Excel Course Now
Enter Your Details & We Will Contact You
Great Choice
Thank You
Ok
Do You Want to Become a Expert in Excel ?
Buy The Full Excel Course Now
Enter Your Details & We Will Contact You
Great Choice
Thank You
Ok