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
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
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
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.
I am trying to extract data from one worksheet to another and wondered if I could get some help.
Hi I export an Excel report from Time Keeper system (Access Control).
Happy Sunday evening peeps!
The wife is using Excel to compile results. 1. = poor, 2= satisfactory, 3-good etc to 6=excellent.
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
- New Range Name features in Excel 2007. By Simon Hurst 452,282 6
- Want to learn about Excel pivot tables? Start here. By David Carter 113,326 6
- ExcelZone's Five Minute Pivot Table Tips - Index 88,258
- Exporting data from Sage Line 50 into Excel #1. By David Carter 78,105 10
- Tutorial:.... Budgeting with Pivot Tables #1 [Excel 5 to 97] 71,310 2