SOMEKA BLOG
Combining business know-how into Excel and Google Sheets tips to provide hundreds of interesting articles.
RECENT POSTS
Lead List Tutorial: How to track sales leads in Excel?
Learn how to use Excel for your lead management. A complete guide on how to track sales leads in Excel. Free spreadsheets included.
Can Excel Analyze Data?
Excel is more than calculations or keeping records; learn how can excel analyze data and make analyzing data processes easier.
Can Excel be Used on Mac?
The first version of Excel was installed in Mac devices. Check this guide to learn everything about Excel for Mac, Apple Numbers and more!
Can Excel be Used for Accounting?
Microsoft Excel becomes every accountant’s best friend. Check this guide to learn how accountans use Excel in their daily work!
Can Excel be Used as a Database?
Excel as your main database can come with some disadvantages as well as its advantages. In this blog post these are going to be detailed.
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!
Proforma Invoices: Meaning, Templates & How-to Create One!
In this article you’ll learn what is proforma invoice, common mistakes that companies make, how to create an easy one in Excel!
The Objectives of Inventory Management: Techniques, Challanges and Process in Detail!
Inventory is an essential step of tracking the stock of products. In this article, you’ll learn the objectives of inventory management.
Questions You Should Ask Before Creating Org Chart for your Company!
In this practical guide, you’ll get answers for the most common questions about creating org charts and learn how to structure yours in Excel!