Mr Excel & excelisfun Trick 76: Worksheet With Hyperlinks That Jump To Each Sheet In The Workbook

About this tutorial: Video duration: 7:46 Download Files: See Mr Excel and excelisfun create Dynamic Range For VLOOKUP and Data Validation using the OFFSET and INDEX functions.

Excel Magic Trick 336: Incrementing Numbers In Formulas

About this tutorial: Video duration: 12:45 Download Excel Start File: Download Excel Finished File: Full Page With All File Links: Learn about the ROWS, COLUMNS, MOD, ROUND, and WEEKDAY functions :to: 1)Increment from small to big 2)Increment from big to small 3)Increment a difference (Arithmetic Sequence) 4)Increment a ratio (Geometric Sequence) 5)Repeating Sequences 6)Use WEEKDAY […]

Excel Magic Trick 390: Increment Word & Number 2 Methods.

About this tutorial: Video duration: 3:26 Download Files: See how to do create a column of words and numbers quickly with two different formulas and a mouse trick for Paste Special Values. See how to increment a word and a number.

Excel Magic Trick 474: Conditional Format At Every Change In Value

About this tutorial: Video duration: 1:52 Download Files: See how to Conditional Format At Every Change In Value. Steps 1Highlight range A1:A2152 2Alt + O + D (opens) Conditional Formatting 3Click New Rule 4Click “Use Formula” 5Enter formula: A1not A2 6Format 7Click OK

Excel Magic Trick 369: Compare 2 Lists, Extract Records Not Listed Twice

About this tutorial: Video duration: 10:7 Download Files: See array formula that will extract records that are not listed twice. See the functions: ISNA, MATCH, SUMPRODUCT, IF, ROWS, SMALL, ROW.

Excel Magic Trick 540: Extract New Records Not In Old List – Array Formula Method

About this tutorial: Video duration: 8:33 Download Files: See how to check two 2 lists of records and extract only the new records (records that are in new list but not in old list) with array formulas that use SUMPRODUCT, ISNA, MATCH, IF, ROWS, SMALL, INDEX, ROW functions function. Compare Two 2 Lists

Excel Magic Trick 368: Count Unique Items With More Than One Criteria

About this tutorial: Video duration: 14:2 Download Files: Amazing use of the FREQUENCY and MATCH functions! Array formula for counting unique items in a column with criteria in a second column. See 1 formula for counting numbers and 1 for counting words. Formulas use the functions: SUM, IF FREQUENCY, MATCH, ROW, and ISNUMBER in an […]

Excel Magic Trick 316: Concatenate Selection w Criteria (MoreFunc Excel Add-in functions)

About this tutorial: Video duration: 6:19 Download Excel Start File: Full Page With All File Links: With Formulas: see how to Count Unique Values, List Unique Value, Concatenate range of values with separator. See the MoreFun Add-in functions COUNTDIFF, UNIQUEVALUES, MCONCAT. Related videos: Excel Magic Trick 276 MoreFunc Excel add-in 66 New functions Excel Magic […]

Excel Magic Trick 370: Conditional Formatting Odd & Even Numbers

About this tutorial: Video duration: 4:34 Files: See how to Conditional Format Even and Odd numbers using a TRUE / FALSE formula with the MOD function.

Excel Magic Trick 558: VLOOKUP to verify if Whole Record is in Table

About this tutorial: Video duration: 6:56 Download Files: See how to check if a record is in a table using VLOOKUP. See how to do this for a 2 column (field) table and a 4 column (field) table. See how to add a concatenated column and concatenate lookup_value in VLOOKUP function. Match. Is record in […]

Excel Magic Trick 418: Reference Every Third Value

About this tutorial: Video duration: 2:32 Download Files: See how to use the INDEX and ROWS function to list every third value from a column of values.

Excel Magic Trick 477: 13 Digit Number ID Shows Scientific Notation!?

About this tutorial: Video duration: 1:44 Download Files: See how to prevent Excel from displaying a 13 Digit Number ID in Scientific Notation using Number Number formatting with no decimals showing. Number Formatting in Excel

Excel Magic Trick 393: Remove Last Two Words From Column Of Data

About this tutorial: Video duration: 11:6 Download Files: See how to remove last two words for column of data using LEN, SUBSTITUTE, FIND, REPT, RIGHT and TRIM functions. Amazing formulas from Mr Excel Message Board.

Excel Finance Class 69: Net Present Value Profile — Build Table and Chart in Excel NPV Function

About this tutorial: Video duration: 18:41 Download Excel File: Download PowerPoints: Learn how to create a Net Present Value Profile table and chart in Excel. See the cross over point where Internal Rate Of Return IRR is. See an area chart for NPV profile and see a line chart for NPV Profile.

Mr Excel & excelisfun Trick 33: First Monday For Reporting Period

About this tutorial: Video duration: 7:44 Download Files: See Mr Excel and excelisfun show three formulas for finding first Monday of reporting period: If 1st day of month is Monday, then that day, otherwise the last Monday of the previous month. See the functions EOMONTH, WEEKDAY, DATE, MONTH, IF and DAY

Excel Basics #17: Page Setup

About this tutorial: Video duration: 6:59 Download file: The Excel Basics Series shows a systematic description of what Excel can do from beginning to end. #17 Video topics: 1)Fix Column Widths 2)Print Preview (Ctrl + F2) 3)Page Setup (2007: Alt + P + S + P; 2003; Alt + F + U) 4)Print Larger 5)Margins […]

Office 2010 Class #01: Windows Explorer and Introduction To Office 2010

About this tutorial: Video duration: 21:58 Windows Explorer Files: Learn about Using Windows Explorer to manage files and get an introduction to Office 2010. Learn about: 1) Windows Explorer 2) Create Folders 3) Name files 4) Excel and Word 5) File Extensions 6) Save As and Save 7) Task Bar 8) Ribbon 9) Quick Access […]

Excel Tricks : Easy Technique To Replace Vlookup With Index and Match Functions || dptutorials

About this tutorial: Video duration: 4:2 Are you still using Vlookup? This Microsoft Excel tutorial will teach you how to use the INDEX and MATCH functions, which can provide a better solution. For Personalized detail learning, write to dptutorials15@gmail.com If you found this video valuable, give it a like. If you know someone who needs […]

Excel Magic Trick 460: Transpose Range with INDEX, COLUMNS and ROWS functions

About this tutorial: Video duration: 3:11 See how to transpose a range (switch rows and columns) using INDEX, COLUMNS and ROWS function. If you dont want to use TRANSPOSE function, this is a good substitute.

Excel Magic Trick 852: Conditional Standard Deviation: STDEV.S & IF or DSTDEV functions?

About this tutorial: Video duration: 4:43 Download file: Learn how to: 1. Calculate Standard Deviation with One Condition for many categories using STDEV.S & IF or DSTDEV functions 2. Calculate Standard Deviation with One Condition for one categories using DSTDEV function 3. Standard Deviation IF Incoming search terms:STDEV S conditional