OMGT 4853 Video Database (MC) (2024)

1

VideoQuizSubjectTitleWeblinkExtra Credit: Click here to rate this video

Length (minutes)

Contributor

2

10011Very beginners start hereExcel 2010 Tutorial For Beginners #2 - Enter & Edit Text and Numbershttp://www.youtube.com/watch?v=pPSwbK4_GdYRATE THIS VIDEO9Excel for Beginners

3

10021Very beginners start hereEssential Formatting Trickshttp://www.youtube.com/watch?v=8FkaZSTSlDQ RATE THIS VIDEO3Shir Consulting

4

10031Very beginners start hereExcel 2010 Tutorial | Worksheets & Workbookshttp://www.youtube.com/watch?v=snf_FnsUWp4 RATE THIS VIDEO8David Murray

5

10041More for very beginnersExcel: Familiarizing yourself with functions and formulashttp://www.youtube.com/watch?v=GmuyZFLEScU RATE THIS VIDEO3Lynda.com

6

10051Add numbers in Excel Excel 2010 Tutorial For Beginners #3 - Calculation Basics & Formulas (Microsoft Excel)http://www.youtube.com/watch?v=RgvdCHjOKYg RATE THIS VIDEO13Excel for Beginners

7

10061Basic Math in Excel (Add, Subtract, Multiply, Divide)Create or Delete a Formulahttp://office.microsoft.com/en-us/excel-help/create-or-delete-a-formula-HP010342373.aspxRATE THIS VIDEO0Microsoft

8

10071Basic formatting - put commas in numbers; currency; percent; decimal placesExcel 2010 Tutorial For Beginners #6 - Number Formatshttp://www.youtube.com/watch?v=kHSXMPbCdEM&list=PLjT_MIUPIOA9ySAtvcQw1TJ0GaWKhUuJNRATE THIS VIDEO10Excel for Beginners

9

10081Basic formatting - put commas in numbers; currency; percent; decimal placesExcel 2013 tutorial: Numeric and special formattinghttp://www.youtube.com/watch?v=fDO5QQt-QmURATE THIS VIDEO6Lynda.com

10

10091Basic formatting - scientific notationIntroduction to Scientific Notationhttps://www.khanacademy.org/math/cc-eighth-grade-math/cc-8th-numbers-operations/cc-8th-scientific-notation/v/scientific-notation--oldRATE THIS VIDEO60Khan Academy

11

10101Basic formatting - scientific notationEssential Formatting Tricks (at the very end for scientific notation)http://www.youtube.com/watch?v=8FkaZSTSlDQRATE THIS VIDEO3Shir Consulting

12

10111Basic formatting - scientific notationExponents and Baseshttp://math.about.com/od/algebra1help/tp/Exponent_And_Base.htmRATE THIS VIDEO0About.com

13

10121SUMHow to add numbers in Excelhttp://www.youtube.com/watch?v=EmeRPJ5sG9oRATE THIS VIDEO6Lynda.com

14

10131PRODUCTProduct Functionhttp://www.youtube.com/watch?v=q-Jv5ccgneURATE THIS VIDEO1assyrahbianca

15

10141SUMPRODUCTExcel Magic Trick 777: SUMPRODUCT Functionhttp://www.youtube.com/watch?v=vxpeEf8MYaYRATE THIS VIDEO5ExcellsFun

16

10151Operator orderIntroduction to order of operationshttps://www.khanacademy.org/math/cc-sixth-grade-math/cc-6th-expressions-and-variables/cc-6th-order-operations/v/introduction-to-order-of-operationsRATE THIS VIDEO60Khan Academy

17

10161Operator orderOffice 2010 Class #22: Excel Formulas: Math Operators and Order Of Operationshttp://www.youtube.com/watch?v=azyi8aWIr6MRATE THIS VIDEO9ExcellsFun

18

10171Relative and Absolute Referencing, Weighted ForecastingOffice 2010 Class #25: Excel Cell References: Relative, Absolute, Mixedhttp://www.youtube.com/watch?v=yGPx94pSOP0RATE THIS VIDEO35ExcellsFun

19

10181Fill In FunctionsExcel 2007 Tutorial 3.1. Using Functionshttp://www.youtube.com/watch?v=kcOrBTc8lgQRATE THIS VIDEO8djdates

20

10191Freeze or Lock PanesHow to freeze panes in Excelhttp://www.youtube.com/watch?v=ki9bY4oLVMcRATE THIS VIDEO3Lynda.com

21

20012Multiple OperatorsExcel 2010 Business Math 14: Exponents in Excel Formulas and Formattinghttps://www.youtube.com/watch?v=9z6b9bG1gCURATE THIS VIDEO3MrExcellsFun

22

20022e (Euler's constant)Introduction to Logarithmshttp://www.mathsisfun.com/algebra/logarithms.htmlRATE THIS VIDEO0Mathisfun.com

23

2003a2Exponential function EXPNatural Logarithms with a Calculatorhttps://www.khanacademy.org/math/algebra2/logarithms-tutorial/natural_logarithm/v/natural-logarithm-with-a-calculatorRATE THIS VIDEO3Khan Academy

24

2003b2Exponential function EXPExcel - Math functions (just first four minutes)https://www.youtube.com/watch?v=LzZ3k3rKswkRATE THIS VIDEO4Jalayer Academy

25

20042LN (natural logarithm)How to Use the LN Function in Excelhttps://www.youtube.com/watch?v=v4DDPNU92tkRATE THIS VIDEO2iYogi

26

20052AVG, AVERAGEMicrosoft Documentation: Average function in Excelhttp://office.microsoft.com/en-us/excel-help/average-function-HP010342191.aspxRATE THIS VIDEO0Microsoft

27

20062Running totals / cumulative totalsExcel Cumulative Sum Formulahttps://www.youtube.com/watch?v=-muM3klpNFERATE THIS VIDEO4Aldo Mencaraglia

28

20072Percentage error measurementCalculating percentages in Excel 2010https://www.youtube.com/watch?v=oD0QZIGYkkIRATE THIS VIDEO4Sali Kaceli

29

20082Mean, stdevMicrosoft Documentation: Stdev function in Excelhttp://office.microsoft.com/en-us/excel-help/stdev-function-HP010335660.aspxRATE THIS VIDEO0Microsoft

30

20092Mean, StdevHow To... Calculate Mean and Standard Deviation in Excel 2010https://www.youtube.com/watch?v=62i1fqKhNhgRATE THIS VIDEO7Eugene O'Loughlin

31

20102StdevVariance and Standard Deviationhttps://www.khanacademy.org/math/probability/descriptive-statistics/variance_std_deviation/v/range--variance-and-standard-deviation-as-measures-of-dispersionRATE THIS VIDEO60Khan Academy

32

20112Range Names in ExcelHow to Create Named Ranges to Use in Excel Formulashttps://www.youtube.com/watch?v=FbhnvuN_YlQRATE THIS VIDEO13Danny Rocks

33

30013OverviewMinutes 0 - 9 of Excel 2010 Statistics 07: Charts Basics: Pie, Column, Bar, Line and X-Y Scatterhttps://www.youtube.com/v/-btUxQi76qI?start=0&end=540RATE THIS VIDEO9ExcellsFun

34

30023ColumnMinutes 9 - 12 of Excel 2010 Statistics 07: Charts Basics: Pie, Column, Bar, Line and X-Y Scatterhttps://www.youtube.com/v/-btUxQi76qI?start=540&end=720RATE THIS VIDEO3ExcellsFun

35

30033BarMinutes 12 - 15 of Excel 2010 Statistics 07: Charts Basics: Pie, Column, Bar, Line and X-Y Scatterhttps://www.youtube.com/v/-btUxQi76qI?start=720&end=900RATE THIS VIDEO3ExcellsFun

36

30043Clustered, Stacked, and Percentage bar and column chartsMinutes 15 - 17 of Excel 2010 Statistics 07: Charts Basics: Pie, Column, Bar, Line and X-Y Scatterhttps://www.youtube.com/v/-btUxQi76qI?start=900&end=1020RATE THIS VIDEO2ExcellsFun

37

30063Line chartMinutes 18 - 24 of Excel 2010 Statistics 07: Charts Basics: Pie, Column, Bar, Line and X-Y Scatterhttps://www.youtube.com/v/-btUxQi76qI?start=1080&end=1440RATE THIS VIDEO6ExcellsFun

38

30073XY ScatterMinutes 24 - 30 of Excel 2010 Statistics 07: Charts Basics: Pie, Column, Bar, Line and X-Y Scatterhttps://www.youtube.com/v/-btUxQi76qI?start=1440&end=1800RATE THIS VIDEO6ExcellsFun

39

3009a3ParetoCreate a Pareto Charthttps://www.youtube.com/watch?v=bxr0iL6NI1gRATE THIS VIDEO10Doug H

40

3009b3ParetoCreate a Pareto Chart in Excelhttps://www.youtube.com/watch?v=2UdajrDMjRERATE THIS VIDEO9My Excel Lesson

41

3009c3ParetoHow To ... Create a Pareto chart in Excel 2013https://www.youtube.com/watch?v=WpnVbKOMukIRATE THIS VIDEO8Eugene O'Loughlin

42

40014Quiz mechanicsHow to Create a Cell Reference to another Worksheet or another Excel File in Excel 2010https://www.youtube.com/watch?v=3QecNX23L3ERATE THIS VIDEO5Maarten H

43

40024Quiz mechanicsHow to take a screenshot in windows 7https://www.youtube.com/watch?v=szuCX3KF8v4RATE THIS VIDEO2bowei437

44

40034Includes installation of Analysis ToolPak and binsCreating a Histogram In Excel 2010https://www.youtube.com/embed/xe2Q6z6PTqk?rel=0&start=0&end=182RATE THIS VIDEO3waxwing111

45

4003b4For Mac users: histogramsExcel 2013: Frequency Function & Creating Histograms (note - this works for Excel 2010 also)https://www.youtube.com/watch?v=asEuFvWGJDsRATE THIS VIDEO6Kevin Olson

46

40044MIN MAX and COUNTExcel 2010 Tutorial For Beginners #5 - Functions AVERAGE MAX MIN COUNT (Microsoft Excel)https://www.youtube.com/watch?v=DUoz9v2CHjoRATE THIS VIDEO10MotionTraining

47

40054Sort top to bottomExcel 2010: Sortinghttps://www.youtube.com/watch?v=_7U0aWzTkkYRATE THIS VIDEO4GCFLearnFree.org

48

40064Sort left to rightSort left to right in Microsoft Excelhttps://www.youtube.com/watch?v=qYAOCzbj3GARATE THIS VIDEO6The IT Service

49

40074Range lookup includedHow to Use VLOOKUP in Microsoft Excel 2010https://www.youtube.com/watch?v=981MeKFA4W8RATE THIS VIDEO10QuePublishing

50

40084HLOOKUPHLOOKUP() in Excel - how to use it and edit it. Walkthrough explanationhttps://www.youtube.com/watch?v=4av_WHpVLtkRATE THIS VIDEO8ExcelisHell

51

40094Transpose;first way is just fineTwo Ways to Transpose Excel Datahttps://www.youtube.com/watch?v=7zrHZM7aL2URATE THIS VIDEO8Danny Rocks

52

40104Prerequisite for 4011; covers curly brackets { }Excel Array Formula Series #1: Basics of Array Formulashttps://www.youtube.com/watch?v=vqfikSMx7mERATE THIS VIDEO8ExcellsFun

53

40114Matrix MultiplicationExcel Array Formula Series 12: MMULT function Matrix Algebrahttps://www.youtube.com/watch?v=qJnL5hFfcYoRATE THIS VIDEO3ExcellsFun

54

40124Invert a MatrixMatrix Multiplication and Inverse in Excelhttps://www.youtube.com/watch?v=G8w-d9U3PJMRATE THIS VIDEO5Hifas Faiz

55

40134How to make a dashboardHow to Make a Dashboardhttps://www.youtube.com/watch?v=PILflFzAXiYRATE THIS VIDEO8Carrie Beam

56

50015IFExcel 2010 - Create Basic IF Functionshttps://www.youtube.com/watch?v=jTuwUKzT1UsRATE THIS VIDEO3keystonelearningcom

57

50025ANDThe AND Function in Excelhttps://www.youtube.com/watch?v=BKypSMdkk7URATE THIS VIDEO4Aldo Mencaraglia

58

50035ORExcel OR function - beginnerhttps://www.youtube.com/watch?v=UpB-oCsnPeMRATE THIS VIDEO6Jalayer Academy

59

50045NOT, ANDLearn Excel 2010 - "Bonus Formula, Truth Table, AND() NOT()": Podcast #1639https://www.youtube.com/watch?v=_MH4fCcL32MRATE THIS VIDEO5Bill Jelen

60

50055IFOffice 2010 Class #38: Excel IF Function Formula Made Easy (7 examples)https://www.youtube.com/watch?v=vFteHgX01JkRATE THIS VIDEO12ExcellsFun

61

50065OR, AND, IFExcel Magic Trick 939: Use OR and AND Functions In IF Function For Logical Testshttps://www.youtube.com/watch?v=veyaEaKwHgkRATE THIS VIDEO16ExcellsFun

62

50075COUNTIF for textHow To... Use the COUNTIF statement in Excel 2010https://www.youtube.com/watch?v=8kt8-oTcmfgRATE THIS VIDEO3Eugene O'Loughlin

63

50085COUNTIF, SUMIFMicrosoft Excel Tutorial for Beginners #19 - COUNTIF and SUMIF Functionshttps://www.youtube.com/watch?v=0MbM1Eb_pNwRATE THIS VIDEO8MotionTraining

64

50095FilterExcel 2010: Filtering Datahttps://www.youtube.com/watch?v=zQMA9lw4EyURATE THIS VIDEO4GCFLearnFree.org

65

50105SortHow To...Sort Data in Excel 2010https://www.youtube.com/watch?v=IrymK7jx-34RATE THIS VIDEO4Eugene O'Loughlin

66

50115Pivot TablesPivot Tables for Beginnershttps://www.youtube.com/watch?v=TqJJHaE1CxsRATE THIS VIDEO4sjfischer8959's channel

67

50125Pivot TablesWorking with Pivot Tables in Excel 2010 - Part 1https://www.youtube.com/watch?v=l0a0dCgFA5gRATE THIS VIDEO5CSU Fullerton IT Training

68

50135Pivot TablesOffice 2010 Class #36: Excel PivotTables Pivot Tables 15 examples (Data Analysis)https://www.youtube.com/watch?v=qMGILHiLqr0RATE THIS VIDEO24ExcellsFun

69

60016Goal SeekHow to use Goal Seek Function in Excelhttps://www.youtube.com/watch?v=fcKCUDyF73YRATE THIS VIDEO4Aldo Mencaraglia

70

60026Goal SeekExcel Video 331 Introducing Goal Seekhttps://www.youtube.com/watch?v=FnHEmMZZayQRATE THIS VIDEO5PivotTableGuy

71

60036Goal SeekHow to use the Goal Seek function in Excelhttps://www.youtube.com/watch?v=fcKCUDyF73YRATE THIS VIDEO4Aldo Mencaraglia

72

60046Installing Solver (Analysis ToolPak)How to Install Microsoft Excel 2010's Solver Add-Inhttps://www.youtube.com/watch?v=0z2BVsbITAsRATE THIS VIDEO5Thomas Franza

73

60056SolverHow to Use the Solver Tool in Excelhttps://www.youtube.com/watch?v=K4QkLA3sT1oRATE THIS VIDEO10Danny Rocks

74

70017Math underpinningsIntroduction to Random Variableshttps://www.youtube.com/watch?v=IYdiKeQ9xEI#t=603RATE THIS VIDEO12Khan Academy

75

70027Uniform distributionUniform Distributionhttp://en.wikipedia.org/wiki/Uniform_distribution_(continuous)RATE THIS VIDEO0Wikipedia

76

70037RAND and RANDBETWEENGenerate Random Numbers for Excel Spreadsheetshttps://www.youtube.com/watch?v=Ol6ACNK1GIARATE THIS VIDEO4Danny Rocks

77

70047RAND and RANDBETWEENExcel Functions: RAND and RANDBETWEENhttps://www.youtube.com/watch?v=tELEvts3AdYRATE THIS VIDEO5Train Signal

78

70057Math underpinningsNormal Distributionhttp://www.regentsprep.org/Regents/math/algtrig/ATS2/NormalLesson.htmRATE THIS VIDEO0Regents Prep

79

70067Normal distributionLearn Excel 2010 - "Random Around Mean and Standard Deviation": Podcast #1507https://www.youtube.com/watch?v=IcNOaPCYqEYRATE THIS VIDEO3Bill Jelen

80

70077POISSON functionExcel Statistics 65: POISSON function Poisson Probability Distributionhttps://www.youtube.com/watch?v=JR-1ftUj__YRATE THIS VIDEO11ExcellsFun

81

70087Monte carloMonte Carlo Simulation Tutorial (worksheet-based simulations only; NOT VBA based simulations). Screens 01 through 09; do NOT need to do commute worksheet in screen 10 forwards.http://excelmontecarlo.com/RATE THIS VIDEO0Power 4XL

82

70097Monte carloMonte Carlo Simulation Tutorial - coin toss examplehttp://excelmontecarlo.com/06_simple_coin_toss_worksheet.htmlRATE THIS VIDEO0Power 4XL

83

70107Monte carloMonte Carlo Simulation Tutorial - multiple coin tosses examplehttp://excelmontecarlo.com/08_multiple_coin_toss_worksheet.htmlRATE THIS VIDEO0Power 4XL

84

80018FVExcel Tells You the Future Value of Your Investmenthttps://www.youtube.com/watch?v=tTWE0KpbgmARATE THIS VIDEO7Danny Rocks

85

80028PVExcel tutorial: Present value (PV) in excel 2010https://www.youtube.com/watch?v=C3huNohGo0gRATE THIS VIDEO4Codible

86

80038NPVHow to calculate investment NPV in Excelhttps://www.youtube.com/watch?v=s2ZZFjC2UBURATE THIS VIDEO3Lynda.com

87

80048NPERHow to use the NPER function in Excelhttps://www.youtube.com/watch?v=VLbdpgReGFkRATE THIS VIDEO4Lynda.com

88

80058ANOVA (includes installation of Analysis ToolPak)ANOVA Excel 2010 - by columnshttps://www.youtube.com/watch?v=HOblE4FMud4RATE THIS VIDEO10Matt Wiley

89

80068Pivot Table sortExcel Video 2 Sorting a Pivot Tablehttps://www.youtube.com/watch?v=rz_HtD2kelMRATE THIS VIDEO6PivotTableGuy

90

91

92

93

94

95

96

97

98

99

100