fbpx
Search
Close this search box.

All articles with 'Learn Excel' Tag

Formula Forensics No. 003 – Lukes Reward

Published on Nov 18, 2011 in Formula Forensics, Learn Excel, Luke, Posts by Luke
Formula Forensics No. 003 – Lukes Reward

Today we publish what is hopefully the First of many posts by guest author Luke M. it is also the Third post in the Formula Forensics series, which has now moved to a regular and new Thursday slot ?

Luke has taken up Hui’s and 3G’s challenge of explaining how the technique he regularly uses on the Chandoo.org Forums for extracting individual records out of a group.

Today Luke tells us how to extract a list of items from a larger list according to some criteria.

Continue »

Making Small Multiples in Excel [Charting Technique]

Published on Nov 16, 2011 in Charts and Graphs
Making Small Multiples in Excel [Charting Technique]

Today, lets learn how to create small-multiples (or panel charts) to visualize trend of 2 product lines over years in various regions. The inspiration for this chart and article came from my friend, Paresh‘s recent article on his blog.

See how you can create a combination of area & line chart to create the small-multiple chart and clone it. You can also download the workbook and play with it to understand this technique better.

Continue »

Excel for Project Managers program is open, Please join today

Published on Nov 14, 2011 in products, Project Management

Excel for Project Managers - Online Training Program from  Chandoo.org & Pristine

My dear friends & readers of Chandoo.org,

We are so happy to announce Excel for Project Managers program for your consideration. Please read this short page to understand the benefits of this course & to sign-up. Or visit our sales page for details.

Who is this course for?

Well, I am sure you know the answer. This course is aimed at Project Managers, Business Analysts, Project Leads and people aiming for various project management roles. This course also helps project sponsors, people working in reporting & financial analysis of projects.

To enjoy this course, you should be familiar with various aspects of Excel (preferably Excel 2007 or 2010). This course is not aimed at absolute newbies of Excel.

Continue »

Calculate Payment Schedule [Homework]

Published on Nov 11, 2011 in Excel Challenges, Learn Excel
Calculate Payment Schedule [Homework]

While I was away, Hui did a splendid job of starting a new series called Formula Forensics. The idea is to break down formulas for difficult real-world problems so that we can understand them better. In that spirit, I am giving you an interesting and tough formula homework. Situation: Imagine you work for Large Fries […]

Continue »

Excel for Project Managers is coming up next Monday (14th), Details Inside…

Published on Nov 9, 2011 in Project Management, Training Programs
Excel for Project Managers is coming up next Monday (14th), Details Inside…

Last week, we have announced about an upcoming online training program – Excel for Project Managers. Quite a few of expressed interest and shared ideas on how we should do this course. Finally, I am happy to announce the dates for this program and share details. Read on… Who is this program for? Well, there […]

Continue »

Using an Array Formula to Find and Count the Maximum Text Occurrences in a Range

Using an Array Formula to Find and Count the Maximum Text Occurrences in a Range

Chandoo is off on Holidays and once again thrown me the keys to Chandoo.org.

So this week we’re going to:

  • Pull apart an Array Formula and see what’s under the hood;
  • Have a look at a technique for quickly developing Custom Number Formats &
  • Look at how we can use HTML Codes in posts at Chandoo.org to spice up your questions and answers.

Today is Tarun’s Problem

“I have got multiple names in each row and would like to have what name is repeated maximum number of times and how many times?”

Today we pull apart an answer to this question and see how it works.

Continue »

Compare 2 Lists Visually and Highlight Matches

Published on Oct 27, 2011 in Excel Howtos, Learn Excel
Compare 2 Lists Visually and Highlight Matches

Comparison is one of the most common things we do with Excel. Naturally, there are so many ways to compare 2 lists of data using Excel.

Today, I want to share an interesting comparison problem with you.

Lets say you run a small shop which sells some highly specialized products. Now, since your products require quite some training before customers can buy them, you keep track of all product queries and arrange demos.

After a hectic week, you are staring at 2 lists. One with product queries, another with product demos. And you want to know whether all the queries are answered with a demo or not.

Continue »

Tell us what you would like to learn in our Excel for PMs course [Survey]

Published on Oct 25, 2011 in products, Project Management
Tell us what you would like to learn in our Excel for PMs course [Survey]

Few days ago, we announced about our upcoming Excel for PMs course. Quite a few of emailed me and told that you are looking forward for this.

Today I want to share our preliminary agenda for this course and take your help in fine-tuning it.

Continue »

Split an Excel File in to Many using VBA [Videos]

Published on Oct 19, 2011 in VBA Macros
Split an Excel File in to Many using VBA [Videos]

Splitting an Excel file in to many is easier than splitting bill in a restaurant among friends. All you need is advanced filters, a few lines of VBA code and some data. You can go splitting in no time.

Context:

Lets say you have lots of data like this in a file. And you want to split this in to multiple files, one per salesperson.

Solution – Split Data in to Multiple Files using Advanced Filters & VBA

The process of splitting data can be broken down to 4 steps …,

Continue »

Quickly Fill Blank Cells in a Table [Reader Tip]

Published on Oct 17, 2011 in Excel Howtos
Quickly Fill Blank Cells in a Table [Reader Tip]

This post is authored by Martin, one of our readers.

Situation:

Sometimes I encounter data in my tables with blank cells where there is a repeated value from the cell directly above. See below:

This can be annoying when it comes to interpreting the data and when sorting columns.

Solution:

To know how I solve this, just read rest of the article.

Continue »

Commercial Aspects of Project Management

Published on Oct 14, 2011 in Project Management
Commercial Aspects of Project Management

In 2005, fresh out of MBA School, I was put on managing an e-business transformation strategy project. It was then that realized that project management was a full time job (I always wondered before that why PMs were even paid a dime!). We created huge Project Management reports for the client, where were tracked and […]

Continue »

Filter values where Fruit=Banana OR Sales>70. In Other Words, How to use Advanced Filters?

Published on Oct 10, 2011 in Excel Howtos, Learn Excel
Filter values where Fruit=Banana OR Sales>70. In Other Words, How to use Advanced Filters?

Filtering is a simple yet powerful way to analyze data. When you apply filters to any list of values, Excel gives you some really useful pre-defined filters so that you can analyze the data in a variety of ways. So, assuming you have data like this: We all know how to filter data for Bananas. […]

Continue »

A Challenge from Hui

Published on Oct 3, 2011 in Excel Challenges, Posts by Hui

Hi All. I am about to head off on holidays for a couple of weeks during which time I will only have limited internet access and won’t be helping out here at Chandoo.org or at the ExcelHero Academy whilst away. I thought I may leave a few words and a Challenge for everyone. History In […]

Continue »

Incell Sales Funnel Charts

Published on Sep 29, 2011 in Charts and Graphs
Incell Sales Funnel Charts

Sales Funnel or Sales Process refers to a systematic approach to selling a product or service. [more on sales process] Whether you run a small business or part of a large corporation, chances are, you heard about Sale Funnel. Understanding & analyzing your sales performance from a Funnel point of view is a great way […]

Continue »

Sum of Values Between 2 Dates [Excel Formulas]

Published on Sep 27, 2011 in Excel Howtos, Learn Excel
Sum of Values Between 2 Dates [Excel Formulas]

Lets just say, you run a nice little orange shop called, “Joe’s Awesome Oranges“. And being an Excel buff, you record the daily sales in to a workbook, in this format. After recording the sales for a couple of months, you got a refreshing idea, why not analyze the sales between any given 2 dates? […]

Continue »