DATE Formula Excel – How to use Excel DATE Function

Posted on 23 July 2009

Syntax of DATE Formula Example of DATE Formula Possible Errors returned by the DATE Formula DATE formula in Excel returns the number representing the date for a given day, month and year. The DATE formula is typically used to construct a date by providing the constituting parts such as day, month and year. The minimum and maximum values that a date can take is Office 2003 is January 1, 1900 and December 31, 9999 (if that existed). DATE Formula ... Continue Reading

Comments (24)

VBA Chart

Posted on 20 July 2009

Making a chart using VBA can be easy. VBA provides a handle to a chart object using the "ChartObject" class and to the chart data series trough the "Series" class. Let's look at a basic example where we use VBA to create an empty chart to our spreadsheet and then add data to it. [cc lang="vb"] Sub CreateChart() Dim ChartObj As ChartObject Dim ChartSeries as Series Set ChartObj = ActiveSheet.ChartObjects.Add ( Left: = 100, Width: = 550, Top: = 75, Height: = 325) Set ... Continue Reading

Comments (6)

Pivot Table in Excel – How to Create and Use Pivot Table

Posted on 15 July 2009

Pivot Table Basics Learn How to Create Pivot Table in Excel Things that can be done with Pivot Tables in Excel Pivot Table Download What is a Pivot Table? A pivot table is a table that stores the summary of an underlying data set in a condensed form. A pivot table consists of rows, columns, page and data fields each of which can be moved around interactively and help the user isolate, expand, group and sum the data in real ... Continue Reading

Comments (8)

A New Rig

Posted on 15 July 2009

Last week my computer broke down. This time, unlike previous occasions, it just wouldn't resurrect itself. That rig was my first build and had been with me for the past eight years. It wasn't a thoroughbred, a humble Duron (AMD) at heart but it had its fair share of adventures. All those impromptu college parties, those last minute project reports, getting hauled around in a rug-shack, a thousand tweaks to squeeze the last remaining MHz out of the processor, even ... Continue Reading

Comments (1)

Make Mouse Scroll Wheel Work in VBA Editor (IDE)

Posted on 14 July 2009

This ranks right at the top of annoyances when it comes to working with the VBA IDE - the mouse scroll wheel simply does not work. So if you have more lines of code than can fit into a single screen in the VBA IDE, you end up having to drag the scroll bar to up/down to navigate. Jimmy Peña recently posted this very useful VBA tip on his informative blog that provides the solution to this issue. ... Continue Reading

Comments (10)

MATCH Formula Excel – How to use Excel MATCH Function

Posted on 13 July 2009

Syntax of MATCH Formula Example of MATCH Formula Possible Errors returned by the MATCH Formula MATCH formula in Excel returns the relative position of a value in an array or a range MATCH Formula Syntax MATCH Formula has three parts: MATCH (value_to_find, range_to_find_value_in, match_type) value_to_find value_to_find is the value which we are trying to find. It can be a number or a string. If the value_to_find is specified as a ... Continue Reading

Comments (4)

How to hide a sheet in Excel

Posted on 12 July 2009

How to Hide a sheet from users temporarily ? This option works only if you want Excel to hide the sheet temporarily - subsequent users can always make the worksheet visible again anytime they wish to. To make a worksheet invisible, simply click on the ‘Format’ -> ‘Sheet’ ->’Hide’ option from the menu and it will hide the sheet from view. This is oftentimes the simplest option. How To Hide a sheet with restricted ... Continue Reading

Comments     

ADDRESS Formula Excel – How to use Excel ADDRESS Function

Posted on 10 July 2009

Syntax of ADDRESS Formula Example of ADDRESS Formula Possible Errors returned by the ADDRESS Formula ADDRESS formula in Excel generates the address for a cell when provided a row and a column number. ADDRESS Formula Syntax ADDRESS Formula has five parts: ADDRESS (row_num, col_num, ref_type, ref_style, sheet_name) row_num row_num is the row number in which the cell for which you are trying to generate the address is located. It is ... Continue Reading

Comments (3)

Array Formulas Examples

Posted on 08 July 2009

Array formulas help you turn normal Excel Formulas into super formulas. Here are a few examples of Array formulas. These examples highlight the use of multiple conditions within a single array formula and how we can club multiple formulas in to a single array formula. Array formulas are powerful - no doubt about that. However before we go any further, one must look at the flip side to using array formulas. They take much more computational power and can slow ... Continue Reading

Comments     

Javascript Charting Library

Posted on 06 July 2009

A Javascript charting library is a compilation of javascript code which helps you create charts in a browser. Here's a list of 5 Javascript charting libraries that I had a chance to review : (Each of the Javascript charting libraries reviewed below would offer its own custom functions to interact with the chart object. If a chart fits your need, you may want to read the chart library's API documentation in greater detail. However, if you're short on development time, this ... Continue Reading

Comments     

Array Formulas in Excel – Excel Array Formula Syntax & Array Constants

Posted on 05 July 2009

Array Formulas in Excel An Array Formula in excel is a formula that uses arrays instead of single cell value as input. Excel Array Formulas can be thought of as many formulas packed into a single super formula. In this article we will take a look at the syntax of an array formula, its various parts, learn how to write a basic array formula and then graduate on to writing the more powerful versions of it. Before we begin, let ... Continue Reading

Comments (16)

COUNTIF Formula Excel – How to use Excel COUNTIF Function

Posted on 04 July 2009

Syntax of COUNTIF Formula Example of COUNTIF Formula Possible Errors returned by the COUNTIF Formula COUNTIF formula in Excel counts the numbers of cells in a range that meet the given condition. COUNTIF Formula Syntax COUNTIF Formula has two parts: COUNTIF (range, criteria) range range is the range in which the value that you are trying to find out is located. criteria criteria is the value whose occurence in the above range we would like to count. ... Continue Reading

Comments (3)

IF Formula Excel – How to use Excel IF Function

Posted on 04 July 2009

IF formula in Excel checks whether a given condition evaluates TRUE or FALSE. Syntax of IF Formula Example of IF Formula Possible Errors returned by the IF Formula IF Formula Syntax IF Formula has three parts: IF(criteria, value_when_true, value_when_false) criteria criteria is the condition that we would like to evaluate for being TRUE or FALSE. value_when_true value_when_true is the value that will be returned by the function when the above criteria evaluates to TRUE. This ... Continue Reading

Comments (5)

Javascript Get the Current Path without %20 and / backslash

Posted on 03 July 2009

To get the current path using javascript without the %20 and / (backslash), use the following code: [cc lang="vb"] var path = document.location.pathname; alert (path); [/cc] However using the javascript path variable in this manner gives something like this: So now we use the string replace function in Javascript to rectify this: [cc lang="vb"] var path = document.location.pathname; path = path.replace(/\//gi, ""); path = path.replace(/%20/gi, " "); path = path.replace(/\\/gi, "\/"); alert (path); var path = document.location.pathname; [/cc] This javascript code gives us the path ... Continue Reading

Comments (1)