Posts Tagged ‘make’

Excel Busn Math 60: Future Value Annuities FV & PMT function

Friday, October 7th, 2011

See how to use the Excel functions FV and PMT to make a future value calculation for an annuity.

This is a Highline Community College Business Math Class, Busn 135, taught by Mike Gel excelisfun Girvin

Duration : 0:20:3

(more…)

Technorati Tags: , , , , , , , , , , , , , , , ,

Excel Basic Series #3: Creating Marklist using Sum Average and Rank

Sunday, July 31st, 2011

This is the channel teaches the excel in tamil.
In this video
You could learn how to make marklist along with these function include
SUM, AVERAGE, RANK.

Duration : 0:7:57

(more…)

Technorati Tags: , , , , , , , , , , , , ,

HTML Tutorial 1 – Designing A Website In Notepad – Basics and Beginnings

Monday, December 27th, 2010

In this HTML website design tutorial I will teach you how to write and format your very first web page using HTML.

Difficulty Level:
Easy/Beginner

If you have any problems or need help with any of this tutorial please leave a comment below or message me on YouTube.

Duration : 0:6:32

(more…)

Technorati Tags: , , , , , , , , , , , , , , , , , , , ,

Excel Magic Trick 712: Formula To Take Data in Column and Make Proper Table For Name and E-mail

Tuesday, September 14th, 2010

Take bad data set up in one column and make a proper table of data for mail merge. See how to extract name and e-mail data from a list in one column where records are entered inconsistently. See the INDEX, SMALL, ROW, ROWS, COUNTIF, SEARCH, INSNUMBER and IF functions in a 2 formulas and 2 array formulas.

Download file: http://people.highline.edu/mgirvin/ExcelIsFun.htm

Duration : 0:12:12

(more…)

Technorati Tags: , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , ,

Completely hide the Ribbon in Excel 2007 – Macro

Monday, September 6th, 2010

http://www.TeachExcel.com

This tutorial will show you how to completely hide the Ribbon menu system for Excel 2007. The tutorial will also show you a quick way to partially hide the Ribbon menu system in Excel 2007.

In order to completely hide the Ribbon, you will need to write a macro, which is explained in detail in the video. This is a really neat trick to use in Excel when you want the Ribbon, the Office button, and the Mini toolbar to be completely gone.

To get the spreadsheet used here of for more excel video tutorials, macros, tips and tricks, visit the website http://www.TeachExcel.com You can also visit the forum there if you have any questions.

Have a great day!

Duration : 0:6:32

(more…)

Technorati Tags: , , , , , , , , , , , , , , , , , ,

Excel 2003 Tutorial Cutting Copying and Pasting Data Using Drag and Drop Microsoft Training Lesson 5.4

Tuesday, August 31st, 2010

Learn how to cut, copy or paste data using drag and drop in Microsoft Excel at www.teachUcomp.com. A clip from Mastering Excel Made Easy v. 2003. http://www.teachucomp.com/tutorexmain.htm – the most comprehensive Excel tutorial available. Visit us today!

Duration : 0:2:27

(more…)

Technorati Tags: , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , ,

Excel Tutorial Writing Formulas Microsoft Training Lesson 4.3

Monday, August 30th, 2010

Learn how to write a formula in Microsoft Excel at www.teachUcomp.com. A clip from Mastering Excel Made Easy v. 2007. http://www.teachucomp.com/tutorexmain.htm – the most comprehensive Excel tutorial available. Visit us today!

Duration : 0:7:6

(more…)

Technorati Tags: , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , ,

VLOOKUP Introduction, Explanation, Example in Excel (2 of 2)

Monday, August 30th, 2010

http://www.TeachMsOffice.com
Part 2 of 2
Here, I explain what the VLOOKUP() function in excel is; what it does; and how it can be useful for you. Note, this is an introduction to the vlookup function and does not cover anything advanced. It will serve to give you a good understanding of how it works and how to use it.

Follow along with the excel spreadsheet used in the tutorial by downloading it at my website. Just navigate to the tutorials section and from there the formulas section:

http://www.ExcelisHell.com

Duration : 0:4:23

(more…)

Technorati Tags: , , , , , , , , , , , , , ,

Excel Tutorial Creating Pivot Tables Microsoft Training Lesson 22.1

Monday, August 30th, 2010

Learn how to create a PivotTable in Microsoft Excel at www.teachUcomp.com. A clip from Mastering Excel Made Easy v. 2007. http://www.teachucomp.com/tutorexmain.htm – the most comprehensive Excel tutorial available. Visit us today!

Duration : 0:4:53

(more…)

Technorati Tags: , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , ,

Excel 2003 Tutorial Lookup Functions Microsoft Training Lesson 30.2

Sunday, August 29th, 2010

Learn how to use lookup functions in Microsoft Excel at www.teachUcomp.com. A clip from Mastering Excel Made Easy v. 2003. http://www.teachucomp.com/tutorexmain.htm – the most comprehensive Excel tutorial available. Visit us today!

Duration : 0:4:54

(more…)

Technorati Tags: , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , ,