Functions IF, AND, OR in Excel

flattr this!

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

flattr this!

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

Random date in Excel

flattr this!

Generate random date in Excel is easy. Let’s see how to do that. Continue reading “Random date in Excel” »

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

flattr this!

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

flattr this!

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

flattr this!

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

Exercises for dummies – cell format

flattr this!

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

flattr this!

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

flattr this!

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

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

flattr this!

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

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