How To Reverse Search in Excel
This tutorial explains how to reverse search in Excel. 2 methods explained to do reverse string search to search for a word from end of string.
→Tagged: excel
How To Do Reverse vLookup In Excel
This tutorial explains how to do reverse lookup in Excel. There is an Excel add-in that reverses the lookup process offered by VLOOKUP function.
→
How to Change Case of Text in Excel
This tutorial explains various methods to change the case of text in MS Excel by using free Add-ins, Macros, and Excel formulas.
→
Convert Word to Excel Online Free with these 3 Websites
Here are some websites to convert doc to xls online. These websites are able to convert text, tables, and images of original Word file to Excel file.
→
How To Change Shape of Comment Box In Excel
This tutorial explains how to change shape of comment box in Excel. I have covered a simple trick to change shape of comment box with any Basic Shapes.
→
Free Excel Add-In To Get Tons of Financial and Economic Data
Quandl is a free Excel add-in to get tons of financial and economic data from database of Quandl directly from Excel. You can search and download the data.
→
Excel Add-In To Create Gantt, Waterfall, Mirror Charts, Etc.
PlusX is a free Excel add-in that helps to create Gantt, waterfall, mirror, double donut, etc., using the data available in the active Excel sheet.
→
Favorite Bookmarks Add-In For Microsoft Excel To Save Time
Favorite Bookmarks Add-In For Microsoft Excel is a very simple and easy to use bookmarking tool which lets you add bookmarks to your favorite excel files.
→
Excel Add-In to Change Values of Cells Using Any Number
Range Calculations is an Excel add-in to recalculate the values of multiple cells automatically. You can use a number to add, subtract or divide the values.
→
Excel Add-In To Create Radial Bar Chart for Table Data
Here is a free Excel add-in to create radial bar chart for table data. You can also select columns and a color theme to generate the chart.
→
How To Export Your Trello Boards To Excel
This tutorial explains how to export Trello boards to Excel. A Chrome extension, Export for Trello, lets you backup public or private boards as XLXS files.
→
How To Quickly Access Font, Borders, Insert Options in Excel
Ablebits.com Smart Toolbar for Microsoft Excel is a very handy plugin to quickly access font, borders, alignment, insert, and other options in Excel.
→
Learn Spreadsheet Formulas, SQL Queries with DataMonkey
Datamonkey is a free website that helps to learn spreadsheet formulas and SQL queries. It provides interactive examples for better understanding.
→
SolverStudio: Free Add-in to Create Optimization Models in Excel
SolverStudio is a free add-in for Excel where you can create and solve optimization models from within Excel using various differen modeling languages.
→