Include a dynamic variable text box in a chart or graph
Trying to make charts more expressive is anyone’s objective so that he/she doesn’t have to modify the chart every time a piece of data changes in the source of the graph. Do this by adding variable text boxes inside the chart template. As you can see in the picture, there is an average calculated and […]
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 […]
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
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
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
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. […]
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 […]