Afleveringen
-
Ladies & 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 & Data Analytics.
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.
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 & Charting Online.
-
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?
Two personal updates3 legs of formula writingFunction knowledgeOperatorsReferencing6 categories of must-know functionsBasic mathConditionsLookupsTextDate & timeWork specificClosing remarks & resources for you
In this podcast,The post CP056: So which formulas you should care to learn? appeared first on Chandoo.org - Learn Excel, Power BI & Charting Online.
-
Zijn er afleveringen die ontbreken?
-
Ladies & 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 episodeWhat next?How to extract every 6th item from a list?The post CP055: “Yes, I am back” edition (and a bonus Excel tip) appeared first on Chandoo.org - Learn Excel, Power BI & Charting Online.
-
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 updatesTop 10 pivot table tricksAdding same value field twiceTabular layoutsGETPIVOTDATA & 2 bonus tricksRelationships & data modelOne slicer to rule them allShow only top x valuesRelative performanceShow unique countSpruce up with conditional formatsNot so ugly pivot chartsResources & Show notes for youThe post CP054: Top 10 Pivot Table Tricks for YOU appeared first on Chandoo.org - Learn Excel, Power BI & Charting Online.
-
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 validationHow Excel DV compares with database & software DV?Types of data validation rulesList & custom rules explainedInput & error messagesAlternatives to data validationEnhancing data validationRemoving data validation rulesHomework problem for youResources & show notesThe post CP053: Excel Data Validation for Dummies appeared first on Chandoo.org - Learn Excel, Power BI & Charting Online.
-
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 QueryWhy you should get this book?What is in this book?A very cool example of the techniques you will learnConclusionsThe post CP052: Book Review – M is for Data Monkey by Ken & Miguel appeared first on Chandoo.org - Learn Excel, Power BI & Charting Online.
-
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 youThe post CP051: VLOOKUP FAQs – Most frequently asked questions about VLOOKUP – Answered appeared first on Chandoo.org - Learn Excel, Power BI & Charting Online.
-
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 messageFifty tips in 5 bucketsShortcuts & ProductivityFormulasManaging DataChartsUsing Excel betterThe post CP050: Fifty Excel Tips to make you awesome appeared first on Chandoo.org - Learn Excel, Power BI & Charting Online.
-
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 dumpExamples of data dumpWhy we dumpWays to avoid data dumpsGo for information dumpsSort the dumpFilter the dumpGive a tableResources for youThe post CP049: Don’t do data dumps!!! appeared first on Chandoo.org - Learn Excel, Power BI & Charting Online.
-
In the 48th session of Chandoo.org podcast, let's make some animated charts!!!
What is in this session?
In this podcast,
AnnouncementsWhy animate your charts?Non-VBA methods to animate chartsExcel 2013's built-in animation effectsIterative formula approachVBA based animationCartoon film analogyUnderstanding the VBA partExample animated chart - Sales of a new productResources and downloads for youThe post CP048: How to create animated charts in Excel? appeared first on Chandoo.org - Learn Excel, Power BI & Charting Online.
-
In the 47th session of Chandoo.org podcast, let's see how Excel can make you an awesome entrepreneur.
What is in this session?In this podcast,
Why Excel for entrepreneursKey areas of a business owner's workProjects & to dosFinancesCustomers & marketingPlanning & strategyProcesses & workflows5 features of Excel that helpConclusionsThe post CP047: Best Excel tools for Entrepreneurs appeared first on Chandoo.org - Learn Excel, Power BI & Charting Online.
-
In the 46th session of Chandoo.org podcast, let's talk about gantt charts and project plans.
What is in this session?In this podcast,
A brief intro to Excel 2016What is a Gantt chart?How Gantt charts can help us?How to create Gantt charts in ExcelUsing bar charts with invisible seriesUsing conditional formatting and formulasUsing ready-made templatesResources on Gantt charts & project planningConclusionsThe post CP046: Gantt charts & project planning using Excel appeared first on Chandoo.org - Learn Excel, Power BI & Charting Online.
-
In the 45th session of Chandoo.org podcast, let's get in to Monte Carlo simulations.
What is in this session?In this podcast,
Quick personal updates - 200km BRM and book delayHistory of Monte Carlo simulationsMonte Carlo simulations - an exampleHow to do simulations in ExcelFormulasVBAData TablesUsing data tables to run simulations - case study - estimating Pi valueThings to keep in mind when setting up your simulation modelsResources on Monte Carlo simulations in ExcelConclusionsThe post CP045: Introduction to Monte Carlo Simulations in Excel appeared first on Chandoo.org - Learn Excel, Power BI & Charting Online.
-
In the 44th session of Chandoo.org podcast, let's talk about failures.
What is in this session?In this podcast,
Book announcement about Dashboards for ExcelStory of my first ever dashboardImportant lessons - Requirement Analysis for dashboardsResources for creating awesome dashboardsPodcastsBooksCoursesThe post CP044: My first dashboard was a failure!!! appeared first on Chandoo.org - Learn Excel, Power BI & Charting Online.
-
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 AugustMy 9 favorite time saving features of ExcelRemove DuplicatesTablesPivot TablesAuto fillFormat PainterFind & ReplaceVBA / Macro RecorderAuto saveAuto complete / IntellisenceRecap & ConclusionsThe post CP043: My favorite time saving features of Excel, Revealed. appeared first on Chandoo.org - Learn Excel, Power BI & Charting Online.
-
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 August5 key finance conceptsTime value of moneyCompound interestRisk free rate of returnNet Present Value - NPVInternal Rate of Return - IRRCase study - Uber vs. Your carConclusionsThe post CP042: Financial Analysis & Modeling concepts – 101 appeared first on Chandoo.org - Learn Excel, Power BI & Charting Online.
-
In the 41st session of Chandoo.org podcast, Let's take a trip to data hell and meet 6 ugly, clumsy, confusing charts. I am revisiting a classic Chandoo.org article - 6 Charts you will see in hell.
What is in this session?In this podcast,
Quick announcement about Awesome August6 charts you should avoid3D chartsPie / donut charts with too many slicesToo much dataOver formattingComplex chartsCharts that don't tell a storyConclusionsThe post CP041: 6 charts you’ll see in hell – v2.0 appeared first on Chandoo.org - Learn Excel, Power BI & Charting Online.
-
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,
WelcomeMiguel's introduction, background and current projectsWhat is Power QueryHow to install itSample use cases of Power QueryWhat is Power BIResources for learning Power Query - Books & CoursesThe 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 & Charting Online.
-
In the 39th session of Chandoo.org podcast, Let's learn about FOR loops.
There is a special giveaway in this podcast. It is a workbook with several FOR loop VBA code examples. Listen to the episode for instructions.
What is in this session?In this podcast,
AnnouncementsWhat is a loop - plain English & technical definitionsFor Loop vs. other kind of loops (While & Until)For Next loopsFor Each loopsNested For loopsSpecial tips on For loopsPerformance issues & infinite loopsConclusions & giveawayThe post CP039: May the FOR Loop be with you – Introduction to For Loops in Excel VBA appeared first on Chandoo.org - Learn Excel, Power BI & Charting Online.
-
In the 38th session of Chandoo.org podcast, Let's optimize data to ink ratio of your charts.
What is in this session?
In this podcast,
AnnouncementsWhat is Data to Ink Ratio?Obvious ways to optimize Data to Ink RatioMore ways to optimize Data to Ink ratioHighlighting what is importantConclusionsThe post CP038: Data to Ink Ratio – What is it, How to optimize it, Techniques & Discussion appeared first on Chandoo.org - Learn Excel, Power BI & Charting Online.
- Laat meer zien