01.10.16

Freezing Rows and Columns in a Google Spreadsheet

Freezing Rows and Columns in a Google Spreadsheet




How to freeze multiple rows and / or columns

How to freeze multiple rows and / or columns (Excel tips #6)



excel university





Google Sheets Make Headers in Rows or Freeze Rows and Columns




Google Sheets: Modifying Columns, Rows, and Cells





Creating an app (Database) that works with Google Sheets!




How to use Data Validation to create a drop down list in a Google spreadsheet





DYNAMIC DEPENDENT DROP DOWN LISTS IN GOOGLE SPREADSHEETS + Tools - Script Editor



Creating an app (Database) that works with Google Sheets!



F&Q AND ADVANCED OPTIONS FOR DYNAMIC DROP DOWN LISTS IN GOOGLE SPREADSHEETS



HOW TO CREATE HORIZONTAL OR "ROW" DEPENDENT DROP DOWN LISTS IN GOOGLE SPREADSHEETS

Google Sheets: Creating Simple Formulas




Google Sheets: Creating Complex Formulas





How to Extract Data from a Spreadsheet using VLOOKUP, MATCH and INDEX



How to extract data from website to excel


Automated data scraping from websites into Excel



How to extract data from multiple tables in a web page



How to Scrape Google Search Results Quickly, Easily and for Free





The Ultimate Introduction to Web Scraping and Browser Automation


Whenever you need to import data from an external website, hopefully they provide an API and make your life easy. But in the real world, that's not always the case. There are numerous reasons why you might want to get data from a web page or multiple web pages, and there's no API in sight, and in that case you're going to need to fall back onto Web Scraping and Browser Automation.

In this screencast I'm going to give a high level overview of how to scrape websites, then cover five different scenarios, in increasing difficulty, for practical web scraping. There is a massive amount of information in this screencast and I'm going to straight up bombard you with it, but if you can make it until the end I guarantee you will come out knowing how to scrape websites with the best of them.

As always, you can hit me up on twitter @AlwaysBCoding with questions, comments, to argue about programming, or to drop a suggestion for which topics I should cover next.

Jordan Leigh





Automatically Download Stock Price data from Yahoo Finance


Published on 30 Oct 2014
A walkthrough on how to write a VBA Macro in Excel to automatically download historical prices for any stock in any date range.

**UPDATE** 9/10/16 it seems that Yahoo has reversed their URL for getting the data. The End Date and the Beginning Date have reversed. So if you just swap the locations on the Excel sheet for the dates then it should work fine.
TimeValue Videos
https://sites.google.com/site/timevaluevideos/






























Zamknutí řádků a sloupců ukotvením příček







Žádné komentáře: