All articles in 'Learn Excel' Category
Last week I introduced the technique of using custom Number Formats for Chart Axis labels.
Today I present a few more alternative layouts including Chart Series Data Label Formats.Continue »
A few weeks back, John asked a post question, “ How can I add a £ to the 80 on a Chart axis and leave the rest of the numbers plain numbers ? ”
Custom Number Formats, That’s How.Continue »
Who is this course for?
If you use MS Excel to do data analysis, reporting, day to day tracking or project management then this is the right course for you. If you struggle with formulas or not sure which formula to use for any given occasion, then this is the perfect course for you. We will be introducing more than 40 different formulas with 100s of examples in this course. As we will be using realistic data & examples, you can very quickly apply the same to your day to day work and do so much more with ease & confidence.Continue »
It is megaphone time at Chandoo.org. I have a few quick announcements about upcoming training programs & other interesting stuff. Just read on
1. VBA Classes – 2nd batch details.
2. Good news for our Indian customers
3. New Excel Formula Crash Course – from tomorrow (17 August)
4. Excel School prices going up!
5. Recommended Live Training – Mike’s Power Analyst Bootcamp in US
The other day, while I was putting my kids to sleep, this idea came to me. How do I check if a cell contains a palindrome, using Excel formulas?
Next morning, I wrestled with excel for about 20 minutes and boom, the formula is ready.
But what is a palindrome?
A palindrome is a word, phrase, verse, or sentence that reads the same backward or forward. For example: A man, a plan, a canal, Panama!
So, to check if a cell contains palindrome, we need to reverse the cell contents and see if both original and reverse are the same.
Everyone and their colleague knows the importance of Excel keyboard shortcuts. While it may be a good idea to know a 97 different shortcuts for everything in Excel, the fact is, you don’t use them all the time. So, it all boils down to memorizing the few shortcuts that you use all the time.
In this post, I am sharing 10 such shortcuts that I can’t live without, especially, when I am analyzing data, making charts and formatting my workbooks.Continue »
Today I want to share an Employee Shift Calendar Template with you. You can use this template to keep track of shift timings on various days. See a demo of the template: How does this template work? This template uses a 3 main ideas, Excel formulas to create the calendar & checking for a day’s […]Continue »
Last week we learned how to create dynamic hyperlinks in Excel. Today, I want to show you something even cooler. An interactive dashboard based on hyperlinks, like shown above.
Isn’t it impressive?
Well, to create something like this, you don’t need a degree in advanced cryogenics. You just need a bunch of data, a chart, a one line macro code and some pixie dust (go easy on pixie dust).Continue »
During one my recent training programs, a participant asked an interesting question.
I have a list of values. I would like to place a hyperlink in my workbook that would always take me to the last value in the list.
Something like shown aside.
Click on the image to learn how this is done.Continue »
Today, let us learn how to use NPV() function in Excel & create a simple financial model.
If you are dealing with cash and valuations, you are bound to have come across the NPV function. If you don’t know the assumptions behind the same, I bet it could cost you your job!
Let’s take a simple project – You buy a MSFT stock for USD 100. You receive a dividend of USD 10 in the first year, USD 20 in the second year, USD 40 in the third year and then you sell it out for USD 140. If you could have alternatively put this money in bank at 10% interest rate, have you gained anything?
How do you model this in excel? In this tutorial we understand how you can use NPV to do this analysis and what kind of pitfalls you can land into!!Continue »
A quick announcement folks. I am doing an Excel Boot-camp in Singapore this weekend (July 8-10) along with Paramdeep from Pristine. If you are interested in joining our Bootcamp, this is your last chance. Visit our Singapore Excel Boot-camp page for details & sign-up information. The last date for enrollment is Thursday, 7th of July. […]Continue »
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.Continue »
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.Continue »
Over at Newton Excel Bach I spotted the Dynamically Defined Dancing Pendulums. Doug had used Strand7 for the animation.
I thought I could do that in Excel and did.
This post demonstrates some of some basic VBA techniques used to simplify repetitive tasks used during the construction of the project.
For a full project description visit Excel Hero.com.
Can I automate 500 Columns of Data Analysis without VBA?
Excel super function – Data Table to the rescue.
After reading this post, you will be able to process data like a Data Analysis Super Hero !Continue »