The latest articles on DEV Community by Naomi Ruigu (@naomi_ruigu_063af8eda6cce). https://dev.to/naomi_ruigu_063af8eda6cce 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%2F3952228%2Ff12e9695-a5ec-433b-9c50-22efc90f15f3.jpg https://dev.to/naomi_ruigu_063af8eda6cce en Naomi Ruigu Sun, 07 Jun 2026 07:55:08 +0000 https://dev.to/naomi_ruigu_063af8eda6cce/how-excel-is-used-in-real-world-data-analysis-3l8g https://dev.to/naomi_ruigu_063af8eda6cce/how-excel-is-used-in-real-world-data-analysis-3l8g <h3> Excel </h3> <p>Excel is a spreadsheet software that is used to organize, analyze, collect and calculate data in both data science and analytics.</p> <h3> How Excel is used in Business decisions, reports and marketing performance </h3> <ul> <li>Excel is used to make and perform calculations and data cleaning in organizations</li> <li>Excel helps organizations to organize data in rows and columns and helps to track records on how the organisation is performing.</li> <li>Provides an entry point for managing operations and data without requiring a lot of programming knowledge.</li> </ul> <h3> Features &amp; Formulas used in Excel </h3> <ul> <li><p><em>Sorting and Filtering</em>- Organize and find data quickly</p></li> <li><p><em>Conditional Formatting</em>- Highlight cells based on rules</p></li> <li><p><em>Freeze panes</em>- Keep headers visible while scrolling.</p></li> <li><p><em>Sum(A1:A5)</em> Adds values</p></li> <li><p><em>Average(A1:A5)</em> Calculate average</p></li> <li><p><em>Count(A1:A5)</em> Counts numeric cells</p></li> <li><p><em>SumIF(A1:A5,"&gt;100")</em> Adds values meeting a condition</p></li> <li><p><em>Counta(A1:A5)</em> Counts non-empty cell</p></li> </ul> <h3> Data perspective </h3> <p>As a beginner in data science and analysis, learning Excel changes how you think, interpret and visualize data by seeing different patterns and trends, which helps in management and operation to make informed decisions based on the accuracy of the data.</p> beginners discuss datascience ai