Hello everyone! It's day 5, and next up in my journey is something called Conditional Formatting, specifically formula-based formatting. Today's submission is a short one. Formula-based formatting helps us format or highlight cells based on a formula...
Hello everyone. This is Day 4 of my post on my Excel learning experience. I know I missed posting yesterday, but don't worry; I still went through the module I was to go through yesterday. I couldn't post because of the poor power supply here. Here's...
Today, I went through Lookup and Reference functions with ExcelMaven. I covered the following areas: Named Arrays ROW/ROWS COLUMN/COLUMNS VLOOKUP and HLOOKUP Named Arrays This is exactly as it sounds, an array that is named. Using named arrays helps ...
Today, I learned about statistical functions, and it was fascinating. I went through the following areas: COUNT AVERAGE/MEDIAN/MODE MIN/MAX PERCENTILE STANDARD DEVIATION VARIANCE RANK SMALL/LARGE RAND/RANDBETWEEN SUMPRODUCT COUNTIFS/SUMIFS/AVERAGEIFS...
I've been learning about Advanced Excel formulas and functions. Today, I covered Logical operators in the following areas: IF statement Nested IF statements IFAND and IFOR operators IFNOT function IS statements IF Statement I learned that th...
Hello everyone, I'm Victor Onasanya. I'm new to this community. I'm currently learning data analysis. And I've had an on-and-off relationship with Ms. Excel and PowerBI for years. But lately, I've decided to get serious and commit myself to them. I p...