All articles in 'Learn Excel' Category

75 Excel Speeding up Tips Shared by YOU! [Speedy Spreadsheet Week]

Published on Mar 27, 2012 in Learn Excel, VBA Macros
75 Excel Speeding up Tips Shared by YOU! [Speedy Spreadsheet Week]

As part of our Speedy Spreadsheet Week, I have asked you to share your favorite tips & techniques for speeding up Excel. And what-a-mind-blowing response you gave. 75 of you responded with lots of valuable tips & ideas to speed-up Excel formulas, VBA & Everything else.

Thanks to all the contributors

Many thanks to everyone who shared their tips & ideas with us. If you like the tips, please say thanks to the contributor.

Read Excel Speeding-up tips by area

This page is broken in to 3 parts, click on any link to access those tips.

Read everything
Formula Speeding-up Tips
VBA / Macros Optimization Tips
Everything Else
Share your tips

Continue »

Excel Speedup & Optimization Tips by Experts [Speedy Spreadsheet Week]

Published on Mar 26, 2012 in Learn Excel, VBA Macros
Excel Speedup & Optimization Tips by Experts [Speedy Spreadsheet Week]

As part of Speedy Spreadsheet Week, I have emailed few renowned Excel experts and asked them to share their tips & ideas to speedup Excel. Today, I am glad to present a collection of the tips shared by them. Read the Excel optimization & speeding up tips shared by Hui, Luke, Narayan, George, Gregory & Jordon.

Continue »

Speed up your Excel Formulas [Speedy Spreadsheet Week]

Published on Mar 20, 2012 in Excel Howtos, Learn Excel
Speed up your Excel Formulas [Speedy Spreadsheet Week]

Excel formulas acting slow? As part of our Speedy Spreadsheet Week, today lets talk about optimizing & speeding up Excel formulas. Use these tips & ideas to super-charge your sluggish workbook. Use the best practices & formula guidelines described in this post to optimize your complex worksheet models & make them faster.

1. Use tables to hold the data
2. Use named ranges & named formulas
3. Use pivot tables
4. Sort your data
5. Use manual calculation mode

… and more. Read on to learn these top 10 tips & ideas to improve performance of your excel formulas.

Continue »

Data and Calculations for our Customer Service Dashboard [Part 2 of 4]

Data and Calculations for our Customer Service Dashboard [Part 2 of 4]

Welcome back. In part 2 of Making a Customer Service Dashboard using Excel let us learn how the data & calculations for the dashboard are setup.

Designing Customer Service Dashboard
Data and Calculations for the Dashboard
Creating the dashboard in Excel
Adding Macros & Final touches

In this installment, we will examine all the variables, named ranges & various formulas that drive our dashboard. Also, you can download the full dashboard workbook and play with it to examine these formulas and learn better.

Continue »

14 ways to check if an year is leap year, using Excel [just for fun]

Published on Feb 29, 2012 in Excel Howtos, Learn Excel
14 ways to check if an year is leap year, using Excel [just for fun]

Today is February 29th, and that means, this year we have one more day to be awesome. So lets celebrate it in Excel style!

Lets learn 14 different ways to tell if an year is leap year, using Excel Formulas.

Why 14? because, we are awesome like that.

Continue »

Designing a Customer Service Dashboard in Excel [Part 1 of 4]

Published on Feb 22, 2012 in Charts and Graphs, Learn Excel
Designing a Customer Service Dashboard in Excel [Part 1 of 4]

Sawadee Krup folks. Today, we begin a new series on Chandoo.org – Making a Customer Service Dashboard using Excel. This 4 part tutorial teaches you,

Designing Customer Service Dashboard
Data and Calculations for the Dashboard
Creating the dashboard in Excel
Adding Macros & Final touches

Customer service is one area where a lot of data is collected regularly. Understanding all this and making business decisions is quite complex task. This is where dashboards shine.

Read on to learn how to design customer service dashboards.

Continue »

Reporting Scenarios using Offset

Published on Feb 14, 2012 in Excel Howtos, Financial Modeling, Learn Excel
Reporting Scenarios using Offset

Project Managers often report financial numbers to the management. In a dynamic world, these numbers are usually based on a lot of factors that may or may not be under your control. So the top management demands that the numbers be reported as per different economic scenarios – Optimistic, Normal or Pessimistic. It is important […]

Continue »

Learn Statistics & Probability using MS Excel

Published on Feb 13, 2012 in excel apps, Excel Howtos, Learn Excel, simulation, VBA Macros
Learn Statistics & Probability using MS Excel

One of the most dreaded courses during my under-graduation is Probability, Statistics & Queuing Theory. We called it PSQT. I struggled to understand the significance and concept of this course as I could barely concentrate in the class. We had a professor, who is probably a genius, but the moment he started the class, I would magically fall in to one of my after-noon naps. When I woke up, we are either in the middle of an elaborate t-test or going thru intricacies of a Markovian queue.

This was all 11 years ago. Later in life, I have embraced the world of probability & statistics. I still fear queues. May be I will get there one day. 😉

A good understanding of statistics & probability theory is necessary if you want to model complex real-life problems using Excel or similar tools. Naturally, Excel has several functions, features & supported add-ins to help you in this area.

Today, I want to share some of this with you. This article is broken down in to 3 parts.

  1. Learning Statistics & Probability using Excel
  2. Downloadable Excel Workbooks to understand
  3. Full blown models & simulations in Excel
Continue »

How would you customize Excel after installing? [poll]

Published on Feb 10, 2012 in Excel Howtos, Learn Excel
How would you customize Excel after installing? [poll]

Recently, I bought a new laptop, because my old Toshiba died down. After installing the OS and other necessary tools (like browser, skype etc.), I have installed Office 2010. Since Excel is my bread and butter, I like to customize it so that I can get more work done. So today,let me share how I […]

Continue »

Using external software packages to manage your spreadsheet risk [Part 4 of 4]

Published on Feb 8, 2012 in Financial Modeling, Learn Excel
Using external software packages to manage your spreadsheet risk [Part 4 of 4]

Background – Spreadsheet Risk Management

In the Managing Spreadsheet Risk series so far we have looked at the concept of spreadsheet risk and how to manage it both at a company level and at a spreadsheet level using Excel functionality. In this final article we are going to have a quick look at an example of spreadsheet auditing software.

What to look for in a Spreadsheet Risk Management Software

First off I should state that there is a wide range of spreadsheet auditing solutions in the marketplace of different types and styles and at a variety of costs. In this section I would like to take a little time to explain the criteria we applied when we were sourcing auditing software.

Continue »

Comparing 2 Lists with a Twist

Published on Feb 6, 2012 in Excel Howtos, Learn Excel
Comparing 2 Lists with a Twist

We love to compare. The instinct to compare leaves no one. Even my two year old twins compare their toys with each other (and fight).

It would make Excel hugely popular if Microsoft builds a handy data comparison tool right in to it. Alas, they have customizable ribbon, 3d effects & equation editor…

Since comparison is one of the main uses of Excel, we have written extensively about it here.

But there is always one more interesting comparison problem. Today, I want to share one such problem, based on a comment left by N-Man.

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 »

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 »

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 »