Learn Excel For Beginners

Search This Blog

like our page and follow us

Posted by Unknown on February 28, 2016

Get link
Facebook
X
Pinterest
Email
Other Apps

Like our page on Facebook:)

Get link
Facebook
X
Pinterest
Email
Other Apps

Comments

Auto fill Excel function’s: (Lesson 20 ) :

As we discussed before in lesson 8 we can auto fill cells with data by click and drag cells . we also can auto fill functions by the same way click and drag we will take a very simple example to illustrate this lesson .the figure below show us sequence in column A from cell A1 to A10 in cell B1 we will write a formula which is =a1 Then we will drag like we did before from the black cross at the right bottom of cell the figure below show the result after we drag the function The formula will be copied to the selected cells but there number of row changing in the dragging process ,when we copy formula to cell b2 the no. Of row changing in the formula to be 2 we used trace formula to illustrate the result

Lesson 8 :Excel Auto fill

Lesson 8 :Auto fill ; It allows you to quickly fill data , we can use it to repeat date in one cell to another cell(s) Or we can to quickly fill data in a series The Figure below illustrate what will happen when you write number ‘1’ in cell ‘a1’ and click and drag The black cross on the bottom right corner of that cell to cell ‘a7’ . We will find the the value ‘1’ repeated in from cell A1 to A7 . For example we can use Auto fill to fill series like months, days of the week, or a numeric series or You can teach Excel to Auto fill other text series Excel knows how to Autofill months (January or Jan) and days of the week (Monday or Mon).If we write “Jan” in cell a1 and click and drag to cell a12 Excel You can teach Excel to Auto fill other text series. First, click on the Office Button and choose “Excel Options” in the lower right corner of the menu. In the “Popular” category (the one that appears automa...

Lesson 11 : Excel conditional Formatting ( Highlight cells rules ) :

Our first lesson will be the first choice in the list which is ‘Highlight cells rules’ this rule will highlight the cell or font under preset rule like 'Greater than' we select column B and click on 'Greater than' window will open with text box , write the number which You want to format cells greater than. Then choose the color from the drop down list on the right You can also customize your format by choosing another font or another color not in the list just choose ‘custom format ‘ from the drop down list as we can see in the figure we format the numbers which are greater than 3000 (B5,B6) less than , between , equal to and text that contains ; all these rules are the same as Greater than' you have text box for the rule number and drop down list to choose color A Date Occurring : the same way but this is regarding cells that contains dates occurring As we can see in figure ...

Powered by Blogger

Copy rights reserved to the owner of the blog

like our page and follow us

Comments

Post a Comment