Excel | AccountingWEB

Excel

Say I have a timesheet.  I put in 'Mr A Bloggs' and wonder, 'What other entries were made for this client?'.

5

Excel lecturer David Ringstrom has started publishing a series of quick Excel tips on our sister site AccountingWEB.com.

Shareholder with 5% equity charges expenses of phone bill, travel and meeting expenses to Company - how to treat for tax and VAT

 

3

Hi all,

2

I would like to know how to account for:

 

  • lapses under IFRS 4
  • Cancellation of an insurance policies
  • Health insurance

 

I have a tracker.  People putting lower case letters in codes is not cool, so I want to make it so my spreadsheet either rejects them, or better yet, corrects them.

11

I am looking for a formula whereby you can enter your accounting dates and period and it will tell you what is your assesable profits in the opening/closing and change of accounting dates.  Is this

2

Time spent exploring Microsoft’s mountain of Excel resources will often reveal hidden treasures - even to the people who know the program best.

Pages