Author: Umesh Agarwal

How to Convert Google Sheets Data to JSON Data API

How to Convert Google Sheets Data to JSON Data API

This article explains how to convert Google Sheets Data to JSON Data API. You can convert Google Sheets data as a JSON API and use it as another fron ...
Free Powerpoint Templates 2021

Free Powerpoint Templates 2021

Free Powerpoint Templates 2021 Free Powerpoint Templates 2021 Read More: How to delete rows in google sheets using a scriptHow ...
How to delete rows in google sheets using a script

How to delete rows in google sheets using a script

This article provides a solution to delete multiple rows in Google Spreadsheet if cell values match to certain string or value using a Google Scrip ...
How to send HTML table in the email body using google app script

How to send HTML table in the email body using google app script

This article contains a Google App Script code to send auto email alerts for employees' leave transactions. Let's learn how to send an HTML table in ...
How to Rename PDF Files with their Contents using python

How to Rename PDF Files with their Contents using python

This solution contains the python code for how to rename PDF files with their contents using python and tkinter gui. If you are looking for a rea ...
Free PDF Tool to Split Multi-Page PDF File into One

Free PDF Tool to Split Multi-Page PDF File into One

This is a Free PDF Tool to Split Multi-Page PDF File into One using the python tkinter GUI library. What does it do? Split Multi-Page ...
How to change font family in multiple word files VBA

How to change font family in multiple word files VBA

This VBA enables you to select a folder and change a font family name in all the word documents which are there in the folder. Let's see the below VB ...
How to repeat a cell value to n times in google sheets

How to repeat a cell value to n times in google sheets

Assuming you have data in Column A, a list of products and you want to repeat them in the next column or in another sheet to n times. Let's assume yo ...
How to fill down blank rows using Arrayformula in Google Sheets

How to fill down blank rows using Arrayformula in Google Sheets

Assuming you have data in Column A, a list of products but it has some blank rows in between and you want to fill them down with product name itself. ...
Greenfield Colony Review 2021

Greenfield Colony Review 2021

Greenfields is spread over 434 acres of land having 3713 plots, approx.1200 plots already constructed having 3600 dwelling units with more than 10,00 ...
How to get sheets name and rename them using Google Script

How to get sheets name and rename them using Google Script

Renaming all sheets in Google Sheets is a tedious task. If you do it manually, it'll kill your valuable time. Let's see How to get sheets name and re ...
How to use REGEX formulas in Google Sheets

How to use REGEX formulas in Google Sheets

REGEX formula is a great function created for Google Sheets. You will not find this function in MS EXCEL, you have to write a VBA script to apply reg ...
How to Insert serial numbers automatically in excel using VBA

How to Insert serial numbers automatically in excel using VBA

How to Insert serial numbers automatically in excel using VBA Indexing or Sequencing is a crucial part when you work with Excel. You often apply m ...
How to Remove Unwanted Text From Multiple Columns In Google Spreadsheet

How to Remove Unwanted Text From Multiple Columns In Google Spreadsheet

How to Remove Unwanted Text From Multiple Columns In Google Spreadsheet Removing unwanted text from multiple datasets is a tedious task, but Googl ...
How to unmerge specific cells in Excel using VBA

How to unmerge specific cells in Excel using VBA

How to unmerge specific cells in Excel using VBA Sometimes you just want to unmerge cells which contain some specific value but you want to do it ...
How to create multiple files using sheets in Excel VBA

How to create multiple files using sheets in Excel VBA

How to create multiple files using sheets in Excel VBA How many times you come across a situation where you want to create multiple files usi ...
How to extract text from a bracket cell in excel

How to extract text from a bracket cell in excel

How to extract text from a bracket cell in excel Assuming you have some data in column A in an excel sheet and every cell contains lengthy&nb ...

Free Increment Letter Templates 2021

Free Increment Letter Templates 2020 Normal Increment Letter  <<Date>> <<Employee Name>> <<Employee Code>> < ...
Free Template for Contractor Agreement or Professional Services Agreement

Free Template for Contractor Agreement or Professional Services Agreement

Free Template for Contractor Agreement or Professional Services Agreement PROFESSIONAL SERVICES AGREEMENT This Professional Services Agreement ( here ...
How to convert multiple text values to a date format using a single formula

How to convert multiple text values to a date format using a single formula

How to convert multiple text values to a date format using a single formula Assuming there is an uncleaned Date format in Column A, some of t ...
How to clean up scraped data in Excel without VBA

How to clean up scraped data in Excel without VBA

How to clean up scraped data in Excel without VBA Before you use your data for reports, analytics or presentation, first you need to clean it as y ...
How to send email notifications on Google Spreadsheets if any cell value changes

How to send email notifications on Google Spreadsheets if any cell value changes

How to send email notifications on Google Spreadsheets if any cell value changes Working on Google Spreadsheets is fun, you can do a lot with Goog ...
Advance MS-Word Keyboard Shortcuts 2021

Advance MS-Word Keyboard Shortcuts 2021

Advance MS-Word Keyboard Shortcuts 2021 MS-Word keyboard shortcuts are as important as any other program be it excel or powerpoint. MS-Word needs a ...
How to Convert All Cell Values (Text) to UPPER Case VBA

How to Convert All Cell Values (Text) to UPPER Case VBA

How to Convert All Cell Values (Text) to UPPER Case VBA When you want to convert a cell or text value in excel, you apply "Upper" formula in excel ...
How To Transpose / Convert Multiple Rows Into Single Row without VBA and Array Formula

How To Transpose / Convert Multiple Rows Into Single Row without VBA and Array Formula

How To Transpose / Convert Multiple Rows Into Single Row without VBA and Array Formula If you are looking for a solution to Transpose / Convert Multi ...
How to replace other cell values in excel using VBA

How to replace other cell values in excel using VBA

How to replace other cell values in excel using VBA This VBA enables you to replace cell values other than the specific ones. Refer below code for ...
Advance Excel Keyboard Shortcuts 2021

Advance Excel Keyboard Shortcuts 2021

Advance Excel Keyboard Shortcuts 2021 Excel shortcuts are basic need if you need to work faster in excel. There are hundreds of shortcut keys you ca ...
How to apply VLOOKUP without entering a column number

How to apply VLOOKUP without entering a column number

How to apply VLOOKUP without entering a column number Are you still using VLOOKUP in the same old fashion and wonder how to apply VLOOKUP ...
Latest Minimum Wages State Wise 2021

Latest Minimum Wages State Wise 2021

Latest Minimum Wages State Wise 2021 Looking for a Minimum Wages Notification here is the solution. Refer to the below table and download your Mini ...
How to do the reverse salary calculation for CTC or Net Pay

How to do the reverse salary calculation for CTC or Net Pay

How to do the reverse salary calculation for CTC or Net Pay Whether you belong to Talent Acquisition, Finance, HR, Temp Staffing or an Individ ...
Open chat
Talentnett Solutions
Hello,

How may I help you today!

Regards,
Umesh Agarwal
Contact - +91 - 7017544508
Email - umesh.agarwal@talentnett.com

Cool Tips and Tricks Directly Delivered in your Inbox. Subscribe to our Newsletter.

You have successfully subscribed to the newsletter

There was an error while trying to send your request. Please try again.

Talentnett will use the information you provide on this form to be in touch with you and to provide updates and marketing.