Alternate row color Excel
Large tables in Excel look much more better and are easier to read when we choose to alternate row color. Each other row gets a background color, so it’s easier to read the values in the extreme right in association with the labels at the extreme left of the table. 3 ways of alternating rows […]
Gantt chart template excel diagram Download
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 […]
Insert login form with password in excel Download
Even though Microsoft Excel doesn’t qualify as a high security data protection system, sometimes users of an workbook file must be sorted out and have different information access rights. The solution for this is to implement a login form in excel, like this one: How to insert login form with password in excel The first […]
Automatic sorting using workbook formulas
Optimizing the conclusions presented by an Excel worksheet data processing algorithm usually needs a solution for information sorting in order for it to be displayed top-down by importance factor to the subject. Additional formulas needed You need to insert the formulas to calculate automatically the position of each item in the list based on it’s […]