Excel 2010 Statistics #34: Data Analysis Add-in Descriptive Statistics tool

Download file: https://people.highline.edu/mgirvin/ExcelIsFun.htm 1. Use the Data Analysis Add-in Descriptive Statistics tool to quick calculate Numerical descriptive statistics like, Mean, Median, Mode, Standard Deviation, Range. Min, Max This is for the Highline Community College Busn 210 Statistical Analysis for Business and Economics taught by Michael Girvin

Excel Magic Trick 1207: PERCENTILE.EXC, PERCENTILE.INC, QUARTILE.EXC, QUARTILE.INC Functions

About this tutorial: Video duration: 12:52 Download File: See how to use the different percentile and quartile functions in Excel:: 1. (00:11) What is a percentile? 2. (00:47) Difference between PERCENTILE.EXC and PERCENTILE.INC functions AND the difference between the QUARTILE.EXC and QUARTILE.INC functions. 3. (2:30) Algorithm for calculating position of item in list for .EXC […]

Average Last 3 Customer Sales: Power Query, DAX Measure or Worksheet Formula: Excel Magic Trick 1552

About this tutorial: Video duration: 22:45 Download Excel Finished Files: Entire page with all Excel Files for All Videos: In this video learn how to Average a customers last three sales (last three dates) using Excel Worksheet Formulas, Power Query M Code and a Power Pivot & Power BI DAX Measure. Learn about the Table.Sort […]

Office 2010 Class #36: Excel PivotTables Pivot Tables 15 examples (Data Analysis)

Download files at: https://people.highline.edu/mgirvin/AllClasses/216_2010/Content/04Excel/Excel2010.htm The Excel 2010 Basics Series shows a systematic description of what Excel can do from beginning to end. Topics Covered In Video: 1. PivotTables are easy: Just envision the table in advance 2. Field list has fields and areas that you can drag fields to 3. Column Labels — Column Headers […]

Excel Magic Trick 521: Bankers Rounding (Half-Way-Even) vs. Arithmetic Rounding

About this tutorial: Video duration: 13:54 See how to Round numbers two different ways: 1.School Rounding: 5 or greater add 1, 4 or less leave as is. 2.Bankers Rounding : 5 round to nearest even, 6 or greater add 1, 4 or less leave as is. See four methods: 1.EXCEL ROUND Function 2.User Defined Function […]

Excel Magic Trick 1299: Automatic Calendar Table in Data Model, New in Excel 2016

About this tutorial: Video duration: 3:47 Download File: Learn how to: create Automatic Calendar Table in Data Model, New in Excel 2016. This ability was not in earlier versions of Excel. Incoming search terms:excel magic trick 1299

Excel Magic Trick 591: Paste Special Operations Add & Multiply

About this tutorial: Video duration: 5:32 See how to add $600 to a lot of numbers all at once by using Paste Special Operations Add. See how to increase a lot of numbers all at once by 6% by using Paste Special Operations Multiply.

Excel 2013 Statistical Analysis #4: What Is / Are Statistics? Download Stock Data Create Information

About this tutorial: Video duration: 19:28 Download files: Topics in this video: 1. (00:21) What Is / Are Statistics? Define Statistics 2. (02:42) Descriptive Statistics and Inferential Statistics 3. (05:00) Collect, analyze and present raw data on Yahoo Stock Price: Search the internet, download, create formulas and crate a Chart and present the information in […]

Excel 2010 Magic Trick 672: AGGREGATE function Replaces SMALL Function Array Formula

About this tutorial: Video duration: 8:10 See how you can use the non-Ctrl+Shift+Enter function AGGREGATE in place of SMALL in an array formula. Link for file:

Excel Magic Trick # 273: Extract Top 5 Records w Formula

About this tutorial: Video duration: 10:52 Extract top (max high) 5 records w formula where duplicates are allowed. See how to extract the top (max high) five values and associated names from a database with an array formula that can handle duplicate top values. See the functions: TRANSPOSE, COUNTIF, MAX, INDIRECT, IF, COLUMNS, INDEX, SMALL […]

Excel Magic Trick 1336: Power Query: Import Big Data Text Files: Connection Only or Data Model?

About this tutorial: Video duration: 11:35 Download File: See how to use Import 10 Text Files and Append (combine) then into a single Proper Data Set before making a PivotTable Report. Compare and Contrast whether we should use Connection Only or Data Model to store the data. 1. (00:18) Introduction & Look at Text Files […]

Excel Tables Tutorial #2 How to Create and Use Excel Tables 2013 2010 2007

About this tutorial: Video duration: 10:1 In this Excel Tutorial Video Series I show you how to create and Use Excel tables. I show you how to style your table, make custom table styles, navigate through excel tables, insert new table columns and table rows, Work with table style options, move tables, and how to […]

Import Power Pivot Data Model into Power BI Desktop (Excel Magic Trick 1365)

About this tutorial: Video duration: 3:36 Download File: See how to import an Excel Power Pivot Data Model with tables, relationships and DAX Measures into Power BI Desktop using the File (Upper Left icon), Import, Excel Workbook option in Power BI Desktop.

Excel Magic Trick 1436 Excel 2016: Combine 2 BIG Tables into 1 for PivotTable Report, No Power Pivot

About this tutorial: Video duration: 7:5 Download File: Start File: Finished File: Entire page with all Excel Files for All Videos: See how to use Excel 2016 to take a 900,000 row table and a 1,000,000 roe table and combine them into one in order to make a PivotTable Report. See how to use the […]

Power query in Excel in Hindi ||excel for accountant| interview questions|| PIVOT TABLE DASHBOARD ||

About this tutorial: Video duration: 15:55 MOST ASKING QUESTION IN INTERVIEW. WATCH AND APPLY THIS AND BE A UNIQUE EXPLORE YOUR KNOWLEDGE

Excel Magic Trick 1331: Import Multiple Excel Files & Sheets into Excel: Power Query Get & Transform

About this tutorial: Video duration: 29:48 Download File: See how to use Power Query (Get & Transform) to import multiple Excel Workbook Files with Multiple Excel Sheets into a single Excel File in two different situations: 1. (00:18) Introduction to Append Multiple Workbooks and Merge Multiple Workbooks 2. (01:58) Append Multiple Workbooks into a single […]

Excel Magic Trick 402: Monthly Comparative Report – Pivot Table

About this tutorial: Video duration: 3:52 See how to use a Pivot Table to create a Report that shows the differences in Sales between Months. See the Pivot Table tricks: 1.Group Dates by Quarter and Year 2.Drag and Drop Fields 3.Show values as Difference from 4.Formatting a Pivot Tables Incoming search terms:IHD7ricehog

Excel Magic Trick 1430: DAX Functions XNPV & XIRR for Irregular Cash Flow Net Present Value & IRR

About this tutorial: Video duration: 9:45 See how to use the DAX Functions XNPV and XIRR to calculate the Net Present Value and Internal Rate of Return of Cash Flows that occur at irregular date intervals. See how to use the DAX Functions XNPV and XIRR to calculate the Net Present Value and Internal Rate […]

Excel Magic Trick 1066: PivotTable: Month Over Month Sales Calculations From Transactional Data Set

About this tutorial: Video duration: 2:23 Download Excel File: See MOM calculations: 1. (00:18 min) Use PivotTable to calculate Month Over Month Sales Calculations From Transactional Data Set 2. (00:50 min) PivotTable to group by month 3. (00:50 min) PivotTable to add month sales 4. (01:11 min) Show in Tabular Format 5. (01:18 min) Number […]

Formula.Firewall Error in Power Query & Power BI: Rebuild This Data Combination Solved (MSPTDA 9.5)

About this tutorial: Video duration: 5:22 Learn how to deal with Power Query Error: Formula.Firewall: Query references other queries or steps, so it may not directly access a data source. Please rebuild this data combination. Two solutions are presented in this video. Download Files: Excel Start: Zipped Folder: Download Excel FINISHED Files:… Incoming search terms:msptda […]