I wanted to link a couple of things I’ve been learning and doing and highlight them in videos. In some demonstrations seeing is better than listing Vid 1. Screen Capture & Optical Character Recognition (OCR) In this video I wanted to show how to use screen capture process to get code from YouTube and other
I need to get my head around this to see if it can supplement the sheet filtering info I was exploring in the last post. Formatting Macro tutorial I will be following the tutorial in the video below, it is one of the videos from the Learn Google Spreadsheets that I think is an exceptional
I wrote a post on using Excel filterable Heatmaps for Asset Condition over time online. This was an excel file on my OneDrive that I then embedded in a web page. I had filtered the columns so that you could filter columns to do forecasting for building items that would need work to be done
YouTube screen capture convert text I watch tutorial videos to learn how to do certain things in coding. Sometimes, in the video, they leave a copy of the code so that you can download it, other times this is not the case. So you have to write the code out longhand for yourself, which can
There seems to be a few plugins that will take your article in Google docs and post on a WordPress site. The first one I came across was an addon in Google Docs called WordPress.com for Google Docs. This requires you to have the Jetpack plugin on your WordPress site. I’m not keen on that
I was excited about this feature. Being able to upload files in a form. This could really help the automation process for the services I’m offering. Summary On setting up the form I found out that people are only allowed to upload files if they have a gmail account and are logged in. Also there
Further to my previous post Google Sheets “GOOGLEFINANCE()” for free Stock data that started with referencing 5 things that Excel couldn’t do but Google Sheets can, I wanted to explore a few of the features mentioned in that video. It mentioned the following Google Sheet Functions: ImportFEED(), Import HTML() &ImportXML() 1. ImportFeed() Well, I followed
After the success of my previous automated quoting service Creating free embedded automated quote for service with Google Docs I found a couple of things that I wanted to try to extend this process. The first is multi sections in forms and the second is, instead of using the Google Sheets Document Studio Addon I
I came across this YouTube video that I thought was quite enlightening “5 Things You Can do in Sheets That You Can’t Do in Excel”: I was rather intrigued by it and decided to look into some of the functions more deeply. So far I have only played with the GOOGLEFINANCE() function and SPARKLINE() My
After writing a post on following a tutorial for automated invoice for a cake shop order, Free Google Docs online ordering automated I decided that, after migrating my Services to my Blog Site I’d try setting up an Automated Quote process for one of the services I offer, namely a Browser viewer for Panoramas linked
