by trace-admin | Oct 1, 2023 | News
Google Sheets is Google's answer to traditional spreadsheet software and is part of the Google Workspace productivity suite. It is a cloud-based tool that allows users to create, edit and collaborate on spreadsheets online.
1. Basic Spreadsheet Functionalities:
- Google Sheets offers the traditional functionalities of a spreadsheet application, such as creating tables, using mathematical and statistical formulae, formatting cells and much more.
2. Real-time collaboration:
- Similar to Google Docs, Google Sheets allows several users to edit a spreadsheet simultaneously. Each user sees the others' edits in real time, identified by specific colours.
- You can add specific comments to cells or regions of the spreadsheet and start conversations on those comments.
3. Version history:
- Sheets automatically saves a history of all versions of the spreadsheet, allowing users to see the changes made over time and revert to a previous version if necessary.
4. Integration with Google Drive:
- Files created in Google Sheets are automatically saved in Google Drive, providing secure storage and easy access from any internet-connected device.
5. Offline mode:
- Like Google Docs, Google Sheets allows users to edit spreadsheets offline, synchronising changes as soon as the internet connection is restored.
6. Compatibility and Import/Export:
- Google Sheets is compatible with other popular spreadsheet formats, such as XLS and XLSX from Microsoft Excel. You can import files from these formats, edit them in Google Sheets and then export them back to the original format or other available formats.
7. Predefined templates:
- Google Sheets offers a variety of predefined templates for various needs, such as budgets, calendars, project planning and much more.
8. Advanced Functions and Scripting:
- In addition to the common spreadsheet functions, Google Sheets offers the possibility of using Google Apps Script, enabling the creation of customised functions, automation and integration with other Google services.
9. Graphs and Data Analysis:
- Google Sheets allows you to create a variety of graphs based on the data you enter. It also has data analysis tools and can even connect to external data sources.
10. Extensions and add-ons:
- The functionality of Google Sheets can be expanded with a variety of add-ons available in the Google Workspace Marketplace.
11. Security and privacy:
- Similar to Google Docs, it is possible to share spreadsheets with specific permission settings, and Google employs robust security measures to protect user data.
To summarise, Google Sheets is a versatile and powerful spreadsheet tool that especially benefits those who value real-time collaboration and access to their files from anywhere.
by trace-admin | Oct 1, 2023 | News
Google Docs is a cloud-based word processor that lets you create, edit and store documents online.
1. Basic Text Editing Functionalities:
- Google Docs offers all the basic functionalities of a word processor, such as text formatting (bold, italics, underlining), creating numbered or bulleted lists, text alignment, etc.
2. Real-time collaboration:
- One of the most notable features of Google Docs is the ability to allow multiple users to edit a document simultaneously.
- Edits are visible in real time, and each user has a specific colour to identify their changes.
- You can add comments to any part of the document and even start conversations within those comments.
3. Version history:
- Google Docs automatically saves all versions of a document, allowing users to see the changes made over time and, if necessary, revert to a previous version.
4. Integration with Google Drive:
- All documents created or edited in Google Docs are automatically saved in Google Drive, Google's cloud storage service.
- This integration allows easy sharing and access to documents from any device with an internet connection.
5. Offline mode:
- Although Google Docs is a cloud-based application, you can edit documents offline. Changes are synchronised as soon as the device reconnects to the internet.
6. Compatibility:
- Google Docs supports various file formats, including DOC, DOCX, PDF, RTF and others.
- You can import and edit documents from other formats and then export the document in the desired format.
7. Predefined templates:
- To make it easier to create documents, Google Docs offers a variety of predefined templates, such as CVs, letters, notes and reports.
8. Additives and Extensions:
- Google Docs supports a variety of add-ons and extensions that can be installed to extend the word processor's functionality.
9. Integrated Search Tools:
- Using the "Explore" feature, users can carry out web searches directly within Google Docs, making it easy to insert information, images and even quotes.
10. Security and privacy:
- Documents can be shared with specific permission settings: from giving someone full editing access to only allowing viewing.
- Google also employs various security measures to ensure that stored documents are protected.
In short, Google Docs is a robust and versatile tool that has revolutionised the way people work and collaborate on text documents. It is especially popular with users who value the ability to access and edit documents from anywhere and on any device with internet access.
by trace-admin | Sep 27, 2023 | Google Workspace configuration
DomainKeys Identified Mail (DKIM) is an email authentication standard that allows the sender (in this case, Google Workspace) to demonstrate that the messages sent are genuine and have not been altered in transit. By setting up DKIM, you help protect your company's emails from spoofing, phishing and other malicious techniques.
Here's a basic guide on how to set up DKIM records for Google Workspace:
- Sign in to the Google Workspace Admin ConsoleGo to the Google Workspace Admin Console (admin.google.com) and log in with your administrator account.
- Navigate to Gmail settingsIn the left-hand side panel, click on "Applications" and then select "Gmail".
- Email authenticationScroll down to the "Email authentication" section and click on "Configure email authentication".
- Activate DKIMSelect the "Activate DKIM" option and click on the "Generate new registration" button. Choose the selector prefix (usually "google") and follow the instructions.
- Create the DKIM record in your DNSGoogle will provide you with a record name (which includes the prefix of your chosen selector) and a record value. You will need to add this TXT record to your domain's DNS configuration. The record value will be something like "v=DKIM1; k=rsa; p=MIGfMA0G... (rest of key)". To do this, go to the control panel of your domain provider (where you registered your domain) and look for the section for adding or managing DNS records. Create a new TXT record, enter the name and value provided by Google Workspace.
- Check the configurationAfter adding the DKIM record to the DNS, it can take some time (sometimes up to 48 hours) for it to propagate completely. Go back to the Admin Console and check the configuration. When everything is correct, the DKIM status will change to "Active".
- FinishOnce DKIM is active, messages sent via Gmail will include a digital signature that verifies their origin and integrity.
by trace-admin | Nov 19, 2023 | Google Workspace configuration
The DMARC register (Domain-based Message Authentication, Reporting, and Conformance) is used to improve email security by specifying how an email service should handle messages that fail the SPF and DKIM authentication tests.
To set up a DMARC record for Google Workspace, your domain's DNS record might look something like this:
v=DMARC1; p=none; rua=mailto:[email protected]; ruf=mailto:[email protected]; fo=1;
In this example:
v=DMARC1 indicates the version of the DMARC record.
p=none defines the policy for handling e-mails that fail DMARC tests. none means that no specific action is taken, but this can be changed to quarantine (send emails to quarantine) or reject (reject emails) depending on your needs.
rua=mailto:[email protected] specifies where the aggregated DMARC reports should be sent. Replace [email protected] with the e-mail address where you want to receive these reports.
ruf=mailto:[email protected] indicates where forensic failure reports should be sent. Replace [email protected] with the appropriate e-mail address.
fo=1 determines the conditions under which forensic failure reports are generated. 1 means that reports are generated if there are failures in SPF or DKIM.
Remember that DMARC configuration must be done carefully, as misconfigured policies can affect email delivery. It is therefore advisable to start with a policy none and monitor reports before moving on to more restrictive policies such as quarantine or reject.
It is also essential to replace the e-mail addresses in the fields street e ruf their own e-mail addresses to receive DMARC reports.
by trace-admin | Nov 19, 2023 | Google Workspace configuration
The "postmaster" e-mail address is a standard convention used in e-mail system administration. Traditionally, "[email protected]" serves as a central point of contact for email-related issues for a specific domain (in this case, "example.com").
Here are some important aspects of the "postmaster" e-mail:
Purpose:
It is intended for e-mail administration and system maintenance.
It serves as a point of contact for external email-related problems, such as delivery issues, spam reports, and authentication problems (SPF, DKIM, DMARC).
Internet standard:
The existence of a "postmaster" address is a requirement defined in the Internet e-mail standards, specifically in RFC 5321.
This standard ensures that there is always a way to contact someone responsible for a domain's email services.
Technical issues and abuse:
System administrators use the "postmaster" address to receive notifications about technical problems, such as delivery errors, bounces, and other routing issues.
It is also used to report email abuse, such as phishing or spam activities originating from the domain.
Maintenance and monitoring:
The address should be monitored regularly by an administrator or IT team to ensure that critical issues are attended to promptly.
Ideally, it should be configured to accept emails from any source, to ensure effective communication about email problems.
Privacy and Security:
Due to its nature, the "postmaster" address can be a target for spam. It is therefore important to have appropriate filters and security measures in place.
It must be managed in such a way as to protect the privacy and security of incoming communications.
In short, the email "postmaster" is a vital part of a domain's email infrastructure, offering an essential communication channel for email administration and security-related issues.
