Archive for March, 2012
Comprehensive Guide to VLOOKUP & Other Lookup Formulas
This week many Excel bloggers are celebrating VLOOKUP week. So I wanted to chip in and give you a comprehensive guide to VLOOKUP & Other lookup formulas. Read on …,
What is VLOOKUP Formula & how to use it?
I often tell my excel school students that learning VLOOKUP formulas will change your basic approach towards data. You will suddenly feel that you have discovered a superman cape in your attic. It is that awesome.Continue »
Formula Forensics 016. Suzannes DJIA Average
“I was trying to calculate the average DJIA # by month. I had the data by day so tried various combos (none of which worked) (:-”
Learn how to help Suzanne average the DJIA on a particular day and learn about a new Excel Function all in one post.Continue »
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.
Formula Speeding-up Tips
VBA / Macros Optimization Tips
Share your tips
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 »
Today, I am taking a break from Speedy Spreadsheet Week to celebrate Telugu New year with my family. Ugadi (meaning start of a new era) is celebrated on first day of Telugu year and occurs in March / April.
Here is a pic from early today morning, when we could finally convince the kids to laugh when the camera clicks.Continue »
Optimization Tips & Techniques for Excel VBA & Macros [Speedy Spreasheet Week]
Is VBA slowing down your workbooks? Do you spend hours starting at Excel while the macros finish running? As part of our Speedy Spreadsheet Week, today lets talk about optimization techniques for Excel VBA & Macros.
Optimization Techniques for Excel VBA & Macros
Lets break this in to 2 sections. (1) Quick optimization techniques & tactics (2) Optimization ideas for the long run. Read on…,Continue »
Speeding up & Optimizing Excel – Tips for Charting & Formatting [Speedy Spreadsheet Week]
Is Excel acting slow & taking ages? As part of our Speedy Spreadsheet Week, today lets talk about optimizing & speeding up Excel by formatting & charting better. Use these tips & ideas to super-charge your sluggish workbook.
No matter how much data you got, how many formulas you wrote, the end users seldom see them on your workbook. They see the finalized dashboard, they play with the model, they look at the report. And if you make poor choices, your end users will thing your workbook is slow.
So let me present you 7 charting & formatting tips to optimize & speed up Excel. Read on…,Continue »
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 »
This week, Speed up your Spreadsheets – Your Action Required
In recent installment of Customer Service Dashboard post, our reader Salmon asked an interesting question,
I am struggling with data size with my dashboards…so many SQL data pulls and formulas to generate the Dashboard, the entire file is massive and sluggish. Perhaps a few tips from Chandoo Master for all us rookie dashboard designers regarding how to minimize file size and maximize calc speeds. #
Dan l & others chipped in and shared their ideas on speeding up Excel. But the topic is wide & has many solutions. So I am dedicating an entire week to discuss this. Welcome to Speedy Spreadsheet Week.Continue »
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 »
What is so special about Go To Special? [15 tips]
We briefly covered Excel’s Go To Special function in the Managing Spreadsheet Risk series and in this post, we are going to explore Go to special feature in detail and learn how to use it.
What is Go To Special?
Go To Special is a tool within Microsoft Excel that enables you to quickly select cells of a specified type within your Excel worksheet. Once you get to grips with this function and what it can be used for you will wonder how you ever lived without it. Read on…,Continue »
Formula Forensic No. 015 – Cornelia’s Price Rises
Cornelia wanted to cumulatively increases prices to a lot of products.
See how it was accomplished using an Array Formula to assist.
In Cell Text Formats – 2 Quick Tips
Did you know you can apply any text effect to a single character or group of text characters within a cell ?
This post will show you 2 quick tips to assist you in this technique.Continue »
Yet Another Sales Funnel Chart in Excel
A while ago, our reader Shay emailed me a Sales Funnel chart template.
I had to create a sales funnel for my company and I looked all over the internet to see how to do what I needed to do. I couldn’t find anything. I tried your funnel chart as well but because my numbers are all over the place I couldn’t get it to work for me.
I get so much information from you that I decided to share this chart with you. I used the shapes drawings to create the funnel graphic and the camera tool to place the values in each shape. I used formulas in the original data so that I will not have to recalculate every month.
I took the liberty of making little changes to Shay‘s funnel chart template to make it even better. Here is how the funnel looks like.Continue »
Do you use Pivot Tables? What do you use them for & where do you struggle [Survey]
If you like to analyze data, then you would fall in love with Pivot Tables on first sight. Pivot tables are a powerful, dead-simple & lovely way to play with your data, automate your reports and save time. That said, not all of us know how to use them or how to get them to […]Continue »