Skip to content
logo
Digital Marketing Chef
Latest from the digital kitchen
  • Home
  • SEO
    • Free SEO tools
      • SEO ROI Calculator
    • Creating a great SEO content plan: Step by step guide
    • What is TFIDF and why it’s important for SEO
    • Getting started with Mobile SEO
    • What is DOM (Document Object Model) and why should I care?
    • Top 5 SEO Mistakes in 2019
  • PPC
    • scripts
      • What are AdWords Scripts and how to use top AdWords Scripts for free
      • Building Top Google Ads Scripts from Scratch
      • AdWords Script for tracking Quality Scores of SEM Keywords
    • Problems with targeting “in-market” audiences.
    • How to Manage your Search ads on Google without Average Position
  • Blog
    • JavaScript
      • Getting a hang of Object Oriented Programming in JavaScript
      • Building an EMI Calculator using JavaScript : 3 different methods
      • Using JavaScript to pass attributes to HTML tags
  • Experiments
    • Simple Mutual Fund SIP Calculator
    • Ready to use home loan EMI calculator
  • Analytics
    • Google Sheets
      • Web Scraping without coding – easiest way to build your own Web Scraper
      • Complete Guide to IMPORTFEED Function in Google Sheets with Examples
      • How to use importhtml function in Google Sheets
      • The correct way of using ARRAYFORMULA in Google Sheets
      • IMPORTRANGE in Google Sheets
    • Python
      • Web Scraping in Python using BeautifulSoup [Tutorial with Code]
      • Python Selenium Tutorial (with Code examples)
      • Using split method to generate sub-strings from strings in Python [with Examples]
      • Python Strings: Replace sub-strings within strings
      • Replace Regex in Python String
      • Python trim strings with strip method [with Examples]
      • Simple Introduction to Pandas DataFrames with Examples
      • How to read data from Excel or CSV to Pandas in Python
      • How to export data from Pandas to Excel or CSV
      • How to drop columns and rows in Pandas DataFrames

Tag: google sheet functions

IMPORTRANGE in Google Sheets

November 4, 2019 admin 8 Comments

The IMPORTRANGE function in Google Sheets allows you to import data between multiple spreadsheets. To understand the formula of the…

Continue Reading →

Posted in: Analytics, Google Sheets Filed under: google sheet functions, google sheets

The correct way of using ARRAYFORMULA in Google Sheets

October 20, 2019 admin 5 Comments

Of all the unique formulas available in Google Sheets (unique with respect to good old MS Excel), I find ARRAYFORMULA…

Continue Reading →

Posted in: Analytics, Google Sheets Filed under: google sheet functions, google sheets

How to use importhtml function in Google Sheets

September 22, 2019 admin 3 Comments

Importhtml is a function in Google Sheets that allows you to import tables and lists from any URL to Google…

Continue Reading →

Posted in: Analytics, Google Sheets Filed under: google sheet functions, google sheets, html tags, web scraping

Complete Guide to IMPORTFEED Function in Google Sheets with Examples

August 28, 2019 admin 7 Comments

IMPORTFEED is a powerful but less known function in Google Sheets. IMPORTFEED allows you to easily import RSS or ATOM…

Continue Reading →

Posted in: Analytics, Google Sheets Filed under: google sheet functions

IMPORTXML in Google Sheets – easiest way to build your own Web Scraper

admin 9 Comments

How to use IMPORXML to scrape web content to Google Sheets? IMPORTXML function in Google Sheets is an easy and…

Continue Reading →

Posted in: Analytics, Google Sheets Filed under: google sheet functions, html tags, web scraping

Recent Posts

  • IMPORTRANGE in Google Sheets
  • Python trim strings with strip method [with Examples]
  • The correct way of using ARRAYFORMULA in Google Sheets

Recent Comments

  • Marc on IMPORTXML in Google Sheets – easiest way to build your own Web Scraper
  • joxvoisee on Python Selenium Tutorial (with Code examples)
  • joxvoisee on Python Selenium Tutorial (with Code examples)

Archives

  • November 2019
  • October 2019
  • September 2019
  • August 2019
  • July 2019

Follow Us

Contact Us

  • Email
    anirbansengupta31@gmail.com
Copyright © 2019 Digital Marketing Chef