Marvin's Underground Lectures
Welcome
Login / Register

Microsoft Excel


  • 45:31 Patrick Hudak   CA63B  Intermediate Microsoft Excel 11052012

    Patrick Hudak CA63B Intermediate Microsoft Excel 11052012

    by Admin Added 21 Views / 0 Likes

    Go to the next professional and personal step using Excel. Learn Excel featuresthat are used in decision-making. Experiment with scenarios, data lookups, goalseek, solver, pivot-table charts and graphs, and more. Create macros to automateExcel tasks. Crea

  • 03:09 Patrick Hudak   CA63B  Intermediate Microsoft Excel 11132012

    Patrick Hudak CA63B Intermediate Microsoft Excel 11132012

    by Admin Added 21 Views / 0 Likes

    Go to the next professional and personal step using Excel. Learn Excel featuresthat are used in decision-making. Experiment with scenarios, data lookups, goalseek, solver, pivot-table charts and graphs, and more. Create macros to automateExcel tasks. Crea

  • 59:22 Rhoda James   Office Technology   OFF 120   Excel Spreadsheet  06 24 2013

    Rhoda James Office Technology OFF 120 Excel Spreadsheet 06 24 2013

    by Admin Added 21 Views / 0 Likes

    An Excel worksheets and workbooks course to include: formatting,calculating sums, formulas, charts, enhancing the worksheet, andmaking decisions using the IF function, completing financial functions,data lists, large workbooks using templates, using advan

  • 31:17 Microsoft Excel Financial Functions

    Microsoft Excel Financial Functions

    by Admin Added 21 Views / 0 Likes

    In this video learn to use built-in Excel Financial Functions. Learn to use Present Value (PV), Future Value (FV), PMT, IPMT, PPMT, NPER, RATE and RRI functions. Link to sample file: http://simpletek.ca/files/excel-2013-files/

  • 30:18 Microsoft Excel 2013 LOOKUP and Reference Functions

    Microsoft Excel 2013 LOOKUP and Reference Functions

    by Admin Added 20 Views / 0 Likes

    Lynette Mann explains the LOOKUP and reference functions in Microsoft Excel 2013. The LOOKUP function finds a value in a single row or column and matches it with a value in the same position in a different row or column. HLOOKUP and VLOOKUP are used for r

  • 1:01:35 Excel 2010 Data Tools

    Excel 2010 Data Tools

    by Admin Added 20 Views / 0 Likes

    Lynette Mann teaches the data tools in Microsoft Excel 2010, including Consolidate, Data Tables (One- and Two- Variable), Goal Seek, Data Validation, and Scenario Manager.

  • 41:41 Patrick Hudak   CA63B  Intermediate Microsoft Excel 12032012

    Patrick Hudak CA63B Intermediate Microsoft Excel 12032012

    by Admin Added 20 Views / 0 Likes

    Go to the next professional and personal step using Excel. Learn Excel featuresthat are used in decision-making. Experiment with scenarios, data lookups, goalseek, solver, pivot-table charts and graphs, and more. Create macros to automateExcel tasks. Crea

  • 14:29 Microsoft Excel 2003 Basic 3 (Auto sum, fill handle, format text)

    Microsoft Excel 2003 Basic 3 (Auto sum, fill handle, format text)

    by Admin Added 20 Views / 0 Likes

    Learn to use auto summation, summation of 2 separate range, Fill handle, Formatting text like Merge&Center, Wrap text, putting text at an angle

  • 39:44 Microsoft Excel 2007 2010 pt 1 (Enter/Edit cell, Formulas, Functions, Fill Handle...)

    Microsoft Excel 2007 2010 pt 1 (Enter/Edit cell, Formulas, Functions, Fill Handle...)

    by Admin Added 19 Views / 0 Likes

    In this video learn the basics of Microsoft Excel in Office 2010, which is similar to Office 2007 with a few differences. Learn to enter/edit cells, basic formulas, understand order of operations, functions, fill handle, page setup&printing.

  • 13:21 Microsoft Excel 2003 Basic 5 (If function, Conditional Formatting, Absolute Reference)

    Microsoft Excel 2003 Basic 5 (If function, Conditional Formatting, Absolute Reference)

    by Admin Added 18 Views / 0 Likes

    5th video in series on Excel Basic. In this video understand copy&paste special, If function, Conditional Formating, Absolute reference.

  • 16:16 Microsoft Excel 2010 Data Tables

    Microsoft Excel 2010 Data Tables

    by Admin Added 17 Views / 0 Likes

    Lynette Mann describes the use of Data Tables in Microsoft Excel 2010. A data table is a range of cells in which the user can change values in some in some of the cells and come up with different answers to a problem. A one-variable data table allows the

  • 17:06 Microsoft Excel 2007 2010 pt 4 (Conditional Format, If Function, Copy/Paste)

    Microsoft Excel 2007 2010 pt 4 (Conditional Format, If Function, Copy/Paste)

    by Admin Added 17 Views / 0 Likes

    Learn to use Conditional formatting, If function and copy/paste in Excel. Also learn to use If Function with Absolute Reference. Copy&Paste Values or Paste Link. Copy and Paste information from Excel to Word, using regular paste and a paste link.

  • 15:23 Microsoft Excel 2013 Logical (Boolean) Functions

    Microsoft Excel 2013 Logical (Boolean) Functions

    by Admin Added 15 Views / 0 Likes

    Lynette Mann explains the use of Boolean logical operators in Excel 2013. Not only can users use an expression to match records, but they can combine expressions using the And, OR, NOT, and XOR operators.

  • 23:42 Microsoft Excel 2003 pt 7 (Sort, Filter, Pivot table, Vlookup, Concatenate....)

    Microsoft Excel 2003 pt 7 (Sort, Filter, Pivot table, Vlookup, Concatenate....)

    by Admin Added 15 Views / 0 Likes

    Click here for the sample file http://simpletek.ca/files/ In this video learn to use Database functionality in Excel with Sort, Filter, Freeze pane, and enter info as Form. Also learn to split screen and view 2 worksheets side by side. Learn to create piv

  • 11:22 Microsoft Excel 2010: Data Validation

    Microsoft Excel 2010: Data Validation

    by Admin Added 14 Views / 0 Likes

    Lynnette Mann demonstrates how Data Validation works with Microsoft Excel 2010. Data validation allows the user to set rules or restrictions on the type of data permitted to be entered in a cell or range of cells. The video demonstrates how to apply a val

  • 1:06:54 Patrick Hudak   CA62B  Introduction to MS Excel 09052012

    Patrick Hudak CA62B Introduction to MS Excel 09052012

    by Admin Added 14 Views / 0 Likes

    This is an introduction to Excel. The course covers Excel basics, formulas,functions, charts, and formatting. Students create 3-D bar charts, use loanamortization functions, and setup print options.

  • 51:49 Patrick Hudak   CA63B  Intermediate Microsoft Excel 11142012

    Patrick Hudak CA63B Intermediate Microsoft Excel 11142012

    by Admin Added 14 Views / 0 Likes

    Go to the next professional and personal step using Excel. Learn Excel featuresthat are used in decision-making. Experiment with scenarios, data lookups, goalseek, solver, pivot-table charts and graphs, and more. Create macros to automateExcel tasks. Crea

  • 1:40:45 Microsoft Excel 2007 Advanced Features

    Microsoft Excel 2007 Advanced Features

    by Admin Added 14 Views / 0 Likes

    Tutorial for Microsoft Excel 2007 covering some of the advanced features in the application.

  • 1:01:53 Excel 2010   Data Tools

    Excel 2010 Data Tools

    by Admin Added 13 Views / 0 Likes

  • 1:15:10 Excel 2013 Functions

    Excel 2013 Functions

    by Admin Added 13 Views / 0 Likes

  • 18:47 Microsoft Excel 2013 Financial Functions

    Microsoft Excel 2013 Financial Functions

    by Admin Added 13 Views / 0 Likes

    Lynette Mann explains the financial functions (as opposed to formulas) in Microsoft Excel 2013. These functions perform many of the commonly used financial calculations, such as the calculation of yield, interest rates, investment valuations, internal rat

  • 10:16 Microsoft Excel 2010: Goal Seek

    Microsoft Excel 2010: Goal Seek

    by Admin Added 13 Views / 0 Likes

    Lynnette Mann demonstrates how Goal Seek works with Microsoft Excel 2010. Goal Seek is used to find an input value knowing the desired result from a formula. It is a "What-if" analysis tool which, given the results desired, finds the input needed to make

  • 36:06 Patrick Hudak   CA63B  Intermediate Microsoft Excel 11192012

    Patrick Hudak CA63B Intermediate Microsoft Excel 11192012

    by Admin Added 13 Views / 0 Likes

    Go to the next professional and personal step using Excel. Learn Excel featuresthat are used in decision-making. Experiment with scenarios, data lookups, goalseek, solver, pivot-table charts and graphs, and more. Create macros to automateExcel tasks. Crea

  • 10:24 Microsoft Excel 2013 IF Functions

    Microsoft Excel 2013 IF Functions

    by Admin Added 12 Views / 0 Likes

    Lynnette Mann explains the IF function in Microsoft Excel 2013. The IF function returns one value if a condition you specify evaluates to TRUE, and another value if that condition evaluates to FALSE.

Categories

| Kids Playground | Events Schedule |Image Galleries | Games | Radios |Animations | Chat | Classifieds | Blog Post | Free Content | News
Copyright @ 2005-2006 Marvin A. Hendricks Inc. All Rights Reserved