Get Even More Visitors To Your Blog, Upgrade To A Business Listing >>

Few Advance Features of Excel

-Keyboard shortcuts –Most users of windows are familiar with using the keyboard as an alternative to selecting commands or tools with the mouse. Same features are also available in Excel-for example

Ctrl + N for New, Ctrl + O for Open, Ctrl + S for Save, Ctrl + P Print, Ctrl + X for Cut etc . These familiar shortcuts are only a small sample of the shortcuts available in Excel. Here is a further example-

Format Cells :-       Ctrl + 1

Display Help :-   F1

Insert New worksheet :-             Shift + F11

Move cursor to cell A1 :-           Ctrl + Home

Display the Find and Replace dialog box  :-                 Shift + F5

Whenever we regularly encounter a tedious and slow operation, it makes sense to search for a keyboard shortcut to save time.

Most practicing analysts have experienced the frustration of trying to understand a complex formula or a model design six months after they built it, or two years after someone built it. But while agrees that spreadsheets should be documented, almost no one does it. The reason seems to be that most of forms of documentation are too time consuming. Cell comments are one easy way to document the details behind a cell or range of cells. After writing a comment, it can be deleted, change and edit easily.

Mangalmay is The Top BBA college in Greater Noida For More Information :

Mangalmay Group of Institutions
Greater Noida, Delhi NCR
Call us : 1800 200 9260
Visit : http://www.mangalmay.org/

The post Few Advance Features of Excel appeared first on Mangalmay Group of Institutions | Leading education institutes in India.



This post first appeared on Mangalmay Institutions, please read the originial post: here

Share the post

Few Advance Features of Excel

×

Subscribe to Mangalmay Institutions

Get updates delivered right to your inbox!

Thank you for your subscription

×