Excel VBA: Different Types Of Excel Macros

Excel support services will receive scores of different questions each and every day. The range of the questions definitely covers a lot of ground. Among the most common of questions asked is “What are the different types of Excel Macros?” This is a helpful question to ask because if you do not know the different […]

Read More

Excel Function: MATCH() Explained

Excel MATCH function examples allow us to see how the MATCH function can be used, and understand what scenarios it could help us. Basically, the MATCH function was designed to return a relative row reference (relative to the array in which data is searched for) for data that you specify. If searching for a number, […]

Read More

How to Automate MS Excel Using Visual Studio.NET

Introduction I have written this article to address requests I have been getting through e-mail on how to automate MS Excel. Most people who are looking at this article might also be interested at the following articles for automating MS Word documents. Here is the link for Automating MS Word using C#, and here is […]

Read More

Excel Formula Vs Function : What is the difference?

Once question I get asked about a LOT it when it comes to Excel is just what is the difference between a Function and a Formula? In this article I will discuss the differences and work through some examples. A Formula in Excel can be described as a statement that is written by a spreadsheet […]

Read More

How to Flag Multiple Matches In Your VLOOKUP Formula?

This article will explore the Excel VLOOKUP Formula and show you how to combine it with an IF statement to flag if there are multiple lookup values matches in your data set. VLOOKUP is really great for pulling in data from a larger table in Excel, but sometimes in a larger data sets there may […]

Read More

Excel Formula : SUMPRODUCT () for Advanced Users

When I first learned about the SUMPRODUCT  formula  in  Excel , I almost dismissed it as a useless  formula  used by only few users. How often would anyone need to multiply 2 or more groups of numbers together and add up the results!? To get to the story, we know that formula is keyed in as: […]

Read More

Excel VBA Tutorial : Workbook Events and Procedures

Today we will learn about Workbook Events and Procedures Workbook Activate Event This event will run code whenever this specific workbook is activated. Workbook AddinInstall Event This event will run when the specific workbook is installed as Add-In in Excel. Workbook AddinUninstall Event This event will run when this workbook is uninstalled from Excel’s Add-Ins. […]

Read More

Excel Formula : SEARCH() vs FIND()

There are two very similar functions in Excel to look for data inside of cells matching parameters that you dictate: SEARCH and FIND. There are so similar, in fact, that one wonders why have two separate functions that perform virtually the identical results and are identical in the construct of the formula. This article will […]

Read More

How to Connect “External Data” source to “Import” data into Excel

The main benefit of connecting to external data from Microsoft Excel is that you can periodically analyze this data in Excel without repeatedly copying the data, which is an operation that can be time-consuming and error-prone. After connecting to external data, you can also automatically refresh (or update) your Excel workbooks from the original data source whenever the data source is updated with new information.

Read More