How to use online classroom? [FAQs]

Hi there,

Welcome to our online classroom. Please take a minute to watch this video. It will help you understand,

  • How our online classroom works
  • What is a lesson plan and how to use it?
  • How to ask questions & doubts?
  • How to change your profile (display name, email address, password, avatar etc.) ?
  • How to watch lessons on your iPad / Tablets?

Watch the introduction video:

Download the Video

: Download lesson video

Any questions or doubts about our online classroom?

Just reply to this article or send us an email at purna.duggirala.va@gmail.com

 

68 thoughts on “How to use online classroom? [FAQs]”

    1. @Yousef,
      The website is not designed for playback on Mobile devices. If your membership level allows downloads of video, these can synced post download with the mobile devices; however, direct viewing of them online on mobile devices will not work.

  1. Videos not loading.
    1st Lesson, apparently no link for me.
    FAQ How t0 Use Online Classroom, stuck on Please Wait
    My popup blocker off, chandoo made a trusted site.

    1. Sorry to hear that. Can you tell me which browser / device you are using. Also, do you have any content blocking rules for 3rd party content (as we us lsns.excelschool.in domain to serve the videos).

  2. thanks for reply

    desktop conventional PC
    Dell Inspirion 537 00
    2.70 gigahertz intel Pentiom Dual-Core
    64 bit ready

    Windows 7 Professional

    Internet Explorer 10

    In Explorer security tab
    zone Internet, set at medium-high, enable protected mode: on
    zone Trusted for site http://*.chandoo.org: set at low, enable protected mode: off
    no other known blocking rules

    1. I just replicated this in IE10. Very strange. When I load this page from FireFox, I can see the video alright. But IE10 seems to have trouble fetching the videos. Can you use an alternative browser like FireFox or Chrome? I am sorry for the trouble.

    2. Okay… found a solution. You need to disable Active-x filtering. This seems to be the culprit.

      Press ALT+T then uncheck Active-x Filtering
      Now reload the page and videos play!

      This sounds like an unsafe thing to do, so I would either switch to Chrome / FF or restore Active-x filtering later or set up a rule (not sure how to) only for chandoo.org to switch off Active-x filtering.

  3. Thanks for attention, findings. (Need to leave now, will be back to try/enjoy later. Did sneak in an attempt with Safari, seemed to be encountering same— but maybe my various processes were interfering with each other.)

  4. Chandoo,

    I have a data challenge that I can’t seem to get around. Many of my clients are in the air conditioning and heating business selling to consumers. I have several years of transactional data by address, by date, by type of transactions, and by sale amount.

    There are 4 different kind of transactions. Replacements, repairs, maintenance, and service contract payments.

    What I am trying to determine and present is what percentage of the first transaction with a customer are in each category.

    Thanks!

  5. Could you please let me know which of your classes would work more with formulas? I have enjoyed the Power Pivot class, but I need more work with the measures and formulas in excel.
    Thank you

  6. Need help on Separating City State that is in one cell. No commas. I tried Text to Columns in excel but it separates only if you have 2-items in the Column. Example–Denver Co will work in Text to Columnes.

    SAN PEDRO CA
    –These needs Two Columns City & State not three. Do I need a formula for this?

    Thanks
    Marty

    1. @Martin,

      1. Extract City : =IF(ISERROR(LEFT(A1,FIND(” “,A1,FIND(” “,A1)+1))),LEFT(A1,FIND(” “,A1,1)),LEFT(A1,FIND(” “,A1,FIND(” “,A1)+1)))
      2. Extract State : =IF(ISERROR(LEFT(A1,FIND(” “,A1,FIND(” “,A1)+1))),LEFT(A1,FIND(” “,A1,1)),LEFT(A1,FIND(” “,A1,FIND(” “,A1)+1)))

      This will work if there are 2 spaces (SAN PEDRO CA) or 1 space (CITY STATE).

      You can modify this I there are 3 spaces as well.

      ~VijaySharma

  7. Hello,

    I have a problem that I hope you could help me with. I have a pivot table from an OLAP source with contract data; customers in rows and month in columns. I want to count terminations per month, the logic in English would be something like: “count all blank rows which the month before were non-blank”.

    I tried my way around some countifs(), but did not get them to work.

    Thankful for any help

    Regards
    Bjorn

  8. I watch the lessons on a Nexus 7. They work well when I have an internet WiFi connection. When I try to download the files, so that I may watch them when WiFi is not available, the file downloads, but is then unplayable. Any suggestions?

  9. I am having a real hard time keeping track of my progress 🙁
    I can only sporadically drop in and view the courses. But each time I struggle with figuring out where I had left off. Any practical tips on how to handle this?

    Would have been nice if the site had some features to support that (check marks to show videos I have completed, ability to resume a video where you had left off). But I am more than open to alternate even unconventional strategies. I could use a Skydrive/Google Docs document where I note my progress (I use multiple devices). Wondering if other users have any ideas around this?

    1. @Avichal,

      Currently we do not have this functionality into the classes, and you also mentioned the best possible way to track your progress by creating an online document. I would encourage you to use that till we have another solution.

      ~VijaySharma

  10. I NEED HELP! I HAVE A SMALL CONSULTING GIG I’D LIKE TO PAY THROUGH PAYPAL.. IT CONSISTS OF vB CODES AND LITTLE PROGRAMMING..

    I JUST WANT TO EXPLAIN, I RECEIVE LOT OF MEDICAL RECORDS IN PDF FILE AND I’D LIKE TO NAME THESE FILES ACCORDING TO PATIENT’S FIRST AND LAST NAME WITH THE ID NUMBER ON THE PDF FILE. i DON’T WANT TO MANUALLY OPEN IT UP ONE AT A TIME AND THEN DO THE RENAMING. I HAVE THOUSANDS OF THEM. I KNOW THERE IS WAY USING VB CODE TO DO THE CONVERSION. PLEASE TELL ME IF YOU CAN DO IT WITH PROVIDING ME WITH INSTRUCTIONS. I WILL PAY. PLEASE EMAIL ME AT aubon@hotmail.com subject: Small Consulting Job. Thanks Annie

  11. Chandoo,

    I really want to know if you can share that secret of your on the first business dashboard. You never gave us the formula or teach us how you use data validation to put the dates on the corner of the dashboard. Please share your answer with us.

    Thank you,

  12. A Question for the smart Execel Gods:
    In SQL 2008 R2 I have a like Statement: Where (TeamId like N’Gold%’) I get back
    Gold.1
    Gold.2
    Gold.3
    How is this done in excel 2010 or in a Slicer

    1. @Bharat,

      If you want to just filter rows that contain Gold then you can use filters and search for Gold.
      Filtering based on wild card is not possible with slicers.

      If you want to sum or count values based on cells that contain gold, then use wildcard character * in SUMIFS or COUNTIFS.

      Example =COUNTIFS(A1:A10, “Gold*”) will count how many cells in the range A1:A10 contain Gold.

    1. Hi Gaurav ,

      Can you explain what you mean by live example of VBA code ?

      Do you mean that you want real-life examples instead of made-up examples ?

      Narayan

      1. Hey Narayan,

        Yes, I believe so. there should be some example code as I read somewhere before joining. Live example help us to understand the thing quickly and brings us in playing zone.

        Is there any other way to interact more quickly than write it here and expect an answer after couple of hours. I have more questions to ask.

        Thanks!
        Gaurav

        1. Hi Gaurav ,

          You don’t become a musician only by listening to Mozart. Or a mason by looking at buildings.

          Programming in any language involves learning the building blocks of the language ; once you are comfortable with constructing simple segments of code , you can progress to more complex constructions , without which you cannot have real-life working code.

          Have patience and keep learning.

          In a journey which can take a year or two , I don’t think a couple of hours really matter.

          Ask your questions and I’ll try to answer them as soon as possible.

          Narayan

  13. Hello,

    Is there any way to watch the video full screen without the view being blurry?
    It’s hard to watch the lesson without it being full screen but when I use the full screen option everything becomes blurry.

    Thanks,
    Monique

  14. Hi,

    I am new to the classes..please confirm if I can download the sample worksheets..was trying to download salary analysis from 50 ways to analyze data category.

    Regards,
    Tarun

  15. Hello Chandoo,
    I am frequent traveller and do not have my laptop most of the time. I tried opening the videos on mobile but was not able to. Please guide.

    1. Hi Jinesh, You can download and sync videos to your mobile device. I recommend keeping the spreadsheets open on a laptop for pause + practice. I am not sure about video compatibility with mobile browsers, so download + sync is best option.

      1. I am not able to download videos on Laptop. It is just giving otion to download Transcripts.
        Please advise below –
        1. How to download videos (couldn’t find any links)
        2. How to view videos on Mobile?

        Your earliest help required.

          1. @ Jinesh
            Your lesson plan is at https://chandoo.org/learn/excel-school-new-lesson-plan/
            Below ever lesson, you can see
            Download this lesson & Watch at leisure
            Download lesson video
            at the above link, place your mouse pointer and right click. select save link as and show the folder to save the file.
            it will be in mp4 format which can be played in any mp4 supporting media players

Leave a Reply

This site uses Akismet to reduce spam. Learn how your comment data is processed.