Watch Queue
TV Queue
Watch QueueTV Queue
-
-
-
-
Sign in now to see your channels and recommendations!
Watch Queue
TV Queue
__count__/__total__
Subscription preferences
Loading...
Working...
ExcelIsFun
-
excelisfun YouTube Channel: How To Search For Videos & Download Excel Workbooks
367,567 views 1 year ago -
This item has been hidden
-
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.This item has been hidden -
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 FeaturesThis item has been hidden -
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)This item has been hidden -
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 ExcelThis item has been hidden -
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 BasicsThis item has been hidden -
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...This item has been hidden -
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)This item has been hidden -
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.This item has been hidden -
Excel Series: Magic Tricks (6th 200 videos)
Excel Magic Tricks by excelisfun. Learn efficiency in using Excel.This item has been hidden