Sometimes it is more important to get the right answer than to worry about writing the most efficient program. I read a book years ago that gave a really good description of something Excel users should understand. Matrix math, external data feeds, massaging data so it can be turned into "*content", understanding the limitations of Excel, Properly recognizing when a given data manipulation should be performed by an external program, etc. This increase in freelance costs short term saved us in terms of severance and in terms of a morale hit of doing layoffs.Ĭonnect the dots of how what you built made a business impact or made some bigwig’s job easier. We invested recruiting resources in knowing how to pipeline these freelancers quickly so when we needed them we could hire them short term, but overall we had better utilization and less need to have layoffs due to having people on staff that weren’t likely to be fully sold-in to our clients. Quantitatively showed what roles we usually had utilization issues and so we shouldn’t hire someone full-time to do the role unless it was sold x% for y duration of months. did an analysis of our cost to freelance certain roles vs hiring them full time. Based on this model I could demonstrate that we could make a more compelling offer that seemed attractive to our clients, but actually made our firm more money vs using an across-the-board discounting model.ģ. It was fine-tuned so we could achieve certain margin levels or spend levels by our clients based on the skills/roles we thought they’d use most based on the prior 24 months of scoping and delivering projects. Built a model to generate a rate card for how much to charge clients for each role within our professional service organization. This used to take an analyst all day Friday to generate these reports and after I made this file an analyst would click one button and the reports would be emailed in a couple minutes.Ģ. Then it automatically emailed each regional director with an attachment of their team’s file and the body of the email text was basic commentary of 5 metrics. It would pivot by each region and create work over week variance analysis by account. Wrote a macro that logged into Salesforce and pulled our organization’s revenue pipeline of all active projects each sales person was working on. I’d talk about how you’ve used the tool to automate some process, make it more efficient, or organize data in a way that previously wasn’t done by people in your organization. If you’ve been working on it for a decade and fact that you’re on this subreddit means you likely are familiar with many of the advanced features. You learn by practicing, but also by jamming with others and improvising. You can do similar thing with cells but it's not always that useful.ĭoing it you can transform the code from (more or less): Workbook. Opening vba you can assign code names to every sheet, doing it you can always refer it directly in the code, no matter what name is shown in excel. If you don't it may hapoen that vba tries to open a sheet from the wrong workbook, screwing things up. When you open a workbook assign it to a variable and use it whenever you need to do any action. One thing i can suggest: recordin macro you will see a lot of 'lect', '' but that stupidly slow. It's been more than a year since I used vba so i don't remember exatcly the code to open files but you can find everything online. I suggest you to just record a simple macro and experiment with changing the code. They are identifiable with a special user flair.Ī community since MaAsking a question? Describe if you are using Excel (include version and operating system!), Google Sheets, or another spreadsheet application. Occasionally Microsoft developers will post or comment. Recent ClippyPoint Milestones !Ĭongratulations and thank you to these contributors Date Include a screenshot, use the tableit website, or use the ExcelToReddit converter (courtesy of u/tirlibibi17) to present your data. NOTE: For VBA, you can select code in your VBA window, press Tab, then copy and paste that into your post or comment. To keep Reddit from mangling your formulas and other code, display it using inline-code or put it in a code-block This will award the user a ClippyPoint and change the post's flair to solved. OPs can (and should) reply to any solutions with: Solution Verified Only text posts are accepted you can have images in Text posts.Use the appropriate flair for non-questions.Post titles must be specific to your problem.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |