Debra Dalgleish's guest appearances

Debra Dalgleish

Chandoo.org Podcast - Become Awesome in Data Analytics

Mike Alexander

Jordan Goldmeier

Dan Fylstra

Hudhud Cyclone

Paul Woods

Miguel Escobar

OwlTail

In the 5th session of Chandoo.org podcast, we are going to demystify form controls. I am very happy and excited to interview my good friend, fellow Excel MVP, author, blogger and virtual mentor – Debra Dalgleish about this topic.  Before we proceed in to the session, let me remind you: Get new episodes automatically! That is right. Chandoo.org uses latest &amp; most magical software. That means, whenever a podcast goes live, an army of magical fairies carry the sound-waves and bring them right to your mobile phone or tablet. And all you have to do is subscribe.  For iPhone or iPod or iPad: Click here to subscribe. Andriod Phones &amp; Tabs: Click here to subscribe on Stitcher. (You can download Stitcher free app from that link) Windows Phone: For Windows phone, search your podcasts app for our show. Or… As always, you can get latest episodes, show notes &amp; resources from our Podcast page.  What is in this session? In this session we are going to explore form controls, a powerful feature of Excel that makes your workbooks interactive. Debra is a world famous expert on all topics of Excel (especially data validation, pivot tables &amp; form controls) and this session is very entertaining, informative and practical. Special gift for our listeners: In this podcast Debra mentions about her User forms training kit. I highly recommend this product for anyone hoping to learn user forms, data entry forms and form controls. As our podcast listener, if you choose to purchase this training kit, you get  20% discount on Debra’s User Form Training kit (if you buy before April 30th, 2014) Special bonus from me: 14 page guide &amp; practice workbook on form controls  Listen to the podcast to know how to get these. In this podcast, you will learn,  What are form controls When you would use them? Example form control – Combo box How form controls differ from active-x controls How to enable form controls in your Excel? Various important form controls  Combo box Command Button Radio Button Check box Scroll bar &amp; Spin button List box   Compatibility of form controls between various version of Excel Comparison of form controls with other types of interactive features in Excel  Slicers Hyper links VBA   Debra’s favorite form control tip Special bonus &amp; how to obtain it  Go ahead and listen to the show  Links &amp; Resources mentioned in this session: Debra’s website – Contextures.com  Books mentioned:  Beginning Pivot Tables in Excel 2007 Pivot Table Recipe Book  Courses mentioned:  Excel School online training program VBA Classes online training program Debra’s User forms training kit  Articles &amp; Discussion on Form controls  Enabling Developer Toolbar &amp; Form controls in Excel Multiple Selection thru Data validation Dependent Data Validation (Cascading Data Validation) Dependent Data Validation [contextures.com] Multi-selection list boxes – how to use them?  Other types of interactive features in Excel  Introduction to hyperlinks Slicers – how to use them – case study Making your dashboards &amp; reports interactive – detailed guide  Recommended Resource – Debra’s User Form Training Kit If you wish to learn more about user forms, form controls and how they can simplify life for your workbook users, then please consider purchasing Debra’s User Form training kit. It is an eBook + Excel workbook combo that works very well and helps you understand these advanced concepts very easily. Click here to get your copy. Note: You get 20% discount on this if you buy before 30th of April. Listen to podcast for details. Note about links: The links to various books &amp; Debra’s training kit are affiliate links. It means when you click on them &amp; purchase, Chandoo.org receives some commission. I recommend these books because I genuinely love them. I would have recommended even if there is no benefit to me.  Transcript of this session: Download this podcast transcript [PDF] If you enjoy the podcast…, Please do these 2 things. It means a lot me &amp; our community.  Subscribe to our podcast on iTunes Please leave an honest review on iTunes by clicking here.. It will help the show &amp; its rankings immensely. Thank you so much.  Do you use form controls? I use them in almost all my dashboards. They are really easy to set up and use. I also love slicers, hyperlinks, little bit of VBA and any other type of interactive features Excel supports. What about you? Do you use form controls? What is your experience like? Please share using comments. The post CP005: Introduction to Form Controls – an interview with Debra Dalgleish appeared first on Chandoo.org - Learn Excel, Power BI &amp; Charting Online.

<p>In the 5th session of <a href="http://chandoo.org/wp/podcast-sessions/" rel="nofollow" target="_blank">Chandoo.org podcast</a>, we are going to <strong>demystify form controls</strong>.</p> <p>I am very happy and excited to interview my good friend, fellow Excel MVP, author, blogger and virtual mentor – <em><strong>Debra Dalgleish</strong></em> about this topic.</p> <p></p> <p>Before we proceed in to the session, let me remind you:</p> <h3>Get new episodes automatically!</h3> <p>That is right. <a href="http://Chandoo.org" rel="nofollow" target="_blank">Chandoo.org</a> uses latest &amp; most magical software. That means, whenever a podcast goes live, an army of magical fairies carry the sound-waves and bring them right to your mobile phone or tablet. And all you have to do is subscribe.</p> <ul> <li><strong>For iPhone or iPod or iPad: </strong><a href="https://itunes.apple.com/in/podcast/chandoo.org-podcast-become/id835954043?mt=2" rel="nofollow" target="_blank"><strong>Click here to subscribe</strong></a>.</li> <li><strong>Andriod Phones &amp; Tabs:</strong> <a href="http://www.stitcher.com/podcast/chandoo-microsoft-excel-mvp-training-data-analysis-specialist/chandooorg-podcast-become-awesome-in-data-analysis-charting" rel="nofollow" target="_blank">Click here to subscribe on Stitcher</a>. (You can download Stitcher free app from that link)</li> <li><strong>Windows Phone:</strong> For Windows phone, search your podcasts app for our show.</li> <li><strong>Or…</strong> As always, you can get latest episodes, show notes &amp; resources from our <a href="http://chandoo.org/wp/podcast-sessions/" rel="nofollow" target="_blank">Podcast page</a>.</li> </ul> <h3>What is in this session?</h3> <p>In this session we are going to explore form controls, a powerful feature of Excel that makes your workbooks interactive. Debra is a world famous expert on all topics of Excel (especially data validation, pivot tables &amp; form controls) and this session is very entertaining, informative and practical.</p> <strong>Special gift for our listeners:</strong><br/> In this podcast Debra mentions about her User forms training kit. I <em>highly</em> recommend this product for anyone hoping to learn user forms, data entry forms and form controls. As our podcast listener, if you choose to purchase this training kit, you get<p></p> <ul> <li>20% discount on <a href="http://chandoo.org/deb" rel="nofollow" target="_blank">Debra’s User Form Training kit</a> (if you buy before April 30th, 2014)</li> <li>Special bonus from me: 14 page guide &amp; practice workbook on form controls</li> </ul> <p>Listen to the podcast to know how to get these.</p> <p>In this podcast, you will learn,</p> <ul> <li>What are form controls</li> <li>When you would use them?</li> <li>Example form control – Combo box</li> <li>How form controls differ from active-x controls</li> <li>How to enable form controls in your Excel?</li> <li>Various important form controls <ul> <li>Combo box</li> <li>Command Button</li> <li>Radio Button</li> <li>Check box</li> <li>Scroll bar &amp; Spin button</li> <li>List box</li> </ul> </li> <li>Compatibility of form controls between various version of Excel</li> <li>Comparison of form controls with other types of interactive features in Excel <ul> <li>Slicers</li> <li>Hyper links</li> <li>VBA</li> </ul> </li> <li>Debra’s favorite form control tip</li> <li>Special bonus &amp; how to obtain it</li> </ul> <h3>Go ahead and listen to the show</h3> <p></p> <h3>Links &amp; Resources mentioned in this session:</h3> <p><strong><a href="http://contextures.com" rel="nofollow" target="_blank">Debra’s website – Contextures.com</a><br/> </strong></p> <h3>Books mentioned:</h3> <ul> <li><a href="http://www.amazon.com/gp/product/1590598903/ref=as_li_ss_tl?ie=UTF8&amp;camp=1789&amp;creative=390957&amp;creativeASIN=1590598903&amp;linkCode=as2&amp;tag=poinhairdilb-20" rel="nofollow" target="_blank">Beginning Pivot Tables in Excel 2007</a></li> <li><a href="http://www.amazon.com/gp/product/1590596293/ref=as_li_ss_tl?ie=UTF8&amp;camp=1789&amp;creative=390957&amp;creativeASIN=1590596293&amp;linkCode=as2&amp;tag=poinhairdilb-20" rel="nofollow" target="_blank">Pivot Table Recipe Book</a></li> </ul> <h3>Courses mentioned:</h3> <ul> <li><a href="http://chandoo.org/wp/excel-school/" rel="nofollow" target="_blank">Excel School online training program</a></li> <li><a href="http://chandoo.org/wp/vba-classes/" rel="nofollow" target="_blank">VBA Classes online training program</a></li> <li><a href="http://chandoo.org/deb" rel="nofollow" target="_blank">Debra’s User forms training kit</a></li> </ul> <h3>Articles &amp; Discussion on Form controls</h3> <ul> <li><a href="http://chandoo.org/wp/2009/05/26/excel-2007-productivity-tips/" rel="nofollow" target="_blank">Enabling Developer Toolbar &amp; Form controls in Excel</a></li> <li><a href="http://www.contextures.com/excel-data-validation-multiple.html" rel="nofollow" target="_blank">Multiple Selection thru Data validation</a></li> <li><a href="http://chandoo.org/wp/2014/02/25/robust-dynamic-cascading-dropdowns-without-vba/" rel="nofollow" target="_blank">Dependent Data Validation (Cascading Data Validation)</a></li> <li><a href="http://www.contextures.com/exceluserformdependentcomboboxes.html" rel="nofollow" target="_blank">Dependent Data Validation [contextures.com]</a></li> <li><a href="http://www.contextures.com/excel-data-validation-listbox.html" rel="nofollow" target="_blank">Multi-selection list boxes – how to use them?</a></li> </ul> <h3>Other types of interactive features in Excel</h3> <ul> <li><a href="http://chandoo.org/wp/2011/03/31/excel-hyperlinks/" rel="nofollow" target="_blank">Introduction to hyperlinks</a></li> <li><a href="http://chandoo.org/wp/2010/12/08/dynamic-dashboard-video-tutorial/" rel="nofollow" target="_blank">Slicers – how to use them – case study</a></li> <li><a href="http://chandoo.org/wp/2012/08/02/making-dashboards-interactive/" rel="nofollow" target="_blank">Making your dashboards &amp; reports interactive – detailed guide</a></li> </ul> <h3>Recommended Resource – Debra’s User Form Training Kit</h3> <p>If you wish to learn more about user forms, form controls and how they can simplify life for your workbook users, then please consider purchasing Debra’s User Form training kit. It is an eBook + Excel workbook combo that works very well and helps you understand these advanced concepts very easily.</p> <p><a href="http://chandoo.org/deb" rel="nofollow" target="_blank"><strong>Click here to get your copy</strong></a>.</p> <p>Note: You get 20% discount on this if you buy before 30th of April. Listen to podcast for details.</p> <p><small><strong>Note about links: </strong>The links to various books &amp; Debra’s training kit are affiliate links. It means when you click on them &amp; purchase, <a href="http://Chandoo.org" rel="nofollow" target="_blank">Chandoo.org</a> receives some commission. I recommend these books because I genuinely love them. I would have recommended even if there is no benefit to me. </small></p> <h3>Transcript of this session:</h3> <p><a href="https://img.chandoo.org/podcast/cp005-Transcript for Session.pdf" rel="nofollow" target="_blank">Download this podcast transcript</a> [PDF]</p> <h3>If you enjoy the podcast…,</h3> <p>Please do these 2 things. It means a lot me &amp; our community.</p> <ol> <li><a href="https://itunes.apple.com/in/podcast/chandoo.org-podcast-become/id835954043?mt=2" rel="nofollow" target="_blank">Subscribe to our podcast on iTunes</a></li> <li>Please leave an honest review on iTunes by <a href="https://itunes.apple.com/in/podcast/chandoo.org-podcast-become/id835954043" rel="nofollow" target="_blank">clicking here.</a>. It will help the show &amp; its rankings immensely. <strong>Thank you so much.</strong></li> </ol> <h3>Do you use form controls?</h3> <p><em>I use them in al</em>most all my dashboards.<em> </em>They are really easy to set up and use. I also love slicers, hyperlinks, little bit of VBA and any other type of interactive features Excel supports.</p> <p><strong>What about you? </strong>Do you use form controls? What is your experience like? Please share using comments.</p> <p>The post <a href="https://chandoo.org/wp/cp005-form-controls/" rel="nofollow" target="_blank">CP005: Introduction to Form Controls – an interview with Debra Dalgleish</a> appeared first on <a href="https://chandoo.org/wp" rel="nofollow" target="_blank">Chandoo.org - Learn Excel, Power BI &amp; Charting Online</a>.</p>

CP005: Introduction to Form Controls – an interview with Debra Dalgleish