Marvin's Underground Lectures
Welcome
Login / Register

Microsoft Excel


  • 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

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

  • 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

  • 44:23 Patrick Hudak   CA63B  Intermediate Microsoft Excel 11262012

    Patrick Hudak CA63B Intermediate Microsoft Excel 11262012

    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

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

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