Dashboards 公开
[search 0]
更多

Download the App!

show episodes
 
Become Awesome in Excel by Chandoo.org – A podcast aimed to teach you data analysis, charting, visualization, dashboard reporting, big data analysis, Power Pivot, Self-service BI, Excel based spreadsheet-modeling, automation thru VBA, macros, project management, business analysis, interactive & dyanmic graphs, pivot tables, Excel formulas, functions, calculations, summarizing data, Excel formatting, shortcuts, productivity, application development, beginner to advanced Excel skills, excel ti ...
 
Loading …
show series
 
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 Da…
 
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 Da…
 
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 be…
 
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 be…
 
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 & 2 bonus tricks Relationships & data model One slicer to rule them all Show only top x values Relative performance Show uniq…
 
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 & 2 bonus tricks Relationships & data model One slicer to rule them all Show only top x values Relative performance Show uniq…
 
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 & software DV? Types of data validation rules List & custom rules explained Input & error messages Alternatives to data validation Enhancing data validation Removing data…
 
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 & software DV? Types of data validation rules List & custom rules explained Input & error messages Alternatives to data validation Enhancing data validation Removing data…
 
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 yo…
 
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 yo…
 
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…
 
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…
 
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 & Productivity Formulas Managing Data Charts Using Excel better Listen to this session Click here to download the MP3 file. Resources for thi…
 
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 & Productivity Formulas Managing Data Charts Using Excel better Listen to this session Click here to download the MP3 file. Resources for thi…
 
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 …
 
In the 48th session of Chandoo.org podcast, let’s make some animated charts!!! What is in this session? In this podcast, Announcements Why animate your charts? Non-VBA methods to animate charts Excel 2013’s built-in animation effects Iterative formula approach VBA based animation Cartoon film analogy Understanding the VBA part Example animated char…
 
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 entrepreneurs Key areas of a business owner’s work Projects & to dos Finances Customers & marketing Planning & strategy Processes & workflows 5 features of Excel that help Tables Financial for…
 
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 2016 What is a Gantt chart? How Gantt charts can help us? How to create Gantt charts in Excel Using bar charts with invisible series Using conditional formatting and formulas Using ready-made …
 
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 delay History of Monte Carlo simulations Monte Carlo simulations – an example How to do simulations in Excel Formulas VBA Data Tables Using data tables to run simulations – case s…
 
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 Excel Story of my first ever dashboard Important lessons – Requirement Analysis for dashboards Resources for creating awesome dashboards Podcasts Books Courses Listen to this session Click here to d…
 
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 & Replace VBA / Macro Recorder Auto save Auto complete / Int…
 
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 …
 
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 August 6 charts you should avoid 3D charts Pie / donut charts with too many sl…
 
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 in…
 
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, Announcements What is a loop – plain English & technical definitions For Loop vs. other kind…
 
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, Announcements What is Data to Ink Ratio? Obvious ways to optimize Data to Ink Ratio More ways to optimize Data to Ink ratio Highlighting what is important Conclusions Listen to this session Click here to download th…
 
In the 37th session of Chandoo.org podcast, Let’s debug ’em #VALUEs & #N/As. What is in this session? In this podcast, Introduction to Excel formula errors The easy kind: syntax errors The triky ones: # ERRORs Fixing errors – using IFERROR & ISERROR Error checking & debug options Using Errors deliberately – charts & data validation A challenge for …
 
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…
 
In the 35th session of Chandoo.org podcast, Let’s hear from Dan Fylstra, the creator of Excel Solver. I had the fortune of meeting Dan when I was in Santa Clara last month. I immediately asked him to be part of Chandoo.org podcast and he was kind enough to agree. So today let’s take a trip down the memory line, hear him talk about some of the fasci…
 
In the 34th session of Chandoo.org podcast, Let’s hear from Jordan Goldmeier – my friend, fellow blogger, Excel blogger & 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 …
 
In the 33rd session of Chandoo.org podcast, let’s turn the mic to our listeners and hear their tips. What is in this session? This session has 2 things. A surprise Easter egg (an Excel tip hidden in the podcast audio) Collection of Excel tips recorded & submitted by Chandoo.org readers Listen to this session Click here to download the MP3 file. Lin…
 
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 & 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 thi…
 
In the 31st session of Chandoo.org podcast, let’s disappear. What is in this session? Spreadsheets are complex things. They have outputs, calculation tabs, inputs, VBA code, from controls, charts, pivot tables and occasional picture of hello kitty. But when it comes to making a workbook production ready, you may want to hide away few things so it l…
 
In the 30th session of Chandoo.org podcast, let’s learn how to uncover fraud in data. What is in this session? In the wake of hedge fund scams, accounting frauds and globalization, We, analysts are constantly second guessing every source of data. So how do you answer a simple question like, “am I being lied to?” while looking at a set of numbers yo…
 
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. Her…
 
In the 28th session of Chandoo.org podcast, let’s figure out how to express business rules & 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…
 
In the 27th session of Chandoo.org podcast, let’s pave way for an awesome 2015. We are going to talk about 15 proven strategies for making you awesome in Excel & Your work. What is in this session? We all get fresh dose of energy, enthusiasm & drive during new years. So we aim for bigger & more awesome things. But once the first few weeks are over,…
 
A big, warm & pleasant hello to you. I wish you a merry Christmas & Happy New Year 2015. May your holidays be filled with joy, togetherness, celebrations and fulfillment. May your new year be filled with hope, energy and awesomeness. I want to tell you how thankful I am for all your support in this year. Every time you visit our website, read an ar…
 
In the 25th session of Chandoo.org podcast, let’s learn how to avoid SSUP syndrome. What is in this session? Most of us suffer from Sexy on the Spreadsheet, Ugly on Printout syndrome. I used to suffer from it too. This happens because we spend all our attention creating that perfect workbook, report or model. And then, we forget about making the pr…
 
In the 24th session of Chandoo.org podcast, let’s customize Excel so we become productive. What is in this session? Each of us use Excel in our own way. And yet, we all end up using the same Excel. That is not fair. Shouldn’t the Excel of an accountant be different from Excel of a teacher? In this podcast, lets understand some of the powerful & use…
 
In the 23rd session of Chandoo.org podcast, lets talk about my experience with Hudhud cyclone. Note: This podcast session has no Excel tips. It is a story of how our family is surviving the effects & aftermath of destructing Hudhud cyclone that recently (on 12th October) passed thru our city. Hopefully, you still find it interesting & inspiring. If…
 
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 …
 
In the 21st session of Chandoo.org podcast, lets compare lists. Quickly What is in this session? Comparing things is a favorite pastime for analysts all over the world. Sadly, it is also an area where we waste hours. So in this episode, I share my top secret comparison techniques to save you time. Note: This is a short format podcast. That means yo…
 
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, Anno…
 
In the 19th session of Chandoo.org podcast, lets talk about modeling best practices. What is in this session? I am very happy to interview my good friend, blogger, author, excel trainer & business-women – Danielle Stein Fairhurst for this session. I first met Danielle when I went to Sydney, Australia in April 2012. Our friendship & collaboration gr…
 
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 & 17 episodes to reach this milestone. Thanks for loving Chandoo.org podcast. You …
 
In the 17th session of Chandoo.org podcast, lets leave Excel aside and talk about other MS Office apps. Thats right. We will be learning 10 tips on how to use Word, Power Point, Outlook etc. Ready? What is in this session? A while ago, I got an email from Paul Woods. Paul is an Office 365 MVP, fellow blogger, father of twins and intrepreneur. Since…
 
In the 16th session of Chandoo.org podcast, lets review 3 very useful books for aspiring analysts. What is in this session? Analytics is an increasingly popular area now. Every day, scores of fresh graduates are reporting to their first day of work as analysts. But to succeed as an analyst? By learning & practicing of course. And books play a vital…
 
In the 15th session of Chandoo.org podcast, lets answer some of your burning Excel questions. What is in this session? Around last week, I invited you to ask me anything. More than 150 people responded to this call and sent in their questions. Since answering all the questions is not possible, I handpicked roughly 10 questions to answer in this epi…
 
Loading …

快速参考指南

Google login Twitter login Classic login