Excel Slow to Respond – Avoiding Mistakes that Make Excel Slow Down to a Crawl

Everyone hates it when excel becomes slow to respond. So here are some tips to avoid doing things that can slow down excel. Excel 2007 and later versions sport a much bigger grid which tends to amplify poor spreadsheet design. An Excel spreadsheet that seemed a bit slow in Excel 2000 would likely get bogged down to a crawl in Excel 2007 if you, like me, are using the same hardware. The key to understanding ...

Continue Reading

Excel Slow to Respond - Avoiding Mistakes that Make Excel Slow Down to a Crawl

How to write a macro in Excel

Posted on 29 July 2009

How to write a macro in Excel
How to write a macro in Excel? Here are a few quick tips: Excel Macro - How to Record Excel Macro - How to Edit Excel Macro - Improving speed of code Excel Macro - Examples Recording a macro in Excel How to record a macro in Excel 2007 and Excel 2010 In Excel 2007 (and Excel 2010), the "Record Marco" menu option is under the "View" ribbon. Click on the "Macros" button towards ...
Continue Reading

Comments (7)

Excel 2007 – Review Continues

Posted on 28 July 2009

Excel 2007 - Review Continues
Excel 2007 was, for me, the discovery of the month. This article continues the review that I started in the previous post. Though this post should have been written about two years back, inspiration only struck me this weekend. Named Range in Excel 2007 The named range is a definite improvement over 2003. A lot of features have again been bought forth in this version (or added anew) such as scope definition and being able to view the values (a great ...
Continue Reading

Comments (4)

Excel 2007

Posted on 25 July 2009

Excel 2007
Excel 2007 finally happened to me. Its not that I've never though of moving to Excel 2007 from the 2003 avatar of Excel, but you see, yours truly has never been accused of being an early adopter in the past, no sir never, and I've got a duty to protect that reputation. I bought my first phone after it had been on the market for a few years, bought my first car after it had been on road for a ...
Continue Reading

Comments (10)

Hide Error Value and Error Indicators in Excel

Posted on 26 June 2009

Hide Error Value and Error Indicators in Excel
To hide error value and error indicators in Excel you can use any of the following means: Hide error values using conditional formatting Hide errors indicators by turning off background error Hide error values by using IF(ISERROR()) function Hide error using a custom VBA function Let's take a closer look at each type of error handling method. Hide error values using conditional formatting Click on the cell that contains an error value. From the menu, select 'Format' -> 'Conditional Formatting'. ...
Continue Reading

Comments (3)

Fix Runtime Error in VBA

Posted on 24 June 2009

Fix Runtime Error in VBA
To fix runtime errors is VBA, use the following three statements - On Error, Resume and Debug. The first one traps a runtime VBA error when it occurs, the second one tells the application the point from which to resume code execution when the error has been caught (if you decide to catch the error) and the third one informs the user where (and which) runtime error took place. A runtime Error in VBA can occur for a plethora of reasons. ...
Continue Reading

Comments (7)

Chart Table – When a Beautiful Chart meets a Handsome Table

Posted on 16 June 2009

Chart Table - When a Beautiful Chart meets a Handsome Table
Chart table - as the name suggests - is a beautiful fusion of a chart and a table giving rise to a visually appealing yet information rich presentation of data. Not that the concept itself is anything new - experts have openly and vociferously championed the cause of the chart table, its various facets have been discussed at length in numerous forums and the latest versions of excel come equipped with tools that further aid their creation (namely sparklines). However ...
Continue Reading

Comments (1)

How to generate a sample set with normal distribution in Excel

Posted on 09 June 2009

How to generate a sample set with normal distribution in Excel
Normal distribution is one of the most commonly found distribution types in nature. The normal distribution is a continuous probability distribution where the data tends to cluster around a mean or average. If you were to plot the frequency distribution of a normal distribution, you will tend to get the famous inverted bell-shaped curve also known as the Gaussian function. Coming to the point, we are sometimes faced with situations where we would like to test out a hypothesis or carry ...
Continue Reading

Comments (9)

Make excel calculate faster – Quick tip

Posted on 09 June 2009

Make excel calculate faster - Quick tip
If you want to make your large excel workbook calculate faster and have about 10 seconds of time on your hands, use this trick. 1. Open the workbook and select the spreadsheet with the largest number of formulas (or data). 2. While keeping the 'Ctrl' key pressed, press 'End'. 3. Check the cell address that the cursor has moved to. 4. If the cursor is well beyond the last cell that had a formula ...
Continue Reading

Comments     

Retirement Planner in Excel

Posted on 04 June 2009

Retirement Planner in Excel
Retirement planner in Excel will help you calculate your savings at the time of retirement. The Excel retirement planner takes in to consideration your monthly income, expenses, asset purchase over time, saving allocations and expectations of interest rates and asset appreciation to calculate the growth of your savings over a given period. You can download the retirement planner in excel here. All of us worry about the impeding retirement. How ...
Continue Reading

Comments     

Excel Chart Tip – Insert Chart Series in an Excel Chart

Posted on 03 June 2009

Excel Chart Tip – Insert Chart Series in an Excel Chart
Adding new series to an Excel Chart can be a boring job. Normally you'd edit the Excel chart by right clicking the chart area and adding a new series in the Source Data box (which can take up to 7 clicks). By using this quick tip you can now insert a new chart series with just two mouse clicks. Here’s how it can be done. Inserting a new series ...
Continue Reading

Comments (4)

Make Charts in Excel Using Symbols

Posted on 21 May 2009

Make Charts in Excel Using Symbols
You can use Excel to make charts using symbols and display unconventional characters. Here's a list of symbols that can be used for making charts in excel. You can generate these symbols in Excel by formatting normal alpha-numeric characters with in-built or custom fonts (Windings, MS Outlook etc.) Few quick tips: To make a bar graph Use the REPT(char) function in Excel to repeat a character. Choose from the list of symbols ...
Continue Reading

Comments (1)

Excel #N/A #REF! #NAME? #DIV/0! #NULL! #VALUE! #NUM! Error

Posted on 20 May 2009

Excel #N/A #REF! #NAME? #DIV/0! #NULL! #VALUE! #NUM! Error
Have you ever encountered the #N/A, #REF!, #NAME?, #DIV/0!, #NULL!, #VALUE! or #NUM! errors in Excel? Learn more about these errors and how to avoid them in simple terms. Why does Excel show #N/A, #REF!, #NAME?, #DIV/0!, #NULL!, #VALUE! or #NUM! errors? #NAME? Error The #NAME error is generated when a cell tries to reference a non-existent cell call a non-existent function. If you enter a formula that does not exist ...
Continue Reading

Comments (6)

How to Format a Pivot Table in Excel

Posted on 19 May 2009

How to Format a Pivot Table in Excel
In this post you will learn about how to format pivot tables in excel. Formatting a pivot table is often the step that people tend to miss out when presenting information using pivot tables. By formatting a pivot table you can make the data stand out, occupy less screen 'real estate' and make the user's life simpler. (You can download a copy of the format a pivot table in excel workbook with an example here.) How to Format a Pivot Table? Let ...
Continue Reading

Comments     

Six Sigma Calculator in Excel

Posted on 11 May 2009

Six Sigma Calculator in Excel
How do you make a six sigma calculator in Excel? Well it's all really quite simple in excel....the calculator needs only a single formula to generate the sigma level for a process!!! You simply plug the number of opportunities & defects into an excel spreadsheet and calculate the sigma level by using NORMSINV (1 - defect/opportunities). You can download a copy of the six sigma calculator in excel here. Before ...
Continue Reading

Comments (5)

How to Create a Pareto Chart in Excel

Posted on 05 May 2009

How to Create a Pareto Chart in Excel
Find out how to create a Pareto chart in Excel. A Pareto chart can be created in Microsoft Excel as a combination of a bar and a line chart. A Pareto chart (also known as the Pareto graph) is a combination of two data series, one set of points representing a set of independent values and the other representing the cumulative sum of those values. The independent values are typically represented by vertical bars in which the values are arranged ...
Continue Reading

Comments (11)

How to create an Excel Flow Chart – (Template and Software)

Posted on 04 May 2009

How to create an Excel Flow Chart - (Template and Software)
This tutorial shows how to create a Flow charts in Excel. Flowcharts help you logically represent a sequence of activities in a process. Before you begin, you may want to download and analyze this sample flowchart template created using excel. Making flowcharts in Excel can be as easy and fast as it is in Microsoft Visio without having to buy a license for the later. If you work in a company where a lot of planning and process engineering ...
Continue Reading

Comments (4)

Excel Keyboard Shortcuts – A list of 125+ Keyboard Shortcuts in Excel

Posted on 29 April 2009

Excel Keyboard Shortcuts - A list of 125+ Keyboard Shortcuts in Excel
Here is a comprehensive list of more than 125 keyboard shortcuts in Excel. You can download the entire list of keyboard shortcut keys as an Excel workbook here. These shortcuts cover formatting cells and worksheets, inserting rows and columns, calculations, handling workbooks and a number of other useful keys that will make you an Excel Keyboard expert in no time....
Continue Reading

Comments (2)

Excel VBA For Do While and Do Until Loop

Posted on 21 April 2009

Excel VBA For Do While and Do Until Loop
The VBA For Loop and the Do While loops are the two most important loops in the VBA language. They can be used to carry out a specific task in an iterative manner till such time that a condition is met (or the VBA loop is terminated). Download the worksheet with examples of the for, do while and do until loops in VBA The VBA For Loop The VBA For ...
Continue Reading

Comments (7)

Excel Waterfall Chart Template with Negative Values

Posted on 16 April 2009

Excel Waterfall Chart Template with Negative Values
If all you need to do is to get a copy of the Excel Waterfall Chart Template with Negative Values then you can simply download it here. For those interested in knowing how to create a waterfall chart in excel, please read on. How do I create a waterfall chart in excel? There are two ways to create a waterfall chart in Excel. The first is to simply lay out a grid ...
Continue Reading

Comments (29)

Subscribe

Keep up with the latest stories - Delivered right to your inbox
feedburner

Translate

English flagItalian flagKorean flagChinese (Simplified) flagPortuguese flagGerman flagFrench flagSpanish flagJapanese flagArabic flagRussian flagDutch flagHindi flagFilipino flagIndonesian flagThai flagTurkish flagPersian flag
treeemap software for excel


ARCHIVES