We recently created 9 new training videos for our online MYOB training course and one of them demonstrated how to export and import data from an MYOB training company datafile. Exporting and importing is used to extract transaction and sales information and also customer or supplier card files from MYOB to use with Microsoft Excel in performing mail merges.
We have included the simple accounts list that we use in our online MYOB bank reconciliation course as a file you can download and open up in Notepad or Microsoft Excel. The image above shows what the file looks like when opened up in Notepad. It’s called a TAB-DELIMITED text file and this example includes a header record that gives you the name of each field (column)
If you want to learn more about TEXT format (including CSV – comma separated values) files and how to manipulate this type of data using Microsoft Excel, take a look at our Microsoft Excel course 307 (visit this link and scroll down until you see the course contents of course 307: http://ezylearnonline.com.au/courses/microsoft-excel/excel-course-outline-2/).
If you need training on Microsoft Excel and data storage types you’ll be thrilled to hear that this course is one of 9 courses that are all included for one low price and LIFETIME student membership at the EzyLearn online Microsoft Excel course. Click here to enrol.
The one thing I've found fascinating in accounting and bookkeeping is watching technology companies try…
Is your name on this list? I want to thank the following students for choosing…
There are many finance professionals — who does your business need? Does your business need a…
Employers like small business owners are looking for staff online using Google. From office admin…
Most complete courses are now discounted. If you want to learn something new now is…
The features that each of these companies provide is invaluable for businesses. We can't do…