-
Continue reading →: EXCEL – CREATE A TABLE OF CONTENTSSometimes, having a lot of sheets in Excel can be overwhelming. It’s beneficial to have a table of contents on the first sheet. The picture below shows what we want to achieve. To create a table of contents follow the steps below: This is a good way to navigate a…
-
Continue reading →: EXCEL CREATE A TIMELINEA common task in Excel is to create a timeline to track the progress of a task or project. To achieve this do the following:
-
Continue reading →: EXCEL PROGRESS TRACKERExcel allows users to track tasks and assignments using databars. To implement this, enter tasks in one column and corresponding numbers in the next. Select the numbers, access “Conditional Formatting” under the “Home” tab, choose “Data Bars,” and the progress bars will update automatically as numbers change.
-
Continue reading →: EXCEL – TRACK PROGRESSIn Excel we can check the progress of certain task with checkboxes and percent calculations. Above we have a bunch of tasks, and the tasks have a number of stages. Depending on how many checkboxes that are checked, we can calculate the progress. Steps to follow:
-
Continue reading →: CALCULATE PERCENT DIFFERENCEA common task in Excel is to calculate percent difference. Above we have different kinds of fruits. Their respective sales are shown in two months. In the final column, we have calculated the difference. Follow the below steps: Now we can easily spot the differences above in column D.
-
Continue reading →: CALCULATE DELIVERIESIn Excel a common task is to check progress for ordered and delivered items. Below we have number of ordered and delivered fruits, our goal is to calculate how big percentage is delivered. Follow the below steps:
-
Continue reading →: TRACK PROGRESS WITH CHECKBOXES
One common task in Excel is to track progess, here we are going to use checkboxes for that purpose. Follow this simple steps:
-
Continue reading →: USE CHECKBOXESCheckboxes in Excel are very useful, they are boxes that we can insert into a cell. Then we can check or uncheck them with a simple click. They have two values: Lets make an example:
-
Continue reading →: FIND SMALLEST VALUE IN A GROUPA common task in Excel is to locate the smallest value in a group. We are going to make use of the MINSIFS function in this example. Follow the below steps: Below is the syntax for the MINIF function. =MINIFS(min_range,range1,criteria1) In our example: We are using structured references here, so…
-
Continue reading →: CALCULATING USING STRUCTURED REFERENCESIn the last post we saw the benefits of using structured references. Here we have created two columns of data, as a table. Our goal is to calculate som measures. The formulas is as below: If we add a fruit and amount, the values will recalculate, this is one of…
Hi,
I’m Henrik
Welcome to Excel tutorials made easy. This site is full of easy to follow tutorials
Join the fun!
Stay updated with our latest tutorials and ideas by joining our newsletter.
Excel tutorials 