Showing posts with label Learn Spreadsheets. Show all posts
Showing posts with label Learn Spreadsheets. Show all posts

Sunday, January 6, 2008

A GPA Calculator with how-to video

uTIPu is a site which gives the software (tipCam) to capture your own help videos (tips) and a community site through which others can view your video. While the site seems new, someone has posted a video explaining their Google spreadsheet GPA calculator - with a video describing how to use it. They also used the often overlooked (uh... make that un-discoverable) feature called &newcopy, which lets you immediately give someone a copy of your spreadsheet when they click it... so we provide that type of link below as well.

The only thing the author has incorrect is the subtle mistake in "You need a Google (Gmail) account to use it."... A Google Account is NOT the same thing as a GMail account - even though a GMail account IS a Google account, you can also use your existing non-gmail email address to create a Google account and use Google Docs, Calendar, Alerts, Notebook, etc...

Site:uTIPu
Page/Post:GPA Calculator (video and spreadsheet links)
Spreadsheet:GPA Calculator (view only)
Get Your Own Copy:GPA Calculator (EDIT YOUR OWN)

Saturday, December 15, 2007

Project Plan Gantt Chart

Antonio Lupetti strikes again... Last time, he posted a descriptive project planning template using Google spreadsheets. This time, he's got a spreadsheet which produces a gantt chart of your project tasks using conditional formatting.

Site:Woork Blog
Page/Post:Gantt Chart using Google Spreadsheets
Spreadsheet:Gantt Chart Spreadsheet

Project Planning Spreadsheet

The Woork Blog (spelling intentional) by Antonio Lupetti has a post including a useful Project Plan template using a spreadsheet. The post itself is a good read as it offers an explanation of the meaning of all the data in the spreadsheet including some methods used (like vlookup).

Site:Woork Blog
Page/Post:Implement a Project Plan and manage activities with Google Spreadsheets
Spreadsheet:Project Plan Tutorial
Get Your Own Copy:This link gives you your own copy of the above spreadsheet to edit