In this week’s roundup, delete sheets, hide passwords, use Boolean logic, and many more tips. I hope you’ve recovered from your Spreadsheet Day celebrations, and are ready to start a new week.
Author: Debra Dalgleish
Happy Spreadsheet Day 2015
Happy Spreadsheet Day 2015! Thanks for stopping by, and please vote in the survey below, for the Spreadsheet Hall of Fame.
We celebrate on October 17th because that is the date on which VisiCalc was first released, way back in 1979 – and that was 36 years ago. How time flies when you’re having fun with spreadsheets!
Count Items Based on Another Column
How can you count items in one column, based on criteria in a different column? We’ve shipped orders to the East region, and want to know how many of those East orders have a problem note in column D. Instead of the COUNTIF function (1 criterion) we’ll use the COUNTIFS function (multiple criteria).
Excel Roundup 20151012
In this week’s roundup, listing comments, LEGO, option buttons, and inheriting an Excel workbook.
Option Button Scores With CHOOSE Function
You can use option buttons on a worksheet, to make it easy for people to pick just one item from several options. There’s no programming required – just set up a group box, add option buttons, and link the buttons to a cell. The video at the end of this post shows you those steps.
The option buttons send a value to their linked cell, and we’ll take a look at how you can use those numbers.
Continue reading “Option Button Scores With CHOOSE Function”
Excel Roundup 20151005
In this week’s roundup, get started with Office 2016, nominations for a Spreadsheet Hall of Fame, and much more.
Happy 30th Anniversary Excel!
Today is the 30th anniversary of the first release of Microsoft Excel. To celebrate this auspicious occasion, I invited you to share your memories of getting started with Excel, and thank you for your contributions!
In 2005 there was a 20th anniversary celebration, and I wasn’t invited to the party, but I was at Microsoft that day. There was a party that night at Seattle’s Experience Music Project, and we formed a band – Excelerongs – for a special one-night appearance. That’s Dick Kusleika at the left, and I’m 3rd from the right.
So take time to celebrate today, and form your own band to sing the praises of Excel.
Excel Roundup 20150928
In this week’s roundup, Excel history, Office 2016 reviews, add-ins to reduce Excel errors, and much more.
When Did You Start Using Excel?
Next Wednesday is the 30th anniversary of Excel’s first release, and I’d love to hear your Excel memories, and share them here next week. The more the merrier, so please take a few minutes to jot down a few memories.
Here are some questions, to help you get started:
Excel Roundup 20150921
In this week’s roundup, avoid nested IF formulas, understand circular references, see bad charts, and much more.