Marvin's Underground Lectures
Welcome
Login / Register

Microsoft Excel


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

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

  • 13:42 Microsoft Excel 2003 Basic 6 (Pie, Column Chart)

    Microsoft Excel 2003 Basic 6 (Pie, Column Chart)

    by Admin Added 33 Views / 0 Likes

    Learn to make Pie and Column chart in Excel 2003

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

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

    Excel and Word 2003 q&a from testing programs

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

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

  • 1:40:45 Microsoft Excel 2007 Advanced Features

    Microsoft Excel 2007 Advanced Features

    by Admin Added 15 Views / 0 Likes

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

  • 41:41 Patrick Hudak   CA63B  Intermediate Microsoft Excel 12032012

    Patrick Hudak CA63B Intermediate Microsoft Excel 12032012

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

  • 44:23 Patrick Hudak   CA63B  Intermediate Microsoft Excel 11262012

    Patrick Hudak CA63B Intermediate Microsoft Excel 11262012

    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

  • 03:09 Patrick Hudak   CA63B  Intermediate Microsoft Excel 11132012

    Patrick Hudak CA63B Intermediate Microsoft Excel 11132012

    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

  • 51:49 Patrick Hudak   CA63B  Intermediate Microsoft Excel 11142012

    Patrick Hudak CA63B Intermediate Microsoft Excel 11142012

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

  • 36:06 Patrick Hudak   CA63B  Intermediate Microsoft Excel 11192012

    Patrick Hudak CA63B Intermediate Microsoft Excel 11192012

    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

  • 45:31 Patrick Hudak   CA63B  Intermediate Microsoft Excel 11052012

    Patrick Hudak CA63B Intermediate Microsoft Excel 11052012

    by Admin Added 22 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:10:59 Patrick Hudak   CA63B  Intermediate Microsoft Excel 10292012

    Patrick Hudak CA63B Intermediate Microsoft Excel 10292012

    by Admin Added 11 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:03:27 Patrick Hudak   CA63B  Intermediate Microsoft Excel 10222012

    Patrick Hudak CA63B Intermediate Microsoft Excel 10222012

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

  • 58:53 Patrick Hudak   CA62B  Introduction to MS Excel 09192012

    Patrick Hudak CA62B Introduction to MS Excel 09192012

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

  • 50:14 Patrick Hudak   CA62B  Introduction to MS Excel 09122012

    Patrick Hudak CA62B Introduction to MS Excel 09122012

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

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

  • 1:01:35 Excel 2010 Data Tools

    Excel 2010 Data Tools

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

  • 16:16 Microsoft Excel 2010 Data Tables

    Microsoft Excel 2010 Data Tables

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

  • 15:40 Microsoft Excel 2010 Scenario Manager

    Microsoft Excel 2010 Scenario Manager

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

  • 07:57 Microsoft Excel 2010: Consolidation

    Microsoft Excel 2010: Consolidation

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

  • 11:22 Microsoft Excel 2010: Data Validation

    Microsoft Excel 2010: Data Validation

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

  • 10:16 Microsoft Excel 2010: Goal Seek

    Microsoft Excel 2010: Goal Seek

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

  • 18:47 Microsoft Excel 2013 Financial Functions

    Microsoft Excel 2013 Financial Functions

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

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