myexcelonline.com
MyExcelOnline Podcast - Get the Excel insights from the Excel experts!
http://www.myexcelonline.com/podcast
Get the Excel insights from the Excel experts! Most Popular Excel Experts On Our Podcast! Bill Jelen - Excel and MrExcel XL Book. Ken Puls - Power Query. Chris Newman - Excel Add-Ins. Zack Barresse - Excel Tables. Oz du Soleil - Data Cleansing. 010: Excel Power Query (Get & Transform) & Data Cleansing Online Course. We talk about the need to clean dirty data and explain the different ways that you can do this, saving…. Play in New Window. We talk about the need to clean … SHOW NOTES. John Campbell is an ...
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
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
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
Spreadsheet Tricks | Option Explicit VBA
https://optionexplicitvba.com/category/spreadsheet-tricks
A blog of Excel, Dashboards, Visual Basic for Applications, Data Analysis, Operations Research, and Visualizations. Category Archives: Spreadsheet Tricks. Enlarging Form Control Option Buttons. In a previous tip, I had complained about form control option buttons. Click here to learn more about the Camera tool. Again, following my previous tip, we can assign each image created by the camera tool to a macro. That macro would change the Selected Index depending upon which button was selected. And the origi...
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.
SOCIAL ENGAGEMENT