Home
Videos uploaded by user “Spreadsheet Solving”
Kappa and Spreadsheets - a Measure of Inter-rater Agreement
 
05:15
Discover what the kappa or Cohen's kappa is and how spreadsheets can help us solve it. For the related tutorial post, click here: http://spreadsheetsolving.com/2013/12/05/kappa/ Here is the Google spreadsheet template link: https://docs.google.com/spreadsheet/ccc?key=0ArU-OSCYb_YpdG5iaDFsd3FidmlUYTFLNWwyLVB1YUE&usp=sharing More information can be found on www.spreadsheetsolving.com
Views: 14115 Spreadsheet Solving
Correlation & R-squared
 
07:28
Discover statistical functions: correlation (r) and r-squared. Visit www.spreadsheetsolving.com for more videos and tutorials!
Views: 8302 Spreadsheet Solving
Date Functions
 
04:28
Discover basic date functions. Select the HD quality option for the best full-screen viewing experience. Visit www.spreadsheetsolving.com for more videos and tutorials! Here is a link to the Google spreadsheet. To edit it, first save a copy onto your Google drive https://docs.google.com/spreadsheet/ccc?key=0ArU-OSCYb_YpdGlDQk8yYmd6TTI2UWY1RFJoalU1aWc
Views: 12727 Spreadsheet Solving
Equal and Not Equal
 
02:27
Discover the EQUAL and NOT EQUAL functions. Select the HD quality option for the best full-screen viewing experience. Visit www.spreadsheetsolving.com for more videos and tutorials!
Views: 20182 Spreadsheet Solving
Convert between Google Sheets & Excel
 
03:03
We'll show you how to easily convert spreadsheet files between Google Sheets and Microsoft Excel.The process is easy and fast: no plug-ins are required. Note: Since the publishing of the video (2013), Google Spreadsheets has been re-named to Google Sheets. The conversion process from Excel to Google Sheets has also been slightly amended. The exact steps can be found here: www.spreadsheetsolving.com/google-excel-conversion
Views: 15236 Spreadsheet Solving
Rank, Percentrank, & Percentile Functions
 
06:42
This video is part of the series on Statistical Functions. More videos and tutorials about spreadsheet learning can be found at www.spreadsheetsolving.com. Please select the HD quality setting when viewing this video in full-screen mode.
Views: 3966 Spreadsheet Solving
Nested IF function in Google Spreadsheets
 
04:15
This video is part of our series on Statistical Functions. When viewing this video in full-screen mode, please select the HD quality setting. For more videos and tutorials on spreadsheet learning, visit www.spreadsheetsolving.com.
Views: 8211 Spreadsheet Solving
Data Validation
 
03:22
Discover data validation, a technique that improves data analysis. Visit http://spreadsheetsolving.com/ for more videos and tutorials!
Views: 3510 Spreadsheet Solving
Create a GeoMap in Google Spreadsheets
 
04:46
Discover the GeoMap on Google Spreadsheets. Select the HD quality option for the best full-screen viewing experience. Visit www.spreadsheetsolving.com for more videos and tutorials! Here is the link to the Google spreadsheet. To edit it, first save it onto your Google drive. https://docs.google.com/spreadsheet/ccc?key=0ArU-OSCYb_YpdF9TTmJOR2praW1yT3JfV0w1MzU1RVE Here is the link to the spreadsheet. To edit the spreadsheet, first save it onto your Google drive. https://docs.google.com/spreadsheet/ccc?key=0ArU-OSCYb_YpdF9TTmJOR2praW1yT3JfV0w1MzU1RVE
Views: 8728 Spreadsheet Solving
GoogleFinance
 
08:55
Discover the GoogleFinance function. Select the HD quality option for the best full-screen viewing experience. Visit www.spreadsheetsolving.com for more videos and tutorials!
Views: 6577 Spreadsheet Solving
Offset
 
09:58
Discover the OFFSET function. Select the HD quality option for the best full-screen viewing experience. Visit www.spreadsheetsolving.com for more videos and tutorials! Here is the link to the Google spreadsheet. To edit it, first save it onto your Google drive.https://docs.google.com/spreadsheet/ccc?key=0ArU-OSCYb_YpdDR0M3pXUUlubjRRNXNuOVhINFF6aXc
Views: 2353 Spreadsheet Solving
Goal Tracker
 
02:40
Discover the Goal Tracker, a spreadsheet application. Select the HD quality option for the best full-screen viewing experience. Visit www.spreadsheetsolving.com for more videos and tutorials! Here is a link to the Google spreadsheet. To edit it, first save it onto your Google drive. https://docs.google.com/spreadsheet/ccc?key=0ArU-OSCYb_YpdEdBTjdVcFVKRTRFNm8xR0pCd1NXRkE
Views: 1590 Spreadsheet Solving
Index & Match
 
09:46
Discover the INDEX and MATCH functions. Visit www.spreadsheetsolving.com for more videos and tutorials! The Google spreadsheet link can be found here. To edit it, first save a copy on your Google drive. https://docs.google.com/spreadsheet/ccc?key=0ArU-OSCYb_YpdEw0ZW9nLUlyUzliSGFlSjZWMDBScWc
Views: 6468 Spreadsheet Solving
Google Spreadsheet 101
 
06:38
Learn the layout basics of a Google spreadsheet. More videos and tutorials can be found on www.spreadsheetsolving.com.
Views: 1933 Spreadsheet Solving
Spreadsheet Stock Analysis
 
05:17
Discover how to analyze a stock using a Google spreadsheet. Select the HD quality option for the best full-screen viewing experience. Visit www.spreadsheetsolving.com for more videos and tutorials! Here is a link to the Google spreadsheet. To edit it, first create a copy of it on your Google drive. https://docs.google.com/spreadsheet/ccc?key=0ArU-OSCYb_YpdGFPdlhBdUlzWXNONWVRVjFMN2FyYUE
Views: 6290 Spreadsheet Solving
Tree Map
 
04:28
Discover the Tree Map. Select the HD quality option for the best full-screen viewing experience. Visit http://spreadsheetsolving.com/ for more videos and tutorials! Here is the link to the Google spreadsheet. To edit it, first log into your Google accoutn and save a copy onto your Google drive. https://docs.google.com/spreadsheet/ccc?key=0ArU-OSCYb_YpdGlibERUN1lxOHA0X1RrTG1tY1BMcVE
Views: 14733 Spreadsheet Solving
Count vs. Counta
 
04:32
Discover the COUNT and COUNTA functions. Select the HD quality option for the best full-screen viewing experience. Visit www.spreadsheetsolving.com for more videos and tutorials!
Views: 1220 Spreadsheet Solving
Greater & Less than
 
03:43
Discover the greater than, less than, greater than or equal to, and less than or equal to functions. Select the HD quality option for the best full-screen viewing experience. Visit www.spreadsheetsolving.com for more videos and tutorials!
Views: 33142 Spreadsheet Solving
College App Tracker Spreadsheet
 
05:19
Use the college app tracker spreadsheet to organize requirements, manage deadlines, and maintain key info such as login/password and fees. For a copy of the template, click on the link, sign in, and save a version on your Google drive: https://docs.google.com/spreadsheet/ccc?key=0ArU-OSCYb_YpdHdvWXplRUwzRlZwS0dPYkFSYjBzb3c&usp=sharing. You can also find the tutorial post with a link to the spreadsheet here: http://spreadsheetsolving.com/college-app-tracker/
Views: 5260 Spreadsheet Solving
Round Robin Tournament
 
07:24
Discover how to create a Round Robin tournament schedule. Select the HD quality option for the best full-screen viewing experience. Visit http://spreadsheetsolving.com/ for more videos and tutorials! Here is a link to the Google spreadsheet. To edit it, first log in to your Google account and save a copy on your Google drive https://docs.google.com/spreadsheet/ccc?key=0ArU-OSCYb_YpdGFMTFBCbFBsNnZ1Y0Fhd09iRmNaTkE
Views: 26767 Spreadsheet Solving
How to Compare 2 Lists in Spreadsheets:
 
05:03
Let's discover the formula for comparing 2 lists in spreadsheets and apply it to a framework. We'll discuss the ISNA and MATCH functions, along with the IF, AND, and OR. The framework involves determining which members of your club participate in all 3 volunteer activities and therefore receive gold stars. The related post can be found on www.spreadsheetsolving.com/posts
Views: 3309 Spreadsheet Solving
Intro to Index Function
 
04:41
Discover the INDEX function. Select the HD quality option for the best full-screen viewing experience. Visit www.spreadsheetsolving.com for more videos and tutorials!
Views: 434 Spreadsheet Solving
Splitting Costs with Google Spreadsheets
 
06:06
Discover this spreadsheet template for splitting travel costs among your friends, using the SUMIF function and data validation. The related post can be found here: http://spreadsheetsolving.com/split-group-costs. The link for the spreadsheet template is as follows: https://docs.google.com/spreadsheet/ccc?key=0ArU-OSCYb_YpdEhZNVE3Y1QyZmtxQVFoYV9pTE5kVVE&usp=sharing More videos and tutorials can be found on www.spreadsheetsolving.com.
Views: 12959 Spreadsheet Solving
Slope & Intercept
 
02:34
Discover the Slope and Intercept functions. Select the HD quality option for the best full-screen viewing experience. Visit www.spreadsheetsolving.com for more videos and tutorials!
Views: 1155 Spreadsheet Solving
Stacked Bar Chart
 
03:20
Discover how to create a stacked bar chart. Select the HD quality option for the best full-screen viewing experience. Visit http://spreadsheetsolving.com/ for more videos and tutorials! Here is the link to the spreadsheet. To edit it, first log in to your Google account and save a copy on your Google drive. https://docs.google.com/spreadsheet/ccc?key=0ArU-OSCYb_YpdF8tTjNILVRYQ1h6eDhEYk5qZkJYY2c
Views: 17490 Spreadsheet Solving
IFERROR
 
02:52
Discover the IFERROR function. Select the HD quality option for the best full-screen viewing experience. Visit www.spreadsheetsolving.com for more videos and tutorials!
Views: 2200 Spreadsheet Solving
Decoding the Round Robin Spreadsheet
 
04:19
Decode the round robin tennis tournament schedule and score card in Google spreadsheets. The HD quality option is best for viewing this video. More tutorials and videos on spreadsheet learning can be found on www.spreadsheetsolving.com. Here is a link to the Google spreadsheet. To edit it, first save it onto your Google drive https://docs.google.com/spreadsheet/ccc?key=0ArU-OSCYb_YpdGFMTFBCbFBsNnZ1Y0Fhd09iRmNaTkE
Views: 1347 Spreadsheet Solving
Calculate the Volume of Geometric Objects with Spreadsheets
 
03:16
Understand and calculate the volume of a cube, rectangular prism, cylinder, pyramid, cone, and sphere, using our Google spreadsheet template. For more info, see http://spreadsheetsolving.com/volume-geometry/. To edit the template, log into your Google account and save this link on your Google drive: https://docs.google.com/spreadsheet/ccc?key=0ArU-OSCYb_YpdHQ0cWhfTEJkY3kzb09fOUF2b1FFcHc&usp=sharing
Views: 2383 Spreadsheet Solving
Random Prize Drawing
 
03:41
Create a spreadsheet that can randomly draw a winner. Discover vlookup, index, & randbet functions along with data validation. For full-screen viewing, select the HD quality option for the best experience. For more videos and tutorials, visit www.spreadsheetsolving.com. Here is a link to the Google spreadsheet. To edit it, first save it on your Google drive. https://docs.google.com/spreadsheet/ccc?key=0ArU-OSCYb_YpdEpwc283SE5odHVwamZiLVBGbVVndUE
Views: 756 Spreadsheet Solving
Sumif, Paste, Reference
 
08:29
Discover the SUMIF formula, copying and pasting formulas, and the concept of relative and absolute references. We will also review the SUM formula. Visit www.spreadsheetsolving.com for more videos and tutorials!
Views: 2731 Spreadsheet Solving
Why Spreadsheet Solving
 
02:49
Why are spreadsheet skills important? How can I improve upon problem-solving skills and computational thinking? How do I build neat spreadsheet tools and applications? Discover how Spreadsheet Solving can benefit you at http://spreadsheetsolving.com/
Views: 2957 Spreadsheet Solving
Priority Log / New Year Resolution Goal Setting
 
03:40
Discover the Priority Log / New Year Resolution Goal Setting spreadsheet, a useful spreadsheet application. Select the HD quality option for the best full-screen viewing experience. Visit www.spreadsheetsolving.com for more videos and tutorials! Here is a link to the spreadsheet. To edit it, first save it onto your Google drive. https://docs.google.com/spreadsheet/ccc?key=0ArU-OSCYb_YpdDRNUktlNEQ4d2xrT0U3azhCMUpMa3c
Views: 620 Spreadsheet Solving
LEFT function
 
05:13
Discover how to use the LEFT function with a text string. I'd recommend seeing this video in conjunction with the RIGHT and MID functions. The spreadsheet referenced in the video can be found here: https://docs.google.com/spreadsheet/ccc?key=0ArU-OSCYb_YpdGpQcEJZQnRtUF9ibVZMLWJCN0J4VUE&usp=sharing For more videos and tutorials, visit www.spreadsheetsolving.com
Views: 440 Spreadsheet Solving
Decoding Tic Tac Toe
 
08:27
Learn the formulas used to create a tic, tac, toe game: IF, AND, and OR. If viewing this video in full screen, select the HD quality mode. More videos and tutorials on spreadsheet learning can be found on www.spreadsheetsolving.com. Here is a link to the Google spreadsheet. To edit it, first save it onto your Google drive. https://docs.google.com/spreadsheet/ccc?key=0ArU-OSCYb_YpdE5lZ3BzdEhMMkF6c2tFMm41ZXdyNHc
Views: 2825 Spreadsheet Solving
Rounding Functions
 
05:25
Discover rounding functions: round, roundup, and rounddown. Select the HD quality option for the best full-screen viewing experience. Visit www.spreadsheetsolving.com for more videos and tutorials!
Views: 430 Spreadsheet Solving
Decision-Making Tool with Sum and Sumproduct
 
03:33
Discover this decision-making framework application created in Google spreadsheets and learn the sum and sumproduct functions. Select the HD quality option for the best full-screen viewing experience. Visit www.spreadsheetsolving.com for more videos and tutorials! Here is a link to the Google spreadsheet. To edit it, first save it onto your Google drive. https://docs.google.com/spreadsheet/ccc?key=0AuM7Fz10i00NdFM4emxjZm5XeWN1QWg2TUJEV0sxWGc
Views: 891 Spreadsheet Solving
Stacked Area Chart
 
04:04
Discover the stacked area chart. Visit www.spreadsheetsolving.com for more videos and tutorials! Here is the link to the spreadsheet. To edit it, first save it onto your Google drive. https://docs.google.com/spreadsheet/ccc?key=0ArU-OSCYb_YpdEYydXdpWXV3SmtqREtvM1I0UXpCQVE
Views: 1998 Spreadsheet Solving
MID function
 
03:37
Discover how to use the MID function with string text. I'd recommend viewing this video in conjunction with the LEFT and RIGHT function videos. For more videos and tutorials, visit www.spreadsheetsolving.com.
Views: 444 Spreadsheet Solving
Dispersion
 
04:09
Discover the Standard Deviation and Variance, functions that measure dispersion. Select the HD quality option for the best full-screen viewing experience. Visit www.spreadsheetsolving.com for more videos and tutorials! http://www.techrepublic.com/blog/google-in-the-enterprise/five-google-spreadsheet-features-to-help-kick-your-excel-addiction/1420
Views: 418 Spreadsheet Solving
Add, Subtract, Multiply, & Divide
 
02:53
Learn basic operator functions in a Google spreadsheet. If viewing in full screen mode, select the HD quality option. More videos can be found on www.spreadsheetsolving.com.
Views: 1990 Spreadsheet Solving
Round Robin
 
02:55
Discover how to create a round robin tennis tournament schedule and score card using Google spreadsheets. To learn how to create this, select this video here: http://youtu.be/lbV2LPBkR90 More tutorials and videos on spreadsheet learning can be found on www.spreadsheetsolving.com.
Views: 3890 Spreadsheet Solving
Wedding Planning Spreadsheet Organizer
 
04:23
Use this Google Spreadsheet template to plan your wedding, party, or function. A copy of the template can be saved here: https://docs.google.com/spreadsheet/ccc?key=0ArU-OSCYb_YpdFlkSVFteVp0bGNDOHlrSm5OcnNKbFE&usp=sharing More videos and tutorials can be found on www.spreadsheetsolving.com.
Views: 1162 Spreadsheet Solving
Tree Map
 
04:21
Create a tree map using Google spreadsheets. Select the HD quality setting when viewing this video in full screen mode. More videos and tutorials can be found on www.spreadsheetsolving.com.
Views: 1237 Spreadsheet Solving
LEN function
 
01:44
Discover how to use the LEN function with text string. For more videos and tutorials, visit www.spreadsheetsolving.com
Views: 652 Spreadsheet Solving
Quartile
 
02:34
Discover the Quartile function. Select the HD quality option for the best full-screen viewing experience. Visit www.spreadsheetsolving.com for more videos and tutorials!
Views: 193 Spreadsheet Solving
Hlookup
 
07:08
Discover the HLOOKUP (horizontal lookup) function. Select the HD quality option for the best full-screen viewing experience. Visit www.spreadsheetsolving.com for more videos and tutorials!
Views: 3685 Spreadsheet Solving
Single Cell Array
 
05:40
Discover the single cell array function. Select the HD quality option for the best full-screen viewing experience. Visit www.spreadsheetsolving.com for more videos and tutorials!
Views: 540 Spreadsheet Solving
Intro to Functions
 
03:13
I created this video with the YouTube Video Editor (http://www.youtube.com/editor)
Views: 1320 Spreadsheet Solving
SUMSQ
 
02:52
Discover the SUMSQ function. Visit www.spreadsheetsolving.com for more videos and tutorials! Here is a link to the Google spreadsheet. To edit it, first save it on your Google drive. https://docs.google.com/spreadsheet/ccc?key=0ArU-OSCYb_YpdExhNHRSYUQzZXZDY3RSSzV3R2tlcFE
Views: 2893 Spreadsheet Solving
Average, Median, & Mode
 
07:22
Discover the concepts: average, median, and mode. Select the HD quality option for the best full-screen viewing experience. Visit www.spreadsheetsolving.com for more videos and tutorials! Here is a link to the Google spreadsheet. To edit it, first save it on your Google drive https://docs.google.com/spreadsheet/ccc?key=0ArU-OSCYb_YpdDE2MHJiRHlyUWxMSU8zZzB1cVhCR2c
Views: 482 Spreadsheet Solving