Calories, carbohydrates, proteins, fats and fiber diary in Excel

This file will help you track what you eat. The file contains 17 food categories, eating diary and statistics. There are also some sample data for better orientation how it works. It’s very easy to use it. You simply choose food from the list and type the quantity. Excel automatically calculates everything else (like number of calories, carbohydrates, proteins, fats and fiber). Continue reading “Calories, carbohydrates, proteins, fats and fiber diary in Excel” »

How to align or rotate chart titles in Excel

Sometimes happens that the chart titles are not good visible. So we have to align or rotate them. Continue reading “How to align or rotate chart titles in Excel” »

Sport tournament template

I created Excel templates for saving sports results. There are many variants of tournament: 3 – 16 teams in each group. The number of groups is not limited. Continue reading “Sport tournament template” »

Free exercises COUNTIF(S) and SUMIF(S) functions

I have prepared two Excel tables with data and many tasks to use COUNTIF(S) and SUMIF(S). Each task contains also the result. Continue reading “Free exercises COUNTIF(S) and SUMIF(S) functions” »

The difference between a line chart and a scatter chart

People often ask: Should I use the line or the scatter? In this article, I try to explain the difference and when to use each chart type. Continue reading “The difference between a line chart and a scatter chart” »

SUMIF and COUNTIF with date

Date can be used as a condition in the Excel functions SUMIF and COUNTIF. But there can be some problems. I show you examples. Continue reading “SUMIF and COUNTIF with date” »

How to resize the table to fit the page

Setting the width of the table to one page is a common problem. You can do it without changing font size or changing the width of each column. As well as the width, can be adjusted the height. Let’s see how. Continue reading “How to resize the table to fit the page” »

How to highlight whole row using Conditional Formatting

Conditional formatting is very useful tool for highlighting cells in MS Excel. But there is the problem with coloring whole row or whole column of table. This example shows how to do that. Continue reading “How to highlight whole row using Conditional Formatting” »

How to print names of columns or rows on every page

Table is sometimes longer than one page. It is very useful to print names of columns or rows on every page. This example shows how to do that. Continue reading “How to print names of columns or rows on every page” »

Excel always changes numbers to dates or currency – solution

Excel changes cell format to date or currency always when you write some value? This problem can have several reasons. Continue reading “Excel always changes numbers to dates or currency – solution” »

Copyright © All Rights Reserved · Green Hope Theme by Sivan & schiy · Proudly powered by WordPress