Marvin's Underground Lectures
Welcome
Login / Register

Microsoft Excel


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

    Patrick Hudak CA62B Introduction to MS Excel 09122012

    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.

  • 11:07 Microsoft Excel 2003 Basic 4 (Sample Exercise, Page setup features)

    Microsoft Excel 2003 Basic 4 (Sample Exercise, Page setup features)

    by Admin Added 35 Views / 0 Likes

    Continuing from part 3, this video has a sample exercise and looks at page setup, margins, borders, gridlines, inserting worksheet and renaming it. And header/footer.

  • 16:59 Microsoft Excel 2013 pt 8 (Sort, Filter, Freeze Row, Subtotal, Data Validation)

    Microsoft Excel 2013 pt 8 (Sort, Filter, Freeze Row, Subtotal, Data Validation)

    by Admin Added 24 Views / 0 Likes

    Link to sample file: http://simpletek.ca/files/excel-2013-files/ In this tutorial learn about Database functionality of Excel: Sort, Filter, Freeze row. Create SubTotal quickly and use Data Validation to create Drop down list and stop people from entering

  • 07:57 Microsoft Excel 2010: Consolidation

    Microsoft Excel 2010: Consolidation

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

  • 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

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

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

    Microsoft Excel 2013 Logical (Boolean) Functions

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

  • 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

  • 25:05 Microsoft Excel 2007 2010 pt 6 (Concatenate, CountIf, Vlookup, Macros...)

    Microsoft Excel 2007 2010 pt 6 (Concatenate, CountIf, Vlookup, Macros...)

    by Admin Added 26 Views / 0 Likes

    Download link to example file http://simpletek.ca/files/ In this video learn about Concatenate, Countif, Vlookup functions. Also learn to convert "Text to Column", how-to print Titles on all pages, create/use Macros and password protect your sheet.

  • 18:40 Microsoft Excel 2013 pt 2 (Formula, Functions, Fill Handle)

    Microsoft Excel 2013 pt 2 (Formula, Functions, Fill Handle)

    by Admin Added 30 Views / 0 Likes

    In this tutorial learn more about Formulas and Order of Math operations. Learn about Functions like Sum, Average, Max&Min. Learn to user multiple ranges in your calculations. And finally learn to use Fill Handle.

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

    Patrick Hudak CA62B Introduction to MS Excel 09192012

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

  • 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

  • 19:12 Microsoft Excel 2013 pt 7 (IF, SumIF, SumIFS, COUNTIF, AVERAGEIF, VLOOKUP)

    Microsoft Excel 2013 pt 7 (IF, SumIF, SumIFS, COUNTIF, AVERAGEIF, VLOOKUP)

    by Admin Added 30 Views / 0 Likes

    Link to sample file: http://simpletek.ca/files/excel-2013-files/ In this tutorial learn to use IF function followed by SumIF, SumIFS. Use Count Function and a variation of it called CountIF; in the same manner understand AverageIF. And lastly we will look

  • 15:40 Microsoft Excel 2010 Scenario Manager

    Microsoft Excel 2010 Scenario Manager

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

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

    Excel and Word 2003 q&a from testing programs

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

  • 21:06 Microsoft Excel (Goal Seek, Scenarios, Solver)

    Microsoft Excel (Goal Seek, Scenarios, Solver)

    by Admin Added 30 Views / 0 Likes

    In this video learn to use Goal Seek, Scenario Manager and Solver features of Microsoft Excel 2013. This also applies to Excel 2007&2010. Click on the link to download the sample file: http://simpletek.ca/files/excel-2013-files/

  • 10:24 Microsoft Excel 2013 IF Functions

    Microsoft Excel 2013 IF Functions

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

  • 03:09 Patrick Hudak   CA63B  Intermediate Microsoft Excel 11132012

    Patrick Hudak CA63B Intermediate Microsoft Excel 11132012

    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

  • 15:35 Microsoft Excel 2007 2010 pt 5 (Sort/Filter, Subtotal, Pivot Table)

    Microsoft Excel 2007 2010 pt 5 (Sort/Filter, Subtotal, Pivot Table)

    by Admin Added 38 Views / 0 Likes

    In this video learn about Sorting/Filtering data, Custom Sort, creating subtotal and introduction to pivot table.

  • 25:57 Microsoft Excel 2013 pt 1 (Enter/Delete/Edit cells, Save, Open, Formula)

    Microsoft Excel 2013 pt 1 (Enter/Delete/Edit cells, Save, Open, Formula)

    by Admin Added 31 Views / 0 Likes

    In this tutorial learn to use Microsoft Excel 2013 (also applies to other versions of Excel). Learn about parts of Excel. Learn to Enter, Delete and Edit Cells. Save and Open files and we will end it with a simple Formula calculations.

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

    Patrick Hudak CA63B Intermediate Microsoft Excel 10222012

    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

  • 09:58 Microsoft Excel 2003 Basic 2 (Order of operations, sum&average functions)

    Microsoft Excel 2003 Basic 2 (Order of operations, sum&average functions)

    by Admin Added 26 Views / 0 Likes

    Understand order of operation, and learn to use sum&average functions.

  • 18:32 Microsoft Excel 2013 pt 6 (Absolute Reference, Named Ranges, Copy/paste)

    Microsoft Excel 2013 pt 6 (Absolute Reference, Named Ranges, Copy/paste)

    by Admin Added 22 Views / 0 Likes

    In this tutorial learn about using Absolute reference in calculations. Apply Name to a Range and use them in a calculations. And finally learn to use Copy/Paste in Excel and also Copy&Paste information from Excel to Word; use regular Paste and also Paste

  • 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

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