SOMEKA BLOG
Combining business know-how into Excel and Google Sheets tips to provide hundreds of interesting articles.
RECENT POSTS
20 Most-Asked Excel Job Interview Questions for Business Analyst
If you’re a business analyst and looking for questions to test your Excel knowledge, check Excel interview questions, and sample answers!
How to Calculate P Value in Excel?
P-Value might be hard concept to understand. This blog post aims to teach how to calculate P-Value in Excel with examples!
Can Excel Send Emails? Complete Guide to Send Email from Excel
Can Excel send emails? Yes, sure. Here’s a complete guide on how to send emails from Excel. Automatically send an email with VBA code.
Kaizen Methodology: Real Life Examples that Wikipedia Can’t Tell You
This guide will explain Kaizen methodology in detail with real-life examples that Wikipedia can’t tell you. Learn principles, types and more!
How to Calculate Confidence Interval in Excel?
This article describes the formula and explains how to calculate the confidence interval in Microsoft Excel with real-life examples.
Can Excel Map Zip Codes? How to Plot Zip Codes on a Map in Excel?
You’ll learn how to map zip codes from Excel as zip postal codes and make comparisons among geographical regions. Free template included.
How to Calculate Cost of Goods Manufactured?
In this blog post, you’ll learn about how to calculate the cost of goods manufactured in Excel and why it is important for your company with examples!
How to Prevent Data Inconsistency Problems in Excel Workbook?
Excel data inconsistencies can occur from cell to cell. It can seem exactly the same but not always. Check this guide to learn more!
How to Make a Pie Chart in Excel?
Check this guide to learn how to create a pie chart in Excel step by step. It includes definition, types and examples of pie chart!














