In the 45th session of Chandoo.org podcast, let’s get in to Monte Carlo simulations.
What is in this session?
In this podcast,
- Quick personal updates – 200km BRM and book delay
- History of Monte Carlo simulations
- Monte Carlo simulations – an example
- How to do simulations in Excel
- Formulas
- VBA
- Data Tables
- Using data tables to run simulations – case study – estimating Pi value
- Things to keep in mind when setting up your simulation models
- Resources on Monte Carlo simulations in Excel
- Conclusions
Listen to this session
Podcast: Play in new window | Download
Subscribe: RSS
Click here to download the MP3 file.
Resources on Monte Carlo simulations
Articles & tutorials on data tables & Monte Carlo simulations
- The best explanation about data tables & Monte Carlo simulations
- Estimating Pi ? value by throwing frozen hot dogs on Excel charts
- Simulating Monopoly board game to find best strategies
Example workbook – Estimating Pi value with Monte Carlo simulations
Courses:
- 50 ways to analyze your data from Chandoo
50 ways to analyze data is a comprehensive online course to help you become a better analyst. In this course, you will learn how to create Monte Carlo simulations, optimization models, advanced analysis models & visualizations.
Please click here to know more about 50 ways program
Transcript of this session:
Download this podcast transcript [PDF]
Simulate stuff? Stimulate someone, share stories…
Do you simulate stuff at your work (or personal life)? If so, please share your experience with rest of Chandoo.org audience. Post your simulation process, tips & ideas in the comments section.
21 Responses to “Make a Pivot Table in Excel [15 Second Tutorial]”
[...] First step is to create Pivot Table. Here is a video tutorial on making pivot tables. [...]
Dear Sir,
I would like to study pivot table from basics detailed.Pls send me the tips of that
merccccccccccccccccccccccccccccccccccccc
[...] Click here to see a video tutorial of making pivot tables in excel | One more Pivot Table Video Tutorial [...]
it is very useful
hello sir
please send me some information of pivotable. and how to use it
because I am beginer so how can i learn it the pivotable.
and sir will you send me pivotable data because i have no data and i don't
know how to applyed for the pivotable. give some videos so I learn quikely.
thank you
and my best
anticipation
Hi,
This tutorail was helpful. If possible can you please email me some data, so I can create another pivot table? I am trying to learn ASAP and need some info.
Thank you
@Keri
Have a look at FakeNameGenerator.com
Top of the day to you. can you pls send me a detailed tutorial on the pivot table tutorial? Thanks.
Hi,
please tell me how to use Pivot table.
@Karthick, Yemi
Have a read of: http://chandoo.org/wp/2009/08/19/excel-pivot-tables-tutorial/
Dear Sir,
I visited this website of urs for the very first time and trust me this is fabulous.i learnt pivot table through this.Thanks a lot.In corporate world nobody gonna make u learn these things.m very grateful to u.This is a great initiative from ur side.Commendable job done.Hats off to u.For beginners also this is very helpful.The way this website makes u learn excel is very good.
Pooja
Can you please email me information to put into a pivot table and possibly a complete set of instructions? I am a beginner to pivot tables and am possibly interested in obtaining a position that requires pivot tables. thank you.
[...] Click here to see a video tutorial of making pivot tables in excel | One more Pivot Table Video Tutorial [...]
It's simply great..!!
Cool!
Fast but not furious.
Pls email me details of pivot table. I want to learn it asap because I just got a job that requires this. Thanks
it is very useful..............thanks
Sir please can u send me the complete explanation of pivot tables from basics
hello,
I wanted to know how to put pivot with emp id, emp name, emp position in one row.
Ex:-
cel A4 should have Emp id
Cell B4 should have Emp Name
Call C4 should have Emp Position
many thanks in advance
Nice information, thanx my dear.