Menu
Excel Links – My First International Excel Workshop Edition
excel links - 11 comments
Stage is almost set for my first international Excel workshop. That is right. I am doing a physical excel workshop on Intermediate & Advanced Excel at Maldives between January 23 and 27, 2011. I feel quite excited to do this.
While I derive immense pleasure and learn lots of new things by running Excel School, there is one nagging problem. It is an online program, so the scope of physical interaction with students is limited.
Doing a physical class is a great way to meet new people, gather material for new content, get ideas, learn new things and get challenged. And that is why I am looking forward to do my workshop in Maldives next week.
If you would like to join this workshop: Please call Mr. Guru Raj, Training Manager at IIPD, Malè. His number is +960 7625338. (Workshop agenda)
Because I will be busy with the workshop next week, I will not be able to post much on the blog. I have requested Hui, our guest author to keep you all engaged. So expect some delicious stuff from him while I am away.
Let us start this week with some recommended Excel related links.
Excel is 25 years old – cool video
Microsoft made this code video showcasing how Excel’s 25 years has been. See it below or watch it on youtube.
[Related: Brief History of Microsoft Excel in a time-line chart]
Lets say you have a large workbook and want to jump to last cell with data. You can ofcourse press CTRL+End key to do that. But this approach may fail if you have a lot of blank cells at the end. You can of course find and remove blank cells using menu options. But if you want a macro based approach, read the linked tip. It can be quite handy.
Introduction to Custom Functions in Excel
George’s Excel Unsual blog is quite extrodinary. He regularly posts lots of advanced excel models & workbooks. In this short article, he shows how Excel custom functions (UDFs) work and how to write one.
Excel REPT Formula – 30 days 30 formulas
Debra has been doing an excellent series called “30 days 30 formulas“. She has already explained 15 formulas thru this series. In this article, she shows how to REPT formula. If you read any articles on incell charting, you will realize that understanding and using REPT formula is critical to develop good incell charts.
[Related: Learn 51 Excel Formulas]
Understand How Excel 2010 Slicers Work
Slicers is a cool new feature in Excel 2010 that makes data analysis by filtering quite a breeze. In this exhaustive post, Jan Karel explains how to slicers and how to customize them (including changing slicers’ font, which is not possible thru ribbon)
[Related: Dynamic Dashboard using Pivot Tables & Slicers]
Got a link to share?
If you would like to share a link with us, please drop me an email (chandoo.d @ gmail.com). If you are in to birds, you can tweet me. And if you on facebook, you can share links with our fans on our fan page.
Hello Awesome...
My name is Chandoo. Thanks for dropping by. My mission is to make you awesome in Excel & your work. I live in Wellington, New Zealand. When I am not F9ing my formulas, I cycle, cook or play lego with my kids. Know more about me.
I hope you enjoyed this article. Visit Excel for Beginner or Advanced Excel pages to learn more or join my online video class to master Excel.
Thank you and see you around.
Related articles:
|
Leave a Reply
| « Happy Birthday Hui, An Excel Dashboard to prove you are awesome! | Find the Average of Closest 2 Numbers out of 3 [formula challenge] » |
At Chandoo.org, I have one goal, "to make you awesome in Excel & Power BI". I started this website in 2007 and today it has 1,000+ articles and tutorials on data analysis, visualization, reporting and automation using Excel and Power BI. 
11 Responses to “Excel Links – My First International Excel Workshop Edition”
when are you going to come to Buenos Aires !!!!????!!!
@Martin: Oh, how much I would love to. I almost traveled to Buenos Aires once while I was working. But I was sent to Hong Kong instead. Do you think there are enough ears in Argentina to sponsor an excel blogger cross half the globe for a few night stay?
keyword: sponsor.
maybe if you could get one, to make the visit worth (and by that I mean that your seminar costs little for the atendees, as you know the rate exchange is 4 to 1 to USD...)
or perhaps summoning Debra, Ron, Dick, Daniel, Hui, Charley, Jon....... in a single place, such as BA, sponsored by MS and/or some other big company, to set up a dasboard seminar for Financials (and not), Accountants (and not), could worth a somehow expensive fee....
I would imagine that unless the Excel course was held 50m off-shore in the Maldives, I'd struggle to make to to any classes.
Great!!
Good to see your first physical step in international market.
I'm pleased to say that I was the first to comment here on the excelunusual.com blog of my friend George Lungu, after I encourage him to publish his great ideas.
http://chandoo.org/wp/2010/08/13/unusual-excel-uses/#comment-128867
@Chandoo, maybe your opinion about George’s Excel "Unsual" blog is quite "extrodinary".
Did you mean that: George’s Excel Unusual blog is quite extraordinary.
Hello,
Can someone please print some of the course details here? $'s, duration etc.
Unable to dial international at present due to some local flooding here in Austrralia affecting the phone networks.
Many Thanks
CF
Chandoo You have got to give us more notice next time for another Maldives course. It's just a fantastic idea and would be a fantastic experience to do. Can I suggest Goa for another great location idea albiet not international for you.
John
@all: The course is aimed at people living and working in Maldives. That is why I did not mention it on the blog. It is not my intention to spoil the holiday of tourists by wrapping them with SUMPRODUCT.
@Martin: Wow, that would be good. But air lifting all of us to Argentina & hosting us would be quite expensive even for MS.
@Pedro: You are right. Thanks for excelunsual reference. And yes, It is a spelling mistake. I will be fixing it. Thanks for point it out. Donut for you.
@Christian: Duration is 3 days. Price is I guess $75. But you can call Guru on Skype or drop him an email at gururaj_111@hotmail.com
@John: Sure, Goa is a nice place too. It is my new year resolution to do a few workshops this year. I will try to have one in India too.
Congrats Chandoo... This is truly impressive!
May god shower upon all his blessings on you Mr Chandoo on your new venture. It gives me immense pleasure in wishing you. Kindly share your experience once you are free.
With regards
V S Venkatraman