Microsoft Excel The Ultimate Excel Course from ZandaX
Language: English
Files Type: zip, mp4, pdf, srt| Size: 7.89 GB
Video: 12:03:43 |  1280X720 | 1665 Kbps
Audio: mp4a-40-2 | 128 Kbps | AAC
Genre:eLearning

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)