Discussion Archives - Page 2 of 2 - Excel TV

Category Archives for Discussion

Excel Bug in Office 365

I’ve found a rather obnoxious bug in the version of Excel 2013 that comes with Office 365. As you know, I’m a big fan of doing stuff with charts. One of my favorite things is to make a dynamic series that disappears based on some user functionality like in the animation below. So far so […]

Continue reading

Book Updates

I figured I’d break hibernation to give everyone a small, quick update on the book. According to the original dates agreed upon in my contract with Apress, I should be close to finishing my book by now. Well, internet, I’m not close at all. I still have a lot more work ahead of me. The […]

Continue reading

Taking a small break

These last few months have been great to this humble blog – and to me, your humble blogger. We’ve received a lot of traffic, especially for posts concerning the rollover method (40k pageviews overall as of today!). Also, I got married in October!  In pains me to tell you this, but I’m taking a break until next […]

Continue reading

Recommendation: Excel School + Excel Hero Academy Bundle

Chandoo (of Chandoo.org) and Daniel Ferry (of ExcelHero.com) are kicking-off their new Excel School and Excel Hero Academy. If you really want to learn Excel—and I mean learn Excel—I recommend their new courses. It’s true; I’ve never taken a course from either of them. However, much of what you see on this website is a direct […]

Continue reading

Investigations in "Illegal Activities" with User Defined Functions

A group of fellow Excel experts who call themselves the Frankens Team were encouraged by the rollover method to investigate other known instances in which Excel has allowed for the impossible; namely, allowing UDFs to change the value of other cells. I invite everyone to view their terrific analysis: Excel formula to change the value of […]

Continue reading

Investigations in "Illegal Activities" with User Defined Functions

A group of fellow Excel experts who call themselves the Frankens Team were encouraged by the rollover method to investigate other known instances in which Excel has allowed for the impossible; namely, allowing UDFs to change the value of other cells. I invite everyone to view their terrific analysis: Excel formula to change the value of […]

Continue reading

The Excel Rollover Mini FAQ

As more people are use the rollover method (or “Interactive Hyperlinks” as Chandoo calls them), I thought it might be helpful to answer common questions I’ve seen popping up on forums. So, in no particular order, I present the Excel Rollover Mini FAQ! 1. Are there example articles and spreadsheets on how to use Excel […]

Continue reading

About Me

A big thank you to everyone! This blog has achieved over 20,000 page views, which is quite an accomplishment for this humble blogger. Looking through my work, I realize that I’ve never formally introduced myself.  So, here goes.  My name is Jordan Goldmeier and I live in Dayton, Ohio. I work for a small start-up […]

Continue reading

Newspapers – Read Your Sources!

Update – Apologies for the bad proofreading job in the original blog post. Before writing this, I had spent the entire day writing a book proposal for a technical publisher. I was a bit burned-out. It’s an exciting time for the United States. In the forthcoming days (possibly tomorrow), the Supreme Court of the United States […]

Continue reading

Spreadsheet Guidelines and Best Practices

Today, I found this journal article, The role of OR [Operations Research] specialists in ‘do it yourself’ spreadsheet development, from the European Journal of Operational Research, by John S Edwards, Paul N Finlay, John M Wilson. The article outlines 20 Guidelines for Spreadsheet Development and 21 Best Practices Points, which I excerpt below. Guidelines for Spreadsheet […]

Continue reading

Miscellaneous Stuff

First, a big thank you to everyone following my blog. Here’s some stuff I’d like to share in no particular order. Stephen Colbert Come to My Wedding We (my fiance and I) want Stephen Colbert to come to our wedding, which is in October of this year. My beautiful and wonderful fiance explains as follows: During the […]

Continue reading

Visualizing.org: Garbage In, Garbage Out

There are a lot of awful visualizations and info graphics floating around the internet. I’ve sent some of the worst I’ve found to my new internet friend, Kaiser Fung, at JunkCharts. His blog hosts a formidable, if unfortunate, collection of chartjunk and he attempts both to make sense of them as well as to provide suggestions on how to make them better.  […]

Continue reading

Find Me at an Upcoming Conference

Later this month, I’ll be attending the INFORMS Conference on Business Analytics and Operations Research in Huntington Beach, California.  Give me a shout if you’re going too.

Continue reading

Toward a Proper Excel Filename Style

Most importantly, use your wordsAn ideal Excel filename should be two or three succinct words and contain few numbers. Current operating systems no longer constrain filename character length, so there is neither excuse for nor cleverness in using shorthand. Capitalize each word as you would a document title.     Only abbreviate proper nounsIf your […]

Continue reading
>