| Archived
files |
|
Chapter_22-Excels_Essential_LOOKUP_Functions\117. Mastering VLOOKUP() in Microsoft Excel.mp4
[8b3d83cd235b7435]
|
144,853,613 |
538865DB |
|
Chapter_22-Excels_Essential_LOOKUP_Functions\118. Unraveling HLOOKUP() in Microsoft Excel.mp4
[2b0b9282e47a8d85]
|
85,404,204 |
B8891B1C |
|
Chapter_22-Excels_Essential_LOOKUP_Functions\119. Excel's INDEX() Function A Comprehensive Guide.mp4
[a8bdec065e2dd7ea]
|
140,900,620 |
5B6E5F7F |
|
Chapter_22-Excels_Essential_LOOKUP_Functions\120. Microsoft Excel's MATCH() Function Your Complete Tutorial.mp4
[600ab73de4ef1e0e]
|
62,547,214 |
413E329F |
|
Chapter_22-Excels_Essential_LOOKUP_Functions\121. Harnessing Synergy INDEX() and MATCH() in Microsoft Excel.mp4
[6181c6adcd463234]
|
83,017,781 |
15F4B227 |
|
Chapter_22-Excels_Essential_LOOKUP_Functions\122. Unlocking the Potential INDEX() and MATCH() in Microsoft Excel.mp4
[318c88c45e8d166]
|
123,271,386 |
BB5ADF89 |
|
Chapter_22-Excels_Essential_LOOKUP_Functions\123. Creating Dynamic HLOOKUP() with MATCH() in Microsoft Excel.mp4
[4636aafa08176348]
|
77,227,717 |
50C6AC14 |
|
Chapter_23-Excels_Text_Functions_Demystified\124. Mastering Excel's LEFT(), RIGHT(), and MID() Functions.mp4
[6b05d6499a1d2e59]
|
97,459,666 |
C7D25305 |
|
Chapter_23-Excels_Text_Functions_Demystified\125. Exploring Excel's LEN() Function for Text Analysis.mp4
[7444d5a4a8e9315f]
|
35,808,608 |
E495958B |
|
Chapter_23-Excels_Text_Functions_Demystified\126. Navigating Text Data with Excel's SEARCH() Function.mp4
[2357db8a16017a0]
|
157,006,395 |
366A94F0 |
|
Chapter_23-Excels_Text_Functions_Demystified\127. Excel's CONCATENATE() Function Text Fusion Simplified.mp4
[92a1fe89a5e91389]
|
23,474,060 |
4E7F12EF |
|
Chapter_24-Excel_Worksheet_Auditing_Techniques\128. Tracing Formula Precedents in Excel.mp4
[7b407795e5a2fe39]
|
50,855,801 |
32A8869E |
|
Chapter_24-Excel_Worksheet_Auditing_Techniques\129. Investigating Formula Dependents in Excel.mp4
[8815359798e1fd06]
|
40,703,157 |
4C3FB548 |
|
Chapter_24-Excel_Worksheet_Auditing_Techniques\130. Utilizing the Excel Watch Window.mp4
[d3d1f2ad1d2152e6]
|
55,741,015 |
D4AE18D7 |
|
Chapter_24-Excel_Worksheet_Auditing_Techniques\131. Revealing Formulas for In-Depth Analysis.mp4
[9ff401376f86c017]
|
45,909,406 |
1370F41E |
|
Chapter_25-Excel_Worksheet_and_Workbook_Security\132. Secure Specific Cells in an Excel Worksheet.mp4
[6090dc08dd4bc467]
|
100,998,091 |
F0DDE57D |
|
Chapter_25-Excel_Worksheet_and_Workbook_Security\133. Safeguarding Workbook Structure in Excel.mp4
[91ee492088d037a1]
|
32,607,609 |
2C3E24BB |
|
Chapter_25-Excel_Worksheet_and_Workbook_Security\134. Implementing a Password for Workbook Protection.mp4
[13f6264e8aa5b3e9]
|
37,256,061 |
A599FD8C |
|
Chapter_26-Excels_Advanced_What_if_Analysis\135. Excel Goal Seek Tool Mastery.mp4
[73da514e5ccac753]
|
81,527,811 |
63AEB271 |
|
Chapter_26-Excels_Advanced_What_if_Analysis\136. Excel Solver Tool Techniques.mp4
[9259873f3f1621fb]
|
150,667,137 |
5154BB88 |
|
Chapter_26-Excels_Advanced_What_if_Analysis\137. Excel Data Tables for Effective Analysis.mp4
[c038344edc4698f]
|
59,453,935 |
0F97BB6C |
|
Chapter_26-Excels_Advanced_What_if_Analysis\138. Excel Scenario Planning Simplified.mp4
[68e8e210cfc9c816]
|
136,058,114 |
197661AC |
|
Chapter_27-Excel_Macros_for_Task_Automation\139. Demystifying Excel Macros.mp4
[4977e0ac9e5090c0]
|
52,797,263 |
77CCF719 |
|
Chapter_27-Excel_Macros_for_Task_Automation\140. Enabling the Excel Developer Tab.mp4
[738a716b002c5a1f]
|
22,727,705 |
FF63C133 |
|
Chapter_27-Excel_Macros_for_Task_Automation\141. Creating Macros with the Macro Recorder.mp4
[f9db9906db7c8d52]
|
128,299,061 |
D2AE2CA6 |
|
Chapter_27-Excel_Macros_for_Task_Automation\142. Modifying Macros with VBA Scripting.mp4
[8abbcb99bb71add2]
|
97,590,853 |
BB87AFA3 |
|
Chapter_27-Excel_Macros_for_Task_Automation\143. Implementing Macro Buttons for Automation.mp4
[1eee92a8ba78026f]
|
65,392,577 |
D527A5E5 |
|
Chapter_28-Introduction_to_MS_Excel_Advanced_Macros_using_VBA\144. Introduction to Excel Macros Using VBA.mp4
[d8dfe830d252ca93]
|
41,161,181 |
39DD44C8 |
|
Chapter_29-Advanced_Macros_Module_1_Mastering_Excels_Macro_Recorder_Tool\146. Module 1 Dive In – Inserting & Formatting Text Basics.mp4
[b38b237bc41ec444]
|
18,499,787 |
B734E94E |
|
Chapter_29-Advanced_Macros_Module_1_Mastering_Excels_Macro_Recorder_Tool\147. Module 1 First Steps – Starting Your Macro Recording.mp4
[6003b759a903d6f2]
|
55,075,085 |
48C9A180 |
|
Chapter_29-Advanced_Macros_Module_1_Mastering_Excels_Macro_Recorder_Tool\148. Module 1 Action Time – Executing Your First Macro.mp4
[f4dac86735f278a8]
|
21,763,258 |
919979D8 |
|
Chapter_29-Advanced_Macros_Module_1_Mastering_Excels_Macro_Recorder_Tool\149. Module 1 Click to Success – Running Macros with Buttons.mp4
[89163c31a98254b2]
|
28,732,906 |
45AA1567 |
|
Chapter_29-Advanced_Macros_Module_1_Mastering_Excels_Macro_Recorder_Tool\150. Module 1 Troubleshoot Tactics – Editing Macro Errors.mp4
[39dbcd8920d15c23]
|
33,881,858 |
5AA34A5A |
|
Chapter_29-Advanced_Macros_Module_1_Mastering_Excels_Macro_Recorder_Tool\151. Module 1 Macro Mastery – Real-World Applications & Benefits.mp4
[21633ccee77dbbdb]
|
20,521,475 |
DE6DDB7F |
|
Chapter_29-Advanced_Macros_Module_1_Mastering_Excels_Macro_Recorder_Tool\Extra_Files\InsertingAndFormattingText.xlsx |
12,968 |
D14BFB2B |
|
Chapter_30-Excel_VBA_Concepts\152. VBA Foundations – Exploring Excel VBA Concepts.mp4
[6a93cf5895ebc4d6]
|
31,121,202 |
455FDF88 |
|
Chapter_30-Excel_VBA_Concepts\153. VBE Mastery – Navigating the Visual Basic Editor.mp4
[16c62e0462df54e]
|
13,616,030 |
F1D5C94F |
|
Chapter_30-Excel_VBA_Concepts\154. Modular Approach – Structuring Excel VBA Modules.mp4
[69eadf7fa87d3d61]
|
7,182,826 |
B127CDF2 |
|
Chapter_30-Excel_VBA_Concepts\155. Procedural Prowess – Crafting an Excel VBA Procedure.mp4
[3f60e949bd5a2c06]
|
25,184,070 |
10F09E85 |
|
Chapter_30-Excel_VBA_Concepts\156. Code Crafting – Adding Logic to VBA Procedures.mp4
[e574d867915ca0a3]
|
23,020,502 |
D022412C |
|
Chapter_30-Excel_VBA_Concepts\157. Variable Versatility – Grasping Excel VBA Variables.mp4
[7f3eb15fb47a0b21]
|
27,870,797 |
9E421CC4 |
|
Chapter_30-Excel_VBA_Concepts\158. Decision Dynamics – IF Statement Logic Building.mp4
[c4fc4f0b97b99d03]
|
42,104,041 |
011947F4 |
|
Chapter_30-Excel_VBA_Concepts\159. Looping Logic – Automating Repetition with VBA Loops.mp4
[130c3568ee22bb33]
|
55,293,682 |
74158C0E |
|
Chapter_31-Advanced_Macros_Module_2_Advancing_to_VBA_Beyond_the_Basics\161. Introduction to Module 2 -- Interacting With The User.mp4
[2d4adca8c92f75bd]
|
41,516,337 |
075E3BA8 |
|
Chapter_31-Advanced_Macros_Module_2_Advancing_to_VBA_Beyond_the_Basics\162. Module 2 Code Analysis – Understanding VBA Interactions.mp4
[86323dcf93590c32]
|
23,419,500 |
21C0668D |
|
Chapter_31-Advanced_Macros_Module_2_Advancing_to_VBA_Beyond_the_Basics\163. Prompting the User for Information -- Module 2.mp4
[90d974f56bc1280d]
|
43,211,584 |
95FD39C2 |
|
Chapter_31-Advanced_Macros_Module_2_Advancing_to_VBA_Beyond_the_Basics\164. Module 2 InputBox Insights – Enhancing User Input in VBA.mp4
[eb7e647aae31a423]
|
44,983,240 |
7E686085 |
|
Chapter_31-Advanced_Macros_Module_2_Advancing_to_VBA_Beyond_the_Basics\165. Module 2 Logic Layers – Crafting Smart Macros.mp4
[8d1dc4be031baa2e]
|
75,081,843 |
E8AB4831 |
|
Chapter_31-Advanced_Macros_Module_2_Advancing_to_VBA_Beyond_the_Basics\166. Module 2 Error Alerts – Communicating Issues to Users.mp4
[d5e7b45ecee789db]
|
86,831,449 |
DA007D5E |
|
Chapter_31-Advanced_Macros_Module_2_Advancing_to_VBA_Beyond_the_Basics\Extra_Files\Project2-Sorting-Practice.xlsm |
17,522 |
EEA18F58 |
|
Chapter_32-Advanced_Macros_Module_3_VBA_Data_Prep_Clean_and_Streamline\168. Introduction To Module 3 -- Cleaning Up & Formatting Data.mp4
[f49b796920c4b9ae]
|
48,872,311 |
47262445 |
|
Chapter_32-Advanced_Macros_Module_3_VBA_Data_Prep_Clean_and_Streamline\169. Module 3 - Preparing to use the Macro Recorder.mp4
[d5baaa33fecd4c3c]
|
24,918,851 |
222B6541 |
|
Chapter_32-Advanced_Macros_Module_3_VBA_Data_Prep_Clean_and_Streamline\170. Module 3 - Inserting The Headers.mp4
[f14cd17ac5968879]
|
34,233,731 |
F58B439E |
|
Chapter_32-Advanced_Macros_Module_3_VBA_Data_Prep_Clean_and_Streamline\171. Module 3 - Formatting the Headers.mp4
[3d11c6d7f5e2555f]
|
22,465,814 |
EBDE89F0 |
|
Chapter_32-Advanced_Macros_Module_3_VBA_Data_Prep_Clean_and_Streamline\172. Module 3 - Putting It All Together With VBA.mp4
[2c18e6e6a5babf59]
|
97,133,755 |
C8B9BF5C |
|
Chapter_32-Advanced_Macros_Module_3_VBA_Data_Prep_Clean_and_Streamline\173. Module 3 - Running The Loop.mp4
[64a273d214b0669f]
|
30,201,999 |
F0B6463A |
|
Chapter_32-Advanced_Macros_Module_3_VBA_Data_Prep_Clean_and_Streamline\Extra_Files\CleaningUpData.xlsx |
16,531 |
FA31F070 |
|
Chapter_33-Advanced_macros_Module_4_VBA_Formulas_Automate_and_Excel\175. Module 4 Intro to Formula Automation in Excel.mp4
[c1bdd8a91f3baddd]
|
43,952,583 |
B01E6ECD |
|
Chapter_33-Advanced_macros_Module_4_VBA_Formulas_Automate_and_Excel\176. Module 4 Coding the SUM() Function Automation.mp4
[ee572e68d93c1aeb]
|
77,319,519 |
01A44161 |
|
Chapter_33-Advanced_macros_Module_4_VBA_Formulas_Automate_and_Excel\177. Module 4 Advancing SUM() Function Automation.mp4
[48031abf2d89d11b]
|
45,795,762 |
A78384D2 |
|
Chapter_33-Advanced_macros_Module_4_VBA_Formulas_Automate_and_Excel\178. Module 4 Validating the Automated SUM Function.mp4
[94683bf8ef06057f]
|
59,939,817 |
D165F196 |
|
Chapter_33-Advanced_macros_Module_4_VBA_Formulas_Automate_and_Excel\179. Module 4 SUM() Across Sheets – Looping Mastery.mp4
[5f91b4eb01942afb]
|
82,518,926 |
131F3656 |
|
Chapter_33-Advanced_macros_Module_4_VBA_Formulas_Automate_and_Excel\Extra_Files\AutomateSumFunction.xlsx |
15,846 |
7568F98D |
|
Chapter_34-Advanced_Macros_Module_5_Synthesis_Comprehensive_Weekly_Reports\181. Introduction to Module 5 - Creating the Final Report.mp4
[f5b13a62a379ef58]
|
32,642,002 |
7ED035D8 |
|
Chapter_34-Advanced_Macros_Module_5_Synthesis_Comprehensive_Weekly_Reports\182. Module 5 - Creating the Final Report Loop.mp4
[bec7335c4de71865]
|
73,954,133 |
0A6C4B53 |
|
Chapter_34-Advanced_Macros_Module_5_Synthesis_Comprehensive_Weekly_Reports\183. Module 5 - Copying & Pasting Data With VBA.mp4
[f9baa17c40947b3b]
|
57,314,921 |
039CBD5D |
|
Chapter_34-Advanced_Macros_Module_5_Synthesis_Comprehensive_Weekly_Reports\184. Module 5 - Running the Final Report Procedure.mp4
[cfd9659434f26525]
|
28,783,818 |
BA4D967C |
|
Chapter_34-Advanced_Macros_Module_5_Synthesis_Comprehensive_Weekly_Reports\Extra_Files\QuarterlyReport.xlsm |
21,794 |
AB71D9CF |
|
Chapter_35-Advanced_macros_Module_6_Interactive_Design_Excel_VBA_User_Forms\186. Module 6 Introduction to User Forms in Excel VBA.mp4
[584e88479a59409]
|
20,865,319 |
C01239DF |
|
Chapter_35-Advanced_macros_Module_6_Interactive_Design_Excel_VBA_User_Forms\187. Module 6 Crafting Your First Excel User Form.mp4
[f011bd91d5024d0a]
|
47,596,944 |
A1E512E8 |
|
Chapter_35-Advanced_macros_Module_6_Interactive_Design_Excel_VBA_User_Forms\188. Module 6 Enhancing Forms with Control Elements.mp4
[2a80482b07ffe7ea]
|
34,297,891 |
A459EC55 |
|
Chapter_35-Advanced_macros_Module_6_Interactive_Design_Excel_VBA_User_Forms\189. Module 6 - Adding VBA Code to the Initialize Event.mp4
[67ada65e0c49f4a2]
|
72,359,504 |
370D498F |
|
Chapter_35-Advanced_macros_Module_6_Interactive_Design_Excel_VBA_User_Forms\190. Module 6 Dynamic Responses – ComboBox Change Event.mp4
[876d6e40d7a164b7]
|
30,681,048 |
E2D69FFE |
|
Chapter_35-Advanced_macros_Module_6_Interactive_Design_Excel_VBA_User_Forms\191. Module 6 - Adding VBA Code to the Add Worksheet Button.mp4
[47025721f8efcb49]
|
25,589,037 |
43536E80 |
|
Chapter_35-Advanced_macros_Module_6_Interactive_Design_Excel_VBA_User_Forms\192. Module 6 - Changing Worksheet Position & Name Through VBA.mp4
[cfb89e1e36e10905]
|
40,337,514 |
FAB3245C |
|
Chapter_35-Advanced_macros_Module_6_Interactive_Design_Excel_VBA_User_Forms\193. Module 6 - Adding VBA Code to the Run Report Button.mp4
[450d593e8e5fe59]
|
77,349,322 |
89283ABB |
|
Chapter_35-Advanced_macros_Module_6_Interactive_Design_Excel_VBA_User_Forms\194. Module 6 The Final Touch – Displaying the User Form.mp4
[c7563432851f509a]
|
31,702,760 |
C1C20CAD |
|
Chapter_35-Advanced_macros_Module_6_Interactive_Design_Excel_VBA_User_Forms\Extra_Files\COMPLETED+PROJECTS.zip |
127,263 |
18700D85 |
|
Chapter_35-Advanced_macros_Module_6_Interactive_Design_Excel_VBA_User_Forms\Extra_Files\QuarterlyReport+(1).xlsm |
22,442 |
285C33E9 |
|
Chapter_36-Conclusion\196. Leveraging Excel Mastery Congratulations and Parting Insights.mp4
[cdd81fc25f12544c]
|
64,442,042 |
E0D643AB |
|
Chapter_1-Introduction\1. Introduction To The Course.mp4
[c0f4c78df5411e63]
|
56,054,551 |
40622E27 |
|
Chapter_2-Getting_started_with_Microsoft_Excel_The_Basics\2. Excel Launch - Starting Your Spreadsheet Journey.mp4
[9e510444d444f387]
|
17,579,014 |
5C2DF1B6 |
|
Chapter_2-Getting_started_with_Microsoft_Excel_The_Basics\3. Understanding The Excel Startup Screen.mp4
[ffa0747e6ed8bb9]
|
63,760,622 |
44F269E3 |
|
Chapter_2-Getting_started_with_Microsoft_Excel_The_Basics\4. Exploring the Microsoft Excel Interface.mp4
[5e97848fa7edb2f2]
|
36,082,357 |
A02C9F0F |
|
Chapter_2-Getting_started_with_Microsoft_Excel_The_Basics\5. Tailoring the Excel Quick Access Toolbar.mp4
[f846b93678b8a987]
|
28,555,404 |
9623760E |
|
Chapter_2-Getting_started_with_Microsoft_Excel_The_Basics\6. Diving Deeper into Excel's Interface.mp4
[215797360b9d04db]
|
24,922,500 |
8FB21D42 |
|
Chapter_2-Getting_started_with_Microsoft_Excel_The_Basics\7. Decoding Excel Workbook Structure.mp4
[6fa8f8f45672bcc1]
|
30,578,928 |
C00BD056 |
|
Chapter_2-Getting_started_with_Microsoft_Excel_The_Basics\8. Preserving Your Excel Work - Saving Strategies.mp4
[68eb435cd93820d0]
|
55,200,943 |
B2806BA7 |
|
Chapter_2-Getting_started_with_Microsoft_Excel_The_Basics\9. Unlocking Excel Files - How to Open Documents.mp4
[ea8a899b0de08dff]
|
21,343,139 |
343816B1 |
|
Chapter_2-Getting_started_with_Microsoft_Excel_The_Basics\Extra_Files\Efficiency+Boost+Essential+Excel+Shortcut+Keys.pdf |
171,744 |
53A5A611 |
|
Chapter_3-Inputting_and_Refining_Text_and_Formulas\11. Creating Spreadsheet Titles by Entering Text.mp4
[4d59b85f5498b263]
|
34,051,750 |
345A2B32 |
|
Chapter_3-Inputting_and_Refining_Text_and_Formulas\12. Managing Numeric Data in Excel.mp4
[8fe46733f2d3c1b1]
|
40,173,050 |
C0EBF1BE |
|
Chapter_3-Inputting_and_Refining_Text_and_Formulas\13. Inputting Date Values in Excel.mp4
[9daf3a762e03d384]
|
55,099,716 |
002B871E |
|
Chapter_3-Inputting_and_Refining_Text_and_Formulas\14. Utilizing Cell References in Excel.mp4
[d4bf5a8426656255]
|
30,150,906 |
76547AD7 |
|
Chapter_3-Inputting_and_Refining_Text_and_Formulas\15. Constructing Fundamental Formulas in Excel.mp4
[b48419609bb234ee]
|
60,929,359 |
BCF79C38 |
|
Chapter_3-Inputting_and_Refining_Text_and_Formulas\16. Cell References - Relative vs. Absolute (Part A).mp4
[6e54a0628ba503dc]
|
59,682,420 |
28212528 |
|
Chapter_3-Inputting_and_Refining_Text_and_Formulas\17. Cell References - Relative vs. Absolute (Part B).mp4
[68bfb9693125e889]
|
56,186,149 |
4B8E00DC |
|
Chapter_3-Inputting_and_Refining_Text_and_Formulas\18. The Order of Operations in Excel.mp4
[6a9f0ea29c028170]
|
59,069,556 |
62CE7D5E |
|
Chapter_3-Inputting_and_Refining_Text_and_Formulas\Extra_Files\18.+Order+of+Operation+Practice.xlsx |
9,864 |
5B08C870 |
|
Chapter_4-Foundational_Excel_Functions\19. Understanding the Structure of an Excel Function.mp4
[807afcdb6bdec096]
|
58,703,468 |
2A83B2DC |
|
Chapter_4-Foundational_Excel_Functions\20. Utilizing the SUM() Function in Excel.mp4
[ede4fc4e798722e8]
|
50,401,406 |
E7D9A883 |
|
Chapter_4-Foundational_Excel_Functions\21. Employing the MIN() and MAX() Functions in Excel.mp4
[596ade444ba53fc7]
|
58,899,834 |
AA25DC63 |
|
Chapter_4-Foundational_Excel_Functions\22. Leveraging the AVERAGE() Function in Excel.mp4
[319c7aa21b8fbf16]
|
33,793,742 |
657987BD |
|
Chapter_4-Foundational_Excel_Functions\23. Applying the COUNT() Function in Excel.mp4
[b69d281a2b487abf]
|
30,056,694 |
AC18F6D2 |
|
Chapter_4-Foundational_Excel_Functions\24. Handling Errors Related to Adjacent Cells in Excel Calculations.mp4
[91482feafbe76197]
|
41,754,812 |
4CCA94F3 |
|
Chapter_4-Foundational_Excel_Functions\25. Mastering the AutoSum Command in Excel.mp4
[8f054cfb2557a407]
|
75,661,111 |
20CB2A47 |
|
Chapter_4-Foundational_Excel_Functions\26. Exploring Excel's AutoSum Shortcut Key.mp4
[8c8276a81f8e9c8]
|
20,952,253 |
27CF4B3D |
|
Chapter_4-Foundational_Excel_Functions\27. Efficient Formula Copying with the AutoFill Command in Excel.mp4
[acd0d97fc9784bbc]
|
52,006,933 |
0E916806 |
|
Chapter_4-Foundational_Excel_Functions\Extra_Files\Functions.pptx |
106,321 |
AF4ADF2B |
|
Chapter_5-Enhancing_an_Excel_Worksheets_Structure\28. Data Relocation Techniques in Excel.mp4
[f713899b451d4cbb]
|
72,383,136 |
09B0457C |
|
Chapter_5-Enhancing_an_Excel_Worksheets_Structure\29. Efficient Row and Column Management in Excel.mp4
[8106a6a08723d31d]
|
76,998,297 |
DF9EE27A |
|
Chapter_5-Enhancing_an_Excel_Worksheets_Structure\30. Adjusting Cell Dimensions with Precision.mp4
[f9bb4c612f9e984d]
|
66,141,958 |
97CF2E21 |
|
Chapter_5-Enhancing_an_Excel_Worksheets_Structure\31. Concealing and Revealing Rows and Columns in Excel.mp4
[aa425786aa1a721a]
|
56,799,356 |
16557C43 |
|
Chapter_5-Enhancing_an_Excel_Worksheets_Structure\32. Worksheet Renaming Strategies in Excel.mp4
[ea14bc98dbd83dc6]
|
26,348,104 |
1CDEDB6F |
|
Chapter_5-Enhancing_an_Excel_Worksheets_Structure\33. Removing Excel Worksheets Strategically.mp4
[7afdcb3b1f594b3b]
|
30,758,125 |
D7776F8E |
|
Chapter_5-Enhancing_an_Excel_Worksheets_Structure\34. Excel Worksheet Relocation and Duplication Methods.mp4
[c005a0bfd0d98b02]
|
61,812,190 |
1A8D091E |
|
Chapter_6-Excel_Worksheet_Data_Formatting_Techniques\35. Employing Font Formatting Techniques in Excel.mp4
[41d6105790c2419c]
|
45,257,645 |
6D2BFBB5 |
|
Chapter_6-Excel_Worksheet_Data_Formatting_Techniques\36. Customizing Cell Background Colors in Excel.mp4
[6ebab544f6420b53]
|
28,054,989 |
B55B5476 |
|
Chapter_6-Excel_Worksheet_Data_Formatting_Techniques\37. Enhancing Cells with Borders in Excel.mp4
[84dd81e80121c665]
|
40,551,857 |
0DC017D4 |
|
Chapter_6-Excel_Worksheet_Data_Formatting_Techniques\38. Transforming Data into Currency Values in Excel.mp4
[4ddf03f1842cdce0]
|
58,811,496 |
9A05D0CD |
|
Chapter_6-Excel_Worksheet_Data_Formatting_Techniques\39. Precise Formatting for Percentages in Excel.mp4
[cf69b9020b81db5f]
|
21,339,861 |
C557A341 |
|
Chapter_6-Excel_Worksheet_Data_Formatting_Techniques\40. Harnessing Excel's Format Painter Tool.mp4
[4dcb043c5f47586a]
|
31,765,507 |
57557067 |
|
Chapter_6-Excel_Worksheet_Data_Formatting_Techniques\41. Crafting Data Styles for Elegant Presentation.mp4
[f82ac36d2e8fb49]
|
80,260,367 |
FEAD77EC |
|
Chapter_6-Excel_Worksheet_Data_Formatting_Techniques\42. Consolidating and Centering Excel Cells.mp4
[52d16fd526439440]
|
28,529,620 |
CEBB1306 |
|
Chapter_6-Excel_Worksheet_Data_Formatting_Techniques\43. Harnessing the Power of Conditional Formatting in Excel.mp4
[f1d41320d3c0ac98]
|
55,633,143 |
10CF9B23 |
|
Chapter_7-Incorporating_Visual_Elements_in_an_Excel_Worksheet\44. Harnessing Excel's SmartArt for Effective Visual Communication.mp4
[4b9ad9b9ce0c88bd]
|
51,160,878 |
56661A49 |
|
Chapter_7-Incorporating_Visual_Elements_in_an_Excel_Worksheet\45. Utilizing Custom Shapes in Excel.mp4
[5f6a660510837e90]
|
46,121,595 |
13089B18 |
|
Chapter_7-Incorporating_Visual_Elements_in_an_Excel_Worksheet\46. Enhancing Excel Shapes with Professional Formatting.mp4
[5f17305550aab1c1]
|
51,806,009 |
599069A2 |
|
Chapter_7-Incorporating_Visual_Elements_in_an_Excel_Worksheet\47. Harnessing Excel's SmartArt for Effective Visual Communication.mp4
[a661e4389f938b8d]
|
70,570,145 |
5DE609C2 |
|
Chapter_8-Fundamentals_of_Chart_Creation\48. Crafting an Excel Column Chart.mp4
[ed832880bbb88a7b]
|
60,706,165 |
80BC76D0 |
|
Chapter_8-Fundamentals_of_Chart_Creation\49. Utilizing the Excel Chart Ribbon for Precision.mp4
[d27122e1475b5549]
|
61,932,769 |
1053B496 |
|
Chapter_8-Fundamentals_of_Chart_Creation\50. Incorporating and Enhancing Data in Excel Charts.mp4
[55f90abec5d9e7c5]
|
44,600,480 |
30A83972 |
|
Chapter_8-Fundamentals_of_Chart_Creation\51. Applying Advanced Formatting Techniques to Excel Charts.mp4
[bf42fdf33675930b]
|
67,028,177 |
3FA4EB0C |
|
Chapter_8-Fundamentals_of_Chart_Creation\52. Transferring Charts Across Worksheets with Finesse.mp4
[f7c98900930f4fc8]
|
26,566,575 |
6D6822A6 |
|
Chapter_8-Fundamentals_of_Chart_Creation\53. Mastering the Art of Excel Pie Charts.mp4
[49d996ca40078246]
|
54,794,826 |
CC36D20C |
|
Chapter_9-Excel_Worksheet_Printing_Techniques\54. Examining Document Appearance in Print Preview.mp4
[2d4d8f1845b821af]
|
19,496,621 |
93784880 |
|
Chapter_9-Excel_Worksheet_Printing_Techniques\55. Customizing Margins, Scaling, and Page Orientation.mp4
[38a9e086abb2aea4]
|
65,569,653 |
D06C0BF7 |
|
Chapter_9-Excel_Worksheet_Printing_Techniques\56. Navigating Page Layout View with Precision.mp4
[488018e1685de00e]
|
29,074,391 |
A07CB37B |
|
Chapter_9-Excel_Worksheet_Printing_Techniques\57. Incorporating Professional Header and Footer Content.mp4
[2a02b0eca1181b82]
|
57,549,542 |
C3339B81 |
|
Chapter_9-Excel_Worksheet_Printing_Techniques\58. Printing Selected Cell Ranges with Finesse.mp4
[1ede09197cc7c49f]
|
32,871,650 |
9C8A58FA |
|
Chapter_10-Excel_Template_Ultilization_Strategies\59. Understanding Excel Template Essentials.mp4
[a55a31c377587820]
|
18,580,186 |
CC9FC12F |
|
Chapter_10-Excel_Template_Ultilization_Strategies\60. Accessing Pre-existing Templates.mp4
[66856465610c7342]
|
73,535,563 |
279F71C1 |
|
Chapter_10-Excel_Template_Ultilization_Strategies\61. Crafting Tailored Custom Templates.mp4
[7be16c8b363f47de]
|
56,006,988 |
1A4DCAF2 |
|
Chapter_11-Wrapping_up_the_Microsoft_Excel_Foundation_Level\62. Congratulations!.mp4
[763a6717e731f284]
|
17,655,722 |
4F909ABE |
|
Chapter_11-Wrapping_up_the_Microsoft_Excel_Foundation_Level\Extra_Files\Monthly+Budget+-+(Completed+File).xlsx |
36,358 |
04F6F954 |
|
Chapter_12-Microsoft_Excel_intermediary_Level_Introduction\Excel+Intermediary+Exercise.xlsx |
580,573 |
E722F853 |
|
Chapter_13-Excel_List_Management_Techniques\64. Grasping the Architecture of Excel Lists.mp4
[514ffb5843542f41]
|
101,574,025 |
84E1A195 |
|
Chapter_13-Excel_List_Management_Techniques\65. Single-Level Sorting Techniques for Lists.mp4
[94c00ac1b087cc8b]
|
59,977,619 |
34D6B805 |
|
Chapter_13-Excel_List_Management_Techniques\66. Advanced Multi-Level Sorting in Excel Lists.mp4
[f903146db3372cb7]
|
58,058,916 |
71EE9EBB |
|
Chapter_13-Excel_List_Management_Techniques\67. Customized Sorting Approaches for Excel Lists.mp4
[ec5eb7cfd7fcd19a]
|
71,768,884 |
99DBF2E7 |
|
Chapter_13-Excel_List_Management_Techniques\68. Employing AutoFilter for List Filtering.mp4
[cddd32ea7dd5f6a]
|
43,507,882 |
5BE750A4 |
|
Chapter_13-Excel_List_Management_Techniques\69. Implementing Subtotals Effectively in Lists.mp4
[a45fa6f49fe33034]
|
113,035,230 |
C1DBBE00 |
|
Chapter_13-Excel_List_Management_Techniques\70. Transforming Lists into Structured Tables.mp4
[f0f29826177acd1a]
|
165,246,914 |
8178F125 |
|
Chapter_13-Excel_List_Management_Techniques\71. Detecting Duplicates with Conditional Formatting.mp4
[126f0d832e863e6e]
|
67,356,382 |
B98585C2 |
|
Chapter_13-Excel_List_Management_Techniques\72. Efficient Duplicate Removal Strategies.mp4
[7761118c30b4398b]
|
67,003,783 |
3E653E23 |
|
Chapter_14-Mastering_Excel_List_Functions\73. Introduction to Excels Function DSUM().mp4
[5c5cb34b845727a9]
|
70,719,558 |
84E797D3 |
|
Chapter_14-Mastering_Excel_List_Functions\74. Excel DSUM Function Single Criteria Continued.mp4
[21567c44d283a9fe]
|
79,883,504 |
130AF4B8 |
|
Chapter_14-Mastering_Excel_List_Functions\75. Excel DSUM Function with OR Criteria.mp4
[652ad44aa0b890ae]
|
45,509,563 |
650E2F5C |
|
Chapter_14-Mastering_Excel_List_Functions\76. Excel DSUM Function with AND Criteria.mp4
[1bab0d9f5d22e9b]
|
137,339,926 |
C65CAF61 |
|
Chapter_14-Mastering_Excel_List_Functions\77. Excel Function DAVERAGE().mp4
[780232ea9bb6d64c]
|
81,829,543 |
39AE15F1 |
|
Chapter_14-Mastering_Excel_List_Functions\78. Excel Function DCOUNT().mp4
[414e68ccc3fd78ac]
|
105,915,358 |
4FD0936A |
|
Chapter_14-Mastering_Excel_List_Functions\79. Excel Function SUBTOTAL().mp4
[aa82e3ae1fb9cb07]
|
151,233,914 |
4B4C8C7D |
|
Chapter_15-Enhancing_Data_Quality_with_Excel_Validation_Techniques\80. Grasping the Significance of Data Validation in Excel.mp4
[895033c6dd8d0cc]
|
61,794,347 |
4EF9D5F4 |
|
Chapter_15-Enhancing_Data_Quality_with_Excel_Validation_Techniques\81. Constructing Excel Data Validation Lists for Precision.mp4
[abb328a2c171861d]
|
76,229,169 |
A2050196 |
|
Chapter_15-Enhancing_Data_Quality_with_Excel_Validation_Techniques\82. Excel Data Validation for Numeric Input Enhancement.mp4
[d72d1e6a0bb8487e]
|
59,563,173 |
BAC857E9 |
|
Chapter_15-Enhancing_Data_Quality_with_Excel_Validation_Techniques\83. Enhancing Data Validation with Custom Error Handling in Excel.mp4
[4f6602dd5b2f7fae]
|
107,211,045 |
B9940012 |
|
Chapter_15-Enhancing_Data_Quality_with_Excel_Validation_Techniques\84. Employing Dynamic Formulas with Excel Data Validation Techniques.mp4
[70fade21866204b]
|
103,750,114 |
33C60B6B |
|
Chapter_16-Mastering_Excel_PivotTables_Advanced_Data_Analysis\85. Grasping the Essence of PivotTables in Excel.mp4
[5dc45067124a5b8e]
|
54,202,570 |
038A7AFC |
|
Chapter_16-Mastering_Excel_PivotTables_Advanced_Data_Analysis\86. Crafting Excel PivotTables with Precision.mp4
[ef50a3ef5141d292]
|
91,474,592 |
371C8A89 |
|
Chapter_16-Mastering_Excel_PivotTables_Advanced_Data_Analysis\87. Enhancing PivotTable Calculations in Excel.mp4
[a9799e87571db036]
|
98,708,745 |
08BE7BCB |
|
Chapter_16-Mastering_Excel_PivotTables_Advanced_Data_Analysis\88. Strategically Grouping Data in PivotTables.mp4
[b7484f5cda3ad82c]
|
53,396,185 |
A158EC74 |
|
Chapter_16-Mastering_Excel_PivotTables_Advanced_Data_Analysis\89. Polishing the Presentation of PivotTable Data.mp4
[e5863d99e9df761b]
|
45,538,277 |
9BBFF5E2 |
|
Chapter_16-Mastering_Excel_PivotTables_Advanced_Data_Analysis\90. In-Depth Analysis of PivotTable Data.mp4
[e9c08c188fad3b5d]
|
64,813,817 |
B69D1F03 |
|
Chapter_16-Mastering_Excel_PivotTables_Advanced_Data_Analysis\91. Designing Dynamic PivotCharts.mp4
[8517f485bc17ebba]
|
59,684,859 |
E8E9797D |
|
Chapter_16-Mastering_Excel_PivotTables_Advanced_Data_Analysis\92. Refining Data Selection in PivotTables.mp4
[3ca7c4913b6db71e]
|
49,741,368 |
60597385 |
|
Chapter_16-Mastering_Excel_PivotTables_Advanced_Data_Analysis\93. Streamlining Data Filtering with the Slicer Tool in Excel.mp4
[866d90fd4112ae8e]
|
59,076,887 |
EAB5ADE4 |
|
Chapter_17-Mastering_Excels_PowerPivot_Capabilities\94. The Significance of PowerPivot in Excel.mp4
[c47736fe48632555]
|
80,374,957 |
2B8F2A8E |
|
Chapter_17-Mastering_Excels_PowerPivot_Capabilities\95. Enabling the Excel PowerPivot Add-in.mp4
[959e1b4b11e8202c]
|
22,248,655 |
06E2DDA2 |
|
Chapter_17-Mastering_Excels_PowerPivot_Capabilities\96. Constructing Data Models using PowerPivot.mp4
[b986ba26aec2e67a]
|
76,354,271 |
6DBCB55B |
|
Chapter_17-Mastering_Excels_PowerPivot_Capabilities\97. Building PivotTables from Data Models.mp4
[9539fd5967810f40]
|
61,122,398 |
FB8EEE4F |
|
Chapter_17-Mastering_Excels_PowerPivot_Capabilities\98. Harnessing PowerPivot for Advanced Calculations.mp4
[ab272c267fee43db]
|
55,927,401 |
562695AA |
|
Chapter_17-Mastering_Excels_PowerPivot_Capabilities\99. Utilizing PowerPivot for Key Performance Indicators (KPIs).mp4
[5b039d6287c537c1]
|
95,488,284 |
45207180 |
|
Chapter_18-Managing_Extensive_Excel_Datasets\100. Mastering Freeze Panes for Excel Data.mp4
[72ea5f4ebedd51a9]
|
59,672,116 |
D0F4F0E3 |
|
Chapter_18-Managing_Extensive_Excel_Datasets\101. Effective Data Grouping (Columns and Rows).mp4
[89d50ca87b1bc0a7]
|
79,094,842 |
9756E180 |
|
Chapter_18-Managing_Extensive_Excel_Datasets\102. Optimal Printing Solutions for Large Data Sets.mp4
[bbbba43d0f513287]
|
114,160,110 |
DDBE3982 |
|
Chapter_18-Managing_Extensive_Excel_Datasets\103. Excel Worksheet Linking and 3D Formulas.mp4
[e337119f731024b7]
|
37,658,936 |
A87DBD45 |
|
Chapter_18-Managing_Extensive_Excel_Datasets\104. Data Consolidation Across Multiple Worksheets.mp4
[48927951a2ecb1e5]
|
45,562,462 |
E0A00352 |
|
Chapter_19-Congratulations_You_have_completed_the_Intermediate_Level\105. Congratulations! You are now an intermediate user of Ms. Excel.mp4
[788b301ee0e21f04]
|
11,368,092 |
BBEDBF79 |
|
Chapter_20-Unlocking_the_Power_of_Advanced_Microsoft_Excel\Excel+Advanced+Exercise.xlsx |
67,201 |
AD2C29AC |
|
Chapter_21-Mastering_Excels_Conditional_Functions\107. Excel Name Ranges An In-Depth Guide.mp4
[6bd44d8c1489144f]
|
54,117,125 |
811EBC6A |
|
Chapter_21-Mastering_Excels_Conditional_Functions\108. Pros and Cons of Excel Name Ranges.mp4
[7af92a427b733c9]
|
88,020,158 |
D8BA2819 |
|
Chapter_21-Mastering_Excels_Conditional_Functions\109. How to Edit Excel Name Ranges Effectively.mp4
[f502751867a7d5f0]
|
25,518,423 |
814A3791 |
|
Chapter_21-Mastering_Excels_Conditional_Functions\110. Harnessing the Power of Excel's IF() Function.mp4
[ab3d02b77281ce6]
|
62,948,125 |
28B29028 |
|
Chapter_21-Mastering_Excels_Conditional_Functions\111. Leveraging Excel's IF() Function with Named Ranges.mp4
[35971148ec678672]
|
84,436,113 |
DAD2DD11 |
|
Chapter_21-Mastering_Excels_Conditional_Functions\112. Advanced Techniques in Nesting Functions with Excel.mp4
[c065c223bde326df]
|
104,666,374 |
FB4FA296 |
|
Chapter_21-Mastering_Excels_Conditional_Functions\113. Enhancing Your Formulas Nesting AND() within IF().mp4
[4896fbb170a82680]
|
76,441,545 |
9518A360 |
|
Chapter_21-Mastering_Excels_Conditional_Functions\114. Unleashing the Potential of Excel's COUNTIF() Function.mp4
[562ce07cb8b1a755]
|
30,074,868 |
B558B25F |
|
Chapter_21-Mastering_Excels_Conditional_Functions\115. Optimizing Data Analysis with Excel's SUMIF() Function.mp4
[45d9d4145b2b273]
|
65,059,241 |
E36B82D3 |
|
Chapter_21-Mastering_Excels_Conditional_Functions\116. Error Handling with Excel's IFERROR() Function.mp4
[bd60d25704a555f4]
|
48,181,334 |
E8EA2A49 |
|
Chapter_29-Advanced_Macros_Module_1_Mastering_Excels_Macro_Recorder_Tool\Extra_Files |
0 |
00000000 |
|
Chapter_31-Advanced_Macros_Module_2_Advancing_to_VBA_Beyond_the_Basics\Extra_Files |
0 |
00000000 |
|
Chapter_32-Advanced_Macros_Module_3_VBA_Data_Prep_Clean_and_Streamline\Extra_Files |
0 |
00000000 |
|
Chapter_33-Advanced_macros_Module_4_VBA_Formulas_Automate_and_Excel\Extra_Files |
0 |
00000000 |
|
Chapter_34-Advanced_Macros_Module_5_Synthesis_Comprehensive_Weekly_Reports\Extra_Files |
0 |
00000000 |
|
Chapter_35-Advanced_macros_Module_6_Interactive_Design_Excel_VBA_User_Forms\Extra_Files |
0 |
00000000 |
|
Chapter_2-Getting_started_with_Microsoft_Excel_The_Basics\Extra_Files |
0 |
00000000 |
|
Chapter_3-Inputting_and_Refining_Text_and_Formulas\Extra_Files |
0 |
00000000 |
|
Chapter_4-Foundational_Excel_Functions\Extra_Files |
0 |
00000000 |
|
Chapter_11-Wrapping_up_the_Microsoft_Excel_Foundation_Level\Extra_Files |
0 |
00000000 |
|
Chapter_22-Excels_Essential_LOOKUP_Functions |
0 |
00000000 |
|
Chapter_23-Excels_Text_Functions_Demystified |
0 |
00000000 |
|
Chapter_24-Excel_Worksheet_Auditing_Techniques |
0 |
00000000 |
|
Chapter_25-Excel_Worksheet_and_Workbook_Security |
0 |
00000000 |
|
Chapter_26-Excels_Advanced_What_if_Analysis |
0 |
00000000 |
|
Chapter_27-Excel_Macros_for_Task_Automation |
0 |
00000000 |
|
Chapter_28-Introduction_to_MS_Excel_Advanced_Macros_using_VBA |
0 |
00000000 |
|
Chapter_29-Advanced_Macros_Module_1_Mastering_Excels_Macro_Recorder_Tool |
0 |
00000000 |
|
Chapter_30-Excel_VBA_Concepts |
0 |
00000000 |
|
Chapter_31-Advanced_Macros_Module_2_Advancing_to_VBA_Beyond_the_Basics |
0 |
00000000 |
|
Chapter_32-Advanced_Macros_Module_3_VBA_Data_Prep_Clean_and_Streamline |
0 |
00000000 |
|
Chapter_33-Advanced_macros_Module_4_VBA_Formulas_Automate_and_Excel |
0 |
00000000 |
|
Chapter_34-Advanced_Macros_Module_5_Synthesis_Comprehensive_Weekly_Reports |
0 |
00000000 |
|
Chapter_35-Advanced_macros_Module_6_Interactive_Design_Excel_VBA_User_Forms |
0 |
00000000 |
|
Chapter_36-Conclusion |
0 |
00000000 |
|
Chapter_1-Introduction |
0 |
00000000 |
|
Chapter_2-Getting_started_with_Microsoft_Excel_The_Basics |
0 |
00000000 |
|
Chapter_3-Inputting_and_Refining_Text_and_Formulas |
0 |
00000000 |
|
Chapter_4-Foundational_Excel_Functions |
0 |
00000000 |
|
Chapter_5-Enhancing_an_Excel_Worksheets_Structure |
0 |
00000000 |
|
Chapter_6-Excel_Worksheet_Data_Formatting_Techniques |
0 |
00000000 |
|
Chapter_7-Incorporating_Visual_Elements_in_an_Excel_Worksheet |
0 |
00000000 |
|
Chapter_8-Fundamentals_of_Chart_Creation |
0 |
00000000 |
|
Chapter_9-Excel_Worksheet_Printing_Techniques |
0 |
00000000 |
|
Chapter_10-Excel_Template_Ultilization_Strategies |
0 |
00000000 |
|
Chapter_11-Wrapping_up_the_Microsoft_Excel_Foundation_Level |
0 |
00000000 |
|
Chapter_12-Microsoft_Excel_intermediary_Level_Introduction |
0 |
00000000 |
|
Chapter_13-Excel_List_Management_Techniques |
0 |
00000000 |
|
Chapter_14-Mastering_Excel_List_Functions |
0 |
00000000 |
|
Chapter_15-Enhancing_Data_Quality_with_Excel_Validation_Techniques |
0 |
00000000 |
|
Chapter_16-Mastering_Excel_PivotTables_Advanced_Data_Analysis |
0 |
00000000 |
|
Chapter_17-Mastering_Excels_PowerPivot_Capabilities |
0 |
00000000 |
|
Chapter_18-Managing_Extensive_Excel_Datasets |
0 |
00000000 |
|
Chapter_19-Congratulations_You_have_completed_the_Intermediate_Level |
0 |
00000000 |
|
Chapter_20-Unlocking_the_Power_of_Advanced_Microsoft_Excel |
0 |
00000000 |
|
Chapter_21-Mastering_Excels_Conditional_Functions |
0 |
00000000 |
|
| Total size: |
10,778,471,445 |
|
|
