Podcasts about apps script

В этом выпуске: почему пластиковые окна ненадежны, как правильно располагать окна Zed на MacOS, как работают оконные функции в RANGE mode и GROUPS mode, а также литье металлом в домашних условиях и многие другие темы. Шоуноты: [00:02:06] Чему мы научились за неделю Apps Script kitty [00:32:48] Саша продолжает осваивать Zed https://apple.stackexchange.com/questions/211954/how-can-i-rename-desktops-spaces-in-macos Using different themes for… Читать далее →

⏳ Bạn đang làm việc thông minh hay chỉ đang bận rộn vô nghĩa?Mỗi ngày, bạn dành bao nhiêu thời gian cho những công việc lặp đi lặp lại: Nhập dữ liệu, gửi email, thiết kế slide, lọc bảng tính? Những việc này có thật sự cần thiết, hay bạn chỉ đang mắc kẹt trong guồng quay làm nhiều nhưng không hiệu quả?Hãy tưởng tượng tất cả những việc này chỉ cần vài cú click chuột để hoàn thành!

Làm sao để viết câu prompt tốt hơn trong lần tới, đặc biệt là prompt tạo đoạn mã? Trong video này, Linh sẽ hướng dẫn các bạn từng bước để viết prompt tự động đổi màu số trên Google Sheets và Microsoft Excel. Bạn sẽ tìm hiểu về:

Content and Idea Generation, Programming Assistance, Legalities and Business, and even Entertainment, ChatGPT's versatility allows for numerous other applications limited only by imagination and creativity.Amazon sellers can also utilize this powerful tool to assist with various aspects of Amazon Pay-Per-Click (PPC) advertising by providing information, tips, and guidance.Rita Java from PPC Ninja takes AI utilization to the next level and discusses how her team successfully harnesses the AI tool's hidden capabilities, resulting in a monthly time savings of approximately 500 work hours.Episode Notes: 00:25 - Ritu Java Introduction 03:05 - How Does Chat GPT Help in the PPC Game? 05:00 - Chat GPT on Steroids - Advanced Data Analysis 07:30 - Feeding Data to Chat GPT 10:00 - Apps Script x Chat GPT 12:00 - Asking Chat GPT to Generate Trends per SKU 13:50 - Optimizing Listings with ChatGPT 15:50 - SmartScout Brand Analysis 16:20 - Changing Bid Recommendations 17:05 - Going After Competitors with ChatGPT 19:15 - Using Broad Match Modifiers 21:50 - Generating Sponsored Brand Headline Ads 24:40 - Upper and Bottom of FunnelWebsite: About Us | PPC NinjaLinkedIn: Ritu Java | LinkedInRelated Post: Pacvue vs. Perpetua - Which PPC Bid Management Tool is Best for You?

Hi there! Thanks for listening, I Want to Hack is a weekly discussion of coding and spreadsheet concepts. I hope you'll subscribe to follow along! Links at the bottom, but if you do nothing else, would you consider subscribing to my YouTube channel where I share spreadsheet and coding tutorials?

今回のゲストは、社長の id:chris4403 です。最近気になっている技術の話や、はてなの2022年についてお話しています。 トークテーマ: オフィス移転や働き方制度アップデートなどがあった、はてなの2022年 変化を起こすということ byhatenaも開始からちょうど1年 motemenも技術グループも2022年はアウトプットをがんばった RISC-Vを勉強中のmotemen 手を動かすときにGAS使いがちの社長 音声の文字起こし 新入社員のみなさんが研修で作った社内向けサービス「はてなピアスター」 このPodcastへの感想やコメントはぜひ #byhatena をつけてツイートしてください!

Have you ever faced a spreadsheet where one column contains values for each “section” of the spreadsheet but you want to fill those values down through the rest of the column? This is a common problem when you get a data dump from a database or perhaps a copy/paste from a PivotTable. You have values […] The post Dear Analyst # 110: A tutorial on how to fill values down with Excel VBA and Google Apps Script (Vancouver Power BI/Modern Excel re-broadcast) appeared first on .

As we get closer to the cutoff for the GSuite Legacy shutdown, we feel it is time to unite our voices behind a single hashtag and amplify our message so that all the right people at Google get to hear it. With that in mind, we have coined the hashtag #familyworkspace and invite everyone to use it in your tweets and posts about the topic. Feel free to tag @Googleworkspace as well! Silent Releases Japanese grammar suggestions for Gmail Update to message ID in Google Chat audit logs Smart reply in Google Slides Published Releases New beta for data loss prevention helps protect sensitive data when users upload files to external Google Forms Use context-aware access to help protect Admin console access Additional one-click recommended actions in the Alert Center Join a Google Meet call from Google Docs, Sheets, or Slides Additional functionality for the Apps Script Integrated Development Environment (IDE) Script Editor Build custom, integrated solutions across Google Workspace with the new AppSheet Apps Script connector New port for Google Meet media and TLS support for Meet on mobile Intelligent corrections for formulas in Google Sheets Specify which Google Chat notifications from Chat and Gmail to receive when your iOS device is in Focus mode Other Releases Drive for Desktop Workspace Recap is the only show dedicated to and discussing all of the changes happening in Google Workspace on a weekly basis, as well as how all these changes affect our users and our businesses. Google Workspace is innovating at a breakneck pace, making it difficult to keep up and keep track. Join us each week as we discuss What's New in Google Workspace, Upcoming Google Workspace releases, and answer your questions. Hit the subscribe button, engage with us on Twitter at @WorkspaceRecap, and on our website at workspacerecap.com --- Send in a voice message: https://anchor.fm/workspacerecap/message

Your hosts Stephanie Wong and Alicia Williams talk about BigQuery Admin Reference Guides with guest Leigha Jarett. Leigha tells us a bit about the origins of the Admin Reference Guide, which was developed to address frequent customer questions. The series of guides and videos covers onboarding topics from resource hierarchy and APIs to BigQuery tables and storage in an effort to help new admins get started. The team’s Reference Guide on tables helps admins understand the difference between federated and native tables, and Leigha tells our listeners some tips for using each type. Slots and reservations for workload management in BigQuery can be challenging to understand, but these Reference Guides and accompanying videos offer clear explanations. Optimizing projects for speed and monetary efficiency are important topics for any client, and Leigha and the optimization team have addressed these concerns as well. Tips for monitoring, data governance, and the secure sharing of data are also included in their video series, BigQuery Spotlight. We wrap up with a discussion on BigQuery APIs and how easy it is to integrate BigQuery and other Google products. Leigha Jarett Leigha is a developer advocate on the Google Cloud Data & Analytics team. She focuses on making sure developers using tools like BigQuery and Looker are getting the most possible value from their data. Cool things of the week Analyze Cloud Spanner data in BigQuery with federated queries docs Release notes dataset in BigQuery docs and XML feed Google Cloud release notes docs and XML feed Release notes in Cloud Console site Top 25 Google Search terms, now in BigQuery blog Interview BigQuery Admin Reference Guide Blog Recap site BigQuery Admin Reference Guide blog posts site BigQuery Spotlight Video Series videos BigQuery site BigQuery Documentation docs Cloud Spanner site Data Catalog site Apps Script site Looker site What’s something cool you’re working on? Alicia is building new BigQuery architectures in order to understand the journey and identify potential pain areas that may need more support.

Stephanie Wong and co-host Carter Morgan learn all about the no-code experience of AppSheet Automation this week. Guests Jennifer Cadence and Prithpal Bhogill introduce us to AppSheet, a platform that empowers anyone to build applications without code. The strong focus on openness means AppSheet offers support for all manner of APIs and services, making it easy to use and customize. Jennifer starts by telling us how AppSheet increases productivity and satisfaction at work. She describes how people’s individual characteristics and use of time affect productivity and explains that tasks that can be automated free people up to work on higher value tasks or focus on important issues. Employees are not only more productive but happier in their jobs when mundane or frustrating tasks are automated. Later, Prithpal describes using the software. The AppSheet Unified Platform supports any application creator so users can build their apps and automations without ever leaving the AppSheet dashboard. Data stays where it is, with no upload requirements, further easing the build process. We hear some real-world uses of AppSheet Automation, including employee onboarding, customer support, and more. Prithpal takes us behind the scenes, using examples to explain the inner workings of AppSheet and walks us through the steps of using this powerful tool. Jennifer tells us how the AppSheet Community helps shape the platform and talks about the future of AppSheet Automation. Jennifer Cadence Jennifer is the Product Marketing Manager for AppSheet. She’s also a dog lover, community builder, and curious human. Prithpal Bhogill Prithpal is the Lead Product Manager for AppSheet, frequent blogger, and featured speaker on several tech conferences. Cool things of the week Choose your own cloud adventure video Recovering global wildlife populations using ML blog Introduction to AI Platform (Unified) docs Interview AppSheet site AppSheet Community site Invisible Woman book Apps Script site Workspace site What’s something cool you’re working on? Stephanie and Carter are working on some new features for the podcast! Stephanie will be speaking at CTC. Sound Effects Attribution “Applause 1” by Ichapman1980 of Freesound.org

Добрый день уважаемые слушатели. Представляем новый выпуск подкаста RWpod. В этом выпуске: Ruby Ruby 3.0.0 Preview 2 Released Rails 6.1: Horizontal Sharding, Multi-DB Improvements, Strict Loading, Destroy Associations in Background, Error Objects, and more! Rails 6.1 allows associations to support destroy_async option with dependent key Prettier for Ruby goes v1.0 Omniauth 2.0.0 Release Candidate 1 Climbing Steep hills, or adopting Ruby 3 types with RBS How to Create a AWS Lambda Layer of Your Gemfile / Ruby Gem Dependencies Introducing new features for the aws-sdk-rails gem Web Web Almanac 2020 The Import On Interaction Pattern Get ready to up your Apps Script! How did JavaScript’s console.log get its name? Debugging WebAssembly with modern tools Sticky Table Header with React Hooks JSitor - an alternative of JSFiddle, Codepen and JSbin Copy Guard - a simple browser extension that warns you when your copy action was hijacked

When I worked in FP&A, I discovered that VBA could automate a lot of tedious tasks I was doing in Excel. From creating charts to formatting data, I realized that there possibilities with VBA were endless. As I started using Google Sheets more, I found that Google Apps Script offers similar functionality to extend what […] The post Dear Analyst #53: Making your Google Sheets do more for you with Google Apps Script and how to become more data-driven appeared first on .

SPACs (Special Purpose Acquisition Companies) or “blank check” companies have been in the news recently, so I used some real SPAC data for this episode. Your spreadsheet has empty cells in column A, and these empty cells should be filled with values. Your task is to fill values down up until you find another cell […] The post Dear Analyst #42: Filling values down into empty cells programmatically with Google Apps Script & VBA tutorial appeared first on .

อบรม Apps Script โดยการไลฟ์เข้า Workplace

Priyanka Vergadia hops back into the host seat this week, joining Mark Mirchandani to talk to Marit Rødevand of Strise. Strise is an AI-driven enterprise company using knowledge graphs to gather and analyze massive amounts of information, depositing it into a web-based interface to help large clients such as banks solve data-driven problems. Strise’s web-based data platform is customizable, flexible, and capable of keeping up with the fast-paced world of technology so enterprise companies aren’t constantly putting time and resources into reworking old or building new software. To do this, Strise uses knowledge graphs rather than typical databases to create what Marit calls a future-proof data model. Marit explains knowledge graphs in detail, emphasizing that they can reduce training of machine models, allow new data to be input easily, and make analyzing unstructured data much easier. Knowledge graphs take data that would normally only make sense to humans and in effect translate it for computers. Using banking as an example, she details how information about customers can be collected and analyzed thoroughly to help the bank come to conclusions about credit-worthiness or possible criminal activity. On Strise’s platform, Marit tells us that the information is now available to the end user who provides feedback to the system, marking things as relevant or irrelevant, rather than leaving those decisions to a data scientist outside of the client’s field. This means that massive amounts of information could be stored in the knowledge graph, across many industries, and each user only gets the data he or she needs. Google Cloud tools such as Kubernetes Engine, Dataproc, and Pub/Sub have played an integral roll in the creation of the Strise data pipeline. Marit explains how Strise gets their data, how it’s input into the knowledge graph, and how these Google tools help to keep Strise running. Marit Rødevand Marit Rødevand is the CEO & co-founder of Strise, an AI startup from Norway who is signaling a new era of enterprise software. Strise makes the world’s information useful across the enterprise. Their novel approach by utilizing a knowledge graph to power their data platform, allows Strise to break data silos, end customization projects, and bring new insights from unstructured data. Strise is currently helping leading Nordic banks and financial institutions to solve their hardest data-driven problems within KYC/AML, risk, and sales. Strise recently announced their Seed round from Maki.vc, the leading Nordic early stage investor, who invests in deep tech & brand-led startups. Marit has a background from Cybernetics & Robotics at the Norwegian University of Science and Technology (NTNU). In university, she co-founded Rendra, a construction SaaS, who was later acquired. Marit started as Entrepreneur in Residence at NTNU where she spun Strise out of a research project that focused on new data models as a foundation for better AI. Cool things of the week BakeML site David East’s Firebase Podcast podcast Automating BigQuery exports to an email blog Cloud OnBoard site Interview Strise site A world in text — Strise blog GKE site Helm sote Dataproc site Operations site Cloud Run site Cloud Pub/Sub site Cloud DNS site Cloud Storage site GCP Podcast Episode 198: SeMI Technologies with Laura Ham podcast Building on Google Cloud with SeMI Technologies - Stack Chat video Knowledge graphs with Weaviate - Stack Chat video Natural Language Data Processing with Mito.ai - Stack Chat video Question of the week Zach answers the question “What’s a cool thing in Cloud that many people may not have thought about?” GSuite and Apps Script What’s something cool you’re working on? Priyanka wrote this post on 13 Most Common Google Cloud Reference Architectures and her parents were on the news for the vegetable garden they’ve been working on. She’s also been working with material design components and firebase hosting. And The Data Show with Yufeng and Felipe is going strong!

Today’s guest is Ben Collins, who creates online courses, writes tutorials, and teaches workshops around G Suite and App Script. Apps Script is a scripting platform developed by Google for light-weight application development in the G Suite platform. It is an implementation of JavaScript with the express purpose of extending Google apps. App Script was started 10 years ago as a side project, and it eventually took on its own life. Ben talks about some of the different things that App Script can do and where things are stored. They discuss different ways you can get into the script and how to import external scripts from a CDN. Ben gives two examples, one simple and one sophisticated, that you might build from App Script. He talks about event triggers and how authentication is handled. He goes over the three deployment options, namely web app, app executable, sheets add-on, and deploying from the manifest. Ben talks about how triggers are managed in App Script and options for debugging. There is also the option to develop locally as well as in the browser. The show ends with him talking about how to build using HTML in App Script. Panelists Aimee Knight Steve Edwards Dan Shapir Guest Ben Collins Sponsors G2i Split ____________________________ "The MaxCoders Guide to Finding Your Dream Developer Job" by Charles Max Wood is now available on Amazon. Get Your Copy Today! ____________________________________________________________ Links G Suite AppScript Clasp Picks Steve Edwards: King Kong Apparel Aimee Knight: Developers Mentoring Other Developers Dan Shapir: The Web Almanac AJ O’Neal: Photography Magic Lantern Bem Collins: Cold Turkey app Follow Ben at Benlcollins.com and Twitter

Today’s guest is Ben Collins, who creates online courses, writes tutorials, and teaches workshops around G Suite and App Script. Apps Script is a scripting platform developed by Google for light-weight application development in the G Suite platform. It is an implementation of JavaScript with the express purpose of extending Google apps. App Script was started 10 years ago as a side project, and it eventually took on its own life. Ben talks about some of the different things that App Script can do and where things are stored. They discuss different ways you can get into the script and how to import external scripts from a CDN. Ben gives two examples, one simple and one sophisticated, that you might build from App Script. He talks about event triggers and how authentication is handled. He goes over the three deployment options, namely web app, app executable, sheets add-on, and deploying from the manifest. Ben talks about how triggers are managed in App Script and options for debugging. There is also the option to develop locally as well as in the browser. The show ends with him talking about how to build using HTML in App Script. Panelists Aimee Knight Steve Edwards Dan Shapir Guest Ben Collins Sponsors G2i Split ____________________________ "The MaxCoders Guide to Finding Your Dream Developer Job" by Charles Max Wood is now available on Amazon. Get Your Copy Today! ____________________________________________________________ Links G Suite AppScript Clasp Picks Steve Edwards: King Kong Apparel Aimee Knight: Developers Mentoring Other Developers Dan Shapir: The Web Almanac AJ O’Neal: Photography Magic Lantern Bem Collins: Cold Turkey app Follow Ben at Benlcollins.com and Twitter

Today’s guest is Ben Collins, who creates online courses, writes tutorials, and teaches workshops around G Suite and App Script. Apps Script is a scripting platform developed by Google for light-weight application development in the G Suite platform. It is an implementation of JavaScript with the express purpose of extending Google apps. App Script was started 10 years ago as a side project, and it eventually took on its own life. Ben talks about some of the different things that App Script can do and where things are stored. They discuss different ways you can get into the script and how to import external scripts from a CDN. Ben gives two examples, one simple and one sophisticated, that you might build from App Script. He talks about event triggers and how authentication is handled. He goes over the three deployment options, namely web app, app executable, sheets add-on, and deploying from the manifest. Ben talks about how triggers are managed in App Script and options for debugging. There is also the option to develop locally as well as in the browser. The show ends with him talking about how to build using HTML in App Script. Panelists Aimee Knight Steve Edwards Dan Shapir Guest Ben Collins Sponsors G2i Split ____________________________ "The MaxCoders Guide to Finding Your Dream Developer Job" by Charles Max Wood is now available on Amazon. Get Your Copy Today! ____________________________________________________________ Links G Suite AppScript Clasp Picks Steve Edwards: King Kong Apparel Aimee Knight: Developers Mentoring Other Developers Dan Shapir: The Web Almanac AJ O’Neal: Photography Magic Lantern Bem Collins: Cold Turkey app Follow Ben at Benlcollins.com and Twitter

In this episode, we discuss google apps script and the benefits of utilizing it in google sheets. We also look at a use case and provide and example of how the api can be used. If you have something to say, send your emails to lyzstudios@gmail.com and listen to the podcast on all of your favorite podcast apps. Visit lyzstudios.com for more content! --- This episode is sponsored by · Anchor: The easiest way to make a podcast. https://anchor.fm/app --- Send in a voice message: https://anchor.fm/lyzstudios/message Support this podcast: https://anchor.fm/lyzstudios/support

Jon Foust is back this week, joining Mark Mirchandani for an in-depth look at Stackdriver with fellow Googler, Rory Petty. To start, Product Manager Rory explains that Stackdriver is a full observability solution for Google Cloud (as well as other clouds). We touch on how monitoring, logging, and APM tools allow developers and operators to fully understand how a website is performing. In addition to Monitoring and Logging, the suite of Stackdriver tools also includes Debugger, Trace, and Profiler to help users not only monitor their sites, but to solve problems that occur. Stackdriver Monitoring and Logging support Google Cloud services out of the box. Users can use Monitoring to set up alerts, so if something goes awry, they are notified immediately and can address the problem. Alerts can also be custom designed to inform developers of things like number of checkouts on your e-commerce site, the amount of time between checkouts, and more. Stackdriver Monitoring allows blackbox monitoring, too, to make sure your service is healthy. The Monitoring dashboard makes it really easy to get started, with a resources section that has pre-made dashboards for developers to use. Developers don’t have to do a lot of configuration out of the box. However, if you need a more customized dashboard, that is also possible in Stackdriver Monitoring. At Cloud Next earlier this year, Stackdriver announced Service Monitoring in alpha, which shows users a map of their microservices architecture. Public beta will hopefully be later this year. Stackdriver Sandbox, another recent project currently in the alpha stage, gives people an easy way to configure a test Stackdriver environment. This way, developers can play with Stackdriver tools without effecting their websites. Stackdriver Profiler, a great tool to understand the performance of your system, went GA at Cloud Next as well. Stackdriver’s tools are all meant to work together to help you maintain and perfect development projects on many different cloud services and on-prem. Rory Petty Rory Petty is Product Manager for the Stackdriver Monitoring Platform. In his spare time, he enjoys cooking and is a vinyl record enthusiast. Rory is a midwest transplant living in Brooklyn. Cool things of the week Commute just got easier with Google Pay and Google Assistant blog 5 year anniversary of Kubernetes and KubeCon content videos Kubernetes Podcast podcast Early Preview of AR in Google Maps video Interview Stackdriver site Stackdriver with Kubernetes video Stackdriver Monitoring site Stackdriver Logging site Stackdriver Debugger site Stackdriver Trace site Stackdriver Profiler site App Engine site Compute Engine site GKE site Site Reliability Engineering (SRE) Book site Istio site Stackdriver Service Monitoring site Stackdriver Sandbox site Cloud Next ‘19 DevOps & SRE Sessions videos Cloud On Air site Stack Doctor Playlist videos Implementing GCP Stackdriver and Adapting SRE Practices to Samsung’s AI System video Stackdriver Documentation site Question of the week How do I decide between Apps Script and App Maker? Where can you find us next? Jon is going to Games for Change. Mark is going to be in NYC right before Games for Change. Sound Effect Attribution “Spaceship Fly-by, A” by InspectorJ of Freesound.org “Teleport” by Sergenious of Freesound.org “Moretube.wav” by NoiseCollector of Freesound.org “Mystery Peak2.wav” by FoolBoyMedia of Freesound.org

Node.js is our topic this week as Mark and first-time host, Jon Foust, pick the brain of Myles Borins. Myles updates us on all the new things happening with Node.js, including the new .dev site that holds a ton of documentation to help people get started. Node.js now integrates with Cloud Build, the Node.js foundation has some new developments, and Google App Engine supports Node.js. The group has also been working on serverless containers. Myles Borins Myles Borins is a developer, musician, artist, and maker. They work for Google as a developer advocate serving the Node.js ecosystem. Myles cares about the open web and healthy communities. Cool things of the week Google Cloud Next ‘19 session guide now available blog Introducing scheduled snapshots for Compute Engine persistent disk blog Reliable task scheduling on Compute Engine with Cloud Scheduler site How to make a self-destructing VM on Google Cloud Platform article Making AI-powered speech more accessible—now with more options, lower prices, and new languages and voices blog Interview GCP Podcast Episode 105: Node.js with Myles Borins podcast Node.js site Introduction to Node.js site Nodejs.dev on Github site Cloud Build site Firebase site Node.js Foundation site JS Foundation site Linux Foundation site Foundation Bootstrap Team on Github site App Engine site G Suite site Apps Script site BigQuery site JSON site The hilarious misadventures of being a platform downstream from your language video Node.js Versions - How Do They Work? video Open Source Leadership Summit site Black Girls Code site Scripted site Girls Who Code site Question of the week How do I get google cloud APIs to work within Unity? Add packages from NuGet to a Unity project and read more in the Unity docs here Where can you find us next? Mark will be at GDC in March, Cloud NEXT, and ECG in April. Jon will be at GDC, Cloud NEXT, ECG, and Vector 2019.

Joanna Smith and Alicia Williams talk G Suite with Mark and Melanie this week! G Suite is Google’s collection of apps to help make working easier. It includes things like Gmail, Docs, Sheets, Calendar, and more and is designed to be collaborative. It’s customizable, allowing users to adjust the programs to their needs and be more effective – including integrating it with Google Cloud! G Suite has an active community of developers building add-ons to increase functionality as well. Joanna Smith Joanna is a Developer Advocate for G Suite, working to make sure that anyone can extend G Suite with clever solutions to make Google work for them. Alicia Williams Alicia is an advocate for Google Cloud, trying to help data analysts solve problems. She uses machine learning, SQL, and visualizations to help solve problems and tell stories. Cool things of the week A dataset of congressional bills and built a text classification model with AutoML Natural Language by Sara Robinson tweet and blog Serverless from the ground up: Connecting Cloud Functions with a database (Part 3) blog How 20th Century Fox uses ML to predict a movie audience blog Kick off developer projects with improved G Suite Developer Hub blog This multiplayer game integrates Open Match, a highly-scalable, open source matchmaking framework from Google Cloud, Unity tweet, and Google Doodle Happy Anniversary, Melanie! Interview G Suite site Google Sheets site G Suite on Google Plus site G Suite Marketplace site G Suite on Github site G Suite APIs site G Suite App Maker site Building IoT Applications on Google Cloud video Firestore Google Apps Script Library site Build on G Suite site Advanced Services Documentation site BigQuery site New Google Sheets enterprise data integrations with BigQuery and SAP blog Analyze big data within Google Sheets site Analyzing text in a Google Sheet using Cloud Natural Language API and Apps Script blog Entity sentiment analysis on text data in a Google sheet using Cloud Natural Language Github site Question of the week What if I want to write a code sample with a link that opens the Cloud Console and automatically clones a Git repository into Cloud Shell? Where can you find us next? Alicia will be at DevFest. Mark will be at KubeCon in December. Melanie will be at SOCML this month.

Google News and Updates Want to Change The Game? Design one with Google Play Change the Game Challenge A smarter search for files on your phone with Files Go OK Go makes some noise in the classroom Just a Line app (justaline.withgoogle.com) Featured Content Sheets Add-Ons What are add-ons? Add-ons run inside Google Sheets, Docs, Slides, and Forms, but they're built by developers like you and tie into over a dozen Google services without even spinning up a server. Add-ons are built with Apps Script, a server-side JavaScript platform that requires zero setup. Where to find them in Sheets? Connection to forms Google Sheets and Google Forms work hand-in-hand. The data collected from your form is placed in a Sheet where you can then manipulate results, perform additional calculations, and even create mailmerges using any number of add-ons. Resources Autocrat Remove duplicates Super Quiz Flubaroo Flippity Doctopus Google Teacher Tribe Mailbag #GTTribe One of my favorite ways to use #Google #Forms is to use the add on Form Recycler. We encourage Ts to use it to create test banks as they can pull ?s they have used before. Also saves on clicks! @ShakeUpLearning @jmattmiller — Lindsay Foster (@BSGSCSFoster) March 28, 2018 Bailee Sandsmark (email), a 6th-grade middle school PE teacher asks, " I’d like to send out a Sheets template to all 250 of my students for them to individually track their fitness testing data, but then I would like to have an efficient way for them to share that info with me so that I can see all of my students' data in one sheet. Having to access 250 different sheets makes my head spin. Currently, my students track this data on a piece of paper, but it would be great for them to have a digital copy that can travel with them all three years of middle school so they can truly track their growth and so that their 7th and 8th grade PE teachers can see the data as well. I’m hoping you might be able to point me in the right direction of an extension that would do the trick." Check out the Alice Keeler Template Tab! On The Blogs Matt - 11 tips for creating stop motion in Google Slides by Jake Miller (Episode 33 Guest) Kasey - The Nutritional Value of Learning [shortcode-variables slug="signature"]

Ben Collins is a spreadsheet developer, data consultant, and data analytics instructor. He blogs and creates courses at BenLCollins.com, focusing on how to work with data using Google Sheets, Apps Script, and Data Studio. Ben has taught workshops on data analysis, as well as doing freelance and consulting work. Prior to striking out on his own, he spent seven years as a forensic accountant focusing on data analysis. In this episode, we talk about what a data analyst does, how Ben taught himself how to code, why demand is high for data professionals right now, the tools a data analyst uses, and the first steps to take if you want to get started in the field. If you want to step up your spreadsheet game, you can get 20% off Ben's Google Sheets Training Bundle using my affiliate/commission link at LearntoCodeWith.Me/sheets. Going through this link will automatically apply the 20% discount on this course and send a few bucks my way at no extra cost to you.