Skip to main content

Google Sheets: Notes

"Google Sheets is a web-based application that enables users to create, update and modify spreadsheets and share the data online in real time." — TechTarget

>>> To create a new worksheet, access https://sheets.google.com/new

>>> Calculate number of days, months, or years between two dates

=DATEDIF(start_date; end_date; unit)

DATE DIFFERENCE: Calculates the number of days, months, or years between two dates.
start_date: from date
end_date: to date
unit: DAY, MONTH, YEAR...

>>> Get value from "Price" sheet, 'N2' cell.

var cellValue = SpreadsheetApp.getActiveSpreadsheet().getSheetByName("Price").getRange('N2').getValue();
// Logger.log(cellValue);

>>> GOOGLEFINANCE function: https://spreadsheetpoint.com/googlefinance-function-guide/

>>> IMPORTHTML: Imports data from a table or list within an HTML page.

>>> CANNOT DIRECTLY insert special characters in Google Sheets, but CAN copy & paste special characters.

Popular posts from this blog

Synology: Commonly Used Commands

Commonly used commands via ssh with Synology NAS.

American Accent Training Resources

American Accent Training Book and CDs American Accent Training by Ann Cook Rebecca Linquist https://www.youtube.com/user/rebeccalinquist LISA’S YOUTUBE VIDEOS http://www.accurateenglish.com/lisas-youtube-videos/ Rachel's English Youtube Channel https://www.youtube.com/user/rachelsenglish Accent Ace https://www.youtube.com/user/AccentAceConfidence Practice American English sounds with free video lessons by Cheryl A. Posey http://www.speakingyourbest.com/freevideolessons.html Shaw English Online https://www.youtube.com/user/ShawEducation Pronunciation Pro https://www.youtube.com/user/pronunciationpro Heather Hansen https://www.youtube.com/user/heatherhansen

Microsoft Windows: Commonly Used Shortcuts

Windows shortcuts Shortcuts Description Windows + Up Arrow Maximize active window Windows + Down Arrow Restore active window Windows + Left Arrow Move active window to half left of screen Windows + Right Arrow Move active window to half right of screen Windows + A Open Notifications window Windows + C Open C ortana Windows + E Open Windows E xplorer Windows + F Open Windows' F eedback Hub Windows + I Open Windows Settings Windows + L L ock screenr Windows + M M inimize all active windows Windows + P Send screen to P rojector Windows + R Open R UN dialog Windows + Pause Open System Properties window Windows + SHIFT + S Open S creenClipping tool CTRL + SHIFT + ESC Open Task Manager