Latest Posts

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

Best Web Hosting Provider in 2020

Best Web Hosting Provider in 2020 Choosing the best web hosting provider sometimes get very difficult where there are plenty of web hosting companies ...
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 VBA Code Sub Replace() Dim Setrng As Range Dim i As String 'Talentnett Solutions - visit us a ...
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 ...