How handy it would be if you can navigate through different worksheets within one workbook and even jump from one workbook to other without even touching your mouse. 9 Navigate through different worksheets and workbooks You must select one of the cells within the range to correctly select the relevant data table. This command however does not work if your active cell is out of range. Hold down Ctrl and Shift together and press Space bar to have the selection of the whole table. all the cells (data enclosed in relevant rows and coloumns) within a specific range. But after shortlisting several times over, we have come up with these 10 shortcuts which every accountant must know. It was a difficult selection and we had to go through each and every shortcut. But it does not mean at all that excel does not have the potential to aid accountant’s work.įollowing is the list of hand picked Top 10 Shortcut Keys of Excel to help Accountants in their work. But surprisingly not much attention has been given in this regard and the work for accountants in excel is still old-school. So we don’t have to emphasize much about the relation of accountants and excel. Most common example is that data entry work is carried out in specialized accounting software but report work is done in Excel. Even if accountants have some other accounting software at their disposal they always like to involve excel. Around the world excel is the most active computer application in the hands of accountants. Excel and accountants are two interconnected entities.
0 kommentar(er)
