Tutorial 1
|
|
|
|
|
|
|
|
|
|
Tutorial 1 - Creating your first EditGrid spreadsheet
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Practice Area
|
|
Hints
|
|
|
|
|
|
|
Open an existing spreadsheet
|
|
Notice the yellow bar
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
1. Enter the name of spreadsheet
|
|
|
|
|
|
|
|
|
2. Set Permission as "Private", "Public Read-only" or "Public Read and Write"
|
|
|
|
|
|
|
|
|
3. Choose your spreadsheet type as "Spreadsheets" or "Template"
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Save your spreadsheet
|
|
Click the "Save" button on the yellow bar
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Create a new spreadsheet
|
|
Menu Bar > File > New
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Make a copy of a spreadsheet
|
|
Type ".copy" after the spreadsheet URL, for example, you can copy this tutorial to your own workspace by:
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Import a spreadsheet
|
|
Menu Bar > File > New
|
|
|
|
|
|
|
|
|
EditGrid supports mainstream spreadsheet formats such as MS Excel, OpenDocument, Gnumeric, OpenOffice 1.x, Lotus 1-2-3 and CSV.
|
|
|
|
|
|
Tutorial 2
|
|
|
|
|
|
|
|
|
|
|
|
|
Tutorial 2 - Spice up your spreadsheet
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Text Formatting and Alignment
|
|
|
Practice Area
|
|
|
Hints
|
|
|
|
|
|
Text Formatting
|
|
|
Text Formatting
|
|
|
|
|
|
|
|
|
Bold
|
ABC
|
|
Bold
|
ABC
|
|
Use the following toolbar or hot keys:
|
|
|
|
|
|
Italics
|
ABC
|
|
Italics
|
ABC
|
|
|
|
|
|
|
|
Underline
|
ABC
|
|
Underline
|
ABC
|
|
|
|
|
|
|
|
Strike
|
ABC
|
|
Strike
|
ABC
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Bold
|
<Ctrl+B>
|
|
|
|
|
Text Alignment
|
|
|
Text Alignment
|
|
|
Italics
|
<Ctrl+I>
|
|
|
|
|
Left
|
ABC
|
|
Left
|
ABC
|
|
Underline
|
<Ctrl+U>
|
|
|
|
|
Center
|
ABC
|
|
Center
|
ABC
|
|
Strike
|
<Ctrl+S>
|
|
|
|
|
Right
|
ABC
|
|
Right
|
ABC
|
|
Left
|
<Ctrl+L>
|
|
|
|
|
|
|
|
|
|
|
Center
|
<Ctrl+E>
|
|
|
|
|
More ...
|
|
|
More ...
|
|
|
Right
|
<Ctrl+R>
|
|
|
|
|
Arial, font size 14 pt
|
Umbrella
|
|
Arial, font size 14 pt
|
Umbrella
|
|
|
|
|
|
|
|
Times New Roman, font size 8 pt
|
Umbrella
|
|
Times New Roman, font size 8 pt
|
Umbrella
|
|
|
|
|
|
|
|
Century Gothic, font size 12 pt
|
Umbrella
|
|
Century Gothic, font size 12 pt
|
Umbrella
|
|
|
|
|
|
|
|
Change Font Color to Red
|
Red
|
|
Change Font Color to Red
|
Red
|
|
Font Color/Cell Background
|
Format > Font Color
|
|
|
|
|
Change Font Color to Blue
|
Blue
|
|
Change Font Color to Blue
|
Blue
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Number Formatting
|
|
|
Practice Area
|
|
|
Hints
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Add a US dollar sign
|
$100.00
|
|
Add a US dollar sign
|
100
|
|
Menu Bar > Format > Number Formatting <Ctrl+1>
|
|
|
|
|
|
Add a Chinese Yuan sign
|
Ұ100.00
|
|
Add a Chinese Yuan sign
|
100
|
|
The Number Format dialog box will pop up, as follows:
|
|
|
|
|
|
To 2 decimal places
|
123.46
|
|
To 2 decimal places
|
123.45678
|
|
|
|
|
|
|
|
To 4 decimal places
|
12.3457
|
|
To 4 decimal places
|
123.45678
|
|
|
|
|
|
|
|
Do not use 1000 Separator(,)
|
1000
|
|
Do not use 1000 Separator(,)
|
1000
|
|
|
|
|
|
|
|
Use 1000 Separator
|
1,000
|
|
Use 1000 Separator
|
1000
|
|
|
|
|
|
|
|
Set the date format to d/m/yyyy
|
31/3/2007
|
|
Set the date format to d/m/yyyy
|
31/3/2007
|
|
|
|
|
|
|
Tutorial 3
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Tutorial 3 - Give your spreadsheet a more professional look : Table, Chart and Formula
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Table Formatting
|
|
|
|
|
|
Practice Area
|
|
|
|
|
|
Hints
|
|
Set Borders
|
|
|
|
|
|
Set Borders
|
|
|
|
|
|
Use
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Table A
|
|
|
|
|
|
Table A
|
|
|
|
|
|
|
|
Fruit
|
Quantity
|
|
|
|
|
Fruit
|
Quantity
|
|
|
|
|
|
|
Banana
|
5
|
|
|
|
|
Banana
|
5
|
|
|
|
|
|
|
Apple
|
10
|
|
|
|
|
Apple
|
10
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Table B
|
|
|
|
|
|
Table B
|
|
|
|
|
|
|
|
Set background color
|
|
|
|
|
|
Set background colour
|
|
|
|
|
|
|
|
& borders
|
|
|
|
|
|
& borders
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Formulae
|
|
|
|
|
|
Practice Area
|
|
|
|
|
|
Hints
|
|
Add Formulae
|
|
|
|
|
|
Add Formulae
|
|
|
|
|
|
Menu bar > Insert > Functions
|
|
|
|
|
|
|
|
|
|
|
|
|
|
There are 60+ functions you can use
|
|
Asset Record of ABC company
|
|
|
|
|
|
Asset Record of ABC company
|
|
|
|
|
|
for creating formulae
|
|
Items
|
Unit Price
|
Quantity
|
Discount
|
Total
|
|
Items
|
Unit Price
|
Quantity
|
Discount
|
Total
|
|
|
|
Chair
|
$150
|
10
|
10%
|
$1,350
|
|
Chair
|
$150
|
10
|
10%
|
|
|
|
|
Table
|
$2,000
|
10
|
15%
|
$17,000
|
|
Table
|
$2,000
|
10
|
15%
|
|
|
|
|
TV set
|
$3,000
|
2
|
20%
|
$4,800
|
|
TV set
|
$3,000
|
2
|
20%
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Charts
|
|
|
|
|
|
Practice Area
|
|
|
|
|
|
Hints
|
|
Create a Pie Chart
|
|
|
|
|
|
Create a Pie Chart
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Use
|
|
Hong Kong Weather in July
|
|
|
|
|
|
Hong Kong Weather in July
|
|
|
|
|
|
or Insert > Chart
|
|
Drizzle
|
3
|
|
|
|
|
Drizzle
|
3
|
|
|
|
|
You can add a title in the chart by
|
|
Sunny
|
15
|
|
|
|
|
Sunny
|
15
|
|
|
|
|
right clicking on the chart, and then
|
|
Cloudy
|
8
|
|
|
|
|
Cloudy
|
8
|
|
|
|
|
choose "Edit Chart"
|
|
Thunderstorm
|
5
|
|
|
|
|
Thunderstorm
|
5
|
|
|
|
|
|
|
Total
|
31
|
|
|
|
|
Total
|
31
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Weather
|
Days
|
|
|
|
|
|
|
|
|
|
|
|
Tutorial 4
|
|
|
|
|
Tutorial 4 - Share your spreadsheet with others
|
|
|
|
|
|
|
|
Practice
|
|
Hints
|
|
Export this spreadsheet in xls format
|
|
File > Export As
|
|
|
|
or File > Permalinks, then choose the xls format
|
|
|
|
|
|
Share this spreadsheet with your friends
|
|
Share > Share with Others...
|
|
|
|
You can set the following permissions:
|
|
|
|
1. Share to the public
|
|
|
|
2. Share to EditGrid users
|
|
|
|
3. Share to email addresses
|
|
|
|
4. Share to users/workspaces within an organization
|
|
|
|
|
|
Publish this spreadsheet to web
|
|
Publish > Post to Blog/Webpage
|
|
|
|
You can choose to export :
|
|
|
|
- Dynamic HTML table inside an IFrame (Supported by most Blogging systems)
|
|
|
|
- Dynamic HTML table embeding to web page. (Javascript is required)
|
|
|
|
- Featured Mini-EditGrid inside an IFrame
|
Tutorial 5
|
|
|
|
|
|
|
Tutorial 5 - Audit your spreadsheet
|
|
|
|
|
|
|
|
|
|
|
|
Practice
|
|
Hints
|
|
|
|
Mark & add description for a revision:
|
|
File > Mark Revision
|
|
* a marked revision will be kept
|
|
|
|
A window asking you to add description for the revision will apprear:
|
|
permanently for you
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
View revision
|
|
File > View Revision
|
|
* you can view previous revisions
|
|
|
|
|
|
|
|
Roll back to previous version
|
|
File > View Revision > Roll back to this version
|
|
* roll back changes
|
|
|
|
|
|
|
|
See who edited a selected cell
|
|
Right Click on a cell > Properties
|
|
|
Tutorial 6
|
|
|
|
|
|
|
|
|
|
|
|
|
Tutorial 6 - Advanced Usage
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Remote Data
|
|
|
|
|
Practice Area
|
|
|
|
|
Hints
|
|
|
|
|
|
|
|
|
|
|
|
|
|
USA Market Stock Code
|
|
|