optionexplicitvba.com
Long time no see | Option Explicit VBA
https://optionexplicitvba.com/2015/06/28/long-time-no-see
A blog of Excel, Dashboards, Visual Basic for Applications, Data Analysis, Operations Research, and Visualizations. Long time no see. It’s been a long time since you last heard from me. Several things have happened in my life. Well, first, I had to get a job. My consulting business was doing well, and I was actually pretty good at it (at least, I thought so). But circumstances unforeseen changed what I had to do next; and lo, I had to get a job, you know, a. This entry was posted in Tips. June 28, 2015.
optionexplicitvba.com
Speaking | Option Explicit VBA
https://optionexplicitvba.com/speaking
A blog of Excel, Dashboards, Visual Basic for Applications, Data Analysis, Operations Research, and Visualizations. I provide keynotes, conference presentations, and hands-on workshops in both advanced Excel and in theoretical topics, like making better decisions with data. My schedule is filling up quickly this year, so please reach out as soon as possible if you’re interested in having me speak at your conference or to your team. Contact me for more details. Advanced Excel for Business. Pedro Wave for ...
optionexplicitvba.com
PASS Business Analytics & Free Preview Session Webinar | Option Explicit VBA
https://optionexplicitvba.com/2015/02/11/pass-business-analytics-free-preview-session-webinar
A blog of Excel, Dashboards, Visual Basic for Applications, Data Analysis, Operations Research, and Visualizations. PASS Business Analytics and Free Preview Session Webinar. So there’s been a lot of anticipation about this year’s PASS Business Analytics conference in Santa. Clara, California. There will be a veritable Excel dream team (there words, not mine) presenting at this years conferences including yours truly, Rick, Oz, Rob Collie, Chandoo and more. This entry was posted in Tips. February 11, 2015.
optionexplicitvba.com
data analytics | Option Explicit VBA
https://optionexplicitvba.com/tag/data-analytics
A blog of Excel, Dashboards, Visual Basic for Applications, Data Analysis, Operations Research, and Visualizations. Tag Archives: data analytics. PASS Business Analytics and Free Preview Session Webinar. So there’s been a lot of anticipation about this year’s PASS Business Analytics conference in Santa. Clara, California. There will be a veritable Excel dream team (there words, not mine) presenting at this years conferences including yours truly, Rick, Oz, Rob Collie, Chandoo and more. February 11, 2015.
optionexplicitvba.com
Discussion | Option Explicit VBA
https://optionexplicitvba.com/category/discussion
A blog of Excel, Dashboards, Visual Basic for Applications, Data Analysis, Operations Research, and Visualizations. Three Common Dashboard Mistakes. I recently contributed to the article on MRC’s Cup of Joe Blog called 7 harmful business dashboard mistakes. 2 Bad Data Visualization. BI vendors have convinced us flashy, three-dimensional charts will save our businesses but data visualization research suggests they hurt more than help. Stick with the charts you know and avoid the stuff that looks compl...
optionexplicitvba.com
Jordan G | Option Explicit VBA
https://optionexplicitvba.com/author/jpo645
A blog of Excel, Dashboards, Visual Basic for Applications, Data Analysis, Operations Research, and Visualizations. Author Archives: Jordan G. Three Common Dashboard Mistakes. I recently contributed to the article on MRC’s Cup of Joe Blog called 7 harmful business dashboard mistakes. 2 Bad Data Visualization. BI vendors have convinced us flashy, three-dimensional charts will save our businesses but data visualization research suggests they hurt more than help. Stick with the charts you know and avoid...
optionexplicitvba.com
Colors and Excel | Option Explicit VBA
https://optionexplicitvba.com/2015/01/27/colors-and-excel
A blog of Excel, Dashboards, Visual Basic for Applications, Data Analysis, Operations Research, and Visualizations. The theme colors for Excel 2013 are probably the best scheme to date. However, sometimes I’m looking for another palette for my work. For instance, the colors used in this picture of a decisions support system developed in Advanced Excel Essentials. Are from another palette. For these colors, I use a terrific tool colored Color Brewer, which you can find at ColorBrewer2.org. Just a quick as...
optionexplicitvba.com
Advanced Excel | Option Explicit VBA
https://optionexplicitvba.com/category/advanced-excel
A blog of Excel, Dashboards, Visual Basic for Applications, Data Analysis, Operations Research, and Visualizations. Category Archives: Advanced Excel. Everyday Random Shuffling with Formulas. As Thinking Outside the Cell. I call this the everyday method because it’s technically imperfect. From a statistical standpoint, the results are not uniformly distributed. That means the method isn’t perfectly random at all times. We’ll attend to that later in the article. Step 1. Lay it all out. Here, we’ll use.
optionexplicitvba.com
No VBA | Option Explicit VBA
https://optionexplicitvba.com/category/no-vba
A blog of Excel, Dashboards, Visual Basic for Applications, Data Analysis, Operations Research, and Visualizations. Category Archives: No VBA. Auto highlighting Excel charts. On your dashboards, reports, and charts it’s a good idea to alert the user to certain types of values. In a recent post, we discussed how to alert users to certain records on tables using custom formats. We’ll build upon that here but transition to how we might achieve a similar effect on a chart. Let’s do it! You may have noticed w...
optionexplicitvba.com
free webinar | Option Explicit VBA
https://optionexplicitvba.com/tag/free-webinar
A blog of Excel, Dashboards, Visual Basic for Applications, Data Analysis, Operations Research, and Visualizations. Tag Archives: free webinar. PASS Business Analytics and Free Preview Session Webinar. So there’s been a lot of anticipation about this year’s PASS Business Analytics conference in Santa. Clara, California. There will be a veritable Excel dream team (there words, not mine) presenting at this years conferences including yours truly, Rick, Oz, Rob Collie, Chandoo and more. February 11, 2015.
SOCIAL ENGAGEMENT