Marvin's Underground Lectures
Welcome
Login / Register

Microsoft Excel


  • 03:09 Patrick Hudak   CA63B  Intermediate Microsoft Excel 11132012

    Patrick Hudak CA63B Intermediate Microsoft Excel 11132012

    by Admin Added 29 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

  • 15:40 Microsoft Excel 2010 Scenario Manager

    Microsoft Excel 2010 Scenario Manager

    by Admin Added 28 Views / 0 Likes

    Lynette Mann describes the Scenario Manager in Microsoft Excel 2010. Scenario Manager can save different sets of data and automatically substitute into the workbook to display different results. Two different examples are used to create different scenario

  • 1:01:35 Excel 2010 Data Tools

    Excel 2010 Data Tools

    by Admin Added 28 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.

  • 44:23 Patrick Hudak   CA63B  Intermediate Microsoft Excel 11262012

    Patrick Hudak CA63B Intermediate Microsoft Excel 11262012

    by Admin Added 28 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 28 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

  • 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 28 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

  • 16:16 Microsoft Excel 2010 Data Tables

    Microsoft Excel 2010 Data Tables

    by Admin Added 27 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

  • 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 27 Views / 0 Likes

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

  • 1:03:27 Patrick Hudak   CA63B  Intermediate Microsoft Excel 10222012

    Patrick Hudak CA63B Intermediate Microsoft Excel 10222012

    by Admin Added 26 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

  • 45:31 Patrick Hudak   CA63B  Intermediate Microsoft Excel 11052012

    Patrick Hudak CA63B Intermediate Microsoft Excel 11052012

    by Admin Added 25 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

  • 41:41 Patrick Hudak   CA63B  Intermediate Microsoft Excel 12032012

    Patrick Hudak CA63B Intermediate Microsoft Excel 12032012

    by Admin Added 24 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

  • 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 24 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 22 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.

  • 11:22 Microsoft Excel 2010: Data Validation

    Microsoft Excel 2010: Data Validation

    by Admin Added 21 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

  • 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 21 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

  • 1:01:53 Excel 2010   Data Tools

    Excel 2010 Data Tools

    by Admin Added 19 Views / 0 Likes

  • 18:47 Microsoft Excel 2013 Financial Functions

    Microsoft Excel 2013 Financial Functions

    by Admin Added 19 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

  • 1:40:45 Microsoft Excel 2007 Advanced Features

    Microsoft Excel 2007 Advanced Features

    by Admin Added 19 Views / 0 Likes

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

  • 1:15:10 Excel 2013 Functions

    Excel 2013 Functions

    by Admin Added 18 Views / 0 Likes

  • 10:24 Microsoft Excel 2013 IF Functions

    Microsoft Excel 2013 IF Functions

    by Admin Added 18 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.

  • 10:16 Microsoft Excel 2010: Goal Seek

    Microsoft Excel 2010: Goal Seek

    by Admin Added 18 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

  • 51:49 Patrick Hudak   CA63B  Intermediate Microsoft Excel 11142012

    Patrick Hudak CA63B Intermediate Microsoft Excel 11142012

    by Admin Added 17 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

  • 20:28 Excel and Word 2003 q&a from testing programs

    Excel and Word 2003 q&a from testing programs

    by Admin Added 17 Views / 0 Likes

    Excel Repeat rows, format negative numbers, copy formula paste values, Email workbook, create custom list, countif, concatenate,Word synonym, insert date, all caps, readability statistics, save as text, password to open, read-only, increase recent file li

  • 07:57 Microsoft Excel 2010: Consolidation

    Microsoft Excel 2010: Consolidation

    by Admin Added 16 Views / 0 Likes

    Lynnette Mann demonstrates how Consolidation works with Microsoft Excel 2010. Data from separate worksheets can be consolidated on a master worksheet. This makes it easier to update and aggregate it on a regular or ad hoc basis.

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