45 thoughts on “Lesson Plans”

  1. Hi Chandoo.. am not able to view these online video lessons thru my Tab (Celkon CT2). Is there any possibility to view using Tab or Mobile (Nokia N8). Please guide me how to view using any of the above two devices. This will help me to go through the lessons whenever and wherever possible . Thanks, Pradeep Sarma

    1. @Pradeep,
      These lessons webpages are not designed for view over mobile devices. If you have download option in your subscription, you can download the videos and sync them with your device. However, Online playback on mobile devices is not supported.

      1. I could be wrong but this response is contradictory to what is satated in your Q&A section where you state that lessons can be viewed on mobile devices. Even with that I havn’t been able to use my iPad to continue with my lessons on the go, whch is disappointing.

    1. @Leilani,
      The lessons can be viewed full-screen. If you do not see the full-screen icon on any of the lessons, then you might need to upgrade the flash video player. If this is an issue with specific lessons, please let us know the lessons. With most of the lessons, the Excel files developed in the lessons are available for download and you can review the formulas in the Excel files as well.

  2. Why is it that when i “down load” I only get the excel example not the MP4 video you mention?
    Also why not have one place where all class videos are available for downloading?

    1. @Abdalla,
      If your membership plan allows lesson downloads, then you will be able to download the Lessons as Zip archives which contain the mp4 videos. The Excel files are available for download with all lessons in the “Download Links” section below the lesson and the videos are available in “Download this lesson & Watch at leisure” section just below the “download Links” section.

  3. Hi Chandoo/Sameer – Can you please have a relook at the recording of the videos because the quality of resolution seems to be not in par with your VBA and other classes (the fonts and other writting seems to be bit unclear)… are you using the same tools for recording or resolution ratios. Not a big problem just thought will let you know

    Still awaiting your respense on the the issues with bit large file with few columns (say 20-30MB+) size…having excel freezing and not responding. Just FYI I am using 32bit MS Excel Professional Plus with V2 PowerPivot.

    Cheers!!
    Dibs

  4. Hi, I am thoroughly enjoying the lessons and learning so many nuggets…
    I have one question about conditional formatting…?
    Can an email be sent to a person, depending on the value of cell? For eg: we deal with a lot of garments and we may sell out of a particular style. Can an email be sent regarding a “SOLD out” style?

  5. Sir,

    Charan Sparsh.
    Many thanks to Sir for accepting us.
    And Heartiest Pranam to all buddies.

    It is late in the night. Today, logged in just to wish Sir and other mates.

    Respectful Regards,
    Krishna Kant

  6. Hi Chandog
    I am not really sure I understand the format of this class. Do we just watch he videos and then submit any question that we have or will you be sending us homework that needs to be turned in at a given time. Finally, are you going to be offering online tutoring outside the videos. Please advise, just curious.
    Thanks
    Remy

  7. Hi Chandoo
    Need urgent help on VLOOKUP
    If the target location is empty (no data), it is returned as 0, how to return empty instead of 0.
    I have also sent an email with example attached.
    Satpal

  8. HI Where can I find usage of date function? What I’m looking for is, I have couple of criteria, if met, have a set of dates which should be assigned accordingly (perhaps in increment). Have about 100 records in the file and 5 different set of dates. Can send the file, if required.

    regards

    Yoga

  9. Hello,
    Under the nested if lesson as I was using the Weekday(today()) formula it was bringing back January 6, 1900. How am I able to sync the date to my laptop? Not a huge deal, just curious.

    By the way, these videos have already helped me tremendously!

    Thank you!
    Cherise

    1. Hi Cherise ,

      The WEEKDAY function accepts as a parameter , a valid Excel date , and returns as output , the number 1 through 7. There are different versions of this function , where the meaning of 1 differs. One of these versions uses 1 for Sunday , and 7 for Saturday.

      Now , if you format the cell where you have this formula as DATE , then the return value of 6 will be displayed as January 6 , 1900. Format the cell as General , and you should see the digit 6.

      Narayan

  10. I think I bought VBA + download option, so why I dont have any video download link ? I wanted to buy VBA course with download option and not only viewing? also if I maximize the video window to full screen, it is not even HD???

  11. Hello Mr Chandoo,

    I just recently started your course and trying to follow the playzone exercises but as a beginner, I am depending a lot on responses to the questions being posted online but a lot of the basic BUT IMPORTANT questions are not being answered. The video and explanations are great but being able to see answers to questions are key as well. Also maybe give us an opportunity to WATCH you write the ANSWERS would be much more helpful/

    1. Hi Harley ,

      If you go through the comments section , you will find that questions are being answered. I try to answer every question that I come across. So far I have not seen any IMPORTANT question of yours , other than asking others whether their questions have been answered.

      Can you start asking questions on the lessons , and see for yourself ?

      Narayan

  12. Hi Chandoo, I’m unable to download videos from any of the advanced power pivot class… I’m a slow student and may require extended time to study the videos on my own pace… appreciate for your help.

  13. Hi Chandoo,

    I am unable to access my vba lessons. My account expires today (Jan 7th), but I would like to download the remainder of my lessons so I can view them offline.

    Thanks,
    Kristy

  14. Hi Chandoo, et.al.,
    I have an Excel workbook locking question, please.
    How do I hide and lock one or two worksheets within a workbook and then send that file onto other users to update the unhidden worksheets, maintaining links to the hidden worksheets, but enabling the other users to make changes to the unhidden worksheets? i.e., budget workbook with confidential salary data worksheets linked to consolidated budget worksheets to be sent to managers to update their worksheets, but want to keep salary worksheets hidden and locked. Even if they copy the file and rename it, will the hidden worksheets remain hidden and locked (if they don’t have the password)?
    Hope that explains my question well?
    Thank you!

  15. I am a student of excel school dashboards lesson plan, want to join for 50 ways to analyse data after i complete the current course. Pls let me know the cost, duration and when i can enroll.

    Thanks

  16. Hey Chandoo,
    I am not able to access any of the videos in the excel dashboard section. There is absolutely no issue on my end as i am able to access other excel videos. Please sort the issue asap.

  17. Hi All,

    The below code is to print the worksheet names in active workbook. Can somebody help me to declare the actual variable instead of Object.

    Sub sheetcount()

    Dim items As Worksheet

    Dim wks As Object

    Set wks = ActiveWorkbook.Worksheets

    For Each items In wks
    Debug.Print items.Name

    Next items
    End Sub

    with regards,
    surjit

  18. Hi Chandoo,

    I am Mandakini, have enrolled for Excel Dashboard Training with you. I am working in the travel industry as a Senior Operations Assistant in Revenue Management Department. I generate a lot of reports on Excel and would like to get your assistance in making a dynamic waterfall chart. Have provided you with the Savings Figures which is in a pivot table in the excel attachment.Could you please assist me in making the chart by providing me with the steps on how to create it.

    Thank you and regards,
    Mandakini

    Savings 2016/17 2015/16
    Ad hoc 131,600 123,520
    Group 1,824,805 1,347,370
    Recovered 88,391 272,661
    RM Deal 11,950,713 6,466,202
    Grand Total 13,995,509 8,209,753

  19. hello, can anyone please guide me on how to navigate through the website? The videos are not easily available/accessible. If I click on any link course link on the website it just takes me to another link that says “continue reading more” without any link to videos.

  20. Hello! What if I have data on multiple sheets? Call volume, completed assessments (can have multiple done same day) and agent ready statuses; how can I pivot the number of calls made in a day to compare to the number of assessments?

    If you could point me to where I can learn this, it would be greatly appreciated!!

Leave a Reply

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