DATA

In this post we will know about DATA in Menu Bar of Ms-Excel. Data is a very important part of Ms-Excel. All the persons used DATA Menu in every data. Data is for arrange your DATA. The most important part of DATA is filter. Select the first column of your data and then click Data. There is an option showing click Filter and it will create filter of your data.

https://upstox.com/open-account/?f=DAD0

Open your account and get a free stock with this company. One year moneycontrol pro subscription and other benefits. Just click on the link and complete all the informations.

https://upstox.com/open-account/?f=DAD0

If it ask for referral link then type 860716.

Then it will show the result as per next image. Please see the image.

https://upstox.com/open-account/?f=DAD0
Author

By click on the arrow we can check the marks of the students differently. Like when we click on arrow and select Himanshu it will show all subject's marks of Himanshu. Like that we can show all student's marks.







https://upstox.com/open-account/?f=DAD0
Here is one more important function of Data. That is sort. Sort Ascending and sort Descending. You can check it by yourself.
https://upstox.com/open-account/?f=DAD0
Example of Sort Ascending.

https://upstox.com/open-account/?f=DAD0

Author

 It is showing there names in sort Ascending. Like that the down option of this is sort descending. See the example of sort descending.











Example of Sort Descending.

https://upstox.com/open-account/?f=DAD0

It is showing there names in sort Descending.













You can ask me if you want to ask me anything.

WE WILL SEE THE NEXT OPTIONS IN THE NEXT POST.

THANKS!!

PAGE LAYOUT

PAGE LAYOUT

Hi Friends, there  is Page Layout Option in Menu bar of action. There are no more many functions we need to use here. There are not many more functions of this menu, we use as professionally. Let us see first option there is Theme.

THEME:

                          Select your data and click on Page Layout and then Theme. When will you click on theme, it will show all the designs, you move your cursor of mouse one by one, it will automatically change the design. Just have a look.

https://upstox.com/open-account/?f=DAD0

Here are showing many more designs of themes you can move your cursor and check it by yourself.

https://upstox.com/open-account/?f=DAD0

Here is another option we can see here fonts. We can change text fonts from here also. Here click on arrow of fonts and it will show many more options. Just have a look at the image.

https://upstox.com/open-account/?f=DAD0

FONTS:

Here is another option which is important in this section. We can use margins for set printing. If we want to set the print size area of the page then we will use MARGINS for this sections. Just have to see this image. We have to select custom margins to set the size of printing text and page according to our self. Select on the data and select custom margins. Then select the size which we want.

MARGINS:

After selection of custom margins, We see there are many options to use here. We see next window is open here. Have a look in the next window.

https://upstox.com/open-account/?f=DAD0

Here we can see the main parts of our page, TOP, LEFT, RIGHT and BOTTOM parts of our paper. Length is showing in inches here. We can change it by our self. We can increase or reduce the size by margins. 

https://upstox.com/open-account/?f=DAD0

If you want to anything else from this part page layout you can ask it from me by comment and Please follow me. The other part of excel is FORMULAS, but we will do this part later on. Because this part is very bigger than other parts. Then we will do the other parts in the next part.

https://upstox.com/open-account/?f=DAD0

THANKS!!

INSERT MENU

When we click on insert menu first option is show here TABLE. The data which is showing here is in the form of table. When we want to create a table, click on the first row and first column of border which you created before. Pivot Table is the most important part used in Insert. We will see it at the end of this post. Click on the TABLE and Look at the IMAGE.

Look at the image. Just click on name and then Insert. It will select all the columns and rows of TABLE.

Then you will see all the designs of table. You can click and it will show you the design of table. You can select the designs as per your choice. You will see when you place cursor in TABLE DESIGN, it will change one by one. You can choose the design as per your choice. Design will change itself when you place cursor one by one and when you click on arrow there are many designs in it.

In this image I don't click on any design but just place cursor of mouse and I show the style of design. In the next image, we will see when we place cursor on other design, it will automatically change its design. IN the  next picture we will see that my chosen table design was as it is but when you place your cursor to next design. Lets suppose that you place the cursor to next design of table is.  NOW see the image.

If you want to insert a picture in your data then you can do easily. Click on insert and then picture. It will say you insert picture from your computer, you can select and insert it easily. You can size the image and place it yourself where do u want to place. Just like that image.

You can rotate the image easily have a look at the IMAGE.

You can insert GRAPH, PIE and there are many options of insert data if you want and check statistics analysis. Symbols with colors also given there. You can check by yourself.

Just like 2 column graph you can use many type of graphs and you can use pie, you can check yourself.







And now most importantly used in excel is pivot table. Now we will learn about pivot table.

Here is another image of graph. Please have a look at this image also.

PIVOT TABLE

Click Insert and then pivot table. It will ask new sheet or existing sheet. To with your choice you can choose yourself. But it is good to choose other sheet. Just have a look.

HYPERLINK

We can insert HYPERLINK in INSERT menu of excel. Hyperlink is the very important function of Insert Menu. by hyperlink we can insert any of our file or Folder in our file with a small name. Have a look.

Here we select text to display car and select the file is demo. In the cell file would be demo but when we click it will open demo. You can check by yourself.

The Identification of Hyperlink is that it it underlined by itself. Have a look at the image







Here we create a pivot table and there we placed total in first section, then names and then it will show sum of math, We had only drag the three total, name and math. it will show automatically the result. JUST have a look

 AND WE WILL SEE THE OTHER IMPORTANT OPTIONS OF EXCEL IN THE NEXT POST. YOU CAN ASK ME ANY OTHER THING IF YOU WANT TO ASK OF THIS MENU AND YOU CAN FOLLOW ME TO READ ALL THIS TYPE OF POSTS.

THANKS!!

SOME OTHER FUNCTIONS OF EXCEL

Important Functions:

There are some other important functions which are used in Home Menu Here we will know about that functions. One important function is in when Save, Undo and Redo is in upside, and we can open other functions also. Just have a look on image.

By click an arrow we can enable New Options Like New for make new file, Open for open an existing file and many more and by clicking More Commands there would be show many commands we can enable. Save, Undo and Redo are default enable while we open EXCEL. We use Save for our file where we are doing our work, Undo if we have done wrongly delete some value and we want that value again, Undo is for going back our work. In file if we had delete the word Sham and we want it again except type it then we press Undo and if we want to again delete at that time we press Redo. Redo is just opposite of Undo. We use some shortcut keys of these commands if we don't want to use mouse. Short cut command of Select All is Ctrl+A.

Save:        Ctrl+S

Undo:       Ctrl+Z

Redo:       Ctrl+Y

Select all: Ctrl+A

Now we will see the use of Format Painter, Wrap Text and Merge at Center. For a big data these functions are necessarily used in Excel. Now we will see the functions of Format Painter and Wrap Text.

FORMAT PAINTER:

                                  Here to show you, I have change one cell's font and size and copy paste it to other cells. Format Painter is mostly used in excel. If we want to format it as it is we select for format it will automatically change. Have a look at the image.

In the image both cell's data is same and if we want to change some data select which font and size data do u want to give cell Ashu, that its size and font is different. Let us suppose that you want to change is like Paras. Then click on Paras and then select Format Painter and then click on cell Ashu it will look like Paras. Have a look on image.  

Here in this image we had selected cell Paras and then click on Format Painter. We want to change Font Color, Font Style and Font Size like exactly cell Paras so we select Paras for Format Painter. Select Paras then Format Painter then cell Ashu, it will look like as cell Paras, every thing would be change Just have a look and image.

WRAP TEXT:

                        If we want to write some big text like Total of subjects instead of Total, it will not show in small column. We have to increase our Column's Size. Then it will show properly. See image.

Here we increase the size of the column Total of Subjects for show proper text in Border. Wrap Text is used if we don't want to increase the size of the cell and fit it to the column. Have a look at the image. Wrap Text is used of our facility. If we don't want to increase the size of column then wrap text is used. Like if we want to print something in one page, it will take more than one page then we can use wrap text. 

See an image.

You can use wrap text like this.














Hi "Merge and Center" is big work done by this software. So we will do this command. Like if we want to write in data of all student's marks or All Class  Subject Marks. then it will not possible to write in one cell. Have a look.

In the image we can see that All Class Subject Marks is written in column A but other columns are empty. So for show in all the columns we use the command Merge at Center. Then it will show in all the columns. We will use the command like this. First click the row 1 and then click on insert. It will insert a row above row 1.
Then write what do u want to write. Our data is from column A to Column G. Select from column A to column G in row 1. Then select Merge at Center command. It will adjust and do your written in center. Have a look by image.

 Hi, Here are some more options here you can use some more commands, like Sort and Filter. Other commands are not most important used in professionally. Otherwise if you want to know any command I will tell you. I will tell here sort and filter just look at the images.
Sort: 
        Here you can sort of numbers or name ascending or descending order. Select the cell which do u want to sort in ascending or descending order. See the image.

You can see in the image there are many options in  Sort and Filter. When you click on arrow there are many options.





Here is an option showing filter. You can click on filter and see all the options which are showing by filter the document yourself. Select the cell where do u want to open a filter and select on filter. Filter will apply on all the first cells. Have an image of FILTER for you.

Click on the arrow and it will show like the below image. If we want to show a single person subject's marks, then it will show. It will show result how many NAMES with select. Have a look an image with this.

In the showing above image we have selected only GEETA. It will show all marks subject's result of GEETA and hide other persons result.

It is showing all the result, all subject's marks and TOTAL of GEETA. Filter is a main work done in Excel.



Here are necessarily options used in BASIC HOME MENU which use when we open any excel file. These options are showing and do most important functions for us. These options have many work in professional field. We don't need to use other functions. Other options are miscellaneous. If u need, I will tell you option which you say, PLEASE Tell me in comments. How you like my posts. Please comment me and follow my blog.

I will tell other options in Next Post.

THANKS!!!

BASIC FUNCTIONS OF EXCEL

Let's start some Basic Functions which are there when you open Ms-Excel File. Let's see the file image when you open the MS-Excel file. You can open a file you can press Window Key from your keyboard+R and type there EXCEL. It will open excel new file like this image. Or there is option in open Excel when you press on window key.

Here we will see how functions are working cut,copy, paste, format painter etc. These are all functions of Home Menu. Here we should have some data for use these functions. We will use mouse and some functions and commands we will do with keyboard. These all functions have given are functions of home menu. Files are used in excel in the form of table. Let us take an example of this below file.

We will do all the options one by one. as you see total column is blank. First we fill this column. Just select the rows or columns which do you want to sum. Just click auto sum on the right side of menu bar.

Now if you want to add other student's total, you don't need to auto sum every time, just place your mouse cursor on Paras total and drag it or double click here. It will show the answer.

here you will see the answer.

Now you will see cut, copy and paste option. Select the date what do u want to cut, copy and paste. Select the data which do u want to cut and select the other cell where do u want to paste it and click the paste. As well as you can do copy paste. You can do the commands which are showing in home menu bar. Options are in the left side of menu bar. You can use shortcut commands by keyboard also that is for CUT (Ctrl+X), For Copy (Ctrl+C), and for paste (Ctrl+V). You can also use these commands instead of using mouse.

There is also a main function of paste that is paste special but we will learn it later because there are many options which are used in paste special. We have to copy and then choose paste special. First we have to select data and click copy and then paste special and then option we want to choose. Have a look about Paste Special.

Now Lets know about Font (Style of Typing), Size of Text, Bold, Italic and Underline Text. See in the image and where I mark in the images there are options of font, size, Bold, Italic and underline. where is write calibri is font you can check and do font of what you like to give your text and size also. There is also write B, I and U in image. B means bold your text, I means Italic your text. and U means underline your text. Let us see image.

Here you see I have mentioned in the image which is font, font size, bold, italic and underline. I have given command Harish as bold, Geeta as Italic and Manisha is underline. You will know exactly when you do it same. I am giving you shortkut keys of these Commands.
Bold:         Ctrl+B
Italic:         Ctrl+I
Underline: Ctrl+U
Font and Font Size: Shift+Ctrl+F

There are two options showing with Font size, one is for increase font size and other is for decrease font size. and showing color is one for cell color and second is for font color. Now let us see how to add border of your data. Just select your data and there is a option to fill the border. Have a look in the image.

Here you can see and choose option what do u want to choose. But most probably we choose all borders option. Have a look image.










We Will see other options in next Post.
Thanks.

EXCEL INTRODUCTION

Ms-Office is a software which is used in all of the offices in the world.Ms-Excel is a product of Ms-Office. When we install Ms-Office in our computer Excel will automatically installed. Ms-Excel is a big software used for data base in everywhere. Excel is a professional software use in every office. It is use to create data base like names, Phone numbers etc. It has made with columns and rows inserted in it. People who create data mostly use Ms-Excel instead of other softwares. Because it is easy rather than other softwares used for create data base. There are many rows and columns in it. Columns names starts from A, B, C........ and rows from 1,2,3....... Just have a look image of excel for beginners.

https://upstox.com/open-account/?f=DAD0

There  are more than one lakh rows and more than ten thousand columns are in it which is enough for every organisation to work with it. There are some bars showing in the picture like menu bar, formula bar etc. You will understand easily with the image.

https://upstox.com/open-account/?f=DAD0

https://upstox.com/open-account/?f=DAD0

We will do other options of excel like as menu bar, formula bar and other commands in next posts one by one. I will tell about menu bar in next post. Please comment and follow my blog.