DoIT Training at Stony Brook University
DoIT Training at Stony Brook University
  • Видео 493
  • Просмотров 2 516 267
Working with Excel Files in Google Workspace via Gmail and Drive
Google Sheets is a powerful spreadsheet tool, but sometimes you or your collaborators want to work with Excel. There are actual several ways to use Excel with Google.
Slides: docs.google.com/presentation/d/1jL53-yq6WKhHJK5Y2q_WmOxiKv91huZaB_mf0J6aStY/edit?usp=sharing
0:00 Intro
0:22 Save Excel Gmail attachments to Google Drive
1:23 Open Excel files in Google Sheets
2:25 Email an Excel version of your file from Google Sheets
4:11 Open Google-Drive stored Excel files in Excel
5:53 Clean up unneeded Excel files
Tip: If you don’t see Microsoft Excel.app as an option under Open with, install Google Drive for desktop (support.google.com/drive/answer/7329379) and Application Launcher extension (chrome....
Просмотров: 1

Видео

Brightspace: Automatic Zero for Missing Submissions Option (New Feature!)
Просмотров 7214 дней назад
Use the new Automatic Zero for Missing Submissions Option to automatically give a zero to assessments without submissions at the due date. See to enable this feature and what it looks like for learners and instructors when there is an automatic zero. #brightspace #brightspacegrading #D2L #LMSgradebook
Brightspace Gradebook 1: Setting up Your Brightspace Gradebook with the Setup Wizard Tool
Просмотров 21714 дней назад
Learn how to set up your Gradebook in Brightspace and how the new Automatic Zero option (community.d2l.com/brightspace/kb/articles/26156-about-automatic-zero-grading-for-missing-submissions) works. 0:00 Intro 0:16 Navigate to your course 0:25 Navigate to Grades Setup Wizard 1:13 Choose grading system 2:11 Choose which final grade to release 3:01 Grade Calculations 3:49 NEW Automatic Zero 4:18 D...
How to Update Brightspace Notification Settings
Просмотров 8014 дней назад
How to Update Brightspace Notification Settings
Filtered Views in Google Sheets
Просмотров 75Месяц назад
Filtered Views in Google Sheets
Protecting Sheets and Ranges in Google Sheets
Просмотров 38Месяц назад
Protecting Sheets and Ranges in Google Sheets
New! Google Sheets Tables: Organize, Group, Filter, and Share Data EASILY
Просмотров 2062 месяца назад
Google Sheets now has Tables! -Organize your data -Easily create (and share!) grouped and filtered views -Repeat -Celebrate 🎉 #googlesheets #spreadsheet #googlenewupdate #tables
Google Sheets: Tables to Organize Data (New Feature!)
Просмотров 1182 месяца назад
Google Sheets now has Tables, which help organize and beautify your data. Copy Demo sheet to follow along: docs.google.com/spreadsheets/d/1Sn1RhVnbs_fijR3XvAvt7aOuyt9C7asVh4fKnsfvcds 0:00 Intro 0:11 Create table from existing data 0:22 Create table from scratch with a template 0:52 Set column type 1:29 Use dropdowns 2:47 Customize table 3:41 Group by views 5:18 Filter views 6:20 Tables and form...
Google Sheets: Email Merge To Send Custom Attachments With a formula
Просмотров 1062 месяца назад
Use vlookup to send quasi-custom attachments using mail merge. If there's a column value you can use to find the right attachment from a list, this formula will help making mail merge emails even more customized and helpful. More on vlookup: docs.google.com/presentation/d/1eEvRc7j9nZY_pG4xAPAfyrqPeWDXxJyH34-dYFy5ZM8 More on email merge: docs.google.com/presentation/d/1S8TWRNIa_VrLIz5UJb-HOVp4VA...
Google Sheets: Pivot Tables to Summarize Data in a few clicks in Google Sheets
Просмотров 2202 месяца назад
Have a spreadsheet you need to summarize data for? Learn to use Google Sheets Pivot Tables to quickly summarize data to see total numbers by department, project status, or any repeated value in your data. Demo sheet (make a copy to follow along): docs.google.com/spreadsheets/d/1wTDINTKRNZCXL_t_LOYfZzhG4mgzcnzZjnSY4giRdgc 0:00 Intro 0:17 Sort sheet (to count number of each word) 0:53 Create Pivo...
Using AI to Improve Emails that Require Action
Просмотров 573 месяца назад
Watch as I use AI to rewrite an email inviting people to register for technology workshops. 0:00 Intro 0:23 Email with 70% better performance! 1:16 Get general tips for better emails from AI 2:20 Identify the goal of the email 3:27 Use AI to improve parts of your email
Using Grade Schemes in Brightspace
Просмотров 2224 месяца назад
00:00 What are Schemes? 00:34 Creating a Scheme 05:31 Apply a Scheme to Individual Grade Items 06:25 Apply a Scheme to an Entire Gradebook 07:06 Copying Schemes to Other Courses
Brightspace Common Gradebook Issues #5 How Can I Reorder My Gradebook
Просмотров 1015 месяцев назад
Brightspace Common Gradebook Issues #5 How Can I Reorder My Gradebook
Brightspace Common Gradebook Issues #4 What Are These Icons in My Gradebook
Просмотров 885 месяцев назад
00:00 Intro 00:20 Eyeball with Slash Icon in Manage Grades 00:59 Clock Icon 01:57 Star Icon 02:43 Exclamation Point Icon 03:30 Question Mark Icon in Manage Grades 04:06 Roundabout Icon 05:06 File in a Bin, Speech Bubbles, and Question Mark in Square Icons 05:50 Open Eyeball or Eyeball with a Slash Icon in Enter Grades Releasing Final Grades Article: it.stonybrook.edu/help/kb/releasing-final-gra...
Brightspace Common Gradebook Issues #3 Why Are My Students Not Seeing Their Grades
Просмотров 965 месяцев назад
00:00 Intro 00:14 Preview Grades as a Student 00:48 Are Your Grade Items Linked? 03:39 Are Your Grade Items Hidden? 05:21 Have You Checked Your Quiz Settings? 06:36 Have You Checked Your Final Grades Settings? Releasing Final Grades and Changing Final Grade Settings: it.stonybrook.edu/help/kb/releasing-final-grades-in-brightspace
Brightspace Common Gradebook Issues #2 Deleting Grade Items That Won't Go Away
Просмотров 745 месяцев назад
Brightspace Common Gradebook Issues #2 Deleting Grade Items That Won't Go Away
Brightspace Common Gradebook Issues #1 Grade Weight Error Messages
Просмотров 1095 месяцев назад
Brightspace Common Gradebook Issues #1 Grade Weight Error Messages
How to Use Polls/Quizzes in Zoom
Просмотров 5685 месяцев назад
How to Use Polls/Quizzes in Zoom
How to Use Zoom Surveys
Просмотров 1445 месяцев назад
How to Use Zoom Surveys
Google Sheets: Data Extractions- Pull Date Last Modified, Who Last Modified and More Into Sheets
Просмотров 2816 месяцев назад
Google Sheets: Data Extractions- Pull Date Last Modified, Who Last Modified and More Into Sheets
Broadcast Messages to Zoom Breakout Rooms
Просмотров 1006 месяцев назад
Broadcast Messages to Zoom Breakout Rooms
Google Sheets Tools to Delve Into AI-coded Sentiment Analysis Data
Просмотров 1776 месяцев назад
Google Sheets Tools to Delve Into AI-coded Sentiment Analysis Data
Grading Exams/Quizzes in Brightspace
Просмотров 2656 месяцев назад
Grading Exams/Quizzes in Brightspace
Quiz Settings & Enabling Respondus in Brightspace
Просмотров 1626 месяцев назад
Quiz Settings & Enabling Respondus in Brightspace
Question Pools in Brightspace
Просмотров 1066 месяцев назад
Question Pools in Brightspace
Creating a Quiz in Brightspace
Просмотров 6816 месяцев назад
Creating a Quiz in Brightspace
The Question Library in Brightspace
Просмотров 2726 месяцев назад
The Question Library in Brightspace
Google Sheets Query: GROUP BY to Organize Results by a Column
Просмотров 1,7 тыс.6 месяцев назад
Google Sheets Query: GROUP BY to Organize Results by a Column
Google Sheets: Removing Empty Rows from =Query() Results
Просмотров 9776 месяцев назад
Google Sheets: Removing Empty Rows from =Query() Results
Mini Byte: Microsoft Co-Pilot AI Enterprise
Просмотров 376 месяцев назад
Mini Byte: Microsoft Co-Pilot AI Enterprise

Комментарии

  • @miguelgarcia6493
    @miguelgarcia6493 16 часов назад

    Im trying to use OnBase to scan some files but every time I click on Acquire, it wants to use my laptops camera for some reason. Any suggestions?

  • @jldoming
    @jldoming 2 дня назад

    🍒🌻This version of the cheat is already old, the new version of the cheat with anti-ban is already on my channel‍🎤👾

  • @jldoming
    @jldoming 2 дня назад

    🌟🎉This version of the cheat is already old, the new version of the cheat with anti-ban is already on my channel‍🔥💥

  • @wmpmacm
    @wmpmacm 3 дня назад

    I am learning Brightspace. This was helpful.

  • @SheldonMaye
    @SheldonMaye 3 дня назад

    Thank you!!!

  • @mkTVofficials
    @mkTVofficials 6 дней назад

    Hi! Thank you for the useful idea, just a question can we do as button like add file, will instead of add file i will use download button? is it possible not a link.

  • @ritchiewlc
    @ritchiewlc 8 дней назад

    thanks so much! trying to find a solution for that

  • @shawna5158
    @shawna5158 11 дней назад

    Why don't I see 'move to' ?

  • @marshallcolin71
    @marshallcolin71 12 дней назад

    This was super helpful thanks! I'm using it to create a free database for my landscaping business employees, to help them better remember addresses

  • @AayanshMagicWorld
    @AayanshMagicWorld 27 дней назад

    nice

  • @MRPOLY_237
    @MRPOLY_237 Месяц назад

    Thank you ❤

  • @Lei3195i
    @Lei3195i Месяц назад

    Thank you. You solved my problem with a 6 1/2 year old video. :)

  • @DannyJuarez-en8sg
    @DannyJuarez-en8sg Месяц назад

    Great video. What if my survey has been active and I want it to load all and future responses into a google sheet?

    • @DoITTrainingSBU
      @DoITTrainingSBU 22 дня назад

      you can't bring previous responses through this tool. You can, however, export that data and manually paste it into the sheet your new responses come into: www.qualtrics.com/support/survey-platform/data-and-analysis-module/data/download-data/export-data-overview/

  • @connelwilson8
    @connelwilson8 Месяц назад

    Are there any options for sharing zoom polls between instructors? ie, if user A creates Poll A, is there a way for user A to the send the Poll A questions to User B for them to use in their own zoom meetings?

    • @cherylp3796
      @cherylp3796 Месяц назад

      I have the same question. I create polls and quizzes and want the other instructors to use them w/o recreation.

    • @DoITTrainingSBU
      @DoITTrainingSBU Месяц назад

      Unfortunately no, at this time polls and quizzes are tied to one account and cannot be transferred or shared with another user.

  • @andrewjohn970
    @andrewjohn970 Месяц назад

    why my gmail 3 dot..dont have foward as attachment?

  • @justinmacinnes5670
    @justinmacinnes5670 Месяц назад

    Thanks for the info. OK I think I understand now (time will tell)!

  • @marry-anntan9071
    @marry-anntan9071 Месяц назад

    thank you

  • @rverstee
    @rverstee 2 месяца назад

    This is an amazing video - it will be so much easier writing my dissertation now that I understand how to do this

  • @brandonnolan6222
    @brandonnolan6222 2 месяца назад

    Is there a way to add a link into the description? I added the link on the spreadsheet but it didn't import over.

    • @DoITTrainingSBU
      @DoITTrainingSBU 2 месяца назад

      If you use html markup on the link in the description field, it will import as a link. instead of google.com use <a href="google.com">Learn more here</a> where the link in " " after href is the link and the words between > and </a> is the text you want hyperlinked

  • @simeonnovels807
    @simeonnovels807 2 месяца назад

    Thanks so much!

  • @BrittanyRusso-gg5pw
    @BrittanyRusso-gg5pw 2 месяца назад

    What if I have the address listed in another column, is there a way to pull that over into the smart chip automatically?

    • @DoITTrainingSBU
      @DoITTrainingSBU 2 месяца назад

      So far as I know, there's currently no way to do that

  • @dmedilicious8488
    @dmedilicious8488 3 месяца назад

    I would love to go to next question instead

    • @DoITTrainingSBU
      @DoITTrainingSBU 2 месяца назад

      This is the default - no need to use this feature if you want users to go to the next question

  • @abhinaysreeram1
    @abhinaysreeram1 3 месяца назад

    Is it possible to only choose specific columns and rows. . Eg: in the above video i need values of A12,13 and B12, 13 into a separate table

    • @DoITTrainingSBU
      @DoITTrainingSBU 3 месяца назад

      check out the query formula ruclips.net/p/PL6Xrs39_KA2bpNJGr8TFCAZkwCJnmtsuF, perhaps used in conjunction with importrange

    • @abhinaysreeram1
      @abhinaysreeram1 3 месяца назад

      @@DoITTrainingSBU thankq so much...

  • @GD-bh2on
    @GD-bh2on 3 месяца назад

    Thanks a bunch for this! so useful

  • @zenobiapalmyra5670
    @zenobiapalmyra5670 3 месяца назад

    This was awesome. Easy to follow instructions for anyone to follow. Thank you..!!

  • @usamatariq5701
    @usamatariq5701 3 месяца назад

    Informative video works for me 🔥🔥

  • @ontealain
    @ontealain 4 месяца назад

    I wanted to gray out cells of a column regarding of the contents of another column and this helped me to do that Thanks for the Tutorial

  • @ryankudasikHACC
    @ryankudasikHACC 4 месяца назад

    I saw this link recently, but I was pulling my hair out to find it again. Thanks!

  • @jamespersley1838
    @jamespersley1838 4 месяца назад

    Very good. I have been working on a form since January to get exactly what I wanted from it. Everything was pointing to using all these different apps that our district does not have access to. This video just solved my problem. Thank you!

  • @GraysonVoisinet
    @GraysonVoisinet 6 месяцев назад

    Is it possible to create a list with labels? I would like a list that has label for example: Type A : 1, Type B : 2, Type C : 3 So the list will look like above, but once selected, only the value will be displayed because I need those value to make further calculations. Is it possible?

  • @selver1386
    @selver1386 6 месяцев назад

    thx!

  • @hiroyukinumaguchi1984
    @hiroyukinumaguchi1984 6 месяцев назад

    Great!

  • @theafricannomad_
    @theafricannomad_ 6 месяцев назад

    Really helpful, thank you!

  • @saeedekhosravi3112
    @saeedekhosravi3112 6 месяцев назад

    I can't find timeline tabe on google sheet . could you pls guide me?

    • @DoITTrainingSBU
      @DoITTrainingSBU 6 месяцев назад

      Your Google Account likely doesn't have this feature - it's currently only in some Workspace Accounts: support.google.com/docs/answer/12935277?hl=en#zippy=%2Cthese-workspace-editions-can-use-timeline-view

  • @MerrillGF-nq2wh
    @MerrillGF-nq2wh 6 месяцев назад

    I LOVE this! Thank you! In my case, I assign my team or the client to a task in a list of task...I have several tabs representing different types of activities...how do i use this to put the selected client tasks from the different tabs in one "Assigned to Client" list for the client to reference and complete? And same for tasks across all tabs "Assigned to Team?" PLEASE PLEASE PLEASE HELP!

    • @DoITTrainingSBU
      @DoITTrainingSBU 6 месяцев назад

      I find it easier to have one master sheet and separate out from there (rather than having disparate sheets and trying to bring them together). Get your data in one sheet and then use filter views ruclips.net/video/15sjPLLsP4g/видео.html to create separate Editable views of the data, one view for each Client. This is the only way to make separate editable views :)

  • @HaoNguyen-xr2nt
    @HaoNguyen-xr2nt 7 месяцев назад

    Hi thank you so much for your video, it's really helpful. One question: Can we the Timeline combine the information of 2 tabs or more? thanks

    • @DoITTrainingSBU
      @DoITTrainingSBU 7 месяцев назад

      not as is, but if you bring the data together on one sheet, you can create the timeline from that composite

  • @mr.cute.o_o
    @mr.cute.o_o 7 месяцев назад

    Thank you it's helpful in 2024😮😮😮😮

  • @marshmm
    @marshmm 7 месяцев назад

    How can I organize my tasks so that all "in progress" tasks are at the top, then all "not started" tasks are after that, etc. Is there a value to enter somewhere or is there a way to make a custom filter / sort?

    • @DoITTrainingSBU
      @DoITTrainingSBU 7 месяцев назад

      You'd have to sort the sheet/range and it'd be alphabetical. Here's a video on sorting/filtering: ruclips.net/video/idUNKGoiaBc/видео.html (to force the order you want, you could add a number to the status terms that force that order, e.g., 1 In progress, 2 Not started, etc.

  • @shalinsitwala
    @shalinsitwala 7 месяцев назад

    Quick and to the point, very helpful. Thank you!

  • @ShakeebSquare
    @ShakeebSquare 7 месяцев назад

    thanks, really helpful

  • @xotmatrix
    @xotmatrix 7 месяцев назад

    Time to solution: 15 seconds. Thank you!

  • @freddiebiggs990
    @freddiebiggs990 7 месяцев назад

    This video is dope. This is the dopest video I have seen since watching other dope videos.

  • @freddiebiggs990
    @freddiebiggs990 7 месяцев назад

    I am looking to learn how to work my Bright Space

  • @someshchandran4470
    @someshchandran4470 8 месяцев назад

    The most underrated query tutorial on RUclips. I am already using it at my workplace. Thank you.

  • @3dtrip870
    @3dtrip870 8 месяцев назад

    How do you get rid of assignments that linger in the gradebook?

  • @gyorgykerezsi1118
    @gyorgykerezsi1118 8 месяцев назад

    You should have had to start with this: "Availability Available to Google Workspace Essentials, Business Standard, Business Plus, Enterprise Essentials, Enterprise Standard, Enterprise Plus, Education Fundamentals, Education Plus, Education Standard, and the Teaching and Learning Upgrade customers Not available to Nonprofits, and legacy G Suite Basic and Business customers Not available to users with personal Google Accounts " Source: workspaceupdates.googleblog.com/2022/11/timeline-view-google-sheets.html

  • @pikachufan25
    @pikachufan25 9 месяцев назад

    Love the Simple Explanation

  • @liew9533
    @liew9533 9 месяцев назад

    Hi there, may i know how to add a periodical event? Says an event happens once every Tuesday. How to add in?

    • @DoITTrainingSBU
      @DoITTrainingSBU 7 месяцев назад

      You can't add recurring events this way; add the event's first instance and then Google Calendar set its recurrence.

  • @alanbrigham
    @alanbrigham 9 месяцев назад

    What type of account should I have?

  • @balaselvam7024
    @balaselvam7024 9 месяцев назад

    Hey guys I'm trying to find time insights but It's not showing up where you guys are showing it here. Is there a way to set this up?