Author: Umesh Agarwal

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 2020

Greenfield Colony Review 2020

Introduction: Greenfields Colony is situated in Arawali Hills just 3 km from the famous Surajkund in Faridabad, 21 km away from Connaught Place, a ...
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 2020

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 2020

Advance MS-Word Keyboard Shortcuts 2020

Advance MS-Word Keyboard Shortcuts 2020 MS-Word keyboard shortcuts are as important as any other program be it excel or powerpoint. MS-Word needs a ...

Best Web Hosting Provider in 2020

.brz .brz-cp-color1, .brz .brz-bcp-color1{color: #A170D9;}.brz .brz-cp-color2, .brz .brz-bcp-color2{color: #1C1C1C;}.brz .brz-cp-color3, .brz .brz-bcp ...
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 2020

Advance Excel Keyboard Shortcuts 2020

Advance Excel Keyboard Shortcuts 2020 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 2020

Latest Minimum Wages State Wise 2020

Latest Minimum Wages State Wise 2020 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 ...