Charts, Dashboards and More – Best of Excel on the Web (May 2012)
Last updated on May 15, 2012 By Victor Chan
In this article I’m going to do a quick round-up of the Best of Excel on the Web.
This last month has been pretty intense as I’ve been working on the launch of “Excel Power Tips”. The Ebook and Videos should come out next month (fingers crossed). In the mean time check out the teaser video and sign up for a 50% early-bird discount before it’s too late by heading over to the Power Tips page.
Just because I’ve been busy doesn’t mean there hasn’t been great Excel content published elsewhere on the web.
So here are some of my favorite posts, articles and videos that I found in the last couple of weeks.
Charts & Dashboards in Excel
These articles cover techniques and principles for creating charts and dashboards in Excel, with some useful ones that you may not have thought of yourself.
How to fine-tune the position of a chart from inside the VBA editor
How to show chart data when your data is hidden
Create a cool interactive Sales Chart
Create a Customer Service Dashboard in Excel
Conditional Formatting of Charts by Value and Label using VBA
Examples of Chart Junk from the Wall Street Journal
More Excel goodies from around the web
Here’s a collection of tips and resources on formatting, pivot tables, userforms, VBA and migrating to Office 2010.
Find and replace specific colors (and when this does not work)
Excel Pivot Table Selection Quick Tip
Display text values in Pivot Tables without VBA
Disable autofit column widths for all Pivot Tables in a sheet (VBA)
Add New ComboBox Items in Excel UserForm
Move data from one sheet to multiple sheets using VBA
Upgrading to Office 2010? Download free Office 2010 migration guides
Finally here’s a link you should check out for fun!
Don’t lose the chance to secure your 50% discount on “Power Tips”
As I mentioned in the introduction, I’ve been working on the launch of “Excel Power Tips”. If you’d like to boost your productivity in Excel by learning tips & tricks, you should secure your 50% discount off the Ebook and Videos by joining the Launch Excel Early Bird List here.
Related Posts:
Hey, I'm Victor Chan
Are you struggling with complex Excel tasks? Feeling overwhelmed by spreadsheets that are hard to use?
Many people believe mastering Excel is about learning shortcuts, functions, and formulas. But this overlooks the importance of building practical, real-world applications. It's not just about knowing the tools. It's about using them effectively.
That's where I come in. You'll get a unique perspective to Excel training from me. I have over 20 years of experience at Deloitte and two global tech companies. And I know what can make a difference in your career.
Let me help you integrate Excel into your professional life. Starting today. Read one of my articles, watch one of my videos. Then apply the new technique to your work. You'll see the difference immediately!
Recommended Posts
Discover the PROVEN Blueprint for transforming your Excel skills, supercharging your productivity, and standing out in your career! My course helps you to learn Excel VBA and save hours of time even if you have zero prior experience with programming.
Solve tricky Excel problems and take your work to the next level! Get customized solutions for your unique needs. Save time and gain insights with truly expert Excel solutions from only $97 per task.
Get a clear overview of your project progress using the Excel project timeline. Use it to communicate the big picture, track task progress, and stay on top of your project goals. Stay organized with our project timeline!
Our cheat sheets provide quick and easy reference to commonly used Excel VBA concepts and code snippets.
Unlock new levels of productivity and efficiency with our cheat sheets, and write VBA code like a pro in no time.
RECOMMENDED READING
Are you looking to upskill and stay ahead of the curve? Excel is a powerful tool that keeps growing in demand. We round up the best online courses for learning Excel.
Are you looking to up your spreadsheet game? Excel is an invaluable tool that can help you stay organized and save time. From data analysis to budgets, Excel can do it all!
Today, having Excel skills is more critical than ever. Those who know how to use Excel are more likely to find higher-paying jobs. And get promoted faster.