Functions IF, AND, OR in Excel

In this example, I show you how to use IF, AND, OR functions together in the Excel worksheet. There is not only the one solution in logical tasks. You can always modify the formula in different ways. Continue reading “Functions IF, AND, OR in Excel” »

How to quickly find duplicate values in Excel

I think the best way to find duplicate records is using Conditional Formatting and Filter. It’s easy, simple and fast. Continue reading “How to quickly find duplicate values in Excel” »

Running total for multiple items solved by Pivot Table and Line Chart

Creating running total is easy and simple if you use a Pivot Table. I show you an example with a few steps, video guide is included. Continue reading “Running total for multiple items solved by Pivot Table and Line Chart” »

How to use DATEDIF in Excel

DATEDIF is very useful for counting the number of whole calendar years, months and days between two dates. It is a hidden worksheet function and you will not find it in the list of functions but you can use it. Continue reading “How to use DATEDIF in Excel” »

How to SUM visible cells and exclude hidden rows and columns

Continue reading “How to SUM visible cells and exclude hidden rows and columns” »

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” »

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” »

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