# Excel Links – My First International Excel Workshop Edition

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.

Jumping to Last Real Cell

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)

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.

 Happy Birthday Hui, An Excel Dashboard to prove you are awesome! Find the Average of Closest 2 Numbers out of 3 [formula challenge]
 Written by Chandoo Tags: excel links, excel workshop, history, in-cell charting, Learn Excel, macros, Microsoft Excel Formulas, rept, slicers, spreadsheets, udf, videos Home: Chandoo.org Main Page ? Doubt: Ask an Excel Question

### 11 Responses to “Excel Links – My First International Excel Workshop Edition”

1. Martin says:

when are you going to come to Buenos Aires !!!!????!!!

• Chandoo says:

@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?

2. Martin says:

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....

3. Hui... says:

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.

4. saurabh says:

Great!!

Good to see your first physical step in international market.

5. Pedro Wave says:

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.

6. Christian says:

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

7. John says:

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

8. Chandoo says:

@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.

9. Sumit Dhar says:

Congrats Chandoo... This is truly impressive!

10. V S VENKATRAMAN says:

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

 Happy Birthday Hui, An Excel Dashboard to prove you are awesome! Find the Average of Closest 2 Numbers out of 3 [formula challenge]