FUNDOO EXCEL
EVERYTHING YOU WANT TO KNOW ABOUT EXCEL.....
HOME
TUTORIALS
VIDEOS
E-BOOKS
DVD
BOOKS
DOWNLOADS
ABOUT ME
skip to main
|
skip to sidebar
Showing posts with label
Excel VBA Books
.
Show all posts
Showing posts with label
Excel VBA Books
.
Show all posts
RECOMMENDED BOOKS
Excel 2013 Bible
Microsoft Excel 2013
Excel 2013 Dummies
Excel 2013 Formulas
Microsoft Excel 2013
Office 2013 Library
Excel 2010 Dummies
Excel 2013 VBA
Financial Analysis
Excel Pivot Tables
Excel VBA Dummies
Older Posts
Home
Subscribe to:
Posts (Atom)
Subscribe Via E-mail
Enter your email address:
Labels
Excel 2013
Data Analysis
lookup functions
Data Table
Sensitivity analysis
What-if Analysis
Goal Seek
INDEX function
MATCH function
VLOOKUP
CHOOSE
Formula Auditing
Trace Dependents
Trace Precedents
Popular Posts
How to create a Two-Variable Data Table in Excel 2013
Two-variable data table is an excellent tool in excel to perform sensitivity analysis with two ranges of possible input values. It help...
How to use Goal Seek feature in Excel 2013
Goal Seek feature is an excellent tool in excel to obtain an input value for the desired output value for a given relationship between v...
How to create a One-Variable Data Table in Excel 2013
One-variable data table is an excellent tool in excel to perform what-if analysis. It helps in getting output for series of input values f...
How to find and delete all merged cells in Excel 2013 worksheet
Random occurrences of merged cells is a sign of poorly formatted excel sheet. Merged cells are fine when we want to make excel sheet look ...
How to sort horizontally (by row) in Excel 2013
Generally, we sort the data in Excel by values in one or more columns i.e. using top to bottom values in particular column. Howeve...
How to create waterfall chart in Excel 2013
Waterfall chart (or Bridge chart) is great tool to analyze how an initial value is affected by series of intermediate positive or negative...
How to combine or join text cells in Excel 2013
Excel provides great tools to combine or join text/data from multiple cells into one cell. There are primarily two ways in which we can jo...
How to center headings without merging cells in Excel 2013
Merged cells are annoying at times and create many problems while using various functions. The best practice suggests that merged cells s...
How to create a Scenario Summary Report in Excel 2013
After using Scenario Manager to add scenarios to a table in a worksheet, we can generate a summary report to visualize all the scenarios a...
How to split first and last names in Excel 2013
Download Excel File Conventionally, the "convert text to columns" wizard was generally used to split first name and la...
Blog Archive
▼
2014
(27)
▼
October
(6)
How to sort horizontally (by row) in Excel 2013
How to highlight alternate rows in Excel 2013
How to create waterfall chart in Excel 2013
How to find and highlight cells with formula in Ex...
Top 7 new features in Excel 2013 that every Profes...
How to create a histogram in Excel 2013
►
September
(11)
►
April
(5)
►
February
(5)
►
2013
(25)
►
December
(8)
►
November
(17)