more-arw search

Topics

Anonymous Member
Anonymous
(Entrepreneur) Hey all, I am currently struggling trying to figure out how to best structure my sales forecast. A small part of our business we have a fixed unit price and a goal for how many we want to sell of each per month at a predefined unit price. The main part of our business...
Member's Profile
Steve Cannell
Title: Senior Accountant
Company: Private
(Senior Accountant at Private) Hi, I just registered with this site in hopes of gaining a resource that I can pull from. I work as an accountant in a small business and help with the internal duties surrounding accounting. I report to our controller/VP Finance. They have produced a budget for 2018, and...
Nancy Tso
Title: Head of Client Service
Company: SkyStem
(Head of Client Service at SkyStem) Here is a story of what people used to do with Excel, back in the day… (here’s the full article) Forgive me if I now divert into telling you a quick story about my time spent on the Microsoft Excel team way back in 1991. (Yes, I know you were not born yet...
Anonymous Member
Anonymous
(Director of Finance and Operations) **BACKGROUND** We are an enterprise-SaaS startup; our Sales Contracts are typically multi-year agreements. **ASSUME** * Sales person closes a 3-year contract with Total Contract Value (TCV) = 300k * Sales person commission is 10% **QUESTIONS** 1) At the time the Sales...
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...