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.
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-
There
is also an option of “Save”. To Save your document, click on the “Save” option:-
·
Click on Office Button,
there are many options as below-
·
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 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!!!
Comments
Post a Comment