4 articles Presentation design

Alternate row color Excel

alternate-row-colors-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…

 

Automatic sorting using workbook formulas

Automatic Sorting using Excel 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…