The latest articles on DEV Community by Melvin (@melvinkeep). https://dev.to/melvinkeep https://media2.dev.to/dynamic/image/width=90,height=90,fit=cover,gravity=auto,format=auto/https:%2F%2Fdev-to-uploads.s3.amazonaws.com%2Fuploads%2Fuser%2Fprofile_image%2F3952237%2Ff696f977-ca54-40b0-b537-626ed0fbd734.png https://dev.to/melvinkeep en Melvin Sat, 06 Jun 2026 16:24:42 +0000 https://dev.to/melvinkeep/how-excel-is-used-in-real-world-data-analysis-2jcl https://dev.to/melvinkeep/how-excel-is-used-in-real-world-data-analysis-2jcl <p>Microsoft excel is a spreadsheet program used to collect, analyze, store, calculate and visualize data efficiently.</p> <h2> Applications of Excel in real-world data analysis </h2> <ol> <li><p><strong>Making data-driven business decisions</strong>: Companies usually collect data e.g sales numbers, customer behaviour. Excel allows that data to be cleaned and structured using tables,dashboards,filters and formulas. Once the data is organized, excel supports better decisions by making data easy to clean, visualize and interpret.</p></li> <li><p><strong>Financial reporting:</strong> Excel plays a critical role in financial reporting by transforming raw data into meaningful insights that helps businesses, stakeholders understand their perfomance and make data-driven decisions. It helps build financial models, create charts and dashboards used for reporting.</p></li> <li> <p><strong>Marketing perfomance:</strong> Excel is used in marketing perfomance to measure results from campaigns like ads, email marketing and monitor engagement rates on social media platforms e.g facebook, instagram. Thus it's used to create charts, and create comparison on perfomance across different campaigns.</p> <h2> Formulas and features of Excel i've learned so far: </h2> <p>Example: A(product) B(region) C(sales)</p> </li> </ol> <ul> <li>SUMIF() function - it is used to add up values that meet specific condition. Example, if you do want to get the total sales of oranges only. </li> </ul> <div class="highlight js-code-highlight"> <pre class="highlight plaintext"><code>=SUMIF(C2:C6,A2:A6,"Orange") </code></pre> </div> <ul> <li>COUNTIFS() function - it is used to count how many rows meet multiple conditions at the same time. Example, How many times did apple sell in Nairobi? </li> </ul> <div class="highlight js-code-highlight"> <pre class="highlight plaintext"><code>=COUNTIFS(A2:A7,"apple",B2:B7,"Nairobi") </code></pre> </div> <ul> <li>Data validation - it is a feature in excel that controls what type of data can be enterd into a cell. It enables users enter only valid and accurate data. Example, if you only want to enter gender as only male and female.</li> </ul> <h2> Conclusion </h2> <p>In conclusion, learning excel has changed the way I view data because it has shifted my thinking from seeing raw and messy data to seeing cleaned, transformed data that's used in data-driven decion making.</p> beginners learning datascience