With multiple user friendly Excel functions and features, Microsoft Excel can be used for a variety of different uses, including analysis purposes. There are different types of Excel analysis that one can achieve, here are some of what you can accomplish and how you can achieve them: 1. Scenario Analysis Scenario Analysis is also known […]
Category: Blog
5 Advanced Excel Formulas To Prepare
Excel is a pretty straightforward software to use once you have gained experience and knowledge in it’s interface capabilities. Under usual circumstances, the simple functions and formulas you pick up along the way is sufficient to assist you in daily tasks. However, if you are keen to learn more, you can give these 5 advanced […]
5 Functions Of Excel 2016
Excel 2016 has finally been introduced to the market for corporations and entrepreneurs alike to snatch up. The software comes with the latest upgrades, with a host of different features for the users to try. Here are 5 functions to try in Excel 2016: 1. Autocomplete The autocomplete feature in excel has been improved on […]
Excel Workbook Protection Using Simple Steps
If your line of work requires you to keep track of sensitive data, then you may want to consider applying workbook protection to the relevant excel files you wish to protect. Excel versions like Excel 2010 comes with a built in command ‘Protect workbook’ that enables you to prevent your workbook layout to be changed. […]
MYOB Sales – Other Sales Reports
Aside from the other built-in sales reports in MYOB, another interesting report is the Other Sales Reports, which can be accessed under the Reports tab as per screenshot below: In the Sales tab of the Reports window, go to the drop-down arrow to get to the Other Sales Reports as per screenshot below: Other […]
Switching from Manual Accounting to System or Computerized System
One of the most challenging decision business owners face nowadays is whether to continue using manual process for accounting of business transactions or change into a computerized system. To help business owners make a sound business judgment, one very important factor to consider is if the benefit to have this computerized system outweigh the cost […]
What You Should Know About Excel Vlookup
If you are a user of Excel, you would have heard about the Excel Vlookup function in passing. Not many people are clear on what the function actually does so here are some things you should know about Excel Vlookup. The function is actually used for looking up values that belong in the vertical array […]