Blog

Basic Guide to MYOB Data Importing

importing-data-myob

When you begin using MYOB, one of the most important and first steps you have to know about MYOB would be data importing. Importing data into MYOB is an essential part since you have to make sure that the data imported is reliable, especially when you will be using it often. Here is how you can proceed with MYOB data importing correctly:

There is a specific format that external data should follow when it comes to MYOB data importing, so that the entire process can go smoothly. It could be from a spreadsheet or other types of files, but the general format MYOB essentials accepts include data being organised and arranged in the right fields with no missing data from mandatory fields, header rows in the same format, and saved in a .txt file format. Your data should be separated by tabs instead so if you use spreadsheets, they should enable you to export to these types of files.

If you have no idea how to go about it, do not worry. The official MYOB website has sample file resources that are free for download. These sample files are build for hassle free MYOB data importing so feel free to download and edit so that the rest of your information can fit within the sample file. This way, importing can be made a straightforward process. However, make sure not to delete any unneeded fields.

Alternatively if you are using other earlier versions of the MYOB software, you can perform MYOB data importing by exporting the contacts/items from your company file first. Simply use the export data function from the File tab. As they are created for easy exporting, do not change any information fields. Make sure you export everything by clicking on Match all.

Allow the exporting process to run it’s course- once it’s done, all your data should be saved in a text file. You can then use the text file to import it into your new MYOB software with no difficulty.

If you are able to follow the steps above accurately, the MYOB data importing should be imported successfully with no errors. However to err on the safer side, make sure to do a double check. If there are still issues, you can consult the online MYOB forum or liaising with the official MYOB site staff. You can also consider signing up for MYOB training classes to learn more about data.

Microsoft Excel Android Apps- Worth A Try?

In an attempt to better cater to it’s user’s needs, Microsoft Office has finally made Microsoft Excel android apps available on the market for download. The creation of the android apps have undoubtedly caused quite a stir, but at the end of the day, is it really worth the download? Today, we discuss the topic at hand with these factors in mind:

The Good

Microsoft Excel android apps allows users to gain access to their workbook files even while traveling outdoors, contributing to a boost in terms of productivity since users can now make decisions and view files outside. The android app also retains a user-friendly interface similar to what users are accustomed to so navigating around features and functions is fairly straightforward. Users are able to create, view and edit excel files via mobile with the certainty that their work is saved with seamless results even when transferring from PC to mobile and vice versa.

What’s more, Microsoft Excel android apps are free to use so virtually everyone with a mobile phone and data connection can download/use it. If users take the trouble of signing up with an Office 365 subscription, they stand to unlock even more useful features that can help them in their endeavors. Microsoft Excel can also be linked to many sharing platforms like OneDrive, Dropbox, Google Drive and more for easy file retrieval and sharing with others. Other members can also make changes to the spreadsheet together once they have accepted custom invitations and previous versions of files are all stored safely so users can revert to them any time.

The Bad

Unfortunately, Microsoft Excel android apps seem to be unable to function as well when it comes to larger workbook project files- prone to freezing or closing when users try to access or use features. There have also been several reports on bugs and updates causing access difficulties for mobile users. The app has also been known to experience numerous crashing problems.

Final Verdict

Microsoft Excel android apps have earned an over all rating of 4.4 out of 5 from android users in the Google Play section. Most users seem satisfied with the functionality of the app, citing that use of the mobile is immensely helpful and simple to grasp. However, the android app is lacking in certain areas. Certain users experienced difficulty with file access after recent updates and have to resort to 3rd party applications to do so, which is a major drawback. As of the current moment, Microsoft excel android apps seemed to fall short when it comes to graphical content, which could be complicated since business files often come with logos and the like.

5 Custom Excel Functions To Try

With versatility as one of it’s strong points, Microsoft Excel allows users to perform a series of custom excel functions on their excel spreadsheets. Do you know what these functions are? Discover them here and try them out for yourself today!

  1. Character Replacement

One of the most convenient custom excel functions would be character replacement, where users are able to replace certain specific characters with numbers. In order to do so, users can use IF, MID and REPLACE functions. The formula users can use should resemble something like this:
[ =IF((MID(__,_,_))=”_”,REPLACE(__,_,_,_), __) ]

This is to let Microsoft Excel know which characters are to be replaced and what they are to be replaced with. The formula can be tweaked according to position and characters but once done correctly, the replacements will be smooth and seamless.

  1. COMBINA function

    Another useful feature out of all custom excel functions would be the COMBINA function. This function allows users to return number of combinations (with repetitions) for a given number of material. The formula to be entered would be: =COMBINA(__,__). When applying this to cells, it will reveal the number of combinations the user can create.
  1. SKEW.P function A function first introduced in Excel 2013, SKEW.P (=SKEW.P(___)) returns skewness of distributions that are based on populations. This functions well when it comes to applying it to data sets, though users do have to take note that if there are invalid values that are referenced, there would most likely be errors in the form of #NUM! Error. Some other error types to look out for would be data type ( #VALUE! Error and #DIV/0! Error).
  1. User Defined FunctionsMicrosoft Excel also allows users to create user defined functions from other workbook files through the use of VBA using the formula: [=OtherWorkbookName.xls!Functionname(__) ]. There are also specific add ins that allows users to reference functions without having to create references if they are installed.
    [ =Functionname(__)]
  1. RAND function

Keep track of your data and adjust data values with the help of RAND function, a function that notifies and allows users to gain access of random numbers in their data sets with every change they make to their data. Users can retrieve random numbers between a data range. RAND functions can be used in different formulas, for example, when users want to track random numbers that are greater/equal to 0 but less than 1, it would look like =RAND() but if the range is less than a certain value, would appear like =RAND()*__.

5 Steps To Remember For Excel Printing

The process of printing can be a confusing one if you treat Excel like other ordinary documenting software. There are certain procedures in Excel printing that you have to undertake to get a good print. To help reduce the amount of time it takes to produce a good quality print, here are 5 steps to remember when it comes to Excel printing:

  1. Watermark Insertion

Watermark insertion is a good deterrence to have in order to safeguard your Excel documents 1515against others who may try to claim credit for it. To create a simple watermark, locate the ‘Insert tab’ and choose ‘text’. This will enable you to create your watermark through Word Art and paste the text. If you already have a custom watermark image to use, choose ‘Insert’, select ‘Header and footer’ instead from the same ‘Text’ section, choose ‘Picture’ and ‘Ok’ the step.

  1. Non-continuous Area

In order to print non-continuous areas of your Excel file, you have to add them into the print area. Choose the range of cells that you want to add, then hold down CTRL on your keyboard so that you can select another until you have covered all that you wish to print. Now simply choose the Print area icon, which can be found in the toolbar or select the ‘File tab’ and choose ‘Print Area’, ‘Set Print area’ and print.

  1. Page Breaks

Page break insertion and removal are easy to accomplish. Tell Microsoft Excel where to insert or remove page breaks by locating the ‘Page layout’ tab. Choose ‘Break’ option and it would reveal ‘Insert Page break’ or ‘Remove Page Break’ options. Page breaks are one of the easiest functions to work with when it comes to Excel printing, and yet one of the most effective as well.

  1. Custom View

Not many users are aware that custom view could be used for Excel printing when quick printing is needed. Using the ‘Custom view’ function on any worksheet, select CTRL+P and hold it so that the print dialog box is enabled for you. Select OK, your command would be processed and printed with relative ease. This is a good function to use especially when you only require to print certain sections for reference as quickly as possible.

  1. Page Numbers

If you want to add page numbers to your Excel worksheets while printing, you can actually do this in a variety of ways. Select the ‘Page tab’ and locate the ‘Page set up’ so that it opens up the dialog box and enter the number in the ‘First page number’ option. Or enter it into the ‘Header/Footer’ section. You can also enter it into a cell instead.

MYOB Essentials Vs MYOB AccountRight

With it’s ever growing popularity, MYOB has thrived and continually produced more and more efficient software programs for users all over the world. If you are considering purchasing and using MYOB products as an accounting software, it may be difficult to make a decision granted that there are so many options to choose from. Here are two of the most popular MYOB softwares for your consideration, find out more about the two and how they compare against each other:

  1.  Expenses

Comparing expenses for their subscription plan, MYOB Essentials is undeniably more affordable compared to MYOB AccountRight. So if you are a new start up corporation running on a limited budget, then MYOB Essentials might work out better for you. Contact an MYOB 13reseller and ask if investing in the software can entitle you to a PIC claim if you are a local corporation for added expenditure saving.

  1. Accessibility

    In terms of accessibility however, MYOB AccountRight provides more range. MYOB AccountRight gives the user an added ability to work with multiple accounts and get more done. Users can also work offline so that can optimise productivity. Additionally, it allows users to make local backups as well. So with these factors, users can actually get a sense of both convenience and security.

  1. Compliance

One major aspect of a good accounting software program would be Tax Compliance. All MYOB softwares are equipped and fully tax compliant so users can enjoy a sense of security when using the software program for important day to day tasks. Any upgrades will be processed and auto updated or prompts for the user to update would appear.

  1. Functions

All MYOB softwares come with a whole range of essential functions that a professional accountant needs. Both MYOB AccountRight and MYOB Essentials both possess important accounting features. Though MYOB AccountRight wins by a slight margin in terms of functions as MYOB AccountRight allows users to create/track job profits and losses, as well as manage purchase orders.

  1. Payment

MYOB AccountRight also has an additional feature not found in MYOB Essentials- Accepting payment from invoices. This makes payment methods more flexible and convenient since you have more options to choose from. It also makes things a lot easier to keep track of since everything is consolidated in one software.

When it comes to comparison between the two, MYOB AccountRight does have it’s advantages over MYOB Essentials. Though one important factor to consider is that if you need the additional functions MYOB AccountRight offers presently at the moment. If you have expenditure concerns, then MYOB Essentials would be a better choice since it already covers most of the accounting functions you need.

Understanding Excel VBA In 5 Steps

Excel VBA is an obscure yet highly rewarding feature that few have dared breach for fear of sabotaging their own workflow. Today, we show you what Excel VBA truly comprises, the potentials it has and why just exactly you should seek to understand it using 5 steps:

1: Basics

VBA code is a type of language found in the Microsoft Excel system that allows for customisation and experimentation. When you want Excel to do something, VBA is the language you speak to it with. And in order to do that, you need to experiment, create Macros to convey your intentions. Fortunately, even for amateurs with no programming knowledge, this can pose as a bit of a challenge but can be resolved with formulas and other material. The more you know about creating Macros, the more you can achieve.

2: Variables, Conditions, Loops

When it comes to Excel VBA, there are three essential aspects: Variables, Conditions and Loops. Variables are like the SUMTOTAL of VBA, in a sense that it refers to the total space/memory it takes to store a value. Condition on the other hand is like the SUMif of VBA- a way of checking if something fits a certain criteria. Looping on the other hand refers to the instructions that you need to follow at certain points of time.

3: Objects

One important thing to note is that our perception of ‘objects’ is not the same as the computer’s ability to process them. In Excel VBA, you can bridge the gap in communication by remembering that objects are perceived as either methods or properties. Methods apply to what is applied to the object whereas property is what the object has, like value. Some of the most popularly used objects in VBA are Range objects (cell range), ActiveCell object and Selection Object.

4: Resources

Excel VBA Code’s best friend would be programs that help debug any possible bugs (errors that prevent your code from working well) in your code. One recommended resource would be Debug.Print, which assists you in pointing out errors in your code. There are other helpful resources that could become a good reference for you when it comes to Excel VBA, for example, programming books like Excel 2010 Power Programming by John WalkenBach or tutorial videos from Lynda.com, and interesting walkthroughs/discussion tutorials by Chandoo.org.

5: Advice

Excel VBA is immensely useful once you are able to harness the ability to use Macros and the like. You’d be interested in creating more opportunities with VBA code. But one thing to remember is that using VBA Code too often can create complications during your work, so try to use that as sparingly as you can. Excel comes with built in features that are there to help you easily solve most problems so the likelihood of resorting to Excel VBA is low. However, in certain scenarios where you absolutely cannot find the right features or solutions- that’s where this comes in.

Excel VBA can be complicated but once you have gotten the basics down right, you will be able to create Macros with ease. If Excel programming is something you are interested in, perhaps you can brush up on your knowledge by attending Excel classes in Singapore.

5 Foolproof Excel Formatting Tricks To Grab

Save yourself a lot of grief by learning these 5 foolproof Excel formatting tricks! Once you have mastered these 5 essential formatting tricks, you will be able to get so much done in so little time. Here’s what you need to know:

1. Troubleshooting

With conditional formatting, you can highlight any potential mistakes, errors, missing information and repetitions. Lower the amount of mistakes you make and create error free reports/documents with conditional formatting. What you can do is select all the cells you intend to search for errors and locate the menu tab, then select format and choose conditional formatting. Use the formula =iserror() when the dialog box comes up. That would highlight any potential errors you have made. If you’re tracking repetitions however, type in Countif().

2. Alternate rows/Columns

For easy reading, you can use conditional formatting to achieve that. Select the areas in the table that you want to format, then look for conditional formatting through the format tab under the Menu section. Once the dialog box comes out, you can change the format to something like this for highlight: =MOD(ROW(),4)=0. This is just the bare bones of the structure you need to modify your highlight colours. Experiment around with it and see what you can potentially achieve!

3. Graphs

Create In-cell graphs with the REPT() function and also conditional formatting to form a more dynamic chart. Your formula should start with =REPT( “__”, __/100). This is the bare structure of what your formula will look like, experiment with the actual output to see what you can come up with. Once you are able to get this down, you will have created yourself a nice little graph. To add conditional formatting, follow the same steps as above to reach the dialog box. Once you have done so, look for new rules and use a formula to determine cell format. For your format values, you input =($___>AVERAGE($__$_:$__$__)) something akin to this, depending on the nature of your graph. Once you have the format, change your font colour and style however you please.

4. Missing information

Make sure your report is seamless and perfect by not only looking for mistakes but also any possible missing information. This would be especially helpful if you have too much information to sift through. Select the relevant cells, look for your conditional formatting option and select new rule, then select the option: Format only cells that contain, select blanks from the drop down menu. Once done, click okay and it should be formatted accordingly!

5. Range

If you’re looking to single out data that fits in a certain specific range, you can do so as well. Look for your conditional formatting format and select new rule, once done select “Format only cells that contain.” You will then be given two drop down menus. Don’t do anything to the first one, but for the second, select between and key in your values. Once you have done so, set the format and hit okay. You should be able to do exactly what you intended.

These excel formatting tricks are not only flawless in terms of effect, they also save you a lot of time manually customising things. Keep trying and experimenting with different combinations with this as a starting point!

Page 6 of 17« First...45678...Last »