more-arw search

Topics

Member's Profile
Lindsay Ho
Title: Accounting Manager
Company: Calypto Design Systems
(Accounting Manager at Calypto Design Systems) I am working on a budget for next year need to figure out what is the revenue requirement for each GM and net income. For example, operating expense % over revenue is at 27% and GM is at 27%. For Net income of $1000, how much revenue require? If the GM is 1% lower which...
Member's Profile
Roger Frederick
Title: CFO
Company: Private
(CFO at Private)
Anonymous Member
Anonymous
(Financial Reporting Manager) Has anyone used the Vena Solutions for Budgeting or Reporting? Thoughts?
Anonymous Member
Anonymous
(Senior Accountant) Hello- Would you please let me know if there is a way by using excel function to pull: 1) invoices from a string of texts below? 2) Invoices related to the associated companies only? i.e. I would like to pull only invoice started with CO#3 and disregard the all others sales...
Member's Profile
Christopher Webb
Title: Accounting Manager
Company: Private
(Accounting Manager at Private)
Gary Zeune
Title: Managing Director
Company: The Pros & The Cons
LinkedIn Profile
(Managing Director at The Pros & The Cons) I need to include a table with prox 100 rows and 5 columns in html email. How do I create it so that people can click on the column top, header, row to sort by that column? Col 1, Col 2, etc.
Member's Profile
Fletcher Riehl
Title: Owner
Company: Consulting COO
LinkedIn Profile
(Owner at Consulting COO) Does anyone use Excel on a Macbook Pro? I'm an old pro on PCs, but I'm tired of carrying around two computers or running Windows on my Mac. Has anyone had success building financial models on a Mac OS running Excel? Are there any great macros/custom shortcut setup...
Member's Profile
Sheldon Reynolds
Title: CFO
Company: Private
(CFO at Private) Obviously the more advanced tools (like pivot tables and macros) are Excel only, but for basic spreadsheets, is Google on par with Excel?
Wayne Spivak
Title: President & CFO
Company: SBAConsulting.com
LinkedIn Profile
(President & CFO at SBAConsulting.com) From time to time I'll throw out a term that I see constantly used. How would you a) define the term (meaning) and then better explain it so most readers would understand what you want. This could be fun... Advanced Pivot Table
Charley Kyd
Title: Founder
Company: ExcelUser
(Founder at ExcelUser) Excel blogs are filled with specific questions about using Excel. So I thought it might be useful to back up and ask a more general question: What types of spreadsheet tasks are causing particular problems at your company, and why? Where do you or your Excel co-workers...
Wayne Spivak
Title: President & CFO
Company: SBAConsulting.com
LinkedIn Profile
(President & CFO at SBAConsulting.com) Here's a question that can be very entertaining and educational for all. Excel, every white and many blue collar workers needs to know how to use the product to successfully integrate into today's business world. "How to use" is obviously very subjective,...
Member's Profile
Thomas Burke
Title: Senior Management Consultant
Company: Clear Thinking Group
(Senior Management Consultant at Clear Thinking Group)
David Smith
Title: Manager
Company: Private
(Manager at Private) What advanced Excel abilities do you find employers need most, but often find lacking? Also curious about your views on how the lack of those skills impacts organizations. I have to give a presentation on this topic.
Wayne Spivak
Title: President & CFO
Company: SBAConsulting.com
LinkedIn Profile
(President & CFO at SBAConsulting.com) I inherited some pretty funky spreadsheets for a client of mine. One sheet is a summary of certain other worksheets (same spreadsheet), where the number being transferred to the summary moves. Think of taking Gross Sales from a Income Statement spreadsheet, Each month the...
Wayne Spivak
Title: President & CFO
Company: SBAConsulting.com
LinkedIn Profile
(President & CFO at SBAConsulting.com) I was having a drink with a fellow CFO and we got to the subject of Excel and what type of shortcuts we would want and what types our employees might want. We came up with several, here's a few: ALT MB which would (our/there) "MUTE BOSS" CTL FFM which would...
Anonymous Member
Anonymous
(account manager) Hello, Can any one please provide any macros to get reports from microsoft dybamics into excel i.e. i am currently using macros to transfer txt file from microsoft dynamics into excel and working on it. but if someonah has already some tools on this, it would be great to...
Anonymous Member
Anonymous
(Director of Finance) We currently use Excel for much of our periodic reporting, including a number of supplemental schedules. We are developing a management report ( a narrative md&a) and I was wondering how easy it would be to link this document so that it pulled/merged numbers for our...
Wayne Spivak
Title: President & CFO
Company: SBAConsulting.com
LinkedIn Profile
(President & CFO at SBAConsulting.com) Someone I'm connected to on LinkedIn is sourcing a job. One of the myriad of requirements is that the person had experience with Excel sheets containing 100K+ rows. Why would you trust your business to a 100K row spreadsheet? Wouldn't recalc take a very long time?...
Sara Voight
Title: Controller
Company: Critical Signal Technologies, Inc
(Controller at Critical Signal Technologies, Inc) I am using a very large excel file to do our annual budgeting (yes, a program is on tap for future years). We have turned off the automatic calculate formula and either use F9 or save to force an update at various points in time to our work. We are finding that some cells...