All articles with 'ssw' Tag
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
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 »
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.Continue »
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 »
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 »
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 »
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 »