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
EXCEL TUTORIALS – ALL EXAMPLES
Tutorial #01
How to split first and last names in Excel 2013
Download Excel
No comments:
Post a Comment
Newer Post
Older Post
Home
Subscribe to:
Post Comments (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 Freeze Panes in Excel 2013
Freeze Panes is an excellent tool in Excel 2013 for viewing different parts of the same worksheet that normally cannot be seen together. G...
How to create a histogram in Excel 2013
A histogram is an excellent tool used in project management and many other disciplines to analyze a collection of data. A histogram is a...
Show Developer Tab in the toolbar in Excel 2013
How do I get the DEVELOPER tab to display in the Ribbon in Excel 2013? Well, that's very easy!! The DEVELOPER tab is the toolbar tha...
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 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...
E-BOOK AND DVD
COMING SOON....WAIT FOR THIS PAGE
Two-way lookup in Excel 2013 using INDEX and MATCH
Two-way lookup gives value of the intersection of desired row and column values in a table containing data. For example, suppose we h...
How to create list of business days in Excel 2013
The easiest way to generate a list of business days is using following functions: 1. WORKDAY 2. WORKDAY.INTL Generating list of busi...
How to highlight Duplicates in Excel 2013
Is there an easy way to locate and highlight duplicates in a list in Excel? Yes, Excel has many powerful tools to locate and highlight d...
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...
Blog Archive
▼
2014
(27)
►
October
(6)
▼
September
(11)
How to transpose rows and columns in Excel 2013
EXCEL TUTORIALS – ALL EXAMPLES
How to split first and last names in Excel 2013
Two-way lookup in Excel 2013 using INDEX and MATCH
How to insert current date and time in a cell in E...
How to change name in cell comments in Excel 2013
How to center headings without merging cells in Ex...
How to password protect workbook in Excel 2013
How to sort by color in excel 2013
How to compare two lists of data in Excel 2013
How to use RANK function in Excel 2013
►
April
(5)
►
February
(5)
►
2013
(25)
►
December
(8)
►
November
(17)
No comments:
Post a Comment