• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User


  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Search results

  1. Hui

    Excel Insights (Coming soon)

    This April 1 will see the publication of Excel Insights. Excel Insights: A Microsoft MVP guide to the best parts of Excel This book was written by 24 Microsoft MVP's including myself. You can pre-order now at Amazon.com The book contains 24 chapters of all things Excel including: You can...
  2. Hui

    Excel Modeloff 2019

    Fancy your Excel modelling skills Have ago at: https://www.members.modeloff.com/
  3. Hui

    Happy 10th Anniversary Chandoo.org Forums

    Today on July 26, 2009 the Chandoo.org Forums were turned on. So after 10 years, 39,144 threads, 246,519 messages and with 51,201 members a big Happy Anniversary is in order Happy 10th Anniversary Chandoo.org Forums I look forward to the next 10 Hui...
  4. Hui

    Merry Xmas

    Merry Xmas from Puerto Princessa, Palawan, Philippines to all the Chandoo.org Followers and Fellow Ninjas
  5. Hui

    Excel 4th Dimension Challenge

    If you are interested A retired professor (he has presented at European Spreadsheet Risks Interest Group) is running a challenge on creating an Excel model based on 4 dimensions of data – details at the link below. https://www.ssmi.international/multidimensional-spreadsheet-challenge No...
  6. Hui

    Network Charts

    Don't know if you have a use for these type of charts to There is an addin available at: refer: https://appsource.microsoft.com/en-us/product/office/WA104379873?src=office&corrid=052877d3-e530-48ff-83f6-3b83cb78bb0b&omexanonuid=3eb7b2ed-019a-439a-8f59-e96f68a80f8a
  7. Hui

    Hui's World - An Excel project of Global Proportion

    Hui's World An Excel project of Global Proportion coming soon....
  8. Hui

    Develop Excel - London

    if your interested https://developexcel.wordpress.com/
  9. Hui

    Congratulations Chandoo.org

    Congratulations Chandoo.org on achieving the No. 2. in the Ten Best Excel Bloggers. https://hotkeyexcel.com/top-10-best-excel-bloggers-to-follow-2018/
  10. Hui

    Excel, Power BI - User Voice Dashboard

    Wyn Hopkins a director at Access Analytics has just made a Power BI/Excel https://app.powerbi.com/view?r=eyJrIjoiYWNlYjRmZWMtMzE2My00MTBiLTgxY2UtMDFhOWNlZDdkZTdiIiwidCI6IjNlMmRlMjgxLTVmY2MtNGU3ZS04Zjc1LTFiZjEzMjczYjQyYSIsImMiOjEwfQ%3D%3D This makes it easier to see what the current Excel...
  11. Hui

    Calculating a moving weighted average during Resource Scheduling

    I have a small query that you maybe able to help me with. It involves scheduling resource usage similar to my post: https://chandoo.org/wp/2010/11/18/scheduling-variable-sources/ I use a similar technique shown in the attached file: I have a list of resources (left) which are to be used in...
  12. Hui

    Excel Function Convertor

    Microsoft has released a free Excel Function Convertor https://answers.microsoft.com/en-us/msoffice/forum/msoffice_excel-mso_other-mso_2016/new-excel-add-in-lookup-localized-function-names/a9f1ca64-dd15-4998-8f8a-51606d66a452
  13. Hui

    Congratulations New Ninja - Vletm

    Just a quick note to acknowledge the appointment of Vletm as a Chandoo.org Forums Ninja Vletm has been a forum member for the past 3 1/2 years and has answered over 3,300 posts during that time Congratulations Vletm on the appointment.
  14. Hui

    Excel man

  15. Hui

    Welcome New Chandoo.org Ninja - Bosco-Yip

    Just a quick note to acknowledge the appointment of Bosco-Yip as a Chandoo.org Forums Ninja Bosco-Yip has been a forum member for the past 3 1/2 years and has answered over 1,300 posts during that time Congratulations Bosco-Yip on the appointment.
  16. Hui

    Welcome to new Chandoo.org Forums Ninja - Chihiro

    Just a quick note to acknowledge the appointment of Chihiro as a Chandoo.org Forums Ninja Chihiro ha been a forum member for the past 2 1/2 years and has answered over 3,500 posts during that time Congratulations Chihiro on the appointment.
  17. Hui

    Welcome back SirJB7

    Welcome back SirJB7 Its great to see you back after an 18 months hiatus We hope all is well in Argentina
  18. Hui

    5 Minute Excel Challenge

    The guys at Data Pig Technologies are hosting a new contest called the 5-Minute Excel Challenge. The goal of this contest is to see the various techniques the Excel community uses to quickly pull together reporting dashboards. I’m hoping to showcase the versatility, flexibility, and ease of...
  19. Hui

    Free Excel Shortcut Book

    Paul "Terp" from https://www.amazon.com has just published an Excel Shortcuts book on Amazon The Excel Shortcut bible: https://www.amazon.com/Excel-Shortcut-Bible-Powerful-Shortcuts-ebook/dp/B01N767G7Z It is free through this Wednesday. Looks like Kindle only
  20. Hui

    Excel World Champ !!!

    Do you think you have what it takes to be the Excel World Champ? Microsoft wants to test your skills and creativity! From October 2016 to November 2016, Microsoft will run four rounds of Excel tests for residents of select countries. Only the top competitors in each round will make it through...
  21. Hui

    Excel Resources - Free

    A friend of mine, Jeff Robson, has written a number of White Papers and eBooks on implementing Excel and he highlights good and bad practices. I recommend having a browse through his catalog https://accessanalytic.com.au/free-excel-stuff/white-papers/
  22. Hui

    New'ish VBA Site

    Hi All Today I stumbled on Excel Macro Mastery http://excelmacromastery.com/Blog/ It obviously deals with VBA and has excellent posts on all things VBA from beginners level through to Arrays, Collections & Dictionaries Well worth a visit
  23. Hui

    Power Pivot Free EBook

    If you have an interest in PowerPivot have a look at: PowerPivot for Advanced Reporting and Dashboards https://www.packtpub.com/packt/offers/free-learning# But be quick
  24. Hui

    New Chandoo.org Excel Ninja's appointed

    The Chandoo.org Forum is proud to announce the addition of five new Excel Ninja's. Marc L Khalid NGO Throttleworks Nebu JeffreyWeir The Chandoo.org Excel Ninja status is awarded to those people who assist the Excel community via the Chandoo.org Forums in answering other people's Excel...
  25. Hui

    Excel - Happy 30th Birthday

    Excel was released on the 30 September 1985 You can read a bit about it at the following links http://itraining.bg/excel-30-years-history/ http://www.geekwire.com/2015/recalc-or-die-30-years-later-microsoft-excel-1-0-vets-recount-a-project-that-defied-the-odds/...