Home

5 Types Of Excel Analysis To Achieve

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 […]

Read more

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 […]

Read more

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 […]

Read more

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. […]

Read more

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 […]

Read more

What You Should Know About Excel Vlookup

excel

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 […]

Read more

Open chat