Showing related tags and posts accross the entire site.
-
I use Excel in real estate and personal goal setting and run into questions that aren't evident to me.. like 'how to get around circular formula errors .. pair prior ttl today run ttl pair prior ttl total run ttl A/U 100 10 110 E/U 10 7 17 G/U 50 2 52 N/U 10 8 18 E/G 200 3 203 U/C 10 9 19 E/C...
-
Can please someone send me the workings in a excel sheet which shows how to create a bell shaped graph. I have 500 data points and i'm struggling to show standard deviation in the form of a bell graph. You help will be appriciated. My email address is : vanse@hotmail.co.uk Thanks
-
There have been a few postings in different newsgroups regarding the number of keystokes involed when invoking a filter selection in Excel 2007. This reminded me of a conversation I has at a conference some while ago with Dr Peter Grebenik of Brookes University, Oxford, who uses Excel for storing all...
-
Nick I can understand why you would not use the database functions, however would you not start someone off with them? I find them very good for getting peoples heads around the way excel can identify data (handy for moving onto sumproduct) as database functions are more "visual" when setting...
-
Giff That's a big list. It will be very tough to lead anyone in a 'correct' direction as it varies widely on 'application'. For example, I am a date guy, so pivots, external data would be top of my list. Although I have never really been a charting guru, it coming up my league as...