# Monthly Archives: April 2013

Home/2013/April

## Copy Files from One Location to Another folder or directory in Excel VBA

Examples to Copy Files from One Location to Another folder or directory in Excel VBA - if File does not exists in the source or already in the destination.

By |April 28th, 2013|Excel VBA|30 Comments

# 100+ USEFUL VBA CODES & MACROS

## The Most Useful VBA Codes & Macros! Do Almost Everything! We have explained verity of examples to cover most frequently used codes.

By |April 28th, 2013|Excel VBA|182 Comments

## TIME Function in Excel

What is the use of TIME function? Returns the number that represents the particular time What is the syntax of TIME function? TIME(hour, minute, second) Where hour: It is a number from 0 to 23 representing the hour minute: It is a number from 0 t0 59 representing the minute second: It is a number

By |April 27th, 2013|Excel Formulas|0 Comments

## DATE Function in Excel

DATE Function in Excel - formula returns the number that represents the particular date. Learn Formulas, Excel and VBA with examples in our free tutorials.

By |April 27th, 2013|Excel Formulas|0 Comments

## SUBSTITUTE Function in Excel

SUBSTITUTE Function in Excel - formula replaces old text with new text, in a text string or cell reference. It will replace all instances of the old text, unless a specific instance number is selected.

By |April 27th, 2013|Excel Formulas|1 Comment

## Check if file Exists in Location using Excel VBA

Example code to Check if file Exists in Location using Excel VBA. We can use FileSystemObject and FileExists, Dir functions.

By |April 27th, 2013|Excel VBA|5 Comments

## OFFSET Function in Excel – Formula Explained with Examples

OFFSET Function in Excel - formula returns a reference to a range of cells that is a specified number of rows and columns from an initial supplied range

By |April 23rd, 2013|Excel Formulas|3 Comments

## COLUMN Function in Excel

COLUMN Function in Excel - formula returns the column number of the given reference. Learn Formulas, Excel and VBA with examples in our free tutorials.

By |April 20th, 2013|Excel Formulas|0 Comments #### Learning Basic Excel VBA By Examples is the easiest way to understand the basics of VBA to deal with Excel Objects, in this tutorial we will not covering any programming concepts, we will see how to access the different Excel Object using VBA.

By |April 20th, 2013|Excel VBA|40 Comments

## ROW Function in Excel

ROW Function in Excel - fromula returns the row number of the given reference. Learn Formulas, Excel and VBA concepts with examples in our free tutorials.

By |April 17th, 2013|Excel Formulas|0 Comments

## Hyperlinks in Excel VBA – Explained with Examples!

By |April 17th, 2013|Excel VBA|25 Comments

## Excel VBA to Interact with Other Applications

Another powerful feature of Excel VBA is to interact with Other Applications - Examples to deal with MS Word, PowerPoint, Access, Internet Explorer,etc.

By |April 15th, 2013|Excel VBA|1 Comment

## Getting Started with Microsoft Excel

In this section I will introduce the basic features of Microsoft Excel, one of the tools in the MS Office Package. It is a spreadsheet application used to enter the data (text, numbers, etc...) to perform calculations, analysis and store it in a file. There are many built-in functions and formulas allow you to perform calculations and you can create attractive, readable presentations and rich visualized dashboards including tables, charts,etc...

By |April 15th, 2013|Excel|1 Comment

## CELL Function in Excel

CELL Function in Excel - formula returns information about the contents, formatting or location of a given cell. Learn Formulas, Excel and VBA with examples

By |April 14th, 2013|Excel Formulas|0 Comments

## REPLACE Function in Excel

REPLACE Function in Excel - formula replaces a sequence of characters/words in a string with another set of characters/words. Learn Formulas with examples .

By |April 11th, 2013|Excel Formulas|1 Comment

## LEN Function in Excel

LEN Function in Excel - formula Returns the length of the specified string. Learn Formulas, Excel and VBA with examples explained in our free tutorials.

By |April 11th, 2013|Excel Formulas|0 Comments

## REPT Function in Excel

REPT Function in Excel - formula returns a repeated text value a specified number of times. Learn Formulas, Excel and VBA examples in our free tutorials.

By |April 11th, 2013|Excel Formulas|0 Comments

## VALUE Function in Excel

VALUE Function in Excel - formula helps to convert a number in a text format into a number format. Learn Formulas, Excel and VBA examples free tutorials.

By |April 11th, 2013|Excel Formulas|0 Comments

## TYPE Function in Excel

TYPE Function in Excel - formula returns information (integer) about the data type of a supplied value. Learn more Formulas, Excel and VBA with examples.

By |April 10th, 2013|Excel Formulas|0 Comments

## Creating Dashboards in Excel – Dashboard Creation Using Sales Data

This is a simple dashboard, I have used a dummy store data for illustration purpose. Read more and learn to build a simple sales performance dashboard. Example dashboard is attched in the post, you can download and have a look into the file. In this dasboard: