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
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
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.
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 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
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!
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!
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!
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
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
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.
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
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
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!
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.
Highline Community College Teacher, Mike Girvin has created over 1900 Videos, 90 Playlists. Excel Efficiency Tricks so you can work faster, have more fun & help others with Excel. To get free Excel training, watch playlists of videos: 1) Excel Basics, 2) Highline Excel Class. Free Excel Lessons. Learn Excel for Free. Free Excel Tutorials.
Highline Community College Teacher, Mike Girvin has created over 1900 Videos, 90 Playlists. Excel Efficiency Tricks so you can work faster, have more fun & help others with Excel. To get free Excel training, watch playlists of videos: 1) Excel Bas...