Excel

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

Hi,

 

I am trying to extract data from one worksheet to another and wondered if I could get some help.

 

8

Hi I export an Excel report from Time Keeper system (Access Control).

6

Happy Sunday evening peeps!

The wife is using Excel to compile results. 1. = poor, 2= satisfactory, 3-good etc to 6=excellent.

4

I have a set of whole numbers but want to format them so that (say) 1,200,000 displays as £1.2 m.  The £ sign and millions tag are no problem, but how do you format a number so it displays only the

6

Pages