ChatGPT is a wonderful magical tool that can give you the illusion that you are actually talking to an expert on everything. Let’s see how it will respond to questions about MS Excel. Can the AI solve problems? Can it be creative and develop something new from the simple request?
Continue reading “We asked AI for help” »Imagine that you want to arrange a meeting or birthday party for 40 people in the area where are infected people. What is the chance that one of them will come to your event? This probability can be calculated.
Continue reading “Calculate infection probability in group of people” »
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” »
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” »
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” »
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” »
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” »
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” »
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
