All articles in 'Learn Excel' Category
A lot of analysts swear strong allegiance to keyboard shortcuts. But when it comes to formatting a spreadsheet, these shortcuts go for a toss as formatting is a mouse-heavy activity.
But we can use a few simple & effective shortcuts to zip through various day to day formatting tasks. Let me share my favorite formatting shortcuts.Continue »
Yay, bring out the birthday hats, candles, cake & confetti. Chandoo.org podcast is 1 year old.
In this one year, we had 31 sessions, 4 guest appearances, 390,000 downloads & lots of 5 star reviews. Thank you so much for making it a grand success so far.
To celebrate the occasion, I want to reward 3 lucky listeners of our podcast.
How to participate in this contest?
- Simple. Figure out what your favorite Excel tip is.
- Open your smart phone’s voice recorder app
- on iPhone use the Voice Memos app
- on Andriod use sVoice or voice recorder widgets
- If you cant find these apps, just Google record audio <your phone name>
- Record the tip (less than 3 mins duration)
- Please say your name at the end of recording.
- Send the audio file by email to email@example.com
- Do so before end of day 16 March 2015 (Monday)
Once I collect all the tips, I will feature some of them in next episode of Chandoo.org podcast.Continue »
Hi friends & readers of Chandoo.org
I am very happy to invite you to our newest online class, 50 ways to analyze your data. This program is aimed to make you an awesome analyst, training you on vital skills like data analysis, visualization of outputs, modeling business problems and finding best solutions.
Please click here to know more about this program & enroll.
What is this course?
It is the age of big data. Alas, we need big insights. But finding even small insights buried in our data is a hard task. To find the stories hidden in your data, you need to follow a process like this:
- Collect & clean data
- Structure the data
- Model business problems
- Analyze the data (or solve the problem)
- Visualize results
- Find conclusions
- Add layers of complexity to the problem
- Build what-if scenarios
- Reach conclusions
- Take action
This is where the 50 ways to analyze your data course. In this program, we analyze 50 familiar, important and diverse business situations using several of the above steps.
My goal is to make you say “YES” every-time your boss asks “Can you analyze this data and tell me what is going on?”Continue »
Just a quick announcement.
As you may know, I will be speaking at PASS Business Analytics conference in Santa Clara this April (between 20th & 22nd). As a run up to the event, the good folks at PASS are conducting free webinars on various topics of Excel.
Here are 2 topics on which I am doing webinars. You can watch them and pick up some really cool Excel skills. Just click on below links to enjoy them.
- 5 Dashboard mistakes to avoid (watch it any time)
- Excel charting – productivity tips (live on February 3rd)
That is all for now. See you in the webinar.Continue »
If you are an Excel enthusiast, here is a feast for you.
Just a small glitch, it is a not feast you enjoy with mouth, it is a feast you consume with eyes, ears & mind.
It gives me immense pleasure to invite you to this feast.Continue »
A little late to the party, but nevertheless right on track.
As Chandoo.org starts another year of making you awesome, I want to take a few minutes of your time to understand how I can help you better this year?
Please answer this 1 question survey for me.
If you do not see the form below, please click here
This is a guest post by Sohail Anwar.
Why do so many of us use Excel? Let’s trace it back to the ’80s when Microsoft hit gold by being the first out of the blocks with the widely available operating system that was somewhat dummy proof.
Suddenly everyone could aspire to launch ‘Nukes’ like a fresh faced Matthew Broderick in the film ‘War Games’.
By the early 90’s Windows had become even more established relative to other Operating Systems, so much so that PC manufacturers were developing components around Windows’ capabilities and suddenly PCs were Windows machines. As big business began accepting the significance of computing, Microsoft started winning huge licensing contracts with all the major corporations in all sectors, but the Finance sector in particular, where Excel would be king, was having an exponential boom at this time. For big organisations, once you spent a fortune buying licences for the Operating System it only made sense to purchase the seamlessly integrated and carefully developed/tested apps to run on them; enter Excel, Word, PowerPoint and eventually Outlook. Fast forward to 2015 and we are firmly in the age of second generation corporate professionals who have developed much of their productivity skill sets around those particular Windows tools. While all the excellent tools have their place, Excel stands out and here are 8 reasons why you need to up your Excel game more than ever this year.Continue »
Here is a New year gift to all our readers – free 2015 Excel Calendar & daily planner Template.
This calender has,
- One page full calendar with notes, in 4 different color schemes
- Daily event planner & tracker
- 1 Mini calendar
- Monthly calendar (prints to 12 pages)
- Works for any year, just change year in Full tab.
2014 has been the busiest year since starting Chandoo.org. Wow, that is 11 years of breaking previous records. Thank you. In 2014, we published 128 posts (up 27% YoY), received 6,000+ comments (down 19%). Our forum had 8,700+ new members, 6,650 new threads and more than 42,000 posts in 2014. This year, I have also launched Chandoo.org podcast. […]Continue »
This is a guest post by Sohail Anwar.
August 29, 1994. A day that changed my life forever. Football World Cup? Russia and China de-targeting nuclear weapons against each other? Anniversary of the Woodstock festival?
No, much bigger: Two Undertakers show up at WWE Summerslam for an epic battle. Needless to say: MIND() = BLOWN().
And thus begun one boy’s journey into understanding the phenomenon of Multiple Occurrences.
My journey continued, when just a few years later my grandfather handed me down a precious family heirloom: A few columns of meaningless data that I could take away and analyze in Excel. You may laugh but in the 90’s, every boy only wanted two things 1) Lists of pointless data and …Continue »
Hello folks, how are you?
I have an announcement for you.
It is almost holiday time. Every year, Chandoo.org celebrates holidays with a 3 day sale on our most popular product – Excel School training program. The sale for this year will be,
10th December to 12th December (Wednesday to Friday)
What is on sale?
You will be able to save $30, $50 or $100 on our most popular courses
- Excel School + Dashboards program ($30 discount)
- Excel School + VBA + Dashboards ($50 discount)
- Excel School + VBA + Power Pivot + Dashboards ($100 discount)
More details & links for Sale page will be available on 10th of December. Stay tuned.
It has been a while since we had a round of Excel links. Here are some cool tips & links for you.Continue »
Recently my iPhone 4 crashed. It is 3.5 years old. And just like any other 3 year old, it started acting weird & crazy one night. The next morning it went silent. It won’t go beyond the Apple logo whenever I start it. Since I couldn’t wait for the phone to start, I took out the SIM card (the phone is unlocked, if you are wondering) and placed it in my old Nokia phone. But alas, none of my contacts are on the SIM. They are in “cloud”.
After a day of answering phone calls from everyone including my mom as “Chandoo here”, I’ve decided to get my contacts back. So I logged in to iCloud to download a backup. And the backup was a .VCF file.
Since I wanted to have all my contact numbers in a spreadsheet, I did what any Excel nerd would do. I built a template that can convert VCF data to Excel worksheet.Continue »
Excel 2013, the newest version of Excel as of writing this has many great features like data modeling, improved pivot tables, power view, flash fill etc. But one thing that I find very annoying is the Open & Save experience. Any time we open a file or save a workbook (which happens alot everyday), we must navigate the painful backstage screen to select our favorite folders. You see, Excel 2013 supports cloud saving. So that means, by default it will show your Office 365 or OneDrive or SkyDrive or whatever fancy new name Microsoft has for these things. But I am not so much in to clouding. Heck, I see a passing cloud in the sky and I almost run inside my house. So what to do?
Simple. We can turn off these features.Continue »
Recently, we discussed about the case of unwieldy data and how we lookup what we want using formulas like SUMIFS. Today, let us learn few more ways to solve the same problem.
Suitable structure spawns simple solutions
Poorly structured is the 2nd biggest problem of analysts. The first one is not enough coffee. That is why there is a dictum in the data analytics world.
Structure is everything
So, we can easily solve our lookup problem, if our data were to magically re-arranged in 2 column fashion – Data & Value.Continue »
Its almost ready. Our ready to use Excel dashboard templates are coming to a spreadsheet near you on November 13th.
Here is a teaser preview of the dashboards. Our own official trailer, rated A for awesome.
Watch it below:
Excel Dashboard Templates – What are they?
As the name suggests, these a set of workbooks where you can key in your data, set up how you want the looks & bam, a beautiful, insightful, fun, easy to use dashboard pops right out. All in few minutes.
Here is how these templates can help you:
- Design awesome dashboards in minutes, not months: Don’t waste hours trying to figure out formulas, chart settings and layouts. Instead focus on what your users want, how your business works and use those insights to tell the ‘Excel Dashboard Template’ what you want. Save time and look awesome.
- Accommodate change elegantly: People change. Businesses change. What your boss wanted last month is no longer what she wants today. So when someone asks you, “hmm, can you show me YTD data instead of last 13 months”, or “Can I see top 10 KPIs instead of all”, you just smile and tap a few clicks and bingo, the new dashboard will be ready. These templates are designed to handle change (data, requirements, design preferences and insights).
- Customize everything: Unlike a template set in stone, these are designed to let you customize almost every little aspect of the output, calculations and behavior.
- Beautiful & Informative: These templates are designed with a delicate balance of beauty & insight. Everything is seamlessly designed, perfectly aligned and precisely calculated so that you & your boss can focus on the insights & decisions. Time tested and well honored visualization principles & guidelines are observed thru-out the reports.
- Built for starters, built for pros: Whether you are just starting with Excel or a seasoned pro, you can find the templates right up your alley. For advanced users, we have many customizations to whet your appetite. Want to build a custom calculation or include another type of sorting, you can do it by tinkering with ‘calculations’ sheet.