Tag Archives: Google sheets

Check the “Rule of 72” with a spreadsheet

One of the more amazing things I’ve encountered while studying finance is the Rule of 72. This rule effectively tells you how long it would take to double your money, depending on what interest rate you are earning on it. So if you were earning 4% a year, it would take roughly (72/4) = 18 years to turn $1,000 into $2,000.

But does it really work? Let’s verify with a spreadsheet! Continue reading

Play Jeopardy at home with this Mobile Spreadsheet

This is the third in our three-part series of designing spreadsheets entirely on our mobile devices. Part 1 was a New Year’s resolution keeper and Part 2 was a weighted lottery to make a group decision on where to go for lunch. Today we’ll build a spreadsheet on the iPad that allows you and your friends to play along with the Jeopardy TV show, all while keeping score for a friendly competition.


Continue reading

Keep New Year’s Resolutions with Spreadsheets

new-year-hatWhat are your new year’s resolutions? As in most cases, coming up with the goals is easy…but achieving them is another story! According to a Forbes article published a couple of years ago, only 8% of Americans achieve their resolutions. How can we keep our resolutions? Can we be better at goal-setting? As an organizational and prioritization tool, spreadsheets can keep us accountable and help us reach our goals. In our busy lives, it can be a challenge to keep track of and prioritize everything we set out to do. Spreadsheets can help by making us better managers of our lives. Continue reading

Will you pay more or less under the Trump Tax Plan?

After nearly a year and a half after the candidates first declared their intention to run for the Presidency, we have now elected a new President. Trump’s Presidency was a surprise to many, and with Republicans in control of both the House and Senate along with the Presidency, major changes could be possible.

One of those changes could be taxes, where Trump has proposed a tax system with three tax brackets of 12%, 25% and 33% and an increase in the standard deduction to $30k for joint filers, while also eliminating exemptions for dependents. We wondered: roughly how would taxes change for any given level of income, filling status, and number of family members? This is a problem spreadsheets are well suited to solve! Continue reading

Top 10 Keyboard Shortcuts for Spreadsheets

© Photographer Jinyoung Lee | Agency: Dreamstime.com

Here is a short post on my top 10 favorite keyboard shortcuts for spreadsheets.

Keyboard shortcuts lets you perform an action in your spreadsheet by pressing certain keys on your keyboard. Why learn them? Shortcuts are time-saving, increasing your productivity and efficiency!

If you use a Mac, replace the Ctrl with the Command (or Apple) key. Unless specified, the shortcuts can be applied in both Google Spreadsheet and Microsoft Excel.

Continue reading

How many languages do you speak?

[polldaddy poll=6994482]

Over the past several months – or years for that matter – there has been a rush among American parents to teach kids Mandarin.  After-school language classes have emerged, immersion programs are gaining popularity, and videos and phone apps focused on languages have sprung up!

A recent Economist article, “Valued-Added Remodeling” (March 16, 2013) even noted that Jack Markell, Delaware’s governor, plans to expand immersion programs, such as those seen in the kindergarten classroom of Mcllvaine Early Childhood Center, where children are taught solely in Mandarin for half of each day.

Now, what’s the connection between our language skills and a spreadsheet? Continue reading

Google Spreadsheet 101

Take a spreadsheet tour with us. Here you’ll explore the layout of a typical Google spreadsheet. Along the journey, you’ll discover what menu bar is; how to add and rename worksheets; how to add, delete, and re-size rows and columns; and how to undo an action.

5 Favorite Features of Google Spreadsheets

These are among our favorite features of Google spreadsheets!  What are yours?

1.  Convenient access anywhere:  Whether you’re on your laptop, desktop, Android, iPhone, iPad, etc, you can access your Google spreadsheet.  Without worrying about saving and replacing multiple versions, you can view and edit the same spreadsheet across all devices!

Continue reading

Should schools adopt B.Y.O.T?

A new trend across schools has emerged:  B.Y.O.T for Bring Your Own Technology.   Recently, an article in the New York Times describes the debate of whether schools should adopt B.Y.O.T.   Are you a fan or a critic of B.Y.O.T?  Do the advantages of adopting this policy outweigh the drawbacks, or do they not?  How can we think about this?  Before you answer our poll, let’s first discover how we can use a spreadsheet to develop a logical framework to better inform our opinion!

[polldaddy poll=6990938]

Continue reading

Employment Patterns by Gender since 1948

In honor of Women’s History Month in March, check out our poll below:  what percentage of the work force consisted of women in 1948?  Keep in mind that just 28 years prior to 1948, women were first granted the right to vote.   How have employment patterns by gender changed over time?  Let’s use our spreadsheet problem solving skills to figure this out!

[polldaddy poll=6991261]

Continue reading

Pythagoras and SUMSQ

Ever heard of the philosopher and mathematician, Pythagoras of the 6th century BC? Perhaps you’ve come across one his most famous theorems during your geometry class. The Pythagorean Theorem states that in a right triangle, the sum of the legs squared is equal to the hypotenuse squared. 

Continue reading

Coin-flipping Life Experiment

© Photographer Dana Rothstein | Agency: Dreamstime.com

What if life’s major choices are to be decided by the flip of a coin? Interestingly, the Freakonomics Experiments project – a collaboration between Freakonomics and the University of Chicago –  is enlisting volunteers to do just that to study human behavior of decision-making. Intriguing, right?

An essential feature of this experiment is generating a truly random toin coss. While the Freakonomics Experiments team ensured coin toss randomness by using the Swiss-based Fourmilab’s True Random Number Generator (more info here), we can create our own coin toss using spreadsheets!  Really? You bet!

Continue reading