Excel Tutorial: the basics

Spreadsheeting, Part 1:
Quick review for entering formulas and basic formatting.

• Note: on the video below, to ENLARGE the view, simply hit the button in the bottom right corner (left of the Screenr logo and right of the Volume/Speaker button).

• Or, view it here. Or, view it on Youtube.

---

Spreadsheeting, Part 2: 
Data manipulation and formatting.
(The last sentence ends abruptly at 5-minutes, so don't be concerned if it seems to be chopped off.)

• Link to above video (on Screenr), or view it on Youtube

---

Calculating the % of Increase (to measure improvement from Pre-Test to Post-Test). Piece of cake!

---

Spreadsheeting Part 3: 
Embedding your Data and Chart into a Blog post.

• Or view it on Screenr;  or on Youtube

---

1- Illustrations: Share and Publish as a web page

• 

2- Get a link to the published data -> select HTML to embed in a page

• 

3- Experiment with the frame width and height (as desired)

• The Default: width =500 may be too narrow. Try 800 or 900.
• The Default: height=300 may be to short. Try 700 or 800.
• 

NOTE 1: You don't have to publish All Sheets. In the above illustration, one could select the drop-down menu that says All-Sheets and select just the sheet they desire.


NOTE 2: If embedding in a Blog Post -> select the EditHTML tab to paste your embedded coding.


NOTE 3: one can edit the height="300" to a larger number to prevent vertical scrolling.