Excel-magic-tricks-series

excel-magic-tricks-series




Excel Magic Trick 1480: VLOOKUP & MATCH Two-Way Lookup Quantity & Product to Get Price

Download Files: Start Excel File: https://people.highline.edu/mgirvin/YouTubeExcelIsFun/EMT1479-1481.xlsx Entire page with all Excel Files for All Videos: ...
Read more




Excel Magic Tricks # 1: Formulas & Cell References

Download Excel workbook: http://people.highline.edu/mgirvin/excelisfun.htm See Excel Magic! See how to build your spreadsheet smartly, so it updates ...
Read more




Excel में Hard Work नहीं Smart Work करो | Excel Magic Tricks Part 8

Doston is video me maine apko bataya hai kis tarah aap #excel ki 3 Magic Tricks ka use karke apne office work ko kafi aasan bana sakte hai. Is video me aap ...
Read more




Excel Magic Trick 787: Conditional Formatting Basic To Advanced (30 Examples)

Download file: https://people.highline.edu/mgirvin/ExcelIsFun.htm 1. Above Average for Sales (1:24 minute mark) 2. Below Average for Sales ( 3:18 minute mark) ...
Read more




Excel Magic Trick #184: Setup Database in Excel

See how to create a simple database in Excel using the List or Table feature. A simple database can be created in Excel using the Excel 2003 "List" feature or ...
Read more




Excel Magic Trick #174: Smartest Excel People In The World

See an incredible Excel Trick From Aladin at the Mr Excel Message Board. See how to lookup up the last value in an unsorted list. Learn about the LOOKUP ...
Read more




Remove Duplicate Automatic in Excel || Excel Magic Tricks || Magic in Excel

In This Video You will learn excel Magic Tricks - Using Excel Code How to Remove Duplicate Automatically? Happy Independence Day to All my Viewers ...
Read more




Top 25 Excel 2016 Tips and Tricks

The Top 25 tips and tricks for Excel 2016. Use these tips and tricks to improve your efficiency using Excel. I am sure you will discover some that you have not ...
Read more




Excel Magic Trick 848: Create List of Dates For Month With Formula

Download file: https://people.highline.edu/mgirvin/ExcelIsFun.htm Learn how to: 1. Given the month as text and the year as a number, see how to get the first of ...
Read more




Excel Magic Trick 783: Date Functions & Formulas (17 Examples)

Download file: https://people.highline.edu/mgirvin/ExcelIsFun.htm 1. DAY function 2. TEXT Function to get Day spelled out, like "Monday" 3. TEXT Function to get ...
Read more




Excel Magic Trick 778: INDEX & MATCH Lookup Functions Beginning To Advanced (18 Examples)

Download file: https://people.highline.edu/mgirvin/YouTubeExcelIsFun/EMT778.xlsx There are really about 30 example in this long video. INDEX and MATCH ...
Read more




Excel Magic Trick 913: Select From Drop Down and Pull Data From Different Sheet

Download workbook: http://people.highline.edu/mgirvin/ExcelIsFun.htm See how to: 1. Select From Drop Down and Pull Data From Different Sheets using Data ...
Read more




Excel Magic Trick 1107: VLOOKUP To Different Sheet: Sheet Reference, Defined Name, Table Formula?

Download Excel File: http://people.highline.edu/mgirvin/ExcelIsFun.htm See how to do a VLOOKUP to a different Sheet using: 1. Sheet References 2. Defined ...
Read more




Excel Magic Tricks जो आपके ऑफिस वर्क को आसान बनाए | Excel Magic Tricks Part 7

Doston is video me maine bataya hai kis tarah aap #excel ki magic tricks ka use karke apne office work ko aasan bana sakte hai. Is video me maine bataya hai ...
Read more




Excel Magic Trick 167p1 IF function formula: 12 Examples!

Part 1. See 12 different examples of how to use the IF function. This video starts with IF function basics and then shows 12 different examples of how the IF ...
Read more




Excel Magic Trick 520: FIND & SEARCH Functions

Learn about FIND and SEARCH functions: 1.Both functions find the position of a substring in a string the position of some characters within a different set of ...
Read more




Excel Magic Trick # 267: Percentage Change Formula & Chart

Download file in "Excel Magic Trick" section: https://people.highline.edu/mgirvin/excelisfun.htm Learn about the universal formula for Percentage Change: (End ...
Read more




Excel Magic Trick #141 part 2: Series of Dates

See how to generate a series of dates with the TODAY and ROW function that will always show today plus the next 10 days.
Read more




Mysteries of VLOOKUP Function Revealed! 15 Amazing Examples! (Excel Magic Trick 1514)

Need to learn all about VLOOKUP? Microsoft Excel MVP & Highline College Professor, Mike “excelisfun” Girvin, presents 15 amazing VLOOKUP examples, from ...
Read more




Excel Magic Trick 1349: Power Query with Input Variables from Excel Sheet to Extract Records

Download File: http://people.highline.edu/mgirvin/excelisfun.htm See how to use Power Query (Get & Transform) with Input Variables from Excel Sheet to Extract ...
Read more




Excel Magic Trick #246: Waterfall Profit Chart (Create an Excel Waterfall Chart)

See how to create a Waterfall Profit Chart using a Stacked Column Chart, some formulas to create a second data set, and adding No Fill as a color to the second ...
Read more




Excel Magic Trick 1013: MIN IF, MAX IF, MINIF, MAXIF (6 Examples) MAX MIN calculation w 1 criteria

Download Excel File: http://people.highline.edu/mgirvin/ExcelIsFun.htm See how to calculation MIN and MAX calculations with one condition. See how to ...
Read more




Excel Magic Trick 934: HYPERLINK Function and Hyperlink Feature (13 Examples)

Download workbook: http://people.highline.edu/mgirvin/ExcelIsFun.htm See how to use: 1) Hyperlink Feature to open a web address or file (Ctrl + K) 2) ...
Read more




Excel Magic Trick #13: SUM or COUNT only certain items! SUMIF COUNTIF functions

Download Excel workbook: http://people.highline.edu/mgirvin/excelisfun.htm See how to use the SUMIF and COUNTIF functions to add and count given a ...
Read more




Excel Magic Trick 1350: Formulas in PivotTables For Gross Profit & Percentage of Gross Profit

Download File: http://people.highline.edu/mgirvin/excelisfun.htm Learn how to create formulas to make calculations in a Standard PivotTable. See how to Create ...
Read more




Excel Magic Trick 493: Repeat a List of Names 7 times

See how to use 1) Copy, Paste and Sort and 2) an INDEX formula using MOD and ROWS functions to repeat list of names 7 times. See how to increment ...
Read more




Excel Magic Trick 967: Formula To Extract Top 5 Numbers & Names, Including Ties or Duplicates

Download Excel File: http://people.highline.edu/mgirvin/ExcelIsFun.htm Concepts: 1. This video is great to learn how to use a formula to extract top 5 numbers ...
Read more




Excel Magic Trick 496: Attendance Sheet with Freeze Pane, IF & SUM functions, Custom Date Formatting

See how to create a basic Attendance Sheet for a classroom in Excel. See THESE TRICKS: 1)See how to Freeze Panes for Large Spreadsheet 2)Ctrl + 1 to ...
Read more




18 Excel Tips and Tricks, Excel Secrets you don't know

Really awesome 18 Excel Tips and Tricks, Excel Secrets you don't know click here for part 2 video of 18 Excel Tips and Tricks, Excel Secrets you don't know ...
Read more