By . Expenses Spreadsheet. At Thursday, May 27th 2021, 14:45:19 PM.
He will now depend on you for the information, instead of going to the people who prepare the raw spreadsheets. You gain access to him, and as you know, "access is power." Tip #2: Offer to help him with spreadsheets you dont get (yet) If you know that your boss gets other spreadsheets from elsewhere in the company (but you dont get them), ask him to get you copied on them, so you can include those on his dashboard. Find out what totals, charts, or "top n" lists he tends to scan those spreadsheets for. Then, tell your boss that you can consolidate the key information from all those spreadsheets as well (both what you prepare and what others prepare). You can add that to the Excel dashboard you send him every day (after implementing Tip # 1). Tell him how much time youll save him; how he can stay on top of the numbers with the all-inclusive dashboard.
After you have spent some time collecting figures and transforming them into a Microsoft Excel spreadsheet you may need to present your workbook to clients and colleagues. Thanks to the huge array of features offered by the programme, you can design your workbooks in many different forms. Some entrepreneurs prefer information to be presented in straightforward tables, while others benefit from the varied functions of the software and they create coloured pie charts to reflect the data. Whichever way you choose to present information, you are likely to find that MS Excel is the backbone of many workplace documents that require analysis and presentation of data. A great feature of the product is that is has been designed to help you produce workbooks that can be easily moved to other applications. For instance, if you have recently put-together a spreadsheet that shows which departments are underperforming, you may wish to transfer information to other MS products.
I never guestimate a job. After measuring and counting I take my numbers and go to my office and prepare my estimate. If you do a search in Ezines, you will find other articles by me describing how I use the Excel Spread Sheet to total up and multiply high time factors to those elements of the job that are over eight foot high. Why? It takes you a lot more time to paint a window at twenty feet that it does at eight feet of height. After I total everything using the formulas built into the spreadsheet, I go to my estimating software and prepare the estimate. I itemize everything, I never do an estimate that says $2000 (or whatever amount it is), for painting the interior. I itemize everything, and its easier because that is how I count things. Also, because if I count 16 shutters and when I am painting them I count 20, I tell the customer that I only charged for 16, and they can see it in black and white, so they have to pay extra for the extra shutters, this way I dont get cheated. Anyway the subject of itemizing your estimate is a whole new article.