SOMEKA BLOG
Combining business know-how into Excel and Google Sheets tips to provide hundreds of interesting articles.
RECENT POSTS
Formula Parse Errors in Google Sheets
Even experienced users can run into issues with formula parse errors in Google Sheets. They occur when Google Sheets is…
How to Use INDEX MATCH in Google Sheets
Find out what INDEX MATCH Google Sheets formula is, how you can use it, and its benefits with detailed steps and comprehensive examples.
How to Subtract in Google Sheets
Google Sheets is a popular spreadsheet software that allows you to perform various mathematical operations, including subtraction. Whether you need…
How to Convert Excel to Google Sheets?
Find out how to convert Excel to Google Sheets and save Google Sheets as Excel files in a simple way with different methods.
How to freeze a row in Google Sheets?
Freezing rows in Google Sheets makes the selected rows visible and pinned even when you scroll down the page. Similarly,…
How to add a drop down list in Google Sheets?
Learn how to create a Google Sheets drop down list with our step-by-step article including editing, expanding, and removing a drop down list.
How to sort in Google Sheets?
If you have big data and want to learn how to sort in Google Sheets, read our step-by-step guide and find out different methods to sort data.
How to Calculate Interest Rate on a Loan?
How to calculate interest rate on a loan? Compound and simple interest rate formulas with examples. Free templates included.
How to lock cells in Google Sheets?
One of the most known features of Google Sheets is to allow multiple users to access a file at the…