Exercises for dummies – cell format
The cell formatting is a basic knowledge of using MS Excel. It’s not difficult but there are a lot of options and settings. This exercise shows some of the elementary types of formatting. Continue reading “Exercises for dummies – cell format” »
How to create a button for hiding rows or columns
Have you ever seen the plus / minus button that hides or displays rows or columns? How to create it? Let’s see. Continue reading “How to create a button for hiding rows or columns” »
How to exclude hidden rows from SUM
SUM function always calculates with all cells in the range. Sometimes, it’s not desired behavior and we want to exclude hidden cells. Continue reading “How to exclude hidden rows from SUM” »
Tags: SUBTOTAL
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” »
Tags: Scatter
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” »
Tags: COUNTIF
