If you have Adobe Acrobat Pro installed, then you can create an Excel App to Fill Out PDF Forms automatically, directly from Excel.

LEN function: basic text function, widely used. Advanced examples: Count Items from a range based on text length. Return the smallest text in range.

SUBSTITUTE function can be very useful combined with other functions, to get your desired results. Applications examples: Substitute last occurrence only, Extract partial string after last delimiter, Extract item from delimited text, based on item position.

Excel Functions are built into Excel and their functionality and arguments cannot be modified by users. An Excel Formula is designed by the user and it can contain multiple Excel Functions, Defined Names, Constants, Range references.

Pivot Table fails to refresh, because the Data Source reference is not relative anymore, it contains the file name too. If you receive the message: Can’t open Pivot Table Source file, the workbook will not work anymore as expected.

In Excel, you have the option to assign a Name to a cell, or to a Range of cells. This name is reffered to as a Defined Name.

Selecting Excel Table Components is slightly different from selecting normal ranges in a worksheet, because we have 3 major Excel Table Components, which are special ranges: the Headers Row, the Data Body Range, the Totals Row.

The Order of Precedence used by Excel to calculate formulas is extremely important to know when building complex formulas.

Of course, Excel will respect all mathematical rules you learned in school, there are only a few more Operators in Excel: the Range Operators, single Space Operator, Union Operator, the Concatenation Operator and the Exponentiation Operator.

An Excel Defined Table is a special object in Excel which adds a lot of new options and functionalities when working with data ranges. Whith Defined Tables, you can manipulate data more easily than before, adding power and flexibility to your applications.
To create a Defined Table, select the data range, or simply select any cell within the data range, and click the Table button from the Insert tab from Ribbon. The shortcut key is Ctrl+T to create a Defined Table.

There are 3 Reference Operators in Excel: “:” (colon) is the Range Operator, “,” (comma) is the Union Operator, ” ” (space) is the Intersection Operator.

When you try to edit a conditional formatting formula, and you click the left or right arrows to move across formula’s text, Excel inserts unwanted cell references. Same thing happends when you try to edit a defined name formula, or a chart series…

If you’re looking for a Client Relationship Management tool, and you don’t want to spend thousands on a CRM solution, then try this free Excel CRM.

Adding a hyperlink to a specific worksheet or cell is an easy thing to do. But what if you need the hyperlink to be dynamic, no matter if you insert or delete sheets, change the order of sheets, and you want the hyperlink to “know” which is the next or previous sheet, without manually adjusting all hyperlinks?

This article describes a solution for creating mass letters from Excel, using a Word Document as the Letter template and a Map between Excel Defined Names and Word Document Bookmarks.

In this article, you will find code for adding new controls to excel userfom, for adding items to comboboxes and to add values from a range of cells to a combobox list.

Excel does not provide a function for linear interpolations. If your data table has a high granularity, and you need precise results, you have to create your own linear interpolation formula. You will find in this article an excel formula, and a User Defined Function for Linear Interpolation.

This Excel Table Tennis ScoreBoard is dedicated to all Table Tennis fans 🙂 , hope they will find this Excel Table Tennis ScoreBoard useful.

An important feature of tables, the autoexpanding functionality, is lost when the worksheet is protected. When you type anything under the last row, the table will not expand to include the new row, the decision to protect the sheet is not easy when you need both protection and autoexpanding features enabled.

If your workbook contains macros designed to assist users in typing data, or you have UDF – User Defined Functions for specific calculations, then if users are not enabling macros when opening the file, your codes are useless…

Excel User Forms are a great way to collect data in a specific structure. Unfortunately, there is a major limitation that you have to take into consideration when choosing between a worksheet form or a userform: there is no built-in data validation for text boxes, or comboboxes… (you can only limit the number of characters, which might not be what you wanted)