Thanks for this, i think you are an EXCELLENT teacher and trainer. I will try this from my QB desktop One question on excel. I have officer 365, when I double click or right click on an excel file in windows explorer, Excel opens but the file itself does not. i get a blank worksheet. i can drag the file to the blank sheet and it opens , but no other way. used to open at a click last year. Thanks ! David
Thanks! I'm glad this was helpful for you. Usually this happens to me before I click "enable edit" which shows up at the top of the page. See if that works!
Thanks for this. One note regarding dates: I think if you change QB to use the international, sortable date standard yyyy-MM-dd, then you won't have to monkey with it in Excel. The reason this is a standard is that if you use yyyy-MM-dd in folder names, filenames, spreadsheet data, etc then dates always sort correctly.
Thank you for this Clara
Fantastic Hannah! Thank you for the date tip! I learned a ton from this one!
Yay! It took me a while to realize that tidbit about the date, so I am happy it helped you too!
Love this series thank u for your time!! Much appreciated, hoping to learn more accounting related tasks.
Great! Thanks for watching! We've got a lot more videos on accounting coming your way!
Thank you for your work! Your tutorial nicely complements my accounting undergraduate program! :)
Great to hear!
Fantastic !.... Excel tricks ..... like I would like a video on Macros.
Thanks for this, i think you are an EXCELLENT teacher and trainer. I will try this from my QB desktop
One question on excel. I have officer 365, when I double click or right click on an excel file in windows explorer, Excel opens but the file itself does not. i get a blank worksheet. i can drag the file to the blank sheet and it opens , but no other way. used to open at a click last year. Thanks ! David
Thanks! I'm glad this was helpful for you. Usually this happens to me before I click "enable edit" which shows up at the top of the page. See if that works!
Thanks for this. One note regarding dates: I think if you change QB to use the international, sortable date standard yyyy-MM-dd, then you won't have to monkey with it in Excel. The reason this is a standard is that if you use yyyy-MM-dd in folder names, filenames, spreadsheet data, etc then dates always sort correctly.
Awesome! I like mm/dd/yy format in general, but that's great to know for the future!
Dang, rip. I was hoping to create a pivot table of the whole general ledger. Then you deleted the account name
Have you find a way to do that? I have been looking a way to obtain the data in a way that a pivot table can be created with accounts and sub accounts
@@AgustinDelfin-fb5fs I have not :(