Hi i just used your video to create an accounting spreadsheet, and I would like to merge my downloaded bank transactions into this spreadsheet is that possible?
This is great thanks, can I ask though? I'm on a Mac and some icons differ slightly, however I cannot get the formula in P5 to 60. It's either 20 or 78.25333333 The written formula is different to your VoiceOver where you say "Point 2 O 5" but O5 is written, please can you clarify as I feel like I'm missing something. Unless a it's PC/Mac thing. Many thanks in advance!
hi kirstin. Not sure if you figured this out or not but the formula is not to calculate 10% of 41.89. It is calculating how much tax is added to the total amount. So without tax the total amount is 38.08 + 3.81 (tax)= 41.89, hope this makes sense
![Create a TIMESHEET Template using an Excel Spreadsheet - [ 15 Minute Tutorial ]](http://i.ytimg.com/vi/FBwhI808p9U/mqdefault.jpg)
![Create a TIMESHEET Template using an Excel Spreadsheet - [ 15 Minute Tutorial ]](/img/tr.png)
![How to keep Inventory using an Excel Spreadsheet - [create your own Template]](http://i.ytimg.com/vi/msQoTuCsKJ4/mqdefault.jpg)
Thank you. Helping me so much with my business start up!
Hi Harry, glad to help. Good luck with the Start Up! :-)
Absolutely brilliant, thank you very much, look forward to learning more from you 👍
Glad you found it useful :-)
Great video, thanks
Glad you liked it!
Id love a copy! This is great!
Hi, Downloads are available at www.MrSpreadSheet.com :-)
At 7.10 in the instructions on the line 19 the total value suddenly appears yet dosnt on my computer..
Hi, Why not download the original and check your work against that. Download is available at www.MrSpreadSheet.com :-)
It was brilliant… tnx and hope to learn more. How can i become a copy of this template plz??
Hi, Glad you found it useful. Downloads are available at www.MrSpreadSheet.com :-)
i could not get my totals in row 19. what am i doing wrong?
Hi, You can check your work against the original. a download is available at www.MrSpreadSheet.com :-)
at the =SUMIF(Analysis,L5,NetValue) code I get a #NAME? error. How do I fix this?
Hi, You can check your work against the original. Downloads are available at www.MrSpreadSheet.com :-)
Which Excel version use for advanced functions
Hi Tejaswini, I use Excel 365 :-)
Can you make more than 10 analyst type?
Hi Temique, Yes, there is no real limit to this 😊
Hi i just used your video to create an accounting spreadsheet, and I would like to merge my downloaded bank transactions into this spreadsheet is that possible?
Hi Marquita, Yes this can be done, but would need quite a lot of programming. :-)
How can I get a copy of template?
Hi, Downloads are available at www.MrSpreadSheet.com :-)
There is no "copy in headings" in a new blank workbook for excel. This is so frustrating.
Hi Kenneth, You can check your work against the original. See the download guide video ua-cam.com/video/m7Zf8_UWPGQ/v-deo.html 😊
What is the best way to link pdfs and enable me to share the document with my accountant? I don’t want to have to post a USB drive.
Hi Heather, have you tried sharing a cloud link, like OneDrive. This can be password protected and easy to set up. :-)
@@MrSpreadSheet do the files need to go in a specific location?
How can I get a copy of the finished spreadsheet?
ua-cam.com/video/m7Zf8_UWPGQ/v-deo.html 😊
This is great thanks, can I ask though? I'm on a Mac and some icons differ slightly, however I cannot get the formula in P5 to 60. It's either 20 or 78.25333333 The written formula is different to your VoiceOver where you say "Point 2 O 5" but O5 is written, please can you clarify as I feel like I'm missing something. Unless a it's PC/Mac thing. Many thanks in advance!
Hi Shar, You can check your work against the original. See the download guide video ua-cam.com/video/m7Zf8_UWPGQ/v-deo.html 😊
Mrs. Spreat sheet. I do deppend on your precentations. But, this is the worest precentation you ever released at this time, interms of the visiabilty.
Thanks for your insights Ismael :-)
How could i contact you?
Hi Scapp, see the contact links on the about page :-)
Send a copy please
Hi Imran, Please follow the ‘Download’ guide in this link 😊 ua-cam.com/video/m7Zf8_UWPGQ/v-deo.html
You're formula is wrong ... the tax rates are not calculating properly. 10% of 41.89 is not 3.81.
Hi Kirstin, You can check your work against the original. See the download guide video ua-cam.com/video/m7Zf8_UWPGQ/v-deo.html 😊
hi kirstin. Not sure if you figured this out or not but the formula is not to calculate 10% of 41.89. It is calculating how much tax is added to the total amount. So without tax the total amount is 38.08 + 3.81 (tax)= 41.89, hope this makes sense