So you want a 6 figure data job? In this podcast episode, I am going to share 6 strategies and tactics to land a $100k+ data job.  Episode outline:  My experience of working in a a 6 figure ($100k+) data job 6 strategies Build wide data skillbase Cultivate deep technical skills in 1-2 areas Develop business &amp; functional knowledge Cultivate interpersonal skills &amp; present yourself better Strong Interviewing skills Focus on L    Listen to this episode Subscribe to the Show Resources for this podcast episode In the podcast, I talked about creating a digital wardrobe. My recommended webcam, mic &amp; lights are below: Recommended Webcams:  Premium webcam: Elgato Facecam. I have been using Elgato Facecam for the last few months and just love it. It produces crisp, HD quality images &amp; videos with almost no effort. Get it from Amazon. Budget webcam: If you want a good quality webcam that produces decent video and good light capture, try Logitech c920. This was my primary webcam for more than 4 years and never disappointed me. Get it from Amazon.   Recommended Mics:  Premium mic: If your job involves a lot of talking, I suggest getting a good mic to enhance your voice quality. I use Blue Yeti Mics for my videos and livestreams and just LOVE them. Get it from Amazon. Budget mic: I use the Plantronics Blackwire USB headset on the go and love the voice clarity it produces. Get it from Amazon.  Recommended Lighting:  The best lighting is natural light. So position your seat opposite to a window so that your face is getting natural light at angle. Try using sheer curtains to diffuse the strong direct sunlight. Alternatively get a ringlight if you work from a dark room or away from windows. I suggest this one on Amazon.   The post CP02: Six Tips to get a Six Figure ($100,000+) Data Job appeared first on Chandoo.org - Learn Excel, Power BI &amp; Charting Online.

<p>So you want a 6 figure data job? In this podcast episode, I am going to share 6 strategies and tactics to land a $100k+ data job. </p> <h3>Episode outline:</h3> <ul> <li>My experience of working in a a 6 figure ($100k+) data job</li> <li>6 strategies<br><ul> <li>Build wide data skillbase</li> <li>Cultivate deep technical skills in 1-2 areas</li> <li>Develop business &amp; functional knowledge</li> <li>Cultivate interpersonal skills &amp; present yourself better</li> <li>Strong Interviewing skills</li> <li>Focus on L</li> </ul> </li> </ul> <h3>Listen to this episode</h3> <h3>Subscribe to the Show</h3> <h3>Resources for this podcast episode</h3> <p>In the podcast, I talked about creating a <em>digital wardrobe. </em>My recommended webcam, mic &amp; lights are below:</p> <p><strong>Recommended Webcams:</strong></p> <ul> <li>Premium webcam: <a href="https://amzn.to/45g1nQn" rel="noreferrer noopener nofollow" target="_blank">Elgato Facecam</a>. I have been using Elgato Facecam for the last few months and just love it. It produces crisp, HD quality images &amp; videos with almost no effort. <a href="https://amzn.to/45g1nQn" rel="noreferrer noopener nofollow" target="_blank">Get it from Amazon</a>.</li> <li>Budget webcam: If you want a good quality webcam that produces decent video and good light capture, try <a href="https://amzn.to/3OtWVba" rel="noreferrer noopener nofollow" target="_blank">Logitech c920.</a> This was my primary webcam for more than 4 years and never disappointed me. <a href="https://amzn.to/3OtWVba" rel="noreferrer noopener nofollow" target="_blank">Get it from Amazon</a>. </li> </ul> <p><strong>Recommended Mics:</strong></p> <ul> <li>Premium mic: If your job involves a lot of talking, I suggest getting a good mic to enhance your voice quality. I use <a href="https://amzn.to/3DtOiqF" rel="noreferrer noopener nofollow" target="_blank">Blue Yeti Mics</a> for my videos and livestreams and just LOVE them. <a href="https://amzn.to/3DtOiqF" rel="noreferrer noopener nofollow" target="_blank">Get it from Amazon</a>.</li> <li>Budget mic: I use the <a href="https://amzn.to/474zwnG" rel="noreferrer noopener nofollow" target="_blank">Plantronics Blackwire USB headset</a> on the go and love the voice clarity it produces. <a href="https://amzn.to/474zwnG" rel="noreferrer noopener nofollow" target="_blank">Get it from Amazon</a>.</li> </ul> <p><strong>Recommended Lighting:</strong></p> <ul> <li>The best lighting is natural light. So position your seat opposite to a window so that your face is getting natural light at angle. Try using sheer curtains to diffuse the strong direct sunlight.</li> <li>Alternatively get a ringlight if you work from a dark room or away from windows. <a href="https://amzn.to/3rDpjOW" rel="noreferrer noopener nofollow" target="_blank">I suggest this one on Amazon</a>.</li> </ul> <p></p> <p>The post <a href="https://chandoo.org/wp/cp02-six-tips-to-get-a-six-figure-100000-data-job/" rel="nofollow" target="_blank">CP02: Six Tips to get a Six Figure ($100,000+) Data Job</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>

CP02: Six Tips to get a Six Figure ($100,000+) Data Job

Ladies &amp; gentlemen… I have an exciting announcement. I am relaunching my podcast!!! It only took me 7 years, but Chandoo.org podcast is now BACK! I am planning to make regular episodes on Excel, Power BI, SQL &amp; Data Analytics.   Why I am starting it again? Over the last year, I have been thinking about about restarting the podcast. I listen to a lot of podcasts (Tim Ferris show, All-in, Tropical MBA, Office Ladies, YouTube Creators Hub to name a few). They educate, entertain and inspire me. I want to pass along some of those benefits to you. So here we go (again). In this episode… In the 1st episode of Season 2 of Chandoo.org podcast I talk about, Top 5 Excel Skills you need to be a Successful Data Analyst in 2023  What is in this session? In this podcast,  Welcome message Top 5 (Advanced) Excel Skills Tables Power Query Dynamic Arrays &amp; Spill Ranges Pivot Tables &amp; Data Model Charting &amp; Story-telling    Listen to this session Subscribe to the Show Resources for this podcast Comprehensive guides on,  Excel Tables Power Query – Deep introduction Power Query – Mini Course Dynamic Arrays &amp; Spill Ranges Pivot Tables Data Model &amp; Relationships Charting &amp; Story-telling Examples Advanced Excel Skills Top 5 Excel Skills – Video Top 5 Data Skills – Video  The post Top 5 Excel Skills you need to be a Successful Data Analyst in 2023 (podcast) appeared first on Chandoo.org - Learn Excel, Power BI &amp; Charting Online.

<p>Ladies &amp; gentlemen… I have an exciting announcement. I am relaunching my podcast!!!</p> <p>It only took me 7 years, but <a href="https://chandoo.org/wp/category/podcast/" rel="nofollow" target="_blank"><strong>Chandoo.org podcast</strong></a> is now BACK! I am planning to make regular episodes on Excel, Power BI, SQL &amp; Data Analytics. </p> <a href="https://chandoo.org/wp/category/podcast/" rel="nofollow" target="_blank"></a> <h2>Why I am starting it again?</h2> <p>Over the last year, I have been thinking about about restarting the podcast. I listen to a lot of podcasts (Tim Ferris show, All-in, Tropical MBA, Office Ladies, YouTube Creators Hub to name a few). They educate, entertain and inspire me. I want to pass along some of those benefits to you. So here we go (again).</p> <h2>In this episode…</h2> <p>In the 1st episode of Season 2 of <a href="http://Chandoo.org" rel="nofollow" target="_blank">Chandoo.org</a> podcast I talk about, <strong>Top 5 Excel Skills you need to be a Successful Data Analyst in 2023 </strong></p> <h3>What is in this session?</h3> <p>In this podcast,</p> <ul> <li>Welcome message</li> <li>Top 5 (Advanced) Excel Skills<br><ul> <li>Tables</li> <li>Power Query</li> <li>Dynamic Arrays &amp; Spill Ranges</li> <li>Pivot Tables &amp; Data Model</li> <li>Charting &amp; Story-telling</li> </ul> </li> </ul> <h3>Listen to this session</h3> <h3>Subscribe to the Show</h3> <h3>Resources for this podcast</h3> <p><strong>Comprehensive guides on,</strong></p> <ul> <li><a href="https://chandoo.org/wp/data-tables/" rel="nofollow" target="_blank">Excel Tables</a></li> <li><a href="https://chandoo.org/wp/power-query-tutorial/" rel="nofollow" target="_blank">Power Query – Deep introduction</a></li> <li><a href="https://chandoo.org/wp/power-query-power-course/" rel="nofollow" target="_blank">Power Query – Mini Course</a></li> <li><a href="https://chandoo.org/wp/dynamic-array-functions/" rel="nofollow" target="_blank">Dynamic Arrays &amp; Spill Ranges</a></li> <li><a href="https://chandoo.org/wp/excel-pivot-tables-tutorial/" rel="nofollow" target="_blank">Pivot Tables</a></li> <li><a href="https://chandoo.org/wp/introduction-to-excel-2013-data-model-relationships/" rel="nofollow" target="_blank">Data Model &amp; Relationships</a></li> <li><a href="https://chandoo.org/wp/tag/charting-principles/" rel="nofollow" target="_blank">Charting &amp; Story-telling Examples</a></li> <li><a href="https://chandoo.org/wp/advanced-excel-skills/" rel="nofollow" target="_blank">Advanced Excel Skills</a></li> <li><a href="https://youtu.be/cEuq_9CsHIY" rel="nofollow" target="_blank">Top 5 Excel Skills – Video</a></li> <li><a href="https://youtu.be/gVr9f1GJdZc" rel="nofollow" target="_blank">Top 5 Data Skills – Video</a></li> </ul> <p>The post <a href="https://chandoo.org/wp/top-5-excel-skills-you-need-to-be-a-successful-data-analyst-in-2023-podcast/" rel="nofollow" target="_blank">Top 5 Excel Skills you need to be a Successful Data Analyst in 2023 (podcast)</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>

Top 5 Excel Skills you need to be a Successful Data Analyst in 2023 (podcast)

In the 56th episode of Chandoo.org podcast, let me answer the chicken and egg question of Excel users. How many formulas should you care to learn?  What is in this session? In this podcast,  Two personal updates 3 legs of formula writing Function knowledge Operators Referencing   6 categories of must-know functions Basic math Conditions Lookups Text Date &amp; time Work specific   Closing remarks &amp; resources for you  Listen to this session  Click here to download the MP3 file. Resources for learning Formulas Podcast episodes on formulas  All about Excel $@#%%#^^ Mastering aweSUM() formulas of Excel Writing business logic in Excel formulas VTALKUP – learn all about VLOOKUP function VLOOKUP FAQs  Articles to learn important formulas  Top 10 formulas for aspiring analysts Beyond IF &amp; SUM, 15 formulas for everyone  Support Chandoo.org podcast – Give a little thru Patreon I am happy to announce that I have a Patreon page now. If you love my podcast, head to my Patreon page to pledge a little to Chandoo.org. Thanks for your generosity and love. The post CP056: So which formulas you should care to learn? appeared first on Chandoo.org - Learn Excel, Power BI &amp; Charting Online.

<p>In the 56th episode of <a href="http://chandoo.org/wp/podcast-sessions/" rel="nofollow" target="_blank">Chandoo.org podcast</a>, let me answer the chicken and egg question of Excel users. <em><strong>How many formulas should you care to learn?</strong></em></p> <p></p> <h3>What is in this session?</h3> <p>In this podcast,</p> <ul> <li>Two personal updates</li> <li>3 legs of formula writing<br><ul> <li>Function knowledge</li> <li>Operators</li> <li>Referencing</li> </ul> </li> <li>6 categories of must-know functions<br><ul> <li>Basic math</li> <li>Conditions</li> <li>Lookups</li> <li>Text</li> <li>Date &amp; time</li> <li>Work specific</li> </ul> </li> <li>Closing remarks &amp; resources for you</li> </ul> <h3>Listen to this session</h3> <p></p> <p><a href="http://traffic.libsyn.com/chandoo/CP056.mp3" rel="nofollow" target="_blank">Click here to download the MP3 file</a>.</p> <h3>Resources for learning Formulas</h3> <p><strong>Podcast episodes on formulas</strong></p> <ul> <li><a href="http://chandoo.org/wp/2014/12/04/cp026-excel-operators/" rel="nofollow" target="_blank">All about Excel $@#%%#^^</a></li> <li><a href="http://chandoo.org/wp/2014/05/01/cp007-awesum-overview-of-sum-functions-in-excel/" rel="nofollow" target="_blank">Mastering aweSUM() formulas of Excel</a></li> <li><a href="http://chandoo.org/wp/2015/01/22/cp028-how-to-tell-business-logic-rules-to-excel/" rel="nofollow" target="_blank">Writing business logic in Excel formulas</a></li> <li><a href="http://chandoo.org/wp/2014/03/13/cp002-vtalkup-5-excel-lookup-functions-demystified-4-resources-for-you/" rel="nofollow" target="_blank">VTALKUP – learn all about VLOOKUP function</a></li> <li><a href="http://chandoo.org/wp/2016/01/07/vlookup-faqs/" rel="nofollow" target="_blank">VLOOKUP FAQs</a></li> </ul> <p><strong>Articles to learn important formulas</strong></p> <ul> <li><a href="http://chandoo.org/wp/2013/01/16/top-10-formulas-for-aspiring-analysts/" rel="nofollow" target="_blank">Top 10 formulas for aspiring analysts</a></li> <li><a href="http://chandoo.org/wp/2008/08/13/15-microsoft-excel-formulas/" rel="nofollow" target="_blank">Beyond IF &amp; SUM, 15 formulas for everyone</a></li> </ul> <h3>Support <a href="http://Chandoo.org" rel="nofollow" target="_blank">Chandoo.org</a> podcast – Give a little thru Patreon</h3> <p>I am happy to announce that I have a Patreon page now. If you love my podcast, head to <strong><a href="https://www.patreon.com/chandoo" rel="noopener nofollow" target="_blank">my Patreon page</a></strong> to pledge a little to <a href="http://Chandoo.org" rel="nofollow" target="_blank">Chandoo.org</a>. Thanks for your generosity and love.</p> <p>The post <a href="https://chandoo.org/wp/which-formulas-to-learn/" rel="nofollow" target="_blank">CP056: So which formulas you should care to learn?</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>

CP056: So which formulas you should care to learn?

Ladies &amp; gentlemen, its time we revived the much loved Chandoo.org podcast. In the 55th episode, I do a lousy imitation of Arnold Schwarzenegger’s famous “I will be back” and tell you why there was such a long gap between episodes, my plans for reviving our podcast and more.  What is in this session? In this podcast,  Why there was such a long gap between last and this episode What next? How to extract every 6th item from a list?  Listen to this session  Click here to download the MP3 file.  Resources for this podcast  Introduction to OFFSET function Introduction to INDEX function Staying away volatile functions Average of every nth value Filter odd or even rows only  Love my podcast? What topics you want to hear in it? Thanks for all your generous support and love so far. I will be broadcasting new episodes twice a month from now. If you want to hear about a particular topic, share your suggestions in the comments area or email me at chandoo.d@gmail.com Press the magic link and get podcasts right in to your earbuds Our podcast is a great place to learn Excel on the go. There are tons of topics and back episodes to keep you busy for next marathon or month of commute. Check out our back catalog or subscribe today.  iTunes / iPhone Android Computer / Browser    The post CP055: “Yes, I am back” edition (and a bonus Excel tip) appeared first on Chandoo.org - Learn Excel, Power BI &amp; Charting Online.

<p>Ladies &amp; gentlemen, its time we revived the much loved <a href="http://chandoo.org/wp/podcast-sessions/" rel="nofollow" target="_blank">Chandoo.org podcast</a>. In the 55th episode, I do a lousy imitation of Arnold Schwarzenegger’s famous “I will be back” and tell you why there was such a long gap between episodes, my plans for reviving our podcast and more.</p> <p></p> <h3>What is in this session?</h3> <p>In this podcast,</p> <ul> <li>Why there was such a long gap between last and this episode</li> <li>What next?</li> <li>How to extract every 6th item from a list?</li> </ul> <h3>Listen to this session</h3> <p></p> <p><a href="http://traffic.libsyn.com/chandoo/CP055.mp3" rel="nofollow" target="_blank">Click here to download the MP3 file</a>.</p> <h3></h3> <h3>Resources for this podcast</h3> <ul> <li><a href="http://chandoo.org/wp/2012/09/17/offset-formula-explained/" rel="nofollow" target="_blank">Introduction to OFFSET function</a></li> <li><a href="http://chandoo.org/wp/2013/09/18/index-formula-usage-and-tips/" rel="nofollow" target="_blank">Introduction to INDEX function</a></li> <li><a href="http://chandoo.org/wp/2014/03/03/handle-volatile-functions-like-they-are-dynamite/" rel="nofollow" target="_blank">Staying away volatile functions</a></li> <li><a href="http://chandoo.org/wp/2013/09/05/calculating-average-of-every-nth-value-formula-tips/" rel="nofollow" target="_blank">Average of every nth value</a></li> <li><a href="http://chandoo.org/wp/2011/01/05/how-to-filter-odd-or-even-rows-only-quick-tips/" rel="nofollow" target="_blank">Filter odd or even rows only</a></li> </ul> <h3>Love my podcast? What topics you want to hear in it?</h3> <p>Thanks for all your generous support and love so far. I will be broadcasting new episodes twice a month from now. If you want to hear about a particular topic, share your suggestions in the comments area or email me at chandoo.d@gmail.com</p> <h3>Press the magic link and get podcasts right in to your earbuds</h3> <p>Our podcast is a great place to learn Excel on the go. There are tons of topics and back episodes to keep you busy for next marathon or month of commute. <strong><a href="http://chandoo.org/wp/podcast-sessions/" rel="nofollow" target="_blank">Check out our back catalog</a></strong> or subscribe today.</p> <ul> <li><a href="https://itunes.apple.com/in/podcast/chandoo.org-podcast-become/id835954043?mt=2" rel="noopener nofollow" target="_blank">iTunes / iPhone</a></li> <li><a href="http://www.stitcher.com/podcast/chandoo-microsoft-excel-mvp-training-data-analysis-specialist/chandooorg-podcast-become-awesome-in-data-analysis-charting" rel="noopener nofollow" target="_blank">Android</a></li> <li><a href="http://chandoo.org/wp/category/podcast/feed/" rel="nofollow" target="_blank">Computer / Browser</a></li> </ul> <p> </p> <p>The post <a href="https://chandoo.org/wp/cp055-yes-i-am-back/" rel="nofollow" target="_blank">CP055: “Yes, I am back” edition (and a bonus Excel tip)</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>

CP055: “Yes, I am back” edition (and a bonus Excel tip)

In the 54th session of Chandoo.org podcast, let’s make you awesome in Pivot Tables.  What is in this session? In this podcast,  Quick updates Top 10 pivot table tricks  Adding same value field twice Tabular layouts GETPIVOTDATA &amp; 2 bonus tricks Relationships &amp; data model One slicer to rule them all Show only top x values Relative performance Show unique count Spruce up with conditional formats Not so ugly pivot charts   Resources &amp; Show notes for you    Listen to this session  Click here to download the MP3 file.  Resources for this podcast Comprehensive guides on,   Excel Pivot Tables intro – Podcast Excel Pivot Tables an introduction Excel Slicers what are they, how to use and advanced tips GETPIVOTDATA examples &amp; usage Relationships &amp; Data model example &amp; downloadable workbook Power Pivot introduction and overview  Pivot Table Tips &amp; Tricks  Use report filters with VBA Structured references for Pivot Tables Group data in Pivot Tables Matching transactions using Pivot Tables Highlight quarters / weekends using styles in Pivot Reports  What are your favorite Pivot Table tricks? Now its your turn. Go ahead and share your favorite pivot table tricks in the comments box.  The post CP054: Top 10 Pivot Table Tricks for YOU appeared first on Chandoo.org - Learn Excel, Power BI &amp; Charting Online.

<p>In the 54th session of <a href="http://chandoo.org/wp/podcast-sessions/" rel="nofollow" target="_blank">Chandoo.org podcast</a>, let’s make you awesome in Pivot Tables.</p> <p></p> <h3>What is in this session?</h3> <p>In this podcast,</p> <ul> <li>Quick updates</li> <li>Top 10 pivot table tricks <ul> <li>Adding same value field twice</li> <li>Tabular layouts</li> <li>GETPIVOTDATA &amp; 2 bonus tricks</li> <li>Relationships &amp; data model</li> <li>One slicer to rule them all</li> <li>Show only top x values</li> <li>Relative performance</li> <li>Show unique count</li> <li>Spruce up with conditional formats</li> <li>Not so ugly pivot charts</li> </ul> </li> <li>Resources &amp; Show notes for you</li> </ul> <p> </p> <h3>Listen to this session</h3> <p></p> <p><a href="http://traffic.libsyn.com/chandoo/CP054.mp3" rel="nofollow" target="_blank">Click here to download the MP3 file</a>.</p> <h3></h3> <h3>Resources for this podcast</h3> <p><strong>Comprehensive guides on,<br/> </strong></p> <ul> <li><a href="http://chandoo.org/wp/2014/08/21/cp018-intro-pivot-tables/" rel="nofollow" target="_blank">Excel Pivot Tables intro – Podcast</a></li> <li><a href="http://chandoo.org/wp/2009/08/19/excel-pivot-tables-tutorial/" rel="nofollow" target="_blank">Excel Pivot Tables</a> <em>an introduction</em></li> <li><a href="http://chandoo.org/wp/2015/06/24/introduction-to-slicers/" rel="nofollow" target="_blank">Excel Slicers</a> <em>what are they, how to use and advanced tips</em></li> <li><a href="http://chandoo.org/wp/2015/08/26/getpivotdata-in-dashboards/" rel="nofollow" target="_blank">GETPIVOTDATA</a> <em>examples &amp; usage</em></li> <li><a href="http://chandoo.org/wp/2013/07/01/introduction-to-excel-2013-data-model-relationships/" rel="nofollow" target="_blank">Relationships &amp; Data model</a> <em>example &amp; downloadable workbook</em></li> <li><a href="http://chandoo.org/wp/2013/01/21/introduction-to-power-pivot/" rel="nofollow" target="_blank">Power Pivot</a> <em>introduction and overview</em></li> </ul> <p><strong>Pivot Table Tips &amp; Tricks<a href="http://chandoo.org/wp/2011/04/27/update-report-filter-macro/" rel="nofollow" target="_blank"></a></strong></p> <ul> <li><a href="http://chandoo.org/wp/2011/04/27/update-report-filter-macro/" rel="nofollow" target="_blank">Use report filters with VBA</a></li> <li><a href="http://chandoo.org/wp/2014/10/18/introducing-structured-references-for-pivottables/" rel="nofollow" target="_blank">Structured references for Pivot Tables</a></li> <li><a href="http://chandoo.org/wp/2009/11/17/group-dates-in-pivot-tables/" rel="nofollow" target="_blank">Group data in Pivot Tables</a></li> <li><a href="http://chandoo.org/wp/2014/06/10/matching-transactions-pivot-tables/" rel="nofollow" target="_blank">Matching transactions using Pivot Tables</a></li> <li><a href="http://chandoo.org/wp/2012/11/08/highlight-quarters-weekends-in-pivot-reports/" rel="nofollow" target="_blank">Highlight quarters / weekends using styles in Pivot Reports</a></li> </ul> <h3>What are your favorite Pivot Table tricks?</h3> <p>Now its your turn. Go ahead and share your favorite pivot table tricks in the comments box.</p> <h3></h3> <p>The post <a href="https://chandoo.org/wp/cp054-top-10-pivot-table-tricks-for-you/" rel="nofollow" target="_blank">CP054: Top 10 Pivot Table Tricks for YOU</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>

CP054: Top 10 Pivot Table Tricks for YOU

In the 53rd session of Chandoo.org podcast, let’s talk about data validation.  What is in this session? In this podcast,  What is data validation How Excel DV compares with database &amp; software DV? Types of data validation rules List &amp; custom rules explained Input &amp; error messages Alternatives to data validation Enhancing data validation Removing data validation rules Homework problem for you Resources &amp; show notes  Listen to this session  Click here to download the MP3 file.  Resources for this podcast Data validation introduction &amp; examples:  Excel basics: How to add drop down box data validation rules? Either-or condition as validation rule Making data validations dynamic VLOOKUP + Data validation = magic Copy data validations using Paste Special, Remove them with Paste Special  Advanced validation examples:  Advanced data validation techniques (custom rules) Unsorted, duplicate column as source Mix conditional formatting with DV for awesome results  Data validation in play – case studies:  Invoice template using data validation To do list with data validation  Additional resources:  Using form controls in Excel Introduction to slicers  Data validation home work – your answer Did you get the answer for homework? Please post your answers / explanations in the comments section. The post CP053: Excel Data Validation for Dummies appeared first on Chandoo.org - Learn Excel, Power BI &amp; Charting Online.

<p>In the 53rd session of <a href="http://chandoo.org/wp/podcast-sessions/" rel="nofollow" target="_blank">Chandoo.org podcast</a>, let’s talk about data validation.</p> <p></p> <h3>What is in this session?</h3> <p>In this podcast,</p> <ul> <li>What is data validation</li> <li>How Excel DV compares with database &amp; software DV?</li> <li>Types of data validation rules</li> <li>List &amp; custom rules explained</li> <li>Input &amp; error messages</li> <li>Alternatives to data validation</li> <li>Enhancing data validation</li> <li>Removing data validation rules</li> <li>Homework problem for you</li> <li>Resources &amp; show notes</li> </ul> <h3>Listen to this session</h3> <p></p> <p><a href="http://traffic.libsyn.com/chandoo/CP053.mp3" rel="nofollow" target="_blank">Click here to download the MP3 file</a>.</p> <h3></h3> <h3>Resources for this podcast</h3> <p><strong><a href="http://chandoo.org/wp/2010/09/13/dynamic-data-validation-excel/" rel="nofollow" target="_blank"></a>Data validation introduction &amp; examples:</strong></p> <ul> <li><a href="http://chandoo.org/wp/2008/08/07/excel-add-drop-down-list/" rel="nofollow" target="_blank">Excel basics: How to add drop down box data validation rules?</a></li> <li><a href="http://chandoo.org/wp/2010/05/04/either-or-data-validation/" rel="nofollow" target="_blank">Either-or condition as validation rule</a></li> <li><a href="http://chandoo.org/wp/2010/09/13/dynamic-data-validation-excel/" rel="nofollow" target="_blank">Making data validations dynamic</a></li> <li><a href="http://chandoo.org/wp/2010/11/01/mix-vlookup-with-data-validation-for-some-magic-vlookup-week/" rel="nofollow" target="_blank">VLOOKUP + Data validation = magic</a></li> <li><a href="http://chandoo.org/wp/2009/10/28/copy-data-validations/" rel="nofollow" target="_blank">Copy data validations using Paste Special</a>, <a href="http://chandoo.org/wp/2011/03/04/quickly-remove-data-validation-rules-using-paste-special/" rel="nofollow" target="_blank">Remove them with Paste Special</a></li> </ul> <p><strong>Advanced validation examples:</strong></p> <ul> <li><a href="http://chandoo.org/wp/2008/11/25/advanced-data-validation-techniques-in-excel-spreadcheats/" rel="nofollow" target="_blank">Advanced data validation techniques (custom rules)</a></li> <li><a href="http://chandoo.org/wp/2010/02/02/data-validation-using-an-unsorted-column-with-duplicate-entries-as-a-source-list/" rel="nofollow" target="_blank">Unsorted, duplicate column as source</a></li> <li><a href="http://chandoo.org/wp/2011/02/07/data-entry-forms-with-conditional-formatting-and-validation/" rel="nofollow" target="_blank">Mix conditional formatting with DV for awesome results</a></li> </ul> <p><strong>Data validation in play – case studies:</strong></p> <ul> <li><a href="http://chandoo.org/wp/2014/03/19/free-invoice-template/" rel="nofollow" target="_blank">Invoice template using data validation</a></li> <li><a href="http://chandoo.org/wp/2013/01/07/todo-list-with-priorities/" rel="nofollow" target="_blank">To do list with data validation</a></li> </ul> <p><strong>Additional resources:</strong></p> <ul> <li><a href="http://chandoo.org/wp/2011/03/30/form-controls/" rel="nofollow" target="_blank">Using form controls in Excel</a></li> <li><a href="http://chandoo.org/wp/2015/06/24/introduction-to-slicers/" rel="nofollow" target="_blank">Introduction to slicers</a></li> </ul> <h3>Data validation home work – your answer</h3> <p>Did you get the answer for homework? Please post your answers / explanations in the comments section.</p> <p>The post <a href="https://chandoo.org/wp/cp053-excel-data-validation-for-dummies/" rel="nofollow" target="_blank">CP053: Excel Data Validation for Dummies</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>

CP053: Excel Data Validation for Dummies

In the 52nd session of Chandoo.org podcast, let’s discuss monkeys, Ok, I am kidding. We are going to talk about M is for Data Monkey book.  What is in this session? In this podcast,  Updates: Why so much gap between episodes? Quick introduction to Power Query Why you should get this book? What is in this book? A very cool example of the techniques you will learn Conclusions  Listen to this session  Click here to download the MP3 file.  Transcript of this session: Download this podcast transcript [PDF] Resources for this podcast M is for Data Monkey book More information &amp;  tutorials on Power Query  Introduction to Power Query – podcast Unpivot data with Power Query [tutorial] Import web data using Power Query  More resources on Power Query  PowerQuery.Training Power Query posts from Chris Webb blog  Courses to help you tackle data problems  Power Query Online Training from Ken &amp; Miguel Big Data &amp; Power Pivot training from Chandoo  What is your favorite Power Query book? Have you read M is for data monkey? How do you like it? What other books on PQ do you read? Please share your opinions and suggestions in the comment box. The post CP052: Book Review – M is for Data Monkey by Ken &amp; Miguel appeared first on Chandoo.org - Learn Excel, Power BI &amp; Charting Online.

<p>In the 52nd session of <a href="http://chandoo.org/wp/podcast-sessions/" rel="nofollow" target="_blank">Chandoo.org podcast</a>, let’s discuss <em><strong>monkeys</strong></em>, Ok, I am kidding. We are going to <em><strong>talk about M is for Data Monkey book.</strong></em></p> <p></p> <h3>What is in this session?</h3> <p>In this podcast,</p> <ul> <li>Updates: Why so much gap between episodes?</li> <li>Quick introduction to Power Query</li> <li>Why you should get this book?</li> <li>What is in this book?</li> <li>A very cool example of the techniques you will learn</li> <li>Conclusions</li> </ul> <h3>Listen to this session</h3> <p></p> <p><a href="http://traffic.libsyn.com/chandoo/CP052.mp3" rel="nofollow" target="_blank">Click here to download the MP3 file</a>.<br/> <a href="http://www.amazon.com/gp/product/B017QL64A0/ref=as_li_tl?ie=UTF8&amp;camp=1789&amp;creative=390957&amp;creativeASIN=B017QL64A0&amp;linkCode=as2&amp;tag=poinhairdilb-20&amp;linkId=BP5JP3PUU5T4K7SM" rel="nofollow" target="_blank"></a></p> <h3>Transcript of this session:</h3> <p><a href="https://img.chandoo.org/podcast/cp052-Transcript for Session.pdf" rel="nofollow" target="_blank">Download this podcast transcript</a> [PDF]</p> <h3>Resources for this podcast</h3> <p><strong><a href="http://amzn.to/1PEnSQV" rel="noopener nofollow" target="_blank">M is for Data Monkey book</a></strong></p> <p><strong>More information &amp;  tutorials on Power Query</strong></p> <ul> <li><a href="http://chandoo.org/session40" rel="nofollow" target="_blank">Introduction to Power Query – podcast</a></li> <li><a href="http://chandoo.org/wp/2015/09/29/unpivot-data-with-power-query/" rel="nofollow" target="_blank">Unpivot data with Power Query [tutorial]</a></li> <li><a href="http://chandoo.org/wp/2015/08/21/import-web-data-power-query/" rel="nofollow" target="_blank">Import web data using Power Query</a></li> </ul> <p><strong>More resources on Power Query</strong></p> <ul> <li><a href="https://www.powerquery.training/" rel="noopener nofollow" target="_blank">PowerQuery.Training</a></li> <li><a href="http://blog.crossjoin.co.uk/category/power-query/" rel="noopener nofollow" target="_blank">Power Query posts from Chris Webb blog</a></li> </ul> <p><strong>Courses to help you tackle data problems</strong></p> <ul> <li><a href="http://chandoo.org/wp/loves/pqt" rel="noopener nofollow" target="_blank">Power Query Online Training from Ken &amp; Miguel</a></li> <li><a href="http://chandoo.org/wp/resources/learn-power-pivot/" rel="nofollow" target="_blank">Big Data &amp; Power Pivot training from Chandoo</a></li> </ul> <h3>What is your favorite Power Query book?</h3> <p>Have you read M is for data monkey? How do you like it? What other books on PQ do you read? Please share your opinions and suggestions in the comment box.</p> <p>The post <a href="https://chandoo.org/wp/m-is-for-data-monkey-book-review/" rel="nofollow" target="_blank">CP052: Book Review – M is for Data Monkey by Ken &amp; Miguel</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>

CP052: Book Review – M is for Data Monkey by Ken & Miguel

In the 51st session of Chandoo.org podcast, let’s discuss most frequently asked questions about VLOOKUP.  What is in this session? In this podcast,  What is VLOOKUP? What happens when VLOOKUP can’t find the value? Should my list be sorted? Is VLOOKUP slower than INDEX + MATCH? What if my list has multiple matches? How to fetch 2nd / 3rd matching item? How to fetch all matching items? How to fetch items matching multiple conditions? How to speed up VLOOKUP? Why doesn’t my VLOOKUP work? What to do in case of errors? Resources for you  Listen to this session  Click here to download the MP3 file. Resources for this podcast 4 Resources to learn lookup functions:  Comprehensive guide to Excel lookup functions VLOOKUP Cheatsheet The VLOOKUP Quiz – test your knowledge Recommended book: The VLOOKUP Book  Other formulas and links mentioned in this podcast:  INDEX formula – introduction, how to use it and why you should use it? INDEX + MATCH formula combination IFERROR Formula What is it, syntax, examples and uses Looking up 2nd or 3rd matching value Looking up based on multiple conditions Ultimate VLOOKUP trick – Multi-condition lookup  Speeding up VLOOKUPs:  Using relationships feature in Excel 2013 Faster VLOOKUPs with sorting  Transcript of this session: Download this podcast transcript [PDF] Want to know more about VLOOKUP? Please ask… Still have questions about VLOOKUP? Please post them in the comments section. I will try to help you. The post CP051: VLOOKUP FAQs – Most frequently asked questions about VLOOKUP – Answered appeared first on Chandoo.org - Learn Excel, Power BI &amp; Charting Online.

<p>In the 51st session of <a href="http://chandoo.org/wp/podcast-sessions/" rel="nofollow" target="_blank">Chandoo.org podcast</a>, let’s discuss <em><strong>most frequently asked questions about VLOOKUP</strong><strong>.</strong></em></p> <p></p> <h3>What is in this session?</h3> <p>In this podcast,</p> <ul> <li>What is VLOOKUP?</li> <li>What happens when VLOOKUP can’t find the value?</li> <li>Should my list be sorted?</li> <li>Is VLOOKUP slower than INDEX + MATCH?</li> <li>What if my list has multiple matches?</li> <li>How to fetch 2nd / 3rd matching item?</li> <li>How to fetch all matching items?</li> <li>How to fetch items matching multiple conditions?</li> <li>How to speed up VLOOKUP?</li> <li>Why doesn’t my VLOOKUP work?</li> <li>What to do in case of errors?</li> <li>Resources for you</li> </ul> <h3>Listen to this session</h3> <p></p> <p><a href="http://traffic.libsyn.com/chandoo/CP051.mp3" rel="nofollow" target="_blank">Click here to download the MP3 file</a>.</p> <h3>Resources for this podcast</h3> <p><strong>4 Resources to learn lookup functions:</strong></p> <ol> <li><a href="http://chandoo.org/wp/2012/03/30/comprehensive-guide-excel-vlookup/" rel="nofollow" target="_blank">Comprehensive guide to Excel lookup functions</a></li> <li><a href="https://img.chandoo.org/d/Cheater_John_Excel_VLOOKUP_Chandoo.zip" rel="noopener nofollow" target="_blank">VLOOKUP Cheatsheet</a></li> <li><a href="http://chandoo.org/wp/excel-problems-challenges/vlookup-quiz/" rel="nofollow" target="_blank">The VLOOKUP Quiz – test your knowledge</a></li> <li><strong>Recommended book:</strong> <a href="http://chandoo.org/wp/resources/the-vlookup-book/" rel="nofollow" target="_blank">The VLOOKUP Book</a></li> </ol> <p><strong>Other formulas and links mentioned in this podcast:</strong></p> <ul> <li><a href="http://chandoo.org/wp/2013/09/18/index-formula-usage-and-tips/" rel="nofollow" target="_blank">INDEX formula – introduction, how to use it and why you should use it?</a></li> <li><a href="http://chandoo.org/wp/2010/11/02/how-to-lookup-values-to-left/" rel="nofollow" target="_blank">INDEX + MATCH formula combination</a></li> <li><a href="http://chandoo.org/wp/2011/03/11/iferror-formula/" rel="nofollow" target="_blank">IFERROR Formula</a> What is it, syntax, examples and uses</li> <li><a href="http://chandoo.org/wp/2010/11/10/vlookup-second-value/" rel="nofollow" target="_blank">Looking up 2nd or 3rd matching value</a></li> <li><a href="http://chandoo.org/wp/2010/11/02/multi-condition-lookup/" rel="nofollow" target="_blank">Looking up based on multiple conditions</a></li> <li><a href="http://chandoo.org/wp/2014/10/28/multi-condition-vlookup/" rel="nofollow" target="_blank">Ultimate VLOOKUP trick – Multi-condition lookup</a></li> </ul> <p><strong>Speeding up VLOOKUPs:</strong></p> <ul> <li><a href="http://chandoo.org/wp/2013/07/01/introduction-to-excel-2013-data-model-relationships/" rel="nofollow" target="_blank">Using relationships feature in Excel 2013</a></li> <li><a href="https://fastexcel.wordpress.com/2012/03/29/vlookup-tricks-why-2-vlookups-are-better-than-1-vlookup/" rel="noopener nofollow" target="_blank">Faster VLOOKUPs with sorting</a></li> </ul> <h3>Transcript of this session:</h3> <p><a href="https://img.chandoo.org/podcast/cp051-Transcript for Session.pdf" rel="nofollow" target="_blank">Download this podcast transcript</a> [PDF]</p> <h3>Want to know more about VLOOKUP? Please ask…</h3> <p>Still have questions about VLOOKUP? Please post them in the comments section. I will try to help you.</p> <p>The post <a href="https://chandoo.org/wp/vlookup-faqs/" rel="nofollow" target="_blank">CP051: VLOOKUP FAQs – Most frequently asked questions about VLOOKUP – Answered</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>

CP051: VLOOKUP FAQs – Most frequently asked questions about VLOOKUP – Answered

This is going to be epic!!! In the 50th session of Chandoo.org podcast, we have 50 Excel tips to make you awesome.  What is in this session? In this podcast,  Thank you message Fifty tips in 5 buckets Shortcuts &amp; Productivity Formulas Managing Data Charts Using Excel better    Listen to this session  Click here to download the MP3 file. Resources for this podcast Keyboard shortcuts:  Top 10 keyboard shortcuts for you – podcast 012 Comprehensive list of Excel keyboard shortcuts 25 Excel tricks to boost your productivity  Formulas:  Top 10 formulas for analysts &amp; managers Beyond SUM &amp; IF – 15 formulas for you Using wild cards in formulas (* &amp;) Formulas discussed in the podcast: SUMIFS SUBTOTAL CHOOSE AND OR – Logical formulas – podcast 028 IFERROR    Managing Data:  Excel Tables – an introduction Using Text to Columns to convert dates Flash fill – an introduction Remove Duplicates – a quick tutorial Go to special – what is so special about it? Introduction to Data model &amp; Relationships in Excel 2013 Power Query – an intro – podcast 040  Charting:  Data bars in Conditional formatting – a case study Sparklines can go right to left Hide ‘0’ in axis Dynamic titles &amp; labels in charts  Using Excel:  How to create custom ribbons in Excel – tutorial Work with charts faster using selection pane How to make gorgeous printable workbooks – podcast 025 Hide away unused rows &amp; columns &amp; 9 more tips to create awesome workbooks  Transcript of this session: Download this podcast transcript [PDF] What is your favorite tip? Now it’s your turn. Which one of the fifty is your favorite? Or do you have something new altogether? Please share in the comments. Spread the love – Review my podcast If you enjoy Chandoo.org podcast, please take a minute and write a review on iTunes. Also, do share this podcast on a colleague / friend. Make them awesome. Send them here: http://chandoo.org/podcast   The post CP050: Fifty Excel Tips to make you awesome appeared first on Chandoo.org - Learn Excel, Power BI &amp; Charting Online.

<p>This is going to be epic!!! In the 50th session of <a href="http://chandoo.org/wp/podcast-sessions/" rel="nofollow" target="_blank">Chandoo.org podcast</a>, <em><strong>we have 50 Excel tips to make you awesome.</strong></em></p> <p></p> <h3>What is in this session?</h3> <p>In this podcast,</p> <ul> <li>Thank you message</li> <li>Fifty tips in 5 buckets<br><ul> <li>Shortcuts &amp; Productivity</li> <li>Formulas</li> <li>Managing Data</li> <li>Charts</li> <li>Using Excel better</li> </ul> </li> </ul> <h3>Listen to this session</h3> <p></p> <p><a href="http://traffic.libsyn.com/chandoo/CP050.mp3" rel="nofollow" target="_blank">Click here to download the MP3 file</a>.</p> <h3>Resources for this podcast</h3> <p><strong>Keyboard shortcuts:</strong></p> <ul> <li><a href="http://chandoo.org/wp/2014/06/26/cp012-top-10-keyboard-shortcuts/" rel="nofollow" target="_blank">Top 10 keyboard shortcuts for you</a> – podcast 012</li> <li><a href="http://chandoo.org/wp/2010/02/22/complete-list-of-excel-shortcuts/" rel="nofollow" target="_blank">Comprehensive list of Excel keyboard shortcuts</a></li> <li><a href="http://chandoo.org/wp/2015/07/07/analyst-productivity-tricks/" rel="nofollow" target="_blank">25 Excel tricks to boost your productivity</a></li> </ul> <p><strong>Formulas:</strong></p> <ul> <li><a href="http://chandoo.org/wp/2013/01/16/top-10-formulas-for-aspiring-analysts/" rel="nofollow" target="_blank">Top 10 formulas for analysts &amp; managers</a></li> <li><a href="http://chandoo.org/wp/2008/08/13/15-microsoft-excel-formulas/" rel="nofollow" target="_blank">Beyond SUM &amp; IF – 15 formulas for you</a></li> <li><a href="http://chandoo.org/wp/2010/11/01/using-wildcards-with-vlookup/" rel="nofollow" target="_blank">Using wild cards in formulas (* &amp;)</a></li> <li>Formulas discussed in the podcast:<br><ul> <li><a href="http://chandoo.org/wp/2010/04/20/introduction-to-excel-sumifs-formula/" rel="nofollow" target="_blank">SUMIFS</a></li> <li><a href="http://chandoo.org/wp/2010/02/09/subtotal-formula-excel/" rel="nofollow" target="_blank">SUBTOTAL</a></li> <li><a href="http://chandoo.org/wp/2014/07/16/introduction-to-choose-function/" rel="nofollow" target="_blank">CHOOSE</a></li> <li><a href="http://chandoo.org/wp/2015/01/22/cp028-how-to-tell-business-logic-rules-to-excel/" rel="nofollow" target="_blank">AND OR – Logical formulas</a> – podcast 028</li> <li><a href="http://chandoo.org/wp/2011/03/11/iferror-formula/" rel="nofollow" target="_blank">IFERROR</a></li> </ul> </li> </ul> <p><strong>Managing Data:</strong></p> <ul> <li><a href="http://chandoo.org/wp/2009/09/10/data-tables/" rel="nofollow" target="_blank">Excel Tables – an introduction</a></li> <li><a href="http://chandoo.org/wp/2010/03/23/text-to-date-convertion/" rel="nofollow" target="_blank">Using Text to Columns to convert dates</a></li> <li><a href="http://chandoo.org/wp/2015/08/01/introduction-to-flash-fill/" rel="nofollow" target="_blank">Flash fill – an introduction</a></li> <li><a href="http://chandoo.org/wp/2015/08/07/remove-duplicate-combinations/" rel="nofollow" target="_blank">Remove Duplicates – a quick tutorial</a></li> <li><a href="http://chandoo.org/wp/2012/03/12/go-to-special/" rel="nofollow" target="_blank">Go to special – what is so special about it?</a></li> <li><a href="http://chandoo.org/wp/2013/07/01/introduction-to-excel-2013-data-model-relationships/" rel="nofollow" target="_blank">Introduction to Data model &amp; Relationships in Excel 2013</a></li> <li><a href="http://chandoo.org/wp/2015/07/30/intro-to-power-query-podcast/" rel="nofollow" target="_blank">Power Query – an intro</a> – podcast 040</li> </ul> <p><strong>Charting:</strong></p> <ul> <li><a href="http://chandoo.org/wp/2014/03/10/best-charts-to-show-progress/" rel="nofollow" target="_blank">Data bars in Conditional formatting – a case study</a></li> <li><a href="http://chandoo.org/wp/2015/08/02/dynamic-sparklines/" rel="nofollow" target="_blank">Sparklines can go right to left</a></li> <li><a href="http://chandoo.org/wp/2009/12/14/how-to-hide-0-in-chart-axis/" rel="nofollow" target="_blank">Hide ‘0’ in axis</a></li> <li><a href="http://chandoo.org/wp/2015/08/19/descriptive-titles-on-charts/" rel="nofollow" target="_blank">Dynamic titles &amp; labels in charts</a></li> </ul> <p><strong>Using Excel:</strong></p> <ul> <li><a href="http://chandoo.org/wp/2015/08/05/custom-ribbons/" rel="nofollow" target="_blank">How to create custom ribbons in Excel – tutorial</a></li> <li><a href="http://chandoo.org/wp/2015/08/14/using-selection-pane-select-object-tools/" rel="nofollow" target="_blank">Work with charts faster using selection pane</a></li> <li><a href="http://chandoo.org/wp/2014/11/06/cp025-sexy-on-spreadsheet-ugly-on-printout/" rel="nofollow" target="_blank">How to make gorgeous printable workbooks</a> – podcast 025</li> <li><a href="http://chandoo.org/wp/2009/11/03/make-better-excel-sheets/" rel="nofollow" target="_blank">Hide away unused rows &amp; columns &amp; 9 more tips to create awesome workbooks</a></li> </ul> <h3>Transcript of this session:</h3> <p><a href="https://img.chandoo.org/podcast/cp050-Transcript for Session.pdf" rel="nofollow" target="_blank">Download this podcast transcript</a> [PDF]</p> <h3>What is your favorite tip?</h3> <p>Now it’s your turn. Which one of the fifty is your favorite? Or do you have something new altogether? Please share in the comments.</p> <h3>Spread the love – Review my podcast</h3> <p>If you enjoy <a href="http://Chandoo.org" rel="nofollow" target="_blank">Chandoo.org</a> podcast, please take a minute and <a href="https://itunes.apple.com/in/podcast/chandoo.org-podcast-become/id835954043" rel="noopener nofollow" target="_blank">write a review on iTunes</a>.</p> <p>Also, do share this podcast on a colleague / friend. Make them awesome. Send them here: <strong><a href="http://chandoo.org/podcast" rel="noopener nofollow" target="_blank">http://chandoo.org/podcast</a></strong></p> <p> </p> <p>The post <a href="https://chandoo.org/wp/cp050-fifty-excel-tips/" rel="nofollow" target="_blank">CP050: Fifty Excel Tips to make you awesome</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>

CP050: Fifty Excel Tips to make you awesome

In the 49th session of Chandoo.org podcast, let’s talk about data dumps!  What is in this session? In this podcast,  What is a data dump Examples of data dump Why we dump Ways to avoid data dumps Go for information dumps Sort the dump Filter the dump Give a table   Resources for you  Listen to this session  Click here to download the MP3 file. Resources for making animated charts Making better charts in Excel:  How to select right type of chart for your data Why 3D pie charts are evil  Charting podcasts:  CP029 – Impress your boss with awesome charts – 6 step road map CP032 – Rules for creating legendary column charts CP038 – Data to Ink Ratio – What is it and how to optimize it  Transcript of this session: Download this podcast transcript [PDF] Come across any data dumps? Share your story… Now it’s your turn. Do you come across any data dumps in your line work? Share the story in the comments section. Dump some love – Review my podcast If you enjoy Chandoo.org podcast, please take a minute and write a review on iTunes. Also, do dump this podcast on a colleague / friend. Make them awesome. Send them here: http://chandoo.org/podcast   The post CP049: Don’t do data dumps!!! appeared first on Chandoo.org - Learn Excel, Power BI &amp; Charting Online.

<p>In the 49th session of <a href="http://chandoo.org/wp/podcast-sessions/" rel="nofollow" target="_blank">Chandoo.org podcast</a>, <em><strong>let’s talk about data dumps!</strong></em></p> <p></p> <h3>What is in this session?</h3> <p>In this podcast,</p> <ul> <li>What is a data dump</li> <li>Examples of data dump</li> <li>Why we dump</li> <li>Ways to avoid data dumps<br><ul> <li>Go for information dumps</li> <li>Sort the dump</li> <li>Filter the dump</li> <li>Give a table</li> </ul> </li> <li>Resources for you</li> </ul> <h3>Listen to this session</h3> <p></p> <p><a href="http://traffic.libsyn.com/chandoo/CP049.mp3" rel="nofollow" target="_blank">Click here to download the MP3 file</a>.</p> <h3>Resources for making animated charts</h3> <p><strong>Making better charts in Excel:</strong></p> <ul> <li><a href="http://chandoo.org/wp/2010/04/19/chart-selection-process/" rel="nofollow" target="_blank">How to select right type of chart for your data</a></li> <li><a href="http://chandoo.org/wp/2013/04/12/why-3d-pie-charts-are-evil/" rel="nofollow" target="_blank">Why 3D pie charts are evil</a></li> </ul> <p><strong>Charting podcasts:</strong></p> <ul> <li><a href="http://chandoo.org/session29" rel="nofollow" target="_blank">CP029 – Impress your boss with awesome charts – 6 step road map</a></li> <li><a href="http://chandoo.org/session32" rel="nofollow" target="_blank">CP032 – Rules for creating legendary column charts</a></li> <li><a href="http://chandoo.org/session38" rel="nofollow" target="_blank">CP038 – Data to Ink Ratio – What is it and how to optimize it</a></li> </ul> <h3>Transcript of this session:</h3> <p><a href="https://img.chandoo.org/podcast/cp049-Transcript for Session.pdf" rel="nofollow" target="_blank">Download this podcast transcript</a> [PDF]</p> <h3>Come across any data dumps? Share your story…</h3> <p>Now it’s your turn. Do you come across any data dumps in your line work? Share the story in the comments section.</p> <h3>Dump some love – Review my podcast</h3> <p>If you enjoy <a href="http://Chandoo.org" rel="nofollow" target="_blank">Chandoo.org</a> podcast, please take a minute and <a href="https://itunes.apple.com/in/podcast/chandoo.org-podcast-become/id835954043" rel="noopener nofollow" target="_blank">write a review on iTunes</a>.</p> <p>Also, do dump this podcast on a colleague / friend. Make them awesome. Send them here: <strong><a href="http://chandoo.org/podcast" rel="noopener nofollow" target="_blank">http://chandoo.org/podcast</a></strong></p> <p> </p> <p>The post <a href="https://chandoo.org/wp/cp049-dont-do-data-dumps/" rel="nofollow" target="_blank">CP049: Don’t do data dumps!!!</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>

CP049: Don’t do data dumps!!!

Want to be an AWESOME DATA ANALYST? Chandoo.org Podcast is the place to go. Learn how to use popular Data Analytics software like Power BI, Excel, SQL and more with your host Chandoo – an award winning author, speaker and YouTuber.

I listen to this podcast on my commute. It absolutely makes me a more valuable worker.

Awesome podcast!!! Great for career

I love the variety of guests and book suggestions. Thank you!

Excellent Content

Want to be an AWESOME DATA ANALYST? <a href="http://Chandoo.org" rel="nofollow" target="_blank">Chandoo.org</a> Podcast is the place to go. Learn how to use popular Data Analytics software like Power BI, Excel, SQL and more with your host Chandoo – an award winning author, speaker and YouTuber.

Chandoo.org Podcast - Become Awesome in Data Analytics

In the 29th session of Chandoo.org podcast, let’s impress the boss with Excel charts.  What is in this session? Many Excel charts live a short life. They spawn in an ambitious analyst’s spreadsheet. They go to boss with literally flying colors. The boss frowns, they disappear in to recycle bin. Don’t curse your Excel charts with short life span. Here is a 6 step road map to help you create awesome Excel charts, everytime. That is our topic for this podcast session. In this podcast, you will learn  Quick announcements about 50 ways &amp; Einstein 6 step road map for charting success ONE: Dig your data TWO: Validate insights THREE: Pick charts that go well FOUR: Add title &amp; message FIVE: Remove clutter SIX: Prompt action A real life example with road map in action Resources for creating awesome charts  Listen to this session  Click here to download the MP3 file.   Links &amp; Resources mentioned in this podcast 50 ways to analyze data course:  Join the waiting list Course launching on 11th of Feb  Book recommendation   Albert Einstein – his life &amp; universe by Walter Isaacson  Chart creation process &amp; tips:  Selecting right chart for your data Tips for creating awesome column charts Best charts to depict % progress Never use simple numbers in your dashboards More charting principles &amp; chart examples  Additional resources for charting:  Dashboard contest entries &amp; winners – 2014, 2012, 2011, 2010 NY Times visualization lab Charting tutorials &amp; best practices from Jon Peltier Advanced Excel chart examples from Roberto et al  Transcript of this session: Download this podcast transcript [PDF]. How do you impress your boss with charts? My personal favorites are interactive charts &amp; dashboard displays. What about you? How do you impress your boss with Excel charts? What techniques &amp; process you follow? Please share your thoughts and tips in comments. Subscribe to our podcast and get latest episodes automatically Use below link to add our podcast to iTunes. For other options (Android, Windows phone or RSS) click the link below. Thank you.  Other options to subscribe The post CP029: Impress your boss with Excel charts – 6 step road map for you appeared first on Chandoo.org - Learn Excel, Power BI &amp; Charting Online.

<p>In the 29th session of <a href="http://chandoo.org/wp/podcast-sessions/" rel="nofollow" target="_blank">Chandoo.org podcast</a>, let’s <em><strong>impress the boss with Excel charts</strong><strong>.</strong></em></p> <p></p> <h3>What is in this session?</h3> <p><em>Many Excel charts live a short life.</em> They spawn in an ambitious analyst’s spreadsheet. They go to boss with <em>literally </em>flying colors. The boss frowns, they disappear in to recycle bin.</p> <p>Don’t curse your Excel charts with short life span.</p> <p>Here is a 6 step road map to help you create awesome Excel charts, <em>everytime.</em></p> <p><strong>That is our topic for this podcast session.</strong></p> <p>In this podcast, you will learn</p> <ul> <li>Quick announcements about 50 ways &amp; Einstein</li> <li>6 step road map for charting success</li> <li>ONE: Dig your data</li> <li>TWO: Validate insights</li> <li>THREE: Pick charts that go well</li> <li>FOUR: Add title &amp; message</li> <li>FIVE: Remove clutter</li> <li>SIX: Prompt action</li> <li>A real life example with road map in action</li> <li>Resources for creating awesome charts</li> </ul> <h3>Listen to this session</h3> <p></p> <p><a href="http://traffic.libsyn.com/chandoo/CP029.mp3" rel="nofollow" target="_blank">Click here to download the MP3 file</a>.</p> <p> </p> <h3>Links &amp; Resources mentioned in this podcast</h3> <p><strong>50 ways to analyze data course:</strong></p> <ul> <li><a href="http://forms.aweber.com/form/95/1834602295.htm" rel="nofollow" target="_blank">Join the waiting list</a></li> <li>Course launching on 11th of Feb</li> </ul> <p><strong>Book recommendation </strong></p> <ul> <li><a href="http://www.amazon.com/gp/product/0743264746/ref=as_li_tl?ie=UTF8&amp;camp=1789&amp;creative=390957&amp;creativeASIN=0743264746&amp;linkCode=as2&amp;tag=poinhairdilb-20&amp;linkId=WGER5HBN5BMCV2Q3" rel="nofollow" target="_blank">Albert Einstein – his life &amp; universe</a> by <em>Walter Isaacson</em></li> </ul> <p><strong>Chart creation process &amp; tips:</strong></p> <ul> <li><a href="http://chandoo.org/wp/2010/04/19/chart-selection-process/" rel="nofollow" target="_blank">Selecting right chart for your data</a></li> <li><a href="http://chandoo.org/wp/2013/08/29/rules-for-making-awesome-column-charts/" rel="nofollow" target="_blank">Tips for creating awesome column charts</a></li> <li><a href="http://chandoo.org/wp/2014/03/10/best-charts-to-show-progress/" rel="nofollow" target="_blank">Best charts to depict % progress</a></li> <li><a href="http://chandoo.org/wp/2013/07/11/never-use-simple-numbers-in-your-dashboards/" rel="nofollow" target="_blank">Never use simple numbers in your dashboards</a></li> <li><strong><a href="http://chandoo.org/wp/tag/charting-principles/" rel="nofollow" target="_blank">More charting principles</a> &amp; <a href="http://chandoo.org/wp/category/visualization/" rel="nofollow" target="_blank">chart examples</a></strong></li> </ul> <p><strong>Additional resources for charting:</strong></p> <ul> <li>Dashboard contest entries &amp; winners – <a href="http://chandoo.org/wp/2014/06/12/state-migration-dashboard-contest-entries/" rel="nofollow" target="_blank">2014</a>, <a href="http://chandoo.org/wp/2012/07/30/excel-salary-survey-contest-results/" rel="nofollow" target="_blank">2012</a>, <a href="http://chandoo.org/wp/2011/06/30/sales-analysis-charts-in-excel/" rel="nofollow" target="_blank">2011</a>, <a href="http://chandoo.org/wp/2010/01/04/sales-dashboards/" rel="nofollow" target="_blank">2010</a></li> <li><a href="http://www.nytimes.com/interactive/2014/12/29/us/year-in-interactive-storytelling.html" rel="nofollow" target="_blank">NY Times visualization lab</a></li> <li><a href="http://peltiertech.com/" rel="nofollow" target="_blank">Charting tutorials &amp; best practices</a> from Jon Peltier</li> <li><a href="https://sites.google.com/site/e90e50charts/" rel="nofollow" target="_blank">Advanced Excel chart examples</a> from Roberto <em>et al</em></li> </ul> <h3>Transcript of this session:</h3> <p><a href="https://img.chandoo.org/podcast/cp029-Transcript%20for%20Session.pdf" rel="nofollow" target="_blank">Download this podcast transcript</a> [PDF].</p> <h3>How do you impress your boss with charts?</h3> <p>My personal favorites are interactive charts &amp; dashboard displays.</p> <p><strong>What about you? </strong>How do you impress your boss with Excel charts? What techniques &amp; process you follow? Please share your thoughts and tips in comments.</p> <h3>Subscribe to our podcast and get latest episodes automatically</h3> <p>Use below link to add our podcast to iTunes. For other options (Android, Windows phone or RSS) click the link below. Thank you.</p> <p><a href="https://itunes.apple.com/us/podcast/chandoo.org-podcast-become/id835954043?mt=2" rel="nofollow" target="_blank"></a></p> <p><a href="http://chandoo.org/wp/podcast-sessions/" rel="nofollow" target="_blank">Other options to subscribe</a></p> <p>The post <a href="https://chandoo.org/wp/cp029-impress-your-boss-with-excel-charts/" rel="nofollow" target="_blank">CP029: Impress your boss with Excel charts – 6 step road map for you</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>

CP029: Impress your boss with Excel charts – 6 step road map for you

In the 6th session of Chandoo.org podcast, we focus on making you a better analyst.  Before we proceed in to the session, let me remind you: Subscribe to Chandoo.org Podcast Do you know that you can subscribe and receive latest episodes of our podcast right to your ears? Use one of the below links to get started.  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? One of the most popular questions I get, goes like this: I recently became an analyst. I want to succeed in my work. How do I go about it? So in this episode, lets explore the road map to becoming a better analyst. In this podcast, you will learn,  Announcement about Easter Egg hunt Why become a better analyst? The road map for becoming a better analyst – BETTER framework B for Business Knowledge E for Examining user needs T for Thinking about analysis T for Tools of Trade ie Excel E for Expression R for Refining yourself Conclusions  See the mind-map aside (click on it to expand) to understand the BETTER framework. Go ahead and listen to the show  Links &amp; Resources mentioned in this session: Easter Egg Hunt:  Easter Egg hunt 2014 Previous years: 2013, 2012, 2011, 2010 &amp; 2009.  Courses mentioned:  Excel School online training program VBA Classes online training program Power Pivot online classes  Case Studies  How does a rock star Business Analyst use Excel  Resources to learn Excel  Functions Frequently used Excel functions – Reference Top 10 formulas for Analysts Excel formula crash course   Understanding Data Excel Tables Introduction to Tables Using Tables – Video 1, Video 2   Ad-hoc Analysis Tools in Excel Pivot Tables Filters Slicers   Charting &amp; Reporting How to choose right type of chart for your needs? Example Charts Dashboards – tutorials &amp; information   Automation &amp; VBA Introduction to VBA &amp; Automation [5 part crash course] Report Automation using VBA – Example    Making Interactive Charts in Excel  Making your dashboards &amp; reports interactive – detailed guide  Spreadsheet Errors &amp; Auditing  Handling Errors in Spreadsheets Using IFERROR function Spreadsheet Auditing &amp; Risk Management – 4 part article Go to Special – your best friend for spreadsheet auditing  Transcript of this session: Download this podcast transcript [PDF] Are you becoming better analyst? As a CEO of a small company, most of my time is spent on analysis &amp; decision making.  So I am always looking for ways to improve my skills. What about you? How do you become better at your job. Please share your tips, ideas &amp; inspiration in the comments. The post CP006: How to be a better analyst? – Road map for getting better at Data Analysis &amp; Improving your career prospects appeared first on Chandoo.org - Learn Excel, Power BI &amp; Charting Online.

<p>In the 6th session of <a href="http://chandoo.org/wp/podcast-sessions/" rel="nofollow" target="_blank">Chandoo.org podcast</a>, we focu<strong>s on making you a better analyst.</strong></p> <p></p> <p>Before we proceed in to the session, let me remind you:</p> <h3>Subscribe to <a href="http://Chandoo.org" rel="nofollow" target="_blank">Chandoo.org</a> Podcast</h3> <p>Do you know that you can subscribe and receive latest episodes of our podcast right to your ears? Use one of the below links to get started.</p> <ul> <li><strong>For iPhone or iPod or iPad: </strong><a href="https://itunes.apple.com/us/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>One of the most popular questions I get, goes like this:</p> <blockquote><p>I recently became an analyst. I want to succeed in my work. How do I go about it?</p></blockquote> <p>So in this episode, lets explore the road map to becoming a better analyst.</p> <p><a href="https://img.chandoo.org/podcast/cp006-better-analyst-mindmap.png" rel="nofollow" target="_blank"></a>In this podcast, you will learn,</p> <ul> <li>Announcement about Easter Egg hunt</li> <li>Why become a better analyst?</li> <li>The road map for becoming a better analyst – BETTER framework</li> <li>B for Business Knowledge</li> <li>E for Examining user needs</li> <li>T for Thinking about analysis</li> <li>T for Tools of Trade <em>ie </em>Excel</li> <li>E for Expression</li> <li>R for Refining yourself</li> <li>Conclusions</li> </ul> <p><a href="https://img.chandoo.org/podcast/cp006-better-analyst-mindmap.png" rel="nofollow" target="_blank">See the mind-map</a> aside (click on it to expand) to understand the BETTER framework.</p> <h3>Go ahead and listen to the show</h3> <p></p> <h3>Links &amp; Resources mentioned in this session:</h3> <h3>Easter Egg Hunt:</h3> <ul> <li><a href="http://chandoo.org/wp/2014/04/18/easter-eggs-2014/" rel="nofollow" target="_blank">Easter Egg hunt 2014</a></li> <li>Previous years: <a href="http://chandoo.org/wp/2013/03/27/easter-egg-2013/" rel="nofollow" target="_blank">2013</a>, <a href="http://chandoo.org/wp/2012/04/06/easter-eggs-2012/" rel="nofollow" target="_blank">2012</a>, <a href="http://chandoo.org/wp/2011/04/22/chandoo-org-startup-story-2/" rel="nofollow" target="_blank">2011</a>, <a href="http://chandoo.org/wp/2010/04/02/easter-eggs-2010/" rel="nofollow" target="_blank">2010</a> &amp; <a href="http://chandoo.org/wp/2009/04/08/easter-excel/" rel="nofollow" target="_blank">2009</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/wp/resources/learn-power-pivot/" rel="nofollow" target="_blank">Power Pivot online classes</a></li> </ul> <h3>Case Studies</h3> <ul> <li><a href="http://chandoo.org/wp/2011/02/02/business-analysts-excel/" rel="nofollow" target="_blank">How does a rock star Business Analyst use Excel</a></li> </ul> <h3>Resources to learn Excel</h3> <ul> <li>Functions<br><ul> <li><a href="http://chandoo.org/excel-formulas/" rel="nofollow" target="_blank">Frequently used Excel functions – Reference</a></li> <li><a href="http://chandoo.org/wp/2013/01/16/top-10-formulas-for-aspiring-analysts/" rel="nofollow" target="_blank">Top 10 formulas for Analysts</a></li> <li><a href="http://chandoo.org/wp/training-programs/formula-crash-course/" rel="nofollow" target="_blank">Excel formula crash course</a></li> </ul> </li> <li>Understanding Data</li> <li>Excel Tables<br><ul> <li><a href="http://chandoo.org/wp/2009/09/10/data-tables/" rel="nofollow" target="_blank">Introduction to Tables</a></li> <li><a href="http://chandoo.org/wp/2010/11/09/using-lookup-formulas-with-excel-tables-video/" rel="nofollow" target="_blank">Using Tables – Video 1</a>, <a href="http://chandoo.org/wp/excel-tutorial/using-tables/" rel="nofollow" target="_blank">Video 2</a></li> </ul> </li> <li>Ad-hoc Analysis Tools in Excel<br><ul> <li><a href="http://chandoo.org/wp/excel-pivot-tables/" rel="nofollow" target="_blank">Pivot Tables</a></li> <li>Filters</li> <li><a href="http://chandoo.org/wp/2010/12/08/dynamic-dashboard-video-tutorial/" rel="nofollow" target="_blank">Slicers</a></li> </ul> </li> <li>Charting &amp; Reporting<br><ul> <li><a href="http://chandoo.org/wp/2010/04/19/chart-selection-process/" rel="nofollow" target="_blank">How to choose right type of chart for your needs?</a></li> <li><a href="http://chandoo.org/wp/category/visualization/" rel="nofollow" target="_blank">Example Charts</a></li> <li><a href="http://chandoo.org/wp/excel-dashboards/" rel="nofollow" target="_blank">Dashboards – tutorials &amp; information</a></li> </ul> </li> <li>Automation &amp; VBA<br><ul> <li><a href="http://chandoo.org/wp/2011/08/29/introduction-to-vba-macros/" rel="nofollow" target="_blank">Introduction to VBA &amp; Automation [5 part crash course]</a></li> <li><a href="http://chandoo.org/wp/2012/04/02/using-excel-as-your-database/" rel="nofollow" target="_blank">Report Automation using VBA – Example</a></li> </ul> </li> </ul> <h3>Making Interactive Charts in Excel</h3> <ul> <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>Spreadsheet Errors &amp; Auditing</h3> <ul> <li><a href="http://chandoo.org/wp/2009/04/20/excel-formula-errors/" rel="nofollow" target="_blank">Handling Errors in Spreadsheets</a></li> <li><a href="http://chandoo.org/wp/2011/03/11/iferror-formula/" rel="nofollow" target="_blank">Using IFERROR function</a></li> <li><a href="http://chandoo.org/wp/2011/12/07/spreadsheet-risk-management-introduction/" rel="nofollow" target="_blank">Spreadsheet Auditing &amp; Risk Management – 4 part article</a></li> <li><a href="http://chandoo.org/wp/2012/03/12/go-to-special/" rel="nofollow" target="_blank">Go to Special – your best friend for spreadsheet auditing</a></li> </ul> <h3>Transcript of this session:</h3> <p><a href="https://img.chandoo.org/podcast/cp006-Transcript for Session.pdf" rel="nofollow" target="_blank">Download this podcast transcript</a> [PDF]</p> <h3>Are you becoming better analyst?</h3> <p><strong>As a CEO of a small company, most of my time is spent on analysis &amp; decision making.  </strong>So I am always looking for ways to improve my skills.</p> <p><em><strong>What about you?</strong> </em>How do you become better at your job. <strong>Please share your tips, ideas &amp; inspiration in the comments</strong>.</p> <p>The post <a href="https://chandoo.org/wp/cp006-become-better-analyst/" rel="nofollow" target="_blank">CP006: How to be a better analyst? – Road map for getting better at Data Analysis &amp; Improving your career prospects</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>

CP006: How to be a better analyst? – Road map for getting better at Data Analysis & Improving your career prospects

In the 22nd session of Chandoo.org podcast, lets do some macros.    What is in this session? VBA (or macros, automation) is a mystery for many of us. So in this podcast, lets unravel the mystery behind it and get you started with the awesome world of automation. In this podcast, you will learn,  What is a macro? What is VBA then? Reasons for using VBA Macros  Automation Extending Excel’s capabilities Efficiency Applications   How to get started with VBA Macros? Using Recorder Example Macro Going beyond recorder – Learning VBA  Listen to this session    Links &amp; Resources for learning VBA Macros: Getting started with VBA Macros – FREE 5 part crash course  What is VBA &amp; Writing your First VBA Macro in Excel Understanding Variables, Conditions &amp; Loops in VBA Using Cells, Ranges &amp; Other Objects in your Macros Putting it all together – Your First VBA Application using Excel My Top 10 Tips for Mastering VBA &amp; Excel Macros  More tips, information, tutorials &amp; resources on VBA. VBA Example Macros  More than 40 example macros  VBA Video tutorials  Excel VBA Video tutorials  Books for learning VBA  Excel 2010 Power Programming by John Walkenbach Excel VBA for dummies by John Walkenbach More recommended books on VBA  Recommended training program  VBA Classes – Online training from Chandoo.org  Learn from basics to advanced VBA in a self-paced, on-demand online training from me. With more than 24 hrs of video training material, 50 lessons, 50 example macro workbooks, home work exercises, 2 class projects and an online community, you can quickly learn ways to automate your work &amp; save time. Please click here to know more about this program.   Transcript of this session: Download this podcast transcript [PDF]. Are you new to VBA? What is stopping you from learning it? When I first heard about VBA, I was not very interested (as explained in the podcast). But later when I got a job, I realized the potential of VBA and quickly embraced it. What about you? Are you a VBA newbie? What is stopping you from learning it? Please share your fears and difficulties in the comments so that I can help you. The post CP022: What’s a Macro? Introduction to Excel VBA, Macros &amp; Automation appeared first on Chandoo.org - Learn Excel, Power BI &amp; Charting Online.

<p>In the 22nd session of <a href="http://chandoo.org/wp/podcast-sessions/" rel="nofollow" target="_blank">Chandoo.org podcast</a>, lets <em><strong>do some macros. </strong><strong><br/> </strong></em></p> <p></p> <h3>What is in this session?</h3> <p><a href="http://chandoo.org/wp/excel-vba/" rel="nofollow" target="_blank">VBA (or macros, automation)</a> is a mystery for many of us. So in this podcast, lets unravel the mystery behind it and get you started with the awesome world of automation.</p> <p>In this podcast, you will learn,</p> <ul> <li>What is a macro?</li> <li>What is VBA then?</li> <li>Reasons for using VBA Macros <ul> <li>Automation</li> <li>Extending Excel’s capabilities</li> <li>Efficiency</li> <li>Applications</li> </ul> </li> <li>How to get started with VBA Macros?</li> <li>Using Recorder</li> <li>Example Macro</li> <li>Going beyond recorder – Learning VBA</li> </ul> <h3>Listen to this session</h3> <p></p> <p> </p> <h3>Links &amp; Resources for learning VBA Macros:</h3> <p><strong>Getting started with VBA Macros – FREE 5 part crash course</strong></p> <ol> <li><a href="http://chandoo.org/wp/2011/08/29/introduction-to-vba-macros/" rel="nofollow" target="_blank">What is VBA &amp; Writing your First VBA Macro in Excel</a></li> <li><a href="http://chandoo.org/wp/2011/08/30/variables-conditions-loops-in-vba/" rel="nofollow" target="_blank">Understanding Variables, Conditions &amp; Loops in VBA</a></li> <li><a href="http://chandoo.org/wp/2011/08/31/using-objects-in-vba-howto/" rel="nofollow" target="_blank">Using Cells, Ranges &amp; Other Objects in your Macros</a></li> <li><a href="http://chandoo.org/wp/2011/09/02/excel-vba-demo-application/" rel="nofollow" target="_blank">Putting it all together – Your First VBA Application using Excel</a></li> <li><a href="http://chandoo.org/wp/2011/09/06/top-10-tips-for-excel-vba/" rel="nofollow" target="_blank">My Top 10 Tips for Mastering VBA &amp; Excel Macros</a></li> </ol> <p><a href="http://chandoo.org/wp/excel-vba/" rel="nofollow" target="_blank">More tips, information, tutorials &amp; resources on VBA</a>.</p> <p><strong>VBA Example Macros</strong></p> <ul> <li><a href="http://chandoo.org/wp/excel-vba/examples/" rel="nofollow" target="_blank">More than 40 example macros</a></li> </ul> <p><strong>VBA Video tutorials</strong></p> <ul> <li><a href="http://chandoo.org/wp/excel-vba/videos/" rel="nofollow" target="_blank">Excel VBA Video tutorials</a></li> </ul> <p><strong>Books for learning VBA</strong></p> <ul> <li><a href="http://www.amazon.com/gp/product/0470475358/ref=as_li_ss_il?ie=UTF8&amp;tag=poinhairdilb-20&amp;linkCode=as2&amp;camp=1789&amp;creative=390957&amp;creativeASIN=0470475358" rel="nofollow" target="_blank">Excel 2010 Power Programming by John Walkenbach</a></li> <li><a href="http://www.amazon.com/gp/product/0470503696/ref=as_li_ss_il?ie=UTF8&amp;tag=poinhairdilb-20&amp;linkCode=as2&amp;camp=1789&amp;creative=390957&amp;creativeASIN=0470503696" rel="nofollow" target="_blank">Excel VBA for dummies by John Walkenbach</a></li> <li><a href="http://chandoo.org/wp/excel-vba/books/" rel="nofollow" target="_blank">More recommended books on VBA</a></li> </ul> <p><strong>Recommended training program</strong></p> <ul> <li><strong><a href="http://chandoo.org/wp/vba-classes/" rel="nofollow" target="_blank">VBA Classes – Online training from Chandoo.org</a></strong></li> </ul> <p>Learn from basics to advanced VBA in a self-paced, on-demand online training from me. With more than 24 hrs of video training material, 50 lessons, 50 example macro workbooks, home work exercises, 2 class projects and an online community, you can quickly learn ways to automate your work &amp; save time.</p> <p><a href="http://chandoo.org/wp/vba-classes/" rel="nofollow" target="_blank">Please click here to know more about this program</a>.</p> <p> </p> <h3>Transcript of this session:</h3> <p><a href="https://img.chandoo.org/podcast/cp022-Transcript%20for%20Session.pdf" rel="nofollow" target="_blank">Download this podcast transcript </a>[PDF].</p> <h3>Are you new to VBA? What is stopping you from learning it?</h3> <p>When I first heard about VBA, I was not very interested (as explained in the podcast). But later when I got a job, I realized the potential of VBA and quickly embraced it.</p> <p><strong>What about you? </strong>Are you a VBA newbie? What is stopping you from learning it? Please share your fears and difficulties in the comments so that I can help you.</p> <p>The post <a href="https://chandoo.org/wp/cp022-whats-a-macro-introduction-to-excel-vba-macros-automation/" rel="nofollow" target="_blank">CP022: What’s a Macro? Introduction to Excel VBA, Macros &amp; Automation</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>

CP022: What’s a Macro? Introduction to Excel VBA, Macros & Automation

Mike Alexander

In the third session of Chandoo.org podcast, we are going to get BI curious.  Not that kind you silly, We are talking about Business Intelligence, Big Data, Power Pivot &amp; other Power BI family members.  First some good news: We hit #1 on iTunes in our category That is right. Around 14th of March, we hit #1 in our category of podcasts. Yay!!!  Please take a minute to subscribe to our podcast:  Chandoo.org Podcast is on iTunes: Click here to subscribe. Our show is on Stitcher and Windows Phone Podcasts too: Click here to subscribe on Stitcher. For Windows phone, search your podcasts app for our show. As always, you can get latest episodes, show notes &amp; resources from our Podcast page.  What is in this session? In this session, I am happy to feature Mike Alexander – Microsoft MVP, Author, Blogger &amp; a good friend. Mike talks about how Excel is shaping the BI (Business Intelligence) revolution with advent of Power BI functionality. 2 special gifts for our listeners:  10% discount on Mike &amp; Bill’s upcoming Power BI Bootcamp in USA Free Excel Dashboard Tools add-in  Listen to the podcast to know how to get these. You will learn,  Introduction, what Mike is up to these days? What is BI, what does it mean to an average Excel analyst? What BI capabilities Excel has – brief intro to each of them  Power Pivot &amp; what it does Power Query &amp; why it is important Power View &amp; how it works (and where it sucks) Power Maps   How to learn about these new technologies  Recommended Books Websites Courses Live classes   Special gift for our listeners    Go ahead and listen to the show.  Links &amp; Resources mentioned in this session: Mike’s website – Data Pig Technologies Books mentioned   Microsoft BI Tools for Excel Analysts by Mike, Jared &amp; Bernard 101 Ready to use Excel Macros by Mike Alexander Excel Dashboards &amp; Reports by Mike Alexander Power Pivot for the Data Analyst by Bill Jelen DAX Formulas for Power Pivot by Rob Collie Power Pivot Alchemy by Rob Collie &amp; Bill Jelen Author profiles of Chris Webb &amp; Mike Alexander  Power Pivot related articles &amp; resources  Why Excel shines &amp; where it falls compared to other BI tools [PowerPivotPro.com] Introduction to Power Pivot &amp; how to use it?  Add-ins mentioned:  SQL Server Data Mining add-in I could not get a link to the segmentation, clustering add-in I used way back in 2006.  Dashboards mentioned:  Employee Vacation Tracker Dashboard  Courses mentioned:  Online Power Pivot Classes from Chandoo.org PowerPivotPro University Program  Mike &amp; Bill’s upcoming Live Class  Click here to know about Mike’s upcoming Business Intelligence Bootcamp.  Transcript of this session: Click here to download the transcript. Thanks to Mike Thanks Mike for joining me and sharing your knowledge, humor and passion with our podcast community. As always, it was fun talking to you. I look forward to featuring you again in our show sometime. 2 special gifts for our listeners:  10% discount on Mike &amp; Bill’s upcoming Power BI Bootcamp in USA Free Excel Dashboard Tools add-in  Listen to the podcast to know how to get these. 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 Excel’s BI capabilities? Do you use Power Pivot et al? How do you like them? Do you feel these tools empower you &amp; your business? Please share your experiences &amp; thoughts in comments. The post CP003: Business Intelligence for Masses – Interview with Mike Alexander appeared first on Chandoo.org - Learn Excel, Power BI &amp; Charting Online.

<p><strong>In the third session of <a href="http://Chandoo.org" rel="nofollow" target="_blank">Chandoo.org</a> podcast, </strong>we are going to get BI curious. </p> <p>Not that kind you silly, We are talking about Business Intelligence, Big Data, Power Pivot &amp; other Power BI family members.</p> <p></p> <h3>First some good news: We hit #1 on iTunes in our category</h3> <p>That is right. Around 14th of March, we hit #1 in our category of podcasts. Yay!!!</p> <p><a href="https://itunes.apple.com/in/podcast/chandoo.org-podcast-become/id835954043?mt=2" rel="nofollow" target="_blank"></a></p> <p>Please take a minute to subscribe to our podcast:</p> <ul> <li><strong><a href="http://Chandoo.org" rel="nofollow" target="_blank">Chandoo.org</a> Podcast is on iTunes: </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>Our show is on Stitcher and Windows Phone Podcasts too: <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>. For Windows phone, search your podcasts app for our show.</li> <li>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, I am happy to feature Mike Alexander – Microsoft MVP, Author, Blogger &amp; a good friend. Mike talks about how Excel is shaping the BI (Business Intelligence) revolution with advent of Power BI functionality.</p> <strong>2 special gifts for our listeners:</strong><p></p> <ul> <li>10% discount on Mike &amp; Bill’s upcoming Power BI Bootcamp in USA</li> <li>Free Excel Dashboard Tools add-in</li> </ul> <p>Listen to the podcast to know how to get these.</p> <p>You will learn,</p> <ul> <li>Introduction, what Mike is up to these days?</li> <li>What is BI, what does it mean to an average Excel analyst?</li> <li>What BI capabilities Excel has – brief intro to each of them <ul> <li>Power Pivot &amp; what it does</li> <li>Power Query &amp; why it is important</li> <li>Power View &amp; how it works (and where it sucks)</li> <li>Power Maps</li> </ul> </li> <li>How to learn about these new technologies <ul> <li>Recommended Books</li> <li>Websites</li> <li>Courses</li> <li>Live classes</li> </ul> </li> <li>Special gift for our listeners</li> </ul> <p> </p> <h3>Go ahead and listen to the show.</h3> <p></p> <h3>Links &amp; Resources mentioned in this session:</h3> <p><a href="http://datapigtechnologies.com/blog/" rel="nofollow" target="_blank"><strong>Mike’s website – Data Pig Technologies</strong></a></p> <p><strong>Books mentioned<br/> </strong></p> <ul> <li><a href="http://www.amazon.com/gp/product/1118821521/ref=as_li_ss_tl?ie=UTF8&amp;camp=1789&amp;creative=390957&amp;creativeASIN=1118821521&amp;linkCode=as2&amp;tag=poinhairdilb-20" rel="nofollow" target="_blank">Microsoft BI Tools for Excel Analysts</a> by Mike, Jared &amp; Bernard</li> <li><a href="http://www.amazon.com/101-Ready---Use-Excel-Macros/dp/1118281217/ref=la_B001ILHHI8_1_2?s=books&amp;ie=UTF8&amp;qid=1395827289&amp;sr=1-2&amp;tag=poinhairdilb-20" rel="nofollow" target="_blank">101 Ready to use Excel Macros</a> by Mike Alexander</li> <li><a href="http://www.amazon.com/Excel-Dashboards-Reports-Michael-Alexander/dp/1118490428/ref=la_B001ILHHI8_1_3?s=books&amp;ie=UTF8&amp;qid=1395827289&amp;sr=1-3&amp;tag=poinhairdilb-20" rel="nofollow" target="_blank">Excel Dashboards &amp; Reports</a> by Mike Alexander</li> <li><a href="http://www.amazon.com/PowerPivot-Data-Analyst-Microsoft-MrExcel/dp/0789743159/ref=sr_1_sc_1?ie=UTF8&amp;qid=1395827796&amp;sr=8-1-spell&amp;tag=poinhairdilb-20" rel="nofollow" target="_blank">Power Pivot for the Data Analyst</a> by Bill Jelen</li> <li><a href="http://www.amazon.com/DAX-Formulas-PowerPivot-Simple-Revolution/dp/1615470158/ref=pd_sim_b_2?ie=UTF8&amp;&amp;tag=poinhairdilb-20" rel="nofollow" target="_blank">DAX Formulas for Power Pivot</a> by Rob Collie</li> <li><a href="http://www.amazon.com/PowerPivot-Alchemy-Patterns-Techniques-Excel/dp/1615470212/ref=sr_1_3?s=books&amp;ie=UTF8&amp;qid=1395827608&amp;sr=1-3&amp;tag=poinhairdilb-20" rel="nofollow" target="_blank">Power Pivot Alchemy</a> by Rob Collie &amp; Bill Jelen</li> <li>Author profiles of <a href="http://www.amazon.com/Chris-Webb/e/B008KZZH8M/?_encoding=UTF8&amp;camp=1789&amp;creative=390957&amp;linkCode=ur2&amp;qid=1395827531&amp;sr=1-2-ent&amp;tag=poinhairdilb-20" rel="nofollow" target="_blank">Chris Webb</a> &amp; <a href="http://www.amazon.com/Michael-Alexander/e/B001ILHHI8/?_encoding=UTF8&amp;camp=1789&amp;creative=390957&amp;linkCode=ur2&amp;pf_rd_i=507846&amp;pf_rd_m=ATVPDKIKX0DER&amp;pf_rd_p=1688200382&amp;pf_rd_r=110773SXF630WH9Q7MAS&amp;pf_rd_s=center-2&amp;pf_rd_t=101&amp;refinementId=618073011&amp;tag=poinhairdilb-20" rel="nofollow" target="_blank">Mike Alexander</a></li> </ul> <p><strong>Power Pivot related articles &amp; resources</strong></p> <ul> <li><a href="http://www.powerpivotpro.com/2014/01/what-is-power-pivots-1-competitor/" rel="nofollow" target="_blank">Why Excel shines &amp; where it falls compared to other BI tools</a> [<a href="http://PowerPivotPro.com" rel="nofollow" target="_blank">PowerPivotPro.com</a>]</li> <li><a href="http://chandoo.org/wp/2013/01/21/introduction-to-power-pivot/" rel="nofollow" target="_blank">Introduction to Power Pivot &amp; how to use it?</a></li> </ul> <p><strong>Add-ins mentioned:</strong></p> <ul> <li><a href="http://www.microsoft.com/en-in/download/details.aspx?id=29061" rel="nofollow" target="_blank">SQL Server Data Mining add-in</a></li> <li><em>I could not get a link to the segmentation, clustering add-in I used way back in 2006.</em></li> </ul> <p><strong>Dashboards mentioned:</strong></p> <ul> <li><a href="http://chandoo.org/wp/2013/01/24/employee-vacations-tracker-dashboard/" rel="nofollow" target="_blank">Employee Vacation Tracker Dashboard</a></li> </ul> <p><strong>Courses mentioned:</strong></p> <ul> <li><a href="http://chandoo.org/wp/resources/learn-power-pivot/" rel="nofollow" target="_blank">Online Power Pivot Classes from Chandoo.org</a></li> <li><a href="http://www.powerpivotpro.com/powerpivotpro-school/" rel="nofollow" target="_blank">PowerPivotPro University Program</a></li> </ul> <p><strong>Mike &amp; Bill’s upcoming Live Class</strong></p> <ul> <li><a href="https://www.regonline.com/builder/site/default.aspx?EventID=1284865" rel="nofollow" target="_blank"><strong>Click here to know about Mike’s upcoming Business Intelligence Bootcamp</strong></a>.</li> </ul> <h3>Transcript of this session:</h3> <p><a href="https://img.chandoo.org/podcast/cp003-transcript.pdf" rel="nofollow" target="_blank">Click here to download the transcript</a>.</p> <h3>Thanks to Mike</h3> <p>Thanks Mike for joining me and sharing your knowledge, humor and passion with our podcast community. As always, it was fun talking to you. I look forward to featuring you again in our show sometime.</p> <strong>2 special gifts for our listeners:</strong><p></p> <ul> <li>10% discount on Mike &amp; Bill’s upcoming Power BI Bootcamp in USA</li> <li>Free Excel Dashboard Tools add-in</li> </ul> <p>Listen to the podcast to know how to get these.</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 Excel’s BI capabilities?</h3> <p><em>Do you use Power Pivot et al? </em>How do you like them? Do you feel these tools empower you &amp; your business? Please share your experiences &amp; thoughts in comments.</p> <p>The post <a href="https://chandoo.org/wp/cp003-business-intelligence-for-masses-interview-with-mike-alexander/" rel="nofollow" target="_blank">CP003: Business Intelligence for Masses – Interview with Mike Alexander</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>

CP003: Business Intelligence for Masses – Interview with Mike Alexander

In the 42nd session of Chandoo.org podcast, Let’s talk about money. We are going to learn about various concepts that are vital for doing financial analysis and building models.  What is in this session? In this podcast,  Quick announcement about Awesome August 5 key finance concepts Time value of money Compound interest Risk free rate of return Net Present Value – NPV Internal Rate of Return – IRR   Case study – Uber vs. Your car Conclusions  Listen to this session  Click here to download the MP3 file. Resources to learn about financial analysis &amp; modeling Uber vs. Your car – Analysis model Please click here to download the Uber vs. Your car analysis workbook. Finance concepts:  NPV – what is it and how to calculate it in Excel? IRR – how to calculate it? CAGR – how to calculate it? Introduction to financial modeling using Excel – 6 part tutorial  Case studies:  Cost vs. benefit analysis – which bulbs to use? Interactive mortgage calculator How much money you need to retire?  Advanced concepts:  Project finance modeling in Excel – case study Data tables &amp; Montecarlo simulations in Excel – Gold mine case study  Recommended courses:  Financial Modeling school from Chandoo.org – this online course teaches you all the concepts necessary to build full-length valuation &amp; analysis models using Excel 50 Ways to analyze data from Chandoo.org – this online course makes you awesome in all aspects of data analysis, reporting &amp; visual analysis using Excel  Transcript of this session: Download this podcast transcript [PDF] According to you, What are key concepts for financial analysis? I shared my opinion and explained 5 concepts in the podcast. Now its your turn. Tell me what are the key concepts to master if someone needs to learn about financial analysis &amp; modeling? Please share your thoughts and inputs in the comments section. The post CP042: Financial Analysis &amp; Modeling concepts – 101 appeared first on Chandoo.org - Learn Excel, Power BI &amp; Charting Online.

<p>In the 42nd session of <a href="http://chandoo.org/wp/podcast-sessions/" rel="nofollow" target="_blank">Chandoo.org podcast</a>, Let’s talk about money. We are going to learn about various concepts that are vital for doing financial analysis and building models.</p> <p></p> <h3>What is in this session?</h3> <p>In this podcast,</p> <ul> <li>Quick announcement about <a href="http://chandoo.org/wp/resources/awesome-august/" rel="nofollow" target="_blank">Awesome August</a></li> <li>5 key finance concepts<br><ul> <li>Time value of money</li> <li>Compound interest</li> <li>Risk free rate of return</li> <li>Net Present Value – NPV</li> <li>Internal Rate of Return – IRR</li> </ul> </li> <li>Case study – Uber vs. Your car</li> <li>Conclusions</li> </ul> <h3>Listen to this session</h3> <p></p> <p><a href="http://traffic.libsyn.com/chandoo/CP042.mp3" rel="nofollow" target="_blank">Click here to download the MP3 file</a>.</p> <h3>Resources to learn about financial analysis &amp; modeling</h3> <p><strong>Uber vs. Your car – Analysis model</strong></p> <p><a href="https://chandoo.org/wp/wp-content/uploads/2015/08/uber-vs-your-car-model.xlsx" rel="nofollow" target="_blank">Please click here to download the Uber vs. Your car analysis workbook</a>.</p> <p><strong>Finance concepts:</strong></p> <ul> <li><a href="http://chandoo.org/wp/2011/07/05/using-npv-in-excel/" rel="nofollow" target="_blank">NPV – what is it and how to calculate it in Excel?</a></li> <li><a href="http://chandoo.org/wp/2011/10/04/offset-function-to-calculate-irr-for-dynamic-range/" rel="nofollow" target="_blank">IRR – how to calculate it?</a></li> <li><a href="http://chandoo.org/wp/2014/04/29/calculate-cagr-using-excel/" rel="nofollow" target="_blank">CAGR – how to calculate it?</a></li> <li><a href="http://chandoo.org/wp/2010/07/21/financial-modeling-introduction/" rel="nofollow" target="_blank">Introduction to financial modeling using Excel – 6 part tutorial</a></li> </ul> <p><strong>Case studies:</strong></p> <ul> <li><a href="http://chandoo.org/wp/2015/01/28/cost-benefit-analysis-in-excel/" rel="nofollow" target="_blank">Cost vs. benefit analysis – which bulbs to use?</a></li> <li><a href="http://chandoo.org/wp/2010/01/20/mortgage-payment-calculator/" rel="nofollow" target="_blank">Interactive mortgage calculator</a></li> <li><a href="http://chandoo.org/wp/2009/07/29/excel-goal-seek-tutorial/" rel="nofollow" target="_blank">How much money you need to retire?</a></li> </ul> <p><strong>Advanced concepts:</strong></p> <ul> <li><a href="http://chandoo.org/wp/2011/02/08/introduction-to-project-finance-modeling-in-excel/" rel="nofollow" target="_blank">Project finance modeling in Excel – case study</a></li> <li><a href="http://chandoo.org/wp/2010/05/06/data-tables-monte-carlo-simulations-in-excel-a-comprehensive-guide/" rel="nofollow" target="_blank">Data tables &amp; Montecarlo simulations in Excel – Gold mine case study</a></li> </ul> <p><strong>Recommended courses:</strong></p> <ul> <li><a href="http://chandoo.org/wp/financial-modeling/" rel="nofollow" target="_blank"><strong>Financial Modeling school from Chandoo.org</strong></a> – this online course teaches you all the concepts necessary to build full-length valuation &amp; analysis models using Excel</li> <li><strong><a href="http://chandoo.org/wp/resources/50-ways-to-analyze-data/" rel="nofollow" target="_blank">50 Ways to analyze data from Chandoo.org</a> </strong>– this online course makes you awesome in all aspects of data analysis, reporting &amp; visual analysis using Excel</li> </ul> <h3>Transcript of this session:</h3> <p><a href="https://img.chandoo.org/podcast/cp042-Transcript for Session.pdf" rel="nofollow" target="_blank">Download this podcast transcript</a> [PDF]</p> <h3>According to you, What are key concepts for financial analysis?</h3> <p>I shared my opinion and explained 5 concepts in the podcast. Now its your turn.</p> <p><strong>Tell me what are the key concepts to master </strong><em>if someone needs to learn about financial analysis &amp; modeling? </em>Please share your thoughts and inputs in the comments section.</p> <p>The post <a href="https://chandoo.org/wp/financial-analysis-modeling-concepts/" rel="nofollow" target="_blank">CP042: Financial Analysis &amp; Modeling concepts – 101</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>

CP042: Financial Analysis & Modeling concepts – 101

In the 18th session of Chandoo.org podcast, lets loose your Pivot table virginity. Note: This is a short format episode. Less time to listen, but just as much awesome.  First some good news! Our podcast crossed 100k downloads. Yay!!! That is right. It took us 6 months &amp; 17 episodes to reach this milestone. Thanks for loving Chandoo.org podcast. You are awesome. PS: If you have not already subscribed, get it here from iTunes (other ways to subscribe). What is in this session? Pivot tables are a very powerful &amp; quick way to analyze data and get reports from Excel. But surprisingly, not many use them. Today, lets bust your pivot table virginity and understand the concepts like pivoting, values, labels, filters, groups and more. In this podcast, you will learn,  Announcements What is a Pivot Table? Example of business data &amp; reporting needs Terms to understand  Labels Values Groups Filters  Report filters Slicers Label &amp; Value filters     Creating your first pivot table Learning more about pivot tables  Go ahead and listen to the show    Links &amp; Resources mentioned in this session: Excel Pivot Tables – Introduction, Examples, Tutorials &amp; Tips  Introduction &amp; Pivot Table tutorial Examples, Tips, Tutorials &amp; more  Advanced Pivot Table concepts   Introduction to Excel 2013 data model &amp; relationship features Grouping Data in Pivot Tables Report Filters – what are they and how to use them? Slicers – What are they and how to use [example dashboard] Value filters – showing top 10 values  Pivot Table uses &amp; case studies  Show monthly values &amp; % change in one pivot table Matching transactions using pivot tables Calculating conversion ratio using pivot tables Selecting a random sample of data with pivot tables More on Pivot tables  Books &amp; Courses on Pivot Tables  Recommended book: Excel 2013 pivot table data crunching by Mike Alexander &amp; Bill Jelen Recommended course: Excel School online training program     Transcript of this session: Download this podcast transcript [PDF]. You &amp; Pivot tables… tell me all the racy stories I lost my pivot table virginity in 2005. But I quickly regained it as I did not use them much for next 3 years. Then I lost it for good and I am glad for that. Now a days, I use pivot tables almost every week. And they give me quick and easy solutions to many analytical problems I face. What about you? When did you loose your pivot table virginity? How do you use them every day? Please share your tips, stories &amp; experiences in the comments area.   The post CP018: Dont be a Pivot Table Virgin! appeared first on Chandoo.org - Learn Excel, Power BI &amp; Charting Online.

<p>In the 18th session of <a href="http://chandoo.org/wp/podcast-sessions/" rel="nofollow" target="_blank">Chandoo.org podcast</a>, lets <strong>loose your Pivot table virginity</strong>.</p> <p><em>Note: This is a short format episode. Less time to listen, but just as much awesome.</em></p> <p></p> <h3>First some good news!</h3> <p>Our podcast crossed 100k downloads. Yay!!!</p> <p>That is right. It took us 6 months &amp; 17 episodes to reach this milestone.</p> <p>Thanks for loving <a href="http://Chandoo.org" rel="nofollow" target="_blank">Chandoo.org</a> podcast. You are awesome.</p> <p>PS: If you have not already subscribed, <a href="https://itunes.apple.com/us/app/microsoft-excel-for-ipad/id586683407?mt=8" rel="nofollow" target="_blank">get it here from iTunes</a> (<a href="http://chandoo.org/wp/podcast-sessions/" rel="nofollow" target="_blank">other ways to subscribe</a>).</p> <h3>What is in this session?</h3> <p><a href="http://chandoo.org/wp/excel-pivot-tables/" rel="nofollow" target="_blank"><strong>Pivot tables</strong></a> are a very powerful &amp; quick way to analyze data and get reports from Excel. But surprisingly, not many use them. Today, lets bust your pivot table virginity and understand the concepts like pivoting, values, labels, filters, groups and more.</p> <p>In this podcast, you will learn,</p> <ul> <li>Announcements</li> <li>What is a Pivot Table?</li> <li>Example of business data &amp; reporting needs</li> <li>Terms to understand <ul> <li>Labels</li> <li>Values</li> <li>Groups</li> <li>Filters <ul> <li>Report filters</li> <li>Slicers</li> <li>Label &amp; Value filters</li> </ul> </li> </ul> </li> <li>Creating your first pivot table</li> <li>Learning more about pivot tables</li> </ul> <h3>Go ahead and listen to the show</h3> <p></p> <p> </p> <h3>Links &amp; Resources mentioned in this session:</h3> <p><strong>Excel Pivot Tables – Introduction, Examples, Tutorials &amp; Tips</strong></p> <ul> <li><a href="http://chandoo.org/wp/2009/08/19/excel-pivot-tables-tutorial/" rel="nofollow" target="_blank">Introduction &amp; Pivot Table tutorial</a></li> <li><a href="http://chandoo.org/wp/excel-pivot-tables/" rel="nofollow" target="_blank">Examples, Tips, Tutorials &amp; more</a></li> </ul> <p><strong>Advanced Pivot Table concepts<br/> </strong></p> <ul> <li><a href="http://chandoo.org/wp/2013/07/01/introduction-to-excel-2013-data-model-relationships/" rel="nofollow" target="_blank">Introduction to Excel 2013 data model &amp; relationship features</a></li> <li><a href="http://chandoo.org/wp/2009/11/17/group-dates-in-pivot-tables/" rel="nofollow" target="_blank">Grouping Data in Pivot Tables</a></li> <li><a href="http://chandoo.org/wp/2011/04/20/pivot-table-report-filters/" rel="nofollow" target="_blank">Report Filters – what are they and how to use them?</a></li> <li><a href="http://chandoo.org/wp/2010/12/08/dynamic-dashboard-video-tutorial/" rel="nofollow" target="_blank">Slicers – What are they and how to use [example dashboard]</a></li> <li><a href="http://chandoo.org/wp/2010/12/01/top-10-values-in-dashboards/" rel="nofollow" target="_blank">Value filters – showing top 10 values</a></li> </ul> <p><strong>Pivot Table uses &amp; case studies</strong></p> <ul> <li><a href="http://chandoo.org/wp/2012/11/06/monthly-values-and-changes-pivot-table/" rel="nofollow" target="_blank">Show monthly values &amp; % change in one pivot table</a></li> <li><a href="http://chandoo.org/wp/2014/06/10/matching-transactions-pivot-tables/" rel="nofollow" target="_blank">Matching transactions using pivot tables</a></li> <li><a href="http://chandoo.org/wp/2013/03/06/finding-conversion-ratio-using-pivot-table-calculated-items/" rel="nofollow" target="_blank">Calculating conversion ratio using pivot tables</a></li> <li><a href="http://chandoo.org/wp/2014/01/31/how-to-select-a-random-sample-from-all-your-data/" rel="nofollow" target="_blank">Selecting a random sample of data with pivot tables</a></li> <li><a href="http://chandoo.org/wp/tag/pivot-tables/" rel="nofollow" target="_blank">More on Pivot tables</a></li> </ul> <p><strong>Books &amp; Courses on Pivot Tables</strong></p> <ul> <li>Recommended book: <a href="http://www.amazon.com/gp/product/0789748754/ref=as_li_tl?ie=UTF8&amp;camp=1789&amp;creative=390957&amp;creativeASIN=0789748754&amp;linkCode=as2&amp;tag=poinhairdilb-20&amp;linkId=HT6GM2W4SUTDDJPN" rel="nofollow" target="_blank">Excel 2013 pivot table data crunching by Mike Alexander &amp; Bill Jelen</a></li> <li>Recommended course: <a href="http://chandoo.org/wp/excel-school/" rel="nofollow" target="_blank">Excel School online training program </a></li> </ul> <p> </p> <h3>Transcript of this session:</h3> <p><a href="https://img.chandoo.org/podcast/cp018-Transcript%20for%20Session.pdf" rel="nofollow" target="_blank">Download this podcast transcript</a> [PDF].</p> <h3>You &amp; Pivot tables… tell me all the racy stories</h3> <p>I lost my pivot table virginity in 2005. But I quickly regained it as I did not use them much for next 3 years. Then I lost it for good and I am glad for that. Now a days, I use pivot tables almost every week. And they give me quick and easy solutions to many analytical problems I face.</p> <p><strong>What about you?</strong> When did you loose your pivot table virginity? How do you use them every day? Please share your tips, stories &amp; experiences in the comments area.</p> <p> </p> <p>The post <a href="https://chandoo.org/wp/cp018-intro-pivot-tables/" rel="nofollow" target="_blank">CP018: Dont be a Pivot Table Virgin!</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>

CP018: Dont be a Pivot Table Virgin!

Miguel Escobar

In the 40th session of Chandoo.org podcast, Let’s talk about Power Query. I have the pleasure and fortune to catch up with Miguel Escobar (who along with Ken Puls runs PowerQuery.Training website) and talk about this very exciting piece of technology and how it can make our life simpler.  What is in this session? In this podcast,  Welcome Miguel’s introduction, background and current projects What is Power Query How to install it Sample use cases of Power Query What is Power BI Resources for learning Power Query – Books &amp; Courses  Listen to this session  Click here to download the MP3 file. Learn more about Power Query Books: I recommend 2 books for learning more about Power Query.  Power Query for Power BI &amp; Excel by Chris Webb M is for Data Monkey – A guide to M language in Power Query by Ken Puls &amp; Miguel Escobar (pre-order only, release in November 2015)  Online classes: Ken &amp; Miguel regularly run an online class teaching hands-on techniques, implementation guidelines and secrets about Power Query. I have signed up for their next class and eagerly looking forward to it. I recommend going for their class if you want to seriously improve your Power Query skills. Special offer worth $59 for Chandoo.org listeners As a podcast listener, here is a special offer for you from PowerQuery.Training. Use the discount code CHANDOO when signing up for their upcoming live session and get 10% off on the course fees. Click here to signup for their upcoming class. Note: Ken &amp; Miguel are good friends and partners of Chandoo.org. When you join this course from above link, I receive a small commission. I am recommending this course because I genuinely think their program is suitable &amp; awesome for anyone needing Power Query instruction. Transcript of this session: Download this podcast transcript [PDF] Are you using Power Query? What has been your experience with it? I have been playing with Power Query for last 18 months. I really like the technology and what it can do for us, analysts. I regularly use it to clean data, do quick transformations and set up models. What about you? Have you been using Power Query? What is your experience like? Please share your success story in the comments. The post CP040: Intro. to Power Query – What is it and how to get started – with Miguel Escobar appeared first on Chandoo.org - Learn Excel, Power BI &amp; Charting Online.

<p>In the 40th session of <a href="http://chandoo.org/wp/podcast-sessions/" rel="nofollow" target="_blank">Chandoo.org podcast</a>, Let’s talk about Power Query. I have the pleasure and fortune to catch up with Miguel Escobar (who along with Ken Puls runs <a href="http://chandoo.org/wp/loves/pqt" rel="nofollow" target="_blank">PowerQuery.Training</a> website) and talk about this very exciting piece of technology and how it can make our life simpler.</p> <p></p> <h3>What is in this session?</h3> <p>In this podcast,</p> <ul> <li>Welcome</li> <li>Miguel’s introduction, background and current projects</li> <li>What is Power Query</li> <li>How to install it</li> <li>Sample use cases of Power Query</li> <li>What is Power BI</li> <li>Resources for learning Power Query – Books &amp; Courses</li> </ul> <h3>Listen to this session</h3> <p></p> <p><a href="http://traffic.libsyn.com/chandoo/CP040.mp3" rel="nofollow" target="_blank">Click here to download the MP3 file</a>.</p> <h3>Learn more about Power Query</h3> <p><strong>Books:</strong></p> <p>I recommend 2 books for learning more about Power Query.</p> <ul> <li><a href="http://amzn.to/1Sj1tPr" rel="nofollow" target="_blank">Power Query for Power BI &amp; Excel by Chris Webb</a></li> <li><a href="http://amzn.to/1I3p8vq" rel="nofollow" target="_blank">M is for Data Monkey – A guide to M language in Power Query by Ken Puls &amp; Miguel Escobar</a> (pre-order only, release in November 2015)</li> </ul> <p><strong>Online classes:</strong></p> <p>Ken &amp; Miguel regularly run an online class teaching hands-on techniques, implementation guidelines and secrets about Power Query. I have signed up for their next class and eagerly looking forward to it. I recommend going for their class if you want to seriously improve your Power Query skills.</p> <h3>Special offer worth $59 for <a href="http://Chandoo.org" rel="nofollow" target="_blank">Chandoo.org</a> listeners</h3> <p>As a podcast listener, here is a special offer for you from PowerQuery.Training.</p> <p>Use the discount code <em><strong>CHANDOO </strong></em>when signing up for their upcoming live session and get 10% off on the course fees.</p> <p><strong><a href="http://chandoo.org/wp/loves/pqt" rel="nofollow" target="_blank">Click here to signup for their upcoming class</a></strong>.</p> <p>Note: Ken &amp; Miguel are good friends and partners of <a href="http://Chandoo.org" rel="nofollow" target="_blank">Chandoo.org</a>. When you join this course from above link, I receive a small commission. I am recommending this course because I genuinely think their program is suitable &amp; awesome for anyone needing Power Query instruction.</p> <h3>Transcript of this session:</h3> <p><a href="https://img.chandoo.org/podcast/cp040-Transcript for Session.pdf" rel="nofollow" target="_blank">Download this podcast transcript</a> [PDF]</p> <h3>Are you using Power Query? What has been your experience with it?</h3> <p><strong>I have been playing with Power Query for last 18 months. </strong>I really like the technology and what it can do for us, analysts. I regularly use it to clean data, do quick transformations and set up models.</p> <p><strong>What about you? </strong>Have you been using Power Query? What is your experience like? Please share your success story in the comments.</p> <p>The post <a href="https://chandoo.org/wp/intro-to-power-query-podcast/" rel="nofollow" target="_blank">CP040: Intro. to Power Query – What is it and how to get started – with Miguel Escobar</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>

CP040: Intro. to Power Query – What is it and how to get started – with Miguel Escobar

In the 36th session of Chandoo.org podcast, Let’s follow the trend.  What is in this session? In this podcast,  A quick trip to down under What is trend analysis 4 types of common trends linear curve cyclical strange   Doing trend analysis in Excel – the process How to use trend analysis results Conclusions  Listen to this session  Click here to download the MP3 file. Links &amp; Resources mentioned in this podcast Trend Analysis – formulas &amp; chart techniques:  Trend analysis &amp; forecasting – part 1 Trend analysis &amp; forecasting – part 2 Trend analysis &amp; forecasting – part 3  Calculating moving averages in Excel Regression &amp; complex trend analysis: Reference book: Data smart by John Foreman Transcript of this session: Download this podcast transcript [PDF] How do you analyze trends? For my work, I use both cyclical &amp; linear trend analysis techniques. The insights from these help me to optimize my blog posts, understand best times to publish new articles &amp; analyze how well various marketing initiatives are working out. What about you? How do you analyze trends? What techniques do you apply? Please share your tips in the comments area. The post CP036: How to do trend analysis using Excel? appeared first on Chandoo.org - Learn Excel, Power BI &amp; Charting Online.

<p>In the 36th session of <a href="http://chandoo.org/wp/podcast-sessions/" rel="nofollow" target="_blank">Chandoo.org podcast</a>, Let’s follow the trend.</p> <p></p> <h3>What is in this session?</h3> <p>In this podcast,</p> <ul> <li>A quick trip to down under</li> <li>What is trend analysis</li> <li>4 types of common trends<br><ul> <li>linear</li> <li>curve</li> <li>cyclical</li> <li>strange</li> </ul> </li> <li>Doing trend analysis in Excel – the process</li> <li>How to use trend analysis results</li> <li>Conclusions</li> </ul> <h3>Listen to this session</h3> <p></p> <p><a href="http://traffic.libsyn.com/chandoo/CP036.mp3" rel="nofollow" target="_blank">Click here to download the MP3 file</a>.</p> <h3>Links &amp; Resources mentioned in this podcast</h3> <p><b>Trend Analysis – formulas &amp; chart techniques:</b></p> <ul> <li><a href="http://chandoo.org/wp/2011/01/24/trendlines-and-forecasting-in-excel/" rel="nofollow" target="_blank">Trend analysis &amp; forecasting – part 1</a></li> <li><a href="http://chandoo.org/wp/2011/01/26/trendlines-and-forecasting-in-excel-part-2/" rel="nofollow" target="_blank">Trend analysis &amp; forecasting – part 2</a></li> <li><a href="http://chandoo.org/wp/2011/01/27/trendlines-and-forecasting-in-excel-part-3/" rel="nofollow" target="_blank">Trend analysis &amp; forecasting – part 3</a></li> </ul> <p><strong><a href="http://chandoo.org/wp/2009/04/28/calculate-moving-average/" rel="nofollow" target="_blank">Calculating moving averages in Excel</a></strong></p> <p><strong>Regression &amp; complex trend analysis:</strong></p> <p>Reference book: <a href="http://www.amazon.com/gp/product/111866146X/ref=as_li_tl?ie=UTF8&amp;camp=1789&amp;creative=390957&amp;creativeASIN=111866146X&amp;linkCode=as2&amp;tag=poinhairdilb-20&amp;linkId=4T3AMGGABEKOG24A" rel="nofollow" target="_blank">Data smart by John Foreman</a></p> <h3>Transcript of this session:</h3> <p><a href="https://img.chandoo.org/podcast/cp036-Transcript for Session.pdf" rel="nofollow" target="_blank">Download this podcast transcript</a> [PDF]</p> <h3>How do you analyze trends?</h3> <p>For my work, I use both cyclical &amp; linear trend analysis techniques. The insights from these help me to optimize my blog posts, understand best times to publish new articles &amp; analyze how well various marketing initiatives are working out.</p> <p><strong>What about you?</strong> How do you analyze trends? What techniques do you apply? Please share your tips in the comments area.</p> <p>The post <a href="https://chandoo.org/wp/how-to-do-trend-analysis-using-excel/" rel="nofollow" target="_blank">CP036: How to do trend analysis using Excel?</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>

CP036: How to do trend analysis using Excel?

In the 14th session of Chandoo.org podcast, lets figure out how to make awesome dashboards.  What is in this session? Excel dashboards are much in demand these days, thanks to advancements in Excel &amp; growing pressure on costs. Now a days, analysts &amp; managers are expected to quickly put together a dashboard using Excel. But how do you make a dashboard? What process you should follow? These are the questions we address in this podcast. In this podcast, you will learn,  Announcements about upcoming dashboard classes Ten step process for creating awesome dashboards 1. Talk to your end users 2. Make a sketch of the dashboard 3. Validate your understanding 4. Collect data 5. Structure the data …  Go ahead and listen to the show    Links &amp; Resources mentioned in this session: Excelapalooza Excel conference:  Know about this conference Sign-up with 10% discount  Advanced Excel, Dashboards &amp; Power Pivot Masterclass:  Download masterclass brochure Sign-up for the masterclass  Creating Dashboards – complete tutorials:  Creating a KPI Dashboard – 6 part tutorial Customer service dashboard using Excel Employee vacation tracker dashboard More tutorials, examples &amp; information about dashboards  Dashboard Examples &amp; Inspiration:   49 dashboards on State to state migration in USA 66 dashboards visualizing salaries of Excel professionals 32 sales dashboards  78 Sales analytic charts &amp; dashboards More dashboard examples &amp; case studies  Creating Dynamic Charts:  Examples of dynamic charts Introduction to Form controls – article, podcast  Transcript of this session: Download this podcast transcript [PDF]. What process do you follow to create dashboards? I have been following this 10 step process for the last 8 years with great success. Not only this process is easy to follow, but also it reduces the scope of errors significantly. So what about you?What process do you follow when creating dashboards? Please share your thoughts &amp; experiences using comments.  Subscribe to Chandoo.org Podcast  Other options to subscribe The post CP014: How to create awesome dashboards – 10 step process for you appeared first on Chandoo.org - Learn Excel, Power BI &amp; Charting Online.

<p>In the 14th session of <a href="http://chandoo.org/wp/podcast-sessions/" rel="nofollow" target="_blank">Chandoo.org podcast</a>, lets <strong>figure out how to make awesome dashboards</strong>.</p> <p></p> <h3>What is in this session?</h3> <p><a href="http://chandoo.org/wp/excel-dashboards/" rel="nofollow" target="_blank">Excel dashboards</a> are much in demand these days, thanks to advancements in Excel &amp; growing pressure on costs. Now a days, analysts &amp; managers are expected to quickly put together a dashboard using Excel. But <em><strong>how do you make a dashboard? What process you should follow?</strong></em><strong> </strong>These are the questions we address in this podcast.</p> <p>In this podcast, you will learn,</p> <ul> <li>Announcements about upcoming dashboard classes</li> <li>Ten step process for creating awesome dashboards</li> <li>1. Talk to your end users</li> <li>2. Make a sketch of the dashboard</li> <li>3. Validate your understanding</li> <li>4. Collect data</li> <li>5. Structure the data</li> <li>…</li> </ul> <h3>Go ahead and listen to the show</h3> <p></p> <p> </p> <h3>Links &amp; Resources mentioned in this session:</h3> <p><strong>Excelapalooza Excel conference:</strong></p> <ul> <li><a href="http://excelapalooza.com" rel="nofollow" target="_blank">Know about this conference</a></li> <li><strong><a href="http://www.cvent.com/d/64qqqs?ct=ecef2aff-ec15-4938-aaa4-8f89d64d881a" rel="nofollow" target="_blank">Sign-up with 10% discount</a></strong></li> </ul> <p><strong>Advanced Excel, Dashboards &amp; Power Pivot Masterclass:</strong></p> <ul> <li><a href="https://files.chandoo.org/training/aed-usa-2014/aed-usa-2014-brochure.pdf" rel="nofollow" target="_blank">Download masterclass brochure</a></li> <li><strong><a href="http://chandoo.org/wp/resources/aed-usa-2014/" rel="nofollow" target="_blank">Sign-up for the masterclass</a></strong></li> </ul> <p><strong>Creating Dashboards – complete tutorials:<br/></strong></p> <ul> <li><a href="http://chandoo.org/wp/2008/08/20/create-kpi-dashboards-excel-1/" rel="nofollow" target="_blank">Creating a KPI Dashboard – 6 part tutorial</a></li> <li><a href="http://chandoo.org/wp/2012/02/22/design-customer-service-dashboard/" rel="nofollow" target="_blank">Customer service dashboard using Excel</a></li> <li><a href="http://chandoo.org/wp/2013/01/24/employee-vacations-tracker-dashboard/" rel="nofollow" target="_blank">Employee vacation tracker dashboard</a></li> <li><a href="http://chandoo.org/wp/excel-dashboards/" rel="nofollow" target="_blank">More tutorials, examples &amp; information about dashboards</a></li> </ul> <p><strong>Dashboard Examples &amp; Inspiration:<br/> </strong></p> <ul> <li><a href="http://chandoo.org/wp/2014/06/12/state-migration-dashboard-contest-entries/" rel="nofollow" target="_blank">49 dashboards on State to state migration in USA</a></li> <li><a href="http://chandoo.org/wp/2012/07/30/excel-salary-survey-contest-results/" rel="nofollow" target="_blank">66 dashboards visualizing salaries of Excel professionals</a></li> <li><a href="http://chandoo.org/wp/2010/01/04/sales-dashboards/" rel="nofollow" target="_blank">32 sales dashboards </a></li> <li><a href="http://chandoo.org/wp/2011/06/30/sales-analysis-charts-in-excel/" rel="nofollow" target="_blank">78 Sales analytic charts &amp; dashboards</a></li> <li><a href="http://chandoo.org/wp/excel-dashboards/examples/" rel="nofollow" target="_blank">More dashboard examples &amp; case studies</a></li> </ul> <p><strong>Creating Dynamic Charts:</strong></p> <ul> <li><a href="http://chandoo.org/wp/tag/dynamic-charts/" rel="nofollow" target="_blank">Examples of dynamic charts</a></li> <li>Introduction to Form controls – <a href="http://chandoo.org/wp/2011/03/30/form-controls/" rel="nofollow" target="_blank">article</a>, <a href="http://chandoo.org/wp/2014/04/17/cp005-form-controls/" rel="nofollow" target="_blank">podcast</a></li> </ul> <h3>Transcript of this session:</h3> <p><a href="https://img.chandoo.org/podcast/cp014-Transcript%20for%20Session.pdf" rel="nofollow" target="_blank">Download this podcast transcript </a>[PDF].</p> <h3>What process do you follow to create dashboards?</h3> <p>I have been following this 10 step process for the last 8 years with great success. Not only this process is easy to follow, but also it reduces the scope of errors significantly.</p> <p><strong>So what about you?</strong>What process do you follow when creating dashboards? <em><strong>Please share your thoughts &amp; experiences using comments</strong></em>.<strong><em><br/> </em></strong></p> <h3>Subscribe to <a href="http://Chandoo.org" rel="nofollow" target="_blank">Chandoo.org</a> Podcast</h3> <p><a href="https://itunes.apple.com/us/podcast/chandoo.org-podcast-become/id835954043?mt=2" rel="nofollow" target="_blank"></a></p> <p><a href="http://chandoo.org/wp/podcast-sessions/" rel="nofollow" target="_blank">Other options to subscribe</a></p> <p>The post <a href="https://chandoo.org/wp/cp014-create-awesome-dashboards/" rel="nofollow" target="_blank">CP014: How to create awesome dashboards – 10 step process for you</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>

CP014: How to create awesome dashboards – 10 step process for you

In the 11th session of Chandoo.org podcast, lets puts on a magic show for your boss  What is in this session? We all want to impress our bosses, create awesome experiences for our users and become enviable in workplace with our Excel skills. In this session, lets explore 5 very powerful, magical features of Excel that can help you create that jaw-dropping effect. In this podcast, you will learn,  Announcements Why magic 5 Excel Magic Tricks 1: Conditional formatting 2: Form controls + Charts 3: Pivot tables + Slicers 4: Macros + Automation 5: Using right feature @ right time How to learn these magic tricks Conclusions  Go ahead and listen to the show    Links &amp; Resources mentioned in this session: Conditional Formatting  Basics of conditional formatting Magical uses – example 1, example 2 &amp; more  Form controls + Charts   Introduction to form controls (or listen to the podcast) Magical uses – example 1, example 2 &amp; more  Pivot Tables + Slicers  Magical example of what slicers can do (has video too) Another example of slicers  Macros &amp; VBA  Introduction to VBA Magical uses – example 1, example 2 &amp; more  Transcript of this session: Download this podcast transcript [PDF]. What are your favorite Excel magic tricks? My favorites are conditional formatting, slicers, form controls + charts in that order. What about you? What features of Excel are most impressive and mesmerizing? Please share your thoughts using comments.  Subscribe to Chandoo.org Podcast  Other options to subscribe The post CP011: 5 Excel magic tricks to impress your boss appeared first on Chandoo.org - Learn Excel, Power BI &amp; Charting Online.

<p>In the 11th session of <a href="http://chandoo.org/wp/podcast-sessions/" rel="nofollow" target="_blank">Chandoo.org podcast</a>, lets <strong><em>puts on a magic show for your boss</em></strong></p> <p></p> <h3>What is in this session?</h3> <p>We all want to impress our bosses, create awesome experiences for our users and become enviable in workplace with our Excel skills. In this session, lets explore 5 very powerful, magical features of Excel that can help you create that jaw-dropping effect.</p> <p>In this podcast, you will learn,</p> <ul> <li>Announcements</li> <li>Why magic</li> <li>5 Excel Magic Tricks</li> <li>1: Conditional formatting</li> <li>2: Form controls + Charts</li> <li>3: Pivot tables + Slicers</li> <li>4: Macros + Automation</li> <li>5: Using right feature @ right time</li> <li>How to learn these magic tricks</li> <li>Conclusions</li> </ul> <h3>Go ahead and listen to the show</h3> <p></p> <p> </p> <h3>Links &amp; Resources mentioned in this session:</h3> <p><strong>Conditional Formatting</strong></p> <ul> <li><a href="http://chandoo.org/wp/2009/03/13/excel-conditional-formatting-basics/" rel="nofollow" target="_blank">Basics of conditional formatting</a></li> <li>Magical uses – <a href="http://chandoo.org/wp/2013/11/15/srt200/" rel="nofollow" target="_blank">example 1</a>, <a href="http://chandoo.org/wp/2013/11/05/gender-equality-gap-interactive-chart/" rel="nofollow" target="_blank">example 2</a> &amp; <a href="http://chandoo.org/wp/tag/conditional-formatting/" rel="nofollow" target="_blank">more</a></li> </ul> <p><strong>Form controls + Charts</strong></p> <p><a href="http://chandoo.org/wp/2013/08/06/how-to-create-a-then-vs-now-interactive-chart-in-excel/" rel="nofollow" target="_blank"></a></p> <ul> <li><a href="http://chandoo.org/wp/2011/03/30/form-controls/" rel="nofollow" target="_blank">Introduction to form controls</a> (<a href="http://chandoo.org/wp/2014/04/17/cp005-form-controls/" rel="nofollow" target="_blank">or listen to the podcast</a>)</li> <li>Magical uses – <a href="http://chandoo.org/wp/2013/08/06/how-to-create-a-then-vs-now-interactive-chart-in-excel/" rel="nofollow" target="_blank">example 1</a>, <a href="http://chandoo.org/wp/2012/12/06/tax-burden-chart-excel/" rel="nofollow" target="_blank">example 2</a> &amp; <a href="http://chandoo.org/wp/tag/dynamic-charts/" rel="nofollow" target="_blank">more</a></li> </ul> <p><strong>Pivot Tables + Slicers</strong></p> <ul> <li><a href="http://chandoo.org/wp/2010/12/08/dynamic-dashboard-video-tutorial/" rel="nofollow" target="_blank">Magical example of what slicers can do (has video too)</a></li> <li><a href="http://chandoo.org/wp/2012/09/12/interactive-pivot-calendar/" rel="nofollow" target="_blank">Another example of slicers</a></li> </ul> <p><strong>Macros &amp; VBA</strong></p> <ul> <li><a href="http://chandoo.org/wp/2011/08/29/introduction-to-vba-macros/" rel="nofollow" target="_blank">Introduction to VBA</a></li> <li>Magical uses – <a href="http://chandoo.org/wp/2014/05/13/building-a-simple-timer-using-excel-vba-to-track-my-rubiks-cube-solving-speed-case-study/" rel="nofollow" target="_blank">example 1</a>, <a href="http://chandoo.org/wp/2012/10/31/hurricane-sandy-animated-chart/" rel="nofollow" target="_blank">example 2</a> &amp; <a href="http://chandoo.org/wp/excel-vba/" rel="nofollow" target="_blank">more</a></li> </ul> <h3>Transcript of this session:</h3> <p><a href="https://img.chandoo.org/podcast/cp011-Transcript%20for%20Session.pdf" rel="nofollow" target="_blank">Download this podcast transcript</a> [PDF].</p> <h3>What are your favorite Excel magic tricks?</h3> <p>My favorites are conditional formatting, slicers, form controls + charts in that order.</p> <p><strong>What about you? </strong>What features of Excel are most impressive and mesmerizing? <em><strong>Please share your thoughts using comments.</strong><strong><br/> </strong></em></p> <h3>Subscribe to <a href="http://Chandoo.org" rel="nofollow" target="_blank">Chandoo.org</a> Podcast</h3> <p><a href="https://itunes.apple.com/us/podcast/chandoo.org-podcast-become/id835954043?mt=2" rel="nofollow" target="_blank"></a></p> <p><a href="http://chandoo.org/wp/podcast-sessions/" rel="nofollow" target="_blank">Other options to subscribe</a></p> <p>The post <a href="https://chandoo.org/wp/cp011-excel-magic-tricks/" rel="nofollow" target="_blank">CP011: 5 Excel magic tricks to impress your boss</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>

CP011: 5 Excel magic tricks to impress your boss

In the 28th session of Chandoo.org podcast, let’s figure out how to express business rules &amp; logic to Excel.  What is in this session? What good are spreadsheets if they can’t solve business problems? But we all struggle when it comes to modeling real world business conditions in Excel. For example, if you have below business rule to decide how much discount to offer a customer,  If the customer bought 3 or more times previously and offer 15% discount If the customer bought 1 or 2 times previously AND customer’s age is &gt;40, offer 10% discount If the customer visited our New York store between 6PM-9PM offer 5% discount Else no discount  How would you go about modeling these in Excel? That is our topic for this podcast session. In this podcast, you will learn  The challenge of modeling business logic &amp; rules in Excel My struggles with such formulas in early days 4 features of Excel that can help you with this. 1. Logical formulas AND OR NOT XOR   2. Support formulas IF IFERROR CHOOSE   3. Information formulas IS functions   4. Operators Brackets +*- operators   Example business rules &amp; how to write formulas for them Conclusions  Listen to this session  Click here to download the MP3 file.   Links &amp; Resources mentioned in this podcast Logical formulas – Syntax &amp; Examples:  AND OR NOT XOR  Support functions &amp; concepts:  IF formula – tutorial &amp; examples Excel operators – an overview IFERROR formula CHOOSE formula  Advanced business rules &amp; scenarios:  Advanced SUMPRODUCT queries SUMIFS formula for dates in a range  Homework for you:  Write a formula to check if 2 dates are in same month Write a formula to check if few cells have same value An IF formula challenge for you Can you calculate sales commission?  Transcript of this session: Download this podcast transcript [PDF]. What challenges do you face when modeling business rules / logic? When I was learning Excel, I struggled a few years understanding the concept of logical functions. Of course I was in college, so I had all the time in world to explore and learn. What about you? Do you write formulas that model real world logic? Where do you struggle? Please share your thoughts &amp; inputs in comments section so that I can help you better. IF(AND(like chandoo.org, love podcast), If you like chandoo.org &amp; our podcast, please take a minute and do one or both of below:  Leave a honest review on iTunes Share our podcast link with a colleague or friend – Send them here: chandoo.org/podcast   Other options to subscribe The post CP028: How to tell business logic &amp; rules to Excel? appeared first on Chandoo.org - Learn Excel, Power BI &amp; Charting Online.

<p>In the 28th session of <a href="http://chandoo.org/wp/podcast-sessions/" rel="nofollow" target="_blank">Chandoo.org podcast</a>, let’s <em><strong>figure out </strong><strong>how to express business rules &amp; logic to Excel</strong><strong>.</strong></em></p> <p></p> <h3>What is in this session?</h3> <p><em>What good are spreadsheets if they can’t solve business problems?</em></p> <p>But we all struggle when it comes to modeling real world business conditions in Excel. For example, if you have below business rule to decide how much discount to offer a customer,</p> <ul> <li>If the customer bought 3 or more times previously and offer 15% discount</li> <li>If the customer bought 1 or 2 times previously AND customer’s age is &gt;40, offer 10% discount</li> <li>If the customer visited our New York store between 6PM-9PM offer 5% discount</li> <li>Else no discount</li> </ul> <p>How would you go about modeling these in Excel?</p> <p><strong>That is our topic for this podcast session.</strong></p> <p>In this podcast, you will learn</p> <ul> <li>The challenge of modeling business logic &amp; rules in Excel</li> <li>My struggles with such formulas in early days</li> <li>4 features of Excel that can help you with this.</li> <li>1. Logical formulas<br><ul> <li>AND</li> <li>OR</li> <li>NOT</li> <li>XOR</li> </ul> </li> <li>2. Support formulas<br><ul> <li>IF</li> <li>IFERROR</li> <li>CHOOSE</li> </ul> </li> <li>3. Information formulas<br><ul> <li>IS functions</li> </ul> </li> <li>4. Operators<br><ul> <li>Brackets</li> <li>+*- operators</li> </ul> </li> <li>Example business rules &amp; how to write formulas for them</li> <li>Conclusions</li> </ul> <h3>Listen to this session</h3> <p></p> <p><a href="http://traffic.libsyn.com/chandoo/CP028.mp3" rel="nofollow" target="_blank">Click here to download the MP3 file</a>.</p> <p> </p> <h3>Links &amp; Resources mentioned in this podcast</h3> <p><strong>Logical formulas – Syntax &amp; Examples:</strong></p> <ul> <li><a href="http://chandoo.org/excel-formulas/and.shtml" rel="nofollow" target="_blank">AND</a></li> <li><a href="http://chandoo.org/excel-formulas/or.shtml" rel="nofollow" target="_blank">OR</a></li> <li><a href="http://chandoo.org/excel-formulas/not.shtml" rel="nofollow" target="_blank">NOT</a></li> <li><a href="http://chandoo.org/wp/2011/07/29/bitwise-operations-in-excel/" rel="nofollow" target="_blank">XOR</a></li> </ul> <p><strong>Support functions &amp; concepts:</strong></p> <ul> <li><a href="http://chandoo.org/wp/2008/06/09/what-the-if-learn-6-cool-things-you-can-do-with-excel-if-functions/" rel="nofollow" target="_blank">IF formula – tutorial &amp; examples</a></li> <li><a href="http://chandoo.org/wp/2014/12/04/cp026-excel-operators/" rel="nofollow" target="_blank">Excel operators – an overview</a></li> <li><a href="http://chandoo.org/wp/2011/03/11/iferror-formula/" rel="nofollow" target="_blank">IFERROR formula</a></li> <li><a href="http://chandoo.org/wp/2014/07/16/introduction-to-choose-function/" rel="nofollow" target="_blank">CHOOSE formula</a></li> </ul> <p><strong>Advanced business rules &amp; scenarios:</strong></p> <ul> <li><a href="http://chandoo.org/wp/2011/05/26/advanced-sumproduct-queries/" rel="nofollow" target="_blank">Advanced SUMPRODUCT queries</a></li> <li><a href="http://chandoo.org/wp/2011/09/27/sum-between-2-dates/" rel="nofollow" target="_blank">SUMIFS formula for dates in a range</a></li> </ul> <p><strong>Homework for you:</strong></p> <ul> <li><a href="http://chandoo.org/wp/2012/11/02/two-dates-in-month-check/" rel="nofollow" target="_blank">Write a formula to check if 2 dates are in same month</a></li> <li><a href="http://chandoo.org/wp/2012/10/12/check-cells-for-equality/" rel="nofollow" target="_blank">Write a formula to check if few cells have same value</a></li> <li><a href="http://chandoo.org/wp/2012/04/25/if-formula-challenge-for-you/" rel="nofollow" target="_blank">An IF formula challenge for you</a></li> <li><a href="http://chandoo.org/wp/2014/11/21/can-you-calculate-the-sales-commission-homework/" rel="nofollow" target="_blank">Can you calculate sales commission?</a></li> </ul> <h3>Transcript of this session:</h3> <p><a href="https://img.chandoo.org/podcast/cp028-Transcript%20for%20Session.pdf" rel="nofollow" target="_blank">Download this podcast transcript</a> [PDF].</p> <h3>What challenges do you face when modeling business rules / logic?</h3> <p>When I was learning Excel, I struggled a few years understanding the concept of logical functions. Of course I was in college, so I had all the time in world to explore and learn.</p> <p><strong>What about you? </strong>Do you write formulas that model real world logic? Where do you struggle? Please share your thoughts &amp; inputs in comments section so that I can help you better.</p> <h3>IF(AND(like <a href="http://chandoo.org" rel="nofollow" target="_blank">chandoo.org</a>, love podcast),</h3> <p>If you like <a href="http://chandoo.org" rel="nofollow" target="_blank">chandoo.org</a> &amp; our podcast, please take a minute and do one or both of below:</p> <ul> <li><a href="https://itunes.apple.com/us/podcast/chandoo.org-podcast-become/id835954043" rel="nofollow" target="_blank">Leave a honest review on iTunes</a></li> <li>Share our podcast link with a colleague or friend – Send them here: <a href="http://chandoo.org/podcast" rel="nofollow" target="_blank">chandoo.org/podcast</a></li> </ul> <p><a href="https://itunes.apple.com/us/podcast/chandoo.org-podcast-become/id835954043?mt=2" rel="nofollow" target="_blank"></a></p> <p><a href="http://chandoo.org/wp/podcast-sessions/" rel="nofollow" target="_blank">Other options to subscribe</a></p> <p>The post <a href="https://chandoo.org/wp/cp028-how-to-tell-business-logic-rules-to-excel/" rel="nofollow" target="_blank">CP028: How to tell business logic &amp; rules to Excel?</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>

CP028: How to tell business logic & rules to Excel?

Debra Dalgleish

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

In the 26th session of Chandoo.org podcast, let’s learn all about Excel !@#$%^+/*(}][&lt;. I am talking about Excel operators, you silly.  What is in this session? Do you know Excel has more than 25 operators? That is right. There are a variety of operators beyond the simple + – * and /. In this podcast, let’s understand all about these operators and how to use them. You will learn,  Why there is a gap between last &amp; this podcast session About Excel operators Arithmetic operators Text operators Reference operators Comparison operators Closing thoughts  Listen to this session  Click here to listen if the player is not showing up.   Links &amp; Resources on Excel operators &amp; Formulas  Using wild cards in Excel formulas SPACE operator for finding values at intersection Top 10 formulas for aspiring analysts  Excel Dashboard Templates    Click here to know about our Excel Dashboard Templates  Transcript of this session: Download this podcast transcript [PDF]. What are your favorite Excel operators? My favorites are % ? * and [] What about you? What are your favorite operators and why? Please share your thoughts in comments. Subscribe to Chandoo.org Podcast  Other options to subscribe The post CP026: All about Excel !@#$%^+/*(}][&lt; appeared first on Chandoo.org - Learn Excel, Power BI &amp; Charting Online.

<p>In the 26th session of <a href="http://chandoo.org/wp/podcast-sessions/" rel="nofollow" target="_blank">Chandoo.org podcast</a>, let’s <em><strong>learn all about Excel !@#$%^+/*(}][&lt;.</strong></em></p> <p>I am talking about Excel operators, you silly.</p> <p></p> <h3>What is in this session?</h3> <p>Do you know Excel has more than 25 operators? That is right. There are a variety of operators beyond the simple + – * and /.</p> <p>In this podcast, let’s understand all about these operators and how to use them. You will learn,</p> <ul> <li>Why there is a gap between last &amp; this podcast session</li> <li>About Excel operators</li> <li>Arithmetic operators</li> <li>Text operators</li> <li>Reference operators</li> <li>Comparison operators</li> <li>Closing thoughts</li> </ul> <h3>Listen to this session</h3> <p></p> <p><a href="http://traffic.libsyn.com/chandoo/CP026.mp3" rel="nofollow" target="_blank">Click here to listen if the player is not showing up</a>.</p> <p> </p> <h3>Links &amp; Resources on Excel operators &amp; Formulas</h3> <ul> <li><a href="http://chandoo.org/wp/2010/11/01/using-wildcards-with-vlookup/" rel="nofollow" target="_blank">Using wild cards in Excel formulas</a></li> <li><a href="http://chandoo.org/wp/2010/11/09/2way-lookup-formulas/" rel="nofollow" target="_blank">SPACE operator for finding values at intersection</a></li> <li><a href="http://chandoo.org/wp/2013/01/16/top-10-formulas-for-aspiring-analysts/" rel="nofollow" target="_blank">Top 10 formulas for aspiring analysts</a></li> </ul> <p><strong>Excel Dashboard Templates<br/> </strong></p> <p><a href="http://chandoo.org/dbt/index.html" rel="nofollow" target="_blank"></a></p> <ul> <li><a href="http://chandoo.org/dbt/index.html" rel="nofollow" target="_blank"><strong>Click here to know about our Excel Dashboard Templates</strong></a></li> </ul> <h3>Transcript of this session:</h3> <p><a href="https://img.chandoo.org/podcast/cp026-Transcript%20for%20Session.pdf" rel="nofollow" target="_blank">Download this podcast transcript</a> [PDF].</p> <h3>What are your favorite Excel operators?</h3> <p>My favorites are % ? * and []</p> <p><strong>What about you?</strong> What are your favorite operators and why? Please share your thoughts in comments.</p> <h3>Subscribe to <a href="http://Chandoo.org" rel="nofollow" target="_blank">Chandoo.org</a> Podcast</h3> <p><a href="https://itunes.apple.com/us/podcast/chandoo.org-podcast-become/id835954043?mt=2" rel="nofollow" target="_blank"></a></p> <p><a href="http://chandoo.org/wp/podcast-sessions/" rel="nofollow" target="_blank">Other options to subscribe</a></p> <p>The post <a href="https://chandoo.org/wp/cp026-excel-operators/" rel="nofollow" target="_blank">CP026: All about Excel !@#$%^+/*(}][&lt;</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>

CP026: All about Excel !@#$%^+/*(}][

In the 43rd session of Chandoo.org podcast, let’s talk about top time saving features of Excel.  What is in this session? In this podcast,  Quick announcement about Awesome August My 9 favorite time saving features of Excel Remove Duplicates Tables Pivot Tables Auto fill Format Painter Find &amp; Replace VBA / Macro Recorder Auto save Auto complete / Intellisence Recap &amp; Conclusions  Listen to this session  Click here to download the MP3 file. Resources to save time Dealing with duplicates  Remove duplicates button – explained Remove duplicate combinations  Tables &amp; Pivot Table concepts:  Introduction to Excel Tables Introduction to Excel Pivot Tables Structural References &amp; how to use them  Auto fill &amp; flash fill:  Fill up patterns with Auto-fill Flash fill in Excel – a quick intro  Format Painter and how it can save time for you:  Format faster with format painter &amp; double click Format all charts in same way using format painter  Find &amp; Replace:  Use find / replace to change formats quickly Change formulas with find / replace  VBA &amp; Macro Recorder  Introduction to VBA &amp; Macros What is a macro and how to get started – podcast  Transcript of this session: Download this podcast transcript [PDF] Which Excel feature is the most time saving one? I’ve revealed my secrets. Now it’s your turn. Tell me your favorite time saving feature of Excel. And if you have a few minutes time, Please write a review for Chandoo.org  podcast on iTunes. Please click here to do that (see the instructions if you don’t know how to write a review on iTunes). The post CP043: My favorite time saving features of Excel, Revealed. appeared first on Chandoo.org - Learn Excel, Power BI &amp; Charting Online.

<p>In the 43rd session of <a href="http://chandoo.org/wp/podcast-sessions/" rel="nofollow" target="_blank">Chandoo.org podcast</a>, let’s talk about top time saving features of Excel.</p> <p></p> <h3>What is in this session?</h3> <p>In this podcast,</p> <ul> <li>Quick announcement about <a href="http://chandoo.org/wp/resources/awesome-august/" rel="nofollow" target="_blank">Awesome August</a></li> <li>My 9 favorite time saving features of Excel</li> <li>Remove Duplicates</li> <li>Tables</li> <li>Pivot Tables</li> <li>Auto fill</li> <li>Format Painter</li> <li>Find &amp; Replace</li> <li>VBA / Macro Recorder</li> <li>Auto save</li> <li>Auto complete / Intellisence</li> <li>Recap &amp; Conclusions</li> </ul> <h3>Listen to this session</h3> <p></p> <p><a href="http://traffic.libsyn.com/chandoo/CP043.mp3" rel="nofollow" target="_blank">Click here to download the MP3 file</a>.</p> <h3>Resources to save time</h3> <p><b>Dealing with duplicates</b></p> <ul> <li><a href="http://chandoo.org/wp/2009/06/22/remove-duplicates/" rel="nofollow" target="_blank">Remove duplicates button – explained</a></li> <li><a href="http://chandoo.org/wp/2015/08/07/remove-duplicate-combinations/" rel="nofollow" target="_blank">Remove duplicate combinations</a></li> </ul> <p><strong>Tables &amp; Pivot Table concepts:</strong></p> <ul> <li><a href="http://chandoo.org/wp/2009/09/10/data-tables/" rel="nofollow" target="_blank">Introduction to Excel Tables</a></li> <li><a href="http://chandoo.org/wp/2009/08/19/excel-pivot-tables-tutorial/" rel="nofollow" target="_blank">Introduction to Excel Pivot Tables</a></li> <li><a href="http://chandoo.org/wp/2013/06/26/introduction-to-structural-references/" rel="nofollow" target="_blank">Structural References &amp; how to use them</a></li> </ul> <p><strong>Auto fill &amp; flash fill:</strong></p> <ul> <li><a href="http://chandoo.org/wp/2015/01/20/unleash-the-pattern-power-with-excel-fill-quick-tip/" rel="nofollow" target="_blank">Fill up patterns with Auto-fill</a></li> <li><a href="http://chandoo.org/wp/2015/08/01/introduction-to-flash-fill/" rel="nofollow" target="_blank">Flash fill in Excel – a quick intro</a></li> </ul> <p><strong>Format Painter and how it can save time for you:</strong></p> <ul> <li><a href="http://chandoo.org/wp/2015/08/12/format-faster/" rel="nofollow" target="_blank">Format faster with format painter &amp; double click</a></li> <li><a href="http://chandoo.org/wp/2010/02/24/paste-special-chart-formatting/" rel="nofollow" target="_blank">Format all charts in same way using format painter</a></li> </ul> <p><strong>Find &amp; Replace:</strong></p> <ul> <li><a href="http://chandoo.org/wp/2008/04/04/change-cell-formats-with-find-replace-in-excel/" rel="nofollow" target="_blank">Use find / replace to change formats quickly</a></li> <li><a href="http://chandoo.org/wp/2009/02/17/spreadsheet-formulas-edit/" rel="nofollow" target="_blank">Change formulas with find / replace</a></li> </ul> <p><strong>VBA &amp; Macro Recorder</strong></p> <ul> <li><a href="http://chandoo.org/wp/2011/08/29/introduction-to-vba-macros/" rel="nofollow" target="_blank">Introduction to VBA &amp; Macros</a></li> <li><a href="http://chandoo.org/wp/2014/10/09/cp022-whats-a-macro-introduction-to-excel-vba-macros-automation/" rel="nofollow" target="_blank">What is a macro and how to get started – podcast</a></li> </ul> <h3>Transcript of this session:</h3> <p><a href="https://img.chandoo.org/podcast/cp043-Transcript for Session.pdf" rel="nofollow" target="_blank">Download this podcast transcript</a> [PDF]</p> <h3>Which Excel feature is the most time saving one?</h3> <p>I’ve revealed my secrets. Now it’s your turn. Tell me your favorite time saving feature of Excel.</p> <p>And if you have a few minutes <em>time</em>, Please write a review for <a href="http://Chandoo.org" rel="nofollow" target="_blank">Chandoo.org</a>  podcast on iTunes. <strong><a href="https://itunes.apple.com/in/podcast/chandoo.org-podcast-become/id835954043?mt=2" rel="nofollow" target="_blank">Please click here to do that</a></strong> (see the <a href="https://support.apple.com/en-in/HT201991" rel="nofollow" target="_blank">instructions</a> if you don’t know how to write a review on iTunes).</p> <p>The post <a href="https://chandoo.org/wp/top-time-saving-features-of-excel/" rel="nofollow" target="_blank">CP043: My favorite time saving features of Excel, Revealed.</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>

CP043: My favorite time saving features of Excel, Revealed.

Jordan Goldmeier

In the 34th session of Chandoo.org podcast, Let’s hear from Jordan Goldmeier – my friend, fellow blogger, Excel blogger &amp; author. After many years of interaction thru email, blogs, Skype calls, finally I met him at PASS BA conference at Santa Clara this week. He gave me a copy of his new book – Advanced Excel Essentials and I immediately asked him to do a podcast. So here we go.  What is in this session? In this podcast,  Introduction What is this book all about Sample chapter review – User forms Design principles for creating advanced user interactions How to become advanced Excel user – pathway recommended by Jordan More info about Jordan A secret for you  Listen to this session  Click here to download the MP3 file.   Links &amp; Resources mentioned in this podcast Books recommended / mentioned in this podcast  Advanced Excel Essentials by Jordan Goldmeier Data Smart by John Foreman Professional XL Development by Rob, Dennis &amp; Stephen Predictive Analytics by Conrad Carlberg Data Science for Business by Foster &amp; Tom  User form examples:  Creating a spreadsheet wizard to collect data  Resources on learning VBA &amp; Advanced Excel  Introduction to VBA Advanced Excel skills &amp; resources  About Jordan &amp; his work:  Option Explicit VBA – Jordan’s blog Excel TV – where Jordan along with Rick &amp; Oz share tips &amp; interviews  Transcript of this session: Download this podcast transcript [PDF] Have you read Advanced Excel Essentials book? I will be honest, I only thumbed thru a few chapters. But I plan to read the book on my flight back to India (I am typing this from my hotel room in Santa Clara). What about you? Have you read Jordan’s book? If so how do you like it? Please share your feedback &amp; book recommendations in the comments area. Note: All the links to books mentioned in this page use my Amazon affiliate code. This means, when you buy the book from Amazon thru these links, I get a few cents commission. My motivation for recommending these books is very simple. They make you awesome, so I recommend them. I would have recommended them even when there is no commission involved. Thanks for supporting Chandoo.org &amp; happy reading. The post CP034: Advanced Excel Essentials book talk with Jordan Goldmeier appeared first on Chandoo.org - Learn Excel, Power BI &amp; Charting Online.

<p>In the 34th session of <a href="http://chandoo.org/wp/podcast-sessions/" rel="nofollow" target="_blank">Chandoo.org podcast</a>, Let’s hear from <a href="http://optionexplicitvba.com/" rel="nofollow" target="_blank">Jordan Goldmeier</a> – my friend, fellow blogger, Excel blogger &amp; author. After many years of interaction thru email, blogs, Skype calls, finally I met him at PASS BA conference at Santa Clara this week. He gave me a copy of his new book – <a href="http://www.amazon.com/gp/product/1484207351/ref=as_li_tl?ie=UTF8&amp;camp=1789&amp;creative=390957&amp;creativeASIN=1484207351&amp;linkCode=as2&amp;tag=poinhairdilb-20&amp;linkId=ERHMXKUURSA7NTBK" rel="nofollow" target="_blank">Advanced Excel Essentials</a> and I immediately asked him to do a podcast. So here we go.</p> <p></p> <h3>What is in this session?</h3> <p>In this podcast,</p> <ul> <li>Introduction</li> <li>What is this book all about</li> <li>Sample chapter review – User forms</li> <li>Design principles for creating advanced user interactions</li> <li>How to become advanced Excel user – pathway recommended by Jordan</li> <li>More info about Jordan</li> <li>A secret for you</li> </ul> <h3>Listen to this session</h3> <p></p> <p><a href="http://traffic.libsyn.com/chandoo/CP034.mp3" rel="nofollow" target="_blank">Click here to download the MP3 file</a>.</p> <p> </p> <h3>Links &amp; Resources mentioned in this podcast</h3> <p><b>Books recommended / mentioned in this podcast</b></p> <ul> <li><a href="http://www.amazon.com/gp/product/1484207351/ref=as_li_tl?ie=UTF8&amp;camp=1789&amp;creative=390957&amp;creativeASIN=1484207351&amp;linkCode=as2&amp;tag=poinhairdilb-20&amp;linkId=ERHMXKUURSA7NTBK" rel="nofollow" target="_blank"><strong>Advanced Excel Essentials</strong></a> by Jordan Goldmeier</li> <li><a href="http://www.amazon.com/gp/product/111866146X/ref=as_li_tl?ie=UTF8&amp;camp=1789&amp;creative=390957&amp;creativeASIN=111866146X&amp;linkCode=as2&amp;tag=poinhairdilb-20&amp;linkId=CRPA42QLA3QOIRPO" rel="nofollow" target="_blank">Data Smart</a> by John Foreman</li> <li><a href="http://www.amazon.com/gp/product/0321508793/ref=as_li_tl?ie=UTF8&amp;camp=1789&amp;creative=390957&amp;creativeASIN=0321508793&amp;linkCode=as2&amp;tag=poinhairdilb-20&amp;linkId=A2JYCGTCC3LGLFAN" rel="nofollow" target="_blank">Professional XL Development</a> by Rob, Dennis &amp; Stephen</li> <li><a href="http://www.amazon.com/gp/product/B008JWQ8CA/ref=as_li_tl?ie=UTF8&amp;camp=1789&amp;creative=390957&amp;creativeASIN=B008JWQ8CA&amp;linkCode=as2&amp;tag=poinhairdilb-20&amp;linkId=CFTBMBMKH4Z3E3FQ" rel="nofollow" target="_blank">Predictive Analytics</a> by Conrad Carlberg</li> <li><a href="http://www.amazon.com/gp/product/1449361323/ref=as_li_tl?ie=UTF8&amp;camp=1789&amp;creative=390957&amp;creativeASIN=1449361323&amp;linkCode=as2&amp;tag=poinhairdilb-20&amp;linkId=T7TI7Z65WTE66CX5" rel="nofollow" target="_blank">Data Science for Business</a> by Foster &amp; Tom</li> </ul> <p><strong>User form examples:</strong></p> <ul> <li><a href="http://optionexplicitvba.com/2013/10/17/creating-a-spreadsheet-based-wizard/" rel="nofollow" target="_blank">Creating a spreadsheet wizard to collect data</a></li> </ul> <p><strong>Resources on learning VBA &amp; Advanced Excel</strong></p> <ul> <li><a href="http://chandoo.org/wp/2011/08/29/introduction-to-vba-macros/" rel="nofollow" target="_blank">Introduction to VBA</a></li> <li><a href="http://chandoo.org/wp/advanced-excel-skills/" rel="nofollow" target="_blank">Advanced Excel skills &amp; resources</a></li> </ul> <p><strong>About Jordan &amp; his work:</strong></p> <ul> <li><a href="http://optionexplicitvba.com/" rel="nofollow" target="_blank">Option Explicit VBA</a> – Jordan’s blog</li> <li><a href="http://www.excel.tv/" rel="nofollow" target="_blank">Excel TV</a> – where Jordan along with Rick &amp; Oz share tips &amp; interviews</li> </ul> <h3>Transcript of this session:</h3> <p><a href="https://img.chandoo.org/podcast/cp034-Transcript for Session.pdf" rel="nofollow" target="_blank">Download this podcast transcript</a> [PDF]</p> <h3>Have you read Advanced Excel Essentials book?</h3> <p>I will be honest, I only thumbed thru a few chapters. But I plan to read the book on my flight back to India (I am typing this from my hotel room in Santa Clara).</p> <p><strong>What about you? </strong>Have you read Jordan’s book? If so how do you like it? Please share your feedback &amp; book recommendations in the comments area.</p> <p><small>Note: All the links to books mentioned in this page use my Amazon affiliate code. This means, when you buy the book from Amazon thru these links, I get a few cents commission. My motivation for recommending these books is very simple. They make you awesome, so I recommend them. I would have recommended them even when there is no commission involved. Thanks for supporting <a href="http://Chandoo.org" rel="nofollow" target="_blank">Chandoo.org</a> &amp; happy reading.</small></p> <p>The post <a href="https://chandoo.org/wp/cp034-advanced-excel-essentials-book-review/" rel="nofollow" target="_blank">CP034: Advanced Excel Essentials book talk with Jordan Goldmeier</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>

CP034: Advanced Excel Essentials book talk with Jordan Goldmeier

In the 32nd session of Chandoo.org podcast, let’s make legendary column charts.  What is in this session? Column charts are everywhere. As analysts, we are expected to create flawless, strikingly beautiful &amp; insightful column charts all the time. Do you know the simple rules that can help you create legendary column charts? That is our topic for this podcast session. In this podcast, you will learn  Few personal announcements Rule 0: Start at zero Rule 1: Sort the chart Rule 2: Slap a title on it Rule 3: Axis + grid-lines vs. Lables Rule 4: Moderate formatting Conclusions  Listen to this session  Click here to download the MP3 file.   Links &amp; Resources mentioned in this podcast Companion article  5 rules for making awesome column charts More charting principles  Transcript of this session: Download this podcast transcript [PDF] How do you make your column charts awesome? I shared my favorite techniques in the podcast. Now it’s your turn. What about you? What rules &amp; techniques do you use to make your column charts awesome? Please share in the comments section. Subscribe to our podcast and get latest episodes automatically Use below link to add our podcast to iTunes. For other options (Android, Windows phone or RSS) click the link below. Thank you.  Other options to subscribe The post CP032: Rules for making legendary column charts appeared first on Chandoo.org - Learn Excel, Power BI &amp; Charting Online.

<p>In the 32nd session of <a href="http://chandoo.org/wp/podcast-sessions/" rel="nofollow" target="_blank">Chandoo.org podcast</a>, let’s make legendary column charts.</p> <p></p> <h3>What is in this session?</h3> <p>Column charts are everywhere. As analysts, we are expected to create flawless, strikingly beautiful &amp; insightful column charts all the time. Do you know the simple rules that can help you create legendary column charts?</p> <p><strong>That is our topic for this podcast session.</strong></p> <p>In this podcast, you will learn</p> <ul> <li>Few personal announcements</li> <li>Rule 0: Start at zero</li> <li>Rule 1: Sort the chart</li> <li>Rule 2: Slap a title on it</li> <li>Rule 3: Axis + grid-lines vs. Lables</li> <li>Rule 4: Moderate formatting</li> <li>Conclusions</li> </ul> <h3>Listen to this session</h3> <p></p> <p><a href="http://traffic.libsyn.com/chandoo/CP032.mp3" rel="nofollow" target="_blank">Click here to download the MP3 file</a>.</p> <p> </p> <h3>Links &amp; Resources mentioned in this podcast</h3> <p><strong>Companion article</strong></p> <ul> <li><a href="http://chandoo.org/wp/2013/08/29/rules-for-making-awesome-column-charts/" rel="nofollow" target="_blank">5 rules for making awesome column charts</a></li> <li><a href="http://chandoo.org/wp/tag/charting-principles/" rel="nofollow" target="_blank">More charting principles</a></li> </ul> <h3>Transcript of this session:</h3> <p><a href="https://img.chandoo.org/podcast/cp032-Transcript%20for%20Session.pdf" rel="nofollow" target="_blank">Download this podcast transcript</a> [PDF]</p> <h3>How do you make your column charts awesome?</h3> <p>I shared my favorite techniques in the podcast. Now it’s your turn.</p> <p><strong>What about you? </strong>What rules &amp; techniques do you use to make your column charts awesome? Please share in the comments section.</p> <h3>Subscribe to our podcast and get latest episodes automatically</h3> <p>Use below link to add our podcast to iTunes. For other options (Android, Windows phone or RSS) click the link below. Thank you.</p> <p><a href="https://itunes.apple.com/us/podcast/chandoo.org-podcast-become/id835954043?mt=2" rel="nofollow" target="_blank"></a></p> <p><a href="http://chandoo.org/wp/podcast-sessions/" rel="nofollow" target="_blank">Other options to subscribe</a></p> <p>The post <a href="https://chandoo.org/wp/cp032-column-chart-rules/" rel="nofollow" target="_blank">CP032: Rules for making legendary column charts</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>

CP032: Rules for making legendary column charts

In the 20th session of Chandoo.org podcast, lets save some time.  What is in this session? We all want to save time and stay productive. The obvious answer seems like using keyboard shortcuts. But they can only get you so far. So what about the real productive strategies? That is what we address in this podcast. In this podcast, you will learn,  Announcements 5 key areas of business analyst work – tracking, analysis, reporting, data management &amp; modeling Time saving strategies for tracking for analysis for reporting for data management for modeling Conclusions  Here is a mind-map of this podcast.  Listen to this session    Links &amp; Resources mentioned in this session:  Tables: Use them to structure data &amp; track easily Data validation: Use it to ensure that your input data is clean Pivot tables: help you quickly summarize data and get results (check out podcast session 18) Formulas: learn them to analyze better (also check out the podcast sessions 2 &amp; 7) Format Painter: copy formatting from one range (or chart, object) to another easily Keyboard shortcuts: use them to save time (my favorite shortcuts podcast) Modeling best practices: Follow them to save time &amp; create better models  Transcript of this session: Download this podcast transcript [PDF]. How do you save time? Tell us quickly So how do you save time when working with Excel? Please share your tips, suggestions and stories with us in the comments area. But be quick. I don’t want to waste time waiting for your comments  The post CP020: Top 10 time saving strategies for business analysts appeared first on Chandoo.org - Learn Excel, Power BI &amp; Charting Online.

<p>In the 20th session of <a href="http://chandoo.org/wp/podcast-sessions/" rel="nofollow" target="_blank">Chandoo.org podcast</a>, lets <strong>save some time</strong>.</p> <p></p> <h3>What is in this session?</h3> <p><strong>We all want to save time and stay productive. </strong>The obvious answer seems like using keyboard shortcuts. But they can only get you so far. So what about the real productive strategies? That is what we address in this podcast.</p> <p>In this podcast, you will learn,</p> <ul> <li>Announcements</li> <li>5 key areas of business analyst work – tracking, analysis, reporting, data management &amp; modeling</li> <li>Time saving strategies for tracking</li> <li>for analysis</li> <li>for reporting</li> <li>for data management</li> <li>for modeling</li> <li>Conclusions</li> </ul> <p>Here is a mind-map of this podcast.</p> <p></p> <h3>Listen to this session</h3> <p></p> <p> </p> <h3>Links &amp; Resources mentioned in this session:</h3> <ol> <li><a href="http://chandoo.org/wp/2009/09/10/data-tables/" rel="nofollow" target="_blank">Tables</a>: Use them to structure data &amp; track easily</li> <li><a href="http://chandoo.org/wp/2008/08/07/excel-add-drop-down-list/" rel="nofollow" target="_blank">Data validation</a>: Use it to ensure that your input data is clean</li> <li><a href="http://chandoo.org/wp/excel-pivot-tables/" rel="nofollow" target="_blank">Pivot tables</a>: help you quickly summarize data and get results (check out <a href="http://chandoo.org/wp/2014/08/21/cp018-intro-pivot-tables/" rel="nofollow" target="_blank">podcast session 18</a>)</li> <li><a href="http://chandoo.org/wp/tag/formulas" rel="nofollow" target="_blank">Formulas</a>: learn them to analyze better (also check out the <a href="http://chandoo.org/wp/2014/03/13/cp002-vtalkup-5-excel-lookup-functions-demystified-4-resources-for-you/" rel="nofollow" target="_blank">podcast sessions 2</a> &amp; <a href="http://chandoo.org/wp/2014/05/01/cp007-awesum-overview-of-sum-functions-in-excel/" rel="nofollow" target="_blank">7</a>)</li> <li><a href="http://chandoo.org/wp/2011/12/05/excel-formatting-tips/" rel="nofollow" target="_blank">Format Painter</a>: copy formatting from one range (or chart, object) to another easily</li> <li><a href="http://chandoo.org/wp/2010/02/22/complete-list-of-excel-shortcuts/" rel="nofollow" target="_blank">Keyboard shortcuts</a>: use them to save time (<a href="http://chandoo.org/wp/2014/06/26/cp012-top-10-keyboard-shortcuts/" rel="nofollow" target="_blank">my favorite shortcuts podcast</a>)</li> <li><a href="http://chandoo.org/wp/2012/08/29/best-practice-modeling-5tips/" rel="nofollow" target="_blank">Modeling best practices</a>: Follow them to save time &amp; create better models</li> </ol> <h3>Transcript of this session:</h3> <p><a href="https://img.chandoo.org/podcast/cp020-Transcript%20for%20Session.pdf" rel="nofollow" target="_blank">Download this podcast transcript</a> [PDF].</p> <h3>How do you save time? Tell us quickly</h3> <p><strong>So how do you save time when working with Excel?</strong> Please share your tips, suggestions and stories with us in the comments area. But be quick. I don’t want to waste time waiting for your comments </p> <p>The post <a href="https://chandoo.org/wp/cp020-top10-time-saving-strategies/" rel="nofollow" target="_blank">CP020: Top 10 time saving strategies for business analysts</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>

CP020: Top 10 time saving strategies for business analysts

The best podcast episodes of anyone with an interesting story. With famous guests like Obama, LeBron James, Drake, Oprah Winfrey, Richard Branson, Michelle Obama, Serena Williams, to anyone who has a unique and interesting story to tell. Add episodes you're interested into your queue below!

Best Episodes: Personal Stories & Great Interviews

What is this?
1 quote, 3 ideas & 1 question from a carefully curated podcast episode.
Every Monday & Wednesday.

Want a 3rd insight and episode every week? Email me at curation@owltail.com.