Dec 27, 2016

[TIP] How to use Google Spreadsheet for collaboration


Guide to Collaborative Editing With Google Spreadsheet

2016/12/27 by Charly Choi


I would like to introduce some of the essential things you need to know to collaborate with your team through Google Spreadsheet.


Sometimes you need to collaborate using Excel documents. There are too many limitations when trying to collaborate with team members using Excel or Excel Online in MS Office 365. MS Excel may not be suitable for collaborative document work with Excel documents.

Google Spreadsheet has important features for collaborating with team members. Understanding these features will enable you to maximize your work efficiency through collaboration among your team members.

Here is a good Business Case.

  • I am the sales manager with 5 members.
  • Share my Sales Report  with my members  and have them write their sales reports.
  • Some of the members are not familiar with spreadsheets. They can spoil things by not entering them well.
  • I should check all the records that members have edited or typed.
  • If someone in your group modifies or changes a sheet, I'll automatically be notified.
  • Members can edit or type in everything on the sheet, but some important data can only be viewed and can not be modified.
  • Some of the members can only view the sheet contents, can not be modified, and some sheets in the spreadsheet with sensitive information should not be visible to the members.
  • On the sheet, photos taken on the field should also be saved so that they can be shared among the members.
  • Once the Sales Report is complete, it should be posted on the Company's internal site as a graph chart so that it can be viewed by all employees.

    Protected Sheet and Range

If you need to collaborate with your team on a sheet you've created, you'll need to give them permission to edit. Spreadsheet documents may contain sensitive sheets or specific data that others should not tamper with. This data needs to be kept from being modified by other members.

Google Spreadsheet has a 'Protected Sheet and Range' feature. You can specify a range of cells for a particular sheet so that they can not modify this range.

 

 Hide Sheet

Some of your team members may not have permission to edit, but only view. Spreadsheets have sensitive sheets that the view authority can not see. Google Spreadsheet provides the ability to hide sheets. If you hide the selected sheet, users with view privileges will not be able to see the contents of that sheet.

hide sheet.gif

Data Validation


Collaborating members may accidentally enter data incorrectly. To prevent this, you can specify the allowable range of the input data, input only the specified list data, or input only the data of the specified date range. This prevents accidental input of unacceptable data. This feature is essential if you need to work collaboratively through collaborative editing.



Filter Views

In some cases, the members you are working on may need to arrange them in order for a particular column. When a member attempts to sort, the order of the data in the original is changed. To prevent this, you can sort the data of the desired column only by yourself without affecting the original data. In Google Spreadsheet, the Filter Views feature allows you to sort the columns you need only without affecting the original.

I recommend using the Filter Views feature if the members do not have any effect on the original data and each wants to sort and view the data.


Conditional formatting  


Members who share the sheet need to be able to view the data easily. Google Spreadsheet provides the ability to specify the background color for data (Cell, Row, Column) satisfying a certain condition through conditional formatting function.

Image Sharing

One of the most common features of collaborating with Spreadsheet documents is the ability to insert and share images on a sheet.

There are two ways to insert images into Google Spreadsheet.

1). You can upload images from your local PC via Menu -> Insert -> Image, or upload from Google Photo albums, Google Drive. However, you can not insert an image into a sheet cell.


image insert.gif

2). You can use Function - image () to insert an image into a specific cell. This way, you can insert an image into the cell. However, you can not upload images from my local PC, but only images that are public on the web

Notification Rules

Members who share a sheet can automatically receive notifications when they edit or enter data. Spreadsheet provides the ability to specify 'Notification rules'. You can use this feature to specify a notification rule.


Comments


You can communicate through comments in Spreadsheet between members who are co-editing. You can send 'comments' to members by specifying a specific cell. Members who receive comments can reply.

Chart Publishing


You can create a chart on the sheet or by using the ‘Explorer’ (bottom right of the sheet) function. Once the chart is created, you can publish it to the web or to your site. Charts published on the web will automatically change the charts published on the web when the data in the sheet source changes.




--------------------

Advanced Chrome Device Management & 2017 Essential Guide for Chromebook Users: by Charly Choi

Amazon Kindle Store - https://goo.gl/ari79C

Dec 25, 2016

Working with AutoCAD (DWG / DXF) files on your Chromebook


Introducing AutoDesk ™ A360 Viewer



a360 viewer .png

AutoCAD is developed and marketed by AutoDesk ™ as CAD-specific software for 2D /3D design and drafting.

It also uses the DXF format for interoperability in industry standard formats.

S / W for AutoCAD is mostly run on high-end computers (MS or Mac based). In the meantime, Chromebooks have no way to view these high-demanding DWG / DXF CAD formats.

AutoDesk provides a Cloud-based A360 Viewer service for AutoCAD. For Personal is free (use one project for the file, 5GB storage provided). For business use (unlimited use of files, 10GB storage, user management control functions for files).

This A360 Viewer app can be installed on your Chromebook in the Chrome Web Store.

a360.png

Simply create a user account on A360.autodesk.com and run the A360 viewer on your Chromebook.

The A360 Viewer supports Google Drive, so you can open your AutoCAD files by accessing your Google Drive directly from the A360 site without having to download DWG / DXF files to local storage.



a360 upload.png



Introducing Android app DWG Fast Viewer

dwg-fast-viewer.png


Free Android app that opens local DWG files for quick viewing. (Chrome OS version 53+ Chromebooks with Play Store support).

dwg-fast-viewer-1.png


-------------------

Advanced Chrome Device Management & 2017 Essential Guide for Chromebook Users: by Charly Choi

Amazon Kindle Store - https://goo.gl/ari79C

Dec 23, 2016

Unboxing Chromebit for Digital Signage

A set of 3 ChromeOS devices (Chromebook, Chromebox, Chromebit) I am using.
In the meantime, I was  useing Chromebooks and Chromeboxes based on Chrome OS, but recently I bought a Chromebit that was released by Asus.

The purpose of this Chromebit purchase is to compare how much better the Chromebook and Chromebox compared to the Chromebit, but the main purpose is to register as a Chrome Device Management Console device and review whether it is good for the ChromeOS Kiosk and Digital Signage.

I think that the Chromebit size (about the size of the thumb) and the price ($ 85) would have a positive ratio and would be a signage kiosk device. After this release, Chrome OS and Kiosk apps will be linked to the second installment.

Thumb-sized ChromeOS devices - 2GB Ram, 16GB storage, WiFi 802.11ac, Bluetooth 4.0, 1 USB 2.0 port, HDMI port, price $ 85

As an option, I bought a Logitech wireless keyboard (wireless dongle + keyboard + touchpad) for $ 25 and a set of Chrome OS devices.




Box components are very simple - power cord, sticker to monitor, chrome comb body, HDMI extension cable.


Plug-in the Logitech keyboard wireless dongle into the USB 1 port terminal, plug in the power cord, and plug it into the monitor's HDMI port to boot up immediately

YouTube launch screen

After signing in with an existing G Suite account, we found that it performs significantly better than writing Gmail and Drive documents.

--------------------
Kindle Edition-Paperback/eBook -
"Advanced Chrome Device Management & 2017 Essential Guide for Chromebook Users"




Dec 18, 2016

[Google Translate App vs. MS Translate App] Simple comparison of voice recognition rate and translator quality

Microsoft has released the MS Translate app. It is said that 60 languages are supported.

It can be installed for both Android and iOS apps.


I am interested in machine translation nowadays, so I installed it on my Android phone (Nexus 6P-Android 7.1.1 beta) to compare some core with Google Translator. (Korean to English)

Of course, the winner is the Google Translator. I know you can watch the video below.


Dec 15, 2016

[Googe Cast for Education] Share Screen without any H / W device using only Chromebook

Google Cast for Education is a free Chrome app that allows students and teachers to share their screens wirelessly from anywhere in the classroom. Cast for Education carries video and audio across complex school networks, has built-in controls for teachers, and works seamlessly with Google Classroom.
The Cast for Education app runs on the teacher’s computer that’s connected to the classroom projector, and it doesn't require new hardware. Teachers receive casts through the Cast for Education app, and students share their screens using the latest version of the Cast feature in Chrome.



An app that allows you to freely share your screen among Chrome users within the same domain, without the need for a separate device like Chrome Cast.

In particular, active classroom interaction between teachers and students has become possible in the classroom where students have one Chromebook per school. Teacher <-> students, students <-> Students can share the screen and the class can proceed.

Click here to install 'Google Cast for Education' in Chrome Web Store.

Chromecast app launch screen on your Chromebook. My cast name is 'CharlyChoi-Teacher'.


If you click on 'Chrome Browser -> Cast' you want to share, you will see a list of all devices that Chrome Cast app will register and launch (devices connected to WiFi AP in the same domain)










Teacher 'Charly Choi-Teacher' Chooses the name of the chrome cast.








More Help - https://support.google.com/edu/castforedu/?hl=en
--------------

Advanced Chrome Device Management & 2017 Essential Guide for Chromebook Users: by Charly Choi

Amazon Kindle Store - https://goo.gl/ari79C


Dec 9, 2016

How to use Google Translator Talk with Amazon Alexa in Korean (video)

Amazon Alexa is an American-born AI secretary. To use in Korea, you have to take various inconveniences. First, you need to create an account on Amazon, and in order to activate Alexa app, you have to be connected from USA region. After completing this difficulty, all commands must be in English and of course I have to answer in English.

However, with Google's mobile translator app, you can communicate almost in real time in Korean, even if you do not speak English. I experimented with this.



Please try your own language with Amazon Alexa using Google Translate.

[Action for Resigner in GSuite ] Seven actions to keep data security after employee leaves (recommended)

G Suite administrators secure your organization's data by following these recommendations when your employees leave the company:


  1. Reset all mobile devices - The G Suite administrator can remotely delete data from user devices leaving the management console. You can remotely wipe the entire device or just delete G Suite data.
  2. Delete password recovery access - Remove your recovery email address and recovery phone number so that you can not use password recovery.
  3. Change user password - Reset the password of the user who has left the company. This can significantly reduce the risk of unauthorized access.
  4. Cancel all OAuth 2.0 application tokens - G Suite To increase the security of your account, changing your user password cancels OAuth 2.0 tokens issued to access certain products. Review all approved accesses and cancel other approved applications.
  5. G Suite access blocked - Secure your G Suite account by resetting your signed-in cookies for outgoing users. This can significantly reduce the risk of unauthorized access to G Suite.
  6. Revoke Security Key and Cancel App Password Access - Manage your security settings to enhance 2-step verification and password stability. Revoke any security keys or application-specific passwords to which you have been granted access to your exiting user account.
  7. Delete a user's account - Secure your Google Cloud account by migrating all of your data and deleting your account. The exited user will not be able to access your organization's data.

[G Suite Team Drive Full Features] Tested by EAP (Early Adopter Program)

I was selected for Google's Team Drive's Early Adopter Program (EAP). I would like to introduce Team Drive, a new service for G Suite Business.

This is primarily the result of testing for important functions.

  1. .Add Team Folder Concept - Anyone can create and share Team Folders on team drives that the administrator allows

YouTube video - https://goo.gl/SSlp4r


 2. Team folder can be controlled by folder creator. - Member management (add / delete member), modify / delete permission management


3. Give team folders permission management through Google Groups
           - Automatically display team drives of added members when adding members to groups
           - Automatically removed team drives when leaving group members

4. Each individual ownership concept of all documents created by the members of the team folder is removed.
          - Only the person who created the team folder is displayed. 


4. Only the creator of the team folder has the right to delete.
           
5. Prevention of 'orphaned files' from previous Google Drive. In other words, when the user who shared the files and folders created by the owner is moved to another folder or deleted at will, the side effects such as the disappearance of the original owner's files or folders are prevented

6. Members of Team Folders do not allow random deletion of files or folders within Team Folders

7. If the user who created the team folder and created the file leaves the company (if the account is deleted), all the generated files are retained in the team drive.

8. Recycle Bin is managed separately for each team folder created in Team Drive.


9. Subfolders created on the team drive can not be authored separately on a subfolder basis, as in Google Drive.

10. Deleting a folder on a team drive can only be done by the person who created the team drive.

11. If the folder creator of the team drive grants share owners exclusive rights to delete without permission to delete
     - Sharers can upload, create and modify documents
     - Sharers can not delete or move documents

-----------------

Advanced Chrome Device Management & 2017 Essential Guide for Chromebook Users: by Charly Choi

Amazon Kindle Store - https://goo.gl/ari79C