Desain Google Docs

 

https://www.youtube.com/watch?v=0Vq9Jn54xhU

https://www.youtube.com/watch?v=6Tkfj7e8GSo

https://www.youtube.com/watch?v=0Vq9Jn54xhU

https://www.youtube.com/watch?v=p3cwWJkVe9M

https://www.youtube.com/watch?v=kIexyA4pvdY

https://www.youtube.com/watch?v=ibOjI0AGq-0

Google Form Chat GPT

 

https://www.youtube.com/watch?v=0LcyNR92qh8

https://www.youtube.com/watch?v=skgSzv-HYx8

Membuat Laporan Google Form

 

https://www.youtube.com/watch?v=O1spbvxLk7A

https://www.youtube.com/watch?v=jdvIzD8XMtE

Big Query 1

 

https://youtu.be/druV763aTVQ?si=0wckMp7x7nD6qIIn

https://www.youtube.com/watch?v=J9uXzLvlLVs&list=PLf5W0uMSV-Cwi1e8IyL91SFXuy-byiEjy&index=2

Google My Business

 

https://www.youtube.com/watch?v=pZhF3EDGQrw

https://www.youtube.com/watch?v=-hJveJKkFys

Force Copy Google Site

 

https://www.youtube.com/watch?v=Szk-S8W4sP4&t=213s

https://www.chrmbook.com/most-people-dont-know-about-these-advanced-google-site-features/

https://www.chrmbook.com/use-google-sites-for-your-next-class-project/

Awesome Google Site designs

 

https://sites.google.com/sowashventures.com/sites-inspiration-gallery/home?authuser=1

https://sites.google.com/a/tarriers.org/portal/

https://sites.google.com/a/tarriers.org/mslibrary/

https://www.youtube.com/watch?v=JcPW8Nr84E8

https://sites.google.com/sowashventures.com/sites-inspiration-gallery/home?authuser=1

https://www.chrmbook.com/use-google-sites-for-your-next-class-project/

https://www.chrmbook.com/most-people-dont-know-about-these-advanced-google-site-features/

https://www.chrmbook.com/

Tutorial HTML CSS dan Google Site

 

https://www.youtube.com/watch?v=K-V5-jrF_z4&list=PL8yMVD20RKOnAsh9Mv9M2X7oDr2OLUV6U&index=1

https://www.youtube.com/watch?v=1_dNd6DTOlI

https://www.youtube.com/watch?v=DGWthaZTGRo

https://www.youtube.com/watch?v=1Ny-1zHw5AI&t=815s

https://www.youtube.com/watch?v=j-7A5Twkqtw

https://www.youtube.com/watch?v=3YF56nwvsNA&list=PLtrswHp2WnjnPzTB_rR5TDurCtKU2ReqI&index=8

https://www.youtube.com/watch?v=V0DXysQ_WzU&list=PLtrswHp2WnjnPzTB_rR5TDurCtKU2ReqI&index=25

https://www.youtube.com/watch?v=4WKFLE1Bx1M&list=PLwXXOxvDboeZ5C9XI0gU_Wed3yzlfYf0m

https://sites.google.com/sowashventures.com/sites-inspiration-gallery/home?authuser=1

Data Studio - How To Create Dashboar

 

https://www.youtube.com/watch?v=vnqOiQHjAQo&t=887

https://lookerstudio.google.com/reporting/4c84ebdc-826c-44cf-93b2-d2b602d570e6/page/SPudD/edit

https://docs.google.com/spreadsheets/d/1FowQGcKZIEu1_al19LfIBSZKzwPPORjEhCqO0zK9PpA/edit#gid=881803919

https://www.youtube.com/watch?v=AaiPFcBDgtk&t=17s

Data Studio - Report Gallery

 

https://lookerstudio.google.com/gallery?category=visualization

https://lookerstudio.google.com/reporting/76e574a8-e095-49da-8387-989c53022b4b/page/NgJUB

Report Gallery

https://lookerstudio.google.com/gallery?category=visualization
https://lookerstudio.google.com/visualization
https://lookerstudio.google.com/reporting/76e574a8-e095-49da-8387-989c53022b4b/page/NgJUB
https://lookerstudio.google.com/reporting/76e574a8-e095-49da-8387-989c53022b4b/page/mdJUB
https://lookerstudio.google.com/reporting/76e574a8-e095-49da-8387-989c53022b4b/page/sXprB

Google Studio - Community Visualization

 

https://www.youtube.com/watch?v=11Ujl4y-SFA

https://developers.google.com/looker-studio/visualization

https://www.bounteous.com/insights/2020/01/30/using-community-visualizations-google-data-studio

https://lookerstudio.google.com/visualization

https://lookerstudio.google.com/reporting/65758cec-07e2-404f-a1f9-cf57043ca48d/page/SVfXB

https://lookerstudio.google.com/reporting/fd0db9a6-2d6b-443a-adbc-f6a7c7a285a7/page/GUgQB

https://lookerstudio.google.com/reporting/e39df75f-ba64-4e70-aaf9-0c091efa0129/page/p_h7cevozfyc

https://www.youtube.com/watch?v=Ma3n-NTT7FA

https://www.youtube.com/watch?v=8p7ILz5fc0E

Build App in Looker Studio

 

https://lookerstudio.google.com/reporting/fd0db9a6-2d6b-443a-adbc-f6a7c7a285a7/page/DNaRB

Petunjuk : https://lookerstudio.google.com/reporting/fd0db9a6-2d6b-443a-adbc-f6a7c7a285a7/page/GUgQB

https://docs.google.com/spreadsheets/d/1WzvNt8IolcYC81KGw4KVC2FeMpscGt4BReNxpnRdIh8/edit#gid=0

https://www.youtube.com/watch?v=Tf5W9fjcAvk&t=2262s

https://www.youtube.com/watch?v=Ma3n-NTT7FA&t=3s

https://lookerstudio.vip/learn/

https://lookerstudio.google.com/reporting/fd0db9a6-2d6b-443a-adbc-f6a7c7a285a7/page/GUgQB

https://lookerstudio.google.com/reporting/fd0db9a6-2d6b-443a-adbc-f6a7c7a285a7/page/DNaRB

https://www.youtube.com/playlist?list=PLzzmI930BFvviJgP0pPmUIssGp4-R-hzm

Indonesia's rise as a digital power

 

https://www.youtube.com/watch?v=klGB1FzNUuo

https://www.youtube.com/watch?v=R8lP3sP4sy0

Login di Google Site

 

https://www.youtube.com/watch?v=6zntMPh42Wc

https://buatgooglesitenya.blogspot.com/2021/11/membuat-fitur-login-di-google-site.html

Managemen Financial

 

https://www.youtube.com/watch?v=9LgG3JJA_0s

https://www.youtube.com/watch?v=wgHh_50SdGM

https://www.youtube.com/watch?v=wMg7JZaUvy0

BPWebs - CRUD Google Sheet

 

https://www.youtube.com/watch?v=aQlUbQQP8IM&t=22s

https://www.youtube.com/watch?v=Q93BGzGn4hk

Google Form Section - Query

 

https://www.youtube.com/watch?v=h6CArSfWACE

Tally Form

 

https://www.youtube.com/watch?v=Wj9w31eb0aI

https://www.youtube.com/watch?v=_pUixYOmNwo

https://www.youtube.com/watch?v=rdIdDkuCGb8

https://www.youtube.com/watch?v=h6CArSfWACE

Google Form - List Drop down dari spreadsheet

 

https://www.youtube.com/watch?v=73tVo_bJPSc

https://www.pelatihanholistik.com/2021/11/11/spreadsheet-google-forms-lebih-detail/

https://www.youtube.com/watch?v=XAUtW6HFwaE

https://www.youtube.com/watch?v=d7avS1wH1TU

https://www.youtube.com/watch?v=dYF7c3yws9A

/**

 * Auto-populate Question options in Google Forms

 * from values in Google Spreadsheet

 *

 * Written by Amit Agarwal (MIT License)

 *

 **/

const populateGoogleForms = () => {

  const GOOGLE_SHEET_NAME = "NAMA SHEET ANDA";

  const GOOGLE_FORM_ID = "ID GOOGLE FORM";

  const ss = SpreadsheetApp.getActiveSpreadsheet();

  const [header, ...data] = ss

    .getSheetByName(GOOGLE_SHEET_NAME)

    .getDataRange()

    .getDisplayValues();

  const choices = {};

  header.forEach((title, i) => {

    choices[title] = data.map((d) => d[i]).filter((e) => e);

  });

  FormApp.openById(GOOGLE_FORM_ID)

    .getItems()

    .map((item) => ({

      item,

      values: choices[item.getTitle()],

    }))

    .filter(({ values }) => values)

    .forEach(({ item, values }) => {

      switch (item.getType()) {

        case FormApp.ItemType.CHECKBOX:

          item.asCheckboxItem().setChoiceValues(values);

          break;

        case FormApp.ItemType.LIST:

          item.asListItem().setChoiceValues(values);

          break;

        case FormApp.ItemType.MULTIPLE_CHOICE:

          item.asMultipleChoiceItem().setChoiceValues(values);

          break;

        default:

        // ignore item

      }

    });

  ss.toast("Google Form Updated !!");

};

Gallery Maker

 

https://www.gallerymker.com/album/pwkmxmygjq

https://www.youtube.com/watch?v=6te5Xv8ckyk&t=291s

=left(replace(A2,26,7,"thumbnail?id="),71)

Menampilkan Video Di Google Studio

 

https://www.youtube.com/watch?v=tW2CrAf50po

https://www.youtube.com/watch?v=6te5Xv8ckyk&t=291s

GAS - Google Apps Script Drop down

 

https://www.youtube.com/watch?v=9fYTk-6MxdE&list=PLQhwjnEjYj8Bf_EZDrrcmkB9vcB9Sk3x0&index=33

https://www.youtube.com/watch?v=PtIo_oPoAtk&list=PLQhwjnEjYj8Bf_EZDrrcmkB9vcB9Sk3x0&index=34

https://www.youtube.com/watch?v=JVH72QDiOfY&list=PLQhwjnEjYj8Bf_EZDrrcmkB9vcB9Sk3x0&index=35

https://github.com/ashtonfei/google-apps-script-projects/

https://github.com/ashtonfei/live-coding

https://www.youtube.com/watch?v=UIfslpbVu_U&list=PLTPx7x7O-7NAekkDrxYwoG2BT8KeQp1Ts&index=1

https://www.youtube.com/watch?v=frSdszB1EeU&t=594s

Platform Belajar - Canva

 

https://www.youtube.com/watch?v=cOEdnN53YeQ

https://guru.kemdikbud.go.id/video-inspirasi/playlists/video/index.html?id=49&video=aZIB64Ms91c

https://www.youtube.com/watch?v=kx3aeoXAWM4

Matematika Bisnis - Yudy

 

https://www.youtube.com/watch?v=Rv2GneLo9VA&list=PLaRrg8AlhuATdpGjJbtVgyIjTO5qDV_Dv

https://www.youtube.com/watch?v=if9gRldzC84&list=PLaRrg8AlhuAS1PhFT8HLh9ChRX-c9oAZ2

https://www.youtube.com/watch?v=48MqOOv-Srs&list=PLaRrg8AlhuAS1PhFT8HLh9ChRX-c9oAZ2&index=2

https://www.youtube.com/watch?v=fwofZPU08Og&list=PLaRrg8AlhuAQjo2GzD6EK68o-SHsq4GEd

https://www.youtube.com/watch?v=ZXGrkIKkbyA&list=PLaRrg8AlhuARF8sfDsqZEOrvThCX_wd-x&index=3

Big Data

 

https://www.youtube.com/watch?v=N6UvkOIXtdo&list=PLaRrg8AlhuARF8sfDsqZEOrvThCX_wd-x&index=1&t=603s

https://www.youtube.com/watch?v=ZXGrkIKkbyA&list=PLaRrg8AlhuARF8sfDsqZEOrvThCX_wd-x&index=3

Kewirausahaan Digital

 

https://www.youtube.com/watch?v=i5sQRZMIPR0&list=PLaRrg8AlhuATjOhOMmHJP7YdgQdd098k3

https://www.youtube.com/watch?v=PaYl5k6ig2A&list=PLaRrg8AlhuATjOhOMmHJP7YdgQdd098k3&index=2

Big Query Warehouse

 

https://www.youtube.com/watch?v=S-vueV_OnK8

https://www.youtube.com/watch?v=ytM5lPGSOpI&t=9s

https://www.youtube.com/watch?v=K9mfW2j6IHY

Ricki Chan - Visualisasi Data Looker Studio

 

https://www.youtube.com/watch?v=drS__LgbQUM&list=PLhkyjYHra-eJhlmEZKCpsptBWXHKLfPS3&index=1

https://www.youtube.com/watch?v=xxwqIt8UMhc&list=PLhkyjYHra-eKfh4sq9x9RHyOsPoZozfE6&index=3

https://www.youtube.com/watch?v=ytM5lPGSOpI&t=9s

https://www.youtube.com/watch?v=K9mfW2j6IHY

https://www.youtube.com/watch?v=MGnMpxjJuJ0&list=PLzT2eKhDBd_VshRTlEny4wR6I7YKFe7vH&index=2

https://www.youtube.com/watch?v=s1_5j_b4rmY

https://www.youtube.com/watch?v=--M0wLddRYU&t=296s

Looker Studio - Pembinaan Dashboard Cik gu

 

https://www.youtube.com/live/lVwObJjblAU?si=T-Yk1_yuGxaGWD9Y

https://docs.google.com/document/d/1plxfFnzE97cei98UhZjAUdztqICthKilAoMoy-1kGus/edit

Sample DBASE

https://docs.google.com/document/d/1plxfFnzE97cei98UhZjAUdztqICthKilAoMoy-1kGus/edit

Markah Smaple

https://docs.google.com/spreadsheets/d/1CynKQfM1l0Y0O1vqII7IU3DwpTqB9wFl8G1BtsUVSnc/edit#gid=757975195

Looker Studio Warmindo

 

https://www.youtube.com/watch?v=sUAqphE0UeM

https://www.youtube.com/watch?v=qQfUwClQBPk

Dataset

https://lynk.id/products/21-11-2022/file_1669040030452_8664543.csv

Live Selling - Tiktok Shop

 

https://www.youtube.com/watch?v=kiwzfkdi0iI

https://www.youtube.com/watch?v=AA_tfZrJXJA

Edho Zell - Social Bread

https://socialbread.id/cara-kami-bekerja

https://dailysocial.id/post/social-bread-peroleh-pendanaan-6-miliar-rupiah-dipimpin-east-ventures

https://lynk.id/

Expoversary Pengelolaan DUDI BCA

 

Business Story

BCA Berbagi Ilmu