Group items tagged

Here is what we will discover: How to use Google Spreadsheet to facilitate real time collaboration and easy sharing How to use Google Spreadsheet to quickly build resources for your lessons How to use Google Spreadsheet to insert interactive Gadgets How to use Google Spreadsheet to design charts that will have your students going 'wow' How to make self-grading assessments Your questions answered

This free online course will help you switch to Excel 2010 from a previous version of the software, and will give you a thorough knowledge and understanding of Excel and its applications if you have never used it before. You can use Excel to analyse data, for example, in accounts, budgets, billing and many other areas. You learn how to navigate this revised version of Excel, exploring the menu bar and the different tasks that can be done with it. You will work on sample spreadsheets doing basic math, adding and deleting columns and rows, and preparing the worksheet for printing. You will learn how to represent your data visually to show trends, patterns and comparisons between the data in a chart, table or other template, and how Excel 2010 will automatically do all the calculations for you once you add in the formula. This course will be of great interest to all professionals in business, finance and many other areas that need to analyse data in accounts, or keep records of stock or schedules, and to anyone trying to keep track of their personal finances at home. Excel and spreadsheet use has found its way into daily life that few of us would ever have imaged just a few years ago. If you have done previous ALISON courses such as our Microsoft Excel 2003 course or ABC-IT, our comprehensive free introductory computer course, you will find MS Excel 2010 is the perfect next step to bring your spreadsheet skills to the next level.

 Map a List which turn Google Spreadsheet information into Google Maps placemarks.

Enter some text or a URL in a spreadsheet and a QR code will be automatically created - all with the help of a little formula that you'll learn about in this tip of the week.

How do automate the creation of personalized documents and emails from the cloud? The autoCrat Script was written to be a multi-purpose document merge tool that allows you to take any personalized, row-based spreadsheet data and create, save, attach to email, and share templated documents. No scripting ability required to use.

"This free Google Drive tutorial will teach you how to use this cloud-based program to create and save documents, spreadsheets, and more."

"To make the process of assigning students to groups and getting them going on editing the group's template easier I coded an Add-on script: Group Docs Maker. This allows you to copy and paste your roster of students into the spreadsheet and automatically create a copy of a template for each group. Each group members name is automagically appended to the document title."

Please take this poll - it is part of my workshop demonstrations for upcoming conferences

" "