Articles about Using Excel for Data Analysis Purposes

Articles About Data Analysis and Statistics with Excel

Nowadays, 90% of job postings about Data Analysis require excellent spreadsheet skills. So this generally results that the primary tool of many data analyst is Microsoft Excel. In fact, it’s truly amazing how much science you can do with it!

Explore this category to learn a lot of tips, real-life examples, mathematical solutions, data visualization methods, dashboards and graphs in Excel!

What is a Pareto Distribution? Here is an Eye-Opening Guide to Pareto Charts!

Everone knows that a few but important problems have the most impact overall. Check this guide to learn about Pareto charts and 80/20 Rule!

UML Diagram Types Guide: Learn More about Tools, Examples!

This article guides you to form UML diagrams using Excel and shows different types of UML diagrams and why they are crucial for visualizing systems.

KWL Charts: Teaching Strategy that Work for your Students!

KWL is an educational strategy which stands for: Know, Want to Know and Learned. Get comprehensive information about KWL charts, their benefits, usage and the right tools.

A Real Time Stock Quotes in Excel using Python

Using Python you will stream real-time data directly into Excel Stock Price Calculator! Real-time Portfolio View in Ready-to-use Excel Template!

Fortune-Returns-to-Scale-Featured Image tinypng

Ranking factors of Fortune 500: Companies returns to scale

Fortune 500 spreadsheets are great for sorting out those companies returns to scale that are worth investing in, after further investigation.

Mexico-Heatmap-Infographic-Post-SSCover-tin

Mexico Heat Map Infographic in a Few Simple Steps!

Heat Maps are increasingly popular to visualize large volumes of data. We've demonstrated how we used our Excel Template to create an infographic for Mexico

Fortune 500 Revenues World Heat Map - Someka Excel Solutions

Fortune Global 500 Map with Data Visualization

Data analysis of Fortune Global 500 by country. 2017 revenues and profits data has been visualized with Someka Heat Map Generator Excel Templates.

Excel Formulas Training Video Series

Free Excel Formulas Training video course with more than 100 real life examples. A special exercise workbook is also provided for hands-on training.

Google Sheets vs. Excel - Comparison Table - Someka Blog

Google Sheets vs. Microsoft Excel: Which is the best in 2024?

Google Sheets vs Excel? Which one is better: Microsoft Excel or Google Sheets? What are the pros, cons & main differences!