Microsoft Excel Needy functions used in Excel work

Microsoft Excel Needy functions used in Excel work:

Friends, I am using Microsoft Excel 2007 to understand you. But, the same all these will be applicable in all Excel versions.

How to insert data in Cell:  When you open the M.S Excel, then a symbol (like +) will be displayed on the screen, which is used to select the active cell in which you will enter the data. 

By default, the cell A1 is selected when we open the Excel workbook. But, we can change the active cell position using Left/Right/Up/Down Keys.

How to save your data in Excel document: When you enter your data in the M.S Excel and want to save it for the future purpose. There are 2 ways to save your data-

·        Click on Office Button, there are many options as below-

There is also an option of “Save”. To Save your document, click on the “Save” option:-

·        There is also a shortcut “ Ctrl+S” to save the document by using Keyboard. 

Note:- By default, the new Excel file will be saved with the name of “New Microsoft Office Excel Worksheet”. You can either rename the Excel file or save it with another name by using “Save As” option.

How to open new Excel document: If you want to open a new Excel, you can do it either using Office Button or using Shortcut Key “Ctrl+N”.  

How to open the Saved Excel document: If you want to open the saved excel document, you can do it either using Office Button or using Shortcut key “Ctrl+O”.    

Note: If you recently opened the searching saved Excel document, then it will be visible in “Recent Documents Pane” when you will click on Office Button.

The use of “Save As” option in Excel: By default, the new Excel file will be saved with the name of “New Microsoft Office Excel Worksheet”. You can either rename the Excel file or save it with another name by using the “Save As” option.

If you want to use the “Save As” option, you can do it either using Office Button or using Shortcut Key “F12”. 

By doing this, “Save As” dialog box will be opened as below-

In the “File Name”, you can type the Excel document new name what you want.

In the “Save As Type”, there are multiple formats in which you can save the document like- .csv, .xml, .txt, .xlsm etc. 

How to print the Excel document: If you want to open the saved excel document, you can do it either using Office Button or using Shortcut key “Ctrl+P”.  

There will be below 3 options (Print, Quick Print & Print Preview). The function of main options (Print & Print Preview) are explained as below:-

Print: This option is used to select Printer, Printable Page range, No. of copies, Selection area, etc.

Print Preview: This option is used to preview the page, Page setup, and set up the page margins.

In the next post, we will learn about the functionality of Excel Ribbons like- Home, Insert, Page Layout, Formulas, etc. in details.

Hope you will enjoy & learn Excel and be a Rockstar in your professional life.

Cheers & stay connected with me!

Thank you & see you around!!!