excelisfun -- 1800 Excel How To Videos
Loading...
43,124
subscribers
19,809,101
video views
Featured Playlists
Excel Basics Series 2007 (1 to 23) & 2010 (20 to 40)
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
44 videos
Play all
Excel Tutorial, Excel How To, Excel Lessons, Learn Excel, Beginning Excel, Excel Basics
44 videos
Play all
Highline Excel Class Beg - Adv (Complete Class - 59 videos)
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
59 videos
Play all
59 videos
Play all
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.
91 videos
Play all
91 videos
Play all
Excel Finance Class
Learn about Finance and Excel:
1. Introductory course in corporate financial management.
2. We will study beginning concepts associated with the allocation of scarce resources across assets over time.
3. Understand financial statements and cash flow.
4. Understand and make valuation of future cash flow calculations.
5. Learn basics of valuing stocks and bonds.
6. Learn basics of Capital budgeting.
7. Learn basics of Risk and Return.
8. Learn how to use Excel to make financial calculations using many formulas and functions.
Download Excel workbook http://people.highline.edu/mgirvin/ExcelIsFun.htm
Highline Community College Busn 233 Financial Management with Excel taught by Michael Girvin.
113 videos
Play all
1. Introductory course in corporate financial management.
2. We will study beginning concepts associated with the allocation of scarce resources across assets over time.
3. Understand financial statements and cash flow.
4. Understand and make valuation of future cash flow calculations.
5. Learn basics of valuing stocks and bonds.
6. Learn basics of Capital budgeting.
7. Learn basics of Risk and Return.
8. Learn how to use Excel to make financial calculations using many formulas and functions.
Download Excel workbook http://people.highline.edu/mgirvin/ExcelIsFun.htm
Highline Community College Busn 233 Financial Management with Excel taught by Michael Girvin.
113 videos
Play all
Excel 2010 Business Math Class
About 50 Videos about Formulas, Functions, Number Formatting and Math calculations such as: Percentage Increase and Decrease, Invoicing, Cash Discounts, Series Discounts, Payroll, Finance and more...
89 videos
Play all
89 videos
Play all
Office 2010 - Windows Explorer, Word, Excel, Access, PP
Office 2010 Class taught by Michael Girvin at Highline Community College which covers:
1. Windows 7 Operating System Windows Explorer
2. Word
3. PowerPoint
4. Excel
5. Access
51 videos
Play all
1. Windows 7 Operating System Windows Explorer
2. Word
3. PowerPoint
4. Excel
5. Access
51 videos
Play all
Excel Series: Magic Tricks (4th 200 videos)
200 videos that shows tricks in Excel. Excel Magic Tricks 385 - 584. Many efficency tips of how to use Excel effectivly. VLOOKUP & IF functions, array formulas, Date Math and more!
200 videos
Play all
200 videos
Play all
Excel Series: Magic Tricks (3rd 200 videos)
Learn amazing Excel Magic Tricks that will help you become more productive and will allow you to become the Excel Superhero at your work (helping others with Excel is so much fun)! Excel is POWER! Excel is Fun!
200 videos
Play all
200 videos
Play all
Excel Series: Magic Tricks (2nd 200 videos)
Learn amazing Excel Magic Tricks that will help you become more productive and will allow you to become the Excel Superhero at your work (helping others with Excel is so much fun)! Excel is POWER! Excel is Fun!
200 videos
Play all
200 videos
Play all
Excel Lookup Functions & Formulas Beg - Adv
Learn how to use Lookup in Excel: VLOOKUP, HLOOKUP, LOOKUP, MATCH, INDEX and CHOOSE. 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
This is a logical (beginning to end) story about many of the lookup situations you may encounter in Excel.
In This Series learn more than 15 amazing ways to look things up in Excel. We will look at the functions VLOOKUP, HLOOKUP, LOOKUP, MATCH, INDEX, CHOOSE, and the non-function lookup formula using the intersector operator. We will look at simple lookups all the way to complicated, yet efficient methods to look things up in Excel.
Excel Tutorial, Excel How To, Excel Lessons, Learn Excel, Beginning Excel, Excel Basics
50 videos
Play all
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
This is a logical (beginning to end) story about many of the lookup situations you may encounter in Excel.
In This Series learn more than 15 amazing ways to look things up in Excel. We will look at the functions VLOOKUP, HLOOKUP, LOOKUP, MATCH, INDEX, CHOOSE, and the non-function lookup formula using the intersector operator. We will look at simple lookups all the way to complicated, yet efficient methods to look things up in Excel.
Excel Tutorial, Excel How To, Excel Lessons, Learn Excel, Beginning Excel, Excel Basics
50 videos
Play all
Excel Array Formulas Beg - Advanced
Learn about the power of Array Formulas. 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.
In this series see how to create array formulas in Excel. Array formulas can take complex series of formula calculations and reduce them down to a single formula that sits in just one cell! You will see how to create array formulas and see how to use Array Functions.
Learn how to create Array Formulas such as:
1. Total Sales (given rows of input data)
2. Stock Portfolio Return & Standard Deviation given many input variables
3. Multi-conditional Summing and Counting
4. Bayes' Statistical Theorem
5. Summing the 3 largest values for boomerang tournaments
6. Find the biggest improvement
Learn how to use the following Array Functions:
1. FREQUENCY function for Frequency Distributions and Histograms
2. COLUMN & ROW functions to create consecutive Numbers
3. MMULT function to do Matrix Algebra
4. TRANSPOSE function to transpose tables
5. LINEST function to do Linear Algebra
37 videos
Play all
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.
In this series see how to create array formulas in Excel. Array formulas can take complex series of formula calculations and reduce them down to a single formula that sits in just one cell! You will see how to create array formulas and see how to use Array Functions.
Learn how to create Array Formulas such as:
1. Total Sales (given rows of input data)
2. Stock Portfolio Return & Standard Deviation given many input variables
3. Multi-conditional Summing and Counting
4. Bayes' Statistical Theorem
5. Summing the 3 largest values for boomerang tournaments
6. Find the biggest improvement
Learn how to use the following Array Functions:
1. FREQUENCY function for Frequency Distributions and Histograms
2. COLUMN & ROW functions to create consecutive Numbers
3. MMULT function to do Matrix Algebra
4. TRANSPOSE function to transpose tables
5. LINEST function to do Linear Algebra
37 videos
Play all
Excel Extract Records From Database Table / List
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...
78 videos
Play all
Extract With Advanced Filter
Extract With Formulas
Extract With VLOOKUP function
DGET With function
Extract With Filter
And more...
78 videos
Play all
Duplicate Lookup Values - Extract Multiple Items/Records
See what to do when there are Duplicate lookup values and you need to look and return all of the items or records associated with the duplicate lookup values. See Formula, Filter and Advanced Filter Methods. Videos 358, 359, 360 teach all the concepts of how array formulas work for this sort of situation.
11 videos
Play all
11 videos
Play all
Excel Compare / Merge Two Lists
See Excel tricks for:
1)Merge Two Lists Tables w Advanced Filter and Remove Duplicates Feature
2)Is items in Other List?
3)Compare 2 Lists, Extract Records Not Listed Twice
4)Merge Two Lists Excluding Unique Values From First Data Set
5)Merge Two Lists When 1st Column Matches, Extract Fields From Both Tables
20 videos
Play all
1)Merge Two Lists Tables w Advanced Filter and Remove Duplicates Feature
2)Is items in Other List?
3)Compare 2 Lists, Extract Records Not Listed Twice
4)Merge Two Lists Excluding Unique Values From First Data Set
5)Merge Two Lists When 1st Column Matches, Extract Fields From Both Tables
20 videos
Play all
Excel Dynamic Charts Series
Learn abouts how to create dynamic Charts with these methods:
1) Hiding rowsLearn abouts how to create dynamic Charts with these methods:
1)Hide / Unhide Rows
2)Filter & Sort Feature
3)Excel 2010 / 2007 Table Feature (2003 List Feature)
4)Advanced Filter
5)Dynamic Chart Labels using TEXT function and Ampersand &
6)PivotTable PivotChart
7)SUMIFS function
8)SUMPRODUCT function
9)4 Week Chart Dynamic Formula & Dynamic Data Validation Formula
10)OFFSET Function Dynamic Range
11)Dynamic Area Chart with IF Function
24 videos
Play all
1) Hiding rowsLearn abouts how to create dynamic Charts with these methods:
1)Hide / Unhide Rows
2)Filter & Sort Feature
3)Excel 2010 / 2007 Table Feature (2003 List Feature)
4)Advanced Filter
5)Dynamic Chart Labels using TEXT function and Ampersand &
6)PivotTable PivotChart
7)SUMIFS function
8)SUMPRODUCT function
9)4 Week Chart Dynamic Formula & Dynamic Data Validation Formula
10)OFFSET Function Dynamic Range
11)Dynamic Area Chart with IF Function
24 videos
Play all
Excel Pivot Tables (PivotTable) Tricks
The most powerful feature in Excel is the Pivot Table (PivotTable)!!!!!!!!!
See how to create Pivot Tables, Pivot them, Group Dates and more!
Remember: The reason we must learn Pivot Tables is because:
1)They are super fast!
2)They are the easiest way to make calculations when you have multiple criteria!
40 videos
Play all
See how to create Pivot Tables, Pivot them, Group Dates and more!
Remember: The reason we must learn Pivot Tables is because:
1)They are super fast!
2)They are the easiest way to make calculations when you have multiple criteria!
40 videos
Play all
Excel Conditional Formatting Tricks
See many different tricks for Excel's fabulous Conditional Formatting feature. See the real power of Conditional Formatting when you use TRUE FALSE formulas as the condition for formatting.
76 videos
Play all
76 videos
Play all
Isaac's Excel Videos
Isaac shows how to have fun with Excel. He made a video when he was Three, Four and Five. More to come!
4 videos
Play all
view all
4 videos
Play all
Advertisement
