View Contents • • • • • • • • • • • • • • • • • • • Excel and accountants are two interconnected entities. Around the world excel is the most active computer application in the hands of accountants. Even if accountants have some other accounting software at their disposal they always like to involve excel. Most common example is that data entry work is carried out in specialized accounting software but report work is done in Excel. So we don’t have to emphasize much about the relation of accountants and excel. But surprisingly not much attention has been given in this regard and the work for accountants in excel is still old-school.

Free download shortcut keys busy software Files at Software Informer. BUSY is business accounting software for Micro, Small, and Medium businesses. It can be used for financial accounting, inventory management, BOM preparation, management of sales/purchase, CST/VAT reporting, tax calculation, etc.

But it does not mean at all that excel does not have the potential to aid accountant’s work. Following is the list of hand picked Top 10 Shortcut Keys of Excel to help Accountants in their work. It was a difficult selection and we had to go through each and every shortcut.

Download The Final Four in pdf. Introduction to Solid State Physics - Free ebook download as PDF File. FileCatch - solid-state physics. MA In recent years the indoor. Solid state physics by ma wahab pdf to jpg.

But after shortlisting several times over, we have come up with these 10 shortcuts which every accountant must know. 10 Select entire table Select the whole table at once i.e. All the cells (data enclosed in relevant rows and coloumns) within a specific range.

+ + How to use it: Hold down Ctrl and Shift together and press Space bar to have the selection of the whole table. Additional notes: This command however does not work if your active cell is out of range. You must select one of the cells within the range to correctly select the relevant data table. 9 Navigate through different worksheets and workbooks 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. You have to do it to be believe it, it saves much time and make work practically efficient. To switch to next worksheets + To switch to previous worksheets + To navigate through different workbooks + Additional notes: These navigation shortcuts can work only if you have multiple worksheets and workbooks active or opened.

Quick note: Workbook is actually one excel file and acts as one book which may contain many pages i.e. So one workbook can have multiple worksheets in it. 8 Copy formula from above cell and edit Think about a situation where you have to copy a formula from a cell and then paste it in the cell just below it and have to edit it. This might seem easier just to say.