Offshore excel invoice template8/26/2023 Getting Google Maps Images into Excel opens up the possibility of creating simple applications that combine the different types of maps onto one screen. The analyst had more time to do other value-adding work (and also take holidays!)Īnother example is one you can personally play with right away.ĭid you know that it’s possible to export Google Maps and Street View images from the Google Maps service and show them in an Excel workbook? It was scheduled to run at 2am daily… so by the time the analyst came into the office the data was all ready for review. The solution did almost all of the work (especially data transfer between different systems). The company data analyst would manually pull out data from several different sources, transform it, format for presentation and share the results.Īfter the consultants built the automated solution, the analyst was no longer so stressed every day. This particular job took up a substantial amount of effort and was prone to error because of the multiple human-data interactions taking place between different Microsoft programs. They reduced the time taken for one daily data reporting job from hours to minutes – while increasing accuracy of the output. One good example is that of a US healthcare services company who brought in consultants with this skill (if you want more details… see this Tenet Healthcare case study). And you can even scrape data from the web. In fact once you know this skill… you can use it to link and automate multiple Microsoft applications like Access, Outlook and PowerPoint to create unified solutions. I don’t like waiting around for someone else or another department to implement a solution if it can be done quicker and more effectively myself or by someone in my team.Īnd I like the challenge of learning new skills.īut … if you like the results but don’t want to invest the time to personally learn and master a new skill, then you’d better not read the rest of this article (just contact me instead… because I work with a team of like-minded people who can help you achieve the same kind of results in your own company – find out more on this page).īefore I tell you more about what this skill is, and how you too can get started… Let me explain that this “rare and powerful skill” is not just limited to Excel or only applicable to financial transactions. I’m the kind of guy who likes to take an active approach to solving troublesome problems. Sometimes I will happily spend months of my life to learn a new discipline or skill.Īnd it did take me several months to learn enough to achieve the results above.Īs you can see, the payoff can be really big. I’m the kind of guy who likes to invest time to reap rewards. I hope you like the idea of doing 10 hours work in 10 seconds. A person (no matter how accurate and tireless a worker) might still make a couple of errors every hundred invoices. What’s more, there’s no room for data entry error because the spreadsheet takes the exact data from the billing download. With 400 invoices it took a total of nearly 10 seconds… that’s 0.03 seconds per invoice and about 1 million times faster than doing it by hand. And it does this much faster than any trained person can do it. My simple solution takes the downloaded billing information and creates sales invoices using the company’s standard format. So… I helped by creating a spreadsheet that automates the process. That’s a total of 400 invoices x 1.5 min / invoice = 600 minutes or 10 hours Let’s say there are 400 invoices to be created each month, and let’s say the accounts staff take 1.5 minutes to key in each invoice using information from the download (date, customer, e-mail, product(s) and amount(s) billed). However, there wasn’t a way to automatically generate sales invoices in the company’s standard format online. The accounts staff had the sales data, and next wanted to create sales invoice (for audit purposes). The new billings were easily downloaded from the original online source. However, the business added a new project and started billing smaller amounts and with a higher number of invoices. This was fine because the number of invoices were small and the dollar amounts relatively large. The invoice details were entered by hand and printed out for the accounting files. The situation was like this… a small company was using Excel to generate invoices. A couple of months ago I created a spreadsheet that reduces 10 hours of work to 10 seconds.
0 Comments
Leave a Reply.AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |