﻿ Microsoft Excel Videos - 2
Welcome

# Microsoft Excel

• 50:14

### Patrick Hudak CA62B Introduction to MS Excel 09122012

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)

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)

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

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

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

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

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

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

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)

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

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)

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)

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

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 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)

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

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

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)

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)

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

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)

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

• 18:32