All articles with 'ssw' Tag

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 »

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

Published on Mar 22, 2012 in VBA Macros
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]

Published on Mar 21, 2012 in Charts and Graphs, Excel Howtos
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]

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 »

This week, Speed up your Spreadsheets – Your Action Required

Published on Mar 19, 2012 in Excel Howtos
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 »