|
|
|
| Home | Videos | Playlists |
| Channels | About | Search |
|
|
|
|
12:28
3,212 views
|
|
9:47
2,696 views
|
|
7:46
1,920 views
|
|
0:16
2,533 views
|
|
10:33
2,767 views
|
|
4:44
1,971 views
|
|
This is a 30 video playlist of videos that teaches about Excel Array Formulas. It is being released in early 2014 (Jan to Mar). 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.
|
|
|
7:34
by ExcelIsFun
28,908 views
|
|
59:26
by ExcelIsFun
59,455 views
|
|
19:18
by ExcelIsFun
20,195 views
|
|
14:50
by ExcelIsFun
14,236 views
|
|
14:43
by ExcelIsFun
12,600 views
|
|
4:18
by ExcelIsFun
10,269 views
|
|
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
|
|
|
7:55
by ExcelIsFun
43,686 views
|
|
21:53
by ExcelIsFun
45,641 views
|
|
20:27
by ExcelIsFun
28,843 views
|
|
5:54
by ExcelIsFun
19,174 views
|
|
18:28
by ExcelIsFun
21,153 views
|
|
32:56
by ExcelIsFun
15,689 views
|
|
Video Playlist of Excel 2013 Videos from Excel Basics to Advanced. 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)
|
|
|
1:42:38
by ExcelIsFun
56,791 views
|
|
33:55
by ExcelIsFun
17,734 views
|
|
15:23
by ExcelIsFun
8,811 views
|
|
4:51
by ExcelIsFun
14,244 views
|
|
37:12
by ExcelIsFun
14,719 views
|
|
6:01
by ExcelIsFun
8,161 views
|
|
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
|
|
|
2:08
by ExcelIsFun
8,939 views
|
|
Excel 2013 Statistical Analysis #01: Using Excel Efficiently For Statistical Analysis (100 Examples)
2:22:43
by ExcelIsFun
51,041 views
|
|
Excel 2013 Statistical Analysis #2: Install Data Analysis Add-in For Amazing Excel Statistical Tools
1:15
by ExcelIsFun
6,905 views
|
|
3:39
by ExcelIsFun
9,751 views
|
|
Excel 2013 Statistical Analysis #4: What Is / Are Statistics? Download Stock Data Create Information
19:28
by ExcelIsFun
8,752 views
|
|
Excel 2013 Statistical Analysis #5 Data Categorical, Quantitative, Nominal, Ordinal, Interval, Ratio
20:17
by ExcelIsFun
5,793 views
|
|
This is a list of PowerPivot Videos from Mike excelisfun Girvin at Highline College.
|
|
|
38:33
by ExcelIsFun
67,441 views
|
|
5:03
by ExcelIsFun
14,746 views
|
|
7:24
by ExcelIsFun
13,559 views
|
|
9:20
by ExcelIsFun
11,523 views
|
|
12:53
by ExcelIsFun
14,232 views
|
|
16:53
by ExcelIsFun
14,322 views
|
|
Videos about the amazing Excel Power Query, which allows you at import, transform and merge data from many sources into Excel as an Excel Table, into the Data Model, or as a summary report. From Mike excelisfun Girvin at Highline College.
|
|
|
|
3:39
by ExcelIsFun
9,751 views
|
|
5:31
by ExcelIsFun
13,603 views
|
|
9:05
by ExcelIsFun
9,761 views
|
|
15:09
by ExcelIsFun
6,394 views
|
|
7:15
by ExcelIsFun
4,596 views
|
|
9:01
by ExcelIsFun
4,102 views
|
|
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
50:48
by ExcelIsFun
93,439 views
|
|
Office 2013 Class #20: Excel Basics 02: Formula Inputs For Formulas and Charts & Excel's Golden Rule
31:17
by ExcelIsFun
21,051 views
|
|
12:28
by ExcelIsFun
13,671 views
|
|
Office 2013 Class #22: Excel Basics 04: PivotTables Are Easy! SUMIFS or PivotTable for Region Report
13:29
by ExcelIsFun
13,681 views
|
|
5:47
by ExcelIsFun
8,067 views
|
|
11:31
by ExcelIsFun
15,043 views
|
|
See how to extract records from Database Table / List using:
Extract With Advanced Filter
Extract With Formulas
Extract With VLOOKUP function
DGET With function
Extract With Filter
And more...
|
|
|
Excel Magic Trick 703: Extract Records Multiple Criteria (AND OR logic) Filter, Formula, Adv. Filter
23:32
by ExcelIsFun
131,365 views
|
|
15:12
by ExcelIsFun
30,764 views
|
|
15:06
by ExcelIsFun
38,674 views
|
|
2:21
by ExcelIsFun
23,663 views
|
|
7:46
by ExcelIsFun
48,392 views
|
|
12:43
by ExcelIsFun
136,053 views
|
|
About 50 basic videos that cover how to efficiently use Excel, Access, Word, Windows Explorer, PowerPoint and Mail Merge. This is for the Highline Community College Class, Busn 216, Computer Applications taught by Michael Girvin, Mike excelisfun Girvin. Playlist Of Basic Videos for Excel, Word, Access, PowerPoint, Windows Explorer and Mail Merge. This series covers basics for each application. The 50 videos are being uploaded, a few each week from Sep 2013 to Dec 2013)
|
|
|
32:45
by ExcelIsFun
12,518 views
|
|
18:48
by ExcelIsFun
6,610 views
|
|
9:22
by ExcelIsFun
5,292 views
|
|
25:13
by ExcelIsFun
5,115 views
|
|
18:50
by ExcelIsFun
5,010 views
|
|
12:24
by ExcelIsFun
4,971 views
|
