Posts Tagged ‘paste’
Thursday, December 1st, 2011
Download file: https://people.highline.edu/mgirvin/ExcelIsFun.htm
1. Create Defined Names using Name Box or Name Manager
2. Edit Defined Names
3. Create Names From Selection
4. Apply Names to Formulas
5. Paste List Of Names
6. Keyboard Shortcuts
Duration : 0:12:21
(more…)
Technorati Tags: 2007, 2010, Apply Names to Formulas, box, College, Community, Create, Create Names From Selection, Defined, Dragons, edit, excel, excelisfun, Gel, Girvin, Highline, keyboard, List, manager, Mike, name, Names, of, OR, paste, shortcuts, Slaying, using
Tags: 2007, 2010, Apply Names to Formulas, box, College, Community, Create, Create Names From Selection, Defined, Dragons, edit, excel, excelisfun, Gel, Girvin, Highline, keyboard, List, manager, Mike, name, Names, of, OR, paste, shortcuts, Slaying, using
Posted in Learn Excel Formulas | 11 Comments »
Monday, August 8th, 2011
Learn how to use IF AND and OR functions 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:6:45
(more…)
Technorati Tags: 2000, 2002, 2003, 2007, 97, AND, book, cd, class, classes, course, courses, Download, dvd, excel, excell, function, functions, Help, how, how to, IF, merge, Micro, Microsoft, mini, move, moving, ms, Multiple, named, naming, new, Number, numbers, objects, office, online, opening, options, OR, orders, outlines, outlining, page, password, paste, pasting, personal, pick, pivotcharts, precedent, preview, print, printing, protecting, Protection, Quick, ranged, ranges, Recorded, records, redo, Reference, removing, rename, Soft, software, training, tutorial, video, xp
Tags: 2000, 2002, 2003, 2007, 97, AND, book, cd, class, classes, course, courses, Download, dvd, excel, excell, function, functions, Help, how, how to, IF, merge, Micro, Microsoft, mini, move, moving, ms, Multiple, named, naming, new, Number, numbers, objects, office, online, opening, options, OR, orders, outlines, outlining, page, password, paste, pasting, personal, pick, pivotcharts, precedent, preview, print, printing, protecting, Protection, Quick, ranged, ranges, Recorded, records, redo, Reference, removing, rename, Soft, software, training, tutorial, video, xp
Posted in Learn Excel Formulas | 2 Comments »
Friday, July 1st, 2011
The Excel 2010 Basics Series shows a systematic description of what Excel can do from beginning to end.
Download files at: https://people.highline.edu/mgirvin/AllClasses/216_2003/216/busn216.htm
1. Topics Covered In Video:
2. Functions:
3. SUM (add)
4. COUNT (Count Numbers)
5. COUNTA (Count non-blank cells)
6. MIN (minimum value)
7. MAX (maximum value)
8. COUNTIF (count with a condition or criteria)
9. SUMIF (Sum with a condition or criteria)
10. STDEVP (standard deviation for the population)
11. Compatibility functions
12. How to name a range of cells using Defined Names Feature
13. Insert Function keyboard = Shift + F3
14. Paste Name keyboard = F3
15. Name Manager keyboard = Ctrl + F3
16. Create Names From Selection keyboard = Ctrl + Shift + F3
17. Use Defined Names in formulas
18. Learn about Name Manager
Duration : 0:22:32
(more…)
Technorati Tags: 2010, 216, applications, Busn, class, College, Community, Compatibility, computer, count(), counta(), COUNTIF, Create, Defined, excel, excelisfun, feature, formulas, From, functions, Gel, Girvin, Highline, in, keyboard, manager, Max, Mike, Min, name, Names, office, paste, Selection, STDEVP, SUM, SumIF
Tags: 2010, 216, applications, Busn, class, College, Community, Compatibility, computer, count(), counta(), COUNTIF, Create, Defined, excel, excelisfun, feature, formulas, From, functions, Gel, Girvin, Highline, in, keyboard, manager, Max, Mike, Min, name, Names, office, paste, Selection, STDEVP, SUM, SumIF
Posted in Learn Excel Formulas | 4 Comments »
Friday, July 1st, 2011
Download workbook: http://people.highline.edu/mgirvin/ExcelIsFun.htm (all the way at bottom in “Other Excel Series” section)
Highline Community College Science Seminar: The Wonders Of Excel, May 20, 2011
Learn about the wonders of what excel can do with a tour of the different things that Excel can do:
1 Copy & Paste Special (2 Examples) (00:48 minute mark)
2 Keyboard Magic (3 Examples) (03:45 minute mark)
3 Number Format (06:03 minute mark)
4 Decimal (6:11 minute mark)
5 Date (5 Examples) (07:32 minute mark)
6 Percentage (15:02 minute mark)
7 Formulas and Relative Cell References (18:26 minute mark)
8 Formulas and Absolute Cell References (2 Examples) (21:47 minute mark)
9 Sorting (4 Examples) (27:27 minute mark)
10 Filtering (32:27 minute mark)
11 PivotTables (2 Examples) (35:19 minute mark)
12 Charts (6 Examples) (43:31 minute mark)
Duration : 0:55:5
(more…)
Technorati Tags: 20, 2010, 2011, Absolute, AND, cell, charts, College, Community, Copy, Date, Decimal, excel, excelisfun, filtering, Format, formulas, Gel, Girvin, Highline, keyboard, Magic, May, Mike, Number, of, paste, percentage, Pivot, pivotcharts, pivottables, References, Relative, science, Seminar, Sorting, Special, table, the, Wonders
Tags: 20, 2010, 2011, Absolute, AND, cell, charts, College, Community, Copy, Date, Decimal, excel, excelisfun, filtering, Format, formulas, Gel, Girvin, Highline, keyboard, Magic, May, Mike, Number, of, paste, percentage, Pivot, pivotcharts, pivottables, References, Relative, science, Seminar, Sorting, Special, table, the, Wonders
Posted in Learn Excel Formulas | 19 Comments »
Monday, March 21st, 2011
Add Dot Com To End Of Column Of Words:
1) Excel Formula with Ampersand, &, and text in quotes (Double Quotes)
2) Copy
3) Paste Special Values
Duration : 0:0:35
(more…)
Technorati Tags: 2003, 2007, 2010, Ampersand, AND, College, Community, Copy, Double, Dragons, excel, formula, Girvin, Highline, in, Mike, paste, quotes, Slaying, Special, text, values, with
Tags: 2003, 2007, 2010, Ampersand, AND, College, Community, Copy, Double, Dragons, excel, formula, Girvin, Highline, in, Mike, paste, quotes, Slaying, Special, text, values, with
Posted in Learn Excel Formulas | 1 Comment »
Monday, September 6th, 2010
Topics for this video:
1)Learn about the functions: ROUND, ROUNDDOWN, ROUNDUP, INT, CEILING and FLOOR
2)Learn about Paste Special Values and Formulas and Operations and Transpose and Skip Blanks
3)Freeze Panes
4)Percentage Change or Rate of Change: End/Beg 1
5)Goal Seek
This is a beginning to advanced Excel class taught at Highline Community College by Mike Gel excelisfun Girvin Busn 214 BTech 109
Duration : 0:25:17
(more…)
Technorati Tags: Ceiling, College, Community, excel, excelisfun, FOOLR, Freeze, Gel, Girvin, goal, Highline, Mike, Pane, paste, Round, Seek, Special
Tags: Ceiling, College, Community, excel, excelisfun, FOOLR, Freeze, Gel, Girvin, goal, Highline, Mike, Pane, paste, Round, Seek, Special
Posted in Learn Basic Excel | 18 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 »
Sunday, August 29th, 2010
Continuing the Microsoft Excel series of tutorials for beginners. In part 4 you will learn about creating basic functions in Excel and using the Paste Function feature. Hope you find this useful!
Duration : 0:7:57
(more…)
Technorati Tags: Beginners, calculations, computer, excel, function, functions, Guide, Help, Microsoft, ms, paste, spreadsheet, technology, tutorial
Tags: Beginners, calculations, computer, excel, function, functions, Guide, Help, Microsoft, ms, paste, spreadsheet, technology, tutorial
Posted in Learn Basic Excel | 25 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 »
