Pivot ChartsHello everyone. It's good to be here again. Today, I learned about pivot charts. Pivot charts operate mostly like normal Excel charts. So, instead of explaining each chart, I'll be posting a screenshot of a dashboard I built using various charts and ...Aug 9, 2023·1 min read
Formula-based FormattingHello 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...Jul 13, 2023·1 min read
Date/Time FunctionsHello 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...Jul 11, 2023·2 min read
Lookup Reference FunctionsToday, 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 ...Jul 7, 2023·1 min read
Statistical FunctionsToday, 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...Jul 7, 2023·3 min read
Logical OperatorsI'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...Jul 5, 2023·3 min read
GreetingsHello 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...Jul 5, 2023·1 min read