Microsoft Excel The Ultimate Excel Course from ZandaX

0

1

2

3

4

5

Posted on 09 Nov 18:49 | by AD-TEAM | 9 views

Videos Files :
1 ExcelIntroduction ZandaX.zip (504.66 KB)
1 Introduction Course Overview Includes the course workbook & exercises.mp4 (24.87 MB)
74 Introduction.mp4 (35.43 MB)
75 Formulas with References Overview.mp4 (12.78 MB)
76 Absolute References Overview.mp4 (21.96 MB)
77 Formulas with Absolute References.mp4 (50.74 MB)
78 Autosum Functions SUM & AVERAGE Overview.mp4 (35.04 MB)
79 Autosum Functions SUM & AVERAGE.mp4 (49.25 MB)
80 IF and Nested Functions Overview.mp4 (36.64 MB)
81 IF and Nested Functions.mp4 (89.47 MB)
82 Working with Named Ranges Overview.mp4 (27.56 MB)
83 Working with Named Ranges.mp4 (40.7 MB)
84 Array Functions SUMIF & AVERAGEIF Overview.mp4 (32.32 MB)
85 Array Functions SUMIF & AVERAGEIF.mp4 (81.52 MB)
86 Array Functions SUMIF & AVERAGEIF.mp4 (108.71 MB)
87 Formula Auditing Overview.mp4 (34.28 MB)
88 Formula Auditing.mp4 (86.15 MB)
89 Introduction.mp4 (21.31 MB)
90 Creating Excel Tables Overview.mp4 (15.92 MB)
91 Creating Excel Tables.mp4 (85.11 MB)
92 Working with Records and Filters Overview.mp4 (12.96 MB)
93 Working with Records and Filters.mp4 (17.76 MB)
94 Working with Records and Filters.mp4 (123.07 MB)
95 Advanced Filters Overview.mp4 (20.21 MB)
96 Advanced Filters.mp4 (56.5 MB)
100 Remove Duplicates Overview.mp4 (15.25 MB)
101 Remove Duplicates.mp4 (63.46 MB)
102 Data Validation Overview.mp4 (15.26 MB)
103 Data Validation.mp4 (63.41 MB)
104 Consolidate Overview.mp4 (25.35 MB)
105 Consolidate.mp4 (80.36 MB)
97 Introduction.mp4 (28.4 MB)
98 Text to Columns Overview.mp4 (18.62 MB)
99 Text to Columns.mp4 (46.95 MB)
106 Introduction.mp4 (24.94 MB)
107 Trendlines Overview.mp4 (13.89 MB)
108 Trendlines.mp4 (31.81 MB)
109 Error Bars Overview.mp4 (9.68 MB)
110 Error Bars.mp4 (33.77 MB)
111 Working with Axis Options Overview.mp4 (15.53 MB)
112 Working with Axis Options.mp4 (48.01 MB)
113 Advanced Chart Formatting Overview.mp4 (15.84 MB)
114 Advanced Chart Formatting.mp4 (55.1 MB)
115 Sparklines Overview.mp4 (29.03 MB)
116 Sparklines.mp4 (44.11 MB)
117 Advanced Course Overview Includes the course workbook & exercises.mp4 (27.99 MB)
117 ExcelAdvanced ZandaX.zip (1007.17 KB)
118 Introduction.mp4 (14 MB)
119 Outlining and Grouping Data Overview.mp4 (12.07 MB)
120 Outlining and Grouping Data.mp4 (76.83 MB)
121 Using the Subtotals Tool Overview.mp4 (16.36 MB)
122 Using the Subtotals Tool.mp4 (79.56 MB)
123 Introduction.mp4 (16.14 MB)
124 Exploring Scenarios Overview.mp4 (18.64 MB)
125 Exploring Scenarios.mp4 (82.11 MB)
126 Goal Seek and Data Tables Overview.mp4 (38 MB)
127 Goal Seek.mp4 (25.44 MB)
128 Data Tables.mp4 (50.49 MB)
129 Using Solver Overview.mp4 (24.72 MB)
130 Using Solver.mp4 (87.11 MB)
131 Introduction.mp4 (15.87 MB)
132 Getting Started with PivotTables Overview.mp4 (15.73 MB)
133 Getting Started with PivotTables.mp4 (52.43 MB)
134 Displaying Data in a PivotTable Overview.mp4 (18.73 MB)
135 Displaying Data in a PivotTable.mp4 (108.45 MB)
136 Formatting a PivotTable Overview.mp4 (20.02 MB)
137 Formatting a PivotTable.mp4 (103.69 MB)
138 Slicers Overview.mp4 (22.57 MB)
139 Slicers.mp4 (86.37 MB)
140 Introduction.mp4 (16.62 MB)
141 Getting Started with PivotCharts Overview.mp4 (17.07 MB)
142 Getting Started with PivotCharts.mp4 (46.88 MB)
143 PivotChart Tools and Formatting Overview.mp4 (11.82 MB)
144 PivotChart Tools and Formatting.mp4 (80.04 MB)
10 Getting Help with Excel Overview.mp4 (13.21 MB)
11 Getting Help with Excel.mp4 (61.94 MB)
2 Introduction.mp4 (25.05 MB)
3 Starting Out Overview.mp4 (28.7 MB)
4 Opening Excel.mp4 (32.62 MB)
5 Starting Out.mp4 (7.89 MB)
6 About Workbooks Overview.mp4 (13.81 MB)
7 About Workbooks.mp4 (77.86 MB)
8 Exploring your Workbook Overview.mp4 (20.41 MB)
9 Exploring your Workbook.mp4 (20.53 MB)
145 Introduction.mp4 (12.34 MB)
146 Excel and Hyperlinks Overview.mp4 (21.45 MB)
147 Excel and Hyperlinks.mp4 (97.35 MB)
148 Using Custom AutoFill Lists Overview.mp4 (12.98 MB)
149 Using Custom AutoFill Lists.mp4 (62.45 MB)
150 Sharing Workbooks Overview.mp4 (13.06 MB)
151 Sharing Workbooks.mp4 (76.91 MB)
152 Tracking Changes.mp4 (74.84 MB)
153 Introduction.mp4 (15.66 MB)
154 Using the VLOOKUP Function Overview.mp4 (34.15 MB)
155 Using the VLOOKUP Function.mp4 (48.95 MB)
156 Using the LOOKUP Function Overview.mp4 (24.8 MB)
157 Using the LOOKUP Function.mp4 (50.08 MB)
158 Introduction.mp4 (18.41 MB)
159 Recording and Playing Macros Overview.mp4 (14.38 MB)
160 Recording and Playing Macros.mp4 (107.85 MB)
161 The VBA Editor Overview.mp4 (23.41 MB)
162 The VBA Editor.mp4 (40.41 MB)
163 Visual Basic and Macros.mp4 (62.75 MB)
164 ExcelProfessional ZandaX.zip (1.97 MB)
164 Professional Course Overview Includes the course workbook & exercises.mp4 (25.36 MB)
165 Introduction.mp4 (20.84 MB)
166 Editing Standard Formatting Rules Overview.mp4 (16.17 MB)
167 Editing Standard Formatting Rules.mp4 (48.07 MB)
168 Using Formulas in Conditional Formatting Overview.mp4 (11.67 MB)
169 Using Formulas in Conditional Formatting.mp4 (57.73 MB)
170 More Formulas Overview.mp4 (14.34 MB)
171 More Formulas.mp4 (29.74 MB)
172 Introduction.mp4 (25.15 MB)
173 Using Form Controls Overview.mp4 (16.48 MB)
174 Using Form Controls.mp4 (93.02 MB)
175 Creating Templates Overview.mp4 (10.47 MB)
176 Creating Templates.mp4 (61.19 MB)
177 Introduction.mp4 (33.4 MB)
178 Using the Index Function Overview.mp4 (22.93 MB)
179 Using the Index Function.mp4 (31.21 MB)
180 Using the Index Function.mp4 (27.43 MB)
181 Using the Match Function Overview.mp4 (20.07 MB)
182 Using the Match Function.mp4 (21.77 MB)
183 Using Index and Match Together Overview.mp4 (15.92 MB)
184 Using Index and Match Together.mp4 (55.99 MB)
185 Using Index and Match Together.mp4 (51.82 MB)
186 Using the Indirect Function Overview.mp4 (46.38 MB)
187 Using the Indirect Function.mp4 (48.3 MB)
188 Introduction.mp4 (23.67 MB)
189 Using Error Functions Overview.mp4 (22.17 MB)
190 Using Error Functions.mp4 (59.54 MB)
191 Conditional Error Functions.mp4 (31.4 MB)
192 Using Logical Functions Overview.mp4 (13.17 MB)
193 Using Logical Functions.mp4 (32.12 MB)
194 Using Array Formulas Overview.mp4 (34.69 MB)
195 Using Array Formulas.mp4 (26.93 MB)
196 Using Array Formulas.mp4 (18.81 MB)
197 Using Array Formulas.mp4 (29.68 MB)
198 Using Rounding Functions Overview.mp4 (16.1 MB)
199 Using Rounding Functions.mp4 (50.62 MB)
200 Introduction.mp4 (18.98 MB)
201 Importing Pivot Table Data Overview.mp4 (14.89 MB)
202 Importing Pivot Table Data.mp4 (47.69 MB)
203 Calculated Fields in Pivot Tables Overview.mp4 (14.89 MB)
204 Calculated Fields in Pivot Tables.mp4 (56.23 MB)
205 Showing Pivot Data as a Percentage Overview.mp4 (19.54 MB)
206 Showing Pivot Data as a Percentage.mp4 (80.35 MB)
207 Creating Custom Pivot Tables Styles Overview.mp4 (15.17 MB)
208 Creating Custom Pivot Tables Styles.mp4 (66.65 MB)
209 Introduction.mp4 (22.84 MB)
210 Creating a User Defined Function Overview.mp4 (16.49 MB)
211 Creating a User Defined Function.mp4 (67.59 MB)
212 Creating an Interactive Procedure Overview.mp4 (10.37 MB)
213 Creating an Interactive Procedure.mp4 (79.35 MB)
214 Create and Share a Function Addin Overview.mp4 (22.21 MB)
215 Create and Share a Function Addin.mp4 (67.19 MB)
12 Introduction.mp4 (30.17 MB)
13 The Quick Access Toolbar and File Menu Overview.mp4 (12.26 MB)
14 The Quick Access Toolbar and File Menu.mp4 (42.99 MB)
15 The Home Tab Overview.mp4 (12.79 MB)
16 The Home Tab.mp4 (58.37 MB)
17 The Insert Tab Overview.mp4 (11.09 MB)
18 The Insert Tab.mp4 (52.75 MB)
19 The Page Layout Tab Overview.mp4 (9.63 MB)
20 The Page Layout Tab.mp4 (62.28 MB)
21 The Formulas Tab Overview.mp4 (14.32 MB)
22 The Formulas Tab.mp4 (87.77 MB)
23 The Data Tab Overview.mp4 (11.47 MB)
24 The Data Tab.mp4 (77.7 MB)
25 The Review Tab Overview.mp4 (15.32 MB)
26 The Review Tab.mp4 (55.36 MB)
27 Introduction.mp4 (20.82 MB)
28 Working with Excel Overview.mp4 (11.44 MB)
29 Working with Excel.mp4 (49.13 MB)
30 Moving your Data Overview.mp4 (20.57 MB)
31 Moving your Data.mp4 (23.03 MB)
32 Basic Excel Features Overview.mp4 (17.81 MB)
33 Basic Excel Features.mp4 (63 MB)
34 Smart Tags and Options Buttons Overview.mp4 (37.18 MB)
35 Smart Tags and Options Buttons.mp4 (77.13 MB)
36 Editing Tools Overview.mp4 (12.56 MB)
37 Editing Tools.mp4 (68.21 MB)
38 Introduction.mp4 (27 MB)
39 Cell Formatting Overview.mp4 (7.11 MB)
40 Cell Formatting.mp4 (52.32 MB)
41 Conditional Formatting Overview.mp4 (15.88 MB)
42 Conditional Formatting.mp4 (42.19 MB)
43 Enhancing a Worksheets Appearance Overview.mp4 (11.33 MB)
44 Enhancing a Worksheets Appearance.mp4 (71.07 MB)
45 Introduction.mp4 (17.59 MB)
46 Using the View Tab Overview.mp4 (33.06 MB)
47 Using the View Tab.mp4 (84.34 MB)
48 Using the View Tab.mp4 (42.95 MB)
49 Managing a Single Window Overview.mp4 (19.29 MB)
50 Managing a Single Window.mp4 (83.92 MB)
51 Managing Multiple Windows Overview.mp4 (9.93 MB)
52 Managing Multiple Windows.mp4 (51.89 MB)
53 Setting Up Your Workbook Overview.mp4 (15 MB)
54 Setting Up Your Workbook.mp4 (60.51 MB)
55 Printing Options Overview.mp4 (12.62 MB)
56 Print Page Layout Options.mp4 (60.47 MB)
57 Introduction.mp4 (21.85 MB)
58 Using Recommended and Standard Charts Overview.mp4 (19.79 MB)
59 Using Recommended and Standard Charts.mp4 (32.39 MB)
60 Chart Elements Overview.mp4 (9.24 MB)
61 Chart Elements.mp4 (66.6 MB)
62 Chart Tools Design & Format Overview.mp4 (17.84 MB)
63 Chart Tools Design & Format.mp4 (49.49 MB)
64 Excel Intermediate Exercises.zip (804.97 KB)
64 Intermediate Course Overview Includes the course workbook & exercises.mp4 (23.82 MB)
65 Introduction.mp4 (22.21 MB)
66 Saving and File Management Overview.mp4 (12.75 MB)
67 Saving and File Management.mp4 (30.74 MB)
68 Converting and Encrypting Files Overview.mp4 (26.68 MB)
69 Converting and Encrypting Files.mp4 (48.9 MB)
70 File Properties and Digital Signatures Overview.mp4 (17.3 MB)
71 File Properties and Digital Signatures.mp4 (27.94 MB)
72 File Accessibility and Compatibility Overview.mp4 (26.57 MB)
73 File Accessibility and Compatibility.mp4 (49.53 MB)