How do I manage my personal finances with Microsoft's 'Money in Excel' feature?
Money in Excel is the smart and dynamic template that offers you to connect all bank accounts or any other money investment in a secure way to Excel and import the account information and transactions on the spreadsheet. If you are a family subscriber then download this template of Excel and follow the on-screen prompts and connect financial accounts by the use of third party plugin. Once all the information is authorized the workbook will be automatically updated with all the information. Once all your personal accounts have been connected Money in Excel will be an automatic way to import the transaction information within seconds and you don have to spend hours on maintaining your financial spreadsheet. Simply click on the Update button and you will get a quick snapshot of every transaction you made. For more shortcuts like this and for building strong muscle memory in Microsoft Excel you can play with KeySkillset educational games that include more than 2 shortcuts and over 7 formulas. Learn and do all at the same time collect kudos and see your brain efficiency score raising with KeySkillset.
What are some practical travel hacks?
Im not a fan of hacks. It implies there is some cheat code you can use to make travelling a breeze. It absolute bullshit. There no such thing as hacks. There is however such a thing as travelling smart. If you travel smart you will certainly travel cheaper and enjoy your trip more as a result. Here are a few of my favourite tips to travel smarter after five years living and travelling the globe. Pack light. I cannot stress this enough. Wherever you go your luggage goes with you. Pack only what you need and no more. If you desperately need something you can always buy it when you get to your destination. Planning your trip to smallest detail seems to be in vogue nowadays. I don't understand this. I hardly plan my trips. Have I regretted it during my five years of travelling? Not once. Over-planning takes the fun out of going to a new place. Personally I would be stressing about seeing all the places Ive researched. Going there with a few ideas and an open mind allows me to explore the place at my own place and discover areas I might not otherwise have encountered! Bring a water bottle with you. Most countries have water fountains you can use to fill your bottles up! This will prevent you from wasting money on bottled water and spreading plastic around the planet. If you have smelly feet like me this tip will stop your shoes releasing noxious fumes. Simply put a tea bag in each shoe and the leaves will absorb the deadly odour leaving your shoes smelling than before! Always keep some money on you in case of an emergency. Simply hiding ua31 in your shoe coulde in handy should you God forbid get pickpockets or robbed!
What percent of the company do the founders own after 1, 2 or 3 stages of VC funding?
That all depends on How much outside money thepany takes in each round. What the valuation of thepany is in each round. I made a little Excel widget that you can use to figure this out for yourself. You can download it here s In the example I have pre-loaded into the calculator the rounds were as follows $2M raised at an $8M pre-money. $5M raised at a $2M pre-money. $15M raised at a $45M pre-money. In this case the founders own 8% 64% and 48% respectively after each round of funding. Frankly this is a pretty rosy example. Here's a more pessimistic oue from the perspective of the entrepreneurs (perhaps thepany was slower-growing and more cash-intensive) $3M raised at a $5M pre-money. $8M raised at a $13M pre-money. $2M raised at a $25M pre-money. This would lead to the founders owning 63% 39% and 21% after each round. Which leads me to the following point If you want to retain more ownership of yourpany find a way to survive with less outside investment and find ways to increase the perceived value of yourpany (either through faster growth or morepetition between investors). Enjoy the widget and please let me know if it's useful. ( update 7 for more recent analysis on venture and startup operations swing by )
How can I get the Manipulate_Points_on_Charts Add-in for Microsoft Excel 2013?
Did you try getting the add-in from Microsoft? Even though it doesn't explicitly say that Excel 213 is supported it appears to work. Excel Add-In for Manipulating Points on Charts (MPOC) - Office Blogs s I just downloaded the add-in from that webpage (there's a in the Conclusion section at very bottom of page that takes you to a EULA page that has the actual ). I then installed the add-in in Excel 213 and used it to manipulate a chart showing the amount of money from a series of investments How do you create a future value calculation in excel with increasing monthly investment amount? question qid 719885 I then launched the add-in from the Add-Ins tab on the Ribbon specified my chart series and changed the last data point to a higher value. The add-in then asked which cell needed to be changed to make that happen. I responded and the add-in launched Goal Seek to find the value. And after a couple of seconds the chart shifted due to the change in my interest rate assumption.
By using of Excel VBA programming, how can I start to earn money?
Ive been earning a 6-figure ie primarily as an Excel developer for some 2 years. So yes it is possible to make a living (and a very good one) with VBA. Now for the obligatory caveats ) The Number of Opportunities There are far less opportunities where the job title is VBA Developer than there were say 1 years ago. Sure they still exist but theyre focused in specific industry sectors and geographical locations (well get to that in a minute). Youll Want Complementary Skills If you wanted a job as a web developer you be hard pressed to find something paying well with HTML skills alone. Nowadays you typically need to be a full stack developer tomand good rates. The same principle applies with VBA development. Youll really want to enhance your VBA withplementary technologies such as Python and C#. Ironically while C# and VB .Netpile down to basically the same IL code V B .Net pays far less than C#. Youll also can avoid databases usually relational but also others. This includes the ability to read and write SQL. If you want to do VBA work for small business (more on this in a minute) you can employ MS Access. But if you want to do VBA development work in the corporate world youll want experience with an industrial-strength database such as SQL Server or Oracle. This includes the ability to write stored procedures. Work on Your Domain Knowledge However your technical skills are only half the story. The other half will be your domain knowledge. By this I mean developing knowledge and skill in a specific industry sector or niche that makes you more valuable in that sector. Even within banking & finance I focused on a sub-niche. I picked finance for several reasons. One is that the industry pays well. The other is that they invest in technology in order to staypetitive. The last I investigated banking & finance spent on average 3 times as much on IT as almost any other industry. So where are the VBA Opportunities? From what I can see there are three primary areas in which you can earn good money with VBA. As of today there are still opportunities in the finance industry or providing VBA consulting and development services to small and medium business. So your targets are Banking and Finance Jobs which involve VBA but are not VBA developer jobs (e.g. Data Analyst) ordered-list But what about freelance platforms? Ive excluded the many online freelancing platforms such as upwork s as I suspect the majority of the VBA developers there do not earn a substantial ie (if anyone has evidence to the contrary please let me know). Banking & Finance I've spent most of my Excel & VBA development time working in trenches (front office) in the banking and finance arena. Mainly investment banks and asset managers but also retail and institutional banks. The roles pay well. Some of them very well. But they have barriers to entry. One is domain knowledge as I mentioned before. While you don need to have a finance related degree you will be expected to have an understanding of the specific area in finance you want to works as a VBA developer. For example Ive done a lot of work in fixed ie regulatory capital and risk (main market risk and credit risk). The other restriction being a VBA developer in finance is geography. You really need to be in a major financial hub such as New York London Singapore and Hong Kong. Freelance Consultant There are many small-to-medium enterprises who need solutions that off-the-shelf software doesn address. They often don have their own IT department yet still have business problems that need solving. Therein lies the opportunity. Ive known of some VBA developers who focused on a specific industry niche. This not only enhanced their credibility as an authority in that niche but enhanced their profitability as they could streamline their development and processes. Ive done VBA development work for a broad range of industries including national retailers industrial manufacturers an international car manufacturer government departments corporate legal departments utilitiespanies national FMCGs (Fast Moving Consumer Goods) national hardware suppliers small businesses and mortgage brokers The opportunities are out there - you need to go and find them. Permanent Jobs There are still opportunities in the permanent job market as these screen shots show. The first is from JobServe s and the second is from eFinancialCareers s . Two things to note both relate to the UK market (London specifically) and nearly all the VBA job opportunities are in finance. Youll need to look at what is available in your local market but as mentioned well paying VBA jobs in finance have a geographical limitation. These screenshots were taken on Sunday 7-Apr-219. Non-Developer Jobs Involving VBA If all this seems too daunting another alternative is to look at job (contract or permanent) where the job title is not VBA Developer but is enhanced by VBA skills. This includes Data Analysts Business Analysts and Technical Analysts. Many of these pay quite well. Be a Freelancer not an Employee If you want to make a good living with VBA youll also want to be a freelancer not an employee. By freelancer I mean a contractor or consultant who is self-employed. Contractors not onlymand a higher rate than employees but they also have more control than employees over their taxes. All the best Marcus My Excel Genius