Posts Tagged ‘make’
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: annuity, business, Calculation, College, Community, excel, functions, future, FV, Gel, Girvin, Highline, make, math, Mike, pmt, value
Tags: annuity, business, Calculation, College, Community, excel, functions, future, FV, Gel, Girvin, Highline, make, math, Mike, pmt, value
Posted in Learn Excel Formulas | 4 Comments »
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: AVERAGE, channel, excel, in, inside, make, marklist, Names, Rank, spreadsheet, SUM, tamil, Total, ultimate
Tags: AVERAGE, channel, excel, in, inside, make, marklist, Names, Rank, spreadsheet, SUM, tamil, Total, ultimate
Posted in Learn Basic Excel | No Comments »
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: Basic, Beginning, design, develop, document, first, how, howto, HTML, layout, learn, make, programming, Site, teach, to, tut, tutor, tutorial, web, Website
Tags: Basic, Beginning, design, develop, document, first, how, howto, HTML, layout, learn, make, programming, Site, teach, to, tut, tutor, tutorial, web, Website
Posted in Learn Basic Excel | 25 Comments »
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: 2007, 2010, AND, array, Bad, College, column, Community, COUNTIF, data, Dragons, excel, excelisfun, for, formula, formulas, functions, Gel, Girvin, Highline, IF, in, INDEX, INSNUMBER, Mail, make, merge, Mike, Proper, row, ROWS, Search, Set, Slaying, SMALL, table, Take, the, up
Tags: 2007, 2010, AND, array, Bad, College, column, Community, COUNTIF, data, Dragons, excel, excelisfun, for, formula, formulas, functions, Gel, Girvin, Highline, IF, in, INDEX, INSNUMBER, Mail, make, merge, Mike, Proper, row, ROWS, Search, Set, Slaying, SMALL, table, Take, the, up
Posted in Learn Excel Formulas | 3 Comments »
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: 2007, away, classes, completely, excel, go, Help, hide, Macro, make, menu, Microsoft, partially, Ribbon, system, the, tips, tricks, tutorials
Tags: 2007, away, classes, completely, excel, go, Help, hide, Macro, make, menu, Microsoft, partially, Ribbon, system, the, tips, tricks, tutorials
Posted in Learn Excel Macros | 3 Comments »
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: 2000, 2002, 2003, 97, book, cd, class, classes, Copy, copying, course, courses, cut, cutting, data, Download, drag, Drop, dvd, excel, excell, full, goal, group, Guide, headings, height, Help, hide, hiding, highlighting, HLOOKUP, how, how to, Insert, inserting, keyboard, label, labels, layout, learn, line, lines, linked, List, location, Lookup, make, making, manager, managing, manual, merge, Micro, Microsoft, mini, move, moving, ms, Multiple, named, naming, new, Number, numbers, office, online, paste, pasting, Soft, software, training, tutorial, use, using, video, xp
Tags: 2000, 2002, 2003, 97, book, cd, class, classes, Copy, copying, course, courses, cut, cutting, data, Download, drag, Drop, dvd, excel, excell, full, goal, group, Guide, headings, height, Help, hide, hiding, highlighting, HLOOKUP, how, how to, Insert, inserting, keyboard, label, labels, layout, learn, line, lines, linked, List, location, Lookup, make, making, manager, managing, manual, merge, Micro, Microsoft, mini, move, moving, ms, Multiple, named, naming, new, Number, numbers, office, online, paste, pasting, Soft, software, training, tutorial, use, using, video, xp
Posted in Learn Excel Formulas | 1 Comment »
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: 2000, 2002, 2003, 2007, 97, book, cd, class, classes, course, courses, Download, dvd, excel, excell, formula, formulas, height, Help, hide, hiding, highlighting, HLOOKUP, how, how to, Insert, inserting, keyboard, label, labels, layout, learn, line, lines, linked, List, location, Lookup, make, making, manager, managing, manual, merge, Micro, Microsoft, mini, move, moving, ms, Multiple, named, naming, new, Number, numbers, objects, office, online, opening, options, orders, outlines, outlining, page, Soft, software, training, tutorial, video, write, writing, xp
Tags: 2000, 2002, 2003, 2007, 97, book, cd, class, classes, course, courses, Download, dvd, excel, excell, formula, formulas, height, Help, hide, hiding, highlighting, HLOOKUP, how, how to, Insert, inserting, keyboard, label, labels, layout, learn, line, lines, linked, List, location, Lookup, make, making, manager, managing, manual, merge, Micro, Microsoft, mini, move, moving, ms, Multiple, named, naming, new, Number, numbers, objects, office, online, opening, options, orders, outlines, outlining, page, Soft, software, training, tutorial, video, write, writing, xp
Posted in Learn Excel Formulas | 1 Comment »
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: COLUMNS, edit, excel, formulas, functions, HLOOKUP, how, introduction, looking, make, ROWS, to, use, vlookups, write
Tags: COLUMNS, edit, excel, formulas, functions, HLOOKUP, how, introduction, looking, make, ROWS, to, use, vlookups, write
Posted in Learn Excel Formulas | 8 Comments »
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: 2000, 2002, 2003, 2007, 97, book, cd, class, classes, course, courses, Create, Creating, Download, dvd, excel, excell, files, filter, filtered, filtering, filters, find, finding, formats, full, goal, group, Guide, headings, height, Help, hide, hiding, highlighting, HLOOKUP, how, how to, Insert, inserting, keyboard, label, labels, layout, learn, line, lines, linked, List, location, Lookup, make, making, manager, managing, manual, Micro, Microsoft, ms, office, online, Pivot, pivottable, pivottables, Soft, software, table, tables, training, tutorial, video, xp
Tags: 2000, 2002, 2003, 2007, 97, book, cd, class, classes, course, courses, Create, Creating, Download, dvd, excel, excell, files, filter, filtered, filtering, filters, find, finding, formats, full, goal, group, Guide, headings, height, Help, hide, hiding, highlighting, HLOOKUP, how, how to, Insert, inserting, keyboard, label, labels, layout, learn, line, lines, linked, List, location, Lookup, make, making, manager, managing, manual, Micro, Microsoft, ms, office, online, Pivot, pivottable, pivottables, Soft, software, table, tables, training, tutorial, video, xp
Posted in Learn Excel Formulas | 2 Comments »
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: 2000, 2002, 2003, 97, book, cd, class, classes, course, courses, Download, dvd, excel, excell, function, functions, HLOOKUP, how, how to, labels, layout, learn, line, lines, linked, List, location, look, Lookup, make, making, manager, managing, manual, merge, Micro, Microsoft, mini, move, moving, ms, Multiple, named, naming, new, Number, numbers, objects, office, online, opening, options, orders, outlines, outlining, page, password, paste, pasting, personal, pick, pivotcharts, precedent, Soft, software, training, tutorial, up, use, using, video, vlookup, xp
Tags: 2000, 2002, 2003, 97, book, cd, class, classes, course, courses, Download, dvd, excel, excell, function, functions, HLOOKUP, how, how to, labels, layout, learn, line, lines, linked, List, location, look, Lookup, make, making, manager, managing, manual, merge, Micro, Microsoft, mini, move, moving, ms, Multiple, named, naming, new, Number, numbers, objects, office, online, opening, options, orders, outlines, outlining, page, password, paste, pasting, personal, pick, pivotcharts, precedent, Soft, software, training, tutorial, up, use, using, video, vlookup, xp
Posted in Learn Excel Formulas | 6 Comments »