MS Excel PivotTables Creation

دروس الكورس

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
182. 182- MS Excel Protecting and Unprotecting worksheets
183. 183- MS Excel Workbook Protection
184. 184- MS Excel Setting Passwords in Existing Spreadsheets
185. 185- MS Excel Sorting
186. 186- MS Excel Using filters
187. 187- MS Excel Inserting subtotals in Table
188. 188- MS Excel Splitting data
189. 189- MS Excel Flash Fill
190. 190- MS Excel Adding a Drop Down List
191. 191- MS Excel Number Range Data Validation
192. 192- MS Excel Time Validation
193. 193- MS Excel Date Validation
194. 194- MS Excel Solver
195. 195- MS Excel PivotTables Creation
196. 196- MS Excel Scenario Manager
197. 197- MS Excel Text only Validation