Excel Magic Trick #14- Amazing Find & Go To Trick!

Sign Up | Log In | Help | Blog

My Videos

Excel Magic Trick #14- Amazing Find & Go To Trick!

Related Links

Share this TVLesson with Others:

Send Message // Flag This Video // Feature This! // Inappropriate // Add to Favorites

Average (

Votes)

Not yet rated

Please sign up
and login to rate this video.

Comments

Add your comment in the box:

Please keep your comments relevant and respect other users.

More Lessons From the User

YouTubersLoveExcel#24- Add Time by Hour, Minute or Day (02:56)

YouTubersLoveExcel#25- Dynamic Range for Pivot Table & Chart (07:13)

YouTubersLoveExcel#26- Text To Column Trouble (03:37)

YouTubersLoveExcel#22- EOM Terms with IF, DAY & EOMONTH fun (05:08)

YouTubersLoveExcel#23- Add Time with Formula or Format (05:48)

YouTubersLoveExcel#21- Solver for Linear Algebra (10:13)

YouTubersLoveExcel#20- Variable Growth Cash Flow Formula (05:30)

YouTubersLoveExcel#19- Steady Growth Cash Flow Formula (03:44)

YouTubersLoveExcel#18- Logical Formula to Verify Patterns (05:25)

YouTubersLoveExcel#17- Hide Bank Rec Formula (10:31)

YouTubersLoveExcel#16- Percent Number Formatting Tricks (04:25)

YouTubersLoveExcel#14- NOT function for logic formulas (03:46)

YouTubersLoveExcel#13- Date Math and IF function (06:05)

YouTubersLoveExcel#15- Mixed Number formulas and Format (01:42)

YouTubers Love Excel 2007 #4- Count Unique Records (04:28)

YouTubersLoveExcel#9- Extract Records with complex criteria (08:18)

YouTubers Love Excel 2007 #2 Dynamic Data Validation w Table (05:31)

You Tubers Love Excel#11- Pivot Table, SUMPRODUCT & SUMIF (08:04)

YouTubers Love Excel 12- Pivot Table AVERAGEIF SUMIF-COUNTIF (08:12)

You Tubers Love Excel#10- Dynamic Chart by Range of values (05:47)

You Tubers Love Excel#7- Name Ranges to use in functions (02:00)

You Tubers Love Excel#6- VLOOKUP and Custom Data Validation (07:14)

You Tubers Love Excel#8- Extract Data using Functions (04:48)

You Tubers Love Excel #1- Dynamic Data Validation & OFFSET (10:08)

You Tubers Love Excel#5- IF formula too long use- VLOOKUP (10:28)

You Tubers Love Excel 2007#3- SUM across sheets (03:58)

The Beauty Of Excel #1- Formulas & Functions (09:58)

The Beauty Of Excel #2- Formulas, Functions & Charts (09:57)

Microsoft Excel - Adding an in-cell dropdown menu (05:47)

Excel Basics- How To Create a Chart (00:00)

Excel Basics- Using Labels in Formulas (02:21)

How To Insert a Picture In Excel (01:36)

How to Create a Chart with One Keystroke using Excel (04:54)

Excel Magic Tricks # 1- Formulas & Cell References (04:43)

How to Enter Formulas in Excel (03:25)

Excel Magic Trick # 9- Join 2 Cells into 1 (02:49)

Excel Magic Trick # 3- AVERAGE & Go To Blanks (03:24)

Excel Magic Trick # 10- 3 types of Averages! (04:01)

Excel Magic Trick #87- Budgets and Scenarios (08:19)

Excel Magic Trick #85- Formulas for Text and Labels (08:19)

Excel Magic Trick # 2- Chart Keyboard Trick (02:52)

Excel Magic Trick #83- Extract Sample Data Advanced Filter (06:11)

Excel Magic Trick #81- Advanced Filter AND OR Data Extract (05:05)

Excel Magic Trick #79- MOD ROW functions Conditional Format (05:46)

Excel Magic Trick #80- VLOOKUP & Concatenation (03:28)

Excel Magic Trick #78- OFFSET function (07:52)

Excel Magic Trick #77- COUNT Vs. COUNTA function (02:12)

Excel Magic Trick #76- Alternative To Merge & Center (02:13)

Excel Magic Trick #75- EOMONTH function (08:10)

Excel Magic Trick #74- Custom Number Formatting (10:17)

Excel Magic Trick #73- Excel Limit is 15 significant digits (04:31)

Excel Magic Trick #72- Excel Formulas do not see formatting (03:52)

Excel Magic Trick #71- Excel Will Talk To You (03:27)

Excel Magic Trick #69- Assumption Tables and ROUND function (04:09)

Excel Magic Trick #68- How To Setup Complicated Formula (08:41)

Excel Magic Trick #67- ONLY logical Construct AND NOT & OR (03:57)

Excel Magic Trick #66- NONE logical construct with NOT & OR (03:18)

Excel Magic Trick #65- AND OR functions for Customer Credit (06:09)

Excel Magic Trick #66- NONE logical construct with NOT & OR (03:18)

Tutorial Information:

This video teaches you how to find and go quickly.

User Name	Excel@Life
Total Shared	lessons
Added On	2008-06-03
Duration	03:06
Comments	0

Tag

Microsoft Office Excel Techniques Find Go

Share Lesson

<embed src="http://www.tvlesson.com/mediaplayer.swf" width="425" height="350" type="application/x-shockwave-flash" allowfullscreen="true"  flashvars="height=350&width=425&file=http://www.tvlesson.com/flvideo/6459.flv&image=http://www.tvlesson.com/thumb/1_6459.jpg&location=http://www.tvlesson.com/mediaplayer.swf&frontcolor=0xffffff&backcolor=0x000000&lightcolor=0xFF0000&screencolor=0xffffff&autostart=false&volume=80&overstretch=fit&link=http://www.tvlesson.com/vvideo.php?vvid=6459&linkfromdisplay=true"></embed>

Related Video's 12 of 12

Excel Magic Trick #14- Amazing Find & Go To Trick!
Uploaded By: Excel@Life

Excel Magic Trick #17- Randomly Generate Whole Numbers
Uploaded By: Excel@Life

Excel Magic Trick #18- Randomly Generate Letters
Uploaded By: Excel@Life

Excel Magic Trick #19- Randomly Generate Words
Uploaded By: Excel@Life

Excel Magic Trick #20- Lightening Fast Copy Trick!
Uploaded By: Excel@Life

Excel Magic Trick #22- NORMDIST function for Probability
Uploaded By: Excel@Life

Excel Magic Trick #21- BINOMDIST function for Probability
Uploaded By: Excel@Life

Excel Magic Trick #23- Format & Functions Highlighting Range
Uploaded By: Excel@Life

Excel Magic Trick #25- Trouble With Numbers Entered As Text
Uploaded By: Excel@Life

Excel Magic Trick #24- 3-D Cell Ranges! Add across sheets!
Uploaded By: Excel@Life

Excel Magic Trick #26- Subtotals & Visible Cells Only Trick!
Uploaded By: Excel@Life

Excel Magic Trick #28- Conditional Probability & HYPGEOMDIST
Uploaded By: Excel@Life