There are many ways to skin a cat, so the saying goes. In spreadsheets, there are multiple ways to achieve the same result when performing an operation – such as addition, division, equal to, etc. 
See below to view our 3-minute video tutorial and reference chart. Continue reading “Spreadsheet Operators Tutorial”
How to Analyze Stocks in Spreadsheets
In a few steps, you can create a basic stock analyzer spreadsheet. Our post and 5-minute video tutorial will guide you to building a spreadsheet template that charts prices, calculates return and volatility metrics, and identifies lowest and highest daily returns! (Basic template also accessible below).
[youtube=http://youtu.be/hMawNIfdFRo]
Splitting Group Costs with Spreadsheets
After a beach outing, ski trip, or joint roommate purchase, we just might need to split shared expenses among a group. A spreadsheet can serve as an efficient and practical tool to do just that! See this framework live in action in our 6-minute video below.
Calculate Distance Traveled with Spreadsheets
If you have data such as velocity and time traveled, would you be able to calculate the total distance journeyed? Let’s discover how to tackle this question with spreadsheets! We’ll first begin by calculating distance traveled when velocity is constant. Then we’ll approach a more realistic situation of varying velocity using the Mid Rectangular Approximation Method (MRAM)! Continue reading “Calculate Distance Traveled with Spreadsheets”
Take the ‘Order of Operations’ Spreadsheet Quiz!
Know the rules of the order of operations? A central concept in pre-algebra/algebra, these rules clarify which actions in any algebraic expression should be performed first. Let’s review what the rules are and why they are important. Then, you can test your knowledge with a spreadsheet quiz! Continue reading “Take the ‘Order of Operations’ Spreadsheet Quiz!”
How to Compare 2 Lists in Spreadsheets
How do I use spreadsheets to compare 2 lists and apply this knowledge to a practical framework? Let’s discover this while tackling the Gold Star Problem! Continue reading “How to Compare 2 Lists in Spreadsheets”
Convert between Google Sheets & Excel
How do I convert a Google Sheets into Microsoft Excel and vice versa? Below is a 5-step approach and a 3-minute video tutorial. The conversion is fast and easy!
Continue reading “Convert between Google Sheets & Excel”
My Life in a Tree Map
How does my life compare to the average American’s? What does my ideal day look like? With data from the Bureau of Labor Statistics (BLS), Google spreadsheets, and problem-solving skills, let’s conduct some analysis with Tree Maps.
How Accurate is your Robot? Measurement Error & Spreadsheets
No robot or machinery is consistently perfect. Glitches might occur with overuse, or the environment is unsuitable. While achieving a perfectly functioning robot is a noteworthy goal, it may not be realistic. So, what level of error or tolerance level would you be willing to accept? Let’s discover how to use spreadsheets as a tool for understanding and calculating measurement error. Continue reading “How Accurate is your Robot? Measurement Error & Spreadsheets”
How to Track & Analyze Spending
Where does your money go? This is an important question, because it gets to the heart of basic money management and personal finance. Let’s discover and create a spreadsheet application that tracks and analyzes your spending! Continue reading “How to Track & Analyze Spending”
Probabilities & Dice Roll Simulations in Spreadsheets
What is the probability of rolling any pair of numbers with two dice? Let’s first solve this and then confirm our calculated probability by simulating 500 dice rolls with a spreadsheet! In this post, we will focus on understanding basic probability concepts and then discover how with spreadsheets, we can actually see whether our calculated probability holds true!
Continue reading “Probabilities & Dice Roll Simulations in Spreadsheets”
How to Schedule a Tennis Tournament
We feel inspired after watching amazing tennis matches, especially from the Grand Slam tournaments: Australian Open, French Open, Wimbledon, and US Open. After witnessing these matches, we feel the desire to get out on the court and play. How can we organize a tennis tournament to engage in some fun match-play? Let’s discover how to schedule a round robin tennis tournament and score card using spreadsheets! Continue reading “How to Schedule a Tennis Tournament”