In this Google Workspace tutorial, I share how you can get started with Google Workspace in 2023.

Google Workspace is a leading business suite that offers dozens of productivity and collaboration tools for individuals and businesses. Google Workspace is also one of the top email services for setting up business emails.

👉 MY NEW PRODUCT LAUNCH!
I have created a functional CRM with Google Sheets called Sheetify CRM that connects to Google Workspace and allows you to send bulk ‘personalized’ emails in just a few clicks, and manage clients, sales, tasks, and more!

✅ Learn more about my Sheetify CRM here ➜ https://www.sheetifycrm.com/products/sheetify-google-sheets-crm-template
(Discount code SHEETIFY10OFF for 10% off!)

🛠️ My Top Recommended Tools for Small Business 🛠️
👉 https://stewartgauld.com/tools

In this Google Workspace guide for getting started, I share all the basics you need to setup up your Google Workspace accounts. If you are a small business owner and you’re not sure how to get the most out of Google Workspace, then this tutorial is for you.

► Looking for a simple, understandable and actionable road map for setting up your small business online? Start here and get our all-in-one small business playbook:
https://godigitalnow.store/products/go-digital-now-the-ultimate-small-business-playbook-ebook

If you are completely new to Google Workspace and you have yet to set up your domain with Google Workspace, then feel free to watch our part one tutorial for the initial setup. See our video down below.

How to setup Google Workspace (Part 1):

Get started with a 14-day free trial here:
https://workspace.google.com

► Here are the other tutorials and resources that we mentioned in this tutorial:

Learn more about user’s roles and privileges:
https://support.google.com/a/answer/7519580?hl=en

How to create a free email signature:

How to increase email deliverability for Google Workspace:

How to setup SMTP for Gmail:

► Here are other Google App tutorials to help you learn more about each of these powerful apps for businesses:

Top 5 essential apps for small businesses:

How to use Google Forms:

How to create a website for free with Google Sites:

How to use Google Drive:

How to use Google ads:

► Here are the following chapters for this Google Workspace tutorial:

0:00 Intro
01:14 Getting started
02:29 Admin home
02:51 Google Apps
04:17 Add new users
05:17 Primary email vs email alias
07:05 Administrator roles
08:35 How to add email Alias
10:07 How to send as email alias
12:04 Add email signature
14:16 Email groups
15:33 Outro

► Are you interested in joining our small business community?
Join us to receive actionable tips, tutorials and tools to grow your small business online (Subscribe to our email list here): https://mailchi.mp/71ac3fcdbfdf/stewart-gauld

Let me know if you found this Google Workspace tutorial helpful. Also, if you require any help or support with your online activities, make sure to get in touch with me today.

Thanks for watching and enjoy!

#businessemail #googleworkspace
Video Rating: / 5

Share this page:

The Google Sheets WEEKDAY and WEEKNUM functions return the day of the week and week number of the year respectively. Each of these functions have the same type and number of attributes.

WEEKDAY Function

The weekday function returns the day of the week of the specified date as a number. Its value ranges from 0 to 7, depending on the value specified for the type attribute.

Here is the format of the WEEKDAY function formula:

=WEEKDAY(date, [type])

Start the formula with an equal-to symbol.

date is the date for which to get the day of the week. Date, for example, can be a hard-coded date, an address of a cell containing a date, or a function that returns a date.

type is optional, and is a number indicating the numbering system to be used to represent the days of the week.

The default value is 1. It indicates that days are counted starting from Sunday. Its value is 1. Monday’s value is 2, Tuesday’s value is 3, and so on.

If type equals 2, the days are counted starting from Monday. Its value is 1, Tuesday’s value is 2, and Sunday’s value is 7.

If type equals 3, the days are counted starting from Monday. Its value is 0. Monday’s value is 1, and Sunday’s value is 6.

Let’s look at an example of the WEEKDAY function formula:

=WEEKDAY(“9/1/2021”, 1)

The above function formula returns 4. It means the day, which is 1, is the
fourth day of the week.

WEEKNUM Function

The WEEKNUM function returns the number of the week of the year of the specified date.

Here is the format of the WEEKNUM function formula:

=WEEKNUM(date, [type])

date is the date for which to get its week of the year.

type is optional. Its value can be any one of 1, 2, 11, 12, 13, 14, 15, 16, 17, or 21. These numbers define the start and end day of a week for counting
week numbers. If this attribute is omitted, the function uses 1 as the default value.

System 1 and System 2

The two numbering systems the WEEKNUM function indirectly uses are either System 1 or System 2. In System 1, the first week of the year is the one which contains January 1 and is represented as week 1.

In System 2, the first week of the year is the one which contains the first Thursday of the year and is represented as week 1.

The definition of a value of the type attribute is:

1 = Week begins on Sunday, ends on Saturday.
2 = Week begins on Monday, ends on Sunday.
11 = Week begins on Monday, ends on Sunday.
12 = Week begins on Tuesday, ends on Monday.
13 = Week begins on Wednesday, ends on Tuesday.
14 = Week begins on Thursday, ends on Wednesday.
15 = Week begins on Friday, ends on Thursday.
16 = Week begins on Saturday, ends on Friday.
17 = Week begins on Sunday, ends on Saturday.

In System 2 only:

21 = Week begins on Monday, ends on Sunday.

Let’s look at an example:

=WEEKNUM(“9/1/2021”, 1)

The above function formula returns 36 as the number of the week, of the year, to which the specified date belongs.

Take a look at this video tutorial, which gives the steps to use the Google Sheets WEEKDAY and WEEKNUM functions with examples.

This video demonstrates how to use Excel’s WEEKNUM and ISOWEEKNUM functions to convert a date into its week number.
————————
Video Rating: / 5

Share this page:

https://homeconstructionspreadsheet.com

Be your own General Contractor! Estimate the cost and schedule of building a house, then have a step-by-step checklist to guide you through construction.
Video Rating: / 5

Share this page: