A Straits Times chart in Microsoft Excel
I came across a stock market chart in Straits Times a couple of days ago. Just for the fun of it, I created one in Excel within 5 minutes.
Microsoft Excel Training Course for Human Resource
Being Excel savvy is an invaluable if not necessary skill to be a successful HR professional.
Develop Robust Excel Spreadsheets with Checks & Controls
The use of spreadsheets has crept into daily business operations at the highest levels. There is a clear and present need to develop error free spreadsheets
Control your Excel spreadsheets!
Control your Excel spreadsheets!
Consider these shocking stories on how a simple Excel error can cause you sleepless nights
Painless Business Reporting in Microsoft Excel
I have noted that generating business reports in Excel has many common problems across companies though my years of teaching Excel and working as a business analyst in a large corporation.
Problem of Labour Intensive Reporting in Excel
If you are a business analyst like I was, chances are you create and compile tons of reports in Excel. The business of generating reports is a business itself.
Create Executive Dashboards in Excel
Most analysts know how to create charts in Excel. Getting them to look good is another matter. It’s hard to imagine you can create magazine quality dashboards like these without dedicated software.
Work with multiple Excel worksheets at the same time
Imagine when you open a workbook, multiple windows will be opened and each window allows you to work on 1 worksheet and they get arranged nicely across a large LCD monitor. Sounds like a dream? Well this is easy to do.
Dashboard ideas from Wall Street Journal
The Wall Street Journal has a lot of good looking charts which I draw my dashboard ideas. You can hardly find any in BusinessWeek or Fortune nowadays. The chart from WSJ below shows a complex story of European bank revenues from equity capital markets deals(ECM).
Bullet chart in Excel
A bullet chart is a relatively new kind of chart invented by Stephen Few. I was pleasantly surprised to see one in a recent copy of The Wall Street Journal.
