Subscription preferences


Loading icon Loading...



excelisfun YouTube Channel: How To Search For Videos & Download Excel Workbooks

327,584 views 1 year ago
excelisfun = 2200 Excel How to Videos and 50 Playlists of Excel Videos.

Come to the excelisfun Channel to search for videos or watch playlists of videos that can teach you Excel from beginning to end.

To learn Excel from beginning to end, watch the Slaying Excel Dragons playlist.

Learn Excel formulas, functions, array formulas, Charts, PivotTables, Data Storage, Data Analysis and much more - all for free. Check out the different playlists of videos!

Workbooks to download: http://people.highline.edu/... Show less
Read more

Ctrl+Shift+Enter: Mastering Excel Array Formulas (30 Videos in Series) Play

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.

Slaying Excel Dragon Videos: Comprehensive Excel 2010 Lessons. (53 Videos) Play

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

Highline Excel 2013 Class: Comprehensive Excel Basics To Advanced Play

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) Play

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) Play

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

Excel Extract Data (Records) From Table / List / Database Play

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...

Office 2013 Videos: WindowsExplorer, Word, PP, Excel, Access Play

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 Play

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) Play

Excel Magic Tricks by excelisfun. Learn efficiency in using Excel.
to add this to Watch Later

Add to