If you’re new to doing your accounting in Microsoft Excel, it can seem a bit daunting at first. After all, there are so many functions you can use to get the job done.
The good news is, once you master all those functions, you’ll be an accounting pro. You’ll be able to do your accounting faster and make it more accurate.
To help get you there, we’re revealing three Excel tips and tricks to get you closer to mastering your company’s accounting. All you have to do is read on and discover what they are…
Here are the three Excel tips and tricks to help turn you into an accounting pro
Tip 1: Here’s how to work in selected cells without cancelling your selection:
• To scroll down in the same column, press Enter;
• To scroll up in the same column, press Shift + Enter;
• To scroll horizontally in the same row (left to right), press Tab;
• To scroll horizontally in the same row (right to left), press Tab +Shift keys simultaneously;
• To increase the selection press Ctrl + (direction arrow key).
• To scroll through all the cells of a selection from top right in a clockwise direction, click Tab;
• To scroll through all the cells of a selection from bottom right in an anti-clockwise direction, click Shift + Tab.
Tip 2: Use these shortcuts to change the size of selected cells:
• To insert adjacent cells to the right, hold Shift (or F8) and press the right arrow;
• To insert adjacent cells to the left, hold Shift (or F8) and press the left arrow;
• To insert cells above the existing selection, hold down Shift (or F8) and press the up arrow;
• To insert cells below the existing selection, hold down Shift (or F8) and press the down arrow.
Tip 3: Here’s how to introduce validate text
Select the cell you want to validate.
• On the ‘Data’ tab, in the ‘Data Tools’ group, click ‘Data Validation’;
• In the ‘Data Validation’ dialog box, click the ‘Settings’ tab;
• Click on the ‘Custom’ box, then select ‘List’ from the drop-down menu; and
• In the ‘Formula’ field, type in = ISTEXT and type the (first cell in the selection). Then click ‘Okay’.
There you have it. Three simple tips that can help you use your Excel accounting faster and more effectively.
Author: Ashley Churchyard, FSP Business