Hello folks,
We pause the regular broadcast of Excel awesomeness to share something exciting. As you may know, I will be running a series of Advanced Excel Dashboard Masterclasses in Australia this May & June. So if you live in (or nearby) Sydney, Melbourne, Canberra, Perth or Brisbane and want to one up your dashboard skills, you know what to do next.
I am conducting these masterclasses in partnership with Plum Solutions.
What is in this Masterclass & Who should attend?
This 2 day masterclass is aimed at managers, analysts, reporting professionals, executives in sales, marketing, customer service or anyone who wants to learn about Excel Dashboards.
In this masterclass we will be learning,
- Day1: Our first dashboard in Excel
- Excel formulas for dashboards
- Applying advanced conditional formatting for dashboards
- Building our first dashboard – hands-on exercise
- Day 2: Advanced dashboard skills
- Selecting right charts for any situation
- Enhancing dashboards with Excel 2010 – sparklines, slicers
- Customizing Excel charts – top 5 problems
- Building our second dashboard – hands-on exercise
- Q&A
For complete details about the masterclass, please download our brochure.
Benefits of this Masterclass – what you will get?
These are the benefits of the of our Masterclass:
- Learn the process to create robust, easy-to-maintain Excel Dashboards
- Build better & error-free Excel reports
- Know how to choose right charts based on your need
- Understand design principles that make your work stand out
- Discover some of the less commonly-known Excel features
And you will get this by enrolling:
- Two full days of tuition by me
- Use of workstations, lunch and refreshments
- USB stick with Example workbooks, PDF guides & videos
- Access to selected videos & material on Chandoo.org
- Email support for Excel questions for 3 months following the course by Chandoo.org
When is it?
The venues and dates of the masterclass are,
- Thu 03 May 2012, Sydney
- Thu 10 May 2012, Canberra
- Mon 21 May 2012, Perth
- Thu 31 May 2012, Brisbane
- Thu 07 June 2012, Melbourne
Sign-up before April 15th to get $100 discount
This masterclass is AUD 950 + GST per participant.
If you sign-up before April 15th, you get $100 discount. Please use the discount code CHANDOO during checkout to claim it.
Click here to sign-up for our Advanced Excel & Dashboards Masterclass.
Do you want me to conduct training in your company?
I will be Australia between April 23rd and June 10th. I would love to visit your team and spend a day or two discussing Excel. So if you want to have an in-house training session by me, just drop an email to chandoo.d @ gmail.com.
Any questions: Comment on this page or email me.
Thank you
I got my visa few days. I have booked my tickets too. I am very eager to visit Sydney, Perth and all other beautiful places down under. I am even more eager to meet some of you and share my knowledge. Thank you so much for making this happen.
PS: If you are live in any of those 5 cities and want to have some coffee / beer, let me know. I would love to meet you.
PPS: If you live in any of those 5 cities and want to become awesome in Excel, go ahead and sign-up. You know it is going to rock.
11 Responses
Ciao Hui,
Collecting Excel tricks under the title “Notable Excel Websites (Non-MVP) Edition” is a brilliant idea…
Thank you in the name of all The FrankensTeam.
On our site there is a box with a picture and text highlighting:
This is a no-MVP site
we think ourselves “bad boys” a bit 🙂
For those who would like to know why our site is a no-MVP site, enough to click on the link:
http://goo.gl/lxDszY
Thank you again!
Thanks a lot
I really enjoyed this (newsletter). I must admit that I rarely read an Excel newsletter (and I subscribe to quite a few) all the way though, but this grabbed my attention and before I realized it, I was engrossed in it. I must also admit that most of this I don’t understand, yet. But, it excites me when I do learn something new in Excel. I can’t wait to see how much of this I can implement into my (constantly-evolving) ‘House Budget’ & ‘Family Medical’ worksheets that I have developed over the past few years! I sure hope to see more of these type of newsletters in the future! Thanks!
Thanks for doing this Hui! I appreciate being included.
I like Tom’s tip a lot. I posted about a tool I wrote to automate this at http://yoursumbuddy.com/tables-edit-query-dialog/
EXCELLENT !
Hui, This post is Superb! More over I have always been a fan of Roberto’s work and have learnt a lot from him.
Here are some of my recent contributions
1. Customising markers in a chart – http://www.goodly.co.in/customize-markers-in-a-chart/
2. Charting Hacks to work faster – http://www.goodly.co.in/5-charting-hacks-to-help-you-work-faster/
3. 7 Date formulas to make life easy – http://www.goodly.co.in/date-formulas-in-excel/
4. Customised scrollbar using VBA – http://www.goodly.co.in/customized-scroll-bar-in-excel/
5. Adding Direct Legends – http://www.goodly.co.in/customized-scroll-bar-in-excel/
Hope everyone enjoys!
I like the Excel Ninja Menus.
1. Select a cell or range then move till the 4-way cross appears. Right-Click and drag the selection to another place in the worksheet then, like a ninja, a menu full of skills and throwing stars pops up allowing me to do all kinds of awesomeness.
2. When you click the fill box on a Date and right click and drag it down, a lot of amazing Date options pop up.
I also brand my Excel to remind myself that I’m awesome. In my personal macro workbook I place the following code.
Private Sub Workbook_Open()
Application.Caption = “SuperKrishna’s Awesomeness”
End Sub
My favorite tip goes along with #17. If you try to copy subtotaled data (and in earlier Excel versions filtered data),when you paste it all the data displays instead of just the summarized data.
To get around this, select your summarized data, click on Find and Select tab and then select Go to Special. Click Visible cells Only and click OK. Now paste and you will see that only the summarized data has been copied.
You can also go CTRL+G and then click the Special icon at the bottom of the dialog box.
What a great idea, Chandoo! I’d love to be included in your next edition:) Perhaps a VBA exclusive version?
@Ryan
I will review this concept about 6 months out from the original post and be sure to keep your site in mind
Hui…
That sounds great, Hui:) I just realized I gave credit to Chandoo for the idea and I should have attributed it to you.
Sorry about that!