Welcome to our Video Library! Click on the button to the left to be directed to our YouTube channel. Or, view the videos by selecting any of the topics shown below. If viewing in full-screen mode, select the HD option for best quality. To receive notifications of new videos, simply subscribe to the YouTube channel.
We have organized these videos in categories, which you’ll also find in the drop-down options from the “Videos” tab up above. If you would like to see a video that is currently not in the library, email us at spreadsheetsolving@gmail.com and we will do our best to honor your request!
Select any topic below to view a video
Spreadsheets 101
Charts & Graphs
- Area (Stacked)
- Bar
- Bar (Stacked)
- Candlestick
- Column
- GeoMap
- Line
- Pie
- Scatter Plot (& best fit-line)
- Tree Map
Formatting & Data Analysis
- Add an Image
- Align
- Autofill
- Borders
- Conditional formatting
- Data Validation
- Filter
- Freeze
- Merge
- Pivot Table
- Text background color
- Text formatting (Size, Bold, Underline, & more!)
Tools & Apps
- How do I make better decisions with spreadsheets?
- How will a goal tracker benefit me?
- How do I analyze movie data?
- How do I manage order collections?
- How do I build a priority log?
- Where does all my money go?
- Where is basic stock analysis?
- How do I create a tournament schedule?
- How do I make better predictions?
- How do I create a dice game?
- Why create a tic tac toe game?
- How do I decode the tic tac toe game?
- How do I set up a random prize drawing?
- How do I split group costs with spreadsheets?
- How do I visualize data using Gallup survey results?
- How do I design and test experiments?
- How do I conduct hypothesis tests?
- How do I visualize Gallup survey data?
- How do I simulate dice rolls with spreadsheets?
- How do I calculate a variety of exchange rates?
- How do I manage my college applications?
- How do I create a wedding planning spreadsheet?
- How do I calculate the volume of geometric objects?
- How do I improve accuracy with the kappa statistic?
All Functions
- Absolute Value
- Add, Subtract, Multiply, & Divide
- And
- Array (single cell)
- Average (Mean)
- Column
- Concat(enation)
- Correlation
- Count
- Countblank
- Countif
- Counta
- Date Functions
- Equal & Not Equal
- Even
- Geomean
- Google Finance
- Greater than & Less than
- Hlookup
- IF function Intro
- IF function Example
- Nested IF
- IFERROR
- Index
- Index & Match
- Int
- Large
- Left
- Len
- Linest
- Lower
- Median
- Mid
- Min & Max
- Mode
- Odd
- Offset
- Operator Functions
- Or
- Percentile
- Percentrank
- Power
- Product
- Proper
- Rand
- Randbet
- Rank
- Right
- Round
- Roundup
- Rounddown
- Row
- R-squared
- Sign
- Slope & Intercept
- Small
- Standard deviation
- Sum
- Sumif
- Sumproduct
- Sumsq
- Transpose
- Lower
- Quartile
- Variance
- Vlookup