Excel Archives - Digital Ready Marketing We Help The Small Guys To Win Big Tue, 26 May 2020 19:28:54 +0000 en-US hourly 1 https://wordpress.org/?v=6.7.2 How To Transfer Data Into Non Consecutive Empty Cells In Excel? https://digitalreadymarketing.com/transfer-data-non-consecutive-empty-cells-excel/ https://digitalreadymarketing.com/transfer-data-non-consecutive-empty-cells-excel/#respond Thu, 07 Jul 2016 21:37:03 +0000 https://digitalreadymarketing.com/?p=4174 You probably wondering how is this relevant to building niche websites. Trust me it does. When it comes to SEO, the ability to manipulate Excel spread sheet is one of the required skills. In this video, I am going to show you how to transfer data into empty cells in Excel. The need for this […]

The post How To Transfer Data Into Non Consecutive Empty Cells In Excel? appeared first on Digital Ready Marketing.

]]> https://digitalreadymarketing.com/transfer-data-non-consecutive-empty-cells-excel/feed/ 0 How To Return Different Output Depending On The Input In Excel? https://digitalreadymarketing.com/return-output-depending-input-excel/ https://digitalreadymarketing.com/return-output-depending-input-excel/#respond Thu, 28 Jan 2016 08:00:30 +0000 https://digitalreadymarketing.com/?p=3928 Ever since I became a SEO consultant, I am forced to have Excel as my best friend. I had been using Excel since I was in college but never realized how many different functions Excel had. So, in order for us to run a successful online business, Excel is a must. This is why once in […]

The post How To Return Different Output Depending On The Input In Excel? appeared first on Digital Ready Marketing.

]]> https://digitalreadymarketing.com/return-output-depending-input-excel/feed/ 0 How To Test If The Target Keyword Is Included In A Given Content In Excel? https://digitalreadymarketing.com/test-target-keyword-included-content-excel/ https://digitalreadymarketing.com/test-target-keyword-included-content-excel/#respond Sat, 12 Dec 2015 01:30:26 +0000 https://digitalreadymarketing.com/?p=3865 Use this formula in Excel to find if the target keyword is included in a given content. This is particularly useful when auditing the Title tag, H1 and H2 elements. Copy and paste the following formula in column C =SUMPRODUCT(COUNTIF(A2,"*"&$B$2:$B$11&"*"))>0 Video description for this formula Video: how to bulk check H1 and H2 – real SEO […]

The post How To Test If The Target Keyword Is Included In A Given Content In Excel? appeared first on Digital Ready Marketing.

]]> https://digitalreadymarketing.com/test-target-keyword-included-content-excel/feed/ 0 How To Fill Empty Cells With Value Above In Excel https://digitalreadymarketing.com/how-to-fill-empty-cells-value-above-in-excel/ https://digitalreadymarketing.com/how-to-fill-empty-cells-value-above-in-excel/#respond Sat, 09 May 2015 11:37:22 +0000 http://digitalreadymarketing.com/?p=3246 If you have to deal with various software that lets you export excel file a lot, you have probably come across to a situation where you can’t manipulate the data within the file because some cells have been merged together. The solution to this is to unmerge the cells then fill the empty cells with […]

The post How To Fill Empty Cells With Value Above In Excel appeared first on Digital Ready Marketing.

]]> https://digitalreadymarketing.com/how-to-fill-empty-cells-value-above-in-excel/feed/ 0 How To Open Chinese Or Japanese Encoding GWMT CSV Files? https://digitalreadymarketing.com/open-chinese-japanese-encoding-gwmt-csv-file/ https://digitalreadymarketing.com/open-chinese-japanese-encoding-gwmt-csv-file/#respond Thu, 06 Nov 2014 12:00:00 +0000 http://digitalreadymarketing.com/?p=2104 If your site has international presence, most likely you have encountered some funny characters when opened the Google Webmaster Tools (GWMT) export file for Search Queries. The first time I encountered this problem, I actually re-downloaded the file 3-4 times to make sure the file was not corrupted (silly me huh). Let me show you […]

The post How To Open Chinese Or Japanese Encoding GWMT CSV Files? appeared first on Digital Ready Marketing.

]]> https://digitalreadymarketing.com/open-chinese-japanese-encoding-gwmt-csv-file/feed/ 0