As someone who used it on a daily basis for nearly 2 years, I can confirm Think Cell really is a life saver, it just saves so much time and effort, and it's really easy and intuitive to use.
Visualisation is really a trend in the it-world. It makes things so much more understandable and comprehensive. Algorithms and solving methods for the problems are often more then enough. 🖥 🏁 ⏳ 📎
This is going to be really helpful for me. I already use pre-prepared Thinkcell graphs but have never prepared my own. Thank you for this. Love the way you explain, very clear. Have used many of your tips in my new job.
I have been using thinkcell for years now and I just cannot imagine my life without it - this is actually the only downside, since their pricing model is not kind to individuals...
Hi Luis, hope you're well. I have just started working on Think cell, currently developing a dynamic deck to present analysis using VBA. Please suggest is there any demo available for help(like we have for Qlik) or any important guidance as per your experience.
I've created a project for myself in Excel. I've already imported my list of movies from a txt file, sorted it alphabetically and grouped by the franchise. So now I'm inputting more data: the year, the main actors, the rating, the director and the duration. And I might do this with a macro if it's possible: to link my workbook database with a movie site so I can pull in all that data. And I'm also utilizing the movie datatype feature.
Leila, as always, you are truly amazing. Your explanations are so clear. Thank you for taking the time to create these videos and help us in academic and professional life
Very intriguing ... and PRECISLY why Prof. Leila is a 'must-watch' date on my calendar every Thursday morning. Once again, Leila lays out a baker's box of tempting donuts and muffins that create a strong temptation to set aside current projects just to sample EACH one .... SOOOO terribly tempting. Maybe not today ... but some day for sure. Thank you ... thank you ... thank you ... PS Mecho Chart??? ... have never heard the term before.
thanks for sharing Leila. this add-on looks really cool. the two questions that came to mind immediately, you answered right at the end of the video (does it work on mac? YES --- and what if I share with someone who doesn't run that add-on? NO WORRIES, IT'LL WORK ANYWAYS)
Dear Leila, can we use it in Power Point without additional program from think-cell? Such as we make a gap for the latest year on the graph like your ahown us
Leila thanks for this very helpful - is there a link or video on how to build the waterfall you did on min 0.38 that shows 2 scenarios in one bridge - thanks!!!!
Thanks Leila! What happens when I create a chart from an existing Excel model in PPT, and send only the PPT to someone else, will they be able to read the chart?
I pulled off some crazy Excel + PPT automated shit with a DWH in the back. Screw Tableau. It actually brought met to Data Warehousing. Now im the magic data dude
Hi! I had an unrelated question to this video but I hope you can help. I want to increase the size of the selection window of a drop down menu. Now if you open the drop down list you have to scroll to see al options. Is this possible and if so then how? Thanks
Thanks for the walk through Leila. It indeed looks like a very handy tool especially if you are creating reports and presentations on a regular basis. But what if you only need it once to set up one template - can it be used again without the full subscription? At $25 per month it is rather expensive....
Dear Sagenose, thanks for your feedback. Unfortunately, think-cell cannot be used without a valid license. However, we believe that we create amazing value even for occasional users. Find out more about our features under www.think-cell.com/videos.
Your work is excellent and much appreciated. With respect to think-cell, it can be fun to play with but they will not sell a single license so individuals can't license/use which is too bad.
If you are interested in this then just note that it seems the smallest order you can make is for 5 licenses (I wanted to use it to make better charts in a book)
Also do you have any excel addin to conduct multivariate analysis and correlation matrix plot? i don t necessarily want to use python or R for very small data set but want to be able to populate very nice correlation matrix plot for multivariate analysis or multiple linear correlation analysis.
Leila, when pasting complex waterfall graphs from excel to powerpoint, my ppt file size expands to around 34mb. What prefered pasting option is best recommended to keep size smaller. I struggle to send the report out via email as its too big. Plz help!!! Its a massive headache in my life and im sure for alot of ppl
Leila do you have any specific keystroke visualizer, or do you add keystrokes in video editing phase? I'm asking because your keystroke visualizers are amazing and I don't know how to edit videos so if there is any software that does it this well, I would be really happy to get it.
The tool she is propably using for recording the screen is Camtasia and there is an option to record keyboard actions and display them in a way she wants to. Here is explained how to use this feature: ruclips.net/video/gXKgi2kr-QA/видео.html&ab_channel=DemocastMedia
Hello I am a man in Korea who uses Google Spreadsheets to analyze stock data. I use the import range function a lot, but sometimes I get an error message saying that the range is an internal error, and the connection is not working, is there a definitive solution? Please help me! Thank you
As a caution to others: they required me to put in my work email and my phone number then told me I couldn't try it out bc too many people from my organization had tried it out. I'm faculty at a university - duh. So my only option would be to buy it. No thanks.
VERY COOL but. 1. impossibile to register to the site for a private use = as a Private customer I'm not able to fill P.iva, simply because I don't have 2. 945,00EUR for a minimum of 5 user, again I need just one but it's impossible, in any case it costs much more then Office
Someone know how to replace a link? The current chart is pointing a Excel file named “results 2024_03.xls”, now I need to point to another file names “results 2024_04.xls”
Great video, Leila. Not sure how I have never come across think-cell previously. It looks like a good tool to have in my toolbox. However, it is definitely a premium priced add-in. It seems crazy that it can only link to an absolute range in Excel, rather than a (dynamic) table. Being able to do so would make its annual fee a little easier to justify, both to myself and to clients. Keep up the great work!
Amazing content and information, it will be very very helpful if you can please kindly upload videos related to how to create and represent various organisations data chart, technical reports in PowerPoint in the best possible and impressive ways
Why do they need a corporate email address for me to purchase a single license? I don't have one cause I'm self employed. Is there any other way? Please advise.
I've been using this tool for nearly three weeks and it is very unstable and causes PPT to crash. I've done all of the due diligence (clean Windows 10 build + all updates, fresh install of MS365, drivers, etc). The software is a great concept but not well executed in the Windows 10 environment.
Hi leila how ru? i have a problem with my Excel workbook. before using formula the workbook size was upto 17 mb but now i used COUNTIFS formula on my all tables, and now its size is 57mb. now it takes lot of time to open, and most of the time Excel is not responding. plz give me any solution to reduce the size of my workbook. Thanks...... this is my 4th comment to u but u still not reply to any of them....🤔😭
Hai How can I create a dropdown menu of dates.. So that each date correnponds to another cell( which is the same cell) where i need to type comments. Then when i select dates in dropdown i get the comment corresponding to the date selected Lets say i have dates dropdown in Cell B2 and comments in Cell C2 column. I need to be able to select a date in B2 CELL dropdown menu and then type comments in C2 cell so that it will be saved. and I need to do this for all dates in the dropdown. Would really help me if anyone know whether this can be done
Hello madam,, It is a request from my side .. I am not able to pay and watch your lectures on Excel (macros & VBA) .. Can you please upload the paid videos in RUclips it will be helpful for many students out here ..
We are sorry to hear of your issue. For any issue with think-cell, you can always be in contact with our support team who will be more than happy to be of assistance to you. Please follow: www.think-cell.com/support
As someone who used it on a daily basis for nearly 2 years, I can confirm Think Cell really is a life saver, it just saves so much time and effort, and it's really easy and intuitive to use.
I've been using Think cell for more than 4 years and as a Mgmt accountant...this really takes your work up a notch when it comes to PPT.
Using it for 4 years and cant live without it. Great tool with great tutorials.
Great to hear!
Someone so professional & sweet is teaching me great tips on Excel... She is from Austria ... I am from India. 😊 Big thanks to you my new mentor
So nice of you!
Leila! Great video. All your videos have had such a huge impact on my day to day work life.
And my god! The most beautiful woman on RUclips!!
Visualisation is really a trend in the it-world. It makes things so much more understandable and comprehensive. Algorithms and solving methods for the problems are often more then enough. 🖥 🏁 ⏳ 📎
This is going to be really helpful for me. I already use pre-prepared Thinkcell graphs but have never prepared my own. Thank you for this. Love the way you explain, very clear. Have used many of your tips in my new job.
Glad it was helpful, Susan!
I have been using thinkcell for years now and I just cannot imagine my life without it - this is actually the only downside, since their pricing model is not kind to individuals...
Hi Luis, hope you're well. I have just started working on Think cell, currently developing a dynamic deck to present analysis using VBA. Please suggest is there any demo available for help(like we have for Qlik) or any important guidance as per your experience.
@@AnilSharma-vw8mp Not that I know of. Sorry for not being able to help.
Hi Leila, Excellent presentation. All your videos are Excellent. Thank you for sharing.
I've created a project for myself in Excel. I've already imported my list of movies from a txt file, sorted it alphabetically and grouped by the franchise. So now I'm inputting more data: the year, the main actors, the rating, the director and the duration. And I might do this with a macro if it's possible: to link my workbook database with a movie site so I can pull in all that data. And I'm also utilizing the movie datatype feature.
Leila, as always, you are truly amazing. Your explanations are so clear. Thank you for taking the time to create these videos and help us in academic and professional life
You're so welcome!
We will use this video in my company, but not for chart creation; the video itself is an amazing example of a commercial pitch! Well done!
Many, many thanks for this video. Coming from someone that draws horrible stick figures, this add-in will be well worth the expense.
Mind blown away…. Leila and ThinkCell.
Amazing woman with amazing skills with a fantastic tool. Thank you for everything
Wow, thank you!
Here is the link for the extended free trial: www.think-cell.com/leila - Single licenses are also available with my link. Thanks for watching!
This channel is awesome, thanks for share your knowledge
Awesome tool! Loved the interface and results! And when Leila teaches you, it is all the more helpful! Thank you! 😊👍
Thanks Leila.
Think cell is amazing....I was using it in my previous company.
Great to hear!
Another super video from Leila. Thank you!
Totally awesome!
I wish I had 10% of these features in Qlik/PowerBI :(
Really starting to love Excel ....
As always, lovely way of teaching
Thank you! Cheers!
Think cell 📲 is very quick chart 📈. Thank you for sharing it.
Great technique, Leila! It's extremely helpful.
Glad you think so!
Used these add ins at Honda, really useful and neat way of presenting data.
Very intriguing ... and PRECISLY why Prof. Leila is a 'must-watch' date on my calendar every Thursday morning. Once again, Leila lays out a baker's box of tempting donuts and muffins that create a strong temptation to set aside current projects just to sample EACH one .... SOOOO terribly tempting. Maybe not today ... but some day for sure.
Thank you ... thank you ... thank you ...
PS
Mecho Chart??? ... have never heard the term before.
Thanks for watching! Yeah, it's not so common but it's a really cool chart.
We are already using Think Cell at work, although not so extensively. Thanks for sharing Leila, as always great video!
thanks for sharing Leila. this add-on looks really cool. the two questions that came to mind immediately, you answered right at the end of the video (does it work on mac? YES --- and what if I share with someone who doesn't run that add-on? NO WORRIES, IT'LL WORK ANYWAYS)
My pleasure, Birgit :)
Great 😃 you're my favourite Liela 🤗
Dear Leila, can we use it in Power Point without additional program from think-cell? Such as we make a gap for the latest year on the graph like your ahown us
Love you Leila, its excellent
Leila - fantastic video!
Madam is there any formula to add text for duplicate item like we use sumif formula for number....please help
very good presentation
Leila thanks for this very helpful - is there a link or video on how to build the waterfall you did on min 0.38 that shows 2 scenarios in one bridge - thanks!!!!
Check out this tutorial - at the end there is the complex version: ruclips.net/video/QIwRb3hTmc8/видео.html
@@LeilaGharani Thank you!!!!!!!!!!!!! You are the best !!!!!!!!!!!!
Appreciate the extended free trial. Any chance they can get a discounted license for your subscribers?? 😊
I normally use Pivot Table to create Pivot Chart = dynamic data, not static.
Can I still use think-cell?
This was fantastic and very helpful, thanks Leila!
You're so welcome, Chris!
Thank you teacher perfect as always 🤩🤩
Thanks Leila! What happens when I create a chart from an existing Excel model in PPT, and send only the PPT to someone else, will they be able to read the chart?
I pulled off some crazy Excel + PPT automated shit with a DWH in the back. Screw Tableau. It actually brought met to Data Warehousing. Now im the magic data dude
Whats i still miss is that growing lists arent supported
Great video! Thank you. Do you have some more think-cell videos especially creating GANTT Charts?
Not yet but you could check on the think-cell website directly. They have a lot of tutorials.
Hi! I had an unrelated question to this video but I hope you can help. I want to increase the size of the selection window of a drop down menu. Now if you open the drop down list you have to scroll to see al options. Is this possible and if so then how?
Thanks
Thanks for the walk through Leila. It indeed looks like a very handy tool especially if you are creating reports and presentations on a regular basis. But what if you only need it once to set up one template - can it be used again without the full subscription? At $25 per month it is rather expensive....
Dear Sagenose, thanks for your feedback. Unfortunately, think-cell cannot be used without a valid license. However, we believe that we create amazing value even for occasional users. Find out more about our features under www.think-cell.com/videos.
@@think-cellcustomercare5335 i shall take a closer look. Thanks.
hi great video, what entry level would be necessary to create the examples in the video.
Great. This video is also amazing as usual ❤.
Thank you so much 😀
My Company gave me this, and I just started learning it...😁
Happy learning!
Your work is excellent and much appreciated. With respect to think-cell, it can be fun to play with but they will not sell a single license so individuals can't license/use which is too bad.
Actually, if you use my link you'll be able to purchase single licenses too 😊
@@LeilaGharani, It did indeed after the second time. Thanks for the reply.
Thanks! How much is a single user? Website wants email first. Any idea?
Has anyone received the price offer from Think-cell? There is no information that individual purchase is available as per Leila post.
Great tool, thanks for the info. 🙂
There is just something about Ms. Gharani.👍
If you are interested in this then just note that it seems the smallest order you can make is for 5 licenses (I wanted to use it to make better charts in a book)
If you use my link you'll also be able to purchase a single license.
Normally when use dynamic charts, graphs, and tables from Excel to PPT they break. Does this solve that issue?
Hi Leila, can you please show how you would create the chart in (video time 0:32)?
and what is the license cost? I don t want to be using it or 60 days only to realize the license price down the line is pricey
Also the good part is that thinkcell works with VBA so you can automate your charts from Excel to PowerPoint
Also do you have any excel addin to conduct multivariate analysis and correlation matrix plot? i don t necessarily want to use python or R for very small data set but want to be able to populate very nice correlation matrix plot for multivariate analysis or multiple linear correlation analysis.
Leila, when pasting complex waterfall graphs from excel to powerpoint, my ppt file size expands to around 34mb. What prefered pasting option is best recommended to keep size smaller. I struggle to send the report out via email as its too big. Plz help!!! Its a massive headache in my life and im sure for alot of ppl
@Leila, this is only extended trial, the company does not offer individual licenses :(
Leila do you have any specific keystroke visualizer, or do you add keystrokes in video editing phase? I'm asking because your keystroke visualizers are amazing and I don't know how to edit videos so if there is any software that does it this well, I would be really happy to get it.
The tool she is propably using for recording the screen is Camtasia and there is an option to record keyboard actions and display them in a way she wants to. Here is explained how to use this feature: ruclips.net/video/gXKgi2kr-QA/видео.html&ab_channel=DemocastMedia
Hi, great tool!
How can I animate it in PPT?
For a pie chart, I can only get the pie chart to show the % but I want it to show the actual value that I can do in Excel. Please let me know.
What to do if I lose the think cell to review my number and calculation?
Does this work in Word?
Hello I am a man in Korea who uses Google Spreadsheets to analyze stock data. I use the import range function a lot, but sometimes I get an error message saying that the range is an internal error, and the connection is not working, is there a definitive solution? Please help me! Thank you
As a caution to others: they required me to put in my work email and my phone number then told me I couldn't try it out bc too many people from my organization had tried it out. I'm faculty at a university - duh. So my only option would be to buy it. No thanks.
VERY COOL but.
1. impossibile to register to the site for a private use = as a Private customer I'm not able to fill P.iva, simply because I don't have
2. 945,00EUR for a minimum of 5 user, again I need just one but it's impossible, in any case it costs much more then Office
If you use my link, you can sign up for a private license.
thanks for the sharing. Can we use thinkcell to link data table (not chart) from excel to ppt?
Yes, you can also link data tables.
I loved that music, what's the name of the song plz? @1:03 min
Someone know how to replace a link?
The current chart is pointing a Excel file named “results 2024_03.xls”, now I need to point to another file names “results 2024_04.xls”
Great video ... One input, the clock on 00:53 shows not 5 mins but 1 hour 😊
Haha, ours is a special one that measures minutes 😁
Good afternoon Ms. Leila, Please, Do you live in England? Are you from Iran.
Best regards / Kaisy - San Francisco
Great video, Leila.
Not sure how I have never come across think-cell previously. It looks like a good tool to have in my toolbox.
However, it is definitely a premium priced add-in.
It seems crazy that it can only link to an absolute range in Excel, rather than a (dynamic) table. Being able to do so would make its annual fee a little easier to justify, both to myself and to clients.
Keep up the great work!
I tried to using my personal email, Rejected can you advise?
Great 👍👍
Amazing content and information, it will be very very helpful if you can please kindly upload videos related to how to create and represent various organisations data chart, technical reports in PowerPoint in the best possible and impressive ways
Thank you for the suggestions!
Why do they need a corporate email address for me to purchase a single license? I don't have one cause I'm self employed. Is there any other way? Please advise.
Unfortunately, we cannot influence their sign up. It would be best to reach out to them directly at info@think-cell.com
I tried but to no success. I believe its a big misopportunity. Thanks anyway, i still love your videos. Keep it up.
Can you find negotiate for us single user licences? Currently they only sell a minimum of 5 licences.
If you use my link you can also purchase a single license.
@@LeilaGharani Great, thanks! Also, your work is amazing! Especially your course on Power Pivot & Dax, that is my #1 favorite.
Is this feature in Office 365?
I've been using this tool for nearly three weeks and it is very unstable and causes PPT to crash. I've done all of the due diligence (clean Windows 10 build + all updates, fresh install of MS365, drivers, etc). The software is a great concept but not well executed in the Windows 10 environment.
Fantastic
in my excel is not added automatically this add-in - I manage PowerPoint, but no think-cell in Excel
OK - I refresh the page and it iis working now - thanks a lot for this update Leila
For the algorithm. ✊
Very useful..
Hi leila how ru? i have a problem with my Excel workbook. before using formula the workbook size was upto 17 mb but now i used COUNTIFS formula on my all tables, and now its size is 57mb. now it takes lot of time to open, and most of the time Excel is not responding. plz give me any solution to reduce the size of my workbook. Thanks......
this is my 4th comment to u but u still not reply to any of them....🤔😭
Plzzz upload a yoga fitness video ik it's other content but this is also true that u doing yogas... I'm waiting...
Hai How can I create a dropdown menu of dates.. So that each date correnponds to another cell( which is the same cell) where i need to type comments. Then when i select dates in dropdown i get the comment corresponding to the date selected
Lets say i have dates dropdown in Cell B2 and comments in Cell C2 column.
I need to be able to select a date in B2 CELL dropdown menu and then type comments in C2 cell so that it will be saved. and I need to do this for all dates in the dropdown.
Would really help me if anyone know whether this can be done
Thinkcell vs Macabacus?
Buu😢 cannot create my chart (I have the think-cell) but the person give me a very long chart to create 😞
Way too expensive.
The paid subscription is around 24 USD per month. I cannot afford it as a personal user.
Hello madam,,
It is a request from my side .. I am not able to pay and watch your lectures on Excel (macros & VBA) ..
Can you please upload the paid videos in RUclips it will be helpful for many students out here ..
Was interested until I had a look at the pricing.
Yesss queen
Ha! This makes me wish my work meant I created a lot of charts. And presented them. And got a promotion. 😅😅
Wow, this is amazing! Unfortunately, my organisation thinks crayons and flip charts are cutting edge. 🤨
Oh, that's too bad. Well, maybe at some point.
For a second I thought Leila had just done a shampoo or a skin cream ad 😆
Think-cell caused problems with my Smartview plug-in...I removed it...
We are sorry to hear of your issue. For any issue with think-cell, you can always be in contact with our support team who will be more than happy to be of assistance to you. Please follow: www.think-cell.com/support
I am thirsty and look forward to next video
More to come :)