background preloader

Google Sheets

Facebook Twitter

Gmail - Free Storage and Email from Google. Google Sheets: Import Range Function To Share Data. In education there are times when we gather data into a sheet and need to share parts of the form out to others.

Google Sheets: Import Range Function To Share Data

How does one do that so that it populates automatically over time without copying and pasting time and time again? Video Warning: My goal is to take the questions people have about technology and provide solutions. This is just one solution. If you have other ideas or methods to solving the same issue, then please leave a comment or reach out so we can showcase the method. Steps For those who don’t want to watch a video, here is a quick guide. Learning Google Apps. Google Sheets Functions – CONCATENATE. Concatenation.

Google Sheets Functions – CONCATENATE

What on earth does that mean? Put simply, this is putting different pieces together to create a whole. We can have values in different cells and use the CONCATENATE function to join them together to create one combined piece. Here I’ll go through some examples of how to use this function, building up from the very basics to more sophisticated ways to use it, combing it with other functions.

So, let’s dive straight in. Example 1 – Joining two names together In the first example, we have some names which from our system have been stored in separate cells. In cell C2, we write a CONCATENATE function to join the contents of column A and B. As we write the function, we can see that the function needs some strings (text, numbers, etc) to put together. In the brackets we refer to cell A2 (Fred), add a comma, then refer to cell B2 (Flintstone).

As you can see it’s added the two names together, the only problem is, is that there’s no space between the two. Further notes. Google Sheets Functions – IMPORTRANGE. Google Sheets has a wonderfully useful function called IMPORTRANGE.

Google Sheets Functions – IMPORTRANGE

So what does it do? It allows you to connect different spreadsheets and import data from one to another. The most basic example would be to connect one sheet with another sheet and import some data from the first sheet to the second. What’s important is that if you change the data in the first sheet, it’s automatically updates in the second sheet. Other uses Not only can you connect 2 spreadsheets, but you can connect multiple spreadsheets with a master sheet. Either the master is updated and the information is sent out to the individual sheets. Or you can have the opposite, users update the individual sheets and the information is sent to the master sheet.

The Ultimate Guide to Google Sheets. Master Google Sheets and Become a Spreadsheet Expert It's easy enough to list your expenses in a spreadsheet, use =sum(A1:A20) to see how much you spent, and add a graph to compare your expenses.

The Ultimate Guide to Google Sheets

It's also easy to use a spreadsheet to deeply analyze your numbers, assist in research, and automate your work—but it seems a lot more tricky. Google Sheets, the free spreadsheet companion app to Google Docs, is a great tool to start out with spreadsheets. It's free, easy to use, comes packed with hundreds of functions and the core tools you need, and lets you share spreadsheets and collaborate on them with others. But where do you start if you've never used a spreadsheet—or if you're a spreadsheet professional, where do you dig in to create advanced workflows and build macros to automate your work? Here's the guide for you. Table of Contents Download this Course. How to Remove Duplicates in Google Sheets - BetterCloud Monitor. Control Alt Achieve: Make Google Form responses easy to read with “Save as Doc” add-on. Google Forms is a one of the most useful parts of the Google Apps suite for schools.

Control Alt Achieve: Make Google Form responses easy to read with “Save as Doc” add-on

With Google Forms teachers, techies, admins, and students can accomplish many tasks including:Online assessmentsCollecting data for science experimentsBrainstorming ideas in classCompleting a reading logSurveying parentsAccepting technology help ticketsAnd much more… For all its wonderful features, one pain point for Google Forms is viewing all the responses in an easy-to-read format. Learning Google Apps.

Learning Google Apps Learning how to use Drive, Docs, Sheets, Slides & Forms Home › Learning Google Apps › Google Apps › Google Sheets Google Sheets Here you’ll find blog posts on how to use Google Sheets.

Learning Google Apps

The basics Cell formatting Formatting your data Understanding Formulas and Functions Controlling rows and columns (Part 1) Controlling rows and columns (Part 2) Cell references – Relative & Absolute Moving, copying & pasting data (inc Paste Special) Moving beyond just one sheet Share this: Like this: Recent Posts Recent Comments Archives Categories Meta. Learning Google Apps. Control Alt Achieve: Long Multiplication with Google Sheets. My two youngest boys are still in elementary school, so the topic of long multiplication comes up frequently on homework.

Control Alt Achieve: Long Multiplication with Google Sheets

Long multiplication is when you multiply two numbers, such as a 3-digit number times a 2-digit number, and you show all the steps by first multiplying by the ones digit, then by the tens digit, then adding together those partial products to get the final answer. This is a very structured step-by-step method, so it is important for students to be able to follow the process in the correct order. I wondered if Google Sheets could be used to guide a student through the steps, help keep all the numbers organized properly, and provide feedback if the student does something wrong. The answer is yes! What I did was create some sheets that allow a student to type in the original multiplication problem, and then using hidden columns, custom formulas, and conditional formatting, it provides the student with feedback each step along the way.