Канал: Spreadsheet Solving

Conditional Probabilities and the Academy Awards

Conditional Probabilities and the Academy Awards

Kappa and Spreadsheets - a Measure of Inter-rater Agreement

Kappa and Spreadsheets - a Measure of Inter-rater Agreement

Edit and Save 50+ Free Spreadsheets from Spreadsheet Solving

Edit and Save 50+ Free Spreadsheets from Spreadsheet Solving

Calculate the Volume of Geometric Objects with Spreadsheets

Calculate the Volume of Geometric Objects with Spreadsheets

Wedding Planning Spreadsheet Organizer

Wedding Planning Spreadsheet Organizer

How to Name & Protect Cells in Spreadsheets

How to Name & Protect Cells in Spreadsheets

College App Tracker Spreadsheet

College App Tracker Spreadsheet

Create a Currency Exchange Rate Calculator

Create a Currency Exchange Rate Calculator

How to Compare 2 Lists in Spreadsheets:

How to Compare 2 Lists in Spreadsheets:

Convert between Google Sheets & Excel

Convert between Google Sheets & Excel

Probability and Dice Roll Simulations in Spreadsheets

Probability and Dice Roll Simulations in Spreadsheets

Hypothesis Testing with Spreadsheets

Hypothesis Testing with Spreadsheets

How to Visualize Data with Spreadsheets

How to Visualize Data with Spreadsheets

Design and Conduct Experiments with Spreadsheets

Design and Conduct Experiments with Spreadsheets

Splitting Costs with Google Spreadsheets

Splitting Costs with Google Spreadsheets

PROPER function

PROPER function

RIGHT function

RIGHT function

MID function

MID function

UPPER & LOWER functions

UPPER & LOWER functions

LEN function

LEN function

LEFT function

LEFT function

Nested IF

Nested IF

AND Function

AND Function

Operator Functions Overview

Operator Functions Overview

Investment Club spreadsheet

Investment Club spreadsheet

Nested IF function in Google Spreadsheets

Nested IF function in Google Spreadsheets

Random Prize Drawing

Random Prize Drawing

Spreadsheets as Decision Tools

Spreadsheets as Decision Tools

Round Robin

Round Robin

Google Spreadsheet 101

Google Spreadsheet 101

Array (Single Cell)

Array (Single Cell)

Add, Subtract, Multiply, & Divide

Add, Subtract, Multiply, & Divide

OR Function

OR Function

Decoding the Round Robin Spreadsheet

Decoding the Round Robin Spreadsheet

Rank, Percentrank, & Percentile Functions

Rank, Percentrank, & Percentile Functions

Decoding Tic Tac Toe

Decoding Tic Tac Toe

Tic Tac Toe

Tic Tac Toe

Minimum and Maximum Functions

Minimum and Maximum Functions

Offset

Offset

Format Fundamentals

Format Fundamentals

Basic Math Functions

Basic Math Functions

Rank, Percentrank, Percentile

Rank, Percentrank, Percentile

Absolute Value and Sign

Absolute Value and Sign

Min and Max

Min and Max

Rounding Functions

Rounding Functions

Dispersion

Dispersion

Operator Basics

Operator Basics

Min & Max, Small & Large

Min & Max, Small & Large

Small and Large

Small and Large

Pie Chart

Pie Chart

Data Validation

Data Validation

Decision-Making Tool with Sum and Sumproduct

Decision-Making Tool with Sum and Sumproduct

Date Functions

Date Functions

Count vs. Counta

Count vs. Counta

Bar & Stacked Bar Charts

Bar & Stacked Bar Charts

Goal Tracker

Goal Tracker

Application of the IF function

Application of the IF function

Priority Log / New Year Resolution Goal Setting

Priority Log / New Year Resolution Goal Setting

Sumif, Paste, Reference

Sumif, Paste, Reference

Movie Summary Statistics

Movie Summary Statistics

Where does all my money go?

Where does all my money go?

Filter

Filter

IFERROR

IFERROR

Club Form Application

Club Form Application

Or Function

Or Function

And & Or Functions

And & Or Functions

Conditional Formatting

Conditional Formatting

Average, Median, & Mode

Average, Median, & Mode

Intro to Functions

Intro to Functions

And function

And function

Intro to IF function

Intro to IF function

Why Spreadsheet Solving

Why Spreadsheet Solving

Intermediate Formatting

Intermediate Formatting

Column & Row

Column & Row

Intermediate Operator Functions

Intermediate Operator Functions

Create a GeoMap in Google Spreadsheets

Create a GeoMap in Google Spreadsheets

Stacked Area Chart

Stacked Area Chart

Transpose

Transpose

Add an Image

Add an Image

Intro to Index Function

Intro to Index Function

Hlookup

Hlookup

Geomean

Geomean

Column

Column

Greater & Less than

Greater & Less than

Vlookup

Vlookup

Candlestick Chart

Candlestick Chart

Spreadsheet Stock Analysis

Spreadsheet Stock Analysis

Scatter Plot & Best Fit Line

Scatter Plot & Best Fit Line

Correlation & R-squared

Correlation & R-squared

Row

Row

Slope & Intercept

Slope & Intercept

Concat

Concat

Rand & Randbet

Rand & Randbet

Dice Game

Dice Game

Making a Prediction

Making a Prediction

GoogleFinance

GoogleFinance

Index & Match

Index & Match

Access (& Save) Google Spreadsheets

Access (& Save) Google Spreadsheets

Align

Align

Borders

Borders

Round Robin Tournament

Round Robin Tournament

Text background color

Text background color

Pivot Table

Pivot Table

Single Cell Array

Single Cell Array

Freeze

Freeze

Text Formatting: Font size, Bold, Underline, Strikethrough

Text Formatting: Font size, Bold, Underline, Strikethrough

Column Chart

Column Chart

Tree Map

Tree Map

Autofill

Autofill

Product

Product

COUNTBLANK

COUNTBLANK

COUNTIF & COUNTBLANK

COUNTIF & COUNTBLANK

Line Graph

Line Graph

Merge

Merge

COUNTIF

COUNTIF

Bar Chart

Bar Chart

Raised to a Power

Raised to a Power

INT, EVEN, ODD

INT, EVEN, ODD

Quartile

Quartile

Equal and Not Equal

Equal and Not Equal

SUMSQ

SUMSQ

Stacked Bar Chart

Stacked Bar Chart

Tree Map

Tree Map

Bold, Italics, Shade, Border, Autofill

Bold, Italics, Shade, Border, Autofill