Playlists
|
See how to use the excelisfun YouTube channel:
1) Search For Videos 2) Download Workbooks 3) Find Playlists With The Videos You Want! |
|
Learn Excel from the Basics to the Advanced. 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 is a comprehensive Excel class taught by Mike Gel 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
|
|
See 45 amazing examples for lookup in Excel using the functions VLOOKUP, HLOOKUP, LOOKUP, MATCH, INDEX and CHOOSE. 10 videos, 170 minutes, 45 examples. These videos are taken from the Highline Community College Excel Class Taught by Mike Gel Girvin. Some of the topics covered are:
1.VLOOKUP and MID function to extract part of text string for the lookup value 2.Conditional Format a row with LOOKUP function 3.Check to see if item is in list using MATCH & ISNUMBER functions 4.3-Way Lookup use INDEX & MATCH |
|
Learn about the power of Array Formulas. 4 videos, 75 minutes, 24 examples. These videos are taken from the Highline Community College Excel Class Taught by Mike Gel Girvin. Some of the topics covered are:
1.Basics of array formulas 2.Eliminate columns and formula and replace them with a single array formula 3.Learn how to use Array Functions 4.See great time & space saver formula for Lookup-Adding and Counting Unique Records. |
Videos
(832)
[TRANSLATED]
How To Post Questions At The Mr ...
[TRANSLATED]
How To Post Questions At The Mr Excel Message Board
The smartest Excel People In The World? Some of them hang out at the Mr Excel Mess...
[TRANSLATED]
Highline Excel Class 02: Excel F...
Learn about:
1) The different elements of formulas: equal sign, cell references...
[TRANSLATED]
Excel Magic Trick 167p1 IF funct...
Part 1. See 12 different examples of how to use the IF function. This video starts...
[TRANSLATED]
Excel Basics #20: Data Analysis ...
The Excel Basics Series shows a systematic description of what Excel can do from b...
[TRANSLATED]
Highline Excel Class 45: INDEX &...
See 12 examples for the INDEX and MATCH function:
1.Use INDEX, MATCH and SUMPRODU...
[TRANSLATED]
Excel Statistics 22: Histogram &...
See how to create a Percent Cumulative Frequency Distribution with Formulas, a His...
[TRANSLATED]
Excel Magic Trick #246: Waterfal...
[TRANSLATED]
Excel Magic Trick #246: Waterfall Profit Chart
See how to create a Waterfall Profit Chart using a Stacked Column Chart, some form...
[TRANSLATED]
Excel Magic Trick # 267: Percent...
Learn about the universal formula for Percentage Change: (End Value)/Beg Value) 1...
[TRANSLATED]
Highline Excel Class 40: VLOOKUP...
[TRANSLATED]
Highline Excel Class 40: VLOOKUP 11 Unusual Examples
See these 11 VLOOKUP tricks:
1.VLOOKUP algorithm
2.VLOOKUP, Named Ranges, Exact ...
Add to iGoogle


















