Aug 26, 2022

[Compare Google Spreadsheet Functions vs. Excel Functions in details]

Google Spreadsheets has been updated dramatically. More features will be updated in the future.

I compared how Excel spreadsheet is compatible with Excel, how many functions it provides, and how many types of functions.

The total number of functions provided by MS Excel is 504 (as of July 2022). (Refer to Microsoft site.)

The total number of functions provided by Spreadsheet is 494. (Refer to Google Site)

Please refer here for the one-by-one comparison of each function and the detailed analysis of function definition and explanation. In this sheet, I have compared the functions in this sheet as shown below.

What I felt when creating this analysis was that Google Spreadsheets now offers nearly all the important features, although it is not 100% identical to MS Excel. Google recently added a macro feature to Google Spreadsheets. This means that it offers almost all of the features that MS Excel has.

I know that MS Excel is different from the function of online office 365 and the function of installed Excel. In other words, browser-based online Excel has functional limitations compared to installed Excel. Google Spreadsheets, on the other hand, is 100% cloud-based and has the advantage of being immediately available with a browser and is also free.

See here for a detailed comparison of Google Spreadsheet functions and Excel functions.


Aug 23, 2022

[Google Workspace Enterprise] 4 Major Features for Enhanced Security

Google Workpsace Enterprise version is different from Google Workpsace Business Starter and Google Workpsace Business Plus version. If a company is considering enhancing security especially when applying Google Workpsace Enterprise it is necessary to review Google Workpsace Enterprise because of the following four key features for security.

In order to maximize the efficiency of business, the company needs to activate collaboration, prevent important internal data leakage, protect customers' personal information, and use various security systems to safeguard intellectual property from various malware, phishing attempts and malicious viruses.

To further enhance security, IT systems need to be accessible only from a trusted network (for example, a company's internal network), and administrators should be able to access computers that are not registered.

There are a variety of 3rd party solutions to address these security issues. However, the additional cost of introducing can be inconvenient.

Google Workpsace Enterprise offers a variety of services to safeguard against the various security threats mentioned above at no additional cost.

Google Workpsace Enterprise has four more security enhancements.

1. Context Aware Access:

  • Administrator can register your company's computer as a trusted device, make sure that unregistered computers do not have access to the Google Workpsace service, and use the Google Workpsace apps (Gmail, Drive, Calendar, Google Keep).

2. Security sandbox for Gmail 

  • Malicious behavior is fundamentally blocked by "running" previously unknown malware in a secure sandbox environment and analyzing the side effects of the operating system.

3. Data Loss Prevention

  • Gmail DLP and Drive DLP are designed to prevent people from accidentally or deliberately sending confidential company data or personal data that they should not leak by e-mail or external sharing, To provide monitoring and censorship capabilities.

4. Security Investigation tool

  • When a large number of malicious e-mail, spam, and phishing e-mails are delivered to a large number of users from outside, administrators can now delete messages already sent to users and mark them as spam There is a need to do.
  • Access Gmail log data to find and delete malicious emails, mark emails as spam or phishing, and send emails to users' inboxes.
  • Access drive log data to investigate the sharing of files in your organization, creation and deletion of documents, and users who have accessed documents.

New Advanced Chrome Device Management (Book) - Chrome Enterprise/Education Upgrade

In 2017, I published a book through Amazon titled “Advanced Chrome Device Management”. Many thanks to you for purchasing this book.

Google has been selling to schools and businesses under the name ‘Chrome Device Management license’ since 2017.

Google began strengthening its Chrome business in 2019. Google has launched a product called Chrome Enterprise. This Chrome Enterprise includes Chrome browser, Chrome OS, Chromebook, and Chrome Device management.

Beginning in 2020, Chrome Device Management License name has been changed to Chrome Enterprise Upgrade for businesses and Chrome Education Upgrade for education.

Since publishing the Advanced Chrome Device Management book in 2017, Google has changed its name and updated many of its internal features. This led to the need to publish new book to reflect these updates.

In this book, I easily organized the Chrome Enterprise Help documentation provided by Google regarding Chrome Device Management and made it easy to set up and manage what users actually need through ten workshops as described below.

How to manage Users & Browser
  • Workshop 1:How to change User’s Avatar
  • Workshop 2:How to disable to show ‘Home’ button of the browser.
  • Workshop 3:How to block URLs
  • Workshop 4:How to allow users to sign-in only to specific G Suite domains.
  • Workshop 5:How to force install Android apps in Google Play Store
  How to manage Chrome Devices
  • Workshop 6: How to disable guest mode and restrict sign-in to a list of users.
  How to manage Managed guest session and kiosk settings
  • Workshop 7: How to set up your Chromebook as a Public PC
  • Workshop 8: How to use Chromebook for student assessments using a single Kiosk app
  • Workshop 9: How to create Digital Signage System for In-house Promotion
Workshop 10: How to set locked mode for quizzes
 
I'm a Google Certified Chrome Expert who is committed to teaching, consulting, and selling G Suite for Business, Chrome Device Management licenses, and G Suite for Education. Based on my experience, I've updated this book to make it possible for many businesses and schools to use Chromebook in the future.



Amazon Published -  https://amzn.to/39vGDXM


Aug 17, 2022

How to reduce ransomware damage in Google Workspace

How to reduce ransomware damage in Google Workspace

Index
  • Ransomware infection path and severity 2
  • Typical prescriptions from Ransomware solution providers 2
  • Using Google Workpsace for Ransomware Prevention 4
How to set up the Google Workpsace administrator to prevent Ransomware damage in the enterprise 5
What the Google Workspace administrator should do 5
First, how to control attachments received by email in organizational and individual units (administrators) 5
Second, Google Drive  Sync app usage control (admin) 9
Third, Google Workspace Business Team Drive Authorization Control (Administrator) 11
What the normal user should do 14
Back up my computer with the new Google Drive Backup & Sync app 14
How to use the new Google Drive backup and sync app 15

  • How to restore the previous version when you delete or change the original file 16
  • What to do if the Google Worksace user is infected with Ransomware 19

Ransomware infection route and severity

Ransomware has been infected by opening e-mail attachments or visiting suspicious websites. However, it is known that it is infected even if only Internet connection is used by using security weakness of MS Windows OS recently.

According to the security industry, the main culprit is the "WannaCry," which began circulating around Europe on December 12 (local time). Warner Cry is a variant of Ransomware known as WannaCrypt, which infects computers by exploiting security vulnerabilities in Microsoft's Windows operating system.

Key files in the infected computer are encrypted and can no longer be opened by the user. The attacker requires $ 300 as a condition for passing the encryption key and doubles the price if he does not pay the ransom within three days. The attacker threatens to permanently delete the encrypted file if he does not pay the ransom for seven days.

WarnerCry was able to spread around the globe in the first place because it would automatically be infected by running email attachments or visiting certain Web sites, unlike traditional Ransomware, even if they were only connected to the Internet. WarnerCry also has a worm feature that uses Windows Server Msessage Block (SMB), a file-sharing network feature of Windows, to infect not only that computer but also other computers connected to the network.

Because of this situation, there is no way to avoid infection with Ransomware, so its severity is higher than expected.

Typical prescriptions from Ransomware solution providers

A security vendor supplying a vaccine does not offer a specific solution for files already infected with Ransomware (files encrypted by Ransomware). However, in order to minimize infection in advance, four guidelines are suggested.

  • Spamming Email Attention
  • Back up important files
  • Set "Read Only" for important documents
  • Maintain the latest security patch of MS Windows OS

In other words, the point of this rule is that one of the Ransomware infection route is received through e-mail, and if you get infected, you should make the original backup to the safe store so that you can restore the original.  

Security solution vendors are pushing the introduction of a spam processing e-mail system that prevents spam in addition to existing e-mail systems. Storage or backup solution vendors are promoting the need for backup devices to back up important files.

It is an important document, but it is not uncomfortable to set it as 'read only' as it should be edited frequently. In some cases, document management solution providers may encourage the introduction of expensive document management systems that can be centrally controlled, while important documents are managed with appropriate security regulations.

MS Windows OS security patches are made from time to time. However, since malware hackers who create Ransomware are always exploiting Windows OS vulnerabilities, OS security patches are not a fundamental solution.

Full Content Download - PDF




[What is the Macro Feature in Google Spreadsheets?] Automating tasks with Macro Feature

In fact, it is doubtful how many users of Excel are using the macro function properly (there are many users who do not know what macro function actually is) I had a question about whether I had it.

I am pleased to inform you that Google has finally begun offering macros in Google Sheets.

In Google Help, "Automate tasks in Google Sheets, You can save time by automating repetitive tasks with macros." .

https://support.google.com/docs/answer/7665004?co=GENIE.Platform%3DDesktop&hl=en

As mentioned in this help, taking advantage of the macro features is very useful if you need to work over and over again. In other words, you can automate the recording of a single task (macro recording), and then reuse the recorded function in the next iteration. Macro recording automatically creates and saves the script program automatically from inside. You can modify this script later.

For example, if you need to have a Sales Report every quarter, and you apply the same job to the report sheet every quarter, you can simply use the macro to play back the macro recordings from the next quarter without repetition. See YouTube below ..




Differences between User and Device settings and Key settings for Chrome Enterprise Upgrade (CEU)

Key settings for Chrome Enterprise Upgrade (former, Chrome Device Management)


There are more than 400+ policies that can be set through Chrome Device Management. There are five categories of settings: User Settings, Network Settings, Device Settings, Managed Guest Session Settings, and Kiosk Settings.



There are Chromebooks available for you to install and use the Google Play Store. "Google Play Store settings" has been added to Chrome Device Management for these Chromebooks. Your domain’s administrator can enable Play Store and Android Apps to be managed through the Admin Console.

One of the key elements of Chrome Device Management is setting Chrome Device to Managed Guest Sessions, Kiosk Settings, and Single App Kiosk Mode.

Many users can share chrome Devices. For example, it can be used publicly, such as a business center PC, a PC for book searching in a bookstore or a library, or a public PC used by several production workers at a production factory for business purposes. Within Chrome Device Management, you can set this up as a public session in the Managed Guest session settings.
A single app Kiosk setting only allows you to run a single app that you specify, and this app will only work in full-screen mode. Other apps cannot run in this mode.

Typically, the most important of the administrative settings in a business or a school will be user settings and device settings. Public sessions and Kiosk mode settings are optional depending on your Chromebook usage. 

Differences between user and device settings

· User policies apply regardless of which devices are logged in
oTargeted users in the domain through the Admin Console.
oControl your Chrome browser environment
§ Allowed apps and extension controls
§ Force apps and extensions to install
§ Chrome Web Store Permission Limitations
§ Browser environment control - Incognito mode, history, ad hoc mode, safe browsing, malicious sites, remote access client allowed
§ Proxy settings
§ Control the use of screenshots, block and allow access URLs
§ Print control etc.
oOrganizations that use  Google Workspace or Google Workspace for Education users can manage policies in the Google Workspace Admin console.
oCompanies and schools that do not use Google Apps must acquire and manage Chrome Device Management Console licenses.
· Device policies are to control and manage devices regardless of who logs in.
oControl who can log in, how to update, etc.
oControl how users operate the device rather than what they use on the device
§ Device registration and access
§ Allow Guest Mode, Login Restrictions (Use only specified users), SSO,
§ Chrome OS auto-update control, distribution channel control
§ Manage kiosk settings
§ Device status reporting
§ Scheduled reboot
§ Cloud Print Management
§ Bluetooth control
§ Stop using your device remotely
oDevice policies can only be controlled through the Chrome Device Management console through Chrome device management licensing.
· Each policy is mutually exclusive. - There is no policy that conflicts with each other.

If you're using a Chromebook in a company or school that uses Google Workspace or Google Workspace for Education, you can manage your Chromebook users or set up your network without having to register your device. However, device management or opt-in settings, kiosk settings, device provision/deprovision, etc. are only available when you purchased the Chrome Device Management license.

Enterprises that use Chromebooks without Google Workspace will need the Chrome device management license to manage their Chromebooks and manage their users.

Settings
Google Workspace  Admin Console
Chrome device management console
User Settings
O
O
Network Settings
O
O
Device Settings
X
O
Public Settings
X
O
Kiosk Settings
X
O
Device Provision/Deprovision
X
O

For more details - https://amzn.to/37C9xEi 


Aug 12, 2022

[Chromebook Tip] How to set the screen locked mode up for Quizzes using Chromebooks

You can help keep students focused while they take quizzes and tests on their Chromebooks. When students take a quiz in locked mode, they won’t be able to browse other websites or open any other apps.

About locked mode

Locked mode collects email addresses and limits quizzes to only your domain. When in locked mode:
  • Students can’t use other apps. 
  • Some extensions and keyboard shortcuts are disabled.
  • If a student exits the quiz, or opens any other tab, the teacher is notified via email.

Important: To use locked mode, you need:

Turn on locked mode
  1. In Google Forms, open a quiz.
  2. At the top, click Settings > Quizzes.
  3. Check the box next to “Turn on locked mode.”


Accessibility features & extensions in locked mode

  • ChromeVox (text-to-speech)
  • High contrast mode
  • Fullscreen magnifier
  • Docked magnifier


Recommended Chrome extensions
From Don Johnston:
  • Quizbot: An automatic quiz creator for Forms (for teachers).
  • Snap&Read: A text reader that can translate, clarify, and organize ideas. 
  • Co:Writer: A writing help tool with word prediction, speech recognition, and translation.
To learn more about these tools, visit the Don Johnston site.[3]
From Texthelp:
  • EquatIO: Converts your input into mathematical equations, formulas, and more.
  • Read&Write for Google Chrome: Converts text to speech and speech to text, with picture dictionaries, text prediction, and more.
Tip: If you can't find an accessibility feature, use accessibility shortcuts[4] instead.

More details about Chrome Devive Management - https://amzn.to/2SXN6Em


[1] Chromebook Help - http://bit.ly/2SbJfnM
[2] Chromebook Help - http://bit.ly/37hojA2
[3] http://bit.ly/38cTHRK
[4] Chromebook Help - http://bit.ly/38e6naN

Aug 10, 2022

What is Chrome Enterprise Upgrade (Chrome Device Management)?

How to manage Chrome Devices for Enterprise and Education. (CEU)

Companies have not had a positive view of Chromebook. In recent years, however, businesses have changed the perception of Chromebook. According to the IDC report, there are predictions that by 2018, 25% of Fortune 500 companies will use Chromebook.















One of the biggest features for Chromebook is that it has an affordable price (average $ 150 - $ 300). In addition, it features fast performance, fast booting, secure computers free from viruses and malware, easy-to-manage computers, free office document editing tools, and MS Office compatibility tool. With the ability to run even millions of Android apps on the Google Play Store, Chromebook evolves into innovative computers that are capable of not only cloud-based online apps but also Android offline apps.

Google is launching a Chrome-based platform to strengthen its enterprise market. Google is driving the new paradigm of computers in the enterprise market as well as in the education market. That's why businesses and schools are starting to recognize Chromebook.

Chrome-based platforms launched by Google.     

First, Chrome  Enterprise and Education
    At the heart of this service is a combined platform of Chromebook hardware and Chrome Device Management Console software.
    Chromebook is also enhancing their business by getting solutions that can easily access Windows applications (Remote Desktop, Virtual Desktop, and Desktop as a Service).

Second, Chrome for Kiosk
   Anyone in a public place can use a PC for a low cost public use. It is a platform for Chrome OS devices to be used as a library's book search system and as a public PC in business centers and Internet cafes. In addition, schools can use Chromebook as a device for students to take exams.
    When a Kiosk app launches, any other application cannot be run, and only a single Kiosk app registered by an administrator is allowed to run in full-screen mode. This single Kiosk app can be managed through the Chrome Device Management console.
    Anyone can easily build and deploy Kiosk apps to the Chrome Web Store
 
Third, Chrome for Signage
    We have been flooding around with all kinds of digital displays. It is a platform that enables these digital displays to be published remotely at the desired time of day.
    You can install and manage Signage apps through the Chrome Device Management console.
    Chromebit, a stick-type PC, has been launched and is now making its way into the signage market.

Fourth, Chromebox for Meeting
    It is Google Hangout based video conferencing solution.
    Chromebox, high-definition Video Webcam, Speakerphone and so on, it enables companies to build video conferencing systems at low cost.
    To use this product, a separate service license ($ 250 per year / per device) is necessary.

Fifth, Chromebook that support Android apps on the Google Play Store
    You can now install and run Android apps on the Google Play Store on your Chromebook.
    Chromebook is now available in a variety of online and offline apps.

The Chrome Device Management console is a great feature that makes it easy to remotely manage Chromebooks from businesses and schools.

When a company or school distributes computers to its employees or students, it requires the cost and staffing of user preferences, software, OS updates, security software updates, and replacement or repair for other computers in the event of a malfunction.  

Chromebook is easy to manage remotely through the Chrome Device Management console. Administrator can manage all of their environments, software to be installed, automatic OS updates, and the ability to use the Internet only on a controlled network.

If a Chromebook is lost during a business trip or if it is stolen in a cafe, the administrator can remotely disable the device directly and the device will be immediately logged out and no longer available. If a lost Chromebook is retrieved, the administrator can make it available immediately by changing the device to reuse.

To efficiently manage the many Chromebooks distributed to your employees or students in your company or school, Chrome Device Management console is necessary. The Chrome device management console allows you to define and set up more than 150 policies. It's more complicated than it sounds, and it takes a lot of time and effort to figure it out and use it efficiently. In this book, you can easily learn important things from the functions of Chrome device management through various workshops.



Workshop 1-How to enable Chromebook only on your corporate or school network

Workshop 2-How to set up your Chromebook as a public computer

Workshop 3-How to use Chromebook for student assessments using a single Koisk app

Workshop 4-How to create Digital Signage System for In-house Promotion


It also includes essential guides for Chromebook beginners and advanced users. In this book, the author explains the new and updated functions and information recently. 

Key policy settings for Chrome Device Management
If you're using a Chromebook in a company or school that uses Google Workspace/ Google Workspace for Education, you may be confused by the difference between user settings and Chromebook device settings.

User settings can be set through admin console of Google Workspace / Google Workspace for Education. However, Chrome Device Management console is required for Chromebook device-specific settings. I will explain the differences in detail.

There are more than 400 policies that can be set through Chrome Device Management. The settings can be broadly categorized into five categories - User Settings, Network Settings, Device Settings, Public Session Settings, and Kiosk Settings.

One important aspect of setting up Chrome devices is setting Chrome devices to Public Session, Kiosk Settings, and Single App Kiosk Mode.
For example, if you are using a Chrome device for multiple users, a business center PC, a PC for book searching in a bookstore or library, or a public PC used by several production workers in a production plant for business purposes, Device management is setting this as a public session. You can use your PC without a login in a public session.
A single app kiosk setting lets you run only a single specified app, which only works in full-screen mode. Other apps, including things like regular Internet search, will not be available.
Typically, the most important of the administrative settings in a business or school will be user settings and device settings. Public session and kiosk mode settings are optional depending on your Chromebook usage.


Differences between user and device settings


  • User policies apply regardless of which devices are logged in
    • Targeted users in the domain through the Admin Console.
    • Control your Chrome browser environment
      • Allowed apps and extension controls
      • Force apps and extensions to install
      • Chrome Web Store Permission Limitations
      • Browser environment control - Incognito mode, history, ad hoc mode, safe browsing, malicious sites, remote access client allowed
      • Proxy settings
      • Control the use of screenshots, block and allow access URLs
      • Print control etc.
    •  Organizations that use Google Workspace or Google Workspace for Education users can manage policies in the Google Workspace Admin console.
    • Companies and schools that do not use Google Apps must acquire and manage Chrome Device Management Console licenses..
  • Device policies are to control and manage devices regardless of who logs in.
    • Control who can log in, how to update, etc.
    • Control how users operate the device rather than what they use on the device


● Device registration and access
● Allow Guest Mode, Login Restrictions (Use only specified users), SSO,
● Chrome OS auto-update control, distribution channel control
● Manage kiosk settings
● Device status reporting
● Scheduled reboot
● Cloud Print Management
● Bluetooth control
● Stop using your device remotely
  •       Device policies can only be controlled through the Chrome Device Management console through Chrome device management licensing.
        Each policy is mutually exclusive. - There is no policy that conflicts with each other.
If you're using Chromebooks in a company or a school that uses Google Workspace or Google Workspace for Educations, you can manage Chromebook's users and set up network without having to register your device. However, device management or opt-in settings, kiosk settings, device provisioning /deprovisioning, etc. are only available if you have a Chrome Device Management license.
Companies that use Chromebooks without Google Workspace will need a Chrome device management license to manage their Chromebooks and manage their users.


Management topics
G Suit /GSuite for Education Admin Console
Chrome device management console
User Settings
O
O
Network Settings
O
O
Device Settings
X
O
Public Settings
X
O
Kiosk Settings
X
O
Device Provision/Deprovision
X
O




For More information - https://amzn.to/38V80KU  Kindle Store - Paperback/Kindle Edition



-----------