Never stop talking " STOP the Gaza Genocide "
  • Lesson.No : 176
  • 00:00:40

  • MS Excel Updating Links when Source Excel Sheet is Closed

  • Play

Course Lessons

  1. 1- MS Excel Tutorial - Lesson 1 - Excel Interface
  2. 2- MS Excel Tutorial - Lesson 2 - Quick Access Toolbar
  3. 3- MS Excel Tutorial - Lesson 3 - Workbooks and Worksheets
  4. 4- MS Excel Tutorial - Lesson 4 - Formula Bar
  5. 5- MS Excel Tutorial - Lesson 5 - Status Bar
  6. 6- MS Excel Tutorial - Lesson 6 - Navigation Tools
  7. 7- MS Excel Tutorial - Lesson 7 - Shortcut menus and Mini toolbar
  8. 8- MS Excel Tutorial - Lesson 8 - Creating new workbooks
  9. 9- MS Excel Tutorial - Lesson 9 - Tell Me Assistant and Help
  10. 10- MS Excel Tutorial - Lesson 10 - Data Entry and Editing
  11. 11- MS Excel Tutorial - Lesson 11 - Autofill
  12. 12- MS Excel Tutorial - Lesson 12 - Dates and Times
  13. 13- MS Excel Tutorial - Lesson 13 - Undo and Redo
  14. 14- MS Excel Tutorial - Lesson 14 - Comments
  15. 15- MS Excel Tutorial - Lesson 15 - Save and Save As
  16. 16- MS Excel Tutorial - Lesson 16 - Basic Formula for Calculations
  17. 17- MS Excel Tutorial - Lesson 17 - Basic Formula Function
  18. 18- MS Excel Tutorial - Lesson 18 - Duplicating Formulas
  19. 19- MS Excel Tutorial - Lesson 19 - Year to Date Calculation
  20. 20- MS Excel Tutorial - Lesson 20 - Percentage formula
  21. 21- MS Excel Tutorial - Lesson 21 - Relative, absolute and mixed reference
  22. 22- MS Excel Tutorial - Lesson 22 - SUM and AVERAGE
  23. 23- MS Excel Tutorial - Lesson 23 - Common functions
  24. 24- MS Excel Tutorial - Lesson 24 - Font styles and effects
  25. 25- MS Excel Tutorial - Lesson 25 - Row height and column width
  26. 26- MS Excel Tutorial - Lesson 26 - Alignment and warp text
  27. 27- MS Excel Tutorial - Lesson 27 - Borders
  28. 28- MS Excel Tutorial - Lesson 28 - Numeric and special formatting
  29. 29- MS Excel Tutorial - Lesson 29 - Numbers and dates
  30. 30- MS Excel Tutorial - Lesson 30 - Conditional formatting
  31. 31- MS Excel Tutorial - Lesson 31 - Tables
  32. 32- MS Excel Tutorial - Lesson 32 - Slicer
  33. 33- MS Excel Tutorial - Lesson 33 - Working with Shapes
  34. 34- MS Excel Tutorial - Lesson 34 - Inserting and Working with Pictures
  35. 35- MS Excel Tutorial - Lesson 35 - SmartArt
  36. 36- MS Excel Tutorial - Lesson 36 - Editing Rows and Columns
  37. 37- MS Excel Tutorial - Lesson 37 - Hiding and Unhiding Rows and Columns
  38. 38- MS Excel Tutorial - Lesson 38 - Moving and Copying Data
  39. 39- MS Excel Tutorial - Lesson 39 - Finding and Replacing data
  40. 40- MS Excel Tutorial - Lesson 40 - Printing Area and Titles
  41. 41- MS Excel Tutorial - Lesson 41 - Page Layout
  42. 42- MS Excel Tutorial - Lesson 42 - Page Break
  43. 43- MS Excel Tutorial - Lesson 43 - Page Setup and Printing Controls
  44. 44- MS Excel Tutorial - Lesson 44 - Creating Charts
  45. 45- MS Excel Tutorial - Lesson 45 - Chart Types
  46. 46- MS Excel Tutorial - Lesson 46 - Chart Formatting
  47. 47- MS Excel Tutorial - Lesson 47 - Axes and Titles
  48. 48- MS Excel Tutorial - Lesson 48 - Chart Elements
  49. 49- MS Excel Tutorial - Lesson 49 - In-cell charts
  50. 50- MS Excel Tutorial - Lesson 50 - Freezing and unfreezing panels
  51. 51- MS Excel Tutorial - Lesson 51 - Splitting screens
  52. 52- MS Excel Tutorial - Lesson 52 - Collapsing and Expanding data
  53. 53- MS Excel Tutorial - Lesson 53 - Multiple workbooks display
  54. 54- MS Excel Tutorial - Lesson 54 - Renaming, inserting, coloring and deleting sheets
  55. 55- MS Excel Tutorial - Lesson 55 - Moving, copying and grouping sheets
  56. 56- MS Excel Tutorial - Lesson 56 - Linking worksheets and workbooks
  57. 57- MS Excel Tutorial - Lesson 57 - Maintaining and locating links
  58. 58- MS Excel Tutorial - Lesson 58 - IF function
  59. 59- MS Excel Tutorial - Lesson 59 - VLOOKUP function for approximate data
  60. 60- MS Excel Tutorial - Lesson 60 - VLOOKUP function for exact data
  61. 61- MS Excel Tutorial - Lesson 61 - COUNTIF function
  62. 62- MS Excel Tutorial - Lesson 62 - Unlocking and protecting worksheets
  63. 63- MS Excel Tutorial - Lesson 63 - Workbook protection
  64. 64- MS Excel Tutorial - Lesson 64 - Setting passwords
  65. 65- MS Excel Tutorial - Lesson 65 - Tracking changes
  66. 66- MS Excel Tutorial - Lesson 66 - Sorting
  67. 67- MS Excel Tutorial - Lesson 67 - Inserting subtotals
  68. 68- MS Excel Tutorial - Lesson 68 - Using filters
  69. 69- MS Excel Tutorial - Lesson 69 - Splitting data
  70. 70- MS Excel Tutorial - Lesson 70 - Flash Fill
  71. 71- MS Excel Tutorial - Lesson 71 - Removing duplicate data
  72. 72- MS Excel Tutorial - Lesson 72 - Validation tools
  73. 73- MS Excel Tutorial - Lesson 73 - Goak Seek
  74. 74- MS Excel Tutorial - Lesson 74 - Solver
  75. 75- MS Excel Tutorial - Lesson 75 - Scenario Manager
  76. 76- MS Excel Tutorial - Lesson 76 - Data Tables
  77. 77- MS Excel Tutorial - Lesson 77 - Validation for Just Number or Text Input
  78. 78- MS Excel Tutorial - Lesson 78 - Kutools for Validation
  79. 79- MS Excel Tutorial - Lesson 79 - Pivot Tables Creation
  80. 80- MS Excel Tutorial - Lesson 80 - Pivot Tables Manipulation
  81. 81- MS Excel Tutorial - Lesson 81 - Grouping and date and time
  82. 82- MS Excel Tutorial - Lesson 82 - Grouping by various facotors
  83. 83- MS Excel Tutorial - Lesson 83 - Slicers
  84. 84- MS Excel Tutorial - Lesson 84 - PivotCharts
  85. 85- MS Excel Tutorial - Lesson 85 - Go to Special
  86. 86- MS Excel Tutorial - Lesson 86 - Creating Macro
  87. 87- MS Excel Tutorial - Lesson 87 - Running Macro and Assigning Buttons
  88. 88- MS Excel Tutorial - Lesson 88 - Making a Grade Sheet
  89. 89- MS Excel Tutorial - Lesson 89 - Generating Automatic Comments using Numbers
  90. 90- MS Excel Tutorial - Lesson 90 - Autohide Tabs
  91. 91- MS Excel Tutorial - Lesson 91 - Copying just the Visible Data Excluding Hidden Columns
  92. 92- MS Excel Tutorial - Lesson 92 - KuTools for Excel
  93. 93- MS Excel Tutorial - Lesson 93 - Multiple User Sharing
  94. 94- Paint 3D Tutorial - Lesson 22 - Importing Paint 3D Models in MS Excel
  95. 95- MS Excel Changing Text to Upper Case
  96. 96- MS Excel Applying Table Style
  97. 97- MS Excel Getting Stock Rates
  98. 98- MS Excel Row Height and Column Width
  99. 99- MS Excel Alignment
  100. 100- MS Excel Remove Duplicate Data
  101. 101- MS Excel Insert 3D Model
  102. 102- MS Excel Adding to Date
  103. 103- MS Excel Absolute Reference
  104. 104- MS Excel Basic Formula for Calculations
  105. 105- MS Excel Using Format Painter to Copy Cell Formatting
  106. 106- MS Excel Font styles and effects
  107. 107- MS Excel Dividing First Name and Last Name
  108. 108- MS Excel Percentage View
  109. 109- MS Excel Resize all Cells at Once
  110. 110- MS Excel Combine Multiple Excel Sheets
  111. 111- MS Excel Text Join
  112. 112- MS Excel Changing Text to Lower Case
  113. 113- MS Excel Dates
  114. 114- MS Excel Adding Interactive Checkboxes
  115. 115- MS Excel XLOOKUP
  116. 116- MS Excel Duplicating Formulas
  117. 117- MS Excel Get Country Flags
  118. 118- MS Excel Color Scale
  119. 119- MS Excel Autofill
  120. 120- MS Excel Relative Reference
  121. 121- MS Excel Changing Text to Title Case
  122. 122- MS Excel Sum Average Count Quick Preview
  123. 123- MS Excel Tell Me Assistant
  124. 124- MS Excel Adding Image in Cell from URL
  125. 125- MS Excel Center Across Selection
  126. 126- MS Excel Using SUM
  127. 127- MS Excel Sorting Cells by Value
  128. 128- MS Excel Generate Serial Number
  129. 129- MS Excel Tab Colors
  130. 130- MS Excel Generate Random Numbers
  131. 131- MS Excel Mixed Reference
  132. 132- MS Excel Creating New Worksheet
  133. 133- MS Excel Hide and Unhide Sheet
  134. 134- MS Excel AVERAGE
  135. 135- MS Excel Getting Current Currency Exchange Rate
  136. 136- MS Excel Resize all Columns at Once
  137. 137- MS Excel Changing to Sentence Case
  138. 138- MS Excel Remove Background
  139. 139- MS Excel Generating QR Code
  140. 140- MS Excel Slicer
  141. 141- MS Excel Cell Styles
  142. 142- MS Excel Formula Tab
  143. 143- ChatGPT Generate MS Excel Spreadsheet
  144. 144- MS Excel Accessing Quick Access Toolbar
  145. 145- Adding Numbers in MS Excel
  146. 146- MS Excel Resizing Rows and Columns
  147. 147- MS Excel Scroll Lock Key
  148. 148- MS Excel Getting Average
  149. 149- MS Excel Warp Text
  150. 150- MS Excel Adding Borders
  151. 151- MS Excel Changing Border Styles
  152. 152- MS Excel Drawing Borders
  153. 153- MS Excel Changing Currencies
  154. 154- MS Excel Inserting Tables
  155. 155- MS Excel Conditional Formatting
  156. 156- MS Excel Inserting Picture In and Outside of Cells
  157. 157- MS Excel Hiding and Unhiding Rows and Columns
  158. 158- MS Excel Moving and Copying Data
  159. 159- MS Excel Finding and Replacing data
  160. 160- MS Excel Previewing and Printing the Result
  161. 161- MS Excel Adding Titles for Print for All Pages
  162. 162- MS Excel Choosing Different Chart Types
  163. 163- MS Excel Changing Chart Style
  164. 164- MS Excel Using Chart Filters
  165. 165- MS Excel In cell charts
  166. 166- MS Excel Freezing and unfreezing panes
  167. 167- MS Excel Multiple workbooks display
  168. 168- MS Excel Coloring Sheet
  169. 169- MS Excel Deleting Sheet
  170. 170- MS Excel Moving and copying sheets
  171. 171- MS Excel Inserting Rows and Columns in Multiple Sheets at once
  172. 172- MS Excel Linking worksheets cells with Formula
  173. 173- MS Excel Linking workbooks using Formula
  174. 174- MS Excel IF function
  175. 175- MS Excel Trace Dependent and Precedents
  176. 176- MS Excel Updating Links when Source Excel Sheet is Closed
  177. 177- MS Excel COUNTIF function
  178. 178- MS Excel VLOOKUP function for approximate data
  179. 179- MS Excel HLOOKUP function for approximate data
  180. 180- MS Excel VLOOKUP function for exact data
  181. 181- MS Excel HLOOKUP functions for exact data