﻿ Microsoft Excel Videos
Welcome

# Microsoft Excel

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

• 21:37

### Microsoft Excel 2013 pt 9 (Pie/Column Chart, Pivot Table)

Link to sample file: http://simpletek.ca/files/excel-2013-files/ In this tutorial learn to create Pie and Column Chart. And also learn to create Pivot Table.

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

• 14:41

### Microsoft Excel 2007 2010 pt 2.(Pie/Column Chart and Chart Tools)

In this video learn to create Pie&Column chart. Understand the various buttons available under Chart Tools to change Colours, layout and data.

• 09:12

• 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

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

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

• 38:43

### Microsoft Excel 2007/2010 Exam Q&A pt 1

Click on the link to download file practice file http://simpletek.ca/files/Pt 2: https://www.youtube.com/watch?v=SBnBO-BFrx0A quick recap of important Q&A for preparing to take an Excel 2007 computer test. Learn all the basics of saving, opening, password

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

• 13:42

### Microsoft Excel 2003 Basic 6 (Pie, Column Chart)

Learn to make Pie and Column chart in Excel 2003

• 13:29

### Microsoft Excel 2013 pt 3 (Fill Handle Formula, sample exercise)

In this tutorial learn to use Fill Handle to copy formulas. And practice 2 sample excel exercises.

• 09:39

### MS Excel 2003 Basic 1 (Enter, Edit, basic calculations/formula)

Understand parts of Microsoft Excel 2003. Learn to Enter and Edit cells, and basic calculations.

• 15:40

### Microsoft Excel 2007 2010 pt 3 (Name Ranges, Absolute References, Insert/Delete Rows, Format..)

Learn to Name a Range and use it in calculation, absolute references, inserting rows&columns and some formatting features of excel. Look at Print Preview. Add Borders, Gridlines. Put words in various orientation like Vertical or at an angle. Add \$ symbol

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

• 16:30

### Microsoft Excel 2013 pt 10 (Conditional format, Sparklines, other Charts)

In this video learn about using Conditional Format and adding Sparklines to data. Also learn about other types of Charts like Stock, Surface, Donut and Bubble. Link to Sample file: http://simpletek.ca/files/excel-2013-files

• 09:49

### Microsoft Excel 2013 pt 4 (Page Setup, Header/Footer, Repeat Row)

In this video learn about Page setup - Margins, Orientation, Scaling, Gridlines. Also learn about Header/Footer and how to repeat Rows on all Printed Page

• 25:22

### Microsoft Excel 2013 pt 5 (Format, Insert/Delete, Concatenate, Text to Column)

In this tutorial learn about Formatting features of Excel like: Merge&Center, Text Orientation, Wrap Text, Shrink in Cell. Learn to set Cells for Negative Numbers, Date, Telephone numbers. Format the the Column width and Row Height. Insert/Delete Cells, R

• 09:58

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

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

• 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

• 18:32

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

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

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

• 31:17