Thank you, I am flying to Australia today!
Two years ago, If someone told me I would be flying to Australia & get handsomely paid to do it, I would have rubbished the thought. You see, exactly two years ago, I quit my job to work on Chandoo.org for full time.
My main focuses then were,
1) to make sure my family would not starve or be deprived.
2) to make you awesome in Excel
Today, #1 does not keep me up in the night. Thanks to you. You have supported Chandoo.org, purchased our products, spread good word about our site. This removed all my doubts & financial worries. Now, most of my work day is focused on making you awesome in Excel.
Adding Macros & Final Touches to Customer Service Dashboard [Part 4 of 4]
Welcome back. In final part of Making a Customer Service Dashboard using Excel let us learn how to add macros & VBA code that makes our dashboard interactive.
As you can see, there are 2 important macros in this dashboard.
An IF Formula Challenge for you
If I were to hire an data analyst, I would simply ask them to write a complex IF formula in Excel. If they can write it, the interview progresses, else, they are out. In other words,
=IF(person_can_write_big_fat_IF_formula=TRUE, proceed_with_interview, say_thanks_and_call_next_person)
If you are able to write IF formulas for any situation, then you are bound to be awesome in Excel.
So, to test how well you know your IFs & Boolean functions, let me give you a small challenge.
Lets meet when I am in Australia
When I announced my upcoming Australian Excel masterclass, I got quite a few mails (ok, just a few), all which are on these lines,
Wow, I would love to meet you when you are here. Let me know if you have sometime on an evening for some coffee or beer?
Down under, I must be popular.
After saying yes to a few invitations, I saw the hassle in arranging several individual rendezvous. So here is an open invitation to you all. If you like Chandoo.org or Australian brewed coffee, clear your calender on below dates,
- Sydney – 30th April
- Brisbane – 2nd June
I am yet to decide the venue & time. But preferably, we will meet near water around 5ish in the evening. If you want to join me & share your Excel stories (or just any stories), fill up below form.
Send mails using Excel VBA and Outlook
Ever wondered how we can use Excel to send emails thru Outlook? In this article we well learn how to use VBA and Microsoft Outlook to send emails with your reports as attachment.
Scenario: We have an excel based reporting template. We want to update this template using VBA code to create a static version and email it to a list of people. We will define the recipient list in a separate sheet.
Read on…
Formula Forensic No 019. Converting uneven Text Strings to Time
I have imported some data that comes in as a number that I need to convert to h:mm. The data string will be either 1,3,4,5,6 integers long and looks like this…
Help
Creating Customer Service Dashboard in Excel [Part 3 of 4]
Welcome back. In third installment of our Customer Service Dashboard series, we will learn how to construct the charts in our dashboard. We will understand the sparklines, traffic lights & dynamic chart setup. To help you learn better, I have recorded a short video too. Go ahead and enjoy.