Home
Search results “Excel cross product”
Excel Vector Calculator
 
05:53
Views: 11769 ME Tutorials
Join or Merge Two Tables in Excel Using Microsoft Query - Easy!
 
04:47
Learn the basics of joining two tables together! It's actually pretty easy and thus, fun! Try it out! **Limited Offer** Learn to Make Excel Do Your Work For You with The Ultimate Excel Programmer Course – Get the Full 9+ Hour Premium Course for 75% off using coupon code: https://www.udemy.com/ultimate-excel-programmer/?couponCode=2016YOUTUBE75 Click Now to Order and get Lifetime Access to Course, Workbooks, Updates and Support! ------------------------ Create Your Own Barcode Lookup System Using Excel VBA. Learn to Make Your Own Barcode Labels the Easy way and have fun with Barcode Scanners to Automate your Workflow! In this project-driven Course, you’ll learn to Build your own Custom Inventory System with Step-By-Step video instructions. This goes in depth into some advanced Userform strategies that you can use for your other projects to come. A great weekend study! YouTube Subscibers only pay one forth! Get your 75% off Coupon here: https://www.udemy.com/barcodes-excelvba/?couponCode=2016YOUTUBE75 ------------------------ Too busy to Learn Piano? Use my Secrets and Play Your Favorite Songs Today! Did you know; You can learn 4 basic chords in about 5 minutes and instantly be able to play millions of songs. Seriously, check this course out. 75% off for my YouTube Friends! Click here: https://www.udemy.com/play-piano-by-ear-today-supercourse/?couponCode=2016YOUTUBE75 For Articles, Updates and to Contact me for Consulting or just to drop me a line, please visit http://www.ExcelVbaIsFun.com Here is my link to download my FREE workbooks, past present and future: https://www.dropbox.com/sh/nwc5trm2xwlvvbh/XpGTrmKVyQ ------------------------ Playlists: Excel Vba Basics http://www.youtube.com/watch?v=AIhKNNXzZLM&list=PLw8O1w0Hv2ztGjIkrW7suD6oNDaOk3vbR&index=1 Tips N Tricks https://www.youtube.com/playlist?list=PLw8O1w0Hv2zsPU-k2vPZ_6brD5Gk1sVy_ Userforms https://www.youtube.com/playlist?list=PLw8O1w0Hv2zvnLFyiMrihcaOqA0sT0X2U Sample Excel Programs https://www.youtube.com/playlist?list=PLw8O1w0Hv2zuP-BE7tV1UjWa0ZexZqY89 Events Series https://www.youtube.com/playlist?list=PLw8O1w0Hv2zvf-YaBApsIHloI9G6Cq1Wh Activex Controls https://www.youtube.com/playlist?list=PLw8O1w0Hv2zupzNIWkZCOYYngTtMH5nSf ------------------------ Grab an Excel Nerd T-Shirt or Hoodie: http://ExcelVbaIsFun.spreadshirt.com/ ------------------------ Interact and Follow me on: LinkedIn: http://www.linkedin.com/in/danielcstrong Facebook: https://www.facebook.com/Excelvbaisfun/ Twitter: https://twitter.com/ExcelVbaIsFun Google Plus+: http://www.google.com/+ExcelVbaIsFun 'Royalty Free Music by http://audiomicro.com/royalty-free-music'
Views: 173044 ExcelVbaIsFun
Cross Joins in Power Query: Measuring Student Progress
 
08:55
In this video we're measuring student progress against program requirement. A full outer join is used as a final step. However, the cross join is needed so that we can identify where students haven't done ANY work in a category. The full outer join won't pick up data that doesn't exist. What is a Cross Join? It's a way of merging data when you need everything on List 1 to be matched with everything on List 2. A cross join isn't one of the 6 joins packaged in Get & Transform (Power Query) and isn't used much. However, the cross join does have a purpose. This video shows how easy it is to make a cross join but more importantly: - A practical example of when to use a cross join. - Why a cross join was used instead of other joins or Get and Transform (Power Query) features. In this situation, we're measuring student progress against program requirement. A full outer join is used as a final step. However, the cross join is needed so that we can identify where students haven't done ANY work in a category. The full outer join won't pick up data that doesn't exist. Website: http://ozdusoleil.com My book: Guerrilla Data Analysis 2nd Edition http://www.amazon.com/Guerrilla-Analysis-Using-Microsoft-Excel/dp/1615470336 My old blog: http://datascopic.net/blog-2-2
Views: 1963 Excel On Fire
Excel Dynamic Arrays: Fully Dynamic Cross Tabulated Reports? Unbelievable! EMT 1520
 
09:16
Download Excel File: https://people.highline.edu/mgirvin/YouTubeExcelIsFun/EMT1518-1523.xlsx In this video learn about how to create a Fully Dynamic Cross Tabulated Report that can update when formula inputs are changed for Row Header Conditions or Column Headers Conditions and will instantly update when new data is added to the source data. This is all done with Formulas, NOT PivotTables, so everything updates instantly when source data or formula inputs change. See the New Array Functions SORT and UNIQUE, and also the older Array Function TRANSPOSE, but most fundamentally, we will see that the INDEX and MATCH Function can lookup columns of data based on formula inputs, and will be the secret ingredient that we use inside the SUMIFS function and also inside the UNIQUE Function. Full Lesson on these new Dynamic Arrays and new Excel Calculation Engine: Comprehensive Excel Dynamic Array Formula Lesson: The Power of Array Formulas (EMT 1516) , https://www.youtube.com/watch?v=7jJMDGZpjSk Entire page with all Excel Files for All Videos: http://people.highline.edu/mgirvin/excelisfun.htm If you want totals for your dynamic Croos Tab report, check out this video: Excel Dynamic Arrays: Fully Dynamic Cross Tabulated Reports With Totals!!!!! EMT 1528https://www.youtube.com/watch?v=wHeXjYQGvX8
Views: 8897 ExcelIsFun
Excel Magic Trick 1152: Formula or Power Query: Cost Report When Product IDs Don’t Match
 
07:30
Download Excel File: http://people.highline.edu/mgirvin/ExcelIsFun.htm See how to create Total Cost Report when Product IDs in transaction table do NOT match Product IDs in Lookup Table: 1. (00:08 minute mark) Set up of problem: Product IDs in transaction table do NOT match Product IDs in Lookup Table and we need to lookup costs to create a Total Cost Report 2. (00:56 minute mark) Formula method with COUNTIF, Asterisk Wild Card and VLOOKUP 3. (03:26 minute mark) Power Query Lookup Value Does Not Match In Lookup Table Summarize Costs When Product IDs Don’t Matc Product IDs in transaction table do NOT match Product IDs in Lookup Table and we need to lookup costs to create a Total Cost Report IDs in transaction table do NOT match Lookup IDs Miguel Escobar and Ken Puls are doing online workshops on Power Query www.powerquery.training . This training is not by excelisfun.
Views: 6976 ExcelIsFun
Excel Magic Trick 1346: Array Formula: Split Master Table into Sub Tables, Each Product on New Sheet
 
22:05
Download File: http://people.highline.edu/mgirvin/excelisfun.htm See how to use formulas to extract records from a Master Table to Sub Tables on Each Excel Worksheets for each product in the Master Table: 1. (00:17) Introduction. Look at Dynamic End Result Solution. 2. (01:28) Table Formula Nomenclature (Structured References) and how they ract when they are copied. 3. (02:35) Formula to Extract Sheet Name. See the functions: CELL, REPLACE and SEARCH. 4. (04:42) Formula to Count the number of records in the Master Table for each product. See the function COUNTIFS. 5. (05:57) Array formula to extract records based on Criteria. See the functions: IF, ROWS, INDEX, AGGREGATE, ROW and a number of Array Operations. 6. (17:25) Add Formula to calculate total revenue. 7. (19:07) How to Quickly Copy Worksheets using a Keyboard and Mouse. 8. (20:25) Test Where Master Table and Sub Tables are Dynamic and will update when new records are added. 9. (21:06) Summary & Considerations for Advantages and Disadvantages to using Array Formulas. Extract Product Records From Master Table to Multiple Sheets (Sub Tables). How to Retrieve Multiple Records from One Lookup Value. Return Multiple Records from One Lookup Value. Other Similar Videos: Excel Magic Trick 538: Dynamic Sub Tables Based On Master Sheet Array Formula & Drilling Through Excel Magic Trick 1347: Power Query: Split Master Table into Sub Tables, Each Product on New Sheet
Views: 20591 ExcelIsFun
Excel Magic Trick 1202: Conditional Formatting For a Cross Tabulated PivotTable
 
04:06
Download File: http://people.highline.edu/mgirvin/excelisfun.htm See how to add Conditional Formatting to a Cross Tabulated PivotTable: 1. (00:08) Problem Setup 2. (00:28) Set up PivotTable including Group by Year for Date column and Number Formatting for Units Field 3. (02:00) Set up Conditional Formatting Hurdle in Cells 4. (02:40) Add Conditional Formatting to a Cross Tabulated PivotTable
Views: 7141 ExcelIsFun
Count Number Products Battle: Excel? DAX? Power Query? Office 365? Excel Magic Trick 1533
 
15:38
Download Excel Start Files: https://people.highline.edu/mgirvin/YouTubeExcelIsFun/EMT1533Start.xlsx Download Excel Finished Files: https://people.highline.edu/mgirvin/YouTubeExcelIsFun/EMT1533Finished.xlsx In this video compare five methods to count how many products are in a column. Topic: (00:05) Introduction 1. (01:25) Excel Spreadsheet Function: COUNTIFS 2. (03:23) Excel Standard PivotTable 3. (04:47) Power Query: Group By feature 4. (07:23) DAX Functional Language of Excel Power Pivot & Power BI DAX: COUNTROWS 5. (11:08) Office 365 Dynamic Array Functions: UNIQUE & COUNTIFS (14:40) Summary Entire page with all Excel Files for All Videos: http://people.highline.edu/mgirvin/excelisfun.htm Full Lesson on these new Dynamic Arrays and new Excel Calculation Engine: Comprehensive Excel Dynamic Array Formula Lesson: The Power of Array Formulas (EMT 1516)
Views: 6702 ExcelIsFun
Vector dot product and cross product using calculator
 
02:07
Vector - dot product and cross product.
Excel Magic Trick 1100: Cross Tabulated Lookup: 1) Lookup Row then match or 2) Array Multiplication?
 
14:11
Download Excel File: http://people.highline.edu/mgirvin/ExcelIsFun.htm See Two Methods that can return a "Yes" when a Two Way Lookup based on a Column Header and Row Header must lookup items from a second table that presents Dimension (row / column size) Problems (01:59 min) 1. Method 1: INDEX to lookup a row based on a column header that can then be matched against a row header. See the functions: INDEX, MATCH, ISNUMBER and IF. Learn about array syntax. Learn that although the evaluated INDEX function looks like it returns an array, it actually returns a range that the MATCH function can understand. (08:09 min) 2. Method 2: Array Comparative Operation and Array Multiplication. See the functions SUMPRODUCT and IF. Learn about array syntax. Lookup based on row and column headers. Two Way Lookup.
Views: 16136 ExcelIsFun
Find the Dot Product and Cross Product using Maple 16
 
02:09
Watch in 720p/1080p HD and on full screen for best quality. This is a tutorial on how to using Maple 16 to find the cross product and dot product of a vector.The videos is sped up and without background sound. Some of the older videos are a little annoying with the music and VERY long. The idea is that you can watch this, get what you want out of it and move on.This is just an experiment and if the reception is good, will continue to make some videos this way. The idea is that you can watch this, get what you want out of it and move on.
Views: 3864 EngineeringHacks
Excel Magic Trick 1338: Power Query: Unpivot 12 Cross Tabulated Tables into One Proper Data Set
 
24:00
Download File: http://people.highline.edu/mgirvin/excelisfun.htm See 2 Examples of how to use Power Query to Convert 12 Individual Cross Tabulated Tables into One Proper Data Set: 1. (00:15) Introduction 2. (01:14) Example 1: Start with 12 Cross Tabulated Excel Tables (Tables set up as Official Excel Tables using Excel Table feature). See the Power Query Function: Table.UnpivotOtherColumns 3. (13:46) Example 2: Start with 12 Cross Tabulated Tables. See the Power Query Function: Table.UnpivotOtherColumns & Table.PromoteHeaders 4. (23:30) Summary
Views: 13347 ExcelIsFun
Vector Cross Product: How to derive
 
15:56
How to derive the cross product formula for vectors. Free ebook http://tinyurl.com/VectorsYT Test your understanding via a short quiz http://goo.gl/forms/BKJt1pY0Dc
Views: 5025 Dr Chris Tisdell
Excel Magic Trick 1107: VLOOKUP To Different Sheet: Sheet Reference, Defined Name, Table Formula?
 
09:02
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 Names 3. Table Formula Nomenclature (Structured References)
Views: 691092 ExcelIsFun
The Cross Product
 
08:05
Thanks to all of you who support me on Patreon. You da real mvps! $1 per month helps!! :) https://www.patreon.com/patrickjmt !! In this video, I give the formula for the cross product of two vectors, discuss geometrically what the cross product is, and do an example of finding the cross product. For more free math videos, visit http://PatrickJMT.com
Views: 745203 patrickJMT
Excel - Find Matching Values in Two Worksheets, Tables or Columns Tutorial - Part 1
 
14:44
In this video tutorial learn how to find matches in two worksheets in Microsoft Excel.
Compare Two Excel Lists to Spot the Differences
 
05:53
Over time you will collect many lists of Excel data. It can be a challenge to compare the contents of one list with the contents in another list. For example, to find out which customers do not exist in another list. In this lesson I demonstrate three techniques that you can use to compare Customer lists: 1) The =MATCH() Function 2) The VLookup() Function 3) Pivot Tables I invite you to visit my website - www.thecompanyrocks.com - to view all of my video lessons.
Views: 656000 Danny Rocks
Excel Magic Trick 1249: Build Database with Excel 2016 Table feature & VLOOKUP to Get Invoice Detail
 
25:46
Download File: https://people.highline.edu/mgirvin/excelisfun.htm **Note; The word "Database" is used loosely in this video. We use it just to mean we have a dynamic table to store raw data. Overview of video: 1) Build Invoice Database with Excel 2016 Table feature 2) Learn how Excel Table feature automatically carries formatting and formulas to new records 3) Learn how to use Table Formula Nomenclature / Structured References for Excel Table formulas 4) Learn about Dynamic Ranges with Excel Table feature 5) VLOOKUP and MATCH functions to lookup Invoice Details Full Detailed list of what is in video including time hyperlinks: 1) (00:11) Look at finished database and VLOOKUP formula to understand what the goal of the video is. 2) (02:00) Database must be a Proper Data Set: 1) Field Names in First Row, 2) Records in subsequent Rows, 3) Empty Cells or Excel Column/Row Headers Around Data Set 3) (03:07) Add Bold Format to Field Names / Column Headers so database interprets headers correctly 4) (04:42) Custom Date Format to Date Field. This is carried forward to new records in Excel Table Database. 5) (05:58) Add word wrap to Product Description. This is carried forward to new records in Excel Table Database. 6) (06:05) Add Number Formatting: Currency and Percentage to number fields. This is carried forward to new records in Excel Table Database. 7) (06:58) Add formula for Amount owed after discount, tax rate and shipping. See the ROUND function. This is carried forward to new records in Excel Table Database. 8) (10:05) Convert Proper Data Set to Excel Table with Ctrl + T. Excel Table feature is Excel’s Database feature. 9) (11:32) Add new column to database for Balance Due. Learn about Table Formula Nomenclature / Structured References for Excel Table formulas. 10) (11:53) Name the Table. 11) (14:30) Add new records to test database. 12) (16:39) Add Proper Field names using Table Formula Nomenclature / Structured References for Excel Table formulas in the lookup area. Learn about relative references in Table Formula Nomenclature / Structured References for Excel Table formulas. 13) (18:50) Add Data Validation Drop Down List for invoice lookup. 14) (19:44) Create VLOOKUP and MATCH Lookup formula to lookup Invoice Detail. Learn about how to lock (absolute) references in Table Formula Nomenclature / Structured References for Excel Table formulas. 15) (24:46) Test database and lookup formulas. 16) (25:21) Summary and Conclusion For more videos about The Excel Table feature and Table Formula Nomenclature (Structured References): https://www.youtube.com/playlist?list=PLrRPvpgDmw0kmoAhXamTJw6XkebJ6gCxg
Views: 96008 ExcelIsFun
Excel Magic Trick 1412: Power Query to Merge Two Tables Into One Table for PivotTable Report
 
06:56
Download File: Start File: https://people.highline.edu/mgirvin/YouTubeExcelIsFun/EMT1412Start.xlsx Finished File: https://people.highline.edu/mgirvin/YouTubeExcelIsFun/EMT1412Finished.xlsx Entire page with all Excel Files for All Videos: http://people.highline.edu/mgirvin/excelisfun.htm See how to use Power Query to Merge Two Tables into a Single Table, Load as a Connection Only and then build a PivotTable based on the New Merged Table saved as a connection only.
Views: 32971 ExcelIsFun
Excel Dynamic Arrays: Cross Tabulated Report, Totals Top & Left MMULT Array Function (EMT 1526)
 
07:29
Download Excel File: https://people.highline.edu/mgirvin/YouTubeExcelIsFun/EMT1526-1527.xlsx This video is a follow up to EMT 1520. In this video we see how to create fully Dynamic Cross Tabulated Report driven by formula inputs, and have totals at the Left and Above using the MMULT Array Function. Entire page with all Excel Files for All Videos: http://people.highline.edu/mgirvin/excelisfun.htm Full Lesson on these new Dynamic Arrays and new Excel Calculation Engine: Comprehensive Excel Dynamic Array Formula Lesson: The Power of Array Formulas (EMT 1516) Related Videos: Original video about Cross Tab Report, EMT 1520: https://www.youtube.com/watch?v=ZXn0D4Ch7zg Cross Tab Report with totals at bottom and Right, EMT 1528: https://www.youtube.com/watch?v=wHeXjYQGvX8 MMULT Array Function Video: https://www.youtube.com/watch?v=RyorWHIKPC0
Views: 3040 ExcelIsFun
30.3 Cross Product in Cartesian Coordinates
 
07:55
MIT 8.01 Classical Mechanics, Fall 2016 View the complete course: http://ocw.mit.edu/8-01F16 Instructor: Dr. Peter Dourmashkin License: Creative Commons BY-NC-SA More information at http://ocw.mit.edu/terms More courses at http://ocw.mit.edu
Views: 2175 MIT OpenCourseWare
Excel Magic Trick 1281: TEXTJOIN & CONCAT New Excel 2016 functions (14 Examples of Joining Items)
 
10:54
Download File: http://people.highline.edu/mgirvin/excelisfun.htm Learn about the new Excel 2016 functions TEXTJOIN and CONCAT. Compare and contrast these newer functions to the older methods of using the CONCATENATE function and the Ampersand. See some amazing new and more efficient uses that TEXTJOIN and CONCAT have over the earlier methods. 1. (00:47) Ampersand Example: Join First, Middle and Last name when there are no empty cells. 2. (01:18) CONCATENATE Function Example: Join First, Middle and Last name when there are no empty cells. 3. (02:50) CONCAT Function Example: Join First, Middle and Last name when there are no empty cells. 4. (03:30) TEXTJOIN Function Example: Join First, Middle and Last name when there are NO empty cells. Learn about the delimiter argument, ignore_empty argument, text1 argumnet, text2 arguments. 5. (04:34) TEXTJOIN Function Example: Join First, Middle and Last name when there ARE EMPTY CELLS. 6. (05:27) CONCAT Function Example: Join three elements to make up Product Code. 7. (05:56) CONCAT Function Example: Join single cell, delimiter and a range of cells to create a Product Code. 8. (06:43) Ampersand Example: Join three items with two different delimiters to create a Product Code. 9. (07:11) TEXTJOIN and Array Constant Example: Join three items with two different delimiters to create a Product Code. 10. (07:56) TEXTJOIN and Range of Cells that contains different delimiters: Join three items with two different delimiters to create a Product Code. 11. (08:19) TEXTJOIN function to join 3 items with a delimiter to create plywood label 12. (08:39) Ampersand Example: Join 20 e-mails with a semi-colon as a delimiter so we can past e-mails into E-mail To textbox so send out multiple e-mails. 13. (09:24) TEXTJOIN Example: Join 20 e-mails with a semi-colon as a delimiter so we can past e-mails into E-mail To textbox so send out multiple e-mails. 14. (09:53) TEXTJOIN to join records from a database with a comma delimiter to create single column that contains records. Purchase "Office 2016 for Office 365" https://products.office.com/en-us/buy/office Go to Office Insider site to download "Office Insider Version" https://products.office.com/en-US/office-insider Office Insider Version: 16.0.6568.1011 or 16.0.6568.2025
Views: 45713 ExcelIsFun
Excel Magic Trick 1510: Conditional Format Row With Duplicates Based on Product & Color
 
09:21
Download Files: https://people.highline.edu/mgirvin/YouTubeExcelIsFun/EMT1510.xlsx Entire page with all Excel Files for All Videos: http://people.highline.edu/mgirvin/excelisfun.htm In this video see how to color a row with conditional formatting using the COUNTIFS function, an Expandable Range and a Comparative Operator to convert formula to a Logical Formula. See how to use the Conditional Formatting Dialog Box with a Logical Formula. Also see how to use Conditional Formatting on an Excel Table, so new rows are formatted when new records are added..
Views: 5188 ExcelIsFun
Excel Dynamic Arrays: Fully Dynamic Cross Tabulated Reports With Totals!!!!! EMT 1528
 
13:02
Download Excel File: https://people.highline.edu/mgirvin/YouTubeExcelIsFun/EMT1528.xlsx This video is a follow up to EMT 1520, and thanks to David Milbrandt, we now can have a fully Dynamic Cross Tabulates Report driven by formula inputs, and have totals at the Right and Bottom. This video will blow your mid with what the New Office 365 Spilled Array Formulas can do!!!!! See the functions: SUMIFS, UNIQUE, SEQUENCE, SORT, INDEX, MATCH, TRANSPOSE, COUNTA and IF. Learn how to Append Columns or Rows to an existing Array. Entire page with all Excel Files for All Videos: http://people.highline.edu/mgirvin/excelisfun.htm Full Lesson on these new Dynamic Arrays and new Excel Calculation Engine: Comprehensive Excel Dynamic Array Formula Lesson: The Power of Array Formulas (EMT 1516), https://www.youtube.com/watch?v=7jJMDGZpjSk For original Excel Magic Trick 1520: https://www.youtube.com/watch?v=ZXn0D4Ch7zg
Views: 5029 ExcelIsFun
Vectors - Determinant Method Cross Product
 
05:18
Vectors - Determinant Method Cross Product Watch More Videos at https://www.tutorialspoint.com/videotutorials/index.htm Lecture By: Mr. Sameer Anand, Tutorials Point India Private Limited.
Excel Magic Trick 1010: SUMPRODUCT To Multiply Filtered Columns or Columns With Hidden Rows
 
12:42
Download Excel File: http://people.highline.edu/mgirvin/ExcelIsFun.htm See how to multiply and then add two columns with a Filter or Hidden Rows using SUBTOTAL, OFFSET and the SUMPRODUCT function: 1. OFFSET function inside the SUBTOTAL function to create the filtered column of values (rows hidden) 2. SUMPRODUCT to multiply the two filtered columns 3. OFFSET function with a function argument array operation 4. Array Constant 5. Row function to create an array of values SUMPRODUCT on filtered columns. Multiply Filtered Columns. Multiply Columns With Criteria. Multiply Columns Conditionally.
Views: 25710 ExcelIsFun
Excel Magic Trick 1024: SUMIF & SUMIFS function & Mixed Cell References & Dynamic Table Range
 
10:26
Download workbook example from video: http://people.highline.edu/mgirvin/excelisfun.htm Add with one or more conditions: 1. Learn how to add with one or more conditions using the SUMIF and SUMIFS functions. 2. Excel table feature to create dynamic ranges, ranges the expand as new records are added. 3. Learn how to use the Excel Table feature with or without the Table Formula Nomenclature. 4. See how to use regular cell references rather than Table Formula Nomenclature so that you can copy the formula to the side and not have the Table Formula Nomenclature move to different columns. 5. Learn how to create a cross tabulated table to add with two conditions 6. Learn how to use Mixed Cell References to help speed up formula creation time.
Views: 123921 ExcelIsFun
Excel Magic Trick 1345: Conditionally Format Product Name for No Items Entered in Row (4 Methods)
 
06:29
Download File: http://people.highline.edu/mgirvin/excelisfun.htm See how to use a Logical Formula and Conditional Formatting to highlight Product Name when no items are entered in the row. See 4 methods: 1. (00:11) Introduction to Using Logical Formulas to Apply Conditional Formatting. 2. (01:30) Method 1: COUNTA function with Equal Sign Comparative Operator. COUNTA function counts cells that are not empty. 3. (02:54) Method 2: COUNTA and NOT function. NOT function converts TRUE to FALSE and FALSE to TRUE. 4. (03:52) Method 3: COUNT function with Equal Sign Comparative Operator. COUNT function counts cells that contain numbers. 5. (04:37) Method 4: SUM function with Equal Sign Comparative Operator. SUM function adds numbers and will ignore Text Values. 6. (04:58) Conditional Formatting Dialog Box for Logical Formulas. “Use a formula to determine which cells to format”. “Format values where this formula is true”. 7. (06:18) Conclusion
Views: 5604 ExcelIsFun
Tableau 10: Cross-Database Joins
 
08:17
Watch as we quickly combine multiple, disparate sources to create a single Tableau data source and answer key business questions.
Views: 17650 ThorogoodBI
Vector Dot Product Formula
 
09:58
Coding the actual dot product formula. The formula is so simple, yet it is such a great tool.
Views: 857 Jamie King
Cross-Product Features | Showing Help Icons by Default
 
01:10
This tutorial applies to Rel 13 Update 18B and higher. It shows you how to set help options so that help icons are shown by default for all users.
How to Create an Invoice Template in Excel!
 
24:46
In this session, we’ve explained in easy STEP by STEP details about how to create an Invoice Template by just using some basic sum function and lookup feature without VBA in just few minutes. After this video, not only it will be easier for you to create such basic templates, but also you can get the print outs of this template at a single click. This template is very useful for beginners, startups businesses and individuals as it helps in managing and organizing all your finances into one place. We’ve used the following features to create this tutorial. 1. Border Alignments & Formatting 2. SUM function 3. VLOOKUP with IFERROR function 4. Cross Across Selection 5. Page Setup & Print Preview 6. Excel to PDF 7. CONCATENATE function to combine normal text and text from cell reference Visit us for daily dose of Excel Tips & Tricks at http://www.exceltip.com/ In case of any simple or complicated "Excel" query, you can ask to our experts for instant solution at http://www.excelforum.com/
Views: 886116 Excel Tip
The Formula for Dot Product
 
05:17
We prove the formula for dot product using the Law of Cosines.
Views: 547 Multivariablecalc
Create a Break Even Analysis Chart
 
12:53
Check out my Blog: http://exceltraining101.blogspot.com This video show how to create a break even chart. Based on fixed and variable costs you can calculate the break even unit totals and dollar amounts with the per unit sales price. P.S. Feel free to provide a comment or share it with a friend! #exceltips #exceltipsandtricks #exceltutorial #doughexcel --------------------- Excel Training: https://www.exceltraining101.com/p/training.html Excel Books: https://www.amazon.com/shop/dough
Views: 255605 Doug H
Excel Magic Trick 1438: Excel Formula to Create Cross Tabulated OR & AND Logical Test Sales Total
 
06:07
Download File: Start File: https://people.highline.edu/mgirvin/YouTubeExcelIsFun/EMT1438-1439Start.xlsx Finished File: https://people.highline.edu/mgirvin/YouTubeExcelIsFun/EMT1438-1439Finished.xlsx Entire page with all Excel Files for All Videos: http://people.highline.edu/mgirvin/excelisfun.htm See how to use SUMIFS and SUMPRODUCT Functions to create a Cross Tabulated Table to add Sales with Sales Channel Criteria as the Row Header Criteria and Product Group OR Criteria as the Column Header Criteria. Related Videos: Excel Magic Trick 1439: DAX Formula to Create Cross Tabulated OR & AND Logical Test Sales Total Excel Magic Trick 1438: Excel Formula to Create Cross Tabulated OR & AND Logical Test Sales Total
Views: 4039 ExcelIsFun
DAX Fridays! #61: CROSSJOIN
 
06:09
In this video I will show you an example on how the DAX function CROSSJOIN works. Dont miss it :) EXCEL SURVEY: https://1drv.ms/xs/s!Ar8CDNp8cGTcgjaHonN82T8I1jQT PREVIOUS VIDEO: https://www.youtube.com/watch?v=phoeV7QTBjY NEXT VIDEO:https://www.youtube.com/watch?v=mcQ_ZmuWvDs Looking for a download file? Go to our Download Center: https://curbal.com/donwload-center SUBSCRIBE to learn more about Power and Excel BI! https://www.youtube.com/channel/UCJ7UhloHSA4wAqPzyi6TOkw?sub_confirmation=1 Our PLAYLISTS: - Join our DAX Fridays! Series: https://goo.gl/FtUWUX - Power BI dashboards for beginners: https://goo.gl/9YzyDP - Power BI Tips & Tricks: https://goo.gl/H6kUbP - Power Bi and Google Analytics: https://goo.gl/ZNsY8l ABOUT CURBAL: Website: http://www.curbal.com Contact us: http://www.curbal.com/contact ▼▼▼▼▼▼▼▼▼▼ If you feel that any of the videos, downloads, blog posts that I have created have been useful to you and you want to help me keep on going, here you can do a small donation to support my work and keep the channel running: https://curbal.com/product/sponsor-me Many thanks in advance! ▲▲▲▲▲▲▲▲▲▲ QUESTIONS? COMMENTS? SUGGESTIONS? You’ll find me here: ► Twitter: @curbalen, @ruthpozuelo ► Google +: https://goo.gl/rvIBDP ► Facebook: https://goo.gl/bME2sB #DAXFRIDAYS #CURBAL #DAX #POWERBI #MVP ► Linkedin: https://goo.gl/3VW6Ky
Views: 4164 Curbal
Excel Magic Trick 1347: Power Query Function: Split Master Table into Sub Tables for Each Product
 
21:05
Download File: http://people.highline.edu/mgirvin/excelisfun.htm See how to create a Power Query (Get & Transform) Custom Function with a parameter in order to create five Sub Tables, one for each product, each on a new sheet, from a Master Table: 1. (00:17) Introduction. See finished Power Query Function to Extract Records to A Sheet Based on Criteria / Condition / Parameter. 2. (02:23) Import Excel Master Table into Query Editor. 3. (03:19) Filter Records and Add Custom Column to Calculate Revenue. See the Function Number.Round. 4. (07:10) Look at M Code and learn about some of the conventions for M Code. 5. (09:57) Load Query to Sheet to Test where the M Code works. 6. (10:29) Build Power Query Custom Function. Create Parameter / Input Variable / Changeable Criteria in M Code. 7. (12:58) Invoke Function to Create Sub Tables 8. (14:32) Test whether the sub tables 9. (15:57) Learn how to edit the Parameterized Custom Function so that all five invoked functions and the five Sub Tables update perfectly! Learn how to use the Table.RemoveColumns function. 10. (20:36) Summary Power Query (Get & Transform) Custom Function Power Query (Get & Transform) Code with an Input Variable Power Query (Get & Transform) with Input Criteria Power Query (Get & Transform) Parameterized Custom Function Build Re-Usable M Code in Power Query (Get & Transform) Create Power Query (Get & Transform) Function
Views: 17605 ExcelIsFun
Excel Magic Trick 1349: Power Query with Input Variables from Excel Sheet to Extract Records
 
18:02
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 Records and create a Revenue Report. Here are the steps: 1. (00:15) Introduction including Preview of Finished Solution and Preview of steps necessary to accomplish this goal. 2. (02:00) Import and transform Data Set, including removing Columns, Filter For Records and adding an extra Column to calculate Net Revenue using the Number.Round Power Query Function. 3. (06:38) Load Report to Sheet 4. (07:09) Import each Parameter/Criteria Table. 5. (07:36) Convert each Criteria Table to a single Text Item using the Record.Field Power Query Function. 6. (11:38) Declare and Insert Variables into M Code for Report 7. (14:10) Test Reporting System 8. (14:30) Create Recorded Macro To Refresh All and assign it to a Form button 9. (16:40) Test Macro and Reporting System 10. (17:25) Summary
Views: 83581 ExcelIsFun
How to Combine 2 Excel Workbooks Using VLOOKUP
 
08:22
This is a request from one of my viewers. In his organization, two people were working on this project and he needed to produce a consolidated Excel worksheet. Fortunately, when I look at the workbooks he sent me, I noticed that both had a MemberID field that contained the Unique Account Numbers. With this knowledge, I decided that the VLOOKUP Function would be the easiest way to complete this task. Here is a list of the Excel Techniques that I demonstrate in this tutorial: * Move or Copy a worksheet to another Excel Workbook * Create a Named Range to use as the "Table_array" in the VLOOKUP Function * Use "Mixed Cell References" - e.g. $A4 - in VLOOKUP Function * Use FALSE as the optional 4th Argument in VLOOKUP to produce an "Exact Match" * Use IFERROR Function to prevent Error Messages from appearing I invite you to visit my secure online shopping website - http://shop.thecompanyrocks.com - to examine the many training resources that I offer for sale. Danny Rocks The Company Rocks
Views: 1197347 Danny Rocks
Cross-Product Features | Submitting a Scheduled Process
 
02:00
This video tutorial applies to Rel 11 through Rel 13. It shows you how to submit a scheduled process and view the output.
SQL Tutorial 13 Introduction to JOIN, cartesian product
 
10:03
The CARTESIAN JOIN or CROSS JOIN returns the Cartesian product of the sets of records from the two or more joined tables. Check out our website: http://www.telusko.com Follow Telusko on Twitter: https://twitter.com/navinreddy20 Follow on Facebook: Telusko : https://www.facebook.com/teluskolearnings Navin Reddy : https://www.facebook.com/navintelusko Follow Navin Reddy on Instagram: https://www.instagram.com/navinreddy20 Subscribe to our other channel: Navin Reddy : https://www.youtube.com/channel/UCxmkk8bMSOF-UBF43z-pdGQ?sub_confirmation=1 Telusko Hindi : https://www.youtube.com/channel/UCitzw4ROeTVGRRLnCPws-cw?sub_confirmation=1
Views: 12885 Telusko
Chapter 7 - Multi table joins - cross product style
 
08:57
multi table joins using the cross product style
Views: 180 Michael Devlin
Cross-Product Features | Viewing Analytics and Reports
 
02:56
This video tutorial applies to Rel 11 through Rel 13 Update 17D. It shows you how to find analytics and reports, and how to make the most of the viewing features.
Cartesian Product of Graphs
 
01:06
Based on David Eppstein's image which I found here: https://secure.wikimedia.org/wikipedia/en/wiki/File:Graph-Cartesian-product.svg
Views: 4535 sneezebone
Dot Product and Cross Product
 
01:50
This video will show users how to calculate the dot product and cross product between two vectors using the TI-nSpire.
Views: 39505 PiedmontCC Math4U

Windows services application identity
R707 windows 2000
Judith reuten windows
Rougarou update windows
Download jdk 6u26 windows x86