We are having the same problem: paid for the class yesterday, was sent all of the log-in info, put it all in to try and get the lesson plan but the screen here is reading “Please Log-in to access that page.” What’s up?

Hi ,
My name is Bronwyn. I work in Australia for a State Government department. I am looking forward to improving my Excel skills particularly in advanced formulas and dashboards. I would also like to complete the VBA lessons later in 2012.

Hi Chandoo, I purchased the complete package last year. Did not have much time to spend on the classroom till now. When I tried to access the download page, it says I might not have signed up for it. Please help. Thanks!

I am having the same problem as Serene Tan. Ironically, I am attempting to sell this school to a bunch of my colleagues, and I can’t demonstrate the materials and website to the manager who is about to sign up a bunch of people for an Excel training class… It sure would be nice to be able to demonstrate the material for her so I can get you a bunch more students!

I paid for the excel course and due to time constraits was not able to complete all lessons. WhenI try to access, I have very limited access. Is there a time limit to accessing the excel school, or once you have paid, do you have continued access?

Hi Neha,
Thank you for the comment.
You have subscribed for the classes on Jan 13, 2011 and the subscription is valid for one year from the date of subscription.
However you can extend the subscription by playing a little amount.
Send us an email to chandoo.d@gmail.com to know the price for extension and to get an invoice.
Thank you
Ravindra

@Arjun,
Can you please write to purna.duggirala.va@gmail.com with your concern? If your membership is valid, you should be able to access the lessons. Otherwise, Ravindra/Chandoo will revert to you with what is possible.

Hi Chandoo,
My duration to access the downloadable content is expired, But still i face some problems in day to day working in excel. Can i ask my queries?
Also i am stuck with stupid problem. In excel please let me know how i can convert lakhs format in millions? for example:
i want to convert
1,14,200 into
114,200
Please help

@Bharat,
The comma format in Excel will default to millions if your regional setting as set to US. Otherwise, it will show the regional setting number format as per the region selected in Windows Region Settings.

@Arun,
Are you still facing the issues with download or Access to the lessons? This could be because of account activation delay, and as you did not repost this concern, I’m hoping you were able to access and download the lessons. If you are still facing these issues, please do write to purna.duggirala.va@gmail.com with your concern.

@Neha,
Can you please write to Admin Help/Support Email at purna.duggirala.va@gmail.com to get a confirmation of your membership status and the exact issue you encounter (log in error, unable to download error, etc)?

@Sue,
Ravindra, our Student Admin, can confirm the status of your membership and its expiration date and options to extend the membership if the membership is past the expiration date. Please write to him directly at purna.duggirala.va@gmail.com.

@Gerard,
If you are unable to log-in, your membership might be past the validity expiration date. You can confirm the options available with Ravindra, Student Admin, by writing to him at purna.duggirala.va@gmail.com.

@Doug
As you have upgraded your subscription, we have moved you to VBA classes, where you can get all the material for Excel, VBA and DB.(Please refer our email Dated August 31)
Please Visit VBAClasses.
Thank you
Ravindra

I was trying to access some class material but was unable to do so. I had paid for this course and of what I recall, I could revisit old lessons and material shared with me when my registration was live. Could you please help me with issue.

@Preeti,
You can write to Ravindra, our student admin, at purna.duggirala.va@gmail.com to confirm the status and validity of the membership. You can revisit old lessons while the membership duration is valid. If it is valid, Ravindra can review and resolve the issue.

@ssa
i have one requirement is
if i have three rows A and B and C
and i have value in all rows with three decimal point like 2.340,4.568,9.54.786,23.986,102.231,33.333
and i want to highlight value that which is lowest value
and the value remain after divide/2
like 102,234 value=.231 and in 2.34 remain value is .34 , and 33.333 value=1.333

@Rahul,
I’ll request you to post queries in relevant lesson plan sections to allow everyone to benefit from them. Please post this query in conditional formatting lessons. To get you started, you will need a MOD formula and conditional formatting formula rules to get your result.

@ssa
if i use this formula value shows true
{=MIN(MOD(A1:A10,2))}
but in conditional formatting i apply this formula but it not showing true result..
and i click on conditional formatting lesson but my membership duration has been over now so i have to jump on this page automatically..
and i will renew it

I am a paid online student. I was doing a powerpoint project at work, so had to focus on that. Now I am here in the office and trying to get information to do my job, and I can’t get into class. What’s up?

I am working on a Leave report for my process. here’s what i am trying to do, if an employee submits a leave application for a specific period, i want to know how many employees have already been given leaves in that period. I have roster for the employees, so if an employee submits a leave application from 8 June 2104 to 20 June 2014, i want my report to show how many leaves are already approved in that period..