Archive for December, 2011
Saturday, December 31st, 2011
Wall St. Training Self-Study Instructor, Hamilton Lin, CFA explains how to utilize basic regression techniques in Excel. For the novice statistician doing basic regression analysis, Excel’s capabilities are quite robust, although we don’t dare compare Excel to an official statistics program.
For more information of the video courses previewed here, go to: http://www.wstselfstudy.com/modules.html
Over 80 hours of online, interactive Self-Study Videos!
***YOUTUBE VISITORS ONLY***
10% off any online course, use Discount code: youtube
http://www.wstselfstudy.com
Wall St. Training Self-Study provides online, video-based, self-study financial modeling training solutions to Wall Street. Our interactive course modules are Excel-based and specialize in advanced and complex financial modeling, valuation modeling, investment banking, mergers & acquisitions and leveraged buyout training topics. Enhance your skills and master the content required by Wall Street investment banks, M&A, research, asset management, credit, and private equity firms.
Duration : 0:5:7
(more…)
Technorati Tags: banking, financial, hamilton, Investment, LBO, lin, modeling, St., Street, training, Wall
Tags: banking, financial, hamilton, Investment, LBO, lin, modeling, St., Street, training, Wall
Posted in Learn Basic Excel | 2 Comments »
Saturday, December 31st, 2011
Intro to Excel VBA this is a quick video that explains the most commonly used code for Ranges in Excel. We name a range and copy a range to another location. We also show how to copy a selected range
Duration : 0:4:14
(more…)
Technorati Tags: a1, Copy, excel, howto, lesson, range, select, tutorial, vba
Tags: a1, Copy, excel, howto, lesson, range, select, tutorial, vba
Posted in Learn Excel Macros | No Comments »
Saturday, December 31st, 2011
Excel Formulas Urdu Tutorials – Part 3 – by Irfan Wazir Ali
Duration : 0:14:0
(more…)
Technorati Tags: Ali, analysis, by, cellphones, commentary, computers, creature, cybersecurity, defense, diy, downloads, economy, Educational, electronics, environment, excel, finance, financial, formulas, hacking, hacks, howto, instructions, Irfan, medicine, Money, music charts, Part, programs, repair, smart phones, software, technology, tutorial, tutorials, Urdu, video game, vlog, Wazir
Tags: Ali, analysis, by, cellphones, commentary, computers, creature, cybersecurity, defense, diy, downloads, economy, Educational, electronics, environment, excel, finance, financial, formulas, hacking, hacks, howto, instructions, Irfan, medicine, Money, music charts, Part, programs, repair, smart phones, software, technology, tutorial, tutorials, Urdu, video game, vlog, Wazir
Posted in Learn Excel Formulas | 5 Comments »
Saturday, December 31st, 2011
Visit http://www.TeachExcel.com for more, including Excel Consulting, Macros, and Tutorials.
Excel video tutorial about formula auditing in Excel and finding out what formulas point to what cells in a worksheet. Specifically this tutorial talks about tracing precedents and dependents in Excel. This allows you to quickly and easily see what cells are included in a formula or function and what formulas or functions use particular cells in a worksheet in Excel. This is done by displaying arrows from cells to the formulas in which they are used and vice verse.
The main benefit of doing this is to troubleshoot problems in a spreadsheet as well as to quickly find out what references what within a worksheet. This allows you to quickly analyze and understand how a spreadsheet works if you haven’t used it in a while or received the spreadsheet from an outside source or a colleague.
For Excel consulting, classes, or to get the spreadsheet or macro used here visit the website http://www.TeachExcel.com There, you can also get more free Excel video tutorials, macros, tips, and a forum for Excel.
Have a great day!
Duration : 0:6:59
(more…)
Technorati Tags: arrows, auditing, dependents, errors, excel, formula, Help, precedents, trace, troubleshooting, workbooks, worksheets
Tags: arrows, auditing, dependents, errors, excel, formula, Help, precedents, trace, troubleshooting, workbooks, worksheets
Posted in Learn Excel Formulas | 1 Comment »
Friday, December 30th, 2011
“In this video see how to use the Istext Formula in Excel to determine whether the cell valuue is a text or a non text value.
Also covered in this video are
1. The N formula
2. The Randbetween formula
3.The IF formula
4. and conditional Vlookup!! “
Duration : 0:6:37
(more…)
Technorati Tags: excel, excel made easy vlookup, excelmadeasy, excelmadeeasy, Microsoft Excel, multiple vlookup, myelesson
Tags: excel, excel made easy vlookup, excelmadeasy, excelmadeeasy, Microsoft Excel, multiple vlookup, myelesson
Posted in Learn Excel Formulas | No Comments »
Friday, December 23rd, 2011
(Change Sheet Background)
Microsoft Office Excel 2007
Duration : 0:1:39
(more…)
Technorati Tags: 2007, amazing, Application, awesome, background, Basic, beginner, change, cool, demonstration, easy, education, excel, experiment, function, Help, home, instructions, learn, made, Microsoft, Movie, office, program., programing, Really, Reel, sheet, teaches, teen, tips, training, tutorial, video
Tags: 2007, amazing, Application, awesome, background, Basic, beginner, change, cool, demonstration, easy, education, excel, experiment, function, Help, home, instructions, learn, made, Microsoft, Movie, office, program., programing, Really, Reel, sheet, teaches, teen, tips, training, tutorial, video
Posted in Learn Basic Excel | No Comments »
Friday, December 23rd, 2011
In this VBA session you will learn how to
1) How to activate teh Devleloper Tab in Excel
2)How to open the VBA Programming Module in Excel
3) How to write a VBA code for creating a Message box in Excel with Yes/No Options
4) How to test the VBA Code
5) How to run the VBA Code
5) How to assign a special Button to Run the VBA Program
The training file shown in the video is available for free download at www.excelmadeeasy.weebly.com
Duration : 0:7:43
(more…)
Technorati Tags: code, excel, excel made easy, excelmadeasy, excelmadeeasy, messagebox, vba
Tags: code, excel, excel made easy, excelmadeasy, excelmadeeasy, messagebox, vba
Posted in Learn Basic Excel | 6 Comments »
Friday, December 23rd, 2011
Download file: https://people.highline.edu/mgirvin/ExcelIsFun.htm
1. Learn about Proportions, Probabilities and Percentages: Formulas and Formatting.
2. See the COUNTIF function and Relative and Absolute Cell References for counting with 1 criteria
3. See how to create a Basic Frequency Table with Qualitative Data including a Relative or Percent Frequency column with Percentage Number Format.
This is for the Highline Community College Busn 210 Statistical Analysis for Business and Economics taught by Michael Girvin.
Duration : 0:10:31
(more…)
Technorati Tags: 2010, 210, Absolute, analysis, AND, Basic, business, Busn, cell, College, Community, COUNTIF, counting, criteria, data, Dragons, Economics, excel, excelisfun, for, Format, Formatting, formulas, FREQUENCY, function, Gel, Girvin, Highline, Including, Mike, Number, Percentages, Probabilities, Proportions, Qualitative, References, Relative, Slaying, Statistical, Statistics, table, with
Tags: 2010, 210, Absolute, analysis, AND, Basic, business, Busn, cell, College, Community, COUNTIF, counting, criteria, data, Dragons, Economics, excel, excelisfun, for, Format, Formatting, formulas, FREQUENCY, function, Gel, Girvin, Highline, Including, Mike, Number, Percentages, Probabilities, Proportions, Qualitative, References, Relative, Slaying, Statistical, Statistics, table, with
Posted in Learn Basic Excel | 4 Comments »
This video will show you the new look and features of Excel 2007 so you can make the decision to upgrade from Office 2003 to 2007. 
Example Of Using Excel Depreciation Function in Access Query
Excel Formulas Urdu Tutorials – Part 3 – by Irfan Wazir Ali
Saturday, December 31st, 2011Duration : 0:14:0
(more…)
Technorati Tags: Ali, analysis, by, cellphones, commentary, computers, creature, cybersecurity, defense, diy, downloads, economy, Educational, electronics, environment, excel, finance, financial, formulas, hacking, hacks, howto, instructions, Irfan, medicine, Money, music charts, Part, programs, repair, smart phones, software, technology, tutorial, tutorials, Urdu, video game, vlog, Wazir
Tags: Ali, analysis, by, cellphones, commentary, computers, creature, cybersecurity, defense, diy, downloads, economy, Educational, electronics, environment, excel, finance, financial, formulas, hacking, hacks, howto, instructions, Irfan, medicine, Money, music charts, Part, programs, repair, smart phones, software, technology, tutorial, tutorials, Urdu, video game, vlog, Wazir
Posted in Learn Excel Formulas | 5 Comments »