# ExcelIsFun

• ### Tour of excelisfun YouTube Channel: Playlists, Downloadable Files and Search for Video Topic

474,482 views 2 years ago
In this video you will get a tour of the excelisfun Channel here at YouTube and learn how to find the right playlist of videos, search for the video you want and download the Excel workbook files that accompany each video. Show less
Read more
• ## Uploads Play all

• ### Excel Magic Trick 1465: Conditional Formatting Holiday Dates with Red Fill & Word "Holiday" - Duration: 9 minutes, 27 seconds.

• 3,743 views
• 1 day ago
• ### Excel Magic Trick 1464: Is Item In List? Formula to Check if Item is in a List on Separate Sheet. - Duration: 9 minutes, 42 seconds.

• 4,859 views
• 1 week ago
• ### Excel Magic Trick 1463: Show Formula in Cell With Excel Functions FORMULATEXT & ISFORMULA - Duration: 5 minutes, 59 seconds.

• 3,581 views
• 1 week ago
• ### Excel Magic Trick 1462: 5,000 Formulas in a Single Cell with SUMPRODUCT or Array Formula? - Duration: 12 minutes.

• 7,622 views
• 1 week ago
• ### Excel Magic Trick 1461: Ctrl + Enter or Ctrl + D, What is the Difference and When to Use Each? - Duration: 4 minutes, 8 seconds.

• 8,925 views
• 2 weeks ago
• ### Excel Magic Trick 1460: List All Relative Positions in a Single Cell using TEXTJOIN Array Formula - Duration: 12 minutes.

• 4,523 views
• 2 weeks ago
• ### Excel Magic Trick 1459: Adding Food or Accessory Costs For Each Dog with SUMIFS & SUMPRODUCT - Duration: 7 minutes, 9 seconds.

• 3,233 views
• 3 weeks ago
• ### Excel Magic Trick 1457 Part 2: Regional Settings & Text or Number Date / Times in SUMIFS Function - Duration: 3 minutes, 21 seconds.

• 2,127 views
• 3 weeks ago
• ### Excel Magic Tick 1458: Lookup Price in Multiple Tables: VLOOKUP, INDIRECT & Defined Names - Duration: 13 minutes.

• 6,210 views
• 3 weeks ago
• ### Excel Magic Trick 1457: Text or Number Date / Times in Functions & Direct Operations (10 Examples) - Duration: 16 minutes.

• 5,124 views
• 4 weeks ago
• ### Excel Magic Trick 1456: PivotTable & Slicer to Create 8 Year Sales Report by Product & Month - Duration: 4 minutes, 35 seconds.

• 5,234 views
• 1 month ago
• ### Excel Magic Trick 1455: Convert Text Month Criteria to Upper & Lower Dates for SUMIFS Function - Duration: 10 minutes.

• 5,398 views
• 1 month ago
This item has been hidden
• ## Highline Excel 2016 Class: Comprehensive Excel: Calculations & Data Analysis (27 Videos) Play all

Highline College Excel 2016 Class: Busn 218, Spreadhseet Construction taught by Michael Girvin
Comprehensive Excel Class: Effective & Efficient Calculations & Data Analysis, Basic to Advanced
Student Outcomes:
1) Develop Effective and Efficient and solutions in Excel.
2) Use Microsoft Excel to solve typical business related problems with an emphasis on: 1) Making effective and efficient numeric, logical and text calculations and 2) effectively and efficiently converting raw data into useful information.
3) Understand Data Analysis and Business Intelligence terms and use data analysis concepts to create useful information from raw data:
4) Understanding the structure of an excel file as: Cells, Worksheets, Sheet Tabs and Workbooks
5) Using keyboards to accomplish tasks quickly
6) Understand and Utilize Number Formatting as Façade
7) Use Style Formatting, Number Formatting and Page Setup to present information in an effect way.
8) Use Proper Data Sets and correct Data Types to leverage Excel’s full capabilities
9) Create Effective and Efficient Formulas that can make numeric, logical and text calculations and perform data analysis, including extensive coverage of types of formulas, formula elements, lookup formulas, array formulas and much more.
10) Preform Data Analysis and Business Intelligence with Excel’s Built in Data Analysis feature such as Sort, Filter, Power Query, PivotTables and Power Pivot. Learn the concepts and techniques for how to importing, clean and transform data from multiple sources in order to build refreshable reports, dashboards and other data analysis outputs.
11) Automate tasks using Recorded Macros and VBA from the Internet:
12) Use Finance Functions, Statistical Functions and Rounding functions to make specific calculations
• ### Highline Excel 2016 Class 01: Excel Fundamentals: Efficiency, Data, Data Sets, Formatting - Duration: 1 hour, 21 minutes.

• 103,396 views
• 1 year ago
• CC
• ### Highline Excel 2016 Class 02: Excel Fundamentals: Comprehensive Formula Lesson (15 Examples) - Duration: 55 minutes.

• 39,451 views
• 1 year ago
• CC
• ### Highline Excel 2016 Class 03: Data Analysis Fundamentals: PivotTables, Power Query & Data Model - Duration: 1 hour, 43 minutes.

• 167,659 views
• 1 year ago
• CC
• ### Highline Excel 2016 Class 04: References: Relative, Absolute, Mixed, Sheet, Workbook, 3-D, Table… - Duration: 1 hour, 43 minutes.

• 25,135 views
• 1 year ago
• CC
• ### Highline Excel 2016 Class 05: Excel Array Formulas: Comprehensive Lessons: 12 Examples - Duration: 52 minutes.

• 21,578 views
• 1 year ago
• CC
• ### Highline Excel 2016 Class 06: Conditional Calculations with Excel Formulas: Comprehensive Lessons - Duration: 1 hour, 23 minutes.

• 24,132 views
• 1 year ago
• CC
• ### Highline Excel 2016 Class 07 Excel 2016 MAXIFS, MINIFS & IFS Functions for Conditional Calculations - Duration: 11 minutes.

• 7,773 views
• 1 year ago
• CC
• ### Highline Excel 2016 Class 08: Text Formulas and Text Functions to Join and Extract Data - Duration: 29 minutes.

• 25,996 views
• 1 year ago
• CC
• ### Highline Excel 2016 Class 09: Date Formulas and Date Functions, including Fiscal Quarter & Year - Duration: 22 minutes.

• 18,092 views
• 1 year ago
• CC
• ### Highline Excel 2016 Class 10: Excel Data Validation (List, Custom & More), Comprehensive Lesson - Duration: 23 minutes.

• 17,757 views
• 1 year ago
• CC
• ### Highline Excel 2016 Class 11: Lookup Functions & Formulas, Comprehensive Lessons, 20 Examples - Duration: 1 hour, 18 minutes.

• 29,688 views
• 1 year ago
• CC
• ### Highline Excel 2016 Class 12: Two Lookup Values in VLOOKUP? Helper Column or Array Formula. - Duration: 7 minutes, 50 seconds.

• 9,357 views
• 1 year ago
• CC
This item has been hidden
• ## Basic Excel Business Analytics for Highline BI 348 Class. Business Analytics Playlist of Videos (60+ videos) Play all

Learn basic business analytics using the latest version of Microsoft Excel to make meaning of the torrent of data that business people our given each day. We will learn that basics of descriptive, predictive and prescriptive statistical methods and learn how to build efficient Excel models to solve business problems and to convert large data sets of unorganized raw data into useful information for decision making. Topics like: Building Good Spreadsheet Models, Descriptive Statistics, Data Cleaning, Data Transformation, Data Model Building, Data Visualization, Simple Linear Regression, Multiple Linear Regression, Time Series Analysis and Forecasting, Simple Optimization Models and Monte Carlo Simulations in an Excel Spreadsheet.

Business Analytics playlist of videos.
• ### Basic Excel Business Analytics #01: Basic Business Analytics using Excel - Duration: 5 minutes, 4 seconds.

• 54,207 views
• 2 years ago
• CC
• ### Basic Excel Business Analytics #02: Good Spreadsheet Model Design, Fixed Variable Cost Example - Duration: 37 minutes.

• 46,805 views
• 2 years ago
• CC
• ### Basic Excel Business Analytics #03: Goal Seek For What-If Analysis - Duration: 5 minutes, 29 seconds.

• 24,747 views
• 2 years ago
• CC
• ### Basic Excel Business Analytics #04: Excel Formula for Units Break Even Point and a Unit Defect Rate - Duration: 4 minutes, 47 seconds.

• 14,901 views
• 2 years ago
• CC
• ### Basic Excel Business Analytics #05: 1 Variable Data Table For What-If Analysis - Duration: 11 minutes.

• 17,193 views
• 1 year ago
• CC
• ### Basic Excel Business Analytics #06: 2 Variable Data Table For What-If Analysis - Duration: 9 minutes, 47 seconds.

• 13,380 views
• 1 year ago
• CC
• ### Basic Excel Business Analytics #07: X-Y Scatter Chart: Fixed Cost Variable Cost Model - Duration: 14 minutes.

• 14,945 views
• 1 year ago
• CC
• ### Basic Excel Business Analytics #08: Total Revenue Calculation: VLOOKUP or LOOKUP/SUMPRODUCT? - Duration: 19 minutes.

• 23,923 views
• 1 year ago
• CC
• ### Basic Excel Business Analytics #09: Shortest Distance Shipping Costs: INDEX, MATCH, & IF Functions - Duration: 10 minutes.

• 12,435 views
• 1 year ago
• CC
• ### Basic Excel Business Analytics #10: Find & Fix Excel Formula Errors in Spreadsheet Models - Duration: 17 minutes.

• 11,676 views
• 1 year ago
• CC
• ### Basic Excel Business Analytics #11: Dynamic Grading Model: Excel Table feature & VLOOKUP - Duration: 9 minutes, 50 seconds.

• 6,987 views
• 1 year ago
• CC
• ### Basic Excel Business Analytics #12: Raw Data, Data, Proper Data Sets and Data Terminology - Duration: 15 minutes.

• 6,749 views
• 1 year ago
• CC
This item has been hidden
• ## Excel Basics Series: 2007 (#1 to 23) or 2010 (#20 to 40) or 2013 (#1 to 27) Play all

Learn Excel from the Basics to the Advanced. Look through list of videos to find the series you want: 2007, 2010, or 2013. At bottom the numbers 1 to 23 are for Excel 2007. In the middle, the numbers 20 to 40 are for Excel 2010. At the top are the Excel Basics 2013 series for numbers 1 to 25.

This series shows a systematic, logical story about Excel that explains from the beginning theories of how to construct efficient systems of spreadsheets and then points you towards the Beautiful Excel infinity at the other end!

The story tries to not leave holes at any point in the story so that when you are done, you have a solid foundation to complete most tasks in Excel!

Excel Tutorial, Excel How To, Excel Lessons, Learn Excel, Beginning Excel, Excel Basics
• ### Office 2013 Class #19: Excel Basics 1: Excel Grid, Formatting, Formulas, Cell References, Page Setup - Duration: 50 minutes.

• 252,266 views
• 3 years ago
• CC
• ### Office 2013 Class #20: Excel Basics 02: Formula Inputs For Formulas and Charts & Excel's Golden Rule - Duration: 31 minutes.

• 61,735 views
• 3 years ago
• CC
• ### Office 2013 Class #21: Excel Basics 03: Count & Add: COUNT, COUNTA, SUM, COUNTIFS, SUMIFS functions - Duration: 12 minutes.

• 41,199 views
• 3 years ago
• CC
• ### Office 2013 Class #22: Excel Basics 04: PivotTables Are Easy! SUMIFS or PivotTable for Region Report - Duration: 13 minutes.

• 36,928 views
• 3 years ago
• CC
• ### Office 2013 Class #23: Excel Basics 05: Customize the Quick Access Toolbar and Ribbon - Duration: 5 minutes, 47 seconds.

• 22,867 views
• 3 years ago
• CC
• ### Office 2013 Class #24: Excel Basics 6: Excel Keyboard Shortcuts Are Fast! 10 Examples. - Duration: 11 minutes.

• 46,792 views
• 3 years ago
• CC
• ### Office 2013 Class #25: Excel Basics 07: What Excel Does: Calculations and Data Analysis - Duration: 6 minutes, 23 seconds.

• 15,246 views
• 3 years ago
• ### Office 2013 Class #26: Excel Basics 08: Default Alignment In Excel. Numbers stored As Text Trouble - Duration: 4 minutes, 5 seconds.

• 13,425 views
• 3 years ago
• CC
• ### Office 2013 Class #27: Excel Basics 09: Keeping Data in Excel: Proper Data Set or Excel Table - Duration: 13 minutes.

• 15,458 views
• 3 years ago
• CC
• ### Office 2013 Class #28: Excel Basics 10: Style Formatting: By Hand, Cell, Table & Conditional Format - Duration: 22 minutes.

• 22,244 views
• 3 years ago
• CC
• ### Office 2013 Class #29: Excel Basics 11: Number Formatting & Formulas Don't Get Tricked By The Façade - Duration: 28 minutes.

• 14,787 views
• 3 years ago
• CC
• ### Office 2013 Class #30: Excel Basics 12: ROUND function: When and How to use it in Business - Duration: 10 minutes.

• 11,105 views
• 3 years ago
• CC
This item has been hidden
• ## Highline Excel 2013 Class: Comprehensive Excel (Basics To Advanced) Play all

Video Playlist of Excel 2013 Videos from Excel Basics to Advanced. This is the complete Excel Class taught by Mike excelisfin Girvin at Highline College.Topics: Formulas, PivotTables, Flash Fill, Charts, Recorded Macros and More. About 50 Videos uploaded between Sept to Dec 2013. The 50 videos are being uploaded, a few each week from Sep 2013 to Dec 2013)
• ### Highline Excel 2013 Class Video 01: Back To Basics: Number Format, Keyboards, PivotTables, Formulas - Duration: 1 hour, 42 minutes.

• 140,635 views
• 3 years ago
• CC
• ### Highline Excel 2013 Class Video 02: Comprehensive Excel Formula Types & Elements Video 12 Examples - Duration: 33 minutes.

• 42,359 views
• 3 years ago
• CC
• ### Highline Excel 2013 Class Video 03: How Formulas Calculate: Order of Precedence in Excel - Duration: 15 minutes.

• 21,300 views
• 3 years ago
• CC
• ### Highline Excel 2013 Class Video 04: Percentage Increase or Decrease Formula - Duration: 4 minutes, 51 seconds.

• 33,199 views
• 3 years ago
• CC
• ### Highline Excel 2013 Class Video 05: Cell References: Relative, Absolute & Mixed (8 Examples) - Duration: 37 minutes.

• 37,017 views
• 3 years ago
• CC
• ### Highline Excel 2013 Class Video 06: Scenarios To Save Sets Of Formula Inputs, Paste Special Trick - Duration: 6 minutes, 1 second.

• 17,797 views
• 3 years ago
• CC
• ### Highline Excel 2013 Class Video 07: Worksheet & Workbook References, 3-D Cell References - Duration: 11 minutes.

• 15,975 views
• 3 years ago
• CC
• ### Highline Excel 2013 Class Video 08: Excel Table Formula Nomenclature / Structured References 22 Ex. - Duration: 25 minutes.

• 25,141 views
• 3 years ago
• CC
• ### Highline Excel 2013 Class Video 09: Defined Names & Aggregate Functions - Duration: 13 minutes.

• 19,006 views
• 3 years ago
• ### Highline Excel 2013 Class Video 10: AND & BETWEEN Criteria: SUMIFS, DSUM, COUNTIFS, AVERAGEIFS - Duration: 39 minutes.

• 21,720 views
• 3 years ago
• ### Highline Excel 2013 Class Video 11: Calculations With OR Criteria: COUNTIFS, DCOUNTA, SUMIFS, DSUM - Duration: 22 minutes.

• 17,824 views
• 3 years ago
• ### Highline Excel 2013 Class Video 12: AND & OR Criteria Calculations: D Functions like DSUM, DCOUNT - Duration: 9 minutes.

• 9,964 views
• 3 years ago
This item has been hidden
• ## Ctrl+Shift+Enter: Mastering Excel Array Formulas (35+ Videos in Series) Play all

This is a 30 video playlist of videos that teaches about Excel Array Formulas. This is the same series of videos that has been released on DVD. Be sure to buy the book at Amazon (Ctrl + Shift + Enter: Mastering Excel Array Formulas). so you can master Excel Array Formulas and Support the cause, given that these videos are free at YouTube. These are the topics of the 25 videos:
1. Intro To DVD and Video Series
2. Review of Formula & Function Notes: 15 Important Examples
3. Introduction To Array Formulas & Math Array Operation
4. Comparative Array Operation
5. Join Array Operation
6. Function Argument Array Operation
7. Array Constants In Formulas
8. Array Function: TRANSPOSE
9. Array Formula To Deliver Multiple Values To Multiple Cells (One Value To Each Cell).
10. SUMPRODUCT function
11. LOOKUP function
12. Functions That CAN Perform Array Calculations Without Ctrl + Shift + Enter: SUMPRODUCT, LOOKUP, AGGREGATE, INDEX.
13. Function That Can't Make Array Calculations, Even With Ctrl + Shift + Enter (SUMIF & The Like).
14. Dynamic Ranges And Returned Ranges With INDEX and OFFSET Functions
15. Boolean Logic, AND & OR criteria, & Converting TRUEs & FALSEs To 1s & 0s
16. General Rules For Array Formulas: Summarize First 14 Videos.
17. Formulas To Extract Records With Criteria
18. Array Function: FREQUENCY example
19. Unique Count Formulas and the power of the FREQUENCY function.
20. Array Function: MMULT
21. Extract Unique Lists and Sorting Formulas.
22. Conditional Formatting with Array Formulas
23. Excel 2010 Array Function: MODE.MULT
24. Array Function: LINEST
25. 24 Amazing Array Formulas
And a few extra videos thrown in for fun!

Array Formula Playlist of Videos. Excel Array Formulas. List of Videos For Excel Array Formulas.
• ### Ctrl + Shift + Enter: Excel Array Formulas #00: Intro To DVD and Video Series - Duration: 7 minutes, 34 seconds.

• 58,853 views
• 3 years ago
• ### Ctrl + Shift + Enter: Excel Array Formulas #01: Review Formula Basics (15 Important Examples) - Duration: 59 minutes.

• 119,500 views
• 3 years ago
• ### Ctrl + Shift + Enter: Excel Array Formulas #02: Introduction Array Formulas & Math Array Operation - Duration: 19 minutes.

• 36,880 views
• 3 years ago
• ### Ctrl + Shift + Enter: Excel Array Formulas #03: Comparative Array Operations, & Alternatives - Duration: 14 minutes.

• 24,693 views
• 3 years ago
• ### Ctrl + Shift + Enter: Excel Array Formulas #04: Join Array Operation & Alternatives Such as DGET - Duration: 14 minutes.

• 21,134 views
• 3 years ago
• ### Ctrl + Shift + Enter: Excel Array Formulas #04.5: Join Array Operation or SUMIFS Function? - Duration: 4 minutes, 18 seconds.

• 15,877 views
• 3 years ago
• ### Ctrl + Shift + Enter: Excel Array Formulas #05: Function Argument Array Operations - Duration: 8 minutes, 21 seconds.

• 19,457 views
• 3 years ago
• ### Ctrl + Shift + Enter: Excel Array Formulas #06: Array Constants in Top 3 Formula, VLOOKUP, more - Duration: 16 minutes.

• 19,261 views
• 3 years ago
• ### Ctrl + Shift + Enter: Excel Array Formulas #07: Introduction To Array Functions. TRANSPOSE Function - Duration: 9 minutes, 10 seconds.

• 14,834 views
• 3 years ago
• ### Ctrl + Shift + Enter: Excel Array Formulas 08: Array Formula: Multiple Values To Multiple Cells - Duration: 6 minutes, 47 seconds.

• 19,354 views
• 3 years ago
• ### Ctrl + Shift + Enter: Excel Array Formulas 09: SUMPRODUCT Function: 21 Examples, Including Timing - Duration: 45 minutes.

• 23,211 views
• 3 years ago
• ### Ctrl + Shift + Enter: Excel Array Formulas 10: LOOKUP Function: Array Operations wOut CtrlShiftEnter - Duration: 17 minutes.

• 15,413 views
• 3 years ago
This item has been hidden
• ## Slaying Excel Dragon Videos: Comprehensive Excel 2010 Lessons. (53 Videos) Play all

This video series accompanies the published book, Slaying Excel Dragons, ISBN 9781615470006. This video series covers Excel 2010.
Book Title: Slaying Excel Dragons: A Beginners Guide to Conquering Excel's Frustrations and Making Excel Fun. DVD also available: ASIN: 1615470050
See the entire book (550 pages) in video form. This videos series has all the examples in the book plus many more. This video series is a comprehensive look at everything that Excel can do (except for VBA code). This video series is also the basis for the Highline Community College class, Spreadsheet Construction taught by Michael Girvin, Busn 214 class.
The files that accompany the videos can be downloaded here: https://people.highline.edu/mgirvin/ExcelIsFun.htm
Chapters in the book:
1) How Excel Is Set Up
2) Keyboard Shortcuts
3) Data in Excel
4) Style Formatting and Page Setup
5) Formulas and Functions
6) Data Analysis Features
7) Charts
8) Conditional Formatting
9) Find and Replace and Go To Features
• ### Slaying Excel Dragons Book #1: How Excel Is Set Up, Customize Ribbon and Toolbar - Duration: 7 minutes, 55 seconds.

• 69,311 views
• 4 years ago
• ### Slaying Excel Dragons Book #2: Excel 2010 Keyboard Shortcuts Are Fast! - Duration: 21 minutes.

• 71,489 views
• 4 years ago
• ### Slaying Excel Dragons Book #3: Data Into Information: SUMIFS, PivotTable, Verifying Formulas & Data - Duration: 20 minutes.

• 42,753 views
• 4 years ago
• ### Slaying Excel Dragons Book #4: Table Format Structure For Raw Data & Data Analysis - Duration: 5 minutes, 54 seconds.

• 28,987 views
• 4 years ago
• ### Slaying Excel Dragons Book #5: Excel Table Feature (Excel as Database) - Duration: 18 minutes.

• 34,972 views
• 4 years ago
• ### Slaying Excel Dragons Book #6: Number Formatting As Façade: Decimal, Date, Time, Percentage - Duration: 32 minutes.

• 23,959 views
• 4 years ago
• ### Slaying Excel Dragons Book #7: Excel Data Alignment: Pitfalls & Advantageous Tricks - Duration: 15 minutes.

• 17,007 views
• 4 years ago
• ### Slaying Excel Dragons Book #8: Excel Stylistic Formatting - Duration: 21 minutes.

• 15,935 views
• 4 years ago
• ### Slaying Excel Dragons Book #9: Excel Page Setup For Reports Large or Small - Duration: 20 minutes.

• 17,718 views
• 4 years ago
• ### Slaying Excel Dragons Book #10: Excel Cell Styles and Table Styles - Duration: 8 minutes, 29 seconds.

• 18,228 views
• 4 years ago
• ### Slaying Excel Dragons Book #11: Comprehensive Excel Formula Creation Guide (Formula Types, Elements) - Duration: 38 minutes.

• 20,727 views
• 4 years ago
• ### Slaying Excel Dragons Book #12: How Excel Formulas Are Evaluated Order of Operations Excel Formulas - Duration: 17 minutes.

• 11,919 views
• 4 years ago
This item has been hidden
• ## Excel 2013 PowerPivot Playlist of Videos Play all

This is a list of PowerPivot Videos from Mike excelisfun Girvin at Highline College.
• ### Excel 2013 PowerPivot Basics #01: Introduction To PowerPivot for Excel 2013 - Duration: 38 minutes.

• 383,256 views
• 2 years ago
• ### Excel 2013 PowerPivot Basics #02: Import Large Non-Normalized Data Set To Reduce File Size - Duration: 5 minutes, 3 seconds.

• 80,319 views
• 2 years ago
• ### Excel 2013 PowerPivot Basics #03: Replace VLOOKUP with Excel 2013 Data Model & Relationships - Duration: 7 minutes, 24 seconds.

• 71,510 views
• 2 years ago
• ### Excel 2013 PowerPivot Basics #04: DAX Formulas Can Be Easier & Faster Than Array Formulas - Duration: 9 minutes, 20 seconds.

• 63,776 views
• 2 years ago
• ### Excel Magic Trick 1085: How To Simulate VLOOKUP Helper Column In Array Formula (Number or Text) - Duration: 12 minutes.

• 28,932 views
• 3 years ago
• ### Excel 2013 PowerPivot Basics #05: Import External Excel Tables, Build Data Model with SUMX function - Duration: 16 minutes.

• 73,285 views
• 2 years ago
• ### Excel 2013 PowerPivot Basics 6: Import, Filter, Edit From Multiple Data Sources: Access, Excel, Text - Duration: 20 minutes.

• 57,569 views
• 2 years ago
• ### Excel 2013 PowerPivot Basics 7: Calendar Table Calculated Columns: Month Year Quarter Fiscal Quarter - Duration: 23 minutes.

• 60,042 views
• 2 years ago
• ### Excel 2013 PowerPivot Basics #8: Edit Existing Connections, Import New Data, Existing Reports Update - Duration: 7 minutes, 29 seconds.

• 39,361 views
• 2 years ago
• ### Excel 2013 PowerPivot Basics #09: Calculated Fields & DAX Functions 9 Examples - Duration: 29 minutes.

• 83,378 views
• 2 years ago
• ### Excel 2013 PowerPivot Basics #10: CALCULATE function to Change Filter Context (14 Examples) - Duration: 53 minutes.

• 69,098 views
• 2 years ago
• ### Excel Magic Trick 1137: Excel & PowerPivot DAX Formula: Approximate Match Lookup Without VLOOKUP - Duration: 12 minutes.

• 19,554 views
• 3 years ago
This item has been hidden
• ## Excel Finance Class Play all

Learn about Finance and Excel:
1. Introductory course in corporate financial management.
2. We will study beginning concepts associated with the allocation of scarce resources across assets over time.
3. Understand financial statements and cash flow.
4. Understand and make valuation of future cash flow calculations.
5. Learn basics of valuing stocks and bonds.
6. Learn basics of Capital budgeting.
7. Learn basics of Risk and Return.
8. Learn how to use Excel to make financial calculations using many formulas and functions.

Download Excel workbook http://people.highline.edu/mgirvin/ExcelIsFun.htm
Highline Community College Busn 233 Financial Management with Excel taught by Michael Girvin.
• ### Excel Finance Class 01: Intro To Excel 2007 & 2010 - Duration: 14 minutes.

• 160,095 views
• 7 years ago
• ### Excel Finance Class 02: Getting Started with Formulas, Functions, Formula Inputs and Cell References - Duration: 20 minutes.

• 80,766 views
• 7 years ago
• ### Excel Finance Class 03: Math Operators and Order of Operations - Duration: 24 minutes.

• 37,638 views
• 7 years ago
• ### Excel Finance Class 04: The Importance Of Number Formatting In Financial Calculations - Duration: 13 minutes.

• 30,091 views
• 7 years ago
• ### Excel Finance Class 05: Percent, Percent Change / Increase / Decrease Percentage Number Formatting - Duration: 11 minutes.

• 65,980 views
• 7 years ago
• ### Excel Finance Class 06: Relative and Absolute Cell References in Copied Formulas - Duration: 8 minutes.

• 24,907 views
• 7 years ago
• ### Excel Finance Class 07: Stylistic Formatting - Duration: 3 minutes, 46 seconds.

• 19,891 views
• 7 years ago
• ### Excel Finance Class 08: Intro To Corporate Financial Management - Duration: 46 minutes.

• 45,311 views
• 6 years ago
• ### Excel Finance Class 09: Balance Sheet, Working Capital, Liquidity, Debt, Equity, Market Value - Duration: 34 minutes.

• 54,479 views
• 6 years ago
• ### Excel Finance Class 10: Income Statement, Non Cash Depreciation Expense, Matching Principal - Duration: 21 minutes.

• 27,034 views
• 6 years ago
• ### Excel Finance Class 11: Finance Cash Flow From Accounting Information - Duration: 38 minutes.

• 62,617 views
• 6 years ago
• ### Excel Finance Class 12: Cash Flow Advantage To Debt & Average and Marginal Tax Rates - Duration: 13 minutes.

• 16,775 views
• 6 years ago
This item has been hidden
• ## Excel 2013 Statistical Analysis for Business & Economics Playlist of Videos Play all

Highline College Statistical Analysis class, Busn 210. Learn how to use Excel 2013 For topics such as:
1. Understanding Raw Data, Proper Data Sets and Data Analysis
2. Excel Formulas and Functions
3. PivotTables
4. Excel 2013 Charts
5. Keyboards for efficient Data Analysis on Big Data
6. Number Formatting
7. Effective and efficient spreadsheet design, including Excel’s Golden Rule
8. What is Statistics (Descriptive and Inferential)
9. Descriptive Statistics: Tabular & Graphical Presentation
10. Descriptive Statistics: Numerical Measures (Averages and Variances)
11. Introduction to Probability
12. Discrete Probability Distributions
13. Continuous Probability Distributions
14. Sampling and Sampling Distributions
15. Interval Estimation
16. Hypothesis Testing
17. Comparisons involving Means, Experimental Design and Analysis of Variance
18. Comparisons involving Proportions and a Test of Independence
19. Linear Regression
20. Multiple Regression

Busn 210, Class taught at Highline College by Mike excelisfun Girvin
• ### Excel 2013 Statistical Analysis #00: Excel Workbooks For This Class - Duration: 2 minutes, 8 seconds.

• 43,544 views
• 2 years ago
• ### Excel 2013 Statistical Analysis #01: Using Excel Efficiently For Statistical Analysis (100 Examples) - Duration: 2 hours, 22 minutes.

• 314,380 views
• 2 years ago
• ### Excel 2013 Statistical Analysis #2: Install Data Analysis Add-in For Amazing Excel Statistical Tools - Duration: 75 seconds.

• 31,212 views
• 2 years ago
• ### Excel 2013 Statistical Analysis #03: Download & Install Power Query for Data Transformation Tools - Duration: 3 minutes, 39 seconds.

• 44,396 views
• 2 years ago
• ### Excel 2013 Statistical Analysis #4: What Is / Are Statistics? Download Stock Data Create Information - Duration: 19 minutes.

• 31,819 views
• 2 years ago
• ### Excel 2013 Statistical Analysis #5 Data Categorical, Quantitative, Nominal, Ordinal, Interval, Ratio - Duration: 20 minutes.

• 26,484 views
• 2 years ago
• ### Excel 2013 Statistical Analysis #06: Frequency Distributions & Column Charts, Categorical Variables - Duration: 33 minutes.

• 34,434 views
• 2 years ago
• ### Excel 2013 Statistical Analysis #07: Subtle Chart Junk - Duration: 3 minutes, 26 seconds.

• 13,549 views
• 2 years ago
• ### Excel 2013 Statistical Analysis #8: Frequency Distributions, Histograms, Skew, Quantitative Variable - Duration: 41 minutes.

• 114,302 views
• 2 years ago
• ### Excel 2013 Statistical Analysis #09: Cumulative Frequency Distribution & Chart, PivotTable & Formula - Duration: 15 minutes.

• 33,886 views
• 2 years ago
• ### Excel 2013 Statistical Analysis #10: Description of Dot Plot and Stem and Leaf Charts - Duration: 2 minutes, 49 seconds.

• 9,770 views
• 2 years ago
• ### Excel 2013 Statistical Analysis #11: Power Query Import Multiple Text Files, Grade Histogram by Year - Duration: 9 minutes, 2 seconds.

• 11,380 views
• 2 years ago
This item has been hidden
to add this to Watch Later

### Add to

Loading playlists...