In the face of Excel and Google Docs, we are still innovating. We can't hack it, but we can cut off one of its toes first.

Source: Internet
Author: User

The first name is "killing excel". Later I thought that we should keep a low profile and name it "we are still innovating in the face of Excel and Google Docs ".

Chrome subverts ie;

IPhone revolutionizes Microsoft Windows Mobile and Nokia Saipan;

Chrome book subverts windows;

Bully Microsoft xiaoice chatbots;

Prezi subverts PPT;

We use Excel.


We can't hack it, but we can cut off one of its toes first.


Excel has dominated the world for 20 years. This Excel file is a perfect data management software. Excel is used, and CRM, OA, HR, PM, and ERP are not required. Because it is too successful, you cannot subvert yourself; because it is too successful, so wait for death.


We are a super table and strive to become a common data management tool, replacing the general features of Excel, CRM, OA, HR, PM and ERP.


This article does not give a comprehensive overview of the positioning, market strategy, strategic intent, and functional roadmap of the Super table. Instead, it gives us a glimpse of our many innovations.


I. How to insert an attachment in a cell

First, let's take a look at how Excel inserts files into a table.

After a file is inserted into an Excel table, the file belongs to the entire Excel table and does not belong to a cell. For example, the "logo" column in the list of competing products does not belong to the "logo" column of "product. You can place the inserted image near the specific cell in the column of this row. Images can be moved at will. Once moved, it is difficult to determine which product the image belongs.



In addition to images, if you want to insert a Word document or other files, the same problem will occur and will be displayed in a large area of the entire file content. Although you can reduce the image size, you still cannot fix the file in a cell.

Super table solves this problem.

On the homepage, confirm the "logo" column as "image" type:


Then we can see that the icon for uploading images is added to the corresponding cell:



After the image is uploaded, the image is displayed in this cell:



Okay. Which of the following is better than Excel and super table?


The core innovation is that the super table innovation designs the characteristics of input files in the cells of the table. In addition to images, what if the inserted file is a Word document? See:


Click the preview icon next to the file name to view the document content:



Don't copy us. We have applied for a patent. If you must copy the file, go to Turkmenistan or Oman islands. Super forms are too late to apply for patents from many countries. Don't think about the United States either.


2. Gantt chart table Innovation

Create a Gantt chart table based on the Web. Can I create a Gantt chart in an Excel table? Yes! But, will you? How hard is it to find an Excel worksheet that can make Gantt charts?

First, let's preview the Gantt chart of a project I made before I went to Beijing to recruit a team in the last two weeks:




There are at least 10 innovations here:

1. View

The concept of "View" is hard to understand. As a product manager, I cannot find a better term. You can create multiple views for each table. For example, I have an order table and I have created three views:

* View 1: Small sheets of orders

* View 2: only show the order combination and date

* View 3: orders sold by sales personnel

Based on the view name, do you understand the meaning of "view? A view is a part of a table. Each view has its own grouping basis, sorting fields, and filtering conditions.


Taking the "Beijing trip" project table as an example, I open the table and group it by "task category" (actually location), and then sort it by start date, then I got the desired effect, saved it as a view, named "sort by date", and set it as the default view. For example:



2. Group

You can select to group by any column. After grouping, the same rows are arranged together. In the following example, the group is grouped by Task Type, where the group "Beijing" is collapsed:


If you select "Start Date" as the group basis, the effect will be changed:



3. display only the tasks of an executor

If there are multiple executors in a project, click a executor in the Gantt chart, and then the Gantt chart displays only the tasks of the executor. Click again to display the tasks of all executors.



I suddenly thought I could write it again. Too worker.

4,

5,

6,

7,

8,

9,

10,

Feel it for yourself.

Anyone can make plans, and anyone can make beautiful Gantt charts.

Imagine that if a leader or customer asks you to create a project schedule, you may not hesitate to use Excel to make a schedule. But professional? I'm not sure. However, if you create a "project table" in a super table and enter the task breakdown information in a fixed format (you can also add columns at will, A beautiful Project Schedule came out. You can also export the project scheduler Gantt Chart to an Excel file. See the results:



Well written. If you don't want to write it, we will make a recruitment advertisement by the way. We are recruiting "associates", one for each of the market, development, and products. See http://www.domypp.com/index.php/Project/viewContent/id/101/sharekey/lWqjmgCi for details

For more information about the products and companies, visit www.domypp.com.

Currently, the registration is free of charge and is available online. You do not need to download anything.


(End)

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.