To show hidden rows in Excel, you can follow different methods depending on how the rows were hidden (via right-click, filtering, or manually). Here’s a comprehensive breakdown of how to unhide rows, with examples for each scenario.
Continue reading “How to show hidden rows” »Power Pivot is an Excel add-in that supercharges data analysis by enabling you to work with massive datasets, create relationships between different data sources, and perform complex calculations using Data Analysis Expressions (DAX). It essentially brings the power of a relational database directly into Excel. Think of it as a sophisticated engine for data modeling and analysis.
Continue reading “Power Pivot: A Deep Dive” »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” »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” »
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” »
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” »
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” »
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” »
I’m using Array Formulas to find the last filled or the last non empty cell ,it’s the same :). Important: Each formula must be confirmed by Ctrl+Shift+Enter (not just Enter). Continue reading “Value of the last filled cell in a column or in a row” »
Copyright © All Rights Reserved · Green Hope Theme by Sivan & schiy · Proudly powered by WordPress
