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

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

[TIP: How to query in Natural Language (NLP) within Google Spreadsheets]

Introduced in the Google Cloud Next 2017, this feature allows you to Question/Answer in natural language within Google Spreadsheet.

In general, spreadsheet novices often do not know how to use a sheet or the functions Spreadsheet provide, so even if there is useful data in the sheet, it is often misaligned because of poor analysis.

If you take advantage of the Explore function in 'Spreadsheet' as shown below, you can create a good report.



This is a sample statement that can be queried in the Explore of a sheet.

1. What were the top item on 2017
2. How many unique countries
3. What percentage of Represent is '이영희'
5. Who is the top represent?
6. Top Sold Units for Rep of '홍길동'
7. How many sold items by '홍길동

-----------

Kindle Edition-Paperback/eBook -

"Advanced Chrome Device Management & 2017 Essential Guide for Chromebook Users"

' 

[Tip] Send an automatic email response message to Google Forms

One of the most needed features of the Google Forms was that the respondent completed the form and did not know whether the form was received well. When the questionnaire is answered, it is recommended that the response message prepared automatically is delivered.

After conducting an event at a company or school, you may want to ask the participants of the event to evaluate the results of the event. Most of them do not have many respondents. The best way to do this is to use the method of sending the presentation materials to respond to "Event Satisfaction" questionnaires for event attendees.

In the meantime, we needed to implement a separate Google Spreadsheet script program to implement the question-answering functionality.

This spreadsheet add-on allows you to easily realize automatic e-mail response. The user can freely create an email auto-response message and automatically send a ready-made email response message to the respondent when the questionnaire is received without any Script programming.

You can install and use a free add-on called 'form Mule' in the 'Add-ons' of your spreadsheet.

How to use the image in the order shown below, you can easily send an automated response message.

1.  Add email address to questionnaire item

2. Create a response spreadsheet

3. In the spreadsheet, search for 'form Mule' in 'Add-ons' and install.

4. Perform formMule on sheet and set up Auto Responder

5. 5. Select "Form Response 1' sheet  and set "Send on form submit' as 'On'

6. In the Email template section, select the Email item in the questionnaire.

7. Create an auto-reply email message

    (** To: If you click on the empty item and select the email address item on the right side of the questionnaire displayed on the right side, "<>" will be automatically entered.

8. 8. Finally, when respondents respond to the questionnaire, the following email message is automatically sent:

For more information, please refer to YouTube video below.

-----------

My Book - "

Advanced Chrome Device Management & 2017 Essential Guide for Chromebook Users: Chrome for Work/Chrome for Education/Chrome for Kiosk/Chrome for Signage Kindle Edition"

 

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

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

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.

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