Skip to main content

Posts

Showing posts with the label g suite

[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...

[Test for Chromebook Auto Update Expiration (AUE) if it is working or not]

I have read an article saying that a Chromebook may have an auto-update validity period, and I ran the following tests to verify it: The official Google Help Center mentions that automatic update expiration dates are set for Chromebooks (ChromeOS devices). In fact, I tested with a Chromebook that expired the auto-update  (Acer Chromebook 11 C720P, a device whose auto-update expired in June 2019). The expiration date for automatic updates for each device on your Chromebook is mentioned in the Google Official Help Center below. I tried to update today the Acer Chromebook 11 C720P model, which appears to have expired in June 2019. We have confirmed that today's date is updated to the most recent version. Just like the attached capture image "This is the last automatic software and security update for this Chromebook.To get future update, upgrade to a newer model ' In fact, the Chromebook device-specific auto-update expiration mentioned in the Google Help Center ...

[What is Team Drive?] for G Suite Business and G Suite for Education (White Paper)

Finaly. Google announced Team Drives officially for G Suite Business and G Suite for Education at Next 2017. Here is the more detail information on what the Team Drive is and how to use. Team Drive  White Paper What is Team Drive? G Suite Business/G Suite for Education Background G Suite Business (Unlimited) and G Suite for Education is a new addition to Google Drive. It's a new addition to complement the functionality you need to team-collaborate on your existing Google Drive.    Note: This white paper was completed in December 2016. I have been selected as a beta tester by Google's Early Adopter Program and are based on tests that are only allowed on a domain. It is currently in beta. Google's full release is scheduled for early 2017. The information below is subject to change in the official release version Constraints on Google Drive   If the owner of the document or files in the shared folder retires and the administrator deletes t...

Compare core Google+ and G Suite Google+ features

Google+ has features for end users and  for business G Suite versions. Let's review the differences between Google+ for end users and Google+ for G Suite. Compare core and business features Google+ includes business features in addition to the same core functionality as the consumer version of Google+ for G Suite customers. With Google+, you can restrict Google+ to only certain users, control whether you share data with users outside your domain, and manage your social collaborations in a variety of ways. .G Suite Administrators can perform the following functions: Turn Google+ on or off for everyone or for a specific user. By default, keep your posts and communities outside of your organization's domain. Correct the age of the user who mistakenly entered it incorrectly when signing up. Controls whether search engines index user profiles. Control whether third-party apps use the Google+ API. Manage your Google+ profile. For example: Identify who...

[Maximum file size of one file that can be stored in Google Drive]

G Suite users are often confused. What is the maximum size of attachments that you can currently send through Gmail? As you already know, attachments in gmail can only be sent up to 25MB. However, it can be confusing if the size of the file you can send to a URL link via Google Drive is 10GB, 1TB, or 5TB. In Gmail, the maximum size of a file you can send as an attachment is 25 MB. However, if you want to send files over 25MB in size, you can use Google Drive to save the file and send the file as a URL link. At this time, the maximum size of one file that can be sent as URL link can be up to 5TB. (In the past, 10GB, 1TB, now up to 5TB) In other words, the maximum size of a file that can be stored in Google Drive is 5TB. The maximum file size limitation of G Suite Basic, G Suite Business (Unlimited) and G Suite for Education are the same. For more information -  https://support.google.com/drive/answer/37603?hl=en --------- New Book- Advanced Chrome Device Management ...

[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...

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...