Subscription preferences
Loading...
Working...
ExcelIsFun
excelisfun YouTube Channel: How To Search For Videos & Download Excel Workbooks
255,970 views
10 months ago
Ctrl+Shift+Enter: Mastering Excel Array Formulas (30 Videos in Series)
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.
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.
Slaying Excel Dragon Videos: Comprehensive Excel 2010 Lessons. (53 Videos)
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
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
Highline Excel 2013 Class: Comprehensive Excel Basics To Advanced
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)
Highline Excel 2007 Class: Comprehensive Excel Basics To Advanced (59 Videos)
This is a comprehensive Excel 2007 class taught by Mike excelisfun Girvin at Highline Community College. You will see a review of Excel basics and then move on to intermediate and advanced topics in Excel
Excel Basics Series 2007 (#1 to 23) & 2010 (#20 to 40) & 2013 (#1 to 27)
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
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
Excel Extract Data (Records) From Table / List / Database
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...
Extract With Advanced Filter
Extract With Formulas
Extract With VLOOKUP function
DGET With function
Extract With Filter
And more...
Office 2013 Videos: WindowsExplorer, Word, PP, Excel, Access
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)
Excel 2010 Statistics Formulas Functions Charts PivotTables
Learn All the functions, formulas, formatting, Charts and PivotTable Pivot Table tricks for doing Basics Statistics in Business and Economics.
Excel Series: Magic Tricks (6th 200 videos)
Excel Magic Tricks by excelisfun. Learn efficiency in using Excel.