Excel

We have a control sheet for our payroll clients, which has columns:

 

Client

Status

Completed by

Completed date

Contact details

etc

 

2

Microsoft’s TechEd Europe conference this week gave the company a chance to pave the way for a number of new t

2

As Apple’s share price and prestige has soared, it has become even more fashionable to berate Microsoft for its lack of vision and kludgy software.

1

 Is there and easy way - to load Hourly wage rate for multiple hours to obtain weighted average?

2

My knowledge of Excel is a bit limited - I have set up a simple spreadsheet and all I need is a cell which has a formula which says if cell B1 is larger than zero multiple B1 by 17.5% but I cant ge

19

I have been sent a excel file where the column names are displayed as numbers as are the rows.  So the cell that would normally be B3 is displayed as R3C2, row3 column2.  I believe is called relati

2

I want to extract data from 12 monthly worksheets to a monthly reporting format.  I specify the month (Jan, Feb, Mar, etc.) in cell F2 of the reporting format.  I can extract data from the monthly

9

AccountingWEB has formed an alliance with US online training provider CPE Link. Find out how regular contributor David H Ringstrom CPA can help you boost your spreadsheet skills.

I have been using Bridge/Waterfall charts in my reports for quite a while now.  The one I need to do now has a budget figure of, say, +£1500 and drops by steps to a negative actual of, say, £500. 

4

Pages