EditGrid Tutorial

Start

Tutorial 1 - Getting Started!

Creating, copying & importing spreadsheets
Creating a New Spreadsheet
Step 1.
Create at workspace:
Create at spreadsheet view:
Create by Permalink:
Workspace > Create New > New From Blank / Template Library...
Menu Bar >  File >  New /  Template Library... 
Key in the below Permalink in browser



Step 2.
i) Name your Spreadsheet
ii) Select access permission as "Private", "Public Read-only", or "Public Read and Write"
iii) Spreadsheet can be set as type "Spreadsheets", or "Templates".
Please note that you have to own an EditGrid account to save the spreadsheet. 
iv) Complete blank spreadsheet creation by clicking [ Save ] .
Note: You will be redirected to the User Login Page if you haven't logged in yet.
Copying from an existing EditGrid Spreadsheet
Copy at workspace:
Copy at spreadsheet view:
Copy by Permalink:
▼(triangle next to file name)> Properties> Save As
Menu Bar > File > Save As …
Key in ".copy" at the end of the chosen spreadsheet permalink
Importing an external spreadsheet file
Import at workspace:
Import at spreadsheet view:
Import via Permalink:
Workspace > Upload
Menu Bar >  File >  Import...
Key in the below Permalink as an alternative.



EditGrid supports import of MS Excel, OpenDocument, Gnumeric, OpenOffice, Lotus 1-2-3 and CSV.

Spreadsheets

Tutorial 2 - Basic Editing

Introduction of EditGrid toolbar; text, font, cell & number formatting
EditGrid toolbar
Hints
EditGrid toolbar offers buttons for cell, text, and number formatting.
Text, font, and cell format
Try
Hints
Text Format
Button
Hotkey
Example
Text Format
Bold
<Ctrl+B>
ABC
ABC
Use the EditGrid toolbar/ hotkeys
Italics
<Ctrl+I>
ABC
ABC
Underline
<Ctrl+U>
ABC
ABC
 
Strike
<Ctrl+S>
ABC
ABC
Text Alignment
Text Alignment
Left
<Ctrl+L>
ABC
ABC
Use the EditGrid toolbar/ hotkeys
Center
<Ctrl+E>
ABC
ABC
Right
ABC
ABC
Font Style
Font Style
Arial, font size 6 pt
 - 
 - 
ABC
ABC
Times New Roman, font size 8 pt
 - 
 - 
ABC
ABC
Century Gothic, font size 10 pt
 - 
 - 
ABC
ABC
Change Font Color to Red
 - 
ABC
ABC
Alternative: Menu Bar > Format > Font Color
Change Font Color to Blue
 - 
ABC
ABC
Cell Format
Cell Format
Background (Cell backround= Green)
 - 
ABC
ABC
Alternative: Menu Bar > Format > Font Color
Border (Border = Green)
 - 
ABC
ABC
Press [Advanced] in borders menu for more options
Word Wrap
 - 
ABC ABC ABC ABC
ABC ABC ABC ABC
Merge Cells
 - 
ABC ABC ABC ABC
ABC ABC ABC ABC
Select 2 or more cells and then click button
Number format
Try
Hints
Number Format
Button
Hotkey
Menu Bar
Choose a suitable category to perform format numbers
All Types
<Ctrl+1>
Format> Number Formatting
Number Format
Format Category
Example
Number Format
Add a US dollar sign
Accounting/Currency
$100.00
100
Add a Chinese Yuan sign
Accounting/Currency
Ұ100.00
100
To 2 decimal places
Number
123.46
123.45678
To 4 decimal places
Number
12.3457
123.45678
Do Not use 1000 Separator(,)
Number
1000
1,000
To Use 1000 Separator
Number
1,000
1000
Set the date format to d/m/yyyy
Date
3/31/07
3/31/07
Formulas & Functions
Method
Example
Quick Sum
 - 
100
100
Key in formula
Start cell content with ' = '
"=average(H47:J47)""
100
100
Insert function
Menu bar > Insert > Functions...
 - 
100
100
100

Charts

Tutorial 3 - Charts & Chart Mashups

Creating EditGrid Charts
Examples
Example: Pie Chart
Using EditGrid Charts
Using EditGrid's Google Chart Mashup
Hong Kong Weather in July
Drizzle
3
Sunny
15
Cloudy
8
Thunderstorm
5
Total
31
Creating EditGrid Charts
Google Chart Creation
Button
Menu Bar
Choose the range of cells you want to plot
Menu bar> Insert> Chart...
Chart Editing
Hints


1. Right click on the created chart

2. Manage chart properties

3. Click [Apply] to preview

4. Click [Ok]
Creating Charts with EditGrid's Google Chart Mashup
Google Chart Creation
Button
Menu Bar
Formula
Assign and highlight the cell for Google chart display
Menu bar> Insert> Mashup...
=Googlechart(type,data,[,options])
When inserting Google Chart
Hints



1. Choose "Google Charts" option

2. Click [Insert]
View the Mashup form (Menu bar> Insert> Mashup) for more formula details about Google Chart Creation
Try