Microsoft Excel- Excel from Beginner to Advanced

1. 02 Microsoft Excel 101 Course Introduction/002 Course Exercise Files.mp42.32MB
2. 30 Congratualtions/131 Congratulations on Competing the Microsoft Excel 103.mp43.4MB
3. 06 Modifying an Excel Worksheet/029 Renaming an Excel Worksheet.mp45.33MB
4. 33 Excel VBA Concepts/143 Excel VBA Modules.mp45.38MB
5. 11 Working with Excel Templates/055 Intro to Excel Templates.mp45.39MB
6. 12 Congratulations Youve Built a Solid Microsoft Excel Foundation/058 Congratulations.mp45.55MB
7. 10 Printing an Excel Worksheet/050 Viewing your Document in Print Preview.mp45.91MB
8. 03 Microsoft Excel Fundamentals/008 Opening an Existing Excel Document.mp46.19MB
9. 04 Entering and Editing Text and Formulas/016 Understanding the Order of Operation.mp46.5MB
10. 05 Working with Basic Excel Functions/021 Working with the COUNT() Function.mp46.72MB
11. 07 Formatting Data in an Excel Worksheet/035 Formatting Percentages.mp47.02MB
12. 03 Microsoft Excel Fundamentals/007 Saving an Excel Document.mp47.26MB
13. 09 Creating Basic Charts in Excel/048 Moving a Chart to another Worksheet.mp47.42MB
14. 35 Project 3 Preparing and Cleaning Up Data with a Little VBA/159 Project 3 Formatting the Headers.mp47.46MB
15. 36 Project 4 Using VBA to Automate Excel Formulas/162 Introduction to Project 4 Automate Excel Formulas.mp47.46MB
16. 05 Working with Basic Excel Functions/020 Working with the AVERAGE() Function.mp47.82MB
17. 19 Working with Excels PowerPivot Tools/090 Activating the Excel PowerPivot AddIn.mp48.08MB
18. 06 Modifying an Excel Worksheet/028 Deleting an Excel Worksheet.mp48.11MB
19. 05 Working with Basic Excel Functions/017 The structure of an Excel Function.mp48.11MB
20. 04 Entering and Editing Text and Formulas/011 Working with Numeric Data in Excel.mp48.24MB
21. 06 Modifying an Excel Worksheet/027 Hiding and Unhiding Excel Rows and Columns.mp48.5MB
22. 32 Project 1 Using Excels Macro Recorder Tool/137 Running A Macro.mp48.57MB
23. 07 Formatting Data in an Excel Worksheet/032 Changing the Background Color of a Cell.mp48.63MB
24. 21 Congratulations Youre an Intermediate Excel User/100 Congratulations.mp48.63MB
25. 38 Project 6 Working with Excel VBA User Forms/171 Introduction to Project 6 Working with Excel VBA User Forms.mp48.79MB
26. 07 Formatting Data in an Excel Worksheet/036 Using Excels Format Painter.mp48.95MB
27. 33 Excel VBA Concepts/142 The Visual Basic Editor (VBE).mp49.42MB
28. 35 Project 3 Preparing and Cleaning Up Data with a Little VBA/157 Project 3 Preparing to the Use the Macro Recorder.mp49.5MB
29. 05 Working with Basic Excel Functions/023 Using the AutoFill Command to Copy Formulas.mp49.51MB
30. 04 Entering and Editing Text and Formulas/013 Working with Cell References.mp49.59MB
31. 07 Formatting Data in an Excel Worksheet/038 Merging and Centering Cells.mp49.86MB
32. 03 Microsoft Excel Fundamentals/005 Customizing the Excel Quick Access Toolbar.mp49.91MB
33. 38 Project 6 Working with Excel VBA User Forms/176 Project 6 Adding VBA Code to the Add Worksheet Button.mp410.11MB
34. 29 Automating Repetitive Tasks in Excel with Macros/127 Activating the Developer Tab in Excel.mp410.33MB
35. 07 Formatting Data in an Excel Worksheet/033 Adding Borders to Cells.mp410.49MB
36. 10 Printing an Excel Worksheet/054 Printing a Specific Range of Cells.mp410.52MB
37. 35 Project 3 Preparing and Cleaning Up Data with a Little VBA/156 Introduction to Project 3 Cleaning Up and Formatting Data.mp410.71MB
38. 06 Modifying an Excel Worksheet/024 Moving and Copying Data in an Excel Worksheet.mp410.9MB
39. 37 Project 5 Bringing it All Together and a Weekly Report/167 Introduction to Project 5 Creating the Final Report.mp410.99MB
40. 03 Microsoft Excel Fundamentals/003 Launching Excel.mp411.32MB
41. 05 Working with Basic Excel Functions/019 Working with the MIN() and MAX() Functions.mp411.61MB
42. 38 Project 6 Working with Excel VBA User Forms/173 Project 6 Adding Controls to the Form.mp411.65MB
43. 04 Entering and Editing Text and Formulas/010 Entering Text to Create Spreadsheet Titles.mp411.69MB
44. 38 Project 6 Working with Excel VBA User Forms/177 Change Worksheet Name.mp411.7MB
45. 04 Entering and Editing Text and Formulas/012 Entering Date Values in Excel.mp411.75MB
46. 07 Formatting Data in an Excel Worksheet/031 Working with Font Formatting Commands.mp411.78MB
47. 25 Working with Excels Text Based Functions/114 Using Excels CONCATENATE() Function.mp411.86MB
48. 34 Project 2 Moving Beyond the Basics and into VBA/150 Project 2 Breaking Down the VBA Code.mp411.97MB
49. 20 Working with Large Sets of Excel Data/098 Linking Worksheets (3D Formulas).mp411.98MB
50. 09 Creating Basic Charts in Excel/046 Adding and Modifying Data on an Excel Chart.mp412.29MB
51. 27 Protecting Excel Worksheets and Workbooks/120 Protecting the Structure of a Workbook.mp412.34MB
52. 03 Microsoft Excel Fundamentals/004 Introduction to the Excel Interface.mp412.34MB
53. 36 Project 4 Using VBA to Automate Excel Formulas/165 Test the SUM Function.mp412.36MB
54. 38 Project 6 Working with Excel VBA User Forms/179 Project 6 Showing the Form.mp412.39MB
55. 06 Modifying an Excel Worksheet/030 Moving and Copying and Excel Worksheet.mp412.78MB
56. 26 Auditing an Excel Worksheet/118 Showing Formulas.mp412.9MB
57. 32 Project 1 Using Excels Macro Recorder Tool/135 Introduction to Project 1 Inserting and Formatting Text.mp413.08MB
58. 08 Inserting Images and Shapes into an Excel Worksheet/041 Inserting Excel Shapes.mp413.24MB
59. 03 Microsoft Excel Fundamentals/006 Understanding the Structure of an Excel Workbook.mp413.74MB
60. 09 Creating Basic Charts in Excel/047 Formatting an Excel Chart.mp413.81MB
61. 05 Working with Basic Excel Functions/018 Working with the SUM() Function.mp413.88MB
62. 10 Printing an Excel Worksheet/052 Working with Page Layout View.mp413.95MB
63. 26 Auditing an Excel Worksheet/116 Tracing Dependents in Excel Formuals.mp414.12MB
64. 08 Inserting Images and Shapes into an Excel Worksheet/040 Inserting Images.mp414.2MB
65. 27 Protecting Excel Worksheets and Workbooks/121 Adding a Workbook Password.mp414.33MB
66. 10 Printing an Excel Worksheet/053 Adding Header and Footer Content.mp414.38MB
67. 34 Project 2 Moving Beyond the Basics and into VBA/153 Project 2 Building Logic into Your Macros.mp414.76MB
68. 31 Microsoft Excel Macros and VBA Course Introduction/133 Understanding the Why and How Behind Excel Macros.mp414.87MB
69. 05 Working with Basic Excel Functions/022 Using the AutoSum Command.mp415.01MB
70. 38 Project 6 Working with Excel VBA User Forms/172 Project 6 Creating an Excel User Form.mp415.05MB
71. 26 Auditing an Excel Worksheet/117 Working with the Watch Window.mp415.25MB
72. 07 Formatting Data in an Excel Worksheet/039 Using Conditional Formatting.mp415.27MB
73. 08 Inserting Images and Shapes into an Excel Worksheet/042 Formatting Excel Shapes.mp415.35MB
74. 09 Creating Basic Charts in Excel/045 Working with the Excel Chart Ribbon.mp415.68MB
75. 11 Working with Excel Templates/057 Creating a Custom Template.mp416.34MB
76. 06 Modifying an Excel Worksheet/026 Changing the Width and Height of Cells.mp416.37MB
77. 07 Formatting Data in an Excel Worksheet/034 Formatting Data as Currency Values.mp416.45MB
78. 09 Creating Basic Charts in Excel/049 Working with Excel Pie Charts.mp416.89MB
79. 17 Importing and Exporting Data/078 Importing Data from Microsoft Access.mp416.91MB
80. 09 Creating Basic Charts in Excel/044 Creating an Excel Column Chart.mp416.95MB
81. 18 Excel PivotTables/083 Grouping PivotTable Data.mp417.15MB
82. 18 Excel PivotTables/087 Filtering PivotTable Data.mp417.17MB
83. 06 Modifying an Excel Worksheet/025 Inserting and Deleting Rows and Columns.mp417.35MB
84. 36 Project 4 Using VBA to Automate Excel Formulas/164 Continue Automate SUM Function.mp417.54MB
85. 04 Entering and Editing Text and Formulas/014 Creating Basic Formulas in Excel.mp417.58MB
86. 15 Excel List Functions/070 Excel Function DAVERAGE().mp417.58MB
87. 24 Working with Excels Lookup Functions/109 Using Excels HLOOKUP() Function.mp417.73MB
88. 18 Excel PivotTables/088 Filtering with the Slicer Tool.mp418.06MB
89. 34 Project 2 Moving Beyond the Basics and into VBA/149 Introduction to Project 2 Interacting with the User.mp418.13MB
90. 20 Working with Large Sets of Excel Data/099 Consolidating Data from Multiple Worksheets.mp418.14MB
91. 32 Project 1 Using Excels Macro Recorder Tool/140 Practical Uses of Excel Macros.mp418.54MB
92. 35 Project 3 Preparing and Cleaning Up Data with a Little VBA/161 Running the Loop.mp418.93MB
93. 17 Importing and Exporting Data/077 Importing Data from Text Files.mp419.08MB
94. 23 Working with Excels Conditional Functions/105 Using Excels COUNTIF() Function.mp419.11MB
95. 08 Inserting Images and Shapes into an Excel Worksheet/043 Working with Excel SmartArt.mp419.24MB
96. 15 Excel List Functions/071 Excel Function DCOUNT().mp419.3MB
97. 28 Mastering Excels What If Tools/124 Building Effective Data Tables in Excel.mp419.38MB
98. 18 Excel PivotTables/084 Formatting PivotTable Data.mp419.5MB
99. 26 Auditing an Excel Worksheet/115 Tracing Precendents in Excel Formulas.mp419.62MB
100. 29 Automating Repetitive Tasks in Excel with Macros/130 Creating Buttons to Run Macros.mp419.75MB
101. 37 Project 5 Bringing it All Together and a Weekly Report/170 Project 5 - Running the Final Report Procedure.mp419.95MB
102. 36 Project 4 Using VBA to Automate Excel Formulas/166 Project 4 Loop the SUM() Function Over Multiple Worksheets.mp420.07MB
103. 14 Working with an Excel List/061 Sorting a List Using Single Level Sort.mp420.27MB
104. 14 Working with an Excel List/062 Sorting a List Using Multi-Level Sorts.mp420.4MB
105. 19 Working with Excels PowerPivot Tools/092 Creating PivotTables based on Data Models.mp420.42MB
106. 14 Working with an Excel List/063 Using Custom Sorts in an Excel List.mp420.46MB
107. 34 Project 2 Moving Beyond the Basics and into VBA/151 Project 2 Prompting the User for Information.mp420.58MB
108. 16 Excel Data Validation/075 Adding a Custom Validation Error.mp420.63MB
109. 14 Working with an Excel List/064 Filter an Excel List Using the AutoFilter Tool.mp420.78MB
110. 10 Printing an Excel Worksheet/051 Changing the Margins Scaling and Orientation.mp421MB
111. 18 Excel PivotTables/085 Drilling Down into PivotTable Data.mp421.07MB
112. 32 Project 1 Using Excels Macro Recorder Tool/138 Project 1 Running a Macro with a Button.mp421.77MB
113. 35 Project 3 Preparing and Cleaning Up Data with a Little VBA/158 Project 3 Inserting the Headers.mp422.11MB
114. 33 Excel VBA Concepts/141 Excel VBA Concepts.mp422.16MB
115. 11 Working with Excel Templates/056 Opening an Existing Template.mp422.27MB
116. 23 Working with Excels Conditional Functions/102 Working with Excel Name Ranges.mp422.31MB
117. 20 Working with Large Sets of Excel Data/095 Using the Freeze Panes Tool.mp422.39MB
118. 17 Importing and Exporting Data/079 Exporting Data to a Text File.mp422.48MB
119. 16 Excel Data Validation/076 Dynamic Formulas by Using Validation Techniques.mp422.5MB
120. 18 Excel PivotTables/086 Creating PivotCharts.mp422.53MB
121. 16 Excel Data Validation/073 Understanding the Need for Data Validation.mp422.72MB
122. 14 Working with an Excel List/067 Using Conditional Formatting to Find Duplicates.mp422.83MB
123. 14 Working with an Excel List/068 Removing Duplicates.mp422.86MB
124. 29 Automating Repetitive Tasks in Excel with Macros/126 Understanding Excel Macros.mp422.97MB
125. 23 Working with Excels Conditional Functions/107 Using Excels IFERROR() Function.mp423MB
126. 33 Excel VBA Concepts/145 Adding Code to a VBA Procedure.mp423.19MB
127. 18 Excel PivotTables/080 Understanding Excel PivotTables.mp423.29MB
128. 01 Microsoft Excel Course Introduction/001 Welcome to the Ultimate Microsoft Excel Course.mp423.41MB
129. 28 Mastering Excels What If Tools/122 Working with Excels Goal Seek Tool.mp423.93MB
130. 19 Working with Excels PowerPivot Tools/093 PowerPivot Calculated Fields.mp424.02MB
131. 38 Project 6 Working with Excel VBA User Forms/175 Project 6 Adding VBA Code to the ComboBox Change Event.mp424.22MB
132. 38 Project 6 Working with Excel VBA User Forms/174 Project 6 Adding VBA Code to the Initialize Event.mp424.35MB
133. 34 Project 2 Moving Beyond the Basics and into VBA/155 Other Practical Uses of Message and Input Boxes.mp424.42MB
134. 29 Automating Repetitive Tasks in Excel with Macros/129 Editing a Macro with VBA.mp425.39MB
135. 36 Project 4 Using VBA to Automate Excel Formulas/163 Project 4 Automate the SUM() Function through Code.mp425.55MB
136. 16 Excel Data Validation/074 Creating a Validation List.mp425.96MB
137. 18 Excel PivotTables/082 Modifying Excel PivotTable Calculations.mp426.56MB
138. 23 Working with Excels Conditional Functions/103 Using Excels IF() Function.mp426.93MB
139. 38 Project 6 Working with Excel VBA User Forms/178 Project 6 Adding VBA Code to the Create Report Button.mp427.42MB
140. 20 Working with Large Sets of Excel Data/096 Grouping Data (Columns andor Rows).mp427.53MB
141. 33 Excel VBA Concepts/148 Working with Excel VBA Loops to Repeat Blocks of Code.mp427.66MB
142. 32 Project 1 Using Excels Macro Recorder Tool/139 Project 1 Opps I Need to Edit My Macro.mp427.86MB
143. 04 Entering and Editing Text and Formulas/015 Relative Versus Absolute Cell References in Formulas.mp429.02MB
144. 07 Formatting Data in an Excel Worksheet/037 Creating Styles to Format Data.mp429.07MB
145. 23 Working with Excels Conditional Functions/106 Using Excels SUMIF() Function.mp429.18MB
146. 14 Working with an Excel List/060 Understanding Excel List Structure.mp429.38MB
147. 18 Excel PivotTables/081 Creating an Excel PivotTable.mp430MB
148. 25 Working with Excels Text Based Functions/111 Using Excels LEFT() RIGHT() and MID() Functions.mp430.36MB
149. 31 Microsoft Excel Macros and VBA Course Introduction/132 Welcome to the Course.mp432.2MB
150. 19 Working with Excels PowerPivot Tools/089 Why PowerPivot.mp432.62MB
151. 34 Project 2 Moving Beyond the Basics and into VBA/154 Project 2 Alerting the User of Errors.mp433.72MB
152. 23 Working with Excels Conditional Functions/104 Nesting Functions.mp434.94MB
153. 33 Excel VBA Concepts/147 Building Logic with an IF Statement.mp435.38MB
154. 28 Mastering Excels What If Tools/125 Creating Scenarios in Excel.mp435.53MB
155. 24 Working with Excels Lookup Functions/108 Using Excels VLOOKUP() Function.mp435.73MB
156. 35 Project 3 Preparing and Cleaning Up Data with a Little VBA/160 Project 3 Putting it all Together with a Little VBA.mp435.83MB
157. 19 Working with Excels PowerPivot Tools/094 PowerPivot KPIs.mp435.88MB
158. 39 Course Wrap Up/180 Congratulations Youre an Excel MacroVBA Master.mp437.06MB
159. 25 Working with Excels Text Based Functions/112 Using Excels LEN() Function.mp437.15MB
160. 33 Excel VBA Concepts/146 Understanding Excel VBA Variables.mp437.36MB
161. 34 Project 2 Moving Beyond the Basics and into VBA/152 Continue Excel VBA InputBox.mp438.86MB
162. 27 Protecting Excel Worksheets and Workbooks/119 Protecting Specific Cells in a Worksheet.mp439.54MB
163. 15 Excel List Functions/069 Excel Function DSUM().mp439.62MB
164. 14 Working with an Excel List/065 Creating Subtotals in a List.mp439.64MB
165. 15 Excel List Functions/072 Excel Function SUBTOTAL().mp440.63MB
166. 20 Working with Large Sets of Excel Data/097 Print Options for Large Sets of Data.mp440.97MB
167. 25 Working with Excels Text Based Functions/113 Using Excels SEARCH() Function.mp441.86MB
168. 14 Working with an Excel List/066 Format a List as a Table.mp442.73MB
169. 33 Excel VBA Concepts/144 Creating an Excel VBA Procedure.mp443.02MB
170. 28 Mastering Excels What If Tools/123 Working with Excels Solver Tool.mp444.76MB
171. 19 Working with Excels PowerPivot Tools/091 Creating Data Models with PowerPivot.mp445.84MB
172. 29 Automating Repetitive Tasks in Excel with Macros/128 Creating a Macro with the Macro Recorder.mp446.39MB
173. 37 Project 5 Bringing it All Together and a Weekly Report/168 Project 5 Creating the Final Report Loop.mp447.28MB
174. 32 Project 1 Using Excels Macro Recorder Tool/136 Project 1 Start Recording.mp449.21MB
175. 37 Project 5 Bringing it All Together and a Weekly Report/169 Project 5 - Copying and Pasting Data with VBA.mp454.75MB
176. 24 Working with Excels Lookup Functions/110 Using Excels INDEX() and MATCH() Functions.mp463.96MB