Do not hate excel or google sheets

Submitted by ravisagar on Sat, 07/17/2021 - 07:33

Linux lovers - Will you not work for/with a company using proprietary softwares? Honestly I never use #LibreOffice to create excel files for others to consume.

#MicrosoftExcel #LibreOffice

Excel VBA to Jira? #YourComments

Submitted by ravisagar on Sat, 02/06/2021 - 13:22

Do you want to use Excel along with Jira but wondering how to connect them together?

#YourComments #ExcelVBA #RESTAPI

Learn Jira REST API, here is my free course.

Excel VBA macro to convert the case of the first letter in a sentence

Submitted by ravisagar on Mon, 11/13/2017 - 17:22

Let us say you have a some sentences in your excel sheet in one or two cells. Now if you are very particular about punctuation like me then you may want to change the case of all the words starting in a sentence. Let us say you have some sentences like below in various cells.

Excel Tip - How to extract first 20 characters from the string

Submitted by ravisagar on Mon, 11/29/2010 - 06:28

Today I was working on excel (yeah yeah I do work sometimes), I wanted to extract the first 20 characters from the string. I forgot the function name, I did a quick google search and found out the solutions.

Ravi Sagar Newsletter

Honestly I hardly send out mails but I guess there is no harm in at least having a newsletter. I will only send newsletter when I have something important to share or an update. People are busy and no one has time to read emails these days. If you really like my content then I guess you will remember my site and come back for more.

Want to contact me?