Search

# All articles with 'excel optimization' Tag

## Speed up your Excel Formulas [10 Practical Tips]

Published on Apr 14, 2023 in Excel Howtos, Learn Excel

Excel formulas acting slow? 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 Dynamic Array formulas
5. Use manual calculation mode

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

Continue »

Published on Jan 7, 2016 in Chandoo.org Podcast Sessions

In the 51st session of Chandoo.org podcast, let’s discuss most frequently asked questions about VLOOKUP.

### What is in this session?

In this podcast,

• What is VLOOKUP?
• What happens when VLOOKUP can’t find the value?
• Should my list be sorted?
• Is VLOOKUP slower than INDEX + MATCH?
• What if my list has multiple matches?
• How to fetch 2nd / 3rd matching item?
• How to fetch all matching items?
• How to fetch items matching multiple conditions?
• How to speed up VLOOKUP?
• Why doesn’t my VLOOKUP work?
• What to do in case of errors?
• Resources for you
Continue »

## Handle Volatile Functions like they are dynamite

Published on Mar 3, 2014 in Learn Excel, Posts by Jeff

If you’re building large models, then you may want to use volatile functions – including OFFSET(), INDIRECT(), and TODAY() – with caution, because unless you know what you are doing, they *might* slow Excel down to the point that data entry is sluggish, if not downright tedious.

In fact, you *might* want to consider getting out of the habit of using these functions at all if there are alternatives, and you might want to replace volatile functions in your existing models with non-volatile alternatives…I have reduced recalculation time in large models from minutes to milliseconds by doing just that!

So what the heck does volatile actually mean? And why should you care? Let’s find out, shall we?

Continue »

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

Published on Mar 27, 2012 in Learn Excel, VBA Macros

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.

Continue »

## Optimization Tips & Techniques for Excel VBA & Macros [Speedy Spreasheet Week]

Published on Mar 22, 2012 in VBA Macros

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]

Published on Mar 21, 2012 in Charts and Graphs, Excel Howtos

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 »

Published on Mar 19, 2012 in Excel Howtos

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 »

### Get FREE Excel & Power-BI Newsletter

One email per week with Excel and Power BI goodness. Join 100,000+ others and get it free.