# ExcelIsFun

• ### Excel & Business Math 41: Markup On Cost or Markup On Sell Price? Calculate & How They Are Different

1,479 views 2 days ago
Download Start Excel File: https://people.highline.edu......
Download pdf Notes: https://people.highline.edu......
Entire Class Web Site: https://people.highline.edu......

In this video learn the difference between Markup on Cost and Markup on Sell Price.
Excel & Business Math Class (Busn 135) taught by Michael Girvin at Highline College / Mike Girvin at excelisfun Channel at YouTube Channel.
Topics in Video:
1. (00:01) Introduction
2. (00:52) When Thinking About Markup, There Are Two Sides: Cost Side & Sell Price Side
3. (03:01) Both the Cost Side (Manufacturers & Distributors) & Sell Price Side (Retail Stores) Calculate the \$ Markup the Same
4. (05:33) Learn Formulas For “% Markup”. Cost Side (Manufacturers & Distributors) uses Cost As Denominator and Sell Price Side (Retail Stores) uses Sell Price As Denominator
5. (12:27) Meaning of “% Markup On Cost” and “% Markup On Sell Price”
6. (13:25) Solve Markup on Cost Problem
7. (16:45) Solve Markup on Sell Price Problem
8. (19:25) Solve Both Markup on Cost & Markup on Sell Price Problems
9. (23:15) Summary

Next Video: 42 Excel & Business Math Show less
Read more
• ## Uploads Play all

• ### Excel Magic Trick 1479: Lookup Bulk Quantity Discount Prices Using VLOOKUP Function - Duration: 10 minutes.

• 1,974 views
• 1 day ago
• ### Excel & Business Math 41: Markup On Cost or Markup On Sell Price? Calculate & How They Are Different - Duration: 24 minutes.

• 1,421 views
• 2 days ago
• ### Excel & Business Math 40: Partial Payment on Invoice with Cash Discount, Credit to Account Balance? - Duration: 11 minutes.

• 1,351 views
• 3 days ago
• ### Excel & Business Math 39: Create Excel Invoices, Data Validation Drop-down, VLOOKUP & IF Functions - Duration: 30 minutes.

• 3,286 views
• 4 days ago
• ### Excel & Business Math 38: Date Math, Invoices, Cash Discounts on Invoices, Nested IF Functions - Duration: 1 hour, 4 minutes.

• 2,371 views
• 1 week ago
• ### Excel & Business Math 37: Trade Discounts, Series Discounts, Net Cost Equivalents & Wholesale Cost - Duration: 36 minutes.

• 1,955 views
• 1 week ago
• ### Excel & Business Math 36: Comprehensive Excel Payroll Example: SUMIFS, MROUND, MOD, VLOOKUP & More - Duration: 28 minutes.

• 2,897 views
• 2 weeks ago
• ### Excel & Business Math 35: VLOOKUP & MAX Functions for Percentage Method Federal Income Tax Deduction - Duration: 29 minutes.

• 2,525 views
• 2 weeks ago
• ### Excel & Business Math 34: MEDIAN Function for FICA Social Security & Medicare Payroll Deductions - Duration: 38 minutes.

• 1,936 views
• 2 weeks ago
• ### Excel & Business Math 33: VLOOKUP Function for Incentive Pay: Commissions & Piecework (15 Examples) - Duration: 1 hour, 21 minutes.

• 8,404 views
• 2 weeks ago
• ### Excel & Business Math 32: Rounding Time Calculations to Nearest 5 or 15 minutes using MROUND - Duration: 15 minutes.

• 2,008 views
• 3 weeks ago
• ### Excel & Business Math 31: Night Shift Hours Worked Formula for Payroll Time Sheet (3 Examples) - Duration: 20 minutes.

• 2,109 views
• 3 weeks ago
This item has been hidden
• ## Excel Basics: Learn to Efficiently Use Excel at Work and to Get a Job (25 Videos) Play all

This is a free Excel class taught by Mike Girvin, Microsoft Excel MVP and Highline College Professor. This class will teach you the efficient and effective methods of using Excel so you can became great at using Excel to accomplish all your tasks at work, at home, and so that you can get that job you want that requires Excel skills!!!
This is the Busn 216 class at Highline and is the Pre-requisite for Busn 218, which is the Highline Excel 2016 Class Video Playlist here at Highline.
If you are watching videos to learn all about Excel, watch Excel Basics Playlist, first, then watch the Highline Excel 2016 Class, second.
This Playlist will have about 25 videos and will have a new video released every other day : )
Excel Basics Playlist of Videos.
• ### Excel Basics 1: Introduction To Excel 1: Formatting, Formulas, Cell References, Page Setup - Duration: 1 hour, 2 minutes.

• 39,439 views
• 5 months ago
• CC
• ### Excel Basics 2: Introduction to Excel 2: Excel's Golden Rule for Formulas, Formula Inputs, & Charts - Duration: 37 minutes.

• 18,555 views
• 5 months ago
• CC
• ### Excel Basics 3: Count & Add with COUNT, COUNTA, SUM, COUNTIFS, SUMIFS Functions (Intro Excel #3) - Duration: 21 minutes.

• 13,881 views
• 5 months ago
• CC
• ### Excel Basics 4: PivotTables & SUMIFS Function to Create Summary Reports (Intro Excel #4) - Duration: 33 minutes.

• 15,870 views
• 4 months ago
• CC
• ### Excel Basics 5: PivotTable Power to Create Reports with Various Calculations & Layouts - Duration: 20 minutes.

• 12,206 views
• 4 months ago
• CC
• ### Excel Basics 6: Customize Quick Access Toolbar (QAT) and Show New Ribbon Tabs - Duration: 10 minutes.

• 6,160 views
• 4 months ago
• CC
• ### Excel Basics 7: Keyboard Shortcuts Are Fast! - Duration: 8 minutes, 16 seconds.

• 9,532 views
• 4 months ago
• CC
• ### Excel Basics 8: Default Data Alignment In Excel & How it Can Help - Duration: 9 minutes, 25 seconds.

• 6,432 views
• 4 months ago
• CC
• ### Excel Basics 9: Number Formatting as Façade & the ROUND Function - Duration: 28 minutes.

• 7,951 views
• 4 months ago
• CC
• ### Excel Basics 10: Date & Time Number Formatting, Formulas, Functions & Calculations - Duration: 39 minutes.

• 9,114 views
• 4 months ago
• CC
• ### Excel Basics 11: Search for Excel Functions & get help with Function Arguments - Duration: 17 minutes.

• 8,039 views
• 4 months ago
• CC
• ### Excel Basics 12: Complete Formula Lesson of Formula Types & Formula Elements 12 Examples - Duration: 43 minutes.

• 12,735 views
• 4 months ago
• CC
This item has been hidden
• ## Highline Complete 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

If you are watching videos to learn all about Excel, watch Excel Basics Playlist, first, then watch the Highline Excel 2016 Class, second.
• ### Highline Excel 2016 Class 01: Excel Fundamentals: Efficiency, Data, Data Sets, Formatting - Duration: 1 hour, 21 minutes.

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

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

• 203,381 views
• 1 year ago
• CC
• ### Introduction to Power Query & Power Pivot Data Model in Excel 2016 (Excel Magic Trick 1468) - Duration: 50 minutes.

• 50,970 views
• 5 months ago
• ### Highline Excel 2016 Class 04: References: Relative, Absolute, Mixed, Sheet, Workbook, 3-D, Table… - Duration: 1 hour, 43 minutes.

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

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

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

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

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

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

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

• 37,342 views
• 1 year ago
• CC
This item has been hidden
• ## Highline Complete 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.

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

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

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

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

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

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

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

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

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

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

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

• 10,646 views
• 4 years ago
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.

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

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

• 28,252 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.

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

• 19,875 views
• 2 years ago
• CC
• ### Basic Excel Business Analytics #06: 2 Variable Data Table For What-If Analysis - Duration: 9 minutes, 47 seconds.

• 15,348 views
• 2 years ago
• CC
• ### Basic Excel Business Analytics #07: X-Y Scatter Chart: Fixed Cost Variable Cost Model - Duration: 14 minutes.

• 17,563 views
• 2 years ago
• CC
• ### Basic Excel Business Analytics #08: Total Revenue Calculation: VLOOKUP or LOOKUP/SUMPRODUCT? - Duration: 19 minutes.

• 28,850 views
• 2 years ago
• CC
• ### Basic Excel Business Analytics #09: Shortest Distance Shipping Costs: INDEX, MATCH, & IF Functions - Duration: 10 minutes.

• 14,262 views
• 2 years ago
• CC
• ### Basic Excel Business Analytics #10: Find & Fix Excel Formula Errors in Spreadsheet Models - Duration: 17 minutes.

• 13,288 views
• 2 years ago
• CC
• ### Basic Excel Business Analytics #11: Dynamic Grading Model: Excel Table feature & VLOOKUP - Duration: 9 minutes, 50 seconds.

• 7,775 views
• 2 years ago
• CC
• ### Basic Excel Business Analytics #12: Raw Data, Data, Proper Data Sets and Data Terminology - Duration: 15 minutes.

• 7,896 views
• 2 years ago
• CC
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.

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

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

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

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

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

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

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

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

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

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

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

• 16,317 views
• 4 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.

• 72,913 views
• 5 years ago
• ### Slaying Excel Dragons Book #2: Excel 2010 Keyboard Shortcuts Are Fast! - Duration: 21 minutes.

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

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

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

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

• 24,869 views
• 5 years ago
• ### Slaying Excel Dragons Book #7: Excel Data Alignment: Pitfalls & Advantageous Tricks - Duration: 15 minutes.

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

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

• 18,278 views
• 5 years ago
• ### Slaying Excel Dragons Book #10: Excel Cell Styles and Table Styles - Duration: 8 minutes, 29 seconds.

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

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

• 12,417 views
• 5 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.

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

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

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

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

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

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

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

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

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

• 28,159 views
• 7 years ago
• ### Excel Finance Class 11: Finance Cash Flow From Accounting Information - Duration: 38 minutes.

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

• 17,583 views
• 7 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.

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

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

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

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

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

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

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

• 14,574 views
• 3 years ago
• ### Excel 2013 Statistical Analysis #8: Frequency Distributions, Histograms, Skew, Quantitative Variable - Duration: 41 minutes.

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

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

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

• 12,251 views
• 3 years ago
This item has been hidden
to add this to Watch Later

### Add to

Loading playlists...