Work with Number section in Excel

If you wish to set the format to your cell such as currency , percentage , date , function etc for this you must learn NUMBER section in format cell.

General : You can write anything inform of numbers or alphabetical characters in General there is no specific format apply.
Number : change your cell value in decimals in ending , you can also set thousand separator coma, and Negative numbers.
Currency : Allows you to show Currency Symbol if any you may also add more symbols from windows time and Regional settings.
Accounts : Line up the currency symbols and decimal points in a column.
Date : Different kinds of date Format you can set as your own wish and this will automatically appeared in the current year while you just wrote date , and month even it was a long format no worried you can easily set this in your sheet.
Time : Set format like 12 hours or 24 hours , am , pm hours , min , seconds etc.
Percentage : its Multiply the cell value by 100 and showing a symbol of % .
Text : Helps to remove any kind of number formatting just showing a simple text as you write and as you wish.

All About Alignment in Excel

Shuffling values with in cell boundaries called Alignment , several kind of alignment in new version of ms office 2013 some are named as Right Align , Left Align , Center , Top , Bottom etc we have learn every thing about alignment,

Also we have learn how to increase , decrease indent of content , text orientation , Wrap Text & Merge & Center ,  try to cover additional alignment in which you will learn in detail .

All Types of Alignment : 

Short-Key Top Align alt+h+a+t
Top Align : Shifted Cell Value to the top of cell border , either it was already in center or right align but when you click on top align value shifted at the top in the same direction.
Short-Key middle Align alt+h+a+m
Middle align : shifted text to the centered , in the middle of top and bottom of the cell.
Short-Key bottom Align alt+h+a+b

Bottom Align : Cell value at the bottom bottom.
 Short-Key right Align alt+h+a+r

Right Align :  shifted value to right corner.
Short-Key center Align alt+h+a+c
Center : Centered the text.
Short-Key left Align alt+h+a+l
Align Left : Align content to the left.

Wrap Text.

Short-Key wrap text ctrl+shift+w
Force the cell content to remain in the same cell is know as  WRAP TEXT.

Work with Merging.

Merge & Center:
Short-Key merge & center : alt + h+m+c.
To combining and Centered Cells content in new large cell known as Merge & Center. 

Merge Across

Short-Key merge & Across : alt + h+m+a.
Selection of Cells into one row in a large cell shape.

Merge Cells
Short-Key merge Cells: alt + h+m+m.
Selection of cells merge into one large cell. 

unMerge Cells.

Short-Key of Unmerge Cells : alt + h+m+u.

Split selected merged cell into multiple cells or say this remove the merge activity of any area.

Examples are : 
alignment in Excel

Complete Font section in Excel 2013

Styling of document involves , font type , font size , font color , etc now we discuss how you can play with fonts in excel 2013, choosing the right font give looks great to your document , we can start learning about font there is also allots of free font available we will include this later on .

Pick , Re-sizing , and choosing color for Font.

Font dd Short key : Alt, h, f, f than hit down arrow

Font size Short key : Alt, H, F, S than hit down arrow
     Quick decrease Font :  Alt, h, f, k  ( little decrease )
Quick Increase Font : Alt, h, f, g( little increase  )

Dropdown font choosing menu tells you what font you need to implement quick preview for selection is also started when you dropping down the font ,pickup choose any beautiful font you wish but first you have to select the area for implementing.

You can change the size of font by two different ways in excel , quick increase or decrease or select the number to enlarge the same picture gives you clear idea also you can download more fonts and use them to in excel you can also put font in in Urdu & Hindi keep in mind that this works only on the selection of cells with data.

Change color Short key : Alt, h, f, c

gives color scheme to your font easily , just select to which cell font you wish to color than click on dropdown and pick up from the verity of colors , you can also click on more color to create you own combination and standard color also available.

Fill Cell Color

there is some different in font color and cell color basically fill color refers to complete fill up the cell or range of cell by selected color and does not impact on font color , if any.  

Cells Borders.
Short-keys at the bottom of post.

borders gives outline to selected cell or group of cell , its help to show clearly cell values also gives some additional look to the cell value. there are many types of border you can check one by one if required otherwise this is very easy to implement border to your cell value , also there is lots of border shapes so shortkeys list for border is also too big , but you can check and pick up your favorite border and keep practicing so one day these short key on your finger tips : ).

Check out the list of borders short keys complete.
Border – Left
Border – Top
Draw Border
Alt, H, B, W
Top and Bottom Border
Alt, H, B, U
Thick Box Border
Alt, H, B, T
Applies the outline border to the selected cells.
Alt, H, B, S
Right Border
Alt, H, B, R
Top Border
Alt, H, B, P
Bottom Border
Alt, H, B, O
Removes the outline border from the selected cells.
Alt, H, B, N
More Borders
Alt, H, B, M
Left Border
Alt, H, B, L
More Border Colors
Alt, H, B, I, M
Thick Bottom Border
Alt, H, B, H
Draw Border Grid
Alt, H, B, G
Erase Border
Alt, H, B, E
Top and Bottom Border
Alt, H, B, D
Top and Thick Bottom Border.
Alt, H, B, C
Bottom Double Border
Alt, H, B, B
All Borders
Alt, H, B, A
Increases the margin between the border and the text in the cell.
Alt, H, 6
Decreases the margin between the border and the text in the cell.
Alt, H, 5
Removes the outline border from the selected cells.
Applies the outline border to the selected cells.
Paste (No borders)
Alt, H, V, B

How to Copy and Paste in Excel 2013

Today we will talk about Cut , Copy and Paste within excel workbook , for this you have to take some very simple steps, also gives you an Idea to do this by using short-key by using keyboard on the right top corner on excel there is a section name CLIPBOARD , inside clipboard you will saw CUT , COPY , FORMAT PAINTER and PASTE you will learn each individually.

Cut and Paste in Excel.

Short-key : Ctrl + X than Ctrl + V 

Moving the cell or cells object from one place to another know as CUT after this you can PASTE this object where ever you wish , but remember the original location of this object will be empty.

Note : Remember always use PASTE as a value if you saw a drop down in paste icon because we just learning here only copy , cut and paste command.

Copy and Paste in Excel.
Short-key : Ctrl + C than Ctrl + V 
Make duplicate a piece of data from a cell or combination of cell to other location but this time the original data remain on the same place  , pasting remain the same by using Ctrl + V , Excel 2013 there is a feature includes paste as a picture you can paste the copied data in the shape of picture try both thing at excel sheet you will understand easily. 

Format Painter
Short-key : Ctrl + C than Alt+E, S, T, hit Enter
This will only copying the formatting of selected cells and paste to other location ,its very simple through this you will save so much of your time to waste to create formatting again and again , including borders of cells colors of fonts size and many other things include the source formatting , it does not effect to the value of cell or any formula if present already.

Clipboard its self a temporary storage of your copied or cut items which will available to paste other location easily .

See the below picture for use of clipboard.

First Look of Excel 2013 When Click to Open

First Look of Excel gives you an idea actually what also you can do with Microsoft Excel 2013. you can browse free or paid templates  which designed by Microsoft developers Experts in different categories also you have a Hotmail sign option for your free Hotmail account and explore more feature of Microsoft Excel.

Picture showing the numbers , respected detail mention below.

1. Recent and Open Other Workbooks
In recent in Excel you will find most recent files which you closed or opened previously , or this is a short-lived cache storage of Excel files through this you can quickly reopen your most recent files.

Through open other workbook you can browse files from your computer and Microsoft one drive after this will appeared again in recent.

2. Search for online Templates & Suggested Searches.

Template is a style , formats which might be created by some one or Microsoft and upload free or paid , by using of templates you can save your time , you can search online templates according to your need or you can browse category wise both features are available here allots of templates are available when you scrolling down the page you will find more and more.

3.Blank Workbook

Easily open or create a new workbook by clicking on it, there is a difference between open other workbook and blank workbook , blank is always open a fresh workbook even from open workbook you will open previously save workbook on your hard disk.

4.Sign in to Office.

this actually a simple login to your Hotmail or Microsoft account through this sign in process , after this you can save directly your files to One Drive by Hotmail.

Introduction and benefits of Microsoft Excel

Before we start learning process , I suggest to carefully read this complete post with good understanding , after this you will feel that you can catch every step in learning process very easily, these basic things will be very useful till you are involved in learning process. Just keep remember the things.

What is Microsoft Excel and what are the basic features.

Microsoft Excel is part of Microsoft Office Suits , this was early released in several version , latest MS Excel known as Office 16. features includes Power Query integration , New Chart Types, Excel forecasting functions, Excel data cards and many more.

Quick Review of Excel benefits and outputs.

  • Users able to organize , format and calculate data in minimum time.
  • Can create graphical representation.
  • analyzed data very quickly and easily.
  • summarized records simply.
  • reconciled data with other sheets.

How Microsoft Excel helps in Profession.

Microsoft Excel is almost the need of every industry around the globe tracking records , analyzing data ,  helps allot to concise your spreadsheet work , Generating Reports from gigantic data , filtering the part of mega records , also you will become a free lancer after get expertise in MS Excel.

Understanding each and every thing.

I try my level best to gives you maximum descriptive information with the help of video tutorial and via images. also , I design my blog like an Excel Work Book that gives you resemblance of Excel Workbook.

What we learn at this platform.

Key Information about Excel Workbook , work with excel formulas , how to get rid day to day excel Queries , header Ribbon Customization as desired , provides detail video tutorials for Excel in Urdu , Hindi  & English , response to your queries and happy to solve them this will be useful for me as well this increase my knowledge also.  

Sharing is Caring.

don't hesitate to share this with someone else maybe they need this and if your relatives , friends children requires in academic point of view , professional aspects , your friends might think to learn ms office but unable to afford , the information on this blog is absolutely free not any single penny will charge.