Excel | AccountingWEB

Excel

 

Hi,

 

I have currently completed my level 3 AAT qualification and now moving onto level 4. I am thinking of doing some bookkeeping after hours etc as a sole trader. 

1

From time to time, I have a situation where a row in Excel loses its row number (i.e.

10

I have a spreadsheet to calculate Er's NI contributions per employee.

2

I'm not the bookkeeper but unfortunately I still have to suffer the Sage 50 effect.  I hate it for all kinds of reasons.

4

I have a list of over 1,000 items.  I want to search for the latest occurance of a word, but when I search, Excel starts at line 1, meaning I have to click past a lot of items to get to the one I w

6

In his latest Excel tip article from AccountingWEB.com, David Ringstrom reviews the options for protecting the worksheet integrity in different versions of Excel.

2

I am trying to calculate how much bonus to pay an employee so that the net cost to the company is £1000.

Employers NI is 13.8% and Corporation Tax is 20%.

1

For all the buzz about Cloud accounting, the Software Satisfaction Awards 2012 confirm that Sage 50 Accounts and QuickBooks both continue to support sizeable numbers of users.

7

You may have noticed that the submission options for Any Answers look a bit different. Don't worry, they don't go anywhere else and existing posts haven't been affected. 

1

Sometimes Excel alone is not enough, so David Ringstrom offers advice on how to install and track add-ins that extend the application.

2

Pages