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 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 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 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 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 use Scenario Manager in Excel 2013
Scenarios form an important part in real-world problems. The inputs used in the real-world problems are dynamic and hence lead to differen...
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 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...
Top 7 new features in Excel 2013 that every Professional must know
Flash Fill feature "Flash Fill" is the magical feature introduced in Excel 2013 Flash Fill detects a pattern in your initi...
How to highlight alternate rows in Excel 2013
Highlighting alternate rows in Excel 2013 worksheet makes the data visually much more appealing. Instead of doing this manually, w...
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...
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