Jogleen Caliponjworkz.hashnode.dev·Sep 4, 2024Easy Steps to Insert "0" in Excel CellsHave you ever wondered why adding zero in Excel doesn't work? Sometimes you need to perform some rituals for zero to appear in your cell (pun intended!). We will cover some of the easiest ways to do that in this article! To guide you, here's our step...27 reads#microsoftexcel
Mohammad Faizaldatadecode.hashnode.dev·Jul 14, 2024The Infinity Stones of Data AnalysisIn the world of data analysis, the right tools can transform you into a data superhero. Just as Thanos needed the Infinity Stones to wield ultimate power, data analysts need a collection of powerful tools to extract insights and drive decision-making...60 likes·77 readsdata analytics
Ransom Eyoransomeyo.hashnode.dev·Sep 14, 2023Data Analytics: The visualization game where colors serve as a means of communication.""Hello, everyone! I really have passion for storytelling and greatly enjoy having people follow my progress over time. This is the main reason why I've chosen to make this my inaugural blog post here. Above this post's title, you'll find a screenshot...2 likesDevops
olami bosipoolamibosipo1.hashnode.dev·Sep 13, 2023My First Project in data analytics - Sales dashboard using MS excelHi Hashnoders,I'd like to share my experience on my first project in data analytics here.The dashboard was created using Microsoft excel and the dataset (which is one of the historical sales of a supermarket company that was recorded in 3 different b...2 likes·43 readsdataanalytics
Onasanya Victor Oluwatimileyintbright.hashnode.dev·Aug 8, 2023Calculated FieldsHello everyone. I’m back. Apologies for the break. So, over the past few days, I’ve reviewed the "show values as", calculated fields, and calculated items functions in pivot tables. I'll be focusing on Calculated Fields here. The Calculated Fields fu...msexcel
Onasanya Victor Oluwatimileyintbright.hashnode.dev·Jul 7, 2023Statistical 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...dataanalytics
Onasanya Victor Oluwatimileyintbright.hashnode.dev·Jul 5, 2023Logical 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...logical operator
Rashidat Jimohrashidatjay.hashnode.dev·Mar 31, 2023Excel Data Validation: How to Ensure Consistent and Accurate Data Entry.In a standard Excel worksheet, users can input any data they like. Nothing is off-limits from whole numbers to decimals, lists, dates, texts, etc. They only need to double-click on the cell to input the data. However, allowing users to fill in any da...1 like·121 readsexcel
Blessing Ewuolablesscanplay.hashnode.dev·Jul 1, 2022Maven Airlines' Passenger Satisfaction SurveyIt is common knowledge that boarding an airplane can be cumbersome. From booking tickets to checking in, handing over luggage, going through security inspection, finding the boarding gate, and other processes you go through to transport yourself from...142 readsData Science
Tomisintomihashdata.hashnode.dev·Jun 19, 2022Covid-19 Data AnalysisThis week was a proper HUSTLE, and I remember telling our Teams Supervisor at Side Hustle why it was and that I am sure some people in my team have given up on Data Analytics. THE TASK The task is to Work on any Health/Disease Insight Analysis. We ar...1 like·39 readsPowerBI
