Archive for January, 2012

Custom Number Formats (Multiply & Divide by any Power of 10)

Published on Jan 31, 2012 in Excel Howtos, Huis, Posts by Hui
Custom Number Formats (Multiply & Divide by any Power of 10)

In the past here at Chandoo.org and at many many other sites, people have asked the question
“How can I display a number multiplied or divided by 10, 100, 1000, 1000000 etc, but still have the cell maintain the original number for use in subsequent calculations”.

Typically the answer has been limited to “It can’t be done” or “it can only be done in multiples of 1000”.

This post will show you how you can display numbers whilst Dividing or Multiplying the cells value by any Power of 10 !

Continue »

Excel Links – Live from Bangkok Edition

Published on Jan 30, 2012 in excel links, personal

It has been a while since we had an Excel Links feature. So here we go again. But before jumping in to all the Excel goodness, let me share a few tidbits about our Bangkok adventure.

Continue »

Cleaning Up Imported Data – A Recent Case Study

Published on Jan 25, 2012 in Excel Howtos, Huis, Posts by Hui
Cleaning Up Imported Data – A Recent Case Study

Houston, We’ve Had a Problem!
In the initial emails requesting a solution to yesterday’s Formula Forensics, Chandoo’s solution, although Technically correct, Didn’t work ?
This post looks at the problem and what was wrong with the data causing the error.

Continue »

Formula Forensics No. 008 – Elkhan’s MaxIf

Published on Jan 24, 2012 in Formula Forensics, Huis, Posts by Hui
Formula Forensics No. 008 – Elkhan’s MaxIf

Today in Formula Forensics we look at how to Calculate the Maximum value from a list subject to other fields meeting certain criteria:

Continue »

Excel’s Auditing Functions [Spreadsheet Risk Management – Part 3 of 4]

Published on Jan 18, 2012 in Financial Modeling, Learn Excel
Excel’s Auditing Functions [Spreadsheet Risk Management – Part 3 of 4]

This series of articles will give you an overview of how to manage spreadsheet risk. These articles are written by Myles Arnott from Excel Audit Part 1: An Introduction to managing spreadsheet risk Part 2: How companies can manage their spreadsheet risk Part 3: Excel’s auditing functions Part 4: Using external software packages to manage […]

Continue »

Formula Forensics. 009 – Pradhishnair’s Chainage Problem

Published on Jan 17, 2012 in Excel Howtos, Formula Forensics, Huis, Posts by Hui
Formula Forensics. 009 – Pradhishnair’s Chainage Problem

A common Forum Post question and one that Chandoo has written about a few times is, Does my data overlap with another range?

This week Formula Forensics examines Pradhishnair’s Overlapping Chaninage Problem where he wants to know if two values overlap with a range of other values

Continue »

Six Quick Updates

Published on Jan 16, 2012 in blogging, Learn Excel, VBA Macros

Hello my friend,

I have a few quick updates to start the week. Just read on to keep up.

Excel VBA section of Chandoo.org

During last few weeks, I have spent several hours organizing all the VBA material on Chandoo.org. I am happy to announce our brand to Excel VBA area of the site.

This section has Excel VBA overview, examples, videos, tips, books, references & more. Check it out.

Read on for the remaining 5 updates…

Continue »

Finding Friday the 13th using Excel (and learning cool formulas along way)

Published on Jan 13, 2012 in Formula Forensics, Learn Excel
Finding Friday the 13th using Excel (and learning cool formulas along way)

Not that I have friggatriskaidekaphobia or anything. But since today is Friday & 13th, lets put our Excel skills to test and find out when the next Friday the 13th is going to be.

Continue »

Announcing Online VBA Classes from Chandoo.org, Please Join Today

Published on Jan 11, 2012 in products, VBA Macros

VBA Classes from Chandoo.org - Learn Microsoft Excel VBA & MacrosFriends & Readers of Chandoo.org,

I am so happy to tell you that our VBA Classes are now open for your consideration. Click here to know more & join us.

What is this VBA Class?

VBA Class is a structured and comprehensive online training program for learning Microsoft Excel VBA (Macros). It is full of real world examples & useful theory.

The aim of VBA Classes is to make a beginner an expert in VBA.

Read on to understand the benefits of this program & how to sign-up.

Continue »

Use CTRL+Enter to Enter Same Data in to Multiple Cells [Quick Tip]

Published on Jan 9, 2012 in Excel Howtos
Use CTRL+Enter to Enter Same Data in to Multiple Cells [Quick Tip]

Here is a quick Excel tip to kick start your week.

Sometimes, we want to enter same data in to several cells. You can use CTRL+Enter to do this in a snap.

(1) Select all the cells where you want to enter the same data.
(2) Type the data
(3) Press CTRL+Enter
(4) Done!

See the animation aside to understand how this works.

Continue »

12 Steps to become awesome in Excel (and your work) in 2012

Published on Jan 6, 2012 in Learn Excel
12 Steps to become awesome in Excel (and your work) in 2012

Obviously, everywhere you look this week, you find advice on how to do better in 2012.

While you don’t have to wait for a new year to become awesome at your work, You might use the occasion.

So, today I want to share 12 ways to become awesome in Excel. But first I have secret to confess…,

I think becoming awesome in Excel useless.

What we really want is, to become awesome in our work. Since we spend a lot of time using Excel (and other office software), knowing how to use these better can have a huge impact on how we do our work.

In that spirit, lets look at 12 steps to become awesome in your work using Excel.

Continue »

Quick Update about VBA Classes & Discount Expiry!

Published on Jan 5, 2012 in Excel Howtos, Learn Excel

I have 2 quick announcements & 1 Excel tip for you.

Announcements

Read on for a bonus Excel tip as well.

Continue »

How Companies Can Manage Spreadsheet Risk [Part 2 of 4]

Published on Jan 3, 2012 in Financial Modeling, Learn Excel
How Companies Can Manage Spreadsheet Risk [Part 2 of 4]

In the second installment on Excel Spreadsheet Risk Management, Myles takes a look at How companies can manage spreadsheet risk?.

He tells us, how we can set a formal governance framework to reduce or mitigate spreadsheet risk. Go ahead and read. And please tell us how your company manages spreadsheet risk in comments.

Continue »

Free Picture Calendar Template – Download and make a personalized calendar today!

Published on Jan 2, 2012 in Learn Excel, VBA Macros
Free Picture Calendar Template – Download and make a personalized calendar today!

Here is something fun, personalized and delicious to start your new year. A Picture Calendar built in Excel!

Using this you can print a 12 month calendar with your own photos. Its fun to use, easy to set up and looks great. Read more to understand how this works & download the template.

Continue »