excelisfun -- Excel How To Videos

Uploaded videos

Slaying Excel Dragon Videos 1-53 Data Analysis, Calculations

This video series accompanies the published book, Slaying Excel Dragons, ISBN 9781615470006
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

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

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

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

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

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

Excel Series: Magic Tricks (6th 200 videos)

Excel Magic Tricks by excelisfun. Learn efficiency in using Excel.

Excel Series: Magic Tricks (5th 200 videos)

Excel Magic Tricks by excelisfun

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!

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!

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!

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

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

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

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.

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

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

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!