Skip to main content

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. 
Excel Insertion Symbol

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-
Microsoft Excel 2007 Button Options


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

Microsoft Excel 2007 Save Option.jpg


·        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”.  

Microsoft Excel 2007 New Option


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.
Microsoft Excel 2007 Save Option

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”

Microsoft Excel 2007 Save As Option

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

Microsoft Excel 2007 Save As Dialog Box_01



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. 

Microsoft Excel 2007 Save As Dialog Box_02


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”.  

Microsoft Excel 2007 Print Option
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.
Microsoft Excel 2007 Print Option_02

Print Preview: This option is used to preview the page, Page setup, and set up the page margins.
Microsoft Excel 2007 Print Preview Option
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!!!






Comments

Popular posts from this blog

What is Microsoft Excel & its uses?

Microsoft Excel is an electronic  spreadsheet program that is used for storing, organizing, computing and manipulating data. Microsoft Excel provides worksheets that are comprised of rows and columns. Like A Microsoft Word Table, you can store the data in a spreadsheet, but we can do a lot of functions and computations with the stored by using Excel functions and formulas. This is the utility of Excel that separates it from the Microsoft Word Table. Microsoft Excel is used to perform the calculation, analysis, and visualization of data and information.  In  Excel, Users can do various kinds of mathematical, financial, logical calculation, data manipulation, data analysis, and visualization of information in less time and efficient ways. It's used to create a network of text, numbers, and formulas performing calculations. That's extremely valuable for many businesses, which use it to record expenditures and income, plan budgets, chart data and summari...

How to Start Microsoft Excel?

How to Start Microsoft Excel? Follow the below steps to start the Excel application in your PC/Laptop:- 1.       Click on Start Menu 2.       Click on “All Programs” option from Menu. 3.       Select the Microsoft Office Option from the Sub Menu and click it. 4.       Search for Microsoft Excel (which edition installed) from Sub Menu and click it. Now, the Microsoft Excel the application will be launched and the Excel window will be displayed on your PC/Laptop Screen. There are some alternate ways to open Excel, which are as follows- Alternate Method 1:- 1.       Click on Start Menu 2.       Open Search Bar & search for “Excel”. All programs related to your typed search item will be displayed. 3.       Click on Microsoft Excel (which edition installed). Alternate Method 2...