SunSystems

The definition provided by Infor for SunSystems is that it represents an integrated financial management system, purchasing, inventory and sales system that is used by more than 9000 clients worldwide. What I can say about it is that SunSystems is a great integrated system for small and middle businesses even for those that have multi-site […]

Read More>>

Excel tutorials

These are a few tutorials that I think everybody needs to be aware of when working with Microsoft Excel. The tips and tricks available here were studied and developed by people in need of a solution to their problems and is not just a collection of information translated from other internet websites. See bellow the […]

Read More>>
The definition provided by Infor for SunSystems is that it represents an integrated financial management system, purchasing, inventory and sales system that is used by more than 9000 clients worldwide. What I can say about it is that SunSystems is a great integrated system for small and middle businesses even for those that have multi-site subsidiaries. It is very easy to setup, flexible enough and has enough resources left to add further developments long after the implementation team has left. It is great at financial and operational reporting and it enables management to take timely swift and precise decision. Information data available in the systems database can be extracted, processed and delivered to management in a very flexible manner. SunSystems There are available on the internet many articles and even a forum for SunSystems enthusiast to share solutins for the most diverse problems and the system itself is evolving constantly to get better and better in satisfying the needs of all users and business industries. Business Inteligence systems like Infor ION can be implemented to unify and integrate financial with operational and public available data in order to deliver an integrated structure of information that is both accurate and ready to be used in decision making.
Gantt chart template excel diagram

Gantt chart template excel diagram

A good managed project needs a visual Gantt chart template to show visually every task that needs to be executed and the relationship between these tasks. Which one can be done at any given time or which task depends on other tasks execution. A Gantt diagram cand be made as a Gantt chart in excel […]
Adding amounts greater than zero

Adding amounts greater than zero

Adding amounts greater than zero or another given value in Excel is sometimes required and can be acquired by using the SUMIF or SUMIFS formulas. The formula for adding amounts greater than a given value =SUMIFS(sum range, sum range, “>0”) You can replace 0 with the value you need. The condition inside the formula can […]
Find and delete duplicates in Excel

Find and delete duplicates in Excel

In order to find and remove duplicates or just highlight them in an complex and messy Excel spreadsheet be prepared to work hard or just smart and elegant. Too many times we end up with an extralarge Excel file that contains some very complex information and a lot of duplicates that we need to find […]
Format cell to show numbers in thousands

Format cell to show numbers in thousands

Sometimes it is useful to round numbers to the nearest 1000 in order to obtain a good looking report. That is, to have many small width columns and get them all on the same page when printing. Formatting cells to show thousands Right click on the cell you want to format Select Format cells…. From […]
How to use Offset in a table

How to use Offset in a table

Need to find a value in a large table and you know only the label of the row and column where the target is located? No problem, Excel can help you do it with only two formulas: Offset and Match. Take a look in the picture bellow. You will find out how to do it. […]
SunSystems Custom VBA Reports

SunSystems Custom VBA Reports

Are you wondering if there is some possibility to extract information from SunSystems database that allow for decisions to be taken without having to ask employees to process the data before presenting it in a standard or custom reporting template? The answer is YES, there is a solution for this and it is called VBA […]

Language