[Audiobook] Google Workspace

Your workday does not have to be a jumble of lost files, messy permissions, noisy inbox threads, and meetings that start five minutes late. We take you through a full Google Workspace skills tour that turns the toolkit into one connected system, so you can store work once, find it fast, and collaborate without confusion.

We start with Google Drive and the habits that keep teams sane: copying and renaming files, moving folders, using Trash properly, uploading and downloading safely, and finding anything with smart search and filters. From there we get serious about collaboration, covering Google Drive sharing settings, permissions (view, comment, edit), ownership changes, and when publishing to the web is helpful versus risky.

Then we shift into Gmail productivity and communication. We set up vacation responders and desktop notifications, and show how filters, labels, archive, mute, and multiple inboxes can turn your inbox into something you control. We also cover sending email well, including reply versus reply all, forwarding, CC and BCC, plus handling attachments and images without hitting limits.

From meetings to documents to dashboards, we connect the rest of the suite: Google Meet scheduling in Google Calendar, joining by link or code, presenting your screen, managing mic and camera, reducing bandwidth, and dial-in options. We move into Google Chat spaces and moderation, then into Google Docs collaboration with formatting, tables, links, comments, suggesting mode, and version history. Finally, we round out with Google Sheets data management and core functions, and Google Slides design and publishing so your work is ready to share.

Subscribe for more practical Google Workspace training, share this with a colleague who lives in their inbox, and leave a review telling us which tool you want to master next.

Sign up for our self-paced courses or instructor-led workshops at www.ht-a.solutions

Sign up for our self-paced courses or instructor-led workshops at www.ht-a.solutions

Sign up for our self-paced courses or instructor-led workshops at www.ht-a.solutions

Transcript

Copy Transcript Copied

Welcome And Course Roadmap

SPEAKER_01 0:04

Google Workspace. Welcome to our comprehensive course on Google Workspace, your gateway to unlocking the full potential of Google's suite of productivity tools. In today's dynamic and interconnected world, effective collaboration and seamless communication are essential for success in both personal and professional endeavors. Google Workspace offers a versatile array of cloud-based applications designed to streamline workflow, enhance teamwork, and boost productivity across various domains. Overall, Google Workspace plays a crucial role in modernizing workplace productivity, fostering collaboration, and empowering organizations to adapt to the evolving digital landscape. Its comprehensive suite of tools, combined with its emphasis on security, scalability, and flexibility, makes it an indispensable platform for businesses seeking to thrive in today's competitive environment. Research has consistently demonstrated that when clear goals are associated with learning, it occurs more easily and rapidly. With that in mind, let's review our goals for today. At the end of this workshop, participants should be able to create, manage and share files and folders, personalize and manage a Gmail account, schedule and launch a Google Meet, set up, edit, and collaborate on documents online, understand the essential features and capabilities of Google Sheets, understand Google Slides and the various design techniques.

SPEAKER_00 1:34

There are no secrets to success. It is the result of preparation, hard work, and learning from failure.

Google Drive File Management Basics

SPEAKER_01 1:42

This module will familiarize students with Google Drive, a cloud-based storage solution. We'll cover file and folder creation and management, adjusting settings and views, and the sharing procedure for documents. Copying a file in Google Drive is simple and easy to do. Here's how. First, open Google Drive by navigating to it in your web browser. Sign in with your Google account if you aren't already logged in. Next, locate the file you want to copy. You can either navigate through your folders in the My Drive tab or use the search bar at the top to find it quickly. Once you've found the file, click on it to select it. This will highlight the file and you'll be ready to take action. To copy the file, right-click on it or click the three-dot menu next to the file name to open a drop-down menu. Select Make a Copy from the Options. Alternatively, you can press Cetrol plus C on Windows or CMD Plus C on Mac to copy the file. After making the copy, you'll find it in the same folder as the original file. Google Drive will automatically add copy of to the copied file's name to distinguish it from the original. If you'd like to rename the copied file, right-click on it, select rename, and type in your desired name. Moving items to the trash in Google Drive is a simple process. Here's how to do it. First, locate the file or folder you want to delete. You can navigate through your folders or use the search bar at the top to find the item quickly. Once you've found the file, click on it to select it. This will highlight the item and allow you to take action. To move the item to the trash, right-click on it, or click the three-dot menu icon next to the item name. From the drop-down menu, select remove or move to trash. Alternatively, you can press the keyboard shortcut Shift plus T to move the item to the trash. If prompted, confirm that you want to move the item to the trash. To access items in the trash, click on Trash on the left sidebar of Google Drive. This will display all items that have been moved there. From the trash, you can either restore items to their original location or permanently delete them. To restore an item, right-click on it and select Restore. To permanently delete an item, right-click on it and select Delete Forever. To download a file from Google Drive to your computer, start by locating the file you want. Once you find it, click on the file to select it. Afterward, right-click on the file or click the three dot menu next to the item name and choose download. Alternatively, you can use the keyboard shortcut Cuttrel plus S or CMD plus S on Mac to begin the download. Your browser will usually prompt you to select where you want to save the file on your computer. Choose the desired location and click Save or OK to begin the download. The time it takes will depend on the file size and your internet connection speed with a progress indicator in your browser showing the download status. Once the download is complete, open your file explorer, like File Explorer on Windows or Finder on Mac and navigate to the location where you saved the file. You should find it there, ready for use. To upload a file from your hard drive to Google Docs, start by opening Google Docs in your web browser and signing in with your Google account if you're not already logged in. Then, click on the plus new button in the top left corner of the screen. From the drop-down menu, select File Upload. This will open a File Explorer window on your computer. Navigate to the location on your hard drive where the file is saved, select the file and click Open or your computer's equivalent. Google Docs will begin uploading the file to your Google Drive. The upload time depends on the file size and your internet connection speed, and a progress indicator will show the status. Once the upload is complete, the file will be available in your Google Drive, typically found in the My Drive section or the folder where you uploaded it. You can then access and edit the file directly in Google Docs. To move folders in Google Drive, follow these simple steps. Start by opening Google Drive in your web browser and signing in with your Google account if you're not already signed in. Next, locate the folder you want to move. You can browse through your folders or use the search bar to find it. Once you've found the folder, click on it to select it. To move the folder, you can either drag and drop it into the desired location within Google Drive or use the Move option. To use this option, right-click on the selected folder or click the three-dot menu icon and select organize, then choose Move from the menu. A list of available destination folders will appear. Select the one where you want to move the folder. After choosing the destination folder, confirm the move. The folder will then be relocated to the new location within your Google Drive. This simple process helps you keep your files and folders well organized in Google Drive. Renaming files in Google Drive helps keep your files organized and makes them easier to identify. Here's how to rename a file. First, locate the file you want to rename. You can browse through your folders or use the search bar to find it quickly. Once you've found the file, click on it once to select it. This will highlight the file and allow you to take action. To rename the file, either right-click on it or click the three dot menu icon and select rename, or click the file name once more, not the extension, to edit the name directly. Type the new name for the file. Make sure to keep the file extension, such as .docs for a word document or PDF for a PDF, unchanged unless you intend to change the file type. After typing the new name, press OK or hit the enter key to confirm the renaming. Your file will now have the updated name. Removing or deleting folders helps keep your Google Drive organized by clearing out unnecessary clutter. Just be sure to double-check before deleting as items moved to the trash can be permanently deleted from there. To delete a folder, start by locating it. You can browse through your folders or use the search bar to find it quickly. Once you've found the folder, click on it once to select it. This will highlight the folder and make the deletion options available. To delete the folder, right-click on it or click the three-dot menu icon and select Move to Trash from the menu. Alternatively, you can simply press the Delete key on your keyboard. Google Drive will typically ask you to confirm the deletion. Confirm that you want to move the folder to the trash. If you want to permanently delete the folder, go to the trash section of Google Drive. Locate the deleted folder, right-click on it, and choose Delete Forever, or click on the folder and then click Delete Forever at the top. Uploading folders from your hard drive to Google Drive is a simple way to store and organize your files in the cloud. Here's how to do it. First, open Google Drive and click on the plus new button in the top left corner of the screen. From the drop-down menu, select Folder Upload. A file explorer window will appear on your computer. Navigate to the folder you want to upload, click on it to select it, and then click Open or the equivalent option on your computer. Google Drive will begin uploading the selected folder and all of its contents. The time this takes depends on the folder's size and your internet connection speed, and you'll see a progress indicator showing the upload status. Once the upload is complete, the folder will be available in your Google Drive. You can find it in the My Drive section or in the folder where you initiated the upload.

Finding Organising Syncing Drive Files

SPEAKER_01 9:15

By following these steps and using the search features of Google Drive effectively, you can quickly locate the files and documents you need within your Drive storage. First, navigate to the search bar at the top of the page. It may show placeholder text saying search in Drive when you're logged in. Click on the search bar and type in your search query. You can search by file name, keywords, or even specific phrases within documents. If needed, you can use filters to narrow down your search results. Google Drive allows you to filter by file type owner, date modified, and more. To access these filters, click on the arrow icon V at the right end of the search bar after entering your query. After typing your query and applying any filters, press Enter or click the magnifying glass icon to begin the search. Google Drive will then display files and documents that match your criteria. You can preview files directly from the search results by clicking on them. To open a file, simply click its name and it will open in a new tab or window based on your browser settings. If your search doesn't give the expected results, you can refine your query by adding additional keywords or adjusting the existing ones. To clear your search and return to your full list of files, click on the X icon within the search bar. For advanced searching, Google Drive supports search operators to help refine your results. For example, typing type document will narrow the search to only documents, or ownerMe will find files owned by you. You can view more search operators by clicking the question mark icon in the search bar. The recent tab in Google Drive is a section that shows files and documents you've accessed or modified recently. It's a convenient way to quickly find files you've been working on without having to navigate through your folders. Here's how the Recent tab works and its main features. The Recent tab is located on the left-hand side menu of Google Drive, next to sections like MyDrive, Computers, Shared With Me, and Stard. It's easy to access from any page within Google Drive. In the Recent tab, you'll see a list of files and documents organized in reverse chronological order. The most recently accessed or modified files will appear at the top of the list. For each file in the Recent tab, you can perform various actions such as opening the file, sharing it with others, moving it to a different folder, or using additional options from the 3Dot menu icon. You can also preview files directly in the Recent tab by clicking on them. This lets you quickly glance at the file's content without needing to open it in a new window. Although the Recent tab primarily displays your most recent files, you can still search for specific files within it using the search bar at the top of the page. This can be especially helpful if you're trying to find a specific file among your recent activities. The files in the Recent tab are synced across all devices where you're signed in with the same Google account. Whether you access Google Drive from your computer, smartphone, or tablet, you'll see the same list of recent files. Finally, the Recent tab typically shows files that have been accessed or modified within a certain time frame, usually ranging from a few hours to a few weeks, depending on your usage and activity in Google Drive. The Shared With Me tab in Google Drive is a section dedicated to files and folders that other users have shared with you. It provides easy access to content shared directly with your Google account, either by other users within your organization or external collaborators. The Shared With Me tab is located in the left-hand sidebar of Google Drive, beneath sections like MyDrive, Recent, and Stard. In this tab, you'll see a list of files and folders shared with you by others. The items are organized based on the user who shared them and may include individual files, entire folders, or files within shared folders. The files and folders in the Shared With Me tab retain the original permissions set by the owner when they were shared. Depending on these permissions, you may be able to view, comment on or edit the shared content. For each item in the Shared With Me tab, you can perform various actions such as opening the file, adding it to your own drive for easier access, making a copy or moving it to another folder. If you have the appropriate permissions, you can also collaborate with others directly from this tab. This includes commenting, suggesting edits, and real-time collaboration using Google Workspace applications like Google Docs, Sheets, and Slides. You can use the search bar at the top of the page to search for specific files or folders within the Shared With Me tab, which can be especially helpful if you have many shared files. The files and folders in this section are synced across all devices where you're signed in with the same Google account so you can access shared content no matter what device you're using. Google Drive offers sync settings that allow you to control how files and folders are synchronized between your Google Drive account and your computer or other devices. These settings ensure that your files are always updated and accessible across all your devices. To use Google Drive on your desktop, you'll typically need the Google Drive Desktop Application or the Sync feature, which lets you access your Google Drive files directly from your computer's file system. First, install the Google Drive Desktop application by downloading it from the Google Drive website. Follow the installation instructions provided. Once installed, you'll find the Google Drive icon in your system tray on Windows or menu bar on Mac. After installation, sign in with your Google Account credentials to link your Google Drive storage to the desktop application. During setup or through the app settings, you can choose which folders from your Google Drive to sync with your computer. This allows you to access these files directly from your computer's file explorer, Windows Explorer or Finder on Mac. You can also configure other settings like sync frequency, bandwidth usage, and offline access preferences. You can select specific folders on your computer to sync with Google Drive. This means only the selected folders will be synchronized, helping you manage storage space more efficiently and avoid syncing unnecessary files. You can set the sync frequency to determine how often Google Drive checks for changes between your computer and your Google Drive account. Options include real-time syncing or scheduled syncing at set intervals such as every hour. Google Drive also allows you to limit bandwidth usage for syncing. This helps prevent excessive data usage and ensures that other online activities are not disrupted. Once syncing is complete, you'll be able to access your Google Drive files directly from your computer's file system. On Windows, you'll find a folder named Google Drive in File Explorer. On Mac, it will appear in Finder. Any changes made in this folder will automatically sync with your Google Drive account and vice versa. You can manage your files just like you would with any other files on your computer. Create new folders, upload files, delete items, rename files, and organize your content. These changes will be reflected in your Google Drive account. Google Drive also offers offline access to files stored in your Drive account. With offline access enabled, you can view, edit, and create Google Docs, Sheets, and Slides even when you're not connected to the internet. Once you reconnect, changes made offline will sync automatically. You can preview offline files by selecting the check mark in the top right corner. Google Drive offers multi-level organization tools to help you manage your files and folders more effectively. By customizing the viewing settings and options, you can organize your files in a way that enhances your productivity and workflow. Feel free to experiment with different settings to find the setup that works best for you. Google Drive gives you two main ways to view your files and folders grid view and list view. These views provide different visual formats, letting you choose the one that suits your preferences and how you like to organize and access your content. Google Drive offers various settings and options for viewing files and folders within your Google Drive account. These settings allow you to customize the display and organization of your files to suit your preferences and workflow. Google Drive offers offline settings that allow you to access and work on your files even when you're not connected to the internet. These settings enable you to view, edit, and create Google Docs, Sheets and Slides without an internet connection, helping you stay productive in offline environments. To enable offline access, start by opening Google Drive in your web browser. Click on the gear icon at the top right corner to access the settings menu. From the drop-down menu, select Settings. In the settings menu, go to the General tab and find the offline section. Check the box beneath offline to enable offline usage. Once you've enabled offline access and synced the files you want to use offline, you can work on them even without an internet connection. Any changes made offline will be saved locally on your device and automatically synced with your Google Drive account once you're back online. These offline settings ensure seamless access to your files, allowing you to maintain productivity even when you don't have an internet connection. Google Drive provides notifications to keep users informed about activities related to their files and folders. These notifications ensure you're updated on changes, comments, and collaboration efforts within your Google Drive account. To customize your notification settings, open Google Drive in your web browser and click the gear icon at the top right corner to access the settings menu. From the drop-down menu, select settings. In the settings menu on the left-hand side, choose the Notifications tab. Here you can select whether you want to receive notifications via browser or email by checking the appropriate boxes in each section. The drop-down menu in Google Drive allows users to sort their folders based on specific criteria like recent modifications or activity. By using these sorting options, you can better manage and prioritize your files and folders. To access the drop-down menu, simply view your folders in Google Drive. You'll find the sorting options near the top of the page. Clicking on the drop-down menu will display a list of sorting criteria that you can choose from. By selecting the sorting option that suits your needs, such as sorting by modification date or activity, you can easily identify which folders have been recently updated or accessed. This feature helps keep your files organized and accessible. Once you've added files and folders to your Google Drive, they become accessible from any device with Internet access where you can log into your Google Drive account. You can easily organize, share, and collaborate on your files and folders as needed. To add files to Google Drive, you have a couple of options. First, you can use Drag and Drop. Open Google Drive in your web browser. Navigate to the folder where you want to add the file or go to the root of your drive. Locate the files on your computer, then click and hold the file to drag it from your computer into Google Drive. Alternatively, you can use the new button. Click the new button at the top left of the screen, then select File Upload from the drop-down menu. Choose the files you want to add from your computer and click Open or Upload. To add folders, you can again use the new button. Click New at the top left, then select Folder Upload from the drop-down menu. Choose the folder as from your computer that you want to add to your drive and click Open or Upload. You can also create a new folder directly within Google Drive. Navigate to the location where you want to create the new folder, right. Click on an empty space in the folder and select New Folder from the menu. Enter the folder name in the dialog box, then press Enter or click the Create button.

Sharing Permissions Ownership Publishing

SPEAKER_01 21:18

In Google Drive, ownership of a file or folder is typically assigned to the user who originally created it. However, users with the right permissions can transfer ownership of files and folders to other users within their organization. To assign ownership, start by opening Google Drive in your web browser and selecting the file or folder you want to transfer. Right-click on the item to open the context menu, then select the Share option. In the sharing settings window, enter the email address of the person you want to transfer ownership to. Click the drop down menu beside their email address to adjust the access control settings. To remove ownership, open Google Drive in your web browser and select the file or folder. Right click to open the context menu and choose Share. In the Sharing Settings window, find the person from whom you want to remove ownership. Click the drop-down menu next to their email and select Remove Access. By following these steps, you can easily assign or remove ownership of files and folders in Google Drive, which helps improve collaboration and responsibility delegation. Google Drive provides a comprehensive set of permission settings, allowing users to control who can access, view, edit, and share their files and folders. These settings ensure secure and efficient collaboration while maintaining control over your documents. Users with view access can see the contents of the file or folder but cannot make any changes. They can read the document and leave comments, but editing is not allowed. Users with comment access can view the document and leave comments, but they cannot modify the content. They can provide feedback through comments. Those with edit access can view, edit, and make changes to the document. They have full control over the content of the file or folder. The owner of a file or folder has complete control, being able to view, edit, share, manage permissions, and transfer ownership to others. Google Drive also provides several sharing options. With specific people sharing, users can share files and folders with specific individuals by entering their email addresses. This allows precise control over who has access. Alternatively, users can generate a link sharing option, providing a shareable link to the file or folder. Depending on the permission settings, those with the link can view, comment, or edit the document. For more public sharing, users can make files and folders public access, allowing anyone on the internet to access them. This is particularly useful for sharing publicly available documents such as websites or resources. Additionally, users can set options to prevent copying of files or folders to protect sensitive information. This can be done by selecting the settings option under the shared access location and checking the box to update the access controls, ensuring the content remains under control. Publishing to the web on Google Drive lets you make files such as Google Docs, Sheets, Slides, or other compatible file types accessible to anyone on the internet via a unique URL. This feature is useful for sharing documents, presentations, or spreadsheets with a wider audience without requiring viewers to have a Google account. To publish a file, start by opening the file in Google Drive. This could be a Google Docs document, Google Sheets Spreadsheet, Google Slides presentation, or another compatible file type. Next, click on the file menu at the top left corner of the screen. From the drop-down menu, select Publish to the Web. This option may vary slightly depending on the type of file you're working with. Once you click Publish to the web, you will typically see two tabs, Link and Embed. Under the Link tab, you can click the Publish button to generate a link to a web page where the document can be viewed. Depending on the type of file, you might have additional options to customize the publishing settings. For example, you can decide whether viewers can only view the document or also edit it. There may also be an option to automatically republish the document when changes are made. By using these options, you can easily share your files with a broader audience while maintaining control over the content.

SPEAKER_00 25:30

Anyone who has never made a mistake has never tried anything new. Albert Einstein.

SPEAKER_01 25:37

This module will familiarize students with Gmail, a free web-based email service provided by Google. We'll cover

Gmail Settings Vacation Notifications Language

SPEAKER_01 25:43

the personalization of settings, managing an inbox, managing and communicating with contacts, and locating messages. Setting up a vacation responder in Gmail is easy and ensures that people who email you while you're away are informed. Here's how to set it up. First, sign in to Gmail by opening your web browser and going to Gmail. Enter your Google Account credentials if you're not already signed in. Once you're in your Gmail inbox, look for the gear icon in the top right corner and click on it. A drop-down menu will appear. Select See All Settings from the menu. In the Settings menu, you'll see several tabs at the top. Click on the General tab. Scroll down to the bottom of the page to find the Vacation Responder section. To activate the Vacation Responder, check the box labeled Vacation Responder on. Next, set the start and end dates for your Vacation Responder. Click on the calendar icon next to first day to select the start date and do the same for last day to select the end date. Then, compose your message in the text box provided. This is the message that will be sent as your vacation response. Customize it to let people know you're away, when you'll return, and any other relevant information such as who to contact in your absence. If you'd like, you can also set a subject for your vacation response. This is useful to make it clear that the reply is automated. Once you've set everything up, scroll to the bottom and click on Save Changes to activate the Vacation Responder. Your vacation responder is now set up. Anyone who emails you during the specified dates will receive your automated reply. Don't forget to turn off the vacation responder when you return by following the same steps and unchecking the Vacation ResponderOn checkbox. Setting up desktop notifications in Gmail allows you to receive pop-up alerts on your computer whenever a new email arrives. Here's how you can set it up. Start by signing into Gmail. Open your web browser, go to Gmail and sign in with your Google Account credentials if you're not already signed in. Once you're in your Gmail inbox, locate the gear icon in the top right corner and click on it. From the drop-down menu that appears, select See All Settings. In the Settings menu, click on the General tab. Scroll down until you find the Desktop Notifications section. You'll see three options. The first option, New Mail Notifications On, will alert you to all incoming emails. The second option, Important Mail Notifications On, will notify you only for emails that Gmail marks as important. The third option, Mail Notifications Off, disables all desktop notifications. Choose the option that best suits your preference. If you want to receive notifications for all emails, select New Mail Notifications On. If you prefer notifications only for important emails, select Important Mail Notifications On. To turn off notifications entirely, choose Mail Notifications Off. After selecting your preferred notification setting, scroll to the bottom of the page and click Save Changes. Depending on your browser, you may need to grant Gmail permission to show notifications. If prompted, click Allow or Yes to enable desktop notifications. To test the notifications, you can ask someone to send you an email or send an email to yourself from another account. If everything is set up correctly, you should receive a pop-up notification when a new email arrives in your inbox. Now you've successfully set up desktop notifications in Gmail, ensuring you never miss an important email again. Personalizing language and display preferences in Gmail is a simple process. Start by signing in to Gmail. Open your web browser, go to Gmail and sign in with your Google Account credentials if you're not already signed in. Once you're in your Gmail inbox, locate the gear icon in the top right corner and click on it. From the drop-down menu that appears, select See All Settings. In the Settings menu, click on the General tab. Scroll down until you find the language section. Here, you'll find options to change the display language of your Gmail interface. Click on the drop-down menu next to Gmail Display Language and select your preferred language. Gmail supports a wide range of languages, so you should be able to find the one you want. Once you've selected your language, scroll to the bottom of the page and click Save Changes. Gmail will automatically refresh and you'll see the interface displayed in your chosen language. That's it. You've successfully changed the language and display preferences in Gmail, making it easier for you to navigate and use Gmail in your preferred language. Gmail offers powerful features for managing your email, including applying filters and blocking addresses. Here's

Filters Labels Archive Mute Multiple Inboxes

SPEAKER_01 30:26

how you can use these features. To apply filters, start by signing into Gmail. Open your web browser, go to Gmail and sign in with your Google Account credentials if you aren't already signed in. Once you're in your inbox, look for the gear icon in the top right corner and click on it. A drop-down menu will appear. Select See All Settings from the menu. In the Settings menu, click on the Filters and Blocked Addresses tab. To create a new filter, click on the Create a New Filter link. In the filter creation form, you can specify filter criteria such as the sender, recipient, subject, keywords, and more. Once you've defined your criteria, click on the Create Filter button. After creating the filter, Gmail will prompt you to choose the action you'd like to apply to emails that match your filter. You can choose to apply a label, mark as important, mark as read, archive, delete, or forward the emails that meet the criteria. If you want to edit or delete existing filters, go back to the filters and blocked addresses tab. Find the filter you want to modify and click on the edit or delete link next to it. To block an address in Gmail, open the email from the sender you want to block. In the email, click on the three dots in the top right corner of the message. From the menu that appears, click on Block Sender's name. Gmail will confirm that you want to block emails from that address. Confirm the action by clicking Block in the confirmation pop-up. If you ever want to unblock an address, return to the Filters and Blocked Addresses tab in the settings menu. Scroll to the Blocked Addresses section, find the address you want to unblock, and click the Unblock link next to it. Gmail will ask you to confirm that you want to unblock the address. Click the Unblock button to confirm. Once blocked, any emails from that address will automatically be sent to your spam folder. You can always unblock it later by following the same steps and clicking unblock next to the address. Archiving messages in Gmail is a handy way to declutter your inbox without deleting emails permanently. Here's how you can archive emails. First, sign in to Gmail by opening your web browser and going to Gmail. If you're not already signed in, use your Google Account credentials to log in. Once you're in your Gmail inbox, locate the email you want to archive. You can either click on the email to open it or select the checkbox next to it if you want to archive multiple emails. To archive an individual email, click on the email to open it. Once it's open, look for the archive button in the toolbar menu. If you want to archive multiple emails at once, select the checkboxes next to the emails you want to archive. Once you've selected them, look for the archive button at the top of the inbox and click on it to archive the selected emails. For those who prefer using keyboard shortcuts, you can archive emails by pressing the E key on your keyboard when an email is selected. Archived emails are not deleted, they are moved out of your inbox. You can still access them later. To view archived emails, click on the All Mail label on the left sidebar of your Gmail interface. This will show all emails in your account, including archived ones. If you're looking for a specific archived email, you can use the search bar at the top of Gmail. Type in keywords, the sender's name, or any other relevant information to search through your archived messages. To unarchive an email and move it back to your inbox, locate it in the All Mail view or search for it. Once you find the email, open it and click on the Move to Inbox button at the top to unarchive it. That's it! You've successfully archived messages in Gmail. Archiving is an excellent way to keep your inbox organized while still retaining important emails. Muting in Gmail is a feature that allows you to silence or suppress email threads you're not interested in or don't want to receive notifications for. When you mute a conversation, it moves the thread out of your inbox and automatically archives future replies to that thread. To mute a conversation, start by signing into Gmail in your web browser. Once you're signed in, locate the email conversation or thread you want to mute in your inbox. Next, select the conversation by clicking the checkbox next to the emails you want to mute. If the thread has several replies, you can select multiple emails. After selecting the conversation, click the More button to open the drop-down menu, then choose the mute option. Once muted, Gmail will confirm that the conversation has been muted. From now on, future replies to this conversation will be automatically archived and you won't receive any notifications for them. If you need to access muted conversations later, you can find them in the All Mail label or by searching for them using Gmail's search feature. To unmute a conversation and start receiving notifications for it again, locate the conversation in your inbox, open it, and click on the Unmute option. This will move the conversation back to your inbox and you'll start receiving notifications for new replies. Muting is particularly useful for group email threads or conversations you're not actively participating in, but still want to keep for reference without cluttering your inbox or being disturbed by notifications. 4.0 Mini. Multiple inboxes in Gmail is a feature that allows you to divide your inbox into multiple sections based on different criteria such as labels, categories, or specific search queries. Each section functions like a separate inbox, displaying emails that meet the specified criteria. This feature helps you organize and manage your emails more efficiently. To set up multiple inboxes, start by signing into Gmail. Once you're logged in, click on the gear icon in the top right corner to access the settings menu. From the drop-down menu, select See All Settings. Next, click on the Inbox tab in the Settings menu. Here, locate the Inbox type drop-down menu and choose Multiple Inboxes. Now decide how many additional inboxes you want to add. You can add up to five additional inboxes alongside your primary inbox. For each additional inbox, specify criteria like labels, categories, or search queries to filter the emails that appear in that section. You can also customize the name and positioning of each section. Once you've configured the settings, scroll down and click Save Changes. After saving, Gmail will refresh and the new inbox sections will appear in your Gmail interface. You can access them by clicking on the corresponding tabs or sections. If you need to make changes, you can always go back to the Multiple Inboxes section in Gmail Settings to customize and manage your inboxes. With multiple inboxes set up, organizing and prioritizing your emails based on specific criteria becomes much easier, helping you stay on top of your inbox and improve email management. Composing in Gmail refers to the process of creating and sending new emails, where you craft your messages, add recipients, subject lines, and any attachments before sending them out. Start by signing into Gmail through your web browser. Once you're logged in, look for the Compose button in your Gmail inbox. This button is usually located in the top left corner of the screen and is represented by a pencil icon or the word Compose. Click on it to open a new email composition window. Next, in the To field of the composition window, enter the email address of the recipient. If you're sending the email to multiple recipients, you can separate their email addresses with commas. In the subject field, add a brief and descriptive subject line for your email to let the recipient know what it's about. Now type your message in the body of the email. You can format your text using various options from the toolbar such as bold, italic underline, font color, and more. You can also add links, bullet points, and numbered lists if needed. If you'd like to attach files to your email, click on the paperclip icon in the toolbar. This allows you to upload files from your computer or choose files from Google Drive to attach. To insert images directly into your email, click on the image icon in the toolbar. You can then upload an image from your computer or select one from Google Drive. Before sending your email, check for any spelling or grammatical errors. You can do this by clicking on the More icon in the toolbar and selecting the check spelling option. Once you're ready to send the email, click the send button, which is typically located at the bottom of the composition window. Your email will be sent to the recipients. If you're not ready to send the email, you can save it as a draft. Simply click the close button X in the top right corner of the composition window. Gmail will automatically save your draft and you can access it later from the drafts folder in your Gmail account. That's it! You've successfully composed and sent an email in Gmail. You can repeat this process whenever you need to send a new email. Replying and reply all are two common actions in Gmail when responding to emails. When you want to respond only to the sender of an email, use the reply function, which is located in the top right corner of the email. This option ensures that your response is sent solely to the sender. If the email was sent to multiple recipients and you want to reply to everyone involved, use the reply all function. You'll find this option under the More section of the email. It's important to choose the correct option, reply when responding to just the sender, and reply all when addressing everyone included in the email. Be mindful when using reply all to avoid sending unnecessary emails to recipients who may not need to be included in the conversation. Forwarding emails in Gmail allows you to share an email you've received with others. To get started, first sign into your Gmail account by opening your web browser and going to Gmail. Once you're signed in, navigate to the email you want to forward in your inbox and open it. In the email, look for the forward button, which is represented by an arrow pointing forward. This can usually be found in the More section in the top right corner of the email. After clicking on the forward button, enter the recipient's email address in the To field. If you want to forward the email to multiple recipients, separate their email addresses with commas. Once you've added the recipient and composed any additional message, click the send button to forward the email. That's it. You've successfully forwarded an email in Gmail. The recipients will receive the forwarded email along with any message you included. CCing or carbon copying in Gmail is a feature that allows you to include additional recipients in an email without making them the primary recipients. It's commonly used when you want to keep someone informed about the email conversation without directly addressing them. To begin, compose a new email by clicking on the Compose button in the top left corner of your Gmail inbox. Next, in the To field of the composition window, enter the email address as of the primary recipients. These are the main recipients that the email is addressed to. To add additional recipients, click on the CC option, located to the right of the to field. If it isn't visible, clicking on CC will reveal the field. Enter the email address ease of the people you want to include as CC recipients. Compose your message in the body of the email, adding text, formatting, and any attachments or links. Once you've finished composing your email and adding the necessary recipients in both the two and CC fields, click Send to send the email. When you CC someone in Gmail, they will receive a copy of the email along with any attachments or links. Their email address will be visible to other recipients, but they are not considered the primary recipients, so they may not feel directly responsible for responding. Typically, CC recipients are included for informational purposes, to keep them in the loop without cluttering the primary recipient's inbox. CCing is especially useful for group emails or when you want to involve someone in a conversation without making them the focal point. BCC or blind carbon copy allows you to include additional recipients in an email without revealing their email addresses to other recipients. It's commonly used when you want to keep someone informed about the email conversation without directly addressing them or disclosing their identity to others. To begin, compose a new email in Gmail by clicking on the Compose button located in the top left corner of your Gmail inbox. Next, in the To field, enter the email address of the primary recipients. These are the main recipients who the email is addressed to. In Gmail, the BCC field is not immediately visible by default. To access it, click on BCC, which is located next to CC. This will reveal the BCC field where you can enter the email address as of additional recipients you want to BCC. Enter the email address, ease of the recipients you want to BCC in the email. Unlike the TO and CC fields, the email addresses entered in the BCC field will be hidden from all other recipients of the email. Compose your message in the body of the email, adding text, formatting, and any attachments or links as needed. Once you've finished composing your email and adding recipients to the two and BCC fields, click Send to send the email. When you BCC someone in Gmail, they will receive a copy of the email along with any attachments or links. Their email address will be hidden from other recipients, and other recipients won't be aware that the BCC recipient has been included in the email. BCC recipients are typically included for informational purposes or to keep them informed about the conversation without disclosing their identity to others. Using BCC is a common practice to maintain privacy and confidentiality when sending emails to multiple recipients, especially in situations where you want to. Keep certain recipients' identities hidden from others. Launching a text chat in Gmail allows you to have real-time conversations with your contacts directly within the Gmail interface.

Composing Replies CC BCC Attachments

SPEAKER_01 44:21

First, sign in to Gmail by opening your web browser and going to Gmail. If you're not already signed in, use your Google account credentials to log in. Next, access the settings by looking for the gear icon in the top right corner of your inbox. Click on the icon and from the drop-down menu select See All Settings. Navigate to the Chat and Meet section where you'll find the option to enable Google Chat. Select the Google Chat field and then click Save Changes. Once Google Chat is enabled, you'll see a small chat icon in the left-hand toolbar of your Gmail interface. The icon looks like a speech bubble with a quotation mark inside. Click on this chat icon to open Google Chat. Clicking the chat icon opens the Google Chat sidebar within Gmail. You'll see a list of your contacts who are online and available to chat. To find a contact, scroll through the list or use the search bar at the top to search for them by name or email address. Google Chat offers various features such as emojis and file sharing. You can use the icons at the bottom of the chat window to access these features. If you need more options, click on the three dots next to the contact's name to start a video call, create a group chat, or view the contacts profile. When you're finished chatting, close the chat window by clicking the X icon in the top right corner. Launching a text chat in Gmail is a convenient way to communicate with your contacts without leaving your inbox, especially for quick conversations or real-time collaboration. Launching a video call in Gmail allows you to have face-to-face conversations with your contacts directly within the Gmail interface using Google Meet. To begin, sign in to Gmail by opening your web browser and going to Gmail. If you're not already signed in, use your Google account credentials to log in. Next, in the left-hand toolbar of the Gmail interface, you'll see a small video icon. Click on this icon to open Google Meet. Once in Google Meet, under the Meet section, click on the New Meeting tab. Google Meet will generate a code for you to share with others for the meeting. If you need to join a scheduled meeting, look for the Join with a Code tab in the Google Meet sidebar and click on it. Then, enter the meeting code or nickname to join the meeting. To invite participants to the meeting, click on the Send Invite button once the meeting window is open. You can enter email addresses directly or copy and share the meeting link with them. When you're ready to start the video call, click the Start Now button in the meeting window. This will launch the video call, allowing you to see and hear the other participants. During the call, you can manage various settings such as muting or unmuting yourself, turning your camera on or off and adjusting the video quality as needed. When you're finished with the call, you can simply close the Google Meet tab or click on the End Call button within the meeting interface to end the call. Sharing a file in Gmail is a straightforward process. Start by opening Gmail and clicking on the Compose button to create a new email. In the New Email window, you'll see various options at the bottom, including a paperclip icon for attaching files or a link icon for attaching links. To attach a file, click on the paperclip icon. This will prompt you to select the file you want to attach from your computer. A file explorer window will open, allowing you to navigate to the location of the file. Once you've found the file, select it and click open or attach depending on your operating system. After selecting the file, its name will appear as an attachment in the email composition window. You can attach multiple files by repeating the process. To attach a link, click on the link icon. This will prompt you to type in or paste the link you want to attach. Next, compose your email by adding the recipient's email address, subject, and any additional text you want to include. Once you've attached the file and written your message, click on the Send button to send the email with the attached files. Before sending, it's a good idea to double check that the files you intended to attach are included. You can do this by reviewing the attachments listed below the email composition area. When the recipient receives your email, they will be able to download the attached files by opening the email and clicking on the attachment link as provided. And that's it! You've successfully shared a file in Gmail. Keep in mind that Gmail has a file size limit of 25 MB for attachments. If your file is too large, you may need to use Google Drive to share it instead. Inserting images into a Gmail email is a simple and straightforward process. Start by opening Gmail and clicking on the Compose button to create a new email. In the email composition window, place your cursor where you want the image to appear within the body of the email. At the bottom of the email composition area, you'll find a toolbar with various formatting options. Look for the icon that resembles a mountain landscape or a camera which represents the insert image option and click on it. After clicking on the Insert Image icon, a window will appear, allowing you to choose the source of the image you want to insert. You can upload an image from your computer by clicking on the Upload tab and selecting the file from your computer's file explorer. If the image is stored in Google Drive, you can access it by clicking on the Photo or Album tab. Alternatively, you can insert an image by providing the URL of an image hosted online by clicking on the Web Address URLS tab and pasting the image URL. Once you've chosen the image, you can decide whether you want it inserted inline at the location of your cursor or as an attachment to the email. After making your selections, click the insert button. If needed, you can adjust the image size by clicking on the image and dragging its corners to resize it. You can also reposition the image within the email by clicking and dragging it to your desired location. When you're satisfied with your email, click the Send button to send it with the inserted image. And that's it! Your image is now included in your Gmail message. Searching and sorting your inbox in Gmail helps you quickly find specific emails and organize your messages efficiently. To begin, use the search bar at the top of your Gmail inbox. Click on it and start typing your search query. You can search by sender, recipient, subject, keywords, or any other relevant information. Gmail will display results as you type, filtering your emails based on the search criteria. You can further refine your search by using advanced search operators like from, to, subject, label, file name, and more. Press enter or click on the magnifying glass icon to execute the search. In Gmail's All Mail, you can sort your inbox by various criteria such as date, sender, size, and more. To sort your inbox, simply select one of the sorting options at the top of the All Mail screen, and Gmail will rearrange your emails according to your chosen criteria. Filters in Gmail allow you to automatically sort incoming emails based on specific criteria. To create a filter, click the filter button at the end of the search bar to open advanced search options. Enter your search criteria, then click Create Filter. You can choose actions such as applying a label, marking emails as important, archiving, or forwarding. Once you've set your preferences, click Create Filter to save the filter. Labels in Gmail work like folders and help you categorize and organize your emails. To apply a label, select the emails you want to label and click the label icon at the top of your inbox. You can either select an existing label or create a new one. After labeling your emails, you can access them by clicking on the label name in the left sidebar. These features help you search, sort, and organize your Gmail inbox effectively, ensuring a more efficient email management experience. In Gmail, the SEN folder contains copies of the emails you've sent to others. When you send an email from your Gmail account, a copy is automatically stored in the SEN folder. To access it, click on SENT in the left sidebar of the Gmail interface. This will display a list of emails you've sent, organized by date and time. In the SEN folder, you can view the subject, recipient's date, and time sent, as well as the content of each email. Gmail displays send emails as conversations, just like incoming emails, so you can easily see the entire thread of communication. You can also use the search bar at the top of Gmail to find specific emails you've sent. Enter keywords, sender, recipient, or any other relevant information to locate the email you're looking for. Managing sent messages is just like managing any other emails in Gmail. For instance, you can forward a sent email, reply to it, or move it to a different folder, such as an archive or a label, for further organization. You can also delete sent emails if you no longer need them. Deleting a sent email only removes it from your sent folder and does not affect the recipient's copy. Gmail has a generous storage limit for sent messages. However, if you're nearing your storage limit, you might want to consider archiving or deleting old sent emails to free up space. Overall, the sent folder in Gmail helps you keep a record of all your outgoing communications, allowing you to track and refer to past conversations easily. In Gmail, the drafts folder is where you can save unfinished emails that you're working on. As you compose an email in Gmail, it is automatically saved as a draft. If you close the Compose window without sending the email, Gmail will automatically save your progress as a draft. To access your drafts, click on Drafts in the left sidebar of the Gmail interface. This folder contains a list of emails you've started but haven't sent yet, organized by date and time. When you open a draft from the drafts folder, Gmail will display it in the Compose window so you can continue editing. You can make changes to the email, add or remove recipients, modify the subject, and edit the content as needed. If you're looking for a specific draft, you can use the search bar at the top of Gmail. Just enter keywords, recipient, subject, or any other relevant information, and Gmail will display matching results from your drafts folder. You can manage your drafts just like any other emails in Gmail. If you no longer need a draft, you can delete it and it will be removed permanently. If you make changes to a draft, you can save it again to keep your progress. Drafts remain in your account until you either send the email or manually delete them. Gmail automatically saves your drafts periodically, ensuring that you don't lose your work, even if you accidentally close the Compose window or your browser crashes. Overall, the drafts folder in Gmail offers a convenient way to work on emails over time, allowing you to save your progress and come back to them later when you're ready to send. Using Gmail Offline allows you to access your emails, compose new messages, and perform other tasks

Gmail Offline Chat And Meet Shortcuts

SPEAKER_01 55:21

even when you don't have an internet connection. To enable Gmail offline, first open Gmail in your web browser while you're connected to the Internet. Click on the gear icon in the top right corner and select See All Settings. Under the General tab, go to the Offline tab, check the box next to Enable Offline Mail, choose how many days of emails you want to sync for offline access and click Save Changes. You can also install the Gmail Offline Chrome extension for a more seamless offline experience. To do this, visit the Chrome Web Store, search for Gmail Offline, click Add to Chrome and follow the installation instructions. Once Gmail Offline is enabled, you can access your Gmail account offline by opening a new tab in Chrome or visiting mail.google.com in any browser. If you're using the extension, click on the Gmail Offline icon in the Chrome Apps Launcher or new tab page. If not, visit mail.google.com directly in Chrome. While offline, you can read, search and archive emails that have been synced to your device. You can also compose new emails and replies, which will be saved in the outbox and sent automatically when you're back online. Any changes you make, such as organizing emails or labeling them, will sync once you're connected again. When you're back online, Gmail will automatically sync any changes you made while offline, including sending emails from the Outbox and downloading new messages. You can manually sync Gmail by opening Gmail while connected to the Internet. You can adjust your offline settings anytime by returning to Gmail settings and modifying the options in the offline tab. You can also clear your offline data if you no longer want to use Gmail offline. Using Gmail offline is particularly useful when you're traveling or in situations where reliable internet access is unavailable. It allows you to stay productive and access your emails whenever you need them.

SPEAKER_00 57:12

It always seems impossible until it's done. Nelson Mandela.

SPEAKER_01 57:18

This module will familiarise students with Hangouts Meet, also known as Google Meet, a video conferencing platform developed by

Google Meet Scheduling Joining Inviting

SPEAKER_01 57:25

Google. We'll cover scheduling in Hangout, launching a Hangout, presenting your screen in Hangout, managing settings and managing meetings. To schedule a meeting in Hangouts Meet or Google Meet, you can do so directly through Google Calendar, which integrates seamlessly with Hangouts Meet. First, open Google Calendar by visiting calendar.google.com or by selecting the Calendar option in your Google Apps menu. Then, create a new event by either clicking the Plus button or selecting a specific time slot in your calendar. In the event creation window, enter the details for your meeting, such as the title, date, and time. Set the duration of the meeting and if you want, add a description to provide additional context or the agenda for the meeting. Next, add the participants by entering their email addresses in the Add Guests field. To enable Hangouts, Google Meet, click on the Add Google Meet video conferencing option. This automatically generates a Google Meet link for the meeting. If needed, you can manage the meeting settings by selecting the gear symbol beside the Join with Google Meet tab. Once all details are entered, click the Save button to create the event. Google Calendar will send invitations to the guests you've added, and the event will be added to your calendar. After saving the event, Google Calendar will prompt you to send invitations to the guests. At the scheduled time, participants can join the meeting by clicking on the Google Meet link in the Calendar event. They can also join the meeting directly from Google Calendar or by using the Google Meet app. By following these steps, you'll efficiently schedule a Google Meet meeting, ensuring all participants are invited and have the necessary information to join at the scheduled time. Launching a meeting in Hangouts Meet is a straightforward process, especially if you already have a meeting link or if you're using Google Calendar to schedule meetings. If you have a meeting link provided by the meeting organizer or generated previously, you can simply click on the link to join the meeting. Open your web browser and paste the meeting link into the address bar, then press Enter. Alternatively, you can click on the meeting link in an email invitation or any other communication medium where it was shared. Once you've clicked on the meeting link, Google Meet will open in your browser and you'll be taken directly to the meeting room. If the meeting was scheduled in Google Calendar and includes a Google Meet link, you can join the meeting directly from the Calendar event. Open Google Calendar by visiting calendar.google.com or clicking on the Calendar option in your Google Apps menu. Find the event for the meeting you want to join and click on it to open the event details. Click on the Google Meet link provided in the event details, and Google Meet will open in your browser, taking you directly to the meeting room. For those who prefer using a smartphone or tablet, you can join a meeting using the Google Meet app. Open the Google Meet app on your device and if prompted, sign in with your Google account. Tap on Meeting Code or Enter Meeting Code and enter the meeting code provided by the Meeting Organiser. Alternatively, if the meeting was scheduled in Google Calendar, you may be able to join directly from the app by tapping on the meeting event. If you have a meeting code provided by the meeting organizer, you can enter it directly into the Google Meet interface. Go to meet.google.com in your web browser and enter the meeting code in the Enter a Code or Link field, then click Join. Google Meet will prompt you to allow access to your camera and microphone before entering the meeting room. Once you've launched the meeting, you'll be in the meeting room where you can see and interact with other participants through video, audio and screen sharing. Make sure your microphone and camera are enabled if you want to communicate with others using audio and video. Presenting your screen in a Google Meet allows you to share what's visible on your computer or device screen with other meeting participants.

Presenting Controls Bandwidth Dial In

SPEAKER_01 1:01:22

This feature is useful for presenting slideshows, demonstrating software, or collaborating on documents. To start, join the Google Meet Meeting using one of the methods mentioned earlier, such as through a meeting link, Google Calendar, or the Google Meet app. Once you're in the meeting, locate the toolbar at the bottom of the screen. In the toolbar you'll find several icons, including the Present Now button, which looks like a rectangle with an arrow pointing to the right. Click on the Present Now button and a pop-up menu will appear with options to present your entire screen, a specific window or a Chrome tab. You can select the option that best suits what you want to share. If you choose your entire screen, it will share everything visible on your computer or device screen, including multiple monitors if you have them. If you select a window, you can choose a specific application window to share, and only that window will be visible to others. If you opt for a Chrome tab, you can share a specific tab from the Google Chrome browser, and only the content within that tab will be visible. After selecting what you want to present, click on it to start sharing your screen. Google Meet will display a preview of what you're sharing to ensure it's correct. Once you're ready, click on the Share button to begin presenting your screen to other meeting participants. To stop presenting your screen, click on the Stop Presenting button in the toolbar at the bottom of the screen or press the SC key on your keyboard. While presenting, you can still interact with other meeting participants through audio and video. You can also open and switch between applications or tabs on your computer without affecting what's being shared with others. By following these steps, you can easily present your screen in a Google Meet meeting, allowing you to share information, collaborate, and engage with other participants more effectively. Muting your microphone in Google Meet is a simple and essential feature that allows you to control when others can hear your audio during a meeting. First, join the Google Meet Meeting using one of the methods mentioned earlier, such as through a meeting link, Google Calendar, or the Google Meet app. Once you're in the meeting, look for the toolbar at the bottom of the screen. Among the icons in the toolbar, you'll see one that looks like a microphone, which controls your microphone. Click on the microphone icon to mute your microphone. When your microphone is muted, a red line will appear over the microphone icon, indicating that your audio is not being transmitted to other participants. To unmute your microphone and start transmitting audio again, simply click on the microphone icon again. The red line over the microphone icon will disappear, indicating that your audio is now being transmitted to other participants. If you prefer, you can also use a keyboard shortcut to mute and unmute your microphone in Google Meet. Press the Cuttr plus D Windows Linux or Command Plus D Mac keys to toggle between muting and unmuting your microphone. It's good practice to mute your microphone when you're not speaking to minimize background noise and distractions for other participants. When participating in larger meetings or webinars, muting your microphone when you're not speaking can help improve overall audio quality and clarity. By following these steps, you can easily mute and unmute your microphone in Google Meet, allowing you to control when your audio is transmitted to other meeting participants. Turning your camera off in Google Meet allows you to control when other meeting participants can see your video feed. Whether you need to step away briefly, have a poor internet connection, or simply prefer not to share video, this feature gives you the flexibility to manage your participation. First, join the Google Meet Meeting using one of the methods mentioned earlier, such as through a meeting link, Google Calendar, or the Google Meet app. Once you're in the meeting, look for the toolbar at the bottom of the screen. Among the icons in the toolbar, you'll see one that looks like a camera, which controls your video. Click on the camera icon to turn off your camera. When your camera is off, the icon will typically be crossed out or grayed out, indicating that your video feed is not being transmitted to other participants. In some cases you might see a stop camera or turn off camera option. Clicking this will achieve the same result. To turn your camera back on and start transmitting video again, click on the camera icon again. The crossed out icon will disappear and your video feed will be transmitted to other participants. If you prefer, you can also use a keyboard shortcut to turn your camera on and off in Google Meet. Press Ctrl plus E Windows Linux or CMD plus E Mac to toggle between turning your camera on and off. It's important to respect your privacy and comfort level when participating in video meetings. If you prefer not to share video for any reason, you have the option to turn off your camera. Similarly, If you need to step away briefly or have distractions in your environment, you can temporarily turn off your camera to avoid disrupting the meeting. By following these steps, you can easily turn your camera on and off in Google Meet, giving you control over when your video feed is transmitted to other meeting participants. Reducing bandwidth can help improve the quality of your video and audio during meetings, especially if you have a slower internet connection or if you're experiencing network congestion. First, lowering video quality can help. Google Meet automatically adjusts the video quality based on your internet connection speed, but you can manually lower the video quality if you're experiencing bandwidth issues. To do this, during a meeting, click on the three dots options in the bottom right corner of the toolbar. From the menu, select Settings and then under the Video section, choose a lower video quality option, such as Standard Definition 360p instead of high definition 720p or Standard Definition 480p instead of high definition 1080p. Lowering the video quality reduces the amount of data being transmitted, which can help conserve bandwidth. If bandwidth is severely limited, you can also disable your video feed altogether. During a meeting, click on the camera icon in the bottom left corner of the screen to disable your video. This eliminates the need to transmit video data, which can significantly reduce bandwidth usage. Another strategy is to limit screen sharing. Screen sharing requires additional bandwidth to transmit the contents of your screen to other participants. When possible, limit the use of screen sharing or only share specific applications or windows rather than your entire screen. Additionally, try to minimize unnecessary movement or changes on your screen to reduce the amount of data being transmitted. You can also close background applications. Close any unnecessary applications or browser tabs that may be consuming bandwidth in the background. Applications or browser tabs that are actively using the internet can compete with Google Meet for bandwidth, leading to performance issues. Lastly, if you're experiencing poor Wi-Fi connectivity, consider using a wired Ethernet connection instead. Wired connections typically provide more stable and reliable Internet access, which can help reduce the likelihood of bandwidth-related issues during Google Meet meetings. By implementing these strategies, you can effectively reduce bandwidth usage in Google Meet, ensuring a smoother and more reliable meeting experience even with limited internet connectivity. Dialing in allows participants to join a meeting using a phone for audio instead of relying on an internet connection. This feature is particularly useful for participants who may not have access to reliable internet or prefer using a phone for audio. To dial in, the meeting organizer will typically provide a phone number and PIN for participants. This information is often included in the meeting invitation or shared separately. Use your phone to dial the provided number, which is generally toll-free or local depending on your location. If you're dialing internationally, make sure to include the appropriate international dialing code. Once you've dialed the number, you'll be prompted to enter the meeting PIN, followed by the pound, hash, or hash key. The PIN is a numeric code given by the meeting organizer and is included in the invitation. Once you've entered the correct PIN, you'll be connected to the meeting and can participate in the audio portion. After joining the meeting, you will be able to hear the other participants. You can mute and unmute your microphone using the Mute Unmute button on your phone or by pressing the Mute Unmute option in the meeting's phone interface. Muting your phone helps eliminate background noise and ensures better audio quality during the meeting. While dialed in, you can listen and contribute to the conversation. However, you will only have access to the audio portion and will not be able to see video feeds or screen shares from other participants. By following these steps, you can easily dial into a Google Meet meeting and participate in the audio conversation even without an internet connection. Inviting users to a meeting allows you to share the meeting link and other relevant information with participants so they can join at the scheduled time. To begin, create or schedule a meeting in Google Meet. You can do this directly from Google Calendar or by using the Start a Meeting option in Google Meet. If you're creating the meeting in Google Calendar, click the plus button to create a new event. Then add the meeting details such as the title, date, time and description. Next, in the event creation window or meeting details, look for the Add Guests field. Enter the email addresses of the participants you want to invite to the meeting. You can also include a message to provide additional context or information about the meeting. If you're creating the meeting in Google Calendar, a Google Meet link will automatically be generated and added to the event. If you're using another method to create the meeting, be sure to manually include the Google Meet link in the invitation so participants can easily join. The Google Meet link can be found in the event details or meeting invitation, and participants can click on it to join the meeting directly. Once you've added all the necessary details and invited the participants, click on Save or Send to send the invitation. Google Calendar will automatically send email invitations to the participants, including the meeting details and the Google Meet link. Participants will receive email invitations and reminders for the meeting based on their notification settings in Google Calendar. If there are any changes or updates to the meeting, like a change of date, time or location, make sure to update the meeting details in Google Calendar and participants will be notified automatically. By following these steps, you can easily invite users to a Google Meet meeting and ensure they have all the information they need to join the meeting at the scheduled time. To use Google Chat, now known as Google Hangouts Chat, is straightforward once you get the hang of it. First, you

Google Chat Spaces Muting Removing Users

SPEAKER_01 1:12:19

can access Google Chat in a few different ways. You can go to Google Chat directly in your browser. If you use Gmail, you can access Google Chat from the Gmail interface on the sidebar. If you prefer using your mobile device, you can download the Google Chat app from the Google Play Store or the Apple App Store. Next, sign in with your Google Account credentials. If you're already signed in to another Google service, you'll be automatically logged in to Google Chat. Once you're logged in, you'll see a home screen displaying your recent conversations and rooms, now called Spaces. The sidebar on the left offers quick access to several sections. You can create a new chat, view shortcuts for quick messages, access direct messages with individuals or groups, and explore spaces which are group conversations organized by topics or projects. When you want to start a conversation, you can either click on the plus icon or use the search bar to find the person you want to message. After selecting the contact, click Start Chat and type your message in the text box at the bottom of the screen. Once you're done, press Enter or click the blue arrow to send the message. If you want to create or join a space, click the New Chat button, then select Create Space to start a new one or Browse Spaces to find and join an existing one. When creating a space, you can add a name, description, and invite members to join. To manage your notifications, click on the Settings icon in the top right corner. From there, you can adjust your notification settings for messages and mentions. You can choose to receive notifications for all messages, only direct mentions, or turn them off entirely. Google Chat integrates well with other Google Workspace apps like Google Drive and Google Calendar. You can share files directly from Google Drive by clicking the plus icon next to the message box. Google Chat also offers advanced features like reactions and emojis. You can quickly react to messages using emojis or click the emoji icon to add one to your message. You can also use rich text formatting like bold, italics, or underline to emphasize your messages, and for more control over text formatting, you can use markdown syntax. By following these steps, you'll be able to use Google Chat effectively for both personal and professional communication. Muting other users in Google Hangouts now Google Chat allows you to stop receiving notifications from specific individuals or conversations without completely blocking or removing them. On desktop web, open Google Hangouts in your web browser. You can also access it through Gmail by clicking on the Hangouts icon in the sidebar. Select the conversation with the person or group you want to mute. Then, right-click on the conversation and select Mute from the drop-down menu. You'll be asked to choose the duration for which you want to mute the conversation, such as one hour, eight hours, two days or more. On the mobile app, open the Google Hangouts app on your Android or iOS device. Tap on the conversation with the person or group you want to mute. Tap on the three vertical dots, more options, in the top right corner and select people and options or options depending on your device. Toggle the notifications switch to mute the conversation. If you want to unmute a conversation on desktop, follow the same steps as muting, but instead select Turn on Notifications or Unmute. On mobile, go to the Muted Conversation, follow the same steps as muting and toggle the notifications back on. By muting users or conversations, you can manage your notifications and reduce distractions while keeping the option to check the muted conversations at your convenience. Ejecting users from a Google Hangout, now part of Google Chat and Google Meet, involves removing participants from a chat or video call. In Google Chat, open Google Chat or access it through Gmail. Navigate to the chat room or conversation where you want to remove a user. Click on the room name at the top, then select Manage Members from the drop-down menu. Find the member you want to remove, click on the three-dot menu next to their name and select Remove from Space or a similar option to remove them. In Google Meet, go to Google Meet or join a meeting. Click on the People icon at the bottom right corner of the screen to open the People panel. Find the participant you want to remove. Click on the three-dot menu next to their name and select Remove from the call. Ejecting users can help manage disruptions and ensure the meeting or chat stays productive. Always ensure that this action is necessary and communicated appropriately when possible.

SPEAKER_00 1:16:52

Continuous improvement is better than delayed perfection. Mark Twain.

SPEAKER_01 1:16:57

This module will familiarize students with working in Docs, a web-based word processing application developed by Google.

Google Docs Layout Media Links Tables

SPEAKER_01 1:17:04

It allows users to create, edit, and collaborate on documents online. We'll cover settings up pages, inserting non-text elements, changing text attributes, formatting text blocks, using content management tools, inserting and editing tables, collaborating and sharing, and downloading. Customizing your Google Docs pages is easy and a great way to make your documents look professional. Let's walk through how to adjust the page size, orientation, and colour to fit your needs. To change the page size, start by opening your document. You can create a new one or edit an existing one. At the top menu, click File, then select Page Setup. In the dialog box that appears, find the paper size option. Click the drop-down menu and choose the size you want, like letter A4 or another option that works best for you. Next, let's adjust the page orientation. You'll use the same page setup dialog box. This time, look for the orientation section and select either portrait or landscape depending on what suits your document. Finally, to change the page color, open the page setup dialog box again. Look for the page color option and click the colour box to bring up a palette. From there, pick a color that works for you or use the custom colour tool if you have a specific shade in mind. When you're done, click OK to apply all the changes. And that's it. By tweaking the size, orientation, and colour of your pages, you can make your Google Docs look exactly the way you want. Headers and footers in Google Docs can add a professional touch to your document, and setting them up is simple. Let's start with footers. To add one, open your document and click Insert in the top menu. From there, select Headers and Footers and choose Footer. A section will appear at the bottom of your page where you can type anything you need, like page numbers, footnotes, or copyright information. You can even format the text using the toolbar to adjust the font, size or alignment. Adding a header works much the same way. Click insert in the top menu, select headers and footers, and then choose header. A section will appear at the top of the page where you can add details like the document title, your name or the date. Just like with footers, the toolbar gives you options to format the text however you like. Now if you want a different header or footer on the first page of your document, click Options in the Header or Footer section and select Header Format or Footer Format. Check the box for different first page and you can customize it separately. If you need to include page numbers, go back to the insert menu and select page numbers. You'll be able to choose the position and format that works best for your document. You can also access additional settings like margins and layout by clicking options in the header or footer. With just a few steps, you can easily add and customize headers and footers to make your Google Docs documents look clean and professional. Adding a table of contents in Google Docs is a great way to organize your document and make it easier for readers to navigate. Here's how you can set it up. Start by opening your document in Google Docs. If you haven't already, format the sections you want to include in the table of contents using heading styles. For example, you can use heading 1 inch for main sections and heading 2 inches for subsections. To apply a heading style, simply highlight the text, then select the appropriate heading from the toolbar. Once your headings are formatted, decide where you want the table of contents to appear. Place your cursor in that spot, then click Insert in the top menu, hover over table of contents, and you'll see two options. A table with hyperlinks that readers can click to jump to specific sections, or a plain text version without links. Choose the format that works best for your document. The table of contents will generate automatically based on your headings. If you make changes to your document like adding new sections or modifying existing headings, you can easily update the TOC. Just click on it, and a refresh icon will appear on the left. Click the icon to ensure your table of contents reflects the latest structure of your document. By following these steps, you will have a well-organized table of contents that makes your document more user-friendly. Inserting images into a Google Doc is a great way to enhance its visual appeal, clarify concepts, and provide additional context. There are three main ways to add images: using the toolbar, drag and drop, and copy and paste. To use the toolbar, start by opening your Google Doc and placing your cursor where the image should appear. Click on the insert menu at the top of the page and select Image. You'll then have several options to choose from. You can upload an image from your computer, search the web directly through Google Docs, access images stored in your Google Drive or Google Photos, paste a URL for an online image, or even capture a photo instantly with your device's camera. The drag and drop method is another quick option. Open your document and position your cursor where you want the image to be inserted. Locate the image file on your computer, then click and drag it directly into the document. Once you release the mouse button, the image will appear at the cursor's location. Finally, there's the copy and paste method. If the image is already open, right-click on it and select copy. Alternatively, use the shortcut Ctrl plus C on Windows or CMD plus C on Mac. Go to your Google Doc, click where you want the image to appear, and paste it using CtrlPlusV or CMD plus V. The image will be inserted at the exact location of your cursor. These simple methods make adding images to Google Docs quick and intuitive, allowing you to create visually engaging and professional documents with ease. Inserting tables into a Google Doc is a simple way to organize information and present it clearly. To insert a table, start by opening your document and placing your cursor where you want the table to appear. From the top menu, click Insert and hover over table. A grid will appear, allowing you to select the number of rows and columns you need. Drag your mouse over the grid and click to insert the table into your document. Once the table is in place, you can customize it to fit your content. To add or remove rows and columns, right-click on a cell and select the appropriate option from the context menu. If you need to merge cells, highlight the ones you want to combine, right-click and choose Merge Cells. This can be helpful for creating headers or organizing information. For adjusting cell sizes, click and drag the borders of rows or columns to resize them. To ensure even spacing, right-click and select distribute rows or distribute columns. If you want to format text within the table, simply highlight the text in a cell and use the toolbar to apply bold italics, change the font size or adjust alignment. For further customization, right-click on the table and select table properties. This menu allows you to adjust borders, change the cell background colour, modify vertical alignment, and set specific dimensions for columns, rows, and padding. These tools make it easy to create and format tables in Google Docs, ensuring your information is displayed clearly and professionally. Creating hyperlinks in Google Docs is straightforward and can be done in several ways. Here's how you can add, edit or remove links in your document. To add a hyperlink using the toolbar, start by highlighting the text you want to link. Then click the link icon in the toolbar. It looks like a chain link. Alternatively, you can use the shortcut CtrlPlusK on Windows or CMD plus K on Mac. In the dialogue box that appears, type or paste the URL in the link field, and the hyperlink will be applied to the selected text. Another way to insert a link is by using the right-click menu. Highlight the text you want to link or place the cursor where you want the hyperlink to appear. Right-click and select link from the menu. A dialogue box will open, allowing you to enter or paste the URL. Click Apply and the hyperlink will be added. You can also create a hyperlink by simply typing the URL directly into the document. Be sure to include http/slash or https slash slash at the beginning, and Google Docs will automatically convert it into a clickable link. To edit or remove an existing link, click on the link to text. A small menu will appear with options to update the URL or remove the hyperlink altogether. These methods allow you to easily incorporate hyperlinks into your Google Docs, making your documents more interactive and functional. 408. Inserting in-document links, also known as bookmarks or internal links, in Google Docs allows you to navigate to different parts of the same document seamlessly. This is especially useful for creating tables of contents, cross-references, or navigating long documents. Here's how to use them effectively. Creating bookmarks, start by selecting the destination text, which is where the link will point. Navigate to this location in your document. Then, click on the insert menu at the top of the screen and select bookmark from the drop-down. A small blue bookmark icon will appear next to the text, indicating that a bookmark has been created. Linking to a bookmark. To create a link that jumps to the bookmark, highlight the text you want to use as the link. Click the Insert Link button in the toolbar or use the keyboard, shortcut Cuttrol plus K on Windows or CMD plus K on Mac. In the dialog box that appears, locate the section titled Bookmarks, select the bookmark you created and click Apply. Using headings for in-document links, if your document is organized using headings, you can link directly to these without creating bookmarks. Highlight the text you want to use as the link. Click the Insert Link button or use the Ctrl Plus K or CMD plus K shortcut. In the dialog box, you'll see a list of headings under headings. Select the desired heading and click Apply. Editing or removing in document links. To update or delete an in-document link, click on the link to text. A small menu will appear above or below the link. To edit, change the link in the dialog box and click Apply. To remove the link, click Remove or the Trash icon. With these steps, you can easily create and manage in document links, making your Google Docs more dynamic and user-friendly. Changing the font in Google Docs is a quick and easy way to improve the appearance and readability of your document. Here's how you can adjust font settings for selected text, the entire document, or even customize your default font. Changing the font for selected text. To start, highlight the text you want to change by clicking and dragging your cursor over it. In the toolbar at the top of the page, click on the font drop down menu, which displays the current font name, like Arial or Times New Roman. Scroll through the list of fonts and select the one you want. The selected text will update to the new font instantly. Changing the font for the entire document. If you want to change the font for the entire document, Press Catrol plus A on Windows or CMD plus A on Mac to select all the text. Then open the font drop-down menu in the toolbar and choose a new font. The font change will apply to all the text in the document. Adding new fonts, to access additional fonts, open the font drop-down menu and click on more fonts at the top of the list. In the fonts dialog box, browse or search for fonts you'd like to add. Click on the fonts you want and they'll appear on the right side under My Fonts. Once you've made your selections, click OK. These fonts will now be available in your font drop-down menu for future use. Customizing default font settings. If you want to use a specific font as your default, start by formatting your text with the desired font. Next, click on the format menu at the top of the page and hover over Paragraph Styles. Choose Normal Text or another style like title or heading one and select update normal text to match. To make this the default for all future documents, go back to the Paragraph Styles menu, hover over options and select Save as My Default Styles. By following these steps, you can easily change and customize fonts in Google Docs, ensuring your documents look polished and professional. Changing the font size in Google Docs is an effective way to improve readability and emphasize important sections of your document. Here's how to adjust font sizes for specific text, the entire document, or even customize your default settings. To change the size of specific text, begin by highlighting it with your cursor. In the toolbar at the top, locate the font size drop-down menu, which displays the current size such as 11 or 12. Click the drop-down to see a list of predefined font sizes and select the one you want. The highlighted text will instantly update to reflect the new size. If you want to adjust the font size for the entire document, use Cuttr plus A on Windows or CMD plus A on Mac to select all the text. Once everything is highlighted, open the font size drop-down menu and choose your desired size. The entire document will change to match your selection. For a custom font size, highlight the text you want to modify. Open the font size drop-down menu and instead of selecting a predefined size, type a specific value such as 13 or 15 directly into the box. Press Enter and the custom size will be applied to the selected text. To make a specific font, size the default for future documents. Start by formatting your text with the desired size. Click the format menu at the top of the page and hover over paragraph styles. Select Normal Text or another style like title or heading one, then choose update normal text to match. To save this setting as the default, go back to the Paragraph Styles menu, hover over options, and select Save as My Default Styles. By following these steps, you can easily control font sizes in Google Docs, creating documents that are well structured, readable, and visually appealing. In Google Docs, text and highlight colour options allow you to personalize your document and make specific elements stand out. Here's how to use these features effectively. To change the text colour, start by highlighting the text you want to modify. Look for the text colour button in the toolbar. It appears as a capital A with a colour bar beneath it. Click this button to open a colour palette. From the palette, you can choose a standard colour, select a custom color, or create your own. Once you've made your choice, click on the colour and the highlighted text will immediately update to reflect it. For changing the highlight colour, first highlight the text you want to adjust. Then, locate the highlight color button in the toolbar, which looks like a highlighter pen. Click the button to access a color palette. Similar to text color, you can choose from standard or custom options. Select your desired highlight color and it will be applied as a background to the selected text. By using these tools, you can enhance the visual appeal of your Google Docs, emphasizing key points and adding a professional touch to your content. In Google Docs, bold, italic and underline options provide versatile ways to emphasize text and enhance the readability of your document. Bold text adds thickness and prominence to your words, making it ideal for highlighting key points or headings. To apply bold formatting, highlight the text you want to emphasize. Then click the B button in the toolbar or use the shortcut Cuttrus B on Windows or CMD plus B on Mac. The selected text will immediately appear bold. Italic text slants slightly to the right, offering a softer emphasis compared to bold. It's commonly used for titles, foreign words, or specific terms. To italicize text, highlight the desired section, then click the I button in the toolbar or use the shortcut Cuttr plus 1 on Windows or CMD plus I on Mac. The text will appear italicized. Underlining adds a line beneath your text which can emphasize specific words or indicate hyperlinks. To underline text, start by highlighting it. Then click the U button in the toolbar or use the shortcut Ctrl plus U on Windows or CMD plus U on Mac. The underlining will apply instantly. These formatting tools allow you to create visually appealing documents that emphasize important content while maintaining a professional structure. In Google Docs, paragraph styles are predefined formats that help keep your document polished and consistent.

Docs Formatting Styles Proofing Dictionary

SPEAKER_01 1:33:40

These styles, like headings, subheadings, and normal text, allow you to structure content effectively. To apply a style, begin by highlighting the paragraph or text you want to format. Next, locate the styles drop-down menu in the toolbar at the top of the page. By default, this menu displays normal text. Click on it to view a list of styles such as heading 1, heading 2, title, or subtitle. Select the style that fits your content, and the highlighted text will automatically update to match the chosen format. Using paragraph styles ensures your document maintains a cohesive and professional appearance, making it both visually appealing and easy to navigate. In Google Docs, alignment controls how text is positioned within your document, offering options to align text to the left, center it, align it to the right, or justify it for even distribution across the page. These alignment settings contribute to a clean, professional layout. To adjust the alignment, start by highlighting the text or paragraph you want to modify. Next, locate the alignment buttons in the toolbar, where each icon visually represents a specific alignment style. Selecting the left alignment button positions the text against the left margin. Choosing the center alignment button places the text in the middle of the page while the right alignment button moves the text to the right margin. The Justify button ensures the text is evenly distributed between both margins, creating a neat block-like appearance. Once you've decided on the alignment style, click the corresponding button, and the text will instantly adjust to match your selection. Using these alignment options effectively ensures your document is both readable and visually appealing. In Google Docs, line and paragraph spacing options allow you to control the space between lines of text and paragraphs, enhancing readability and the overall appearance of your document. Line spacing refers to the space between each line of text within a paragraph. To adjust it, highlight the text you want to modify or place your cursor within the paragraph. Click the line spacing button in the toolbar, represented by three horizontal lines with arrows pointing up and down. From the drop-down menu, choose a spacing option such as single for minimal space, 1.15 for slightly more space, 1.5 for 1.5 times the single spacing, or double for twice the single spacing. If these options don't meet your needs, select custom spacing to specify an exact value. Paragraph spacing adjusts the space before and after paragraphs, helping to distinguish different sections of text. To modify paragraph spacing, highlight the relevant text or place your cursor within the paragraph. Click the line spacing button and select custom spacing from the drop-down menu. In the dialog box, enter specific values for line spacing as well as for the space before and after paragraphs. Once you've entered your desired values, click Apply to implement the changes. By effectively managing line and paragraph spacing, you can create documents that are not only visually appealing, but also easier to read and navigate. In Google Docs, columns are a versatile formatting tool that can organize your document into vertical sections, much like the layout of newspapers or magazines. This feature not only enhances readability but also adds a professional touch to your document. To add columns, open your Google Doc. If you want to apply columns to specific text, highlight the relevant section. If you'd like the column layout to apply to the entire document, no need to highlight anything. Navigate to the format menu in the toolbar and select columns. You'll see preset options for one, two, or three columns. Choose your desired layout and the changes will take effect immediately. For additional customization, return to the format menu, select columns and choose more options. In the customization menu, you can define the exact number of columns, adjust the spacing between them, and add a vertical line between columns for clearer separation. Once you've made your selections, click Apply to save the changes. Using columns effectively in Google Docs allows you to design clean, visually appealing documents tailored to your content's specific needs. In Google Docs, numbering and bullets are essential tools for creating organized and easy-to-read lists. Numbered lists are ideal for presenting items in a specific sequence, while bulleted lists work well for unordered information. To create a numbered list, start by highlighting the text you want to format or placing your cursor where you'd like the list to begin. Click the numbered list button in the toolbar represented by a series of numbers, 1, 2, 3. If you're starting a new list, simply type your first item and press enter. A new numbered line will appear automatically for each subsequent entry, maintaining the correct sequence. For a bulleted list, the process is similar. Highlight the relevant text or position your cursor where you want the list to start. Click the bulleted list button in the toolbar symbolized by dots or bullet points. Begin typing, and each new line will automatically be formatted with a bullet point. By incorporating numbered and bulleted lists, you can make your document more organized, visually appealing, and easier for readers to follow. Using content management tools like spelling and grammar checkers in Google Docs helps ensure that your documents are polished and error-free. Google Docs automatically checks for spelling and grammar issues as you type, underlining potential mistakes with red for spelling errors and blue for grammar issues. This real-time detection allows you to address errors as they arise. To manually access the spelling and grammar tool, click on Tools in the top menu, then select Spelling and Grammar, followed by Spelling and Grammar Check. A panel will appear on the right side of the screen displaying the first detected issue. You can review each suggestion and choose whether to accept or ignore it. Use the arrows in the panel to navigate through multiple suggestions. If you need to customize your language and settings, go to File, then Language and select your preferred language. Google Docs will use this language setting for spelling and grammar checks. If a correctly spelled word, such as a brand name or technical term, is flagged, you can add it to your personal dictionary. Right-click on the underlined word and select Add to Personal Dictionary to avoid future flags. For quick access, use keyboard shortcuts. Press Cuttr plus Alt plus X on Windows or Command plus Option plus X on Mac to open the spelling and grammar tool. These tools help maintain the quality and professionalism of your document. In Google Docs, the personal dictionary allows you to customize spelling and grammar suggestions by adding words that are unique to your writing, such as brand names, technical terms or proper nouns. This feature helps prevent unnecessary corrections and ensures smoother editing. To add words to your personal dictionary while editing a document, start by looking for any word underlined in red, which indicates it isn't recognized by Google Docs. If you know the word is correct, right-click on it and select Add to Personal Dictionary from the Context menu. This will ensure the word isn't flagged as a mistake in the future. You can also access and manage your personal dictionary directly. Go to the Tools menu at the top of the page, select Spelling and Grammar, and then choose Personal Dictionary. In the dialog box that appears, type the word you want to add and click Add. You can also review and delete words from your list as needed. Using the Personal Dictionary in Google Docs allows you to tailor the spelling and grammar tools to your specific needs, making it especially useful for professionals, students, and anyone who frequently uses unique terminology. This customization improves both efficiency and accuracy in your writing. Creating and managing tables in Google Docs is a simple way to organize data, present information clearly, and improve your documents layout. To create a table, place your cursor where you want the table to appear. Then, go to the insert menu at the top of the page and hover over table. A grid will appear, allowing you to choose the number of rows and columns by dragging your mouse over it. Once you've made your selection, click to insert the table into your document. Customising your table is easy. To resize cells, click and drag the edges of cells, rows or columns. If you need to add rows or columns, right-click on a cell, then choose Insert Row Above, Insert Row Below, Insert Column Left, or Insert Column Right from the menu. To delete rows or columns, right-click on the one you want to remove and select Delete Row or Delete Column. If you want to merge multiple cells, highlight them, right-click and select Merge Cells. If you need to delete an entire table, click anywhere inside the table to select it, then right-click and choose Delete Table. To delete specific rows or columns instead, right-click on the row or column and select the corresponding delete option. These tools make it easy to create and manage tables that enhance the organization and presentation of your document. Creating and managing tables in Google Docs is a versatile way to organize data, present information clearly, and enhance your document layout. Here's how to effectively customize and adjust tables. To access table properties, right-click anywhere inside the table and select table properties from the context menu. This opens the table properties sidebar where you can make various adjustments. In the table border section, you can customize the border colour, adjust the thickness, and select a style such as solid, dashed or dotted. To enhance specific sections, you can change the cell background colour, making rows, columns, or individual cells stand out. For text alignment within cells, use cell vertical alignment to position text at the top, middle or bottom. To adjust cell dimensions, modify cell padding to create space between content and borders, set a minimum row height, or define fixed column widths. For overall table alignment, you can position the entire table to the left, centre or right of the page and use table indentation to offset it from the margin. You can also ensure a consistent layout by evenly distributing rows and columns using the Distribute Rows Columns Evenly option. For better readability, apply alternating row colours under alternate row colours. To manage or modify your table structure, right-click to delete the entire table or select specific rows or columns for deletion. To merge cells, select adjacent cells, right-click and choose merge cells. If needed, split merged cells back into individual ones using the split cells option. For manual adjustments, click and drag the table borders to resize rows and columns or reposition the entire table by dragging it to a new location. These tools give you full control over table customization in Google Docs, enabling you to create professional, well-structured layouts tailored to your needs. Comments in a shared Google Doc are an essential tool for collaboration, enabling users to provide feedback, ask questions,

Docs Collaboration Suggesting Version History

SPEAKER_01 1:44:58

and discuss content directly within the document. Here's how to use them effectively. To add a comment, highlight the text or area you want to address. A small comment icon will appear on the right side of the document. Click on it or right-click the highlighted text and select comment from the menu. Type your feedback, question or note into the comment box, then click Comment to Save It. When replying to comments, click on an existing comment thread visible in a box on the right side of the document. Type your response in the provided box and click Reply to save it, keeping the conversation organized within the thread. To resolve comments, click the Resolve button at the top right of the comment once the issue has been addressed. Resolved comments will no longer appear in the Active View but can be accessed by clicking the comment history icon, a speech bubble with three lines, at the top right of the document. If necessary, you can reopen resolved comments. Google Docs also sends email notifications for comments by default, especially when you're mentioned or new comments are added to a document. You can manage these notifications by clicking the comments icon at the top right and adjusting your preferences using the bell icon. Options include receiving notifications for all comments, only those that mention you, or turning notifications off entirely. To edit or delete a comment, click the three vertical dots in the upper right corner of your comment. Select edit to modify the text or delete to remove the comment entirely. By effectively utilizing comments, you can enhance collaboration and communication in shared Google Docs, ensuring efficient teamwork and clear exchanges of ideas. Editing a shared document in Google Docs makes real-time collaboration seamless and efficient. Here's how you can make the most of the editing features. To make edits, start by choosing the appropriate mode. In editing mode, click anywhere in the document to type, delete, or format text directly. If you're in suggesting mode, your changes will appear in green with a comment box on the side, allowing collaborators to review and discuss your suggestions. You can also format text by adjusting the font style, size or colour and applying effects like bold, italic or underline using the toolbar. To add visual or interactive elements such as images, links, tables or charts, use the Insert menu. When multiple collaborators edit simultaneously, Google Docs usually merges changes smoothly. If conflicting edits occur in the same section, you may be prompted to choose which change to keep, ensuring clarity and consensus. For offline editing, enable the Make Available offline option under the File menu. This allows you to work on the document without an internet connection. Once you're back online, your changes will sync automatically with the shared version. To finalise edits in suggesting mode, review the suggestions made by collaborators. You can accept or reject them by clicking the check mark or X in the comment box. Resolved comments or issues can be marked as such, keeping the document organized and ready for finalization. By mastering these features, you can collaborate effectively on shared Google Docs, ensuring smooth teamwork and a polished final document. Suggesting mode in Google Docs is a feature that allows collaborators to propose edits or changes to a document without altering the original content. This is particularly useful in collaborative environments where changes need to be reviewed and approved before being finalized. 1. Enabling suggestion mode. 1.1 Switch to suggesting mode. To enter suggesting mode, click on the pencil icon in the top right corner of the document and select suggesting from the drop-down menu. In suggesting mode, the pencil icon will change to a green pen icon. 1.2 automatic in comments mode. If you are only allowed to comment on a document and not edit it directly, your changes will automatically be made as suggestions. 2. Making suggestions. 2.1. Type your suggestion. When you type, delete or format text in suggesting mode, your changes will appear as suggestions rather than permanent edits. The suggested changes are highlighted in green or another color, depending on your settings. 2.2 formatting suggestions. You can also suggest formatting changes such as bolding text, changing font size, or altering paragraph alignment. These changes will appear as suggestions in the document. 3. Viewing and Managing Suggestions. 3.1 Inline suggestions. Each suggestion will be marked with a comment box in the right margin of the document. The original text will be crossed out and your suggested text will appear next to it. 3.2 Comments Suggestions automatically generate a comment box on the right side of the document where you or other collaborators can discuss the proposed change. This helps keep the context clear and allows for easy communication about the suggestion. 4. Accepting or rejecting suggestions. 4.1 Review Suggestions. Any collaborator with editing permissions can review suggestions. When you click on a suggestion, you'll see options to accept or reject it. 4.2 Accept a suggestion. Checkmark to accept the suggestion. The suggested changes will replace the original content in the document. 4.3. Reject a suggestion. Click the X to reject the suggestion. The original content will remain unchanged and the suggestion will be removed. By using suggesting mode, you can ensure that all changes are carefully reviewed and approved, maintaining the integrity of the document while still allowing for collaborative input. Revision history in Google Docs, also known as version history, is a powerful feature that allows you to track and review all changes made to a document over time. This tool is especially useful in collaborative settings where multiple people contribute edits. To access revision history, open the document you want to review. Click on File in the top menu, then select version history and choose C version history. For a quicker method, use the keyboard shortcut Ketrol plus Alt plus Shift plus H on Windows or CMD plus Option plus Shift Plus H on Mac. Once opened, the version history interface displays a panel on the right side of the screen. This panel lists all saved versions of the document, complete with timestamps and the names of the collaborators who made the changes. Each collaborator is assigned a unique color and their changes are highlighted accordingly, making it easy to identify who made specific edits. If you need to save or share a specific version, you have options. To download a version, go to File, then Download and select your preferred format, such as Microsoft Word or PDF. To share a version, copy the URL from your browser's address bar while viewing that version. While version history is comprehensive, it has some limitations. Older changes may be grouped or condensed in very long documents or after significant time has passed. Additionally, deleting a document will erase its version history, so exercise caution if you need to preserve a record of changes. By effectively utilizing version history, you can keep track of edits, collaborate seamlessly, and ensure no important content is lost in a shared Google Doc.

SPEAKER_00 1:52:14

Great things are done by a series of small things brought together. Vincent Van Gogh.

SPEAKER_01 1:52:20

This module is designed to provide learners with a comprehensive understanding of Google Sheets, from basic spreadsheet

Google Sheets Data Formatting Functions

SPEAKER_01 1:52:27

functions to advanced techniques. This module will guide you through the essential features and capabilities of Google Sheets, enabling you to efficiently manage data, create powerful spreadsheets, and leverage Google Sheets for personal and professional use. Adding data to Google Sheets is one of the most fundamental tasks you'll perform when working with spreadsheets. To start, open Google Sheets and sign in with your Google account. Open an existing document or create a new one. When adding data to cells, simply click on any cell where you want to add data. The selected cell will be highlighted. Then, type your data directly into the cell, which could be text, numbers, dates, or formulas. Press Enter or Return to move down to the next cell or tab to move to the next cell in the same row. To copy and paste data, select the cells with the data you want to copy, right-click and choose copy, or use the shortcut Cuttral plus C CMD plus C on a Mac. To paste data, click on the cell where you want to paste, then right-click and choose Paste, or use Cuttral plus V, CMD plus V on a Mac. You can also click and drag the small blue square at the bottom right corner of a selected cell to fill adjacent cells with the same data. If you need to insert rows or columns, right-click on a row number or column letter where you want to insert a new row or column. Then select insert one above below for rows or insert one left right for columns from the context menu. For more precise data entry, use the formula bar at the top of the spreadsheet, just below the toolbar. You can enter or edit data in a cell, type equal sign, followed by a formula or function, for example equal sign sum, a1 a 10, directly into the cell or formula bar. Formatting data in Google Sheets is easy. Highlight the cells you want to format, then use the toolbar options to change the font, size, color, alignment, etc. To format numbers as currency, percentage, dates, or custom formats, select the cells and choose the appropriate format from the toolbar. If you're using Google Forms, you can link a Google Form to your Google Sheet. Responses from the form will automatically populate into the spreadsheet. To do this, go to Tools, then Create a Form from within Google Sheets, or create a form in Google Forms and choose Select Response Destination to link it to your sheet. To import data, you can import data from other formats like CSV or Excel by going to File, then Import and Selecting the File. You can also use functions like import data or importange to pull data from external sources or other Google Sheets. For enhanced functionality, you can use Google Sheets add-ons, which are third-party tools that can help with importing data, cleaning data, and more. By mastering these steps, you'll be well equipped to add and manage data in Google Sheets, laying the foundation for more complex tasks and analyses. Deleting or removing data from Google Sheets is just as essential as adding data. To begin, open Google Sheets and sign in with your Google account. You can open an existing document or create a new one. When you need to delete data from cells, click on the cell or drag to select multiple cells that contain the data you want to delete. Press the Delete or Backspace key on your keyboard to clear the contents of the selected cells. The cells will remain, but the data will be removed. If you want to clear formatting while keeping the data, go to Format, then Clear Formatting, or use the shortcut Catrol Plus CMD plus class on a Mac. To delete entire rows or columns, click on the row number on the left or the column letter at the top to select the entire row or column. Then right-click on the selected row or column and choose Delete Row or Delete Column from the menu. The row or column will be completely removed and the remaining rows or columns will shift to fill the gap. For deleting multiple rows or columns, click and drag across multiple row numbers or column letters to select them. Then right-click on the highlighted area and choose Delete Rows XY or Delete Columns XY, where X and Y are the first and last selected rows or columns. If you need to remove specific cells and shift surrounding data, select the cell or range of cells you want to delete. Right-click the selected cells and choose Delete Cells from the context menu. You'll be prompted to choose how to shift the remaining data, either shifting cells left or up to fill the deleted space. To delete entire sheets, navigate to the Sheet tab at the bottom of the screen. Right-click on the Sheet tab and select Delete from the menu. This will permanently remove the entire sheet from your Google Sheets document. If you accidentally delete something, you can quickly undo the action by pressing Ctrl plus Z, CMD plus Z on a Mac, or by clicking the Undo button in the toolbar. Additionally, you can use version history to restore a previous version of the document. If you want to clear data without deleting rows or columns, use the Clear Content option. This will remove the data while keeping your spreadsheet structure intact. When dealing with form responses, if your Google Sheets is linked to a Google form, you can delete individual form responses by finding the row associated with the response and deleting it as you would any row. Keep in mind that deleting rows associated with form responses will remove the data from the spreadsheet, but won't affect the Google form itself. By mastering these deletion techniques, you'll be able to efficiently manage your Google Sheets, keeping them clean, organized, and free of unnecessary data. Reasing rows and columns in Google Sheets is a useful feature that helps you keep certain parts of your spreadsheet visible while scrolling through other data. This is especially helpful when working with large datasets as it allows you to always see headers or labels. To start, open Google Sheets and sign in with your Google account. Open an existing document or create a new one. Freezing rows or columns works by keeping them in view while you scroll through the rest of your spreadsheet. Typically, this is used for headers or key identifiers. To freeze rows, first, select the row you want to freeze, usually the first row where your headers are located. Go to the View menu at the top of the screen, select Freeze from the drop-down menu, and then choose one row to freeze the top row. If you want to freeze more than one row, select two rows or up to current row X, where X is the number of the row you selected. To freeze columns, select the column you want to freeze, typically the first column that contains labels or key data points. Again, go to the View menu, select Freeze, and choose one column to freeze the first column. For more than one column, select two columns, or up to current column X. If you need to freeze multiple rows or columns, select the last row or column you want to freeze. Then, under View, choose Up to Current Row X or Up to Current Column X, where X corresponds to your selection. To unfreeze rows or columns, simply go back to View and select No Rows or No Columns to return the spreadsheet to its normal state. You can also use your mouse to freeze rows or columns by dragging the small grey line that appears between the row numbers or column letters and the data grid. Hover your mouse over the line until it turns into a hand icon, click and drag it down or to the right to freeze the desired rows or columns. Freezing is particularly useful for keeping headers visible as you scroll through large data sets or for freezing key identifiers like names or IDs when the first column contains important data. In data analysis, freezing rows or columns is especially helpful when comparing data or working with pivot tables, as it allows you to keep the most critical parts of your data always in view. However, there are some limitations. You can only freeze rows from the top and columns from the left, so it's not possible to freeze rows or columns from the middle of the sheet. By understanding how to freeze and unfreeze rows and columns, you can make your workflow more efficient and ensure that important data remains visible as you navigate your spreadsheet. Formatting data in Google Sheets is an essential task that helps organize your spreadsheet, making it more readable, organized, and visually appealing. By applying various formatting techniques, you can highlight key information, differentiate between data types, and improve the overall clarity of your sheet. To begin, open Google Sheets and select the spreadsheet containing the data you wish to format. For basic text formatting, first, select the cell or text you want to format. You can use the toolbar to apply bold, italic, or underlined styles. Changing the font style and size is easy. Select the text or cells you want to adjust, click the font drop down in the toolbar and choose your preferred font. Then adjust the font size using the drop-down next to the font selection. Text alignment is another useful feature. You can horizontally align text to the left, center, or right using the alignment buttons in the toolbar. For vertical alignment, click the vertical alignment button to align your text to the top, middle or bottom of the cell. If you have long text that doesn't fit in a single cell, you can use text wrapping. Select the cell with a long text, click the text wrapping button and choose wrap to ensure all text fits within the cell. Alternatively, you can select clip to truncate the text if it exceeds the cell width. For number formatting, select the cells containing numbers, go to the format menu, then choose number and select the format that fits your needs, for example currency, percentage, date, time. If you need a custom format, you can select custom number format and create your desired format. You can also merge cells to combine multiple cells into one larger cell. Select the cells you want to merge, click the merge cells button, and choose the desired merge option, such as merge all, merge horizontally, or merge vertically. Data validation allows you to set rules for what data can be entered into a cell. Select the cells, go to Data and then Data Validation, and set the type of data allowed, such as numbers only, specific text or a drop-down list. To format dates and times, select the cells with dates or times, go to format, then number, followed by date or time, and choose your preferred format. For cell background colour, select the cells you want to colour, click the fill colour button in the toolbar, and choose your colour from the palette. You can also use the custom option to create a specific shade by inputting a hex code. Borders are helpful for defining cell boundaries. Select the cells you want to apply borders to, click the borders button, and choose the type of border, for example, all borders, outer borders, inner borders, or borders on specific sides. You can customize the border style and colour using the options available. By mastering these formatting techniques, you can make your Google Sheets more effective and visually appealing, ensuring that your data is not only organized but also easy to interpret and navigate. Formatting Sheets in Google Sheets helps organize your workbook by managing its structure. You can add, delete, copy, rename, and move sheets to ensure your data is organized efficiently across multiple sheets. To add a new sheet, click the Plus Plus icon located next to the existing sheet tabs at the bottom of your Google Sheets window. This allows you to create a new sheet where you can enter and organize different sets of data. If you need to delete a sheet, right-click on the Sheet tab at the bottom and select Delete from the context menu. Google Sheets will ask for confirmation before deleting the sheet. Click OK to proceed with the deletion. Copying a sheet is useful when you want to duplicate the contents of a sheet within the same workbook. To do this, right-click on the sheet tab and select Duplicate from the context menu. This creates a copy of the sheet with the same data and formatting. Moving a sheet to another workbook can be done using the Copy to feature. Right, click on the sheet tab you want to move, then select Copy to New Spreadsheet or Excisting Spreadsheet. If you choose an existing spreadsheet, you will be prompted to select which workbook to copy the sheet to. This is useful for sharing data across different projects or collaborating with others. Renaming a sheet helps keep your workbook organized by giving each sheet a meaningful name. To rename a sheet, double-click on the sheet tab and type the new name. Press Enter to save the changes. Alternatively, right-click on the sheet tab and select Rename from the context menu. Rearranging sheets in your workbook allows you to prioritize important sheets or keep them in a specific order. To do this, click and drag the sheet tab to the desired position at the bottom of the Google Sheets window. These techniques enable you to efficiently manage your Google Sheets workbooks, ensuring your data remains organized, easy to navigate, and ready for collaboration. Inserting non-text elements like charts, images, links, forms, and drawings into Google Sheets enhances your data presentation, making your spreadsheet more interactive and visually engaging. Charts in particular are useful as they offer visual representations of your data, helping you easily spot trends, comparisons, and patterns. To insert a chart first, select the range of data you want to visualize. After selecting the data, go to the Insert menu and choose Chart. This will insert a default chart based on your data. Once the chart is inserted, you can customize it further by clicking on the chart and using the chart editor that appears on the right side of your screen. In the editor, you can choose different chart types such as bar, line or pie and adjust settings like axes, labels, colours, and more to suit your needs. Images can add context, branding or visual interest to your data in Google Sheets, making your spreadsheet more engaging and easier to understand. To insert an image directly within a cell, go to the Insert menu, select Image, and then choose Image in Cell. You can upload an image from your computer, search the web, or provide a URL for the image. If you prefer to insert an image over the cells, select Insert, then Image and choose Image Over Cells. This allows you to place the image above the cells, giving you more flexibility in positioning it. Once the image is inserted, you can resize and reposition it by clicking and dragging the corners to adjust its size and moving it around within your sheet to fit your layout. Hyperlinks in Google Sheets can be used to link to external websites, specific cells, or even other sheets within the same workbook, enhancing navigation and reference within your data. To insert a link, select the cell where you want to add the hyperlink, then go to Insert in the toolbar and choose Link. Next, enter the URL you want to link to or select a cell or sheet within the workbook to link to a specific location. You can also customize the text displayed in the cell by typing it in the provided field instead of showing the full URL. This makes your spreadsheet more interactive and easier to navigate. Google Forms is a powerful tool for collecting data, and when integrated with Google Sheets, it automatically populates responses into a spreadsheet. This feature is particularly useful for tasks like surveys, feedback, and registrations. To create a form, go to Tools and select Create a Form to either create a new Google form or link an existing one to your sheet. Once the form is linked, the responses will automatically populate into a new sheet within your workbook, making it easy to analyze and manage the data directly in Google Sheets. Drawings in Google Sheets allow you to add custom shapes, diagrams, or annotations, which can be useful for illustrating concepts or adding visual notes. To create a drawing, go to Insert and select Drawing to open the Google Drawing tool. Use the drawing tools to create shapes, text, lines, or other graphics and click Save and Close when you're done. The drawing will then be inserted into your sheet as an image, which you can resize and move as needed. If you need to make changes to the drawing, simply double-click on it to edit it. These non-text elements enhance your Google Sheets, making your data more dynamic, interactive, and easier to interpret. Google Sheets offers a variety of functions to perform calculations and analyze data efficiently. The sum function is used to add together a series of numbers within a range of cells and return the total sum. It's especially useful for quickly calculating totals. The syntax for the sum function is equal sign sum number one, number two, where number one, number two can be individual cells, ranges of cells, or a combination of both. For example, equal sign sum a1 a 10 adds all numbers from cell a1 to a10. Alternatively, equal sign sum a1, b1, c1 adds the values in cells a1, b1, and c1. The average function in Google Sheets calculates the average mean of a set of numbers. It works by summing the numbers and then dividing the results by the count of those numbers. The syntax for the average function is equal sign average, number 1, number 2, where number 1, number 2 can be individual cells, ranges of cells, or a combination of both. For example, equal sign average, b2, b8, calculates the average of the values in cells b2 to b8. Alternatively, equal sign average calculates the average of the values in cells, a1, a2, and a3. The min function in Google Sheets returns the smallest number in a range of cells. It's particularly useful for identifying the minimum value within a dataset. The syntax for the MIN function is equal sine min, number one, number two, where number one, number two can be individual cells, a range of cells, or a combination of both. For example, equals min c2c10 finds the smallest value in the range c2 to c10. Alternatively, equals min a1, b1, c1 returns the smallest value among the values in cells a1, b1, and c1. The max function in Google Sheets returns the largest number in a range of cells, making it useful for finding the maximum value within a dataset. The syntax for the max function is equal sign max number 1, number 2, where number 1, number 2 can be individual cells, a range of cells, or a combination of both. For example, equal sign max d2 d10 finds the largest value in the range d2 to d10. Alternatively, equal sign max returns the largest value among the values in cells a1, b1, and c1. The count function in Google Sheets is used to count the number of numeric values in a range of cells. It only counts cells that contain numbers, excluding text or empty cells. The syntax for the count function is equal sign count, value 1, value 2, where value 1, value 2, and can be individual cells, a range of cells, or a combination of both. For example, equal sign count, equal. Counts how many cells in the range E2 to E10 contain numbers. Similarly, equal sign count A1, a two, a three count and how many of the cells A1, A2, and A3 contain numeric values. These functions are essential for performing basic arithmetic and statistical analysis in Google Sheets. Managing and transforming data in Google Sheets involves key functions that help organize, clean, analyze, and present data effectively.

Sheets Validation Protection Comments Imports

SPEAKER_01 2:12:38

Sorting is one of the most basic functions. You can sort your data alphabetically, numerically, or by date. To do this, select the column you want to sort and then go to Data and select either Sort Sheet or Sort Range. Filtering allows you to view specific data subsets without modifying the original dataset. To apply filters, go to Data, select Create a Filter, and then click on the filter icons in the header row to choose your criteria. This feature helps narrow down the data you need to focus on while keeping the original data intact. Restricting input is a powerful feature in Google Sheets that allows you to control the type of data entered into a cell. By using data validation, you can ensure that only specific data types, such as dates, numbers within a certain range, or selections from a drop-down list, are entered. To set this up, go to data and select data validation. You can also create drop-down lists in cells to ensure consistent data entry. This is done through the same data validation feature, where you can specify a list of allowed values. This method helps prevent errors and ensures that users select from a predefined set of options. Highlighting data with conditional formatting in Google Sheets allows you to visually emphasize certain values or trends within your data. To use this feature, go to Format and then select Conditional Formatting. This will enable you to set up rules such as highlighting cells with values above or below a certain threshold or those that fall within a specific date range. You can also use colour scales and custom rules to further enhance your data presentation. Color scales apply gradients to data, making it easy to see patterns, while custom rules give you more flexibility to format cells based on the specific conditions you define. These visual cues help users quickly interpret and analyze data. Sorting and protecting sheets in Google Sheets helps with organizing and securing your data. To sort sheets manually, click and hold the sheet tab at the bottom of your window and drag it left or right to your desired position. This is helpful for creating a logical order, such as by project or date. For further organization, group related sheets together, making navigation easier. To protect sheets or ranges, go to the data menu and select Protect Sheets and Ranges. This allows you to protect entire sheets or specific ranges from editing. After selecting the sheet or range, you can set permissions to restrict editing or allow specific users to make changes. Additionally, you can set up a warning for editing protected content, notifying users when they try to make changes but allowing them to proceed if needed. By mastering these functions, you can ensure your Google Sheets are organized and secure, improving your ability to manage data effectively. In Google Sheets, adding, replying to, and managing comments is a great way to collaborate with others without altering the data in the sheet. To add a comment, select the cell where you want to leave a note. Right-click and choose comment, or click the comment icon that appears when hovering over the cell. Type your comment in the box and click comment to save it. If you want to notify someone directly, type at followed by their name or email. Others can reply to your comment, allowing for ongoing discussions and clarifications. This helps with asking questions, suggesting changes, or flagging issues. Once the issue has been resolved, you can mark the comment as resolved by clicking the check mark in the top right corner. This removes the comment from view but keeps it accessible in the comment history. To view all comments on a sheet, click the comment icon in the top right corner. This will open a sidebar where you can see both active and resolved comments. In Google Sheets, you can access and manage the revision history of your document to track changes and restore previous versions. To access the revision history, go to File, then select Version History and click See Version History, or simply use the shortcut Kittral plus Alt plus Shift plus H. In the revision history panel, you'll see a timeline of changes made to the document. Versions are listed by date and time, and you can click on any version to view how the sheet looked at that specific point. Changes are colour-coded by user, so you can easily identify who made each change. If you need to restore a previous version, select the version you want and click Restore This version. This feature is helpful if you need to undo a mistake or revert to a specific state of the sheet. Additionally, you can name specific versions to make it easier to identify important milestones or changes, such as before major data update. This helps keep your version history organized and easier to navigate. You can download your Google Sheets in various formats to share or work offline. To do this, simply go to the File menu, then select Download and choose the format that best fits your needs. For instance, if you're sharing with someone who uses Excel, you can download the sheet in Microsoft Excel format to XLSX. If you're working with open source office suites like LibreOffice, the open document format.odis might be the best option. For reports or non-editable versions, you can export your sheet as a PDF. If you need to import data into a database or other software, you can choose the comma separated values format, say SV, which exports only the data in the active sheet. Alternatively, the tab separated values format .etsp uses tabs instead of commas to separate the values. If you'd like to share or publish your sheet online, you can export it as a web page, chmail zipped. Finally, for scripting or coding purposes, you can download your data as plaintext.txt. By using comments for discussions, revision history to track changes, and downloading for offline or alternative use, you can collaborate more effectively with others on Google Sheets. To import a CSV file into Google Sheets, start by opening Google Sheets and creating a new blank spreadsheet. Once you're in, click on the File menu and select Import. This will open a pop-up window where you can choose the Upload tab. You can then either drag and drop your CSV file or click on Select a File from your device to browse and upload it. After selecting your file, you'll be presented with several import options. First, choose where you'd like the data to be placed, either in a new sheet, replacing the current sheet, or appending to existing data. You'll also see the separator character, which Google Sheets usually detects automatically, like a comma or tab, but you can adjust this manually if needed. There's an option to convert text into numbers, dates, and formulas. If you want Google Sheets to interpret the data correctly, just check that box. Once you're ready, click Import Data and the content from your CSV file will appear in your Google Sheet. To import an XLS file into Google Sheets, first open Google Sheets and create a new blank spreadsheet. Then, click on the File menu and select Import. This will open a pop-up window where you can go to the Upload tab. From there, you can either drag and drop your Excel file into the window or click on Select a File from Your Device to browse and upload the file. Once you've selected the file, you'll see a few import options. First, choose where you'd like the data to go, in a new sheet, replacing the current sheet or appending it to existing data. You'll also have an option to let Google Sheets convert text into numbers, dates, and formulas, ensuring that the formatting and formulas are preserved as much as possible. Finally, click Import Data, and the content from your Excel file will be added to your Google Sheet. If you upload a CSV or Excel file directly to Google Drive and open it, Google Sheets will automatically convert the file to a Google Sheets format. This makes it easy to work with different data formats within Google Sheets, allowing for smooth collaboration and effortless sharing in the cloud. This module is designed to provide learners with a comprehensive understanding of Google Slides, from basic presentation

Google Slides Build Design And Media

SPEAKER_01 2:21:03

creation to advanced design techniques. It will guide you through the essential features and capabilities of Google Slides, enabling you to efficiently create engaging presentations, enhance your visual storytelling, and leverage Google Slides for personal and professional use. To add a slide, you can click on the plus icon at the top of the slides panel on the left, right-click in the slides panel and select New Slide, or use the shortcut Catrol plus M on Windows or CMD plus M on Mac to quickly add a new slide. For copying slides, you can right-click on the slide you want to copy in the slides panel and select Duplicate Slide. Alternatively, select the slide, press Catrol plus C Windows, or CMD plus C Mac to copy it, and then press Catrol plus V Windows or CMD plus V Mac to paste. You can also hold down the Cetrol key, Windows, or Option key, Mac while dragging the slide to make a copy. To delete a slide, right-click on the slide in the side panel and select Delete Slide, or simply select the slide and press the Delete or Backspace key on your keyboard. To apply a layout, select the slide you want to change, then click on the layout drop-down in the toolbar and choose your desired layout. To apply a theme, click on the Theme button in the toolbar or go to Slide, then Change Theme. A panel will open on the right side, allowing you to select a theme for your entire presentation. To locate the presenter notes, look at the bottom of the Google Slides interface where you'll see a space labelled Click to Add Speaker Notes. Click there and start typing your notes. These notes will be visible to you in presenter mode but not to your audience. To animate an object in Google Slides, first select the object, whether it's text, an image, or something else. Next, click on Insert, then Animation, or simply right-click and select Animate. A panel will appear on the right where you can choose the type of animation, set its timing, and adjust other options. Finally, click play to preview your animation. To copy a slide, start by selecting the slide or slides you want to copy, then press Catrol plus C Windows or CMD plus C Mac. Next, right-click where you'd like to paste the slide and choose Paste without formatting to match the destination theme. Alternatively, you can paste normally using Catrol plus V or CMD plus V, and when the option appears in the lower right corner, choose either Keep Original Styles or Match Destination Styles. To turn text or an object into a link, start by selecting the text or object you want to link. Then click on the Insert Link icon in the toolbar or use the shortcut Ctrl plus K Windows or CMD plus K Mac. In the dialogue box, you can either paste a URL or choose Slides in this presentation to link to a specific slide. After selecting the slide you want to link to, click Apply. To add a text box in Google Slides, you can use the toolbar by clicking on the text box icon, which looks like TT. After that, click and drag on the slide to create the text box and start typing inside it. Alternatively, you can go to the Insert menu, select Textbox, and then click on the slide where you'd like to place the text box. To change the font in Google Slides, first, select the text you want to modify. Then, in the toolbar, click on the font drop-down menu, which usually displays the current font name, and choose your desired font. To adjust the size, select the text, then click on the font size drop-down menu next to the font name. You can either pick a predefined size or type a specific size in the box. To change the text colour in Google Slides, select the text you want to modify. Then, click on the text color icon in the toolbar, which looks like an A with a colour bar underneath. From there, you can choose a colour from the palette or select Custom to create your own colour. To add a highlight colour, select the text you want to highlight, then click on the highlight colour icon in the toolbar which looks like a highlighter. Choose a color from the palette to highlight your text. To format text in Google Slides, first select the text you want to modify. For bold text, click the bold icon in the toolbar which looks like a B, or use the shortcut Cateril plus B Windows, or CMD plus B Mac. For italics, click the italics icon and i or use the shortcut Cattral plus 1 Windows or CMD plus Y Mac. To underline text, select the text, then click the underline icon, a U with a line under it, or use the shortcut Cattr plus U Windows or SEMD plus U Mac. These formatting tools make your text more visually engaging and easier to emphasize in your presentation. To insert images into Google Slides, you have a few options. To upload an image from your computer, click on Insert, then Image, and choose Upload from Computer. If you want to insert an image from the web, click Insert, then Image and select Search the Web. A sidebar will appear where you can search for images and once you find one, click it and then click Insert. You can also insert images directly from Google Drive, Google Photos, or by pasting a URL. For inserting videos, you can add videos from YouTube by clicking Insert, then Video. You can search for the video directly in the dialog box or paste the YouTube URL. If you want to insert a video from Google Drive, select the Google Drive tab in the Insert Video dialog box. Once your image or video is inserted, click on it to select it. You can resize it by dragging the corners to maintain the aspect ratio or by dragging the sides to stretch it. To move the image or video around the slide, simply click and drag it to your desired position. To insert a chart in Google Slides, click on Insert, then Chart, and choose the type of chart you want, such as bar, column, line, or pie. The chart will be linked to a Google Sheets document, so if you need to edit the data, click on the chart and then click the link icon to open the Google Sheets file. After making changes in Sheets, click Update in Google Slides to reflect those changes. For inserting a table, click on Insert, then Table, and drag to select the number of rows and columns you need. You can format the table using toolbar options like changing the border color, adjusting cell padding, and applying background colours to cells. To insert a diagram, click on Insert, then Diagram. A sidebar will open, offering various diagram types such as grids, hierarchies and timelines. Choose a style and then customize it with options like the number of levels or color scheme. To insert lines in Google Slides, click on the line tool in the toolbar and then select the type of line you want, such as a straight line or an arrow. Once you've selected the line type, click and drag on the slide to draw the line. You can also adjust the line's colour, weight and style, like dotted or dashed, using the toolbar. To insert shapes, click on the shape tool in the toolbar and choose the shape you want, such as a rectangle, circle or arrow. Click and drag on the slide to draw the shape, and then use the toolbar to modify the shape's fill colour, border colour, and border weight. To insert slide numbers in Google Slides, start by clicking on Insert in the top menu, then select Slide Numbers. A dialogue box will appear, giving you the option to apply slide numbers to all slides or skip the title slide. Once you're ready, click Apply to add the slide numbers to your presentation. By default, the slide numbers will appear in the bottom corner of each slide. If you'd like to customize their placement or style, go to the slide master by clicking View and then Theme Builder. From there, you can edit the slide number placeholder to adjust its position or design. These tools allow you to create a dynamic and visually appealing presentation by effectively managing non-text elements. To send an object to the front in Google Slides, select the object you want to move. Right, click on it, hover over order, and then choose Bring to Front. This will bring the object above all other items on the slide. If you want to send the object to the back, select it. Right-click, hover over order, and choose send to back. This will place the object behind all other elements on the slide, allowing you to layer objects as needed. To group objects in Google Slides, select multiple objects by holding down the Shift key and clicking on each one. Once they are all selected, right-click on one of the selected objects and choose Group from the context menu. This will combine them into a single group, making it easier to move or format them together. If you need to ungroup the objects later, simply select the grouped object, right-click on the group, and choose ungroup. This will separate the objects again, allowing you to manipulate them individually. To align objects horizontally in Google Slides, first select the objects you want to align. Then, go to the Arrange menu and select Align. From the options that appear, choose either left, center or right to align the objects accordingly. For vertical alignment, with the objects still selected, go to the Arrange menu again and then select Align. From here, you can choose top, middle or bottom to adjust the vertical positioning of the objects. This ensures your elements are positioned exactly how you want them on the slide. To manually rotate an object in Google Slides, first select the object. You'll then see a rotation handle, which looks like a circular arrow, above the object. Click and drag this handle to rotate the object to your desired angle. For more precise rotation, select the object and right-click on it. From the context menu, choose Format Options. In the Size and Rotation section, you'll find a rotation box where you can enter a specific degree value to rotate the object accurately. This allows for fine-tuned adjustments to the rotation angle. To distribute objects horizontally in Google Slides, first select multiple objects. Then, go to the Arrange menu, click Distribute, and choose Horizontally. This will evenly space the selected objects along the horizontal axis. For vertical distribution, select the objects you want to space evenly. Go to the Arrange menu, click Distribute, and select Vertically. This will evenly space the objects along the vertical axis. To enable Snap 2 guides in Google Slides, these are already enabled by default. As you drag objects close to the guides or other objects, they will automatically snap into place for precise alignment. If you'd like to add custom guides, first go to the View menu and select Show Ruler to display the ruler. Then simply drag from the ruler to create custom guides on the slide for more control over your object placement. To manually resize an object in Google Slides, select the object and click and drag the handles on the corners or sides to resize it. If you want to maintain the aspect ratio while resizing, hold down the Shift key as you drag a corner handle. For more precise resizing, right-click on the object, choose Format Options, and in the Size and Rotation section, you can enter specific dimensions for accurate resizing. These tools help you organize and position objects effectively on your slides, ensuring your presentations are clear and visually appealing. To access Presenter View in Google Slides, click on the Slideshow button in the top right corner. From the drop-down menu,

Present Print Publish And Wrap Up

SPEAKER_01 2:33:10

select Presenter View. Once you're in Presenter View, you'll see your speaker notes, which are only visible to you, helping you stay on track. A timer will also start, showing you how long the presentation has been running, and you'll have indicators for the current slide and the total number of slides. In addition, Presenter View offers audience tools such as the ability to start a Quanda session where your audience can submit questions. You can access this through the Audience Tools tab. To navigate through your slides, use the arrow keys or click directly on the slide thumbnails in the Presenter View window. This setup helps you deliver a smooth and organized presentation. To access print settings in Google Slides, go to the File menu and select Print Preview. In the print layout options, you can choose how you want your presentation to appear. If you select one slide with notes, it will print each slide along with its speaker notes. If you prefer to print just the slides without notes, choose one slide without notes. You can also print handouts by selecting to print multiple slides per page, such as two, three, four, six, or nine slides per page. Another option is Outline, which prints a text outline of your presentation without images or graphics. There are additional settings to customize your printout. You can choose to hide the background to save ink or select between portrait and landscape orientation. You can also choose the desired paper size such as letter or A4. Once you've adjusted your settings, you can either click Print to send your presentation to a printer or choose Download as PDF to save a printable version of your slides. To access the Publish to Web feature in Google Slides, go to the File menu, click Share, and then select Publish to the Web. In the Publishing Settings, you have a couple of options for how you want to share your presentation. First, under the link option, you can get a link to share your presentation. This link automatically plays the presentation in full screen mode when accessed. You can choose to have the presentation start automatically when the viewer opens the link and even set it to restart after the last slide. Alternatively, if you want to embed your presentation on a website or blog, select the Embed tab. Here, you can customize the size and set the auto-advanced timing before copying the embed code to use on your site. You can also adjust the auto-advanced settings for your slides, choosing how long each slide should be displayed before automatically advancing, with timing ranging from every second to every minute. Once you're ready to publish, click the publish button. Confirm your choice and Google Slides will generate a shareable link or embed code. If at any point you no longer want the presentation to be available, simply return to Publish to the Web and click Stop Publishing. These tools help you share and present your Google Slides presentations in various formats, making it easy to distribute your content to an audience, whether in person or online. Although this workshop is coming to a close, we hope that your journey to improve your Google workspace skills is just beginning. We wish you the best of luck on the rest of your travels. Success is the sum of small efforts repeated day in and day out. Robert Collier Persistence is the twin sister of excellence. One is a matter of quality, the other a matter of time. Maribel Morgan Continuous effort, not strength or intelligence, is the key to unlocking our potential. Winston Churchill. Opportunities are usually disguised as hard work, so most people don't recognize them. Anne Landers.