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.
Microsoft made this code video showcasing how Excel’s 25 years has been. See it below or watch it on youtube.
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.
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.
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]
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)
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.
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]|