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