Sales Analysis Charts in Excel – 78 Alternatives
Recently, I ran a contest asking you to analyze a bunch of sales data and present your results in charts. We received a total of 78 charts from 45 people. The contest entries had a mind-boggling variety of excel charts, techniques and ideas. It took me a while to go thru all the files and compile the results. Thanks for your patience. In this post, you can find all the charts along with my comments & links to download files.
Excel Links – Updates on Singapore Workshop Edition
It has been a while since we had an Excel Links post. So here we are.
First, I want to update you about our Singapore Workshop.
As you know, we have opened the registrations for this workshop last week. If you are in Singapore and want to attend an Excel & Financial Modeling Workshop, Please consider joining us on July 8- 10. For details & enrollment, visit Singapore Bootcamp page.
Apart from the Singapore workshop, I was busy last week conducting live training at CapGemini, in their Hyderabad office on Excel & Dashboards. It was a very good experience. I learned a lot about practical challenges people face when doing sales reports etc. using Excel.
Form Controls – Adding Interactivity to Your Worksheets
Excel can be a bland collection of cells with text and numbers or it can be a playground where you can have interactive engagement with your models.
The choice is yours!
Excel provides a small number of tools to allow you to interact with your models.
These tools are called Form Controls and can be added into and linked to your models data.
This post will look at the various types of Form Controls and discuss their application and use.
Dynamically Grouping Related Events [Excel Combo Charts with Pizzazz]
Yesterday we have posted how to use excel combo charts to group related time events. Today we will learn how to change the event grouping dynamically using form controls.
This effect can be easily achieved with a cup of coffee, one combo box form control and the good old IF formula. Read more to learn how to do this.