Financial Modeling School > FAQs
Financial Modeling School FAQs
-
FAQs on Financial Modeling School Methodology
- Do I need to be online at any specific time?
- What do I need to enjoy the lessons?
- I am an absolute newbie, can I join Financial Modeling School?
- What version of Excel do we use in this program?
- Can I ask questions or doubts?
- What happens if I am busy and cannot log-in for a while?
- How does Financial Modeling School Work?
- How much time does it take to finish the lessons?
- Will I get a certificate when I finish the course?
- What happens if I finish viewing all the lessons?
- What is the difference between ONLINE Option and ONLINE+DOWNLOAD Option?
- What do I need to sign up?
- How can I get my company pay for this program?
- Can I get a payment receipt?
- Can I upgrade to DOWNLOAD Option later?
- Or there any other payments or hidden costs?
- Do I have Money Back Guarantee?
- Are there any team discounts? I want to sign up my entire team.
- Financial Modeling School is pricey…
- Will there be any home work?
- What are the topics covered in Financial Modeling school?
- Can I share the lessons or example files with colleagues or friends?
FAQs on Pricing, Payments & Discounts
FAQs on Topics & Content
Other FAQs
Do I need to be online at any specific time?No. You can watch the lessons at leisure. All the lessons are immediately accessible as soon as you sign-up. You can log-in and go thru the lessons at your own pace and comfort. You can even download the lessons and watch them offline (if you purchase the download option).
What is the difference between ONLINE Option and ONLINE+DOWNLOAD Option?Everything is same between ONLINE and ONLINE+DOWNLOAD options. The only added advantage of DOWNLOAD option is that, you can download all the lessons in HD quality and view them offline. This can be a very powerful thing as you get to see lessons at higher resolutions and repeat them at your wish.
What do I need to sign up?You need a credit card to purchase financial modeling school membership. In certain countries, you may use your checking account to make the payment too. Optionally, if you have PayPal account, you can use that too purchase financial modeling school membership. But in any case, having PayPal account is not necessary.
What do I need to enjoy the lessons?
- A computer with a modern browser (IE7, Firefox or Chrome)
- Excel 2007+ (Excel 2003 is fine too, but some lessons are suited for Excel 2007)
- Speakers or ear phones that can give you good quality output
- Time and zeal to learn
How can I get my company pay for this program?I have prepared a simple document explaining this program. Download [pdf link] and send it your boss. Since $297 is not a big amount, your boss should be happy to invest in your skills.
Can I get a payment receipt?Yes. As soon as you make the payment, We will send you a receipt. You can use this to claim reimbursement at work. Let us know if you need any additional documents, We can provide you them. Write to me at chandoo.d @ gmail.com.
I am an absolute newbie, can I join Financial Modeling School?The answer to this mixed. If you know various financial concepts (like balance sheet, profit-loss accounts, cash flow statements) then you can join the program even if you don’t know much excel. If you don’t know much about excel, then you should watch Excel Tutorials for Beginners series. But if you are completely to new to the world of finance and Excel, it may be difficult to follow the pace of this program.
What version of Excel do we use in this program?Excel 2007. For all the demos and videos, we use Excel 2007. Whenever we discuss an incompatible feature, We will provide some alternatives for Excel 2003. But this is not always possible. But most examples and ideas can be implemented right away in Excel 2003 or above.
Will there be any home work?Yes, At the end of each lesson, you can download a student copy of worksheet so that you can fill-up the file as per your understanding.
Can I ask questions or doubts?Absolutely. Financial Modeling School is similar to Chandoo.org blog. You can go thru the lesson and ask questions using comments feature. Both Paramdeep & I will answer them as we get time. Not just us, any one in the class can answer the questions.
(Pls. note that we cannot answer specific questions related to your work or not related to the topic under discussion).
What happens if I am busy and cannot log-in for a while?No worries, just log-in when you have time and go thru all the pending lessons. You can read / watch them in any order too.
Can I upgrade to DOWNLOAD Option later?Sure you can. It costs $77 to upgrade to DOWNLOAD option. You can find links to upgrade in Financial Modeling School.
Or there any other payments or hidden costs?No, there are no other payments or hidden costs other than what is stated here. You either pay $297 or $217. That is all.
Do I have Money Back Guarantee?Yes. Your membership comes with 30 day money back guarantee. If you don’t like the program, please email me asking for refund and I will refund the money and cancel your membership. No questions asked. And the beauty is, we are still cool.
How does Financial Modeling School Work?Once you pay the course fees and sign up,
- You will be given a userid and password to access classroom area
- Once a week we will post new lessons & material in the classroom area. You can login and review this whenever you are free.
- You can download example excel files, home work and videos (if you sign up for download option) for further learning
- You can ask questions or discuss topics with other classmates thru comments
Learn more about Financial Modeling School from this guide. [PDF]
What are the topics covered in Financial Modeling school?Please refer to Financial Modeling School course curriculum guide[PDF] for more information on this.
How much time does it take to finish the lessons?Our estimates suggests that it would take 3 hours of viewing every week per 8 weeks to finish the program. On top, you may have to spend 2 hours a week practising what you learned. So, that would be an hour a day for 2 months of 2 hours a week for 4 months.
Are there any team discounts? I want to sign up my entire team.Thank you. And of course yes. If you sign up more than 3 people in one shot, you get 25% off the price, for all the students.
Please specify the quantity in order form and your discount will be applied automatically.
If you need further help, just send me an email – chandoo.d @ gmail.com or call me at +1 206 792 9480.
Will I get a certificate when I finish the course?You can request for a certificate when you are done going thru lessons. Around week 8, you will see a “request certificate” button. Use it to get your certificate.
What happens if I finish viewing all the lessons?Financial Modeling School is open from the time you register till April 18, 2011. You are free to repeat any lessons or ask questions if you have finished all of them.
Financial Modeling School is pricey…$217 (or $297) is what you will earn in a few days in most countries around the world. Investing this amount to boost your career skills is a very good move. Financial Modeling is a highly sought after area of work and knowing how to develop proper models can be of tremendous value to your career. However if you are finding this as an expensive option, I can totally understand to you. Here is what I suggest. Don’t join the program. Instead, go thru this free financial modeling course. Also there are very good sites like corality.com, plumsolutions.com.au offering good content on project finance, financial modeling etc. for free. Visit these sites to learn more and become awesome.
Can I share the lessons or example files with colleagues or friends?You cannot share lessons or videos with anyone. You cannot also share the bonus content (free ebooks etc.) with anyone. You can, however, share the example files with colleagues purely for work reasons (ie, if you use the example workbook to prepare a chart, you can share that).
Please note that Financial Modeling School content is copy-righted and protected by international laws. You are allowed one license for viewing, repeating, learning from the content. You are not given any rights to reproduce or share the content with out our explicit authorization.
You are also not allowed to share your login id / password with anyone.
Join Financial Modeling School Now
We are sorry, but registrations for first batch of Financial Modeling School are now closed. We are busy teaching Financial Modeling to 105 students in this batch. We will be re-opening registrations in February 2011.
Please leave your name and email id below, so that we can get in touch with you when the registrations open.
How the Purchase Process Works?
We hope to see you in Financial Modeling School.
About Your Teachers:
Paramdeep
Welcome to Financial Modeling School.
My aim is to make you awesome in financial modeling. I have co-founded Pristine Education and till data taught Financial Modeling to 100s of individuals in investment banks, equity research firms etc.
Chandoo
At Chandoo,org, I have one goal – “to make you awesome in Excel”. I have started writing about Excel in year 2007. To date, I have authored more than 350 tutorials, articles and how-to guides and trained 650 students and made them awesome in Excel. I have received prestigious MVP award from Microsoft in years 2009 and 2010.
We hope to see you in Financial Modeling School.
How does Financial Modeling School work?
Links & Downloads
| Financial Modeling School FAQs |
| Course Contents & Methodology [PDF] |
| Example Lesson – Overview of Integrated Financial Model [ZIP] |
| Want to pay thru Bank Transfer? Indian Pricing & Account Details |
24 Responses
I’d suggest simply using the subtotal function and filtering the data using the Win/Loss column. You get the same results and the formula is more comprehensible.
@John
That is one option.
There are times however when you want to see the whole data table or a filtered subset and still want to produce summary reports against an unfiltered field.
Is there a particular reason why you are using a comma and the unary (–) operator for the second array in the SUMPRODUCT formula? It seems to work the same if you were to string the arrays together using the asterisk (*). The advantage is that SUMPRODUCT treats the entire string of arrays as a single array.
@Mathew
Your correct, There is no difference.
I thought it may have been easier to explain this method.
Is there a way to do this on a large set of data? As in ~100,000 rows? When I try I get an error because the formula becomes too long. It says the max length of a formula is 8,192 characters. Excel 2010.
How do I incorporate a specific text within a cell for the second array. For instance, – -(C7:C13=”Apple”)
when I chose a specific text the formula does not work.
@RB
I am not sure what is the issue as if I use the sample data in the post the following work fine
Count:
=SUMPRODUCT(SUBTOTAL(3,OFFSET(C7:C13,ROW(C7:C13)-MIN(ROW(C7:C13)),,1)), –(C7:C13=”L”))
Sum:
=SUMPRODUCT(SUBTOTAL(3,OFFSET(C7:C13,ROW(C7:C13)-MIN(ROW(C7:C13)),,1)),(C7:C13=”L”)*(D7:D13))
You may want to check that there are no leading or trailing spaces in your list of Apples
I should have given a better explanation. Heres my situation. I have a column with cells filled with names like Column 1, Column 2, Pier 1, Pier 2, etc. If the cell just contained Pier and searched for that it works. But because it has other characters in the cell its not recognizing the pier. So how can I extract specific characters of a string of text in this formula?
Hopefully this was a better explanation
Hello-
This formula works pretty well for me except that it slow down excel and prevents some of my macros from working. I was wondering if there was a way to program this in VBA so that excel isn’t always trying to recalculate it. I would like to use a push of a button to get it to run then paste in a cell.
Thanks!
I am trying to sum filtered data in a column, but would want to ignore the negative values in the column. How to go about doing this?
@Akshay
Why not just add a filter to that column to only show the values greater than zero?
The negative values are required for reporting purposes, but their effect on the total is distorting the required output. Please advise.
@Akshay
I’d suggest making a post in the Chandoo.org Forums
http://forum.chandoo.org/
Attach a sample file to simplify the task
I have this working for counting and summing, however, I have a list and for the second array, I need a criteria. That is, I’m looking for b13:b200=”01.??.??” or =left((a1,2) or something like that. These types of criteria matches do not appear to work as I get a blank as a result.
Thanks!
@Bob
As your formula b13:b200=”01.??.??” looks like you are trying to check the first day of the month of the range
What about trying Day(B13:B200)=1
Hai Experts,
i understood this formula well and working fine in MS Excel 2013
but when the same am trying to place in google Spreadsheet it shows error as
“SUMPRODUCT has mismatched range sizes. Expected row count: 1. column count: 1. Actual row count: 2014, column count: 1.” and as a result #VALUE! Appears in cell.
Can anyone please help me how would i get it done in Google Spread sheet
or is there any other formula as a substitute for this.
Thank you very much.
thanks for providing this.. but why does excel keeps on prompting Circular referencing in cell D3?
@Vivek
I don’t know
I just downloaded the file and it is working fine and not showing that error
Goto the Formulas, Calculation Options Tab and check that Calculation is set to Automatic
What version of Excel and Windows are you using ?
I know that this forum is for MS Excel, but I am trying to help someone who is working in Google Sheets. The below formula works in Excel but Google Sheets returns:
“SUMPRODUCT has mismatched range sizes. Expected row count: 1. column count: 1. Actual row count: 39000, column count: 1.” and as a result #VALUE! Appears in cell.
This is the same problem asked by Srichirin above. Does anyone know if there is a formula for Google Sheets that will replicate what MS Excel does?
=SUMPRODUCT(SUBTOTAL(3,OFFSET($C$6:$C$39500,ROW($C$6:$C$39500)-MIN(ROW($C$6:$C$39500)),,1)),- -($C$6:$C$39500=H1),($D$6:$D$39500))
Trying to find a SUMPRODUCT formula that counts the word Closed by date for the last 7 days in a filtered list.
=COUNTIF(M:M,”>”&TODAY()-7) works ok for unfiltered count Column M contains Closure dates (blank if open) and Column L is Status Open or Closed
@ Terry
Please ask the question at the Chandoo.org Forums
https://chandoo.org/forum/
Please attach a sample file to ensure a quicker more accurate answer
I used this formula and worked like a charm! But, now I’ve been requested to use it but adding not one but two criteria in the same formula. For instance the sum I was doing added negative and positive numbers. I’ve been asked to use the exact same formula but adding that only positive numbers were considered… any idea on how to do this?
How exactly do you do sum filtered cells when two criteria are need not just one?
Thank you so much brother literally I have been struggling since morning to get the sum of the filtered category, however, after reading your blog attentively i got my solution, so thanks a lot once again.