In this video, we dive into the world of Google Chrome - the good, the bad, and its comparison with Microsoft Edge. We start off by exploring the installation process of Google Chrome on Windows, which is a must-know for both new and experienced users. You might be surprised by what you encounter when you search for Google Chrome, so make sure to watch this video to avoid any confusion.

We also introduce you to a unique version of Google Chrome called Chrome Canary. This version offers the most up-to-date features and functionality that you won't find in the regular Chrome. If you're keen on exploring new features and staying ahead of the curve, Chrome Canary is definitely worth checking out.

Once you have Chrome installed, we guide you through the process of signing in to your Google account within Chrome. By doing this, you can easily sync your bookmarks, passwords, and other important data across all your devices, providing a seamless browsing experience. We also touch upon advanced ad protection settings available in Chrome and how you can tailor your ad experience according to your preferences.

By the end of this video, you'll have a solid foundation in the installation and introduction of Google Chrome. Join us in the next lesson as we delve into more exciting features and tips to enhance your browsing experience.

0:00 - Introduction and customization goals

0:08 - Using the "Customize Chrome" option

0:23 - Changing the theme and uploading custom images

0:43 - Choosing solid colours for the appearance

1:07 - Enabling "Refresh Daily" for a changing background

1:20 - Exploring different profiles and assigning colours

2:05 - Browsing themes in the Chrome Web Store

2:17 - Selecting the most popular dark and black themes

2:35 - Exploring additional theme categories

2:50 - Following device colours and customizing for your company

3:32 - Showcasing the options for shortcut customization

4:12 - Using shortcut bookmarks and most visited sites

4:44 - Understanding and utilizing preview cards and memory usage

5:45 - Changing font size and exploring custom font options

6:20 - Adjusting page zoom and font size for readability

Welcome back to the video! In this tutorial, we will be diving into the exciting world of customizing Google Chrome's appearance. So sit back, relax, and let's get started!

The first step is to click on the "Customize Chrome" option, located at the bottom of your browser window. Once you click on it, you will be presented with several appearance options to explore and modify to your liking.

One of the first things you can do is change the theme of your browser. You have the option to select from pre-existing themes or upload your own custom image. This allows you to personalize your Chrome experience with your own style and aesthetics.

If you prefer a simpler approach, you can choose from a range of solid colours for your browser's background. By selecting a colour, you can instantly see the changes take effect, giving your Chrome a fresh new look.

To add some variety, you can enable the "Refresh Daily" option. This feature automatically changes your background on a daily basis, ensuring that each day brings a new visual experience.

Profiles are another great way to customize Chrome. By creating different profiles, you can assign each one a specific colour. This makes it easier to distinguish between profiles at a glance, without having to read through labels or usernames.

If you're interested in exploring more themes, you can head over to the Chrome Web Store. There, you will find various categories, including the most popular dark and black themes. Take your time to browse through and find the perfect theme that suits your style.

In addition to themes, Chrome also allows you to customize the appearance based on your device's colours. Whether you're using a Windows device or a Mac, you can adjust Chrome to follow your device's colour scheme, keeping everything consistent and harmonious.

Creating custom short cuts is another nifty feature of Chrome. You can add short cuts to frequently visited sites, making it quicker and easier to access them with just a click. It's a convenient way to organize your browsing experience.

Preview cards and memory usage are important factors to consider, especially if you experience slow performance on your device. By managing your open tabs and monitoring memory usage, you can optimize Chrome's performance and ensure a smoother browsing experience.

Don't forget to customize the font size and page zoom to your preference. This allows you to adjust the appearance for better readability, catering to your specific needs.

So that wraps up this customization tutorial for Google Chrome.

TIMESTAMPS:

0:00 - Introduction and background information on using password managers in Chrome

0:30 - Overview of the options in Google Password Manager: payment methods, addresses, and passwords

2:30 - Explaining how to add and manage payment methods in Google Password Manager

4:30 - Demonstrating how to add and autofill addresses in Google Password Manager

6:40 - Discussing the improvements made to Google Password Manager in recent updates

8:20 - Explaining how to access Google Password Manager through the Start Menu or by installing the app

10:20 - Explaining how to import passwords from other password managers and how to export passwords from Google Password Manager

12:10 - Overview of the settings in Google Password Manager, including options for password and passkey saving, encryption, and data deletion

14:30 - Demonstrating how to manually add passwords to Google Password Manager and how to edit and share passwords

17:10 - Recommendations for multi-factor authentication apps, including Google Authenticator, Authy, and 2FAs

In this video, we delve into the features and functionalities of Google Password Manager in Google Chrome. We explore how to manage payment methods, addresses, and passwords in Google Password Manager, and how to add and autofill them when needed.

We discuss the recent improvements made to Google Password Manager, making it a robust and reliable tool for managing your passwords. We also demonstrate how to access Google Password Manager through the Start Menu or by installing the app for quick and easy access.

Additionally, we provide guidance on importing passwords from other password managers and exporting passwords from Google Password Manager. We cover the various settings available in Google Password Manager, including options for password and passkey saving, encryption, and data deletion. Furthermore, we show you how to manually add, edit, and share passwords in Google Password Manager.

Finally, we recommend several multi-factor authentication apps, such as Google Authenticator, Authy, and 2FAs, to enhance the security of your accounts. Join us in this informative video to unlock the full potential of Google Password Manager and take control of your online security.

"Pwned" is internet slang that means someone has been "owned" or defeated, often in the context of gaming or online communities. It implies that someone has been beaten so thoroughly that the other person has complete control or power over them.

In tech and cybersecurity, "pwned" means that someone's data or account has been compromised, typically through hacking. For example, if your email account gets hacked, you could say it’s been "pwned" because the hacker now has unauthorized access to it. The site "Have I Been Pwned" lets you check if your email or phone number has been exposed in data breaches, showing if your information has been compromised online.

TIMESTAMPS:

0:00 - Introduction to Google Chrome

1:11 - Using Task Manager in Google Chrome

3:05 - Managing memory and suspending tabs

6:02 - Zooming in and out on web pages

8:02 - Reopening closed tabs and windows

10:25 - Creating and managing tab groups

12:44 - Using incognito mode

In this video, we will explore some useful tips and tricks for Google Chrome, the popular web browser.

First, we'll dive into the Task Manager feature, which allows you to monitor and control the resources used by Chrome.  You'll learn how to access it and how to interpret the information displayed.

Next, we'll discuss how to manage memory effectively in Chrome. You'll discover how to suspend tabs that are not in use, freeing up valuable system resources. This feature can greatly improve your browsing experience and prevent excessive memory usage.

Then, we'll explore the zooming function in Chrome, which enables you to adjust the size of web page content. Whether you need to zoom in or out to improve readability, we'll show you how to do it easily using keyboard shortcuts.

Ever accidentally closed a tab or even an entire window with numerous tabs.  Don't worry, we'll show you how to reopen recently closed tabs and windows, preventing any frustration and time wasted.

In addition, we'll introduce you to tab groups, a handy feature that allows you to organize and group related tabs together. This helps in keeping your browsing sessions tidy and easy to navigate.

And if you want to browse the web privately, we'll explore incognito mode, which allows you to surf without Chrome remembering your browsing history or storing cookies. Great for those confidential searches or temporary browsing needs.

By the end of this video, you'll be equipped with several useful tips and tricks to enhance your experience with Google Chrome.

TIMESTAMPS:

0:00 - Introduction and recommendation to try the tips and tricks yourself

0:18 - Closing tabs and deleting tab groups

0:26 - Accessing the bookmark manager and customizing the bookmarks bar

1:49 - Renaming and managing bookmarks in the bookmark manager

3:54 - Syncing bookmarks across devices

5:00 - Using the right-click menu for various actions

6:26 - Using the Google Lens feature to search for images and text

8:10 - Controlling audio playback with the media controls

9:36 - Muting specific sites to stop unwanted audio

10:49 - Pinning tabs for quick access

11:56 - Accessing additional settings and options in Chrome

Description:

Welcome to the Google Chrome Tips and Tricks video! In this video, we will explore various features and settings in Google Chrome that can enhance your browsing experience. But before we dive in, I highly recommend trying out these tips and tricks yourself for a more personalized experience.

Let's start by learning how to efficiently close tabs and delete tab groups. Organizing your tabs is crucial for a clutter-free browsing experience. Next, we will dive into the bookmark manager, where you can create and manage bookmarks with ease. You can even customize the bookmarks bar to suit your preferences.

If you want to sync your bookmarks across devices, we'll show you how to do that too. Keeping your bookmarks accessible from any device is incredibly convenient.

We'll also explore the right-click menu and its various options. From copying links to searching Google for specific terms, the right-click menu allows for quick actions on web pages.

Another impressive feature we'll cover is Google Lens. This powerful tool enables you to search for images and text directly from web pages, offering a seamless and efficient browsing experience.

Controlling audio playback can sometimes be challenging, but we'll show you how to use the media controls in Chrome to manage audio across multiple tabs.

To avoid unwanted audio interruptions, we'll share a handy trick to mute specific sites, enabling a more peaceful browsing experience.

Pinning tabs is another great way to keep frequently accessed websites easily accessible. We'll guide you through the process of pinning and unpinning tabs effortlessly.

Furthermore, we'll explore the additional settings and options available in Chrome, such as managing Chrome profiles, customizing appearance, controlling default search engines, and more.

By the end of this video, you'll be equipped with a wealth of knowledge on Google Chrome and its various features. So, buckle up and get ready to optimize your browsing experience! If you have any questions or additional tips to share, feel free to ask questions in the Q&A section. Enjoy!

TIMESTAMPS:

0:00 - Introduction to the Omnibox

1:35 - Performing calculations and getting instant answers

2:00 - Currency conversion made easy

2:30 - Checking the weather

3:00 - Searching bookmarks

3:30 - Defining words and terms

5:00 - Exploring Google dorking

8:00 - Narrowing down search results with advanced techniques

Description:

Welcome back to another video about Google Chrome! In this video, we're going to take a closer look at the Omnibox, the URL bar or omnibar at the top of your browser. Gone are the days of separate search and URL bars - now everything is combined into one handy tool.

First off, let's talk about some cool things you can do with the Omnibox. Did you know that you can perform calculations directly in the search bar? Just type in a simple math problem like "24 times 8" and it will instantly provide you with the answer.

Currency conversion is another powerful feature of the Omnibox. Simply type in the amount and the currency you have, followed by the currency you want to convert to, and it will give you the current exchange rate.

If you're wondering about the weather, you can easily find that out too. Just type in your location and it will provide you with the current weather conditions.

Searching for bookmarks has never been easier. Just type in a keyword related to the bookmark you're looking for and it will show up in the Omnibox, saving you time and effort.

But the Omnibox isn't just limited to searching and browsing - it can also be used to define words and terms. Type "define" followed by the word you want to know more about, and it will provide you with a definition.

Now let's dive into the fascinating world of Google dorking. This technique allows you to find specific information on the internet that may not be easily accessible through regular search methods. It can be particularly useful for researchers or enthusiasts looking for specialized content.

Finally, we explore advanced search techniques. By using specific commands like "in URL" or "site", you can narrow down your search results to specific websites or search for specific text on a page. These techniques can improve the accuracy and relevance of your search results.

So, there you have it - a closer look at the Omnibox in Google Chrome. Try out these tips and tricks for yourself and take your browsing experience to the next level. If you have any questions, feel free to leave them in the Q&A section. Happy browsing!

TIMESTAMPS:

0:00 - Introduction

0:20 - Chrome Web Store and its options

1:07 - PDF Wizardry extension

3:44 - Stay Focused and Momentum extensions for productivity

6:32 - Checker Plus for Gmail and Checker Plus for Google Calendar extensions

8:29 - Screen Recorder extension for capturing screenshots and recording videos

11:59 - Conclusion

Welcome to this lesson on Google Chrome extensions! In this video, we'll explore some useful extensions that can enhance your browsing experience.

First, let's talk about the Chrome Web Store. It's a treasure trove of thousands of extensions that can be added to your Chrome browser. With these extensions, you can customize Chrome to suit your needs and boost your productivity. You can find extensions for themes, productivity, and more.

One handy extension is PDF Wizardry. This extension allows you to convert Office documents to PDF files, merge PDF files, and even add images to PDF files. It's a great tool if you work with PDFs frequently and want more flexibility in managing them.

Are you easily distracted while browsing? Stay Focused and Momentum extensions can help you stay on track. Stay Focused allows you to block distracting websites and set limits on your browsing time, helping you stay focused on the task at hand. Momentum transforms your new tab page into a productivity dashboard, displaying various elements like time, goals, and inspiring quotes.

Do you want to stay updated with your Gmail and Google Calendar without constantly checking them? Checker Plus for Gmail and Checker Plus for Google Calendar are two reliable extensions that provide instant notifications and quick access to your emails and events. With these extensions, you can manage your email and calendar more efficiently.

To record videos or capture screenshots, the Screen Recorder extension is a versatile tool. It offers options to capture the entire page or the visible area and even record your desktop or tab. You can easily save and download the recordings or screenshots for later use.

In summary, the Chrome Web Store offers a wide range of extensions to enhance your browsing experience. In this video, we've covered PDF Wizardry, Stay Focused, Momentum, Checker Plus for Gmail, Checker Plus for Google Calendar, and Screen Recorder. Give them a try and let us know if you have any questions or suggestions in the comments below. Don't forget to check the Q&A section for more recommendations from other users. Happy browsing!

So, you looked at the lesson title and thought, "Cool, a lesson on Gmail."

Ha! Gotcha.

No, we are looking at something way more important: your Google Workspace account.

You might be thinking, "But... I just use Gmail. What's the difference?" I get it. I really do. Let's just take a breath. Here’s the thing: your Google Account is the master key to the entire kingdom. It’s your Gmail, yes. But it's also your Google Docs, your Calendar, your YouTube, and even Gemini. It's the one thing that controls everything else.

Honestly? I've worked with so many clients and end-users who have never clicked "Manage your Google Account." They don't know where it is or why it matters... until they get locked out or have a security scare.

This lesson is your personal, guided tour. This isn't a dry manual. We're pulling back the curtain on the most important settings page you probably ignore. We'll skip the jargon and focus on what you actually need to do to take control of your security, your privacy, and your data. By the end, you'll finally understand what all those settings mean and have the confidence that your account is as secure as possible.

What you'll learn

✅ Understand the crucial difference between your Gmail inbox and your "Google Account."

✅ Confidently navigate to the "Manage your Google Account" dashboard—the control panel for everything.

✅ Set up your "lifeline" settings: a recovery phone and email so you never get locked out.

✅ Take charge of your "Data & privacy" and control what Google saves and who gets to see your personal info.

✅ Activate 2-Step Verification (MFA) step-by-step—the single most important thing you can do to secure your account.

✅ Compare all the 2FA methods (Google Prompt vs. Authenticator Apps vs. Security Keys) and pick the right one for you.

✅ Stop reusing passwords! Learn to use the built-in Google Password Manager.

✅ Run a "Password Checkup" to find any of your passwords that have been leaked on the dark web.

✅ Understand what "Passkeys" are and how they are creating a password-less future.

✅ Find out what's eating all your account storage (is it Drive, Gmail, or Photos?) and how to manage it.

This lesson is for:

• Any Google Workspace or Gmail user who wants to finally understand their account.

• New Employees getting familiar with the Google ecosystem for the first time.

• Security-Conscious Professionals who handle sensitive information and need to ensure their account is locked down.

• Anyone who has ever felt overwhelmed by security warnings or privacy settings.

• People who are still using the same password for everything (you know who you are!).

We're talking Gmail.

Whether you're brand new to Google Workspace or you’ve been using Gmail since the "G Suite" days (remember those, when getting an invite was a big deal?), your inbox might look a little different from mine. That's okay! I've set up my screen to look as default as possible so we can find our footing together.

One thing we know for sure? Google always changes things. Seriously, this is probably the fifth time we've re-recorded this particular intro because Google moves the chat bar, renames a product (hello, Google Workspace!), or shifts the layout.

But don't worry. The goal here isn't just to show you what's on the screen today. It's to give you a rough, logical idea of where everything lives. Think of this as getting the lay of the land, a navigational blueprint, so that when things change (and they will!), you'll know where to look.

We're going to demystify the hamburger menu, show you the secret to getting more screen space, explain the difference between a "folder" and a "label" (it's a massive difference, trust me!), and most importantly, show you how to customize your inbox to match the way you work.

Stop wasting time searching for that one crucial email or missing a meeting because Google filed it in the wrong place. Join me, and let's master the most flexible email client out there!

What you'll learn

✅ Master the Layout: Learn how to collapse the sidebar with the "Hamburger Menu" for extra screen space, a lifesaver on smaller monitors.

✅ Understand Integrated Apps: Discover where Chat (your text messaging) and Meet (your video conferencing) live within your inbox and how to use them.

✅ Customize Your View: Set up your preferred inbox configuration, including how to bring back that familiar horizontal or vertical "Reading Pane" (like the old days of Outlook Express).

✅ Labels vs. Folders: Truly understand why Gmail calls them Labels, not folders, and how this powerful, multi-tag system revolutionizes email organization.

✅ Tame the Tabs: Find out why the default "Primary, Promotions, Social" tabs can cause you to miss crucial emails (like that meeting about your raise!), and how to switch them off instantly.

✅ Conquer Conversation View: Learn the pros and cons of grouping emails into threads, and how to switch it off if you prefer to see every email individually. (I'll try not to judge you internally if you keep it on!)

✅ Use the Waffle (Google Apps Launcher): Quickly access all your other Google Apps, from Drive and Sheets to Gemini (the AI tool), without leaving your tab.

✅ Optimize Your Workflow: Maximize efficiency by using the Right-Hand Side Panel to view your Calendar, Keep notes, and Tasks alongside your emails.

This lesson is for:

Everyday Gmail Users looking to stop being confused by the constant layout changes and start feeling competent.

New Google Workspace Users who need a quick, conversational, and comprehensive introduction to the interface.

Email Power Users coming from platforms like Microsoft Outlook who want to replicate their familiar email viewing setup.

Anyone who is tired of missing important emails because they got filed under "Promotions" or "Updates."

Requirements

A Google Account (personal or Google Workspace).

Access to the Gmail web interface.

An open mind, Google will change the layout again eventually, but you'll be ready!

Emails. Are they the greatest invention or the absolute worst? Honestly, that really depends on your life choices, and your process!

We all know the problem: the emails just keep on coming in, and you have to do something with them. You can't just delete them... though, full disclosure, I once was so frustrated I highlighted everything and hit delete. (Spent the next four hours desperately fishing for emails out of the Trash. Don't do that.)

This lesson is all about doing your emails more efficiently.

I'm not going to be one of those internet gurus pushing a rigid system like GTD (Getting Things Done). What works for a productivity expert might feel like a prison sentence to you. I'm going to show you a couple of highly customizable options and let you decide what tickles your fancy.

We'll start with quick visual tweaks like themes and density, then dive into the organizational powerhouses: Important flags, Stars, Priority Inbox, and the game-changing Snooze feature—the only real way to get to "Inbox Zero" without deleting your entire life.

Most importantly, we'll talk about Labels. Forget folders! Labels are Gmail's superpower, allowing you to categorise an email multiple ways. We'll set up a simple, colour-coded labelling system (To Do, Waiting, To Discuss) that lets you scan your inbox and know exactly what action to take, without even having to read the words. It's about working smarter, not harder.

Stop being one of those people with 13,000 unread emails! Let’s get your inbox under control.

What you'll learn

✅ Visual Tweaks for Comfort: Adjust your inbox density (Default, Comfortable, or Compact) and switch to Dark Mode or custom Themes for less violence on your eyes.

✅ Sorting Strategy: Understand the difference between sorting by Important First, Unread First, and Starred First, and how to use these to prioritize your workload dynamically.

✅ Master the Star System: Use Stars as your daily to-do list marker to keep urgent emails at the very top of your inbox.

✅ Set Up Priority Inbox: Combine Unread, Starred, and Important sections into one cohesive view to process your emails in defined stages.

✅ The Two-Minute Rule: Learn the foundational email efficiency philosophy: if an email takes less than two minutes to deal with, do it now!

✅ Colour-coded Organisation: Create and colour-code custom Labels (e.g., Red for Waiting, Yellow for To Do) so you can instantly identify the action required.

✅ The Secret to Inbox Zero: Snooze! Use the Snooze feature to make emails temporarily disappear and pop back up when you actually need them (like the day of that scheduled meeting).

✅ Efficient Processing: Apply multiple labels and Archive emails so they stay searchable but vanish from your primary view, keeping your inbox clean.

This lesson is for:

• Anyone who is overwhelmed by their daily email volume and needs a better system.

• Professionals seeking a customizable workflow that adapts to their personality, not a rigid set of rules.

• New Gmail Users who want to build efficient email habits from day one.

• Anyone looking to leverage the full, powerful feature set of Gmail Labels, Stars, and Snooze for true productivity.

Requirements

• A Google Account (personal or Google Workspace).

• A desire to stop hoarding emails and start touching an email only once. ?

Mastering Gmail's Hidden Formatting and Scheduling Tools.

Stop writing boring emails! Learn to use scheduling, full-screen defaults, and advanced text formatting options to craft clear, strategic, and professional messages.

This isn't a dig at your email writing skills. This is simply saying: we want to write smarter emails.

In this lesson, we're diving into the Compose window, the one place where your emails start their life. There are so many options tucked away in this little box that can dramatically improve your workflow and the clarity of your communication.

Ever get frustrated by that tiny compose box in the corner? We’ll show you the hidden setting to make full screen your default, a small tweak that makes a huge difference. We'll clarify the difference between CC and BCC (and the funny history of "carbon copy").

Most importantly, we're going beyond plain text. You’ll learn how to use formatting tools like numbered/bulleted lists, custom indents, and the power of the Quote feature to respond clearly to specific points in a previous email. Plus, we'll cover the game-changing Schedule Send tool, so you can stop sending emails at 2 AM and start sending them when they'll actually be read.

We're all about being efficient and intentional. Let’s make sure every email you send is professional, easy to read, and hits its mark.

What you'll learn

✅ Compose Window Customization: Control your writing environment with options to minimize, maximize, or "pop out" the message into a separate window using the Shift key.

✅ Set a Full-Screen Default: Learn the trick to make every new message open in full-screen mode instantly, a massive improvement for focused writing.

✅ Understand CC vs. BCC: Get a clear, simple explanation of Carbon Copy (CC) and Blind Carbon Copy (BCC) and when to use each strategically (like BCCing yourself to confirm a scheduled send).

✅ Master Schedule Send: Use the Schedule Send option to write emails now but deliver them at a more appropriate time (like 8:00 AM on Monday), ensuring maximum impact.

✅ Advanced Text Formatting: Use the "A" formatting button to control fonts, size(hello, huge), bold, italic, and underline strategically.

✅ Clear Communication with Lists: Structure your thoughts clearly using numbered and bulleted lists along with indent and outdent options.

✅ The Power of Quote and Strikethrough: Learn to use the Quote button to clearly mark external text and the Strikethrough button to visually track completed items in a to-do list email.

✅ Remove Formatting: Quickly undo all font and colour chaos with the "Remove formatting" button, a lifesaver when you accidentally paste strange text.

This lesson is for:

• Anyone writing an email, from casual users to executives, who wants to improve message quality.

• Users who want to write emails at night but need them to send during business hours.

• Professionals who rely on lists and clear quoting to manage complex projects.

• Anyone who finds the default compose box too small or distracting.

Requirements

• A Google Account (personal or Google Workspace).

• Access to the Gmail compose feature.

P.S. Ready for the next level? In the next lesson, we’re introducing you to Gemini in your email for instant drafting and smart replies. Get ready to level up!

A hands-on guide to drafting new emails, replying with context, and mastering the "Refine" tools... even when it defaults to American spelling!

So, welcome back! Let's talk about the big one: Artificial Intelligence, or AI.

This lesson is for you if your company has access to Gemini for Google Workspace. I'm not talking about the free Gemini app; I mean the paid add-on that integrates right into your workflow. If you don't have it, you can either look into adding it or, hey, you could just watch because I'm really fun.

We're diving straight into my company Gmail account for this one. Why? Because it has real data, real emails, and real context, which is the only way to show you how this actually works. (Don't worry, I'll be blurring out some stuff to protect the innocent!)

First, I'll show you how to know if you even have it. We're looking for that little "Ask Gemini" doodah in the top-right corner, or the "Help me write" prompt when you compose a new email. If you don't see it, go talk to your Google Workspace Admin before you come back.

We'll start with a simple, kind of silly prompt to see what it can do from scratch. But the real magic is in the refining tools. What does “Elaborate” really do? (Spoiler: it adds more... gumph). We'll also test “Shorten” and “Formalise.”

And, of course, I'll show you why you must rate the AI's suggestions. Remember, when the AI eventually takes over and we're all begging for scraps, this rating will probably come back. I intend to be the one handing out the food, so I'm giving it a good rating.

But the real test? Replying with context. We'll take a real security alert email from Google and use Gemini to draft a reply. I'll even leave a spelling mistake in my prompt on purpose to see if the AI is smart enough to fix it.

This also brings us to one of the biggest (and most frustrating) quirks of this brand-new, sparkly tool: spelling. As a South African using “English (UK),” it drives me nuts when it generates text with American spellings (like "unauthorized" with a 'Z'!). We'll talk about this limitation and the one simple prompt you can add to force it to write in British English.

This is a real-world, honest look at what Gemini in Gmail can do right now. It's new, it's not perfect, but it's pretty amazing. Let's figure it out together.

What you'll learn

✅ How to identify if you have the "Gemini for Google Workspace" license enabled in your Gmail.

✅ Use the "Help me write" feature to draft a brand-new email from a simple prompt.

✅ Master the refining tools to instantly "Formalize," "Shorten," or "Elaborate" on any AI-generated text.

✅ Draft contextual replies by using Gemini to read and understand an existing email thread.

✅ See how the AI handles (and fixes) spelling errors in your prompts.

✅ Understand the current limitation with regional spellings (e.g., US vs. UK English) and why your Gmail settings are ignored.

✅ Learn the simple workaround to force Gemini to write in British English (or any other style).

✅ Discover the "Polish" feature to clean up text you've already written yourself.

This lesson is for:

• Google Workspace users whose company has just rolled out the new Gemini add-on.

• Professionals who want to save time and write smarter, more effective emails.

• Anyone curious about the practical, real-world application of AI inside Google Workspace.

• Non-American English speakers who would like to know how to (kind of) fix the annoying spelling defaults!

Requirements

• Your Google Workspace administrator must have the Gemini features enabled for your account.

Unlocking Gmail's Advanced Query Power. Stop struggling to find that one email! Learn to use Gmail's advanced operators, filters, and logical commands to find exactly what you need, instantly.

You're looking at the name of this Google Gmail lesson and thinking, "Oh, I know how to search." I hear you. But let me tell you, Gmail’s search capabilities are a lot more exciting, and powerful, than just typing in a few keywords.

We all know the internet meme about how bad email search is. People blame the big companies. But honestly, sometimes the big companies aren't at fault. You're just not searching properly! No offence, but it’s true. Often, the tools are there, hidden just beneath the surface, and once you know the secret formulas, you’ll never struggle again.

This lesson is your deep dive into the Advanced Search Operators that turn the simple search bar into a finely tuned, email-finding machine. We'll start with the easy, click-based filters for things like attachments and dates, then quickly move into the command-line logic that separates the casual user from the Gmail power user.

You'll learn how to use logical operators like AND, OR, and the powerful minus sign (–) to exclude irrelevant results. We’ll even tackle niche, life-changing formulas like the around: operator, which finds words within a specific proximity of each other. This is the key to conquering that paralysing pile of emails and finally getting control of your inbox.

What you'll learn

✅ Master the Built-in Filters: Quickly refine searches using the drop-down menu for criteria like has:attachment, Documents, Spreadsheets, or messages is:unread.

✅ Use Custom Date Ranges: Define precise search windows using the date operator, like searching for emails after: a specific date or before: a specific time.

✅ Harness Advanced Search: Learn to use the Advanced Search panel to build complex queries without having to type in any code manually.

✅ Find Exact Phrases: Use Quotation Marks ("exact phrase") to force Gmail to find the full, literal string of words, not just the words scattered throughout an email.

✅ Leverage Logical Operators: Use OR to search for an email from "David OR Dave" and use the minus sign (-) to exclude unwanted words, like searching for "dinner -movie".

✅ Use the around: Operator: Discover the highly specialized around:5 command to find emails where two words are within five words of each other—incredibly useful for precise context.

✅ Search by Size and Filetype:Filter emails by attachment size (larger:10m) or specific file extensions (filename:pdf).

✅ Combine Labels and Keywords: Restrict your search to a specific, colour-coded label you set up in the previous lesson (e.g., label:to-discuss and the word "alert") to focus your workflow.

This lesson is for:

• Anyone frustrated by poor email search results who needs to find that one crucial document.

• Knowledge Workers and Project Managers who deal with high volumes of email and need to retrieve information quickly.

• Super Admin Wannabes who want to learn the underlying search language of Gmail.

• The user with 15,000+ emails in their inbox looking for the ultimate way to clean up (HINT: try searching for unsubscribe and deleting all those newsletters!).

Requirements

• A Google Account (personal or Google Workspace).

• Access to the Gmail web interface.

• A willingness to stop blaming the big company and start using the tools they gave you!

Beyond the Send Button: Attachments, Confidentiality, and Meeting Invites. Stop confusing attachments and links! Master the differences between local and Drive files, use Confidential Mode, and schedule meetings right from your compose window.

In the previous lesson, I realized we needed a little more detail! So, let's circle back to the Compose window and cover the essential functions that elevate you from a basic email sender to a strategic communicator. Trust me, even if you think you've seen it all, there are some fun, crucial things inside here.

The single biggest source of confusion is the attachments versus Drive files. We’re here to tell you the difference! We'll show you exactly when to use the local file attachment button versus when to Insert files using Drive, and why one is better for sharing, permission control, and keeping your storage clean.

Beyond attachments, we'll dive into the powerful features that manage your message's life cycle. You’ll learn how to use Confidential Mode to make an email self-destruct after one day (or a week!) and prevent recipients from forwarding or printing. Finally, we'll cover how to professionally Set up a time to meet right from the email, checking your availability and proposing times without the back-and-forth.

Let's make sure you're using every tool at your disposal to send clear, secure, and professional emails.

What you'll learn

✅ Attachment Clarity: Differentiate between attaching a file from your local computer (the paperclip icon) and inserting a file from Google Drive (the Drive icon).

✅ The Power of Drive Links: Understand that Google files (Docs, Sheets, etc.) can only be inserted as a link, and why this is the preferred method for sharing, co-editing, and maintaining version control.

✅ Converting Non-Google Files: Learn how to upload files like PDFs and images to your Drive while composing, giving you the option to send them as a link (with permissions) or a traditional attachment.

✅ Confidential Mode Mastery: Use Confidential Mode to set an expiration date on your email (making it inaccessible after a set time) and block recipients from forwarding, copying, or printing.

✅ Secure Communication: Implement an SMS Passcode requirement for highly sensitive messages sent in Confidential Mode, adding an essential layer of verification.

✅ Professional Signatures: Create and manage a default signature for your outgoing mail, and learn how to insert it dynamically.

✅ Seamless Meeting Scheduling: Use the Set up a time to meet button to either insert a link to your Booking Page or propose multiple times from your calendar directly into the email body, eliminating calendar tag.

✅ Hidden Formatting & Checks: Find the Labels button to apply organization before sending, and quickly access tools like Plain Text Mode and Spell Check.

This lesson is for:

• Anyone who regularly sends file attachments and gets confused about local vs. Drive options.

• Security-Minded Individuals who need to send sensitive information with an expiration date or restricted permissions.

• Professionals who frequently coordinate meetings and want to automate the scheduling process.

• Anyone who missed these features in the basic training and wants to master the Compose window.

Requirements

• A Google Account (personal or Google Workspace) and a connection to Google Drive.

• A willingness to stop sending massive email attachments!

From Simple Summaries to "Fuzzy Searching" and Finding That Hotel Confirmation in Google Drive

Now, back again to using Gemini. This time, we're going to tackle something that plagues all of us: organising the inbox.

I'm going to be honest right from the start: your mileage may vary with how good Gemini is at this. It's new, it's learning. But I'm opening up a real email from my inbox, not a perfect, sanitized example, to show you what it can really do.

We'll start with the basics. When you open an email and pop out the Gemini side panel, you'll see that "Summarize this email" button. This is perfect for when, frankly, your brain is a bit tired, or you've just received a massive newsletter and you don't want to read the whole thing.

But the real magic isn't just in summarizing. We'll explore the prompts I use all the time, like:

"What are the key takeaways from this thread?"

"What are the action items for me?"

This is incredibly useful. If you get a long email from your boss, you can instantly find out: "What am I being told to do?" Gemini can pull those action items out, and you've got a great starting point for a to-do list.

We'll also dive into what I call "fuzzy searching." This is where you can make Gemini work for you without having to remember all those specific search operators. You can just ask it, in plain English:

"Show me my unread emails in my inbox."

"Find the unread emails in my inbox... with attachments."

Now, we'll also see where the AI... fails. You'll see me ask for "unread emails with attachments," and Gemini will come back and say, "No emails match your request"... even when I can see them sitting right there in my inbox! And yes, we'll talk about that.

The real power, though, is when you start combining services. I'll show you my favourite advanced prompt, a real one I used, where I ask Gemini to:

"Find the hotel number and confirmation number from my Italy trip... find it in the Google Drive... and add it to a new email."

And you'll see it do exactly that. It will scan my emails, find my "Best of Italy" trip documents in Google Drive, pull all the hotel names, addresses, and phone numbers, and draft a new email for me, all from one prompt. It even shows its sources, so you know exactly which email, PDF, or folder it got the information from.

Look, Gemini hasn't been around for that long. We're all just starting to figure this out. My advice? Try and chuck it into Gemini. Whatever you're trying to find, whatever you're trying to do... just ask it. You'll be surprised at what it can pull off.

What you'll learn

✅ Use the Gemini side panel to get instant summaries of long emails and threads.

✅ Go beyond summaries by asking for "Key Takeaways" or "Action Items" to find what's important.

✅ Master "fuzzy searching" to find emails using natural language (e.g., "Find my flight confirmation").

✅ See a real-world example of where the AI fails (and why it's important to know its limits).

✅ Draft contextual replies and see how Gemini "hand-holds" you by asking for more information.

✅ Unlock the real power: Watch as we use a single prompt to find information in both Gmail and Google Drive and compile it into a new draft (the "Italy Trip" example).

✅ Understand "Sources" and how Gemini shows you where it's getting its information from (emails, Docs, PDFs, etc.).

✅ Get a list of my favourite, powerful prompts that you can start using today.

This lesson is for:

Google Workspace users with a Gemini license who feel overwhelmed by their inbox.

Anyone who wants to save time digging for old emails, attachments, or confirmation numbers.

Professionals who want to quickly find action items and key information from long email chains.

Curious users who want to see the practical, real-world limits and powers of Gemini.

Gmail Power-User Tips: Mastering the Buttons You Always Ignore

A rapid-fire guide to Archive, Snooze, Add to Tasks, Create Event, Phishing reports, and the pro way to attach an email.

Now, while we've been playing around with emails, you've probably been staring at a dozen other buttons and icons. They're the things you see every day but maybe never click. Well, I'm going to point them out to you now... and you will never not see them again.

This lesson is a high-speed tour of all those little-used features that can seriously make your inbox more powerful.

We'll cover the basics, fast:

• Archive: What's the real difference between this and just leaving it in your inbox? (Hint: It all goes to "All Mail").

• Report Spam: Why this is better than "Delete" (it actually helps your admin block future spam for everyone).

• Delete: ...I'm not going to explain this one.

• Mark as Unread: The simple trick for triaging your inbox.

But then, we get to the really good stuff. I'll show you Snooze, which is incredibly powerful. My favourite pro-tip? Go to your "Sent" items, find an email where you promised to follow up, and snooze it until April next year. It'll pop back into your inbox right when you need it. No more forgetting. It's very, very powerful.

We'll also look at "Add to Tasks" and how it instantly links an email to your task list in the side panel.

And then, the big one: "Create Event." I've used this hundreds of times. You get an email thread, click this one button, and it automatically opens your calendar, adds all the people from the email as guests, and pastes the entire email contents into the description. It's so much quicker than starting from scratch.

We'll also cover:

• Phishing (with a "pH") vs. Fishing (with an "f"): Why "Report Phishing" is the critical button for protecting your security.

• "Show Original": For the tech-heads. We'll peek at the message headers (SPF, DKIM, DMARC). If you don't need it, it's useless. Absolutely useless. But if you do... it's a lifesaver.

• Two ways to attach an email: The slow way (download, then attach the .eml file) and the pro way (just click, drag, and drop it. It's one step shorter, which is useful).

• BONUS CALENDAR TIP: I'll open my calendar—yes, I do yoga, I'm super flexible—and show you how to use the "Email guests" button from inside a calendar event to pre-fill a new email with the title, time, and attendees.

This is a broad overview, but it's packed with snippets that will help you every single day. So, hold on tight. The next lesson is on filtering, and it's even more exciting than you think!

What you'll learn

✅ The REAL difference between "Archive" and "Delete" (and where to find your archived mail).

✅ A pro-tip for "Snooze" that turns your "Sent" folder into a powerful follow-up system.

✅ Instantly create a calendar event from any email, complete with guests and the email body.

✅ How to properly report "Phishing" (with a pH!) and why it's different from spam.

✅ The fastest way to attach an email to a new draft using a simple drag-and-drop.

✅ How to "Email guests" directly from a calendar invite, saving you time and effort.

✅ What "Show Original" is for and when you (as a power-user) might actually need it.

This lesson is for:

• Google Workspace users who want to move from "basic" to "power-user."

• Anyone who feels overwhelmed by their inbox and wants to learn triage tricks.

• Professionals who want to be more efficient at managing meetings, follow-ups, and tasks.

Mastering Gmail Filters: The Ultimate Automation Guide

Go beyond "Star" and "Archive"—Learn to automatically reply with templates, auto-delete, and finally take control of your inbox.

So, as promised in the previous lesson, we are now filtering emails.

You might be thinking, "What's a filter?" Well, let's open an email. We're all on the same page? Cool.

You know that little three-dot menu with the option "Filter messages like this"? That's our starting point. When you click it, Gmail instantly finds all the messages from that sender. But this is where the magic begins, because we can get way more specific.

This is all based on the advanced searching we did earlier. We can filter based on:

• Who it's from

• Who it's to

• The subject

• Or, my favourite has the words."

Let's say we have "Project Snuggles." (I don't know why snuggles, but I'm really enjoying saying it, so we're sticking with it!) You can create a filter that finds any email with the word "snuggles" in it.

But just finding them is boring. The real power is in what you do next. When you create the filter, you get a list of actions that are... well, they get quite exciting.

You can automatically:

• Skip the Inbox (Archive it): Perfect for "Project Snuggles" which, let's be honest, finished 10 years ago. You don't want to see the emails, but you don't want to delete them either. This makes them skip your inbox and go right into the archive, ready for you to search later.

• Star it: This is how you organise. Have you received an email from the CEO? Create a filter to always star it so it lands in your "Priority" inbox.

• Apply a label: Automatically tag all "Project Snuggles" emails with the "Project Snuggles" label.

• Delete it: Just tell it to go away. No archive, no inbox. Just gone.

• Never send to spam: We all have that one client whose emails always go to spam, even though their reputation with the "email gods" should be clean. This filter saves them, every time.

But now... the fun one. The really fun one: Send a template.

Imagine people keep emailing you asking for updates on Project Snuggles. You can create a filter that automatically sends a template reply: "This is our timeline for Project Snuggles. These are our deliverables, our KPIs, our other fun things. We'll get back to you within 24 hours." It's a real-world way to give people an instant response and manage their expectations.

Of course, to send a template, you have to have a template. I'll show you exactly how to create them:

1. Compose a new email.

2. Write your masterpiece (e.g., "Template for KPI Requests").

3. Click the three dots, go to "Templates," and "Save draft as a template."

4. Give it a name. Done.

Now, you can combine these. You could automatically send your "KPI Request" template and then automatically delete the original email. You are in control!

Finally, I'll show you how to apply this to all the existing messages... with one big warning: If you have 99 matching messages and you check "send a template," you are about to send 99 emails. So, just... be careful with that one.

What you'll learn

✅ How to create a powerful filter based on a sender, subject line, or specific keywords (like "Snuggles").

✅ Master all the filter actions: from "Skip the Inbox" and "Apply a label" to "Delete it."

✅ The real-world strategy for using "Never send to spam" to save important emails.

✅ The ultimate automation hack: How to create, save, and manage Email Templates.

✅ How to set up an "auto-responder" by combining filters with the "Send template" action.

✅ How to apply a new filter to all your existing matching conversations.

✅ The one critical mistake to avoid when applying a "Send template" filter to existing messages.

This lesson is for:

• Google Workspace users who get a lot of repetitive emails (like "KPI requests").

• Anyone who wants to automate their inbox and stop manually sorting emails.

• Professionals who want to use Gmail to automatically manage client expectations with template replies.

• Admins of "Project Snuggles" who are tired of answering the same questions!

  
  

You've become "label-crazy" and your inbox is still a mess. Let's fix it and use the "brand spanking new" tool to one-click unsubscribe from all that noise.

Great, you're back.

We're going to look at labels and subscriptions. And you'll notice, I'm back in Michael's test account. Now, you might have this problem... you got excited. You thought, "I need a label for this, I need a label for that." You made 700 labels. And now you've just realised your inbox is more complicated than when you started.

So, let's fix it.

If you scroll all the way down your label list and click "Manage labels," you'll get to the settings. This is where you take back control.

We'll skip the system labels (Inbox, Sent, etc.) and go right to your labels. I'll show you:

• Show/Hide: The basic toggle for the side-list.

• Show if unread: This is the magic one. You can set a label (like my "To discuss" one) to disappear from the sidebar when there's nothing new. As soon as a new unread email gets that label, it pops back up. It’s a great way to clean up your view.

• Show in message list: This lets you hide that little coloured tag next to the email's subject line. You can have a label that's only visible on the sidebar, not cluttering your inbox.

• Actions: Of course, you can also "Edit" (to rename "To discuss" to "To discuss later") or just "Remove" the label entirely.

The "Brand Spanking New" Feature: Manage Subscriptions

Now for the second part. You might see this new blue "Manage subscriptions" link. If you don't, it just means this feature is brand new and rolling out.

Since Michael's test account has no subscriptions, I'm going to switch to my real company email to show you what this does.

This one-page list details every single newsletter and subscription you have. And what you'll see is that it ranks them. The "most virulent"—the ones sending you the most stuff—are right at the top.

From here, you have two options:

1. Go to website: For some (like TikTok), it sends you to their preferences page to unsubscribe.

2. Unsubscribe: For many (like Netflix), it gives you a simple, one-click "Unsubscribe" button right inside Gmail. It'll handle the rest.

But the best feature? If you see a sender and go, "Who on earth is this?"... just click it. Gmail will automatically run a filter and show you every email you've ever received from them. It's the perfect way to decide if you want to keep them or cut them.

I know, I've joked about "Inbox Zero" (I don't believe in it), but this is the real path to a cleaner inbox. If you find a subscription frustrating, if it's just taking up space... unsubscribe from it. It's that simple.

What you'll learn

✅ How to fix "labels" by using the "Manage labels" settings page.

✅ The magic of "Show if unread" to create dynamic labels that disappear when you're done.

✅ The difference between hiding a label from the list versus the message view.

✅ How to use the "brand spanking new" Manage Subscriptions tool to see all your newsletters in one place.

✅ Why Gmail ranks your subscriptions by the "most virulent" senders.

✅ How to one-click unsubscribe from senders like Netflix without ever leaving Gmail.

✅ The best trick: How to click an unknown subscription to instantly filter your inbox and see everything they've sent you.

This lesson is for:

• Anyone who went "label-crazy" and now has an inbox that's even more confusing.

• Users who are drowning in subscriptions and newsletters and want a fast way out.

• "Inbox Zero" skeptics who just want a cleaner and less frustrating inbox.

• Professionals who want to master every single setting Gmail has to offer.

Requirements

• A handful of labels you're probably ready to delete.

• A long list of subscriptions you're definitely ready to delete!

The Gmail Settings Masterclass: A "Love It or Hate It" Deep Dive

A rapid-fire tour of every tab, from "Undo Send" and custom "Stars" to "Send & Archive," "Keyboard Shortcuts," and "Offline Mode."

Now, every time I re-record this course, I find that some people complain about this section. And other people absolutely love this section because they want to get their teeth into it.

So, you may or may not like this section, but we're going in.

We're clicking that little cog in the top-right corner and diving straight into "See all settings." We've been in here a couple of times, but now we're going through it, tab by tab, to give you a full understanding of how to customise your Gmail.

A quick warning: There's a lot of stuff in here, so I'm going to go fairly fast. If you want anything expanded upon, please drop a question in the Q&A section.

Are you ready? Let's go.

We'll spend most of our time in the "General" tab, the command centre of your inbox. We'll cover everything from language settings (and why Gemini still defaults to US English) to the maximum page size.

But we'll focus on the settings that really change your workflow:

• Undo Send: We'll crank this up to the full 30 seconds and I'll explain the one critical mistake (clicking away) that will mess with you every time.

• Send and Archive: This is one of my favourite productivity hacks. I'll show you how to enable this button to reply and clear an email from your inbox in one single shot.

• Smart Compose: Would you like Google to finish your sentences for you... like a girlfriend? It's really quite useful. We'll turn that on.

• Dynamic Email: This is very, very cool. It’s what automatically pulls your flight details, Amazon tracking, or hotel reservations into a neat card at the top of an email.

• Keyboard Shortcuts: Some people love them, some hate them. I love them. We'll turn them on, and I'll show you how you can reply to a message (press 'A') and flip to the next one (press 'N') without ever touching your mouse.

• Custom Stars: This is another really good one. We'll go beyond the default yellow star and add the green tick, the red exclamation, and more, so you can really organise your priority items.

We'll also speed-run the other tabs, hitting the most important parts like Accounts (how to "Send mail as" or delegate access to your PA), Advanced (how to get that "Unread message icon" in your browser tab), and Offline (how to enable offline mail for when you're on a flight or the power goes out, essential for load shedding!).

This is the ultimate settings tour. Let's get your inbox working *for* you, not *working against* you.

What you'll learn

✅ Master the "Undo Send" timer (and the critical "don't click away" mistake you must avoid!).

✅ Enable my favourite productivity hack: The "Send and Archive" button to clear your inbox faster.

✅ Unlock the other stars! Go beyond the simple yellow star and add the green tick, red exclamation, and more.

✅ See the "Personal Level Indicators" (those little chevrons) that show you what's actually important.

✅ Learn the "love 'em or hate 'em" Keyboard Shortcuts (like 'A' for Reply All) that will change how you use your inbox.

✅ Turn on the "Unread Message Icon" in your browser tab—a tiny but super-useful feature.

✅ Understand the "Accounts" tab: How to set up "Send mail as" (aliases) and "Grant access" (delegation).

✅ Enable "Offline Mail" for when the internet (or the power) goes out—perfect for flights, brownouts, or load shedding.

This lesson is for:

• Gmail users who are ready to graduate from "default" to "pro."

• Anyone who loves tweaking settings and customising their tools to perfection.

• Professionals looking for every possible productivity advantage in their inbox.

• Students who have been asking for this deep-dive section (you know who you are!).

Requirements

• A deep breath (we're moving fast!).

• Your "See all settings" button.

Beyond the Default: The Multiple Inbox Masterclass

Stop living in one chaotic inbox. I'll show you two pro-level setups, "Action Triage" vs. "Project Dashboards", to finally take control.

We are now going to be looking at one of my favourite, and most powerful, inbox setups: Multiple Inboxes.

To get there, we're heading back to the cog in the top-right corner, "See all settings," and then to the "Inbox" tab. Yours is probably on "Default" or maybe "Important first" (we've discussed those). Today, we're selecting "Multiple inboxes."

Now, the default it gives you is is:starred and is:drafts. And... if we save that, you'll see your inbox change a little. You get a new "Drafts" section. But... it doesn't feel that much different, does it?

Okay. Let me show you the way.

You only get five of these sections, so you have to be smart. I'm going to show you my two favourite set-ups. You might hate them, or you might love them and want to tweak them for your own use. I'll include the queries for both in the resources.

Pro Setup #1: The "Action-Oriented Triage"

If you've watched enough hospital movies, you know what "triage" is: dealing with the most important stuff first. This setup is for people who want to see what's on fire.

• Section 1: Urgent We'll set this to is:unread AND has:red-star. I'll show you how to use those different coloured stars we enabled in the last lesson.

• Section 2: Awaiting Reply We'll set this to is:starred AND -has:red-star (meaning, any other star).

• Section 3: Everything Else Unread This will simply be is:unread.

The result? When you open your inbox, it's already sorted for you. You'll see "Urgent" at the top, followed by what you're waiting on, and then the rest of your unread mail. Everything else (the "read" mail) sits in the normal inbox at the bottom.

Pro Setup #2: The "Client/Project-Based Dashboard"

This is honestly the way I prefer to work, because I don't like to deal with things in a panic. I like to see things organised by project or client.

• Section 1: Client A We'll set this to label:Client-A.

• Section 2: Project X We'll set this to label:Project-X.

• Section 3: Other Unread This will be is:unread AND -label:Client-A AND -label:Project-X.

Now, I know you've only got five slots, so if you have 100 clients, this won't work—but you can pick your top five! I'll show you how to create these labels "on the fly" and instantly see your emails pop into these new sections.

There are so many ways to work with your Gmail: stars, labels, green ticks, priority... This lesson will give you two powerful, practical dashboards to choose from.

What you'll learn

✅ How to enable and configure the "Multiple Inboxes" feature in your Gmail settings.

✅ Why the default "is:starred" setup isn't enough and how to make it way more powerful.

✅ Pro Setup #1: The "Action-Oriented Triage" — Learn to use special-coloured stars (like has:red-star) to build an "Urgent" inbox.

✅ Pro Setup #2: The "Client/Project-Based Dashboard" — Use labels to create dedicated inboxes for your most important clients or projects.

✅ The exact search queries (is:unread, has:red-star, label:Project-X) you need to copy and paste.

✅ How to create and apply new labels "on the fly" to feed your new dashboard.

✅ The core philosophy of why you'd choose one of these pro-setups over the other.

This lesson is for:

• Google Workspace users whose single inbox feels chaotic and disorganised.

• Anyone who deals with multiple, high-priority projects or clients at the same time.

• Professionals who want a "triage" system to quickly identify what's most important.

• Users who tried "Important First" or "Unread First" and still felt it wasn't enough.

Requirements

• An open mind to completely changing your inbox (for the better!).

• Having your different-coloured "Stars" enabled (from the previous lesson) is helpful for the Triage setup!

TIMESTAMPS:

0:00 - Introduction
0:03 - Accessing Google Contacts
0:33 - What Are Contacts?
0:48 - Creating a Single Contact
2:03 - Adding Multiple Contacts
6:00 - Synchronizing Contacts with Google Workspace
7:27 - Using Labels in Contacts
8:42 - Understanding the Directory Feature
9:19 - Sending Emails from Directory

This video introduces Google Contacts, a key feature in Google Workspace that helps you manage contact information seamlessly across your devices. Here's what you'll learn:

• Accessing Google Contacts:

  • Visit contacts.google.com directly or navigate via the Google Apps menu (the "waffle").

• What Are Contacts?

  • Contacts store information such as email addresses, phone numbers, physical addresses, and notes about individuals or businesses.

• Creating Contacts:

  • Add individual or multiple contacts.

  • Enter detailed information such as names, email addresses (work/home), phone numbers, and physical addresses.

  • Assign labels like "Work" or "Home" for better organization.

• Using Labels:

  • Group contacts under specific labels (e.g., "Company A").

  • Import multiple contacts using CSV files and assign them to a label for easier management.

• Syncing with Devices:

  • Install the Google Contacts app on your Android phone for automatic synchronization with your Google Workspace account. This ensures your contacts are backed up and accessible if your device is lost or replaced.

• Managing Contacts:

  • Edit, delete, or favourite contacts.

  • Organize contacts using labels and streamline communication with group-specific actions like emailing or exporting contacts.

• Directory Integration:

  • Access your organization’s directory, listing all employees or key stakeholders.

  • Move directory entries into your personal contacts or email them directly via Gmail integration.

Practical Tips

1. Sync and Backup: Always enable syncing to ensure your contacts are secure and updated across all devices.

2. Label Contacts: Use labels like "Clients" or "Team Members" for quick filtering and organization.

3. Leverage CSV Import: Save time by importing bulk contacts using a well-formatted CSV file.

4. Clean Up Contacts: Use tools like "Merge and Fix" to remove duplicates and maintain a tidy contact list.

This foundational knowledge ensures that managing your contacts in Google Workspace is efficient and stress-free.

This video walks through advanced features of Google Contacts within Google Workspace. It focuses on practical tools to help you manage and organize your contacts efficiently. Here's a concise summary of the key points covered:

1. Frequent and Other Contacts

   • Frequent Contacts: Lists people you engage with often, ranking them by interaction frequency. Contacts you engage less with over time move down the list.

   • Other Contacts: Stores email addresses you've interacted with but haven’t formally added to your contact list. A simple click on the "+" icon saves them to your contacts.

2. Merge and Fix Duplicates

   • Merge Duplicates: Consolidates duplicate contact entries from various sources (e.g., CRM, phone apps). You can review and merge individually or all at once for efficiency.

   • Add Details: Automatically suggests adding missing information (like email addresses) to existing contacts.

3. Import and Sync Contacts

   • Import contacts from a CSV file to Google Contacts.

   • Sync contacts across devices, including Android, iOS, and desktop.

   • Backup options for mobile contacts ensure seamless integration.

4. Trash Management

   • Deleted contacts remain in the trash for recovery if needed.

5. Using Contacts in Gmail

   • Access your contact list directly while composing emails in Gmail.

   • Use features like CC/BCC and filters for selecting recipients by labels or categories (e.g., starred contacts).

   • Create and manage labels to group contacts for targeted communication.

6. Side Panel Integration

   • The side panel in Gmail allows quick access to Google Contacts while viewing or composing emails.

   • Contacts related to the ongoing email conversation appear automatically for easy reference.

These features are designed to simplify contact management, improve email efficiency, and ensure your address book stays organized as your network grows. If you’re managing multiple professional or personal connections, these tools can save you significant time.

Master Google Calendar: Organize Your Time, Boost Productivity, and Conquer Scheduling Challenges

This comprehensive video tutorial provides a detailed walkthrough of Google Calendar, empowering you to streamline your schedule, enhance collaboration, and maximize your efficiency. Whether you're a beginner or an experienced user seeking advanced techniques, this guide will equip you with the skills and knowledge to become a Google Calendar pro.

What Viewers Will Learn:

This video delivers a practical, step-by-step guide to Google Calendar, covering everything from basic navigation and event creation to advanced features like time zone management and recurring events. You'll learn how to:

* Navigate the Google Calendar interface effectively, utilizing both mouse clicks and keyboard shortcuts for faster input (including the "A" shortcut for creating new events and "T" for returning to the current day).

* Create and manage events with precision, including setting specific times, durations, locations, reminders, and adding guests.

* Utilize advanced features such as "Appointment Scheduling," "Time Insights" (if available in your Google Workspace plan), and the integrated Tasks functionality.

* Master the art of recurring events, scheduling appointments that repeat weekly, monthly, or annually, with customizable stop dates.

* Effectively manage events across multiple time zones, ensuring accurate scheduling for international collaborations and meetings.

* Leverage Google Calendar's integration with other Google services like Google Meet and Google Drive, enhancing collaboration and workflow.

* Customize your calendar view to optimize your workflow and manage multiple calendars efficiently.

* Understand and manage event permissions, controlling visibility and allowing for collaboration or individual privacy.

* Proficiently use Google Calendar notifications and email reminders to ensure you never miss an important event, providing customizable alerts.

* Effectively delete or modify events, choosing between deleting single instances, recurring events, or entire series of events.

Benefits and Opportunities:

By mastering Google Calendar, you unlock several key benefits:

* Enhanced Time Management: Gain unparalleled control over your schedule, preventing scheduling conflicts and maximizing productivity.

* Improved Collaboration: Seamlessly collaborate with colleagues, clients, and friends, scheduling meetings and events effortlessly.

* Increased Efficiency: Streamline your workflow by integrating tasks and appointments within a single platform, reducing context switching.

* Better Organization: Centralize your appointments, deadlines, and reminders for improved organization and reduced stress.

* Enhanced Communication: Improve communication through clear and concise event details, including locations, descriptions, and attachments.

* Global Collaboration: Easily schedule meetings across various time zones, removing the difficulty of managing time differences.

* Proactive Scheduling: Plan ahead effectively with recurring events and utilize the calendar to anticipate and prepare for upcoming commitments.

Pain Points Addressed:

This video directly addresses common Google Calendar challenges:

* Difficulty Navigating the Interface: The tutorial provides clear, step-by-step instructions on how to navigate the calendar effectively, using both mouse and keyboard shortcuts.

* Struggles with Event Creation: The video offers a comprehensive guide on creating and customizing events, including setting reminders, adding guests, and managing locations.

* Challenges with Recurring Events: Learn how to effortlessly set up recurring events with customizable start and end dates, solving the problem of repetitive manual scheduling.

* Time Zone Confusion: The video clearly explains how to manage events and meetings across different time zones, eliminating time-related misunderstandings and scheduling conflicts.

* Lack of Organization: The video demonstrates strategies for organizing multiple calendars and leveraging features like labels and colors for improved clarity and efficiency.

* Ineffective Collaboration: Learn how to utilize Google Calendar's integration with Google Meet and Drive to seamlessly share information and coordinate with others.

This video is your definitive guide to mastering Google Calendar, transforming your scheduling from a source of stress into a powerful tool for productivity and success. This detailed guide empowers you to take control of your time and achieve your goals. Learn to unlock the full potential of Google Calendar today!

Frequently Asked Questions about Google Calendar

Q: How do I access my Google Calendar?

A: You can access your Google Calendar by going to calendar.google.com, clicking on the calendar icon in your Google Apps Launcher (or "waffle"), or through the apps section on your device.

Q: What are the basic functions of Google Calendar?

A: Google Calendar allows you to create events, view your schedule by day, week, month, or year, search for specific people's availability, and integrate tasks. You can also add locations, descriptions, attachments, and set reminders/notifications.

Q: How do I create a new event?

A: Single-click on a time slot in your calendar. You can then add a title, time, guests, location, description, attachments (like Google Drive files), and set notification preferences (email reminders, pop-up alerts).

Q: How do I add guests to an event?

A: During event creation, you can type in the names of people you want to invite. You can also control their permission levels (modify, invite others, view only).

Q: How do I set reminders for events?

A: You can set reminders for events by choosing a timeframe (e.g., one hour before, five minutes before) You can have multiple types of notifications, including pop-up alerts and email reminders.

Q: How do I add a location to an event?

A: You can type in the location (e.g., "coffee shop," "gym name," or a full address). If you provide a full address, it will integrate with Google Maps for easy navigation on your phone.

Q: How do I manage recurring events?

A: When creating or editing an event, you can set it to repeat daily, weekly, monthly, or on a custom schedule. You can also specify an end date for the recurring event.

Q: What are "Time Insights"?

A: Time Insights is an advanced feature (part of Google Workspace advanced licenses) that provides more detailed analytics and information about your schedule. Availability may depend on your Google Workspace plan.

Q: What is the difference between "Busy" and "Free" event status?

A: Setting an event to "Busy" prevents others from seeing that time slot as available for scheduling. "Free" allows others to see that time as available for meetings or appointments.

Q: How do I manage the visibility of my calendar events?

A: You can control the visibility of events by setting them to "Public" (everyone can see), or "Private" (only you can see, unless you've granted specific permissions to others).

Q: How do I delete an event?

A: You can delete a single event, recurring events following a certain date, or all recurring events from the options presented when you click to delete an event.

Q: How do I deal with events in different time zones?

A: When creating or editing an event, you can select the appropriate time zone from a list of options. The event will then display correctly for attendees in their respective time zones.

Q: How do I find today's events quickly?

A: You can click the "Today" button, or use the keyboard shortcut "T" to quickly return to the current date view.

Master Google Calendar: Add, Customize, and Integrate Calendars for Seamless Scheduling

This comprehensive tutorial dives deep into the powerful features of Google Calendar, showing you how to effortlessly manage your schedule and integrate various calendars for optimal productivity. Forget juggling multiple apps – this video unlocks the potential of Google Calendar for both personal and professional use.

What Viewers Will Learn:

This video provides a step-by-step guide to mastering Google Calendar functionality, covering key aspects such as adding new calendars, customizing their appearance, managing access permissions, and integrating external resources. You'll learn how to seamlessly integrate birthdays from Google Contacts, subscribe to public calendars featuring holidays, sports events, and even humorous excuses for IT-related issues. Furthermore, the video explains how to add calendars from URLs and leverage the power of integrated resources within Google Workspace for efficient scheduling and team collaboration. You’ll understand the advantages of using native Google apps for optimal synchronization and accessibility across devices. The tutorial focuses on practical application, demonstrating how to add and manage calendars for diverse needs, including personal appointments, work projects, team events, and shared resources like meeting rooms.

Benefits and Opportunities:

After watching this video, you’ll be equipped to:

* Streamline your scheduling: Consolidate all your appointments, events, and reminders into one centralized platform.

* Enhance team collaboration: Effortlessly share calendars with colleagues and streamline team scheduling for meetings and projects.

* Boost productivity: Access and manage your schedule from any device, eliminating the need for multiple calendar apps.

* Personalize your calendar: Customize calendar appearance and settings to suit your individual preferences and workflows.

* Leverage pre-built resources: Discover and integrate pre-existing calendars for holidays, sports, religious events and more, all directly within Google Calendar.

* Improve communication: Utilize the “excuse” calendar for humorous responses regarding delays or technical issues.

* Optimize resource booking: Manage bookings for meeting rooms and other shared resources effectively.

* Integrate with other Google Workspace apps: Experience the seamless integration between Google Calendar, Google Contacts, and other Workspace applications for improved efficiency.

Pain Points Addressed:

This video addresses common challenges faced by users who struggle to manage multiple calendars or who aren’t fully leveraging Google Calendar's capabilities. Specifically, it tackles the following pain points:

* Difficulty managing multiple schedules: Learn to consolidate all your calendars into a single, organized view within Google Calendar.

* Lack of awareness about advanced features: Discover hidden features like adding external calendars, customizing appearance, and managing access permissions.

* Inefficient team scheduling: Learn how to effectively share calendars and improve team collaboration for seamless scheduling.

* Limited integration with other apps: Understand the benefits of using native Google apps for better synchronization across devices and the broader Google Workspace ecosystem.

* Uncertainty about adding external calendars: The video provides clear instructions on how to subscribe to public calendars and add calendars from URLs.

* Need for creative excuses for delays: The video introduces a humorous "excuse calendar" for lighthearted solutions to technical challenges.

* Trouble booking shared resources: Learn how to utilize Google Calendar to book meeting rooms and other resources, avoiding double-bookings and conflicts.

This video is perfect for anyone seeking to optimize their time management, enhance team collaboration, and unlock the full potential of Google Calendar. From beginners to experienced users, this tutorial offers practical tips and actionable strategies to improve your productivity and simplify your scheduling. Learn how to leverage the power of Google Calendar to manage your life and work more effectively. Improve your scheduling today!

Frequently Asked Questions (FAQs) about Google Calendar:

Q1: How do I add a new calendar in Google Calendar?

A1: Go to "Other calendars," click the plus sign, select "Create new calendar," give it a name (e.g., "Sewing Classes"), a description, choose your time zone, and click "Create calendar."

Q2: How do I change the color of a calendar?

A2: After creating a calendar, you can change its color by going to the calendar's settings. When adding an event, you can also select the color from the dropdown menu under "Admin user."

Q3: How do I add holidays or other events from external sources to my calendar?

A3: Go to "Other calendars," click the plus sign, and select "Browse calendars of interest." You can then choose from various options like holidays in different countries, sports schedules, phases of the moon, and more. You can also add calendars from a URL by going to "Add calendar from URL" and pasting the link.

Q4: How do I add a calendar from a URL?

A4: Go to "Other calendars," click the plus sign, select "Add other calendars," choose "Subscribe to calendar," paste the URL into the box, and click "Add calendar."

Q5: Why should I use the Google Calendar app instead of other calendar apps (like Outlook or Apple Calendar)?

A5: Google Calendar integrates seamlessly with other Google Workspace apps (Gmail, Drive, etc.). This makes scheduling and managing events much easier. Using native apps ensures proper synchronization and avoids potential issues with visibility across devices. It also provides the benefit of easily sharing and viewing your calendars with other Google Workspace users.

Q6: How do I make my calendar visible or invisible on my phone?

A6: On your phone's calendar app, you can toggle the visibility of specific calendars (like the "Sewing Classes" calendar in the example) on or off. When a calendar is off, it will not show events from that calendar. This is another reason it is recommended to use native Google apps for better integration.

Q7: How can I get a daily "excuse" for IT issues added to my calendar?

A7: There is a "B-O-F-H" (a humorous IT excuse calendar) available online. Find its URL, copy the link, go to your Google Calendar, add a calendar from URL, paste the link, and add the calendar. This will add daily excuses to your calendar. (Note: the instructor strongly implies this is for fun and shouldn't be used to actually deceive).

Q8: How do I add shared resources like meeting rooms to my calendar?

A8: If your Google Workspace admin has set up calendars for resources like meeting rooms, you can find and add them through the "Browse resources" option in "Other calendars."

Q9: What should I do if I have further questions about adding calendars?

A9: Post specific questions in the Q&A section of the course for further assistance. The link to the "excuse" calendar is also provided as a resource.

Master Google Calendar Sharing: A Comprehensive Guide for Individuals and Businesses

This video provides a step-by-step tutorial on effectively sharing Google Calendars, covering everything from basic sharing to advanced configurations for businesses and schools. Learn how to control access, manage permissions, and integrate your calendar seamlessly into your workflow and website. Whether you need to share your schedule with family, colleagues, or the public, this guide will empower you to manage your calendar with precision and ease.

What Viewers Will Learn:

This tutorial will equip you with the essential skills to effectively share your Google Calendar, regardless of your experience level. You'll learn how to:

* Export your Google Calendar for offline access as an iCal file (.ics).

* Share your calendar publicly, allowing anyone to view your schedule (with options to control visibility - free/busy, or full details).

* Share your calendar privately with specific individuals, setting granular permissions to control their access level (view only, edit, manage sharing).

* Utilize shareable links to provide quick and easy access to your calendar.

* Manage access permissions for internal and external users within Google Workspace (or equivalent business environments).

* Configure event notifications (email reminders, duration before event, all-day notifications).

* Integrate your calendar onto a website using iFrame code, ideal for schools or businesses publishing events.

* Control video conferencing options for events (Google Meet integration).

* Understand and configure various settings within Google Calendar’s "Settings and Sharing" menu, including working hours display and external invitation warnings.

Benefits and Opportunities:

After watching this video, you will be able to:

* Streamline communication and collaboration by effortlessly sharing your schedule with colleagues, clients, or family members.

* Enhance productivity by providing others with access to your availability, reducing scheduling conflicts and email back-and-forth.

* Increase transparency and efficiency within teams and organizations by making company events and schedules readily available.

* Improve website engagement by embedding your calendar directly, offering users an interactive view of upcoming events.

* Simplify event management for schools or organizations with numerous events, providing parents or employees easy access to information.

* Leverage Google Calendar's advanced features, such as granular permission controls and integration options, for more efficient calendar management.

* Create professional and polished scheduling systems by configuring advanced settings such as external sharing limitations and notifications.

Pain Points Addressed:

This video directly addresses several common challenges related to Google Calendar sharing:

* Difficulty sharing calendars with individuals outside your organization or domain.

* Uncertainty about controlling the level of access granted to others (view-only vs. edit permissions).

* Confusion regarding the use of shareable links and their security implications.

* Lack of understanding of the available settings within Google Calendar’s sharing options menu.

* Challenges in integrating your Google Calendar with a website or other platforms.

* The struggle of managing notifications for multiple calendars and events.

* Need for a simple, yet powerful method to share events with a large audience (schools, businesses).

* Questions regarding public vs. private calendar sharing and its implications for privacy and data security.

* Concerns about efficiently managing calendar access for different stakeholders, like employees, clients, and the public.

This comprehensive guide provides clear, practical solutions to these pain points, empowering you to confidently share your Google Calendar in any situation. Improve your workflow and communication today by watching this video and mastering the art of Google Calendar sharing. Learn how to efficiently share your schedule, control access, manage permissions, and integrate your calendar for a seamless user experience.

Frequently Asked Questions about Sharing Google Calendars:

Q: How can I share my Google Calendar with others?

A: There are several ways to share your Google Calendar:

* Export: You can export your calendar as an iCal (.ics) file, but this is a static snapshot and won't update live. Use this for archiving, not live sharing.

* Shareable Link: Generate a shareable link. This allows others to view your calendar without needing to sign in (if you make it publicly accessible). However, public access may require Google Admin approval.

* Share with Specific People: Add individual email addresses to share your calendar with specific people. You can control their access level (free/busy, all details, edit permissions).

Q: What are the different access levels I can grant when sharing a calendar?

A: You can choose from several permission levels:

* See only free/busy information: Recipients see only when you're available, not details of your events.

* See all event details: Recipients see the title and description of your events.

* Make changes to events: Recipients can edit your events.

* Make changes and manage sharing: Recipients can also change who else has access to the calendar.

Q: My "See all event details" option is grayed out. Why?

A: This is usually due to company policy. You'll need to contact your Google Workspace administrator to enable this option.

Q: How do I share my calendar with someone outside my company/Google Workspace?

A: You can share with external users, but the options might be restricted by your company's settings. You might only be able to share free/busy information or all event details, but not allow them to make changes. This is configurable in Google Workspace admin settings.

Q: How can I embed my calendar on a website?

A: You can generate an iframe code for your calendar and embed it into your website's HTML. This creates a live, viewable version of your calendar on the website. Users can view details but typically not edit unless explicitly granted permission.

Q: How do I set up event notifications for a shared calendar?

A: You can customize notification settings for each calendar independently. You can choose to receive email reminders a certain amount of time before an event (e.g., one day before).

Q: Can I control whether video conferencing is added to my events automatically?

A: Yes, Google Calendar settings allow you to control whether video conferencing (like Google Meet) is automatically added to new events.

Q: Can I prevent notifications when inviting external users to events?

A: Yes, you can disable notifications about external invitations in your calendar settings.

Q: How can I manage working hours and their display on my calendar?

A: You can set your working hours within your Google Calendar settings and choose whether or not these hours are displayed on the calendar.

Master Your Google Calendar: Optimize Settings & Unlock New Features

This in-depth tutorial will transform your Google Calendar experience, teaching you to leverage its powerful features for increased efficiency and productivity. We go beyond the basics, delving into settings often overlooked, and showcasing exciting new additions from Google. Whether you're a seasoned Google Calendar user or just starting, this video provides valuable insights and practical strategies to streamline your scheduling and time management.

What Viewers Will Learn:

This video provides a comprehensive guide to Google Calendar's advanced settings and features. You'll learn how to:

* Customize your Calendar's appearance: Master the nuances of light, dark, and device default modes, experiment with text color schemes (modern vs. classic), and adjust display options (responsive vs. compact) to optimize visual comfort and readability. Discover how to best tailor your calendar view for optimal screen sizes.

* Manage multiple time zones: Effortlessly navigate global collaborations by setting primary and secondary time zones, and utilizing the world clock feature for seamless scheduling across various locations. Learn how to effectively display multiple time zones simultaneously on your calendar for clarity and accuracy. This includes a step-by-step guide on adding and managing multiple time zones, including India, Australia, and the UK.

* Optimize meeting durations: Maximize your time and minimize scheduling conflicts by adjusting default meeting durations (60, 45, 30, 15 minutes or even Google's new "speedy meetings" option). Learn how to leverage these settings to reclaim valuable time in your day.

* Control guest permissions: Understand and customize guest access to your calendar events, deciding whether guests can modify events, invite others, and see the complete guest list. This ensures better control over your scheduling and prevents unwanted alterations.

* Manage calendar invitations: Learn to refine how invitations are added to your calendar, prioritizing invitations from known senders and controlling how email responses impact your calendar entries. This safeguards against unwanted calendar entries from unknown sources.

* Fine-tune notification alerts: Personalize your alert settings, choosing between desktop notifications, sounds, and snooze options. Customize notification frequency and triggers (e.g., only for events you've accepted).

* Customize your calendar view: Explore options to show/hide weekends, declined events, completed tasks, week numbers, and adjust the display of shorter events, providing complete control over your calendar's visual representation.

* Utilize working hours and location settings: Effectively manage your work schedule by defining working hours, specifying locations (home, office, remote, etc.), and using the location details to share your availability with colleagues and clients. Understand the importance of the “main office building” setting for streamlined collaboration.

* Master keyboard shortcuts: Accelerate calendar navigation with quick keyboard shortcuts for day, week, month, year view, adding events, and other crucial actions. A complete list of shortcuts is included to facilitate efficient calendar management.

* Utilize the trash and print functions: Learn how to recover accidentally deleted events from the trash and how to print your calendar in different formats, ensuring accessibility and backup options.

* Understand Google Calendar Add-ons: Get a preview of the additional functionality that can be added to Google Calendar with add-ons to enhance customization and integration.

Benefits and Opportunities:

By mastering the techniques in this video, you’ll experience:

* Increased Productivity: Streamline your scheduling, reduce conflicts, and manage your time more effectively.

* Improved Collaboration: Enhance teamwork and communication by easily coordinating across time zones and locations.

* Reduced Stress: Simplify your calendar management and minimize the frustrations of scheduling complexities.

* Enhanced Organization: Gain better control over your schedule and events, leading to a more organized and less chaotic workday.

* Personalized Experience: Customize your Google Calendar to perfectly suit your workflow and preferences.

Pain Points Addressed:

This video addresses several common Google Calendar challenges, including:

* Difficulty managing multiple time zones: Learn to seamlessly handle meetings and appointments across different geographical locations.

* Frustration with default meeting lengths: Optimize your meeting durations to reflect your work style and availability.

* Unwanted calendar entries from unknown senders: Take control of your calendar by filtering invitations and managing guest permissions.

* Inefficient calendar navigation: Master keyboard shortcuts and advanced view settings to quickly access and manage your schedule.

* Lack of visual customization: Tailor your calendar's appearance for optimal readability and personalized comfort.

* Confusion with working hours and location settings: Learn how these new features can enhance your productivity and communication.

This video is an essential resource for anyone seeking to unlock the full potential of Google Calendar. Learn to navigate the intricacies of its settings and harness its advanced features for a more productive and organized professional life.

Frequently Asked Questions about Google Calendar Settings

Q: How can I change the appearance of my Google Calendar?

A: Click the settings cog. Under "Appearance," you can choose between "Light," "Dark," and "Device default" themes. You can also select a color scheme ("Modern" with white text or "Classic" with black text) and choose between "Compact" and "Responsive" information display, adjusting the calendar's density based on your screen size.

Q: How do I change the language, region, date, and time formats in my Google Calendar?

A: In the settings cog, under "Settings," you can adjust your language and region. You can also specify your preferred date format (e.g., month/day or day/month) and time format (12-hour or 24-hour).

Q: How can I display multiple time zones in my Google Calendar?

A: In the settings, you can set your primary time zone. To add secondary time zones, enable "Show world clock" and add the desired time zones. These will be displayed on the left side of your calendar view, showing the time in those zones alongside your primary time. Alternatively, you can set a secondary time zone directly in settings.

Q: How can I change the default duration of my calendar events?

A: In the "Settings," you can change the "Default event duration" from 60 minutes to a shorter duration (e.g., 30 minutes, 15 minutes). Google also offers a "Speedy meetings" option for 25-minute events to incorporate short breaks between meetings.

Q: How do I control guest permissions for my calendar events?

A: Under "Settings," you can control whether guests can modify events, invite others, and see the guest list. You can customize these permissions to suit your preferences.

Q: How can I manage calendar invitations from unknown senders?

A: In the "Settings," under "Invitations," you can choose to add invitations only if the sender is known (in your contacts) or only when you respond to the invitation in your email.

Q: How can I adjust notification alerts for calendar events?

A: "Settings" allows you to customize notification alerts, enabling or disabling desktop notifications, choosing snooze durations, selecting notification sounds, and determining whether to receive notifications only for events you've accepted or may attend. You can also choose to show or hide weekends, declined events, completed tasks, and week numbers.

Q: How can I change the appearance of past events?

A: The "Reduce the brightness of past events" setting dims past events, making current events stand out.

Q: How can I view multiple calendars side-by-side?

A: The settings allow for viewing multiple calendars side-by-side in the "Day" view.

Q: How can I change the start day of my week?

A: You can customize the start day of your week (Sunday, Monday, or Saturday) in the calendar settings.

Q: How do I customize my day, week, or month view?

A: The settings let you customize your view to show multiple days or weeks. You can also use keyboard shortcuts (D for day, W for week, M for month, Y for year, X for two weeks) to quickly change views.

Q: How can I automatically add events from my Gmail to my calendar?

A: The "Events from Gmail" setting automatically adds events from your Gmail (like flights or deliveries) to your calendar.

Q: How do I set my working hours and location?

A: A new feature allows you to set your working hours (including specifying location: home, office, etc.) for different days and times, useful for showing availability and location to others.

Q: How can I use keyboard shortcuts in Google Calendar?

A: Press the question mark (?) to see a list of available keyboard shortcuts for navigation and actions.

Q: What if I accidentally delete a calendar event?

A: Deleted events are moved to the trash and can be restored within 30 days.

Q: How can I print my Google Calendar?

A: Use the "Print" option in the settings to print your calendar with customizable options for views, orientation, color, and whether to include declined events.

Q: How do I add add-ons to my Google Calendar?

A: The "Get add-ons" option allows you to find and install additional features for your calendar (this is mentioned as a topic for a future lesson).

Unlock the full potential of your Google Calendar with powerful add-ons! Whether you're a seasoned Google Workspace user or new to Google G Suite, integrating third-party tools can transform your scheduling experience. In this video, we dive deep into how you can enhance your calendar by adding productivity-boosting tools like Zoom, Microsoft Teams, and other essential add-ons. These integrations streamline your workflow, making it easier to manage meetings, collaborate across platforms, and stay organized.

What You'll Learn:

• Finding and Installing Add-ons: Learn how to access the add-on marketplace, search for tools that fit your needs, and install them quickly.

• Free vs. Paid Add-ons: We’ll show you how to differentiate between free and premium features, so you can make the best choice for your workflow.

• Permission Management: Understand what permissions add-ons request and how to ensure your data remains secure.

• Zoom & Microsoft Teams Integration: See how to seamlessly incorporate popular video conferencing tools into your calendar for effortless meeting management.

• Individual vs. Admin Installs: Discover the difference between individual installs and admin-controlled deployments, perfect for corporate environments.

Why Use Add-ons?
Add-ons offer a simple way to extend your calendar’s functionality, saving you time and reducing manual tasks. For hybrid teams working across Google Workspace and Microsoft 365, these integrations are a must-have, allowing seamless transitions between Google Meet, Zoom, and Teams.

Key Benefits:

• Efficiency Boost: Schedule and join meetings faster with direct links from your calendar.

• Flexibility: Switch between multiple video conferencing platforms based on your clients’ or team’s needs.

• Better Collaboration: Make cross-platform teamwork easier by integrating familiar tools into your daily workflow.

We’ll walk you through practical steps to install and use these add-ons, highlighting how they can simplify your day-to-day operations. If your company uses custom internal apps, we’ll show you where to find and manage them, giving your team a tailored experience.

By the end of this tutorial, you’ll know how to use add-ons to create a more efficient, flexible, and collaborative calendar system. Whether you're scheduling a one-on-one or a company-wide meeting, you'll have the tools you need at your fingertips.

Next Steps:
After watching, don’t miss the next video where we explore Google Calendar Tasks and how they integrate with your daily workflow. Learn how to make the most of your calendar by staying organized and on top of your tasks.

Frequently Asked Questions about Google Calendar Add-ons

Q1: What are Google Calendar add-ons?

A1: Add-ons enhance your Google Calendar experience by adding small, useful features and functionalities. They essentially provide upgrades and tweaks to the basic calendar experience.

Q2: How do I find and install Google Calendar add-ons?

A2: Go to the add-ons section within your Google Calendar. You'll find recommendations for Google Workspace users. You can filter by "Works with Calendar," price (free or paid, noting that some free add-ons may have paid features or trials), and rating. If your company has developed internal apps, they will appear under "Internal Apps."

Q3: Are all add-ons free?

A3: No. Many add-ons offer a free version with limited features, while additional functionalities require a paid subscription. Always check the add-on description before installing. Be aware of free trials that may convert to paid subscriptions.

Q4: How do I install add-ons like Zoom or Microsoft Teams?

A4: Find the add-on (e.g., "Zoom for Google Workspace") in the add-ons section. Choose between "Individual Install" (for personal use) or "Admin Install" (for installing across an organization). Carefully review the permissions requested by the add-on before granting access.

Q5: What permissions do add-ons typically request?

A5: Add-ons may request permissions to access your contacts, edit and view calendar events, manage drafts, send emails, and run as a calendar add-on. The specific permissions vary depending on the add-on.

Q6: How do add-ons like Zoom and Microsoft Teams integrate with Google Calendar?

A6: Once installed and signed in, these add-ons provide additional options when creating a meeting. While Google Meet will likely be the default, you can select Zoom or Microsoft Teams as an alternative video conferencing platform. The selected platform will be included in the meeting invite.

Q7: What if I'm an administrator and want to control add-on access?

A7: As an administrator, you can use "Admin Install" to deploy add-ons to your organization or block specific add-ons to control access for users.

Master Your Google Calendar: Conquer Chaos and Reclaim Your Time

This comprehensive video tutorial dives deep into optimizing your Google Calendar for maximum productivity and efficiency. Learn to transform your calendar from a taskmaster into a powerful tool that works for you, not against you. Say goodbye to feeling overwhelmed and hello to a more organized and fulfilling workday.

What Viewers Will Learn:

This video provides practical, actionable strategies to improve your Google Calendar usage. You'll learn how to:

* Effectively manage appointments and meetings: Discover how to seamlessly schedule meetings directly from Gmail, eliminating unnecessary back-and-forth emails. Master the art of creating and sharing meeting notes directly within Google Calendar, ensuring everyone stays informed. Learn to leverage Google Meet integration for seamless virtual meetings.

* Transform tasks into actionable items: Learn how to effectively categorize and prioritize tasks using Google Tasks, distinguishing between time-sensitive events and those that can be handled flexibly. Discover the power of creating separate task lists for better organization and focus.

* Optimize your calendar's visual presentation: Learn to color-code events for easy identification and prioritization. Employ visual cues like emojis to create a more engaging and easily scannable calendar interface.

* Utilize Google Calendar features for improved time management: Explore the benefits of "focus time" blocks, "out of office" settings, and automated meeting declines to protect your time and minimize distractions. Learn how to use repeating tasks for recurring obligations, and how to effectively manage your task lists across your day.

* Improve Calendar Psychology: Understand how to structure your calendar to better suit your personal work style and preferences, including how to minimize distractions and reduce overwhelm.

Benefits and Opportunities:

By implementing the techniques shown in this video, you'll experience:

* Increased Productivity: Streamline your workflow, minimize wasted time, and accomplish more in less time.

* Reduced Stress: A better-organized calendar reduces anxiety and improves your overall work-life balance.

* Improved Time Management: Gain control of your schedule and prioritize tasks effectively.

* Enhanced Collaboration: Seamlessly share meeting notes and information with colleagues, improving teamwork and communication.

* Personalized Calendar System: Customize your calendar to reflect your specific needs and preferences, creating a system that truly works for you.

Pain Points Addressed:

This video directly addresses common challenges faced by many professionals and individuals:

* Feeling overwhelmed by a cluttered calendar: Learn how to declutter and prioritize your appointments and tasks for a clearer, less stressful view.

* Spending too much time managing emails related to scheduling: Streamline your scheduling process and reduce the number of emails required to arrange meetings.

* Difficulty prioritizing tasks: Learn techniques to effectively categorize and prioritize tasks within your calendar and task lists.

* Inefficient use of Google Calendar features: Unlock the full potential of Google Calendar by learning advanced features and integration options, including using Google Tasks, Google Meet and Google Docs.

* Lack of visual clarity in your calendar: Learn strategies to improve your calendar’s visual appeal and make it easier to scan and understand at a glance.

This video is a must-watch for anyone seeking to master their Google Calendar and take control of their time. Learn to leverage the power of Google Calendar, Google Tasks, Google Meet, and Google Docs to achieve peak productivity and create a more fulfilling workday. Whether you are a student, professional, or entrepreneur, the tips and tricks shared in this video will help you stay organized, focused, and in control of your schedule. Improve your time management, reduce stress, and increase your overall efficiency – start maximizing your calendar today!

Frequently Asked Questions (FAQs) and Answers:

Q: How can I efficiently manage my calendar so it works for me, not the other way around?

A: There are several strategies: color-coding important events (e.g., using red for high-priority meetings), differentiating between tasks and calendar events, using Google Calendar's task feature to manage to-dos, creating separate lists for tasks (e.g., "Office Supplies," "Phone Calls"), using the "out of office" function to block off time, and employing focus time blocks to minimize distractions. Utilizing emojis can also improve glanceability.

Q: How can I add a meeting directly from a Gmail email?

A: Select the email containing the meeting request. Google Calendar often provides an option to "Create an event" directly from the email. This automatically adds the sender as an attendee and allows you to set the time and duration.

Q: How can I keep my Google Calendar always visible, regardless of what I'm doing in Gmail?

A: Expand the calendar view in Gmail. Once expanded, it will remain visible on the right-hand side of your screen, allowing you to view your schedule without switching tabs. You can customize which calendars are displayed.

Q: My calendar is cluttered with numerous half-hour appointments and tasks. How can I improve its readability and organization?

A: Prioritize items by color-coding. Separate time-sensitive tasks from those that can be completed at any time. Use Google Calendar's task feature to move non-time-critical items out of your calendar view. Categorize tasks into different lists for better organization.

Q: How can I use Google Calendar's task feature effectively?

A: Create different lists for different task types (e.g., "Office Supplies," "Phone Calls"). This allows you to manage your tasks by category. You can add repeating tasks and set due dates or reminders. However, you can't move repeating tasks between lists; you must create a new task in the desired list.

Q: How can I manage meeting locations and notes using Google Calendar?

A: When scheduling a meeting, Google Calendar automatically suggests a location (e.g., home, office) based on your work location. You can change this manually. Google Calendar also offers the option to create shared meeting notes using Google Docs, which are automatically shared with attendees. This allows for collaborative note-taking and keeps everyone informed. If you record the meeting (depending on your Google Workspace plan), you can add a transcription or link to the recording to the shared notes document.

Q: How can I use "Focus Time" in Google Calendar?

A: The "Focus Time" feature lets you block off time for uninterrupted work. You can set it to automatically decline meetings, mute notifications, and even specify a location. This helps create dedicated periods for focused work.

Q: How can I improve the visual appeal and usability of my Google Calendar?

A: Use color-coding for priority, categorize tasks, and most importantly use emojis to make events more easily identifiable at a glance.

How to Add an Email as an Event in Google Calendar & Google Tasks | Boost Your Productivity with Google Workspace

Emails can quickly pile up, making it hard to stay organized. But did you know you can turn important emails into calendar events or tasks directly within Google Workspace? This tutorial will show you how to streamline your workflow by converting emails into actionable tasks and events with just a few clicks.

• How to Create Calendar Events from Emails: Turn important conversations into scheduled events, ensuring you never miss a meeting or deadline.

• How to Add Emails to Google Tasks: Simplify your task management by turning emails into to-do items and linking them directly to your inbox.

• Why This Workflow Enhances Efficiency: Discover practical tips on integrating Gmail, Google Calendar, and Google Tasks to boost productivity and manage time better.

This guide is perfect for:

• Professionals managing multiple projects and deadlines.

• Students who need a streamlined way to organize assignments and reminders.

• Anyone looking to improve their productivity with Google Workspace!

By the end of this, you’ll have the skills to efficiently manage your inbox, calendar, and tasks, transforming how you work with emails. Stay on top of your commitments without missing a beat!

Master Google Calendar's Appointment Scheduling: Streamline Your Bookings & Save Time

This comprehensive video tutorial will guide you through Google Calendar's powerful new appointment scheduling feature, a direct competitor to scheduling platforms like Calendly and Microsoft Bookings.  Learn how to effortlessly manage your appointments, optimize your availability, and create professional booking experiences for clients, colleagues, or interviewees.

What Viewers Will Learn:

This video provides a step-by-step walkthrough of setting up and customizing Google Calendar's appointment scheduling functionality. You'll learn how to:

*   Define appointment durations and recurrence patterns (daily, weekly, custom intervals).

*   Establish clear scheduling windows, setting limits on booking lead times and minimum notice periods.

*   Implement buffer time between appointments for smoother transitions and efficient task management.

*   Control the number of daily appointments to avoid overbooking and maintain a balanced schedule.

*   Manage co-host calendars for seamless scheduling collaboration.

*   Design and customize booking forms to collect essential guest information (name, email, phone number, custom questions).

*   Enforce email verification to prevent fraudulent bookings.

*   Set up automated booking confirmations and reminders to keep both you and your guests informed.

*   Create and share both single and multi-appointment booking pages via links or website embeds (inline or pop-up).

*   Preview your booking page from the perspective of your guests to ensure a user-friendly experience.

Benefits and Opportunities:

By mastering Google Calendar's appointment scheduling, you unlock several significant advantages:

*   Time Savings: Eliminate the back-and-forth email chains typically associated with scheduling.

*   Improved Efficiency: Streamline your appointment management process, reducing administrative overhead.

*   Professionalism: Create a polished and professional booking experience for clients and colleagues.

*   Cost Savings: Leverage a free, built-in solution instead of subscribing to third-party scheduling tools like Calendly.

*   Integration: Seamlessly integrate scheduling into your existing Google ecosystem.

*   Increased Control: Maintain complete control over your availability and appointment settings.

*   Enhanced Communication: Automated reminders and confirmations ensure no appointments are missed.

*   Customizability: Tailor your booking process to precisely meet your specific needs.

*   Flexibility: Offer a range of meeting options (Google Meet, in-person, phone call).

*   Website Integration: Effortlessly embed your booking page onto your website for convenient access.

Pain Points Addressed:

This video addresses common scheduling challenges by providing clear solutions:

*   Difficulty managing multiple calendars and finding available time slots.

*   Inefficient communication and coordination leading to scheduling conflicts.

*   Lack of a professional booking system for clients or colleagues.

*   High costs associated with using external scheduling platforms.

*   Uncertainty about how to configure optimal scheduling settings.

*   Desire for more control over the appointment booking process.

*   Need for clear and timely communication with guests.

*   The challenge of integrating scheduling with existing website design.

This video is ideal for professionals, entrepreneurs, and anyone seeking to simplify and optimize their appointment scheduling process using the built-in features of Google Calendar.  Learn to leverage this powerful tool to enhance your productivity and create a seamless booking experience for all your appointments, from job interviews to client meetings.  From understanding buffer times and setting booking limits, to customizing booking forms and embedding your scheduler onto your website, this video covers it all. Enhance your workflow and save valuable time with Google Calendar's appointment scheduling.  Learn how to create professional, efficient, and user-friendly scheduling today!

Frequently Asked Questions about Google Appointment Schedules

Q1: How do I access the appointment scheduling feature?

A1: There are two ways:  Click "Appointment schedule" and then "Set up schedule," or click "Create" and then "Appointment schedule." Both lead to the same setup page.

Q2: Can I share only my availability, not my entire calendar?

A2: Yes. The system allows you to share only your free time slots with those booking appointments.

Q3: How do I set the duration of appointments?

A3: You specify the length of each appointment (e.g., 30 minutes, 1 hour) during the setup process.

Q4: How do I set the frequency of available appointment slots?

A4: You can choose from "Does not repeat," "Weekly," or "Custom" (e.g., every two weeks) to define how often appointment slots are available.

Q5: How far in advance can people book appointments?

A5:  The default is 60 days in advance, but this can be changed, or unchecked to allow indefinite booking.

Q6: How much advance notice is required for bookings?

A6: The default minimum booking notice is four hours.  This can be adjusted.

Q7: Can I add buffer time between appointments?

A7: Yes. You can specify buffer time (e.g., 5 minutes, 30 minutes, 1 hour) between appointments to allow for note-taking or other tasks.

Q8: How many appointments can be scheduled per day?

A8: You can set a limit on the maximum number of appointments per day (e.g., four).

Q9: Can guests invite others to appointments?

A9: Yes, by default.  This option can be disabled if necessary.

Q10: How does the system handle conflicts with other calendar events?

A10: The system checks against the specified calendars for availability.  If you have an event scheduled, those times will not be available for booking. You can choose to ignore other calendars if needed.

Q11: Can I add co-hosts to appointments?

A11: Yes, the system allows you to add co-hosts, and it will check the availability of all co-hosts' calendars.

Q12: What information can I request from those booking appointments?

A12: You can customize the booking form to request information such as first name, last name, email address, phone number, and custom questions.  Email verification can also be required.

Q13: What kind of booking confirmations and reminders are available?

A13:  Calendar invitations (non-removable), email reminders (customizable, e.g., one day before, one hour before, or both).

Q14: Can I create a single booking page or one for all appointment schedules?

A14:  Both options are available. A single booking page displays only appointments for that specific schedule.  A page for all appointment schedules lists all available appointments across all your schedules.

Q15: How can I share my booking page?

A15: You can share your booking page via a link, website embed (inline or with a button), or both.  The embed code provides options for inline embedding or a button that triggers a pop-up booking window.

Unlock the Power of Google Workspace Time Insights: Master Your Schedule and Boost Productivity

This video tutorial provides a comprehensive guide to leveraging the powerful Time Insights feature within Google Workspace, helping you optimize your workflow and achieve greater efficiency. We delve into the nuances of this often-overlooked tool, revealing hidden functionalities and strategies to make the most of your workday. Whether you're a seasoned Google Workspace user or just getting started, this video will equip you with the knowledge and skills to dramatically improve your time management.

What Viewers Will Learn:

This video will teach you how to navigate and interpret Google Workspace's Time Insights feature, a powerful tool for analyzing your time allocation across different activities. You'll learn to:

* Understand the different color-coded categories within Time Insights and how to customize them to reflect your specific work patterns (e.g., meetings, personal tasks, phone calls).

* Effectively utilize color labels to categorize your schedule, enabling clearer visualization and analysis of your time usage.

* Analyze your weekly time breakdown to identify areas for improvement in time management and productivity.

* Adjust your working hours within Google Workspace to accurately reflect your schedule and receive more relevant time insights.

* Leverage Time Insights to identify patterns in your meetings, such as frequency, duration, and attendees. This allows for data-driven scheduling decisions.

* Utilize the suggestions provided by Time Insights to optimize scheduling and prioritize tasks, including strategically scheduling focus time to maximize productivity.

* Discover how to schedule future meetings directly from the Time Insights panel, streamlining your workflow and communication.

* Identify and address potential limitations based on your Google Workspace license. The video explains how certain features may only be available with specific licenses.

Benefits and Opportunities:

By mastering Google Workspace Time Insights, you'll unlock a range of benefits, including:

* Enhanced Time Management: Gain a clear understanding of how you spend your time, allowing you to identify time-wasting activities and optimize your schedule.

* Improved Productivity: Use data-driven insights to prioritize tasks, schedule focus time, and minimize interruptions.

* Data-Driven Decision Making: Make informed decisions about your work schedule based on objective data analysis rather than subjective estimations.

* Streamlined Workflow: Integrate Time Insights seamlessly into your existing Google Workspace workflow for a more efficient and organized approach to time management.

* Better Meeting Management: Understand your meeting patterns and schedule future meetings more effectively, reducing scheduling conflicts and improving overall meeting efficiency.

* Reduced Stress and Improved Work-Life Balance: By gaining control over your schedule and reducing wasted time, you can reduce stress and improve your work-life balance.

* Proactive Scheduling: Use the suggestions generated by Time Insights to proactively schedule tasks and meetings, optimizing your daily and weekly agendas.

Pain Points Addressed:

This video directly addresses common challenges related to time management and productivity, such as:

* Difficulty tracking time spent on various activities.

* Inefficient scheduling leading to wasted time and missed deadlines.

* Lack of clarity regarding time allocation across different tasks and projects.

* Uncertainty about how to best utilize the features within Google Workspace.

* The need for a data-driven approach to improve personal productivity.

* Difficulty prioritizing tasks and maintaining a healthy work-life balance.

* Limited understanding of how to optimize meeting schedules to maximize efficiency.

This video is a valuable resource for anyone seeking to enhance their time management skills and boost their productivity within the Google Workspace ecosystem. It offers practical, actionable strategies and techniques to make the most of this powerful tool. The step-by-step instructions and clear visual demonstrations ensure easy understanding and immediate application. Improve your workflow today – watch now!

Frequently Asked Questions (FAQs) about Google Workspace Time Insights:

Q1: I don't see "Time Insights" or "More Insights" in my Google Workspace. Why?

A1: You likely don't have the correct license to access these features. The availability of Time Insights depends on your Google Workspace version and plan.

Q2: How do I interpret the different colors in the Time Insights view?

A2: The colors represent different categories of activities. You can customize these labels. For example, red might be "Meetings," orange might be "Phone Calls," green "Personal," and so on. The default color is often for unsorted activities.

Q3: How can I customize the color labels for my activities?

A3: Click on a colored block representing an activity. You'll then see an option to add or edit labels. You can assign a specific label (like "Meeting" or "Personal") to each color.

Q4: How does Time Insights calculate my remaining work hours?

A4: Time Insights calculates remaining hours based on your defined working hours (which you can adjust in the settings) and the total time already allocated to scheduled events.

Q5: How can I adjust my working hours in Time Insights?

A5: There's an option within Time Insights (typically accessible via a settings or preferences button) to change your typical working hours (e.g., start time, end time, and location).

Q6: What information does "More Insights" provide?

A6: "More Insights" provides a breakdown of your time usage, either by color-coded activity or by type of activity (e.g., Focus Time, Meetings). It will highlight your scheduled events on the calendar for visual confirmation.

Q7: Can Time Insights suggest optimal times for scheduling focus time?

A7: Yes, based on your existing calendar events, Time Insights can suggest days with fewer meetings to schedule your focus time. It also considers recurring events and one-off events.

Q8: How can I schedule a meeting with someone using the Time Insights feature?

A8: The Time Insights view shows a list of people you've recently met with. You can use this section to schedule a new meeting with a listed individual, selecting a date, and adding to your calendar.

Q9: What other information is provided by the Time Insights/More Insights view?

A9: In addition to color-coded and type-based time breakdowns, it shows:

* Total remaining work hours.

* Meetings scheduled, with indication of their recurrence.

* People you've met with.

* Suggestions for better time management (like scheduling focus time on less busy days).

Why you should use this?

1. Efficiency: Instead of manually copying and pasting information from your spreadsheet to your calendar, this code automates the process. With a single click from the custom menu, the event is created in your Google Calendar, saving you time and effort.

2. Accuracy: The code retrieves the information directly from specific cells in your spreadsheet, reducing the chances of errors or typos when transferring data to the calendar. This helps ensure the accuracy of the event details.

3. Consistency: By using the code, you can maintain consistency in how you format and organize the calendar events. The event title can include the supplier name, and the event description can include additional information such as the amount and PO number, providing a standardized structure for your calendar entries.

4. Convenience: The custom menu adds a user-friendly interface within Google Sheets, making it easy to trigger the event creation process without navigating through complex menus or settings. It provides a convenient and accessible way to manage your calendar events directly from your spreadsheet.

5. Streamlined Workflow: If you frequently create calendar events based on information in your spreadsheet, this code streamlines your workflow by eliminating repetitive manual tasks. It allows you to focus on other important aspects of your work while the code handles the calendar integration.

Overall, this code simplifies the process of adding relevant information from your spreadsheet to your Google Calendar, improving efficiency, accuracy, and convenience. It can save you time, reduce errors, and provide a more streamlined workflow for managing your calendar events.

How it works?

1. The `onOpen()` function creates a custom menu in the Google Sheets document. This menu contains a single option: "Add to Calendar". It will be displayed in the menu bar when the spreadsheet is opened.

2. The `addToCalendar()` function is triggered when the "Add to Calendar" option is selected from the custom menu.

3. The function retrieves the values from specific cells in the active sheet:

   - The supplier name is obtained from cell B1.

   - The ship date is obtained from cell B2.

   - The amount is obtained from cell B3.

   - The PO number is obtained from cell B4.

4. It checks whether the ship date is a valid date. If it is, the code proceeds to the next steps. Otherwise, it displays an alert indicating an invalid ship date.

5. If the ship date is valid, it creates a Google Calendar event using the `createEvent()` method from the Calendar service.

   - The event title is set as "Order Shipment - " followed by the supplier name.

   - The event start time is set to 8am by modifying the hours of the ship date.

   - The event end time is set to 9am (1 hour after the start time) by adding 60 minutes to the ship date.

   - The event description includes the amount and PO number obtained from the respective cells.

6. The newly created event is added to the default Google Calendar using the `createEvent()` method with the specified event details.

7. Finally, it displays an alert indicating that the event has been added to the calendar.

This code allows you to manually trigger the process through a custom menu in Google Sheets. When you select the "Add to Calendar" option, it creates a calendar event with the specified details, including the ship date, supplier name in the event title, and additional information in the event description.

• Adding Numbers to Folders to make it in the order you want

• Colour Coding the Folders

• Starring the Folders

• Adding Shortcuts to Drives

Add and remove files to your Workspace

1. On your computer, go to drive.google.com.

2. On the left, click Priority.

3. Below the Workspace you want to add files to, click View Workspace Add files.

4. At the right, select the file or files you want to add.

5. Click Insert.

6. 
   

Note: You can also right-click any file in your Drive to add it to a Workspace.

To remove a file, right-click a file in your Workspace and click Remove from Workspace.

Delete a Workspace

When you delete a Workspace, the Workspace is permanently deleted, but the files remain in their original location.

1. On your computer, go to drive.google.com.

2. At the left, click Priority.

3. Next to the name of the Workspace you want to delete, click the Down arrow.

4. Click Remove Workspace.

• We upload Files and Folders

• Shortcuts to Folders

• We upload by dragging from the desktop and from our downloads

  
  

Because Google doesn't have a client for Linux, companies have created Software to fill that gap. One of the easiest pieces of software that gets the job done is Insync.

• Sharing Files and Folders with others in your organisation and outside your organisation.

• Adding Groups to your Google Contacts and sharing to those groups.

• Changing Owners of a File or Folder.

What are shared drives?

This feature is available with G Suite Enterprise, Enterprise for Education, G Suite Essentials, Business, Education, and Nonprofits edition.

You can use shared drives in Google Drive to store, search, and access files with a team. Shared drive files belong to the team instead of an individual. Even if members leave, the files stay in place so your team can keep sharing information and work anywhere, from any device.

Note: If your organization signed up for or upgraded a G Suite or G Suite Essentials account before July 2017, you might need to turn on shared drives for your users.

Create new items

Document Shift + t

Presentation Shift + p

Spreadsheet Shift + s

Drawing Shift + d

Folder Shift + f

Form Shift + o

Open menus

Sort menu r

Settings menu t

Take action on selected items

Move selected items to new folder z

Star or unstar selected items s

Google Docs is a word processor included as part of a free, web-based software office suite offered by Google within its Google Drive service. This service also includes Google Sheets and Google Slides, a spreadsheet and presentation program respectively. Google Docs is available as a web application, mobile app for Android, iOS, Windows, BlackBerry, and as a desktop application on Google's ChromeOS. The app is compatible with Microsoft Office file formats.[1] The application allows users to create and edit files online while collaborating with other users in real-time. Edits are tracked by user with a revision history presenting changes. An editor's position is highlighted with an editor-specific color and cursor. A permissions system regulates what users can do. Updates have introduced features using machine learning, including "Explore", offering search results based on the contents of a document, and "Action items", allowing users to assign tasks to other users.

Google Docs is available as a web application supported on Google Chrome, Mozilla Firefox, Internet Explorer, Microsoft Edge, and Apple Safari web browsers. Users can access all Docs, as well as other files, collectively through the Google Drive website. In June 2014, Google rolled out a dedicated website homepage for Docs, that contains only files created with the service.In 2014/ Google launched a dedicated mobile app for Docs on the Android and iOS mobile operating systems. In 2015, the mobile website for Docs was updated with a "simpler, more uniform" interface, and while users can read files through the mobile websites, users trying to edit will be redirected towards the dedicated mobile app, thus preventing editing on the mobile web.

Google Docs and the other apps in the Google Drive suite serve as a collaborative tool for cooperative editing of documents in real-time. Documents can be shared, opened, and edited by multiple users simultaneously and users are able to see character-by-character changes as other collaborators make edits. Changes are automatically saved to Google's servers, and a revision history is automatically kept so past edits may be viewed and reverted to.[19] An editor's current position is represented with an editor-specific color/cursor, so if another editor happens to be viewing that part of the document they can see edits as they occur. A sidebar chat functionality allows collaborators to discuss edits. The revision history allows users to see the additions made to a document, with each author distinguished by color. Only adjacent revisions can be compared, and users cannot control how frequently revisions are saved. Files can be exported to a user's local computer in a variety of formats (ODF, HTML, PDF, RTF, Text, Office Open XML). Files can be tagged and archived for organizational purposes

Supported file formats

Files in the following formats can be viewed and converted to the Docs format:

For documents: .doc (if newer than Microsoft Office 95), .docx, .docm .dot, .dotx, .dotm, .html, plain text (.txt), .rtf, .odt

G Suite

Google Docs and the Drive suite are free of charge for use by individuals, but are also available as part of Google's business-centered G Suite, enabling additional business-focused functionality on payment of a monthly subscription

A simple find and replace tool is available. The Drive suite includes a web clipboard tool that allows users to copy and paste content between Google Docs, Google Sheets, Google Slides and Drawings. The web clipboard can also be used for copying and pasting content between different computers. Copied items are stored on Google's servers for up to 30 days. For most copying and pasting, Google Docs also supports keyboard shortcuts.[38] Google offers an extension for the Google Chrome web browser called Office editing for Docs, Sheets and Slides that enables users to view and edit Microsoft Word documents on Google Chrome, via the Docs app. The extension can be used for opening Office files stored on the computer using Chrome, as well as for opening Office files encountered on the web (in the form of email attachments, web search results, etc.) without having to download them. The extension is installed on Chrome OS by default.[39] Google Cloud Connect was a plug-in for Microsoft Office 2003, 2007 and 2010 that could automatically store and synchronize any Word document to Google Docs (before the introduction of Drive) in Google Docs or Microsoft Office formats. The online copy was automatically updated each time the Microsoft Word document was saved. Microsoft Word documents could be edited offline and synchronized later when online. Google Cloud Connect maintained previous Microsoft Word document versions and allowed multiple users to collaborate by working on the same document at the same time. Google Cloud Connect was discontinued in April 2013 as, according to Google, Google Drive achieves all of the above tasks, "with better results"

Get started with Google Docs

Open and Create a new doc

Docs home screen at https://docs.google.com/

Can go to landing page https://docs.google.com/document/u/0/?tgif=d will show all the docs you have worked on

Better way is to open in Drive then you can specify where you create it on your drive folder.

Can create using template as well

Open as Microsoft word doc or Google Doc.

Word doc has extension docx

Google Doc

Now opens as Microsoft Office editing mode in Google Docs by default for docx

Preserved in MS format

MS Google interface is missing MS power user functions about 95% of what word has but not everything

Benefit of Google Docs is that there is nothing to install and cloud based. Perfect for collaboration.

Google Docs doesn’t always look the way you expect from docx

If saved as Google Docs it will create a new file in the drive

Different ID

Should stay with one version for collaboration

Rename docx

Move to different folder

Delete the original

Export easily to will download to your computer - need to upload back to drive if you want the version in your drive.

Google Doc to Word typically has no issue in the conversion, MS to Google Doc may have conversion issues if complex features are used.

Different versions and copies of your document.

Click a time stamp to see a previous version of the file.

Make a copy: Create a duplicate of your document.

Download as: Download your document in other formats, such as Microsoft® Word® or Adobe® PDF.

Email as attachment: Send a copy of the document to people. You can change the format.

Version history: See all the changes you and others have made to the document or revert to earlier versions.

Publish to the web: Publish a copy of your document as a webpage, or embed your document in a website.

Select from templates

If your organization allows you can also submit a template

Collaboration

Under "People," enter the email address you want to share with.

If an email address isn't a Google Account, they’ll only be able to view the file.

Notify or not  Advanced and uncheck the Notify people box.

Share permissions

View: People can view, but can’t change or share the file with others.

Comment: People can make comments and suggestions, but can’t change or share the file with others.

Edit: People can make changes, accept or reject suggestions, and share the file with others.

Up to 100 people can edit and comment at the same time.

Tag user in comment with @ or + symbol

Get a shareable link. - you can share as web links with permissions - or to all On - Public on the web.

After resolve comment history

Work across devices, with or without Internet

Create, edit and share docs from your iPhone, iPad or Android devices. Use Chrome for Mac or PC to work in Docs even when you’re offline.

Easy-to-manage sharing controls

You decide who gets access to your documents and folders. Grant individuals or groups the right to edit, view or just add comments.

Commenting, chat and real-time editing

Work in a single document with teammates or people outside your company. See edits as others type, communicate through built-in chat and ask questions through including comments.

Can restore back to version history

Create named version - good when you have a final or milestone

Can click title of version in the version window to update the name

Automatically simplifies the versions

To make a previous version the active version, at the top, click Restore this version.

To name a previous version, click More Name this version.

To make a copy of a previous version, click More Make a copy.

Work with different versions and copies of your document.

" "

Make a copy: Create a duplicate of your document.

Download as: Download your document in other formats, such as Microsoft® Word® or Adobe® PDF.

Email as attachment: Send a copy of the document to people. You can change the format.

Version history: See all the changes you and others have made to the document or revert to earlier versions.

Publish to the web: Publish a copy of your document as a webpage, or embed your document in a website.

Print and page setup

File >  Page setup.

Enhance your document by adding features.

Editing

Undo or Redo .

Paste and paste without formatting

Will insert where cursor is, select text to apply formatting to.

Image: Insert an image from your computer, the web, Drive, and more.

Table: Select the number of columns and rows to create a table.

Drawing: Create pictures, flowcharts, diagrams, and more.

Link: Add a link to a webpage or a header or bookmark in your document.

Chart: Add different types of charts, or add a chart from Sheets.

Bookmark: Add shortcuts to specific places within your document.

Table of contents: Create an autogenerated table of contents that links to each heading (where you’ve applied heading styles).

Customize your document

" "

Depending on what you want to change, choose an option:

To customize margins, page color, and orientation, click Fileand thenPage setup.

To customize text, images, tables, and more, use the toolbar options.

Note: Some options only appear for certain types of content, such as tables or images.

  Undo or redo your last changes or print your document.

Copy formatting Copy formatting from any text and apply it to another selection of text.

Normal text  | Arial  | 10 Change the style, font, or font size.

    Make text bold, in italics, or underlined or change the text color.

Highlight Add or change the text highlight color.

Add comment Insert a link, comment, or image.

Text alignment Change the text alignment.

Adjust line spacing Change the line spacing or add numbers or bullets.

Indent Change the text indentation.

Remove text formatting Remove text formatting.

Table and image options

Add background color Add background color to a table or change the border color, width, or style.

Crop an image.

Image options… Change the color, transparency, brightness, or contrast.

Replace image Replace an existing image with a new one.

Create page columns

" "

If you’re working on an academic paper or another large document, you can organize your text in columns.

Click Formatand thenColumns.

Select the number of columns you want.

(Optional) To adjust the spacing, or add lines between columns, click Formatand thenColumnsand thenMore options.

Click Apply.

Also in small menu

As long as cursor is on the element it will update you don’t need to select all or you can if its specific part of the element.

Title and subtitle

Heading 1 - heading sizes

Update of heading

Any elements that have it applied

Save as default styles which then can be used across other docs

Insert footnote

Will add number to spot where footnote was selected

get images from the internet

Insert

Table: Select the number of columns and rows to create a table.

Space table rows and columns evenly

1. Highlight the rows or columns that you want to align.

2. Click FormatTableDistribute rows or Distribute columns.

Bookmark: Add shortcuts to specific places within your document.

Image Options

Add headers and footers to your Google Doc

In the Q&A section there was a question about how to add "Page 1 of 3". This is a very simple and quick method to get that done.

Easy to create a Google Doc Document Outline

Did you know you can easily create a table of contents list google document Google Docs

Tools

Document comparison

Allows you to compare 2 versions of same doc

Linked objects

https://support.google.com/docs/answer/7009814?visit_id=637183410882551363-1333893130&p=embedded_tables&hl=en&rd=1

Translate document - will create new document - select doc and name. Select translate

ToolsTranslate document.

Voice typing

“Period” will insert

“Paragraph” will insert

Script Editor

Preferences

Choose to capitalize words

"Test" “test” - smart quotes

Show link details - shows popout box of preview

list google document Google Docs View menu options learn about google document Google Docs

list google document Google Docs Special Characters

Track changes in a document

In the top corner, make sure you’re in Suggesting mode, which may also appear as Suggest.

To suggest an edit, simply begin typing where you think the edit should be

Document’s owner will receive an email with your suggestions. When they click any suggestion, they can Accept Checkmark or Reject Close it.

Add and assign comments in a document

Select text you would like to comment on Add comment

Enter your comment in the box.

To assign the comment to a specific person, check the Assign to box.

Offline mode

Settings in drive

Only for google format documents

Saves in browser cache

Set in google drive

Make non-Google files on your desktop available offline" "

If you haven't already, install Drive File Stream.

On your desktop, click Drive File Stream Drive File Stream.

Click Open Google Drive Folder.

Go to the file or folder you want to access offline, right-click it, and select Drive File Stream and then Available offline.

Make Google files on the web available offline" "

Set up offline availability (one time only):

To see a complete list of keyboard shortcuts, open Google Docs and press ⌘ + / (Mac) or Ctrl + / (Windows, Chrome OS).

Common actions

Keyboard shortcut

Copy

⌘/Ctrl + c

Cut

⌘/Ctrl + x

Paste

⌘/Ctrl + v

Paste without formatting

⌘/Ctrl + Shift + v

Undo

⌘/Ctrl + z

Redo

⌘/Ctrl + Shift + z

Insert or edit link

⌘/Ctrl + k

Find

⌘/Ctrl + f

Format text

Keyboard shortcut

Bold

⌘/Ctrl + b

Italicize

⌘/Ctrl + i

Underline

⌘/Ctrl + u

Strikethrough

Option/Alt + Shift + 5

Superscript

⌘/Ctrl + .

Copy text formatting

⌘/Ctrl + Alt + c

Format paragraphs

Keyboard shortcut

Increase paragraph indentation

⌘/Ctrl + ]

Decrease paragraph indentation

⌘/Ctrl + [

Numbered list

⌘/Ctrl + Shift + 7

Right align

⌘/Ctrl + Shift + r

Left align

⌘/Ctrl + Shift + l

Bulleted list

⌘/Ctrl + Shift + 8

Install an add-on

Click the add-on you want to install and click Free.

Why would you want to use Google Sheets? There are many other alternatives like Excel or Excel online (pared down on Office 365), OpenOffice Calc, Zoho Sheet, LibreOffice Calc, Numbers for Mac, Freeoffice PlanMaker and many others

Well, it can be used like the rest of the Google Products on any device with a browser including iOS and Android apps.

• It is free as part of your Google Account or part of Google Workspace (G Suite)

• It is built for collaboration with others

• Brilliant revision history

• A chat window is built-in

• Addons from Google like GOOGLETRANSLATE() or GOOGLEFINANCE())

• Addons from multiple developers

• Additional extensions can be loaded into Google Chrome to add functionality and can be managed by your admins

• Each lesson will have references in the resources to allow you to test and experiment with options and then another one to show how it is done so that you can test against your own examples with Google Sheets.

• Open and create

  • Create using Sheets.new

  • Create right-click in drive

  • Create new from file menu

Open your Google Workspace Google Sheets resources and make a copy so that you can save it to your drive.

• Looking at versions in Google Sheets from version history and adding values in cells

• Naming version of your sheet and restoring from that sheet

• Looking at the changes in each cell

• Name and rename File in Google Sheets

• How to reference cells A1 F6 etc

• Rows vs Columns

• Upload Excel Spreadsheet make sure that the convert uploads is selected otherwise it stays in Excel format

• Export into various formats

Google Sheets Menus and Functions

• Menu bar

• Explore button

• Formula bar

• Zoom in and out using mouse and keyboard

• Sheets / Tabs / Worksheets ---- the things at the bottom. Renaming and adding new sheets and dragging them around

• Hamburger menu next to tabs

• Double-clicking into cells

• Single click on cell selecting rows and columns

• Selecting all using the top left block

• Adding text in a column and hitting enter Once data is entered, either enter or arrow keys and also click using the mouse.

• Adding a new row for a header

• Adding numbers in the second column

• Simple function like sum when you type in the range or click and drag the range

• Adding the values using the formula bar

• Averages, Sum, Min, Max and CountA

Using Autofill in Google Sheets

• Use autofill to make the header make from January to the end of the year also can use Monday Tuesday and 1,2,3

• Drag over with autofill and increment values by 5 or 13 etc

• Drag totals across

• Drag cells with a merged cells for Jan Feb etc

Formatting your Google Sheets

• Background Color

• Text Color

• Alternating colours

• Column width by dragging the side of the column and right-click and make the width a size

• Header rotate

• Wrap text

• Vertical Alignment

• Merging rows and columns, merge all, horizontally, vertically, unmerge

Referencing in Google Sheets

• Relative cell reference - when you do a1+b1 and then drag it down it is relative to the cells

• Fixed cell reference - when you calculating every cell against a fixed value like tax or markup A$2 or $A$2

• Reference in another tab =’other tab’ !C6

• Reference in another file = importrange (“location of file”, cell reference)

• IMPORTRANGE

  Imports a range of cells from a specified spreadsheet.

  
  

  Sample Usage

  IMPORTRANGE("https://docs.google.com/spreadsheets/d/abcd123abcd123", "sheet1!A1:C10")

  
  

  IMPORTRANGE(A2,"B2")

  
  

  Syntax

  IMPORTRANGE(spreadsheet_url, range_string)

  
  

  spreadsheet_url - The URL of the spreadsheet from where data will be imported.

  
  

  The value for spreadsheet_url must either be enclosed in quotation marks or be a reference to a cell containing the URL of a spreadsheet.

  range_string - A string, of the format "[sheet_name!]range" (e.g. "Sheet1!A2:B6" or "A2:B6") specifying the range to import.

  
  

  The sheet_name component of range_string is optional; by default IMPORTRANGE will import from the given range of the first sheet.

  
  

  The value for range_string must either be enclosed in quotation marks or be a reference to a cell containing the appropriate text.

  
  

  Notes

  Spreadsheets must be explicitly granted permission to pull data from other spreadsheets using IMPORTRANGE. The first time the destination sheet pulls data from a new source sheet, the user will be prompted to grant permission. Once access is granted, any editor on the destination spreadsheet can use IMPORTRANGE to pull from any part of the source spreadsheet. The access remains in effect until the user who granted access is removed from the source.

  
  

  If the data you are trying to import is too large, you may get an error.

Google Sheets is a spreadsheet program with a lot of extra features. It looks and works like any other spreadsheet program, but because it's an internet program, it has a lot more features than most spreadsheet programs. Here are some of the factors that contribute to its superiority:

It's a web-based spreadsheet that you can access from anywhere, so you won't have to worry about leaving your spreadsheet files at home.

It works on any platform, featuring iOS and Android mobile apps as well as a web-based core app.

Google Sheets is a free online file, document, and presentation sharing tool that comes packaged with Google Drive, Docs, and Slides.

It has almost all of the same spreadsheet capabilities as Excel, so if you're familiar with Excel, you'll be right at home in Google Sheets.

• Find help on Keyboard Shortcuts

• Shortcuts Help file ⌘ + / or Ctrl + /

• Inserting Columns and Rows

  • ⌘ + ⌥ + = (with rows selected) or Ctrl + Alt + = (with rows selected)
    ⌘ + ⌥ + = (with columns selected) or Ctrl + Alt + = (with columns selected)

• Copy ⌘ + c or Ctrl + c

• Paste ⌘ + v or Ctrl + v

• Cut ⌘ + x or Ctrl + x

• Undo ⌘ + z or Ctrl + z

• Redo ⌘ + y or Ctrl + y

• Paste Special ⌘ + Shift + v or Ctrl + Shift + v

• =Randbetween()
  

• Select Cells Shift + Arrows

• Move to the beginning of row Fn + Left Arrow or Home

• Move to the beginning of sheet ⌘ + Fn + Left Arrow or Ctrl + Home

• Move to end of row Fn + Right Arrow or End

• Move to end of sheet ⌘ + Fn + Right Arrow or Ctrl + End

• Next Sheet ⌥ + Down Arrow or Alt + Down Arrow

• Previous Sheet ⌥ + Up Arrow or Alt + Up Arrow

• Bold ⌘ + b or Ctrl + b

• Italic ⌘ + i or Ctrl + i

• Underline ⌘ + u or Ctrl + u

• Strikethrough ⌥ + Shift + 5 or Alt + Shift + 5

• Insert/edit comment ⌘ + ⌥ + m or Ctrl + Alt + m

• Select all ⌘ + a or Ctrl + a

• Select column Ctrl + Space

• Select row Shift + Space

• Remove Formatting ⌘ + \ or Ctrl + \

• Joining Strings together using & sign

• IF function Returns one value if a logical expression is `TRUE` and another if it is `FALSE`.

  • Sample Usage

    IF(A2 = "foo","A2 is foo")

    IF(A2,"A2 was true","A2 was false")

    IF(TRUE,4,5)

• LEN Returns the length of a string.

  • Sample Usage

    LEN(A2)

    LEN("lorem ipsum")

• randbetween()

• JOIN(delimiter, value_or_array1, [value_or_array2, ...])

  • delimiter - The character or string to place between each concatenated value.

    • delimiter may be specified as blank, e.g. JOIN(,{1,2,3}).

    • value_or_array1 - The value or values to be appended using delimiter.

    • value_or_array2, ... - [ OPTIONAL ] - Additional value or array to be appended using delimiter.

• TEXTJOIN(delimiter, ignore_empty, text1, [text2, ...])

  • delimiter - A string, possibly empty, or a reference to a valid string. If empty, text will be simply concatenated.

  • ignore_empty - A boolean; if TRUE, empty cells selected in the text arguments won't be included in the result.

  • text1 - Any text item. This could be a string, or an array of strings in a range.

  • text2, ... [OPTIONAL] - Additional text item(s).

• SPLIT("1,2,3", ",")

• SPLIT("Alas, poor Yorick"," ")

• SPLIT(A1, ",")

• 
  

• Increase and decrease the decimal point using the buttons

• ROUND(value, [places]) value - The value to round to places number of places. places - [ OPTIONAL - 0 by default ] - The number of decimal places to which to round. places may be negative, in which case value is rounded at the specified number of digits to the left of the decimal point.

• TRUNC: Truncates a number to a certain number of significant digits by omitting less significant digits.

• ROUNDUP: Rounds a number to a certain number of decimal places, always rounding up to the next valid increment.

• ROUNDDOWN: The ROUNDDOWN function rounds a number to a certain number of decimal places, always rounding down to the next valid increment.

• MROUND: Rounds one number to the nearest integer multiple of another.

• INT: Rounds a number down to the nearest integer that is less than or equal to it.

• FLOOR: The FLOOR function rounds a number down to the nearest integer multiple of specified significance.

• CEILING: The CEILING function rounds a number up to the nearest integer multiple of specified significance.

• ISBLANK Function

  • Syntax

    ISBLANK(value)

    
    

    value - Reference to the cell that will be checked for emptiness.

    
    

    ISBLANK returns TRUE if value is empty or a reference to an empty cell, and FALSE if it contains data or a reference to data.

• ISTEXT Function

  • Syntax

    ISTEXT(value)

    
    

    value - The value to be verified as text.

    
    

    ISTEXT returns TRUE if this is a text value or a reference to a cell containing a text value and FALSE otherwise.

• ISNUMBER Function

  • Syntax

    ISNUMBER(value)

    
    

    value - The value to be verified as a number.

    
    

    *ISNUMBER returns TRUE if this is a number or a reference to a cell containing a numeric value and FALSE otherwise.

• ISNONTEXT Function

  • Syntax

    ISNONTEXT(value)

    
    

    value - The text to be checked.

    
    

    ISNONTEXT returns FALSE if this is a text value or a reference to a cell containing a text value and TRUE otherwise.

    
    

    When value is a reference to an empty cell, ISNONTEXT will return TRUE.

    
    

    When value is an empty string, ISNONTEXT will return FALSE, as the empty string is considered text.

• ISODD Function

  • Syntax

    ISODD(value)

    
    

    value - The value to be verified as odd.

    
    

    ISODD returns TRUE if value is an odd integer or a reference to a cell containing an odd integer, and FALSE otherwise.

• ISEVEN Function

  • Syntax

    ISEVEN(value)

    
    

    value - The value to be verified as even.

    
    

    ISEVEN returns TRUE if value is an even integer or a reference to a cell containing an even integer, and FALSE otherwise.

• ISLOGICAL Function

  • Syntax

    ISLOGICAL(value)

    
    

    value - The value to be verified as a logical TRUE or FALSE.

    
    

    *ISLOGICAL returns TRUE if value is either TRUE or FALSE or a reference to a cell whose value is either TRUE or FALSE.

• ISEMAIL Function

  • Syntax

    ISEMAIL(value)

    
    

    value - The value to be verified as an email address.

• ISURL Function

  • Syntax

    ISURL(value)

    
    

    value - The value to be verified as a URL.

• Freezing Cells and Columns

• Alternating Colors

• Custom Page Breaks

• Print options

• Sorting by Sheet

• Sorting by Range

• SORT Function

  • Syntax

    SORT(range, sort_column, is_ascending, [sort_column2, is_ascending2, ...])

    
    

    range - The data to be sorted.

    
    

    sort_column - The index of the column in range or a range outside of range containing the values by which to sort.

    
    

    A range specified as a sort_column must be a single column with the same number of rows as range.

    is_ascending - TRUE or FALSE indicating whether to sort sort_column in ascending order. FALSE sorts in descending order.

    
    

    sort_column2, is_ascending2 ...

    
    

    [ OPTIONAL ] - Additional columns and sort order flags beyond the first, in order of precedence.

• SORTN Function

  • Syntax

    SORTN(range, [n], [display_ties_mode], [sort_column1, is_ascending1], ...)

    
    

    range - The data to be sorted to find the first n items.

    n - [OPTIONAL - 1 by default] The number of items to return. Must be greater than 0.

    display_ties_mode - [OPTIONAL - 0 by default] A number representing the way to display ties.

    0: Show at most the first n rows in the sorted range.

    1: Show at most the first n rows, plus any additional rows that are identical to the nth row.

    2: Show at most the first n rows after removing duplicate rows.

    3: Show at most the first n unique rows, but show every duplicate of these rows.

    sort_column1 - [OPTIONAL] - The index of the column in range or a range outside of range containing the values to sort by. A range specified as a sort_column1 must be a single column with the same number of rows as range.

    
    

    is_ascending1 - [OPTIONAL] - TRUE or FALSE indicates how to sort sort_column1. TRUE sorts in ascending order. FALSE sorts in descending order.

    sort_column2, is_ascending2, ... - [OPTIONAL] - Additional columns and sort order flags used if a tie happens, in order of precedence.

• Filtering with conditions

• Filtering by Colour

• Filtering using the slicer

• NOW Function

  • Syntax

    NOW()

    
    

    Notes

    Note that NOW is a volatile function, updating on every edit made to the spreadsheet, and can hurt spreadsheet performance.

    
    

    NOW provides the current date and time. To create a date without the current time, use TODAY.

    
    

    NOW will always represent the current date and time the last time the spreadsheet was recalculated, rather than remaining at the date and time when it was first entered.

    
    

    The time or date component of NOW may be hidden by changing the number formatting on the cell. If either the date or time is not appearing, change the number formatting.

• TODAY Function

  • Syntax

    TODAY()

    
    

    Notes

    Note that TODAY is a volatile function and can hurt spreadsheet performance.

    
    

    TODAY provides the current date with no time component. To create a date with the current time, use NOW.

    
    

    TODAY will always represent the current date the last time the spreadsheet was recalculated, rather than remaining at the date when it was first entered.

You can utilize the NOW and TODAY functions instead of manually entering times and dates into a Google Sheets in Google Workspace. These functions display the current time or date, updating on a regular basis or as your spreadsheet changes.

While the NOW and TODAY features update on a regular basis, you can use keyboard shortcuts to rapidly insert a non-updating time or date stamp.

Using NOW to add the current time and date

Using the NOW function in Google Sheets to add the current time and date is almost too simple. Although the NOW method does not require any additional arguments, you will need to format any cells that use NOW alone to display the time.

The timestamp returned by a formula utilizing the NOW function is usually only updated when your spreadsheet is changed. Additionally, you may arrange your spreadsheet to update every minute or every hour.

To do so, go to File > Spreadsheet Settings, choose the "Calculation" tab, and then select the "Recalculation" drop-down menu from the "Update Frequency" drop-down menu.

Data Validation in Google Sheets

• UNIQUE Function

  • Sample Usage

    UNIQUE(A2:B26)

    
    

    UNIQUE({1, 2; 3, 4; 5, 6})

    
    

    Syntax

    UNIQUE(range)

    
    

    range - The data to filter by unique entries.

    Notes

    If rows are returned which appear to be duplicates, ensure that cells including text do not have differing hidden text such as trailing spaces.

    
    

    Ensure that numeric values are formatted in the same way - percentages as percentages, currency values as currency values, etc.

    
    

• VLOOKUP in Google Sheets

  Vertical lookup. Searches down the first column of a range for a key and returns the value of a specified cell in the row found.

  
  

  Sample Usage

  VLOOKUP(10003, A2:B26, 2, FALSE)

  
  

  Syntax

  VLOOKUP(search_key, range, index, [is_sorted])

  
  

  search_key - The value to search for. For example, 42, "Cats", or I24.

  
  

  range - The range to consider for the search. The first column in the range is searched for the key specified in search_key.

  
  

  index - The column index of the value to be returned, where the first column in range is numbered 1.

  
  

  If index is not between 1 and the number of columns in range, #VALUE! is returned.

  is_sorted - [TRUE by default] - Indicates whether the column to be searched (the first column of the specified range) is sorted. FALSE is recommended in most cases.

  
  

  It’s recommended to set is_sorted to FALSE. If set to FALSE, an exact match is returned. If there are multiple matching values, the content of the cell corresponding to the first value found is returned, and #N/A is returned if no such value is found.

  
  

  If is_sorted is TRUE or omitted, the nearest match (less than or equal to the search key) is returned. If all values in the search column are greater than the search key, #N/A is returned.

  
  

  Notes

  If is_sorted is set to TRUE or omitted, and the first column of the range is not in sorted order, an incorrect value might be returned. If VLOOKUP doesn’t appear to be giving correct results, check that the last argument is set to FALSE. If the data is sorted and you need to optimize for performance, set it to TRUE. In most cases it should be set to FALSE.

  
  

  When searching for numeric or date values, make sure that the first column in the range is not sorted by text values. For example, correctly sorted numbers should appear as (1, 2, 10, 100) rather than (1, 10, 100, 2) as they would be if they were sorted as strings. Using an incorrect sort type may cause incorrect values to be returned.

  
  

  Search keys based on regular expressions are NOT supported. Use QUERY instead.

  
  

  VLOOKUP has much better performance with sorted ranges and is_sorted set to TRUE. Consider sorting the column being searched.

  
  

  You can also find matches using pattern strings that include wildcards. The question mark (?) and asterisk (*) are the wildcards for search_key, with the question mark standing in for a single character and the asterisk standing in for any series of characters. If you need to match an actual question mark or asterisk, add a tilde (~) before the character and add an extra tilde if you're looking for something with an actual tilde in it.

Pivot tables aid in the summarization of data, the discovery of trends, and the reorganization of information. In Google Sheets, you can either add pivot tables based on suggestions or manually create them. You can add and move data, apply a filter, drill down to discover details about a calculation, organize data, and more once you build a pivot table.

Watch this lesson to get up to speed on why Google Sheets and Pivot Tables are the best combination in Google Workspace.

Spreadsheets provide great analysis skills, but they occasionally lack that extra layer of understanding. It's difficult to summarize or draw conclusions from a basic tabular spreadsheet view when there's a lot of data.

The pivot table comes into play.

Pivot tables are the bread and butter of most Excel advanced users, but Google Sheets has the same feature, so you may use pivot tables while staying in Google Workspace. We'll go over how to create pivot tables in Google Sheets in this tutorial.

• GOOGLEFINANCE in Google Sheets

  Fetches current or historical securities information from Google Finance.

  
  

  Sample Usage

  GOOGLEFINANCE("NASDAQ:GOOG", "price", DATE(2014,1,1), DATE(2014,12,31), "DAILY")

  
  

  GOOGLEFINANCE("NASDAQ:GOOG","price",TODAY()-30,TODAY())

  
  

  GOOGLEFINANCE(A2,A3)

  
  

  Syntax

  GOOGLEFINANCE(ticker, [attribute], [start_date], [end_date|num_days], [interval])

  
  

  ticker - The ticker symbol for the security to consider. It’s mandatory to use both the exchange symbol and ticker symbol for accurate results and to avoid discrepancies. For example, use “NASDAQ:GOOG” instead of “GOOG.”

  
  

  If the exchange symbol is not specified, GOOGLEFINANCE will use its best judgement to choose one for you.

  
  

  Note: Reuters Instrument Codes are no longer supported. For example, use TSE:123 or ASX:XYZ instead of ticker 123.TO or XYZ.AX.

  
  

  attribute - [ OPTIONAL - "price" by default ] - The attribute to fetch about ticker from Google Finance and is required if a date is specified.

  
  

  attribute is one of the following for real-time data:

  
  

  "price" - Real-time price quote, delayed by up to 20 minutes.

  
  

  "priceopen" - The price as of market open.

  
  

  "high" - The current day's high price.

  
  

  "low" - The current day's low price.

  
  

  "volume" - The current day's trading volume.

  
  

  "marketcap" - The market capitalization of the stock.

  
  

  "tradetime" - The time of the last trade.

  
  

  "datadelay" - How far delayed the real-time data is.

  
  

  "volumeavg" - The average daily trading volume.

  
  

  "pe" - The price/earnings ratio.

  
  

  "eps" - The earnings per share.

  
  

  "high52" - The 52-week high price.

  
  

  "low52" - The 52-week low price.

  
  

  "change" - The price change since the previous trading day's close.

  
  

  "beta" - The beta value.

  
  

  "changepct" - The percentage change in price since the previous trading day's close.

  
  

  "closeyest" - The previous day's closing price.

  
  

  "shares" - The number of outstanding shares.

  
  

  "currency" - The currency in which the security is priced. Currencies don't have trading windows, so open, low, high, and volume won't return for this argument.

  
  

  attribute is one of the following for historical data:

  
  

  "open" - The opening price for the specified date(s).

  
  

  "close" - The closing price for the specified date(s).

  
  

  "high" - The high price for the specified date(s).

  
  

  "low" - The low price for the specified date(s).

  
  

  "volume" - The volume for the specified date(s).

  
  

  "all" - All of the above.

  
  

  attribute is one of the following for mutual fund data:

  
  

  "closeyest" - The previous day's closing price.

  
  

  "date" - The date at which the net asset value was reported.

  
  

  "returnytd" - The year-to-date return.

  
  

  "netassets" - The net assets.

  
  

  "change" - The change in the most recently reported net asset value and the one immediately prior.

  
  

  "changepct" - The percentage change in the net asset value.

  
  

  "yieldpct" - The distribution yield, the sum of the prior 12 months' income distributions (stock dividends and fixed income interest payments) and net asset value gains divided by the previous month's net asset value number.

  
  

  "returnday" - One-day total return.

  
  

  "return1" - One-week total return.

  
  

  "return4" - Four-week total return.

  
  

  "return13" - Thirteen-week total return.

  
  

  "return52" - Fifty-two-week (annual) total return.

  
  

  "return156" - 156-week (3-year) total return.

  
  

  "return260" - 260-week (5-year) total return.

  
  

  "incomedividend" - The amount of the most recent cash distribution.

  
  

  "incomedividenddate" - The date of the most recent cash distribution.

  
  

  "capitalgain" - The amount of the most recent capital gain distribution.

  
  

  "morningstarrating" - The Morningstar "star" rating.

  
  

  "expenseratio" - The fund's expense ratio.

  
  

  start_date - [ OPTIONAL ] - The start date when fetching historical data.

  
  

  If start_date is specified but end_date|num_days is not, only the single day's data is returned.

  end_date|num_days - [ OPTIONAL ] - The end date when fetching historical data, or the number of days from start_date for which to return data.

  
  

  interval - [ OPTIONAL ] - The frequency of returned data; either "DAILY" or "WEEKLY".

  
  

  interval can alternatively be specified as 1 or 7. Other numeric values are disallowed.

  Notes

  Usage restrictions: The data is not for financial industry professional use or use by other professionals at non-financial firms (including government entities). Professional use may be subject to additional licensing fees from a third-party data provider.

  
  

  All parameters must be enclosed in quotation marks or be references to cells containing text.

  Note: A possible exception is when interval is specified as a number and when end_date|num_days is specified as a number of days.

  
  

  Real-time results will be returned as a value within a single cell. Historical data, even for a single day, will be returned as an expanded array with column headers.

  
  

  Some attributes may not yield results for all symbols.

  
  

  If any date parameters are specified, the request is considered historical and only the historical attributes are allowed.

  GOOGLEFINANCE is only available in English and does not support most international exchanges.

  
  

  Historical data cannot be downloaded or accessed via the Sheets API or Apps Script. If you attempt to do so, you'll see a #N/A error in place of the values in the corresponding cells of your spreadsheet.

  
  

  Quotes are not sourced from all markets and may be delayed up to 20 minutes. Information is provided 'as is' and solely for informational purposes, not for trading purposes or advice.

  
  

  Dates passed into GOOGLEFINANCE are treated as noon UTC time. Exchanges that close before that time may be shifted by a day.

• INDEX
  Sample Usage

  INDEX(A1:C20, 5, 1)

  
  

  Syntax

  INDEX(reference, [row], [column])

  
  

  reference - The array of cells to be offset into.

  
  

  row - [OPTIONAL - 0 by default] - The number of offset rows.

  
  

  column - [OPTIONAL - 0 by default] - The number of offset columns.

  
  

  See Also

  MATCH: Returns the relative position of an item in a range that matches a specified value.

  
  

  OFFSET: Returns a range reference shifted a specified number of rows and columns from a starting cell reference.

  
  

  Notes

  If you set row or column to 0, INDEX returns the array of values for the entire column or row, respectively.

• IMPORTHTML

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

  
  

  Sample Usage

  IMPORTHTML("http://en.wikipedia.org/wiki/Demographics_of_India","table",4)

  
  

  IMPORTHTML(A2,B2,C2)

  
  

  Syntax

  IMPORTHTML(url, query, index)

  
  

  url - The URL of the page to examine, including protocol (e.g. http://).

  
  

  The value for url must either be enclosed in quotation marks or be a reference to a cell containing the appropriate text.

  query - Either "list" or "table" depending on what type of structure contains the desired data.

  
  

  index - The index, starting at 1, which identifies which table or list as defined in the HTML source should be returned.

  
  

  The indices for lists and tables are maintained separately, so there may be both a list and a table with index 1 if both types of elements exist on the HTML page.

Create arrays in Google Sheets

You can create your own arrays in a formula in your spreadsheet by using brackets { }. The brackets allow you to group together values, while you use the following punctuation to determine which order the values are displayed in:

• Commas: Separate columns to help you write a row of data in an array. For example, ={1, 2} would place the number 1 in the first cell and the number 2 in the cell to the right in a new column. Please note that based on your Locale you may have to use a "\" rather than a ",". See this video for more info. https://vimeo.com/580192468/48c753caac

• Semicolons: Separate rows to help you write a column of data in an array. For example, ={1; 2} would place the number 1 in the first cell and the number 2 in the cell below in a new row.

Note: For countries that use commas as decimal separators (for example €1,00), commas would be replaced by backslashes (\) when creating arrays.

You can join multiple ranges into one continuous range using this same punctuation. For example, to combine values from A1-A10 with the values from D1-D10, you can use the following formula to create a range in a continuous column: ={A1:A10; D1:D10}.

Adding arrays to existing formulas

You can also use arrays with other existing formulas using brackets in order to organize the returns from your formulas into rows or columns.

For example, ={SUM(A1:A10), SUM(B1:B10)} will produce two values. The first cell will contain the sum of A1 to A10, the cell to the right will contain the sum of B1 to B10.

ARRAYFORMULA

Enables the display of values returned from an array formula into multiple rows and/or columns and the use of non-array functions with arrays.

Sample Usage

ARRAYFORMULA(SUM(IF(A1:A10>5, A1:A10, 0)))

ARRAYFORMULA(A1:C1+A2:C2)

Syntax

ARRAYFORMULA(array_formula)

• array_formula - A range, mathematical expression using one cell range or multiple ranges of the same size, or a function that returns a result greater than one cell.

Notes

• Many array formulas will be automatically expanded into neighboring cells, obviating the explicit use of ARRAYFORMULA.

• Pressing Ctrl+Shift+Enter while editing a formula will automatically add ARRAYFORMULA( to the beginning of the formula.

• Note that array formulas cannot be exported.

To keep track of ranges and generate cleaner formulas, you can name them in Google Sheets.