Files Included :
1 - Section 11 Introduction How to Take Course Selecting a Track (379.84 MB)
2 - BIGA Section 12 Settings and Security (62.8 MB)
3 - BIGA Section 13 Help Videos More (207.71 MB)
4 - BIGA Section 14 Downloads of Files (21.39 MB)
115 - GA Section 5 Introduction What Why How We Will Learn Programming (187.08 MB)
116 - GA Introduction to Section 51 Creating Our First Macro (46.52 MB)
117 - GA Lecture 511 How to Record a Macro (114.18 MB)
118 - GA Exercise 511 How to Record a Macro (19.99 MB)
119 - GA Answer 511 How to Record a Macro (18.89 MB)
120 - GA Lecture 512 How to Run a Macro (10.21 MB)
121 - GA Exercise 512 How to Run a Macro (7.62 MB)
122 - GA Answer 512 How to Run a Macro (5.41 MB)
123 - GA Lecture 513 Creating a Shortcut Key for Your Macro (20.25 MB)
124 - GA Exercise 513 Creating a Shortcut Key for Your Macro (7.57 MB)
125 - GA Answer 513 Creating a Shortcut Key for Your Macro (8.28 MB)
126 - GA Lecture 514 Changing the Code the Macro Created (194.66 MB)
127 - GA Exercise 514 Changing the Code the Macro Created (24.12 MB)
128 - GA Answer 514 Changing the Code the Macro Created (27.42 MB)
129 - GA Lecture 515 Adding Buttons Other Controls (185.05 MB)
130 - GA Exercise 515 Adding Buttons Other Controls (37.15 MB)
131 - GA Answer 515 Adding Buttons Other Controls (65.77 MB)
132 - GA Introduction to Section 52 Creating Our First Function (37.88 MB)
133 - GA Lecture 521 How to Create a Function (66.07 MB)
134 - GA Exercise 521 How to Create a Function (18.62 MB)
135 - GA Answer 521 How to Create a Function (23.27 MB)
136 - GA Lecture 522 How to Call a Function within our Sub Code (71.54 MB)
137 - GA Exercise 522 How to Call a Function within our Sub Code (22.38 MB)
138 - GA Answer 522 How to Call a Function within our Sub Code (25.32 MB)
139 - GA Introduction to Section 53 Understanding the VB Interface Objects (53.21 MB)
140 - GA Lecture 531 Modules Contain Subs and Functions (218.01 MB)
141 - GA Exercise 531 Modules Contain Subs and Functions (28.81 MB)
142 - GA Answer 531 Modules Contain Subs and Functions (55.89 MB)
143 - GA Lecture 532 Projects Contain Modules (137.77 MB)
144 - GA Exercise 532 Projects Contain Modules (11.35 MB)
145 - GA Answer 532 Projects Contain Modules (80.52 MB)
146 - GA Lecture 533 Objects Go In Subs and Functions (271.59 MB)
147 - GA Exercise 533 Objects Go In Subs and Functions (28.32 MB)
148 - GA Answer 533 Objects Go In Subs and Functions (31.89 MB)
149 - GA Lecture 534 Objects are Containers for Smaller Objects (97.34 MB)
150 - GA Exercise 534 Objects are Containers for Smaller Objects (17.22 MB)
151 - GA Answer 534 Objects are Containers for Smaller Objects (46.92 MB)
152 - GA Lecture 535 Objects Have Properties (97.09 MB)
153 - GA Exercise 535 Objects Have Properties (11.48 MB)
154 - GA Answer 535 Objects Have Properties (33.27 MB)
155 - GA Lecture 536 Properties Have Values (44.84 MB)
156 - GA Exercise 536 Properties Have Values (8.38 MB)
157 - GA Answer 536 Properties Have Values (58.63 MB)
158 - GA Lecture 537 Objects Have Methods (47.74 MB)
159 - GA Exercise 537 Objects Have Methods (7.75 MB)
160 - GA Answer 537 Objects Have Methods (15.77 MB)
161 - GA Lecture 538 Methods Perform An Action (35.47 MB)
162 - GA Exercise 538 Methods Perform An Action (23.68 MB)
163 - GA Answer 538 Methods Perform An Action (32.72 MB)
164 - GA Lecture 539 Objects in More Detail (77.88 MB)
165 - GA Exercise 539 Objects in More Detail (32.92 MB)
166 - GA Answer 539 Objects in More Detail (74.98 MB)
167 - GA Introduction to Section 54 Data Types Coding Structures Part 1 of 2 (331.09 MB)
168 - GA Introduction to Section 54 Data Types Coding Structures Part 2 of 2 (232.93 MB)
169 - GA Exercise 541 Data Types Explained s Text More (17.51 MB)
170 - GA Answer 541 Data Types Explained s Text More (38.32 MB)
171 - GA Exercise 542 Coding Structures If Then Case Etc (9.76 MB)
172 - GA Answer 542 Coding Structures If Then Case Etc (34.08 MB)
173 - GA Introduction to Section 55 Functions BugsErrors Part 1 of 2 (309.67 MB)
174 - GA Introduction to Section 55 Functions BugsErrors Part 2 of 2 (286.43 MB)
175 - GA Exercise 551 Functions Explained Message Box More (17.49 MB)
176 - GA Answer 551 Functions Explained Message Box More (105.69 MB)
177 - GA Exercise 552 Bugs Handling Errors (9.3 MB)
178 - GA Answer 552 Bugs Handling Errors (51.74 MB)
179 - GA Introduction to Section 56 Putting It All Together Additional Topics (30.6 MB)
180 - GA Lecture 561 Case Study 1 Download Stock Data Part 1 of 5 (320.76 MB)
181 - GA Lecture 561 Case Study 1 Download Stock Data Part 2 of 5 (308.39 MB)
182 - GA Lecture 561 Case Study 1 Download Stock Data Part 3 of 5 (230.53 MB)
183 - GA Lecture 561 Case Study 1 Download Stock Data Part 4 of 5 (196.87 MB)
184 - GA Lecture 561 Case Study 1 Download Stock Data Part 5 of 5 (210.58 MB)
185 - GA Exercise 561 Case Study 1 Download Stock Data (11.16 MB)
186 - GA Answer 561 Case Study 1 Download Stock Data (155.1 MB)
187 - GA Lecture 562 Case Study 2 ActiveX Form Controls Part 1 of 2 (356.97 MB)
188 - GA Lecture 562 Case Study 2 ActiveX Form Controls Part 2 of 2 (339.1 MB)
189 - GA Exercise 562 Case Study 2 ActiveX Form Controls (6.57 MB)
190 - GA Answer 562 Case Study 2 ActiveX Form Controls (67.91 MB)
191 - GA Lecture 563 Additional VBA Topics (188.84 MB)
192 - GA Quiz 563 Additional VBA Topics (7.9 MB)
193 - GA Answer 563 Additional VBA Topics (41.81 MB)
194 - BIGA Introduction to Other Helpful Excel Topics (36.47 MB)
5 - BIA Introduction to Section 2 Excel 101 Foundations Basics Create Edit (59.4 MB)
10 - BA Lecture 212 Cell Alignment (43.3 MB)
11 - BA Exercise 212 Cell Alignment (5.82 MB)
12 - BA Answer 212 Cell Alignment (9.48 MB)
13 - BA Lecture 213 Borders and Shading (56.93 MB)
14 - BA Exercise 213 Borders and Shading (19 MB)
15 - BA Answer 213 Borders and Shading (62.09 MB)
16 - BA Lecture 214 Intro to Formulas Covered in more detail in Section 3 (28.41 MB)
17 - BA Exercise 214 Introduction to Formulas (7.88 MB)
18 - BA Answer 214 Introduction to Formulas (17.65 MB)
19 - BIA Lecture 215 Introduction to Conditional Formatting (38.4 MB)
20 - BIA Exercise 215 Introduction to Conditional Formatting (3.02 MB)
21 - BIA Answer 215 Introduction to Conditional Formatting (2.49 MB)
6 - BA Exercise 21 Intro Excel Foundations Part 1 Money Doubling Exercise (26.87 MB)
7 - BA Lecture 211 Text Number Formatting (81.04 MB)
8 - BA Exercise 211 Text Number Formatting (20.16 MB)
9 - BA Answer 211 Text Number Formatting (10.74 MB)
22 - BA Exercise 22 Introduction Excel Foundations Part 2 Saving Money (65.52 MB)
23 - BA Lecture 221 Inserting Editing Images (122.18 MB)
24 - BA Exercise 221 Inserting Editing Images (22.68 MB)
25 - BA Answer 221 Inserting Editing Images (87.77 MB)
26 - BA Lecture 222 Inserting Editing Icons (30.84 MB)
27 - BA Exercise 222 Inserting Editing Icons (16.06 MB)
28 - BA Answer 222 Inserting Editing Icons (43.69 MB)
29 - BIA Lecture 223 Ordering Images (165.37 MB)
30 - BIA Exercise 223 Ordering Images (6 MB)
31 - BIA Answer 223 Ordering Images (14.49 MB)
32 - BA Lecture 224 Copying Formulas (39.49 MB)
33 - BA Exercise 224 Copying Formulas (9.34 MB)
34 - BA Answer 224 Copying Formulas (5.16 MB)
35 - BIA Lecture 225 Inserting in Formulas (56.08 MB)
36 - BIA Exercise 225 Inserting in Formulas (16.33 MB)
37 - BIA Answer 225 Inserting in Formulas (13.44 MB)
38 - BA Lecture 226 Inserting in Formulas (131.81 MB)
39 - BA Exercise 226 Inserting in Formulas (29.52 MB)
40 - BA Answer 226 Inserting in Formulas (17.97 MB)
41 - BIA Lecture 227 Formatting Numbers in Formulas (55.24 MB)
42 - BIA Exercise 227 Formatting Numbers in Formulas (17.45 MB)
43 - BIA Answer 227 Formatting Numbers in Formulas (40.04 MB)
44 - BA Lecture 228 Inserting Bar Charts (36.79 MB)
45 - BA Exercise 228 Inserting Bar Charts (5.46 MB)
46 - BA Answer 228 Inserting Bar Charts (21.95 MB)
47 - BIA Lecture 229 Inserting Pie Charts (22.01 MB)
48 - BIA Exercise 229 Inserting Pie Charts (8.1 MB)
49 - BIA Answer 229 Inserting Pie Charts (28.82 MB)
50 - BIA Lecture 2210 Inserting Button Hyperlinks (53.81 MB)
51 - BIA Exercise 2210 Inserting Button Hyperlinks (12.75 MB)
52 - BIA Answer 2210 Inserting Button Hyperlinks (45.75 MB)
53 - BA Lecture 2211 Printing (29.93 MB)
54 - BA Exercise 2211 Printing (21.18 MB)
55 - BA Answer 2211 Printing (32.4 MB)
56 - BIGA Introduction to Section 31 The Bigger Picture of Defined Names (24.47 MB)
57 - BIA Lecture 311 How to Use a Defined Name to Simplify Formulas (151.5 MB)
58 - BIA Exercise 311 How to Use a Defined Name to Simplify Formulas (21.32 MB)
59 - BIA Answer 311 How to Use a Defined Name to Simplify Formulas (43.3 MB)
60 - BIA Lecture 312 How to Change Defined Names (111.5 MB)
61 - BIA Exercise 312 How to Change Defined Names (26.62 MB)
62 - BIA Answer 312 How to Change Defined Names (32.66 MB)
63 - IGA Lecture 313 Advanced Defined Names (76.17 MB)
64 - IGA Exercise 313 Advanced Defined Names (27.8 MB)
65 - IGA Answer 313 Advanced Defined Names (91.52 MB)
66 - BIA Introduction to Section 32 The Bigger Picture of Formula Creation (19.85 MB)
67 - BA Lecture 321 How Excel Helps with Basic Formula Creation (70.62 MB)
68 - BA Exercise 321 How Excel Helps with Basic Formula Creation (13.17 MB)
69 - BA Answer 321 How Excel Helps with Basic Formula Creation (22.28 MB)
70 - BA Lecture 322 Beginner Level Formulas (174.57 MB)
71 - BA Exercise 322 Beginner Level Formulas (12.08 MB)
72 - BA Answer 322 Beginner Level Formulas (17.06 MB)
73 - IA Lecture 323 Intermediate Level Formulas (183.45 MB)
74 - IA Exercise 323 Intermediate Level Formulas (15.99 MB)
75 - IA Answer 323 Intermediate Formulas (23.4 MB)
76 - GA Lecture 324 Genius Level Formulas (167.09 MB)
77 - GA Exercise 324 Genius Level Formulas (14.19 MB)
78 - GA Answer 324 Genius Level Formulas (47.59 MB)
79 - GA Lecture 325 Using Formulas in VBA (56.36 MB)
80 - GA Exercise 325 Using Formulas in VBA (6.49 MB)
81 - GA Answer 325 Using Formulas in VBA (15.64 MB)
82 - BIGA Lecture 326 Case Studies on Using Formulas (162.21 MB)
83 - BIGA Exercise 326 Case Studies on Using Formulas (11.97 MB)
84 - BIGA Answer 326 Case Studies on Using Formulas (65.27 MB)
85 - BIA Introduction to Section 41 The Bigger Picture of Charts (15.8 MB)
86 - BA Lecture 411 How Excel Helps with Basic Charts Creation (83.1 MB)
87 - BA Exercise 411 How Excel Helps with Basic Charts Creation (18.84 MB)
88 - BA Answer 411 How Excel Helps with Basic Charts Creation (17.66 MB)
89 - BA Lecture 412 Basic Charts Creation Without Help from Excel (123.79 MB)
90 - BA Exercise 412 Basic Charts Creation Without Help from Excel (27.2 MB)
91 - BA Answer 412 Basic Charts Creation Without Help from Excel (74.67 MB)
92 - IA Lecture 413 Advanced Charts Creation Case Studies (148.47 MB)
93 - IA Exercise 413 Advanced Charts Creation Case Studies (23.53 MB)
94 - IA Answer 413 Advanced Charts Creation Case Studies (63.47 MB)
100 - IGA Exercise 422 How to Create an Advanced Pivot Table (30.77 MB)
101 - IGA Answer 422 How to Create an Advanced Pivot Table (80.4 MB)
102 - IGA Lesson 423 How to Create an Even More Advanced Pivot Table (85.77 MB)
103 - IGA Exercise 423 How to Create an Even More Advanced Pivot Table (26.35 MB)
104 - IGA Answer 423 How to Create an Even More Advanced Pivot Table (145.67 MB)
95 - IGA Introduction to Section 42 The Bigger Picture of Pivot Tables (28.99 MB)
96 - IGA Lesson 421 How to Create a Basic Pivot Table (153.18 MB)
97 - IGA Exercise 421 How to Create a Basic Pivot Table (16.13 MB)
98 - IGA Answer 421 How to Create a Basic Pivot Table (63.07 MB)
99 - IGA Lesson 422 How to Create an Advanced Pivot Table (184.74 MB)
105 - IGA Introduction to Section 43 The Bigger Picture of Dashboards (35.17 MB)
106 - IGA Lecture 431 Global GDP Dashboard Case Study (154.99 MB)
107 - IGA Exercise 431 Global GDP Dashboard Case Study (18.17 MB)
108 - IGA Answer 431 Global GDP Dashboard Case Study (55.49 MB)
109 - IGA Lecture 432 Billionaires Dashboard Case Study (129.57 MB)
110 - IGA Exercise 432 Billionaires Dashboard Case Study (24.63 MB)
111 - IGA Answer 432 Billionaires Dashboard Case Study (77.44 MB)
112 - IGA Lecture 433 Many DashboardsReports Case Studies (266.82 MB)
113 - IGA Exercise 433 Many DashboardsReports Case Studies (10.84 MB)
114 - IGA Answer 433 Many DashboardsReports Case Studies (168.28 MB)
[center]
Screenshot