download скачать Free download скачать : The 3-in-1 Excel, VBA & SQL Master Course
mp4 | Video: h264,1280X720 | Audio: AAC, 44.1 KHz
Genre:eLearning | Language: English | Size:21.09 GB

Files Included :

1  Introduction.mp4 (34.86 MB)
MP4
2  How to Use The Course.mp4 (31.23 MB)
MP4
3  Select the appropriate plan for you.mp4 (30.46 MB)
MP4
4  Install Office on Windows.mp4 (21.69 MB)
MP4
5  Install Office on a Mac.mp4 (29.48 MB)
MP4
1  Cell References - Part I.mp4 (45.55 MB)
MP4
2  Cell References - Part II.mp4 (78.6 MB)
MP4
3  Cell References - Part III.mp4 (91.7 MB)
MP4
4  Cell References - Part IV.mp4 (59.46 MB)
MP4
5  Cell References - Part V.mp4 (70.26 MB)
MP4
6  Referencing Other Worksheets - Part I.mp4 (39.45 MB)
MP4
7  Referencing Other Worksheets - Part II.mp4 (36.41 MB)
MP4
8  Referencing Other Workbooks - Part I.mp4 (54.53 MB)
MP4
9  Referencing Other Workbooks - Part II.mp4 (47.39 MB)
MP4
1  MATCH.mp4 (72.92 MB)
MP4
2  INDEX Recap.mp4 (49.91 MB)
MP4
3  INDEX MATCH.mp4 (62.45 MB)
MP4
4  INDEX MATCH MATCH.mp4 (45.28 MB)
MP4
1  Working With Multiple Values - Part I.mp4 (36.28 MB)
MP4
10  Array Formula for Finding Unique Values - Part III.mp4 (37.19 MB)
MP4
11  Array Formula for Finding Unique Values - Part IV.mp4 (63.46 MB)
MP4
12  Returning First Distinct Value.mp4 (11.67 MB)
MP4
13  Returning Non-duplicates.mp4 (26.39 MB)
MP4
2  Working With Multiple Values - Part II.mp4 (29.29 MB)
MP4
3  Working With Multiple Values - Part III.mp4 (36.97 MB)
MP4
4  Basic Array Formula Example.mp4 (56 MB)
MP4
5  Conditional Array Formula.mp4 (48.66 MB)
MP4
6  Single Result Array Formula.mp4 (48.39 MB)
MP4
7  The UNIQUE Function.mp4 (25.33 MB)
MP4
8  Array Formula for Finding Unique Values - Part I.mp4 (39.34 MB)
MP4
9  Array Formula for Finding Unique Values - Part II.mp4 (31.08 MB)
MP4
1  Introduction to Charts.mp4 (56.06 MB)
MP4
10  Column Chart - Part IV.mp4 (48.73 MB)
MP4
11  Column Chart - Part V.mp4 (45.41 MB)
MP4
12  Pie Chart - Part I.mp4 (60.05 MB)
MP4
13  Pie Chart - Part II.mp4 (80.1 MB)
MP4
14  Pie Chart - Part III.mp4 (58.44 MB)
MP4
15  Pie Chart - Part IV.mp4 (62.73 MB)
MP4
16  Line Chart - Part I.mp4 (59.33 MB)
MP4
17  Line Chart - Part II.mp4 (68.33 MB)
MP4
18  Combo Chart.mp4 (87.51 MB)
MP4
19  Moving and Copying Charts.mp4 (110.01 MB)
MP4
2  Bar Chart - Part I.mp4 (41.2 MB)
MP4
20  Sparklines - Part I.mp4 (85.4 MB)
MP4
21  Sparklines - Part II.mp4 (63.84 MB)
MP4
22  Sparklines - Part III.mp4 (57.49 MB)
MP4
23  Sparklines - Part IV.mp4 (49.23 MB)
MP4
24  Sparklines - Part V.mp4 (47.65 MB)
MP4
25  People Graph.mp4 (91.07 MB)
MP4
3  Bar Chart - Part II.mp4 (43.72 MB)
MP4
4  Bar Chart - Part III.mp4 (64.48 MB)
MP4
5  Bar Chart - Part IV.mp4 (80.9 MB)
MP4
6  Bar Chart - Part V.mp4 (66.36 MB)
MP4
7  Column Chart - Part I.mp4 (59.75 MB)
MP4
8  Column Chart - Part II.mp4 (37.45 MB)
MP4
9  Column Chart - Part III.mp4 (3.42 MB)
MP4
1  Pivot Table - Part I.mp4 (101.19 MB)
MP4
10  Pivot Table - Part X.mp4 (148.65 MB)
MP4
11  Pivot Table - Part XI.mp4 (48.79 MB)
MP4
12  Pivot Table - Part XII.mp4 (59.06 MB)
MP4
13  Pivot Table - Part XIII.mp4 (70.48 MB)
MP4
14  Pivot Table - Part XIV.mp4 (26.05 MB)
MP4
15  Pivot Table - Part XVa.mp4 (58.4 MB)
MP4
16  Pivot Table - Part XVb.mp4 (90.49 MB)
MP4
17  Pivot Table - Part XVI.mp4 (74.81 MB)
MP4
18  Pivot Table - Part XVII.mp4 (54.25 MB)
MP4
19  Pivot Table - Part XVIII.mp4 (59.3 MB)
MP4
2  Pivot Table - Part II.mp4 (41.27 MB)
MP4
20  Pivot Table - Part XIX.mp4 (44 MB)
MP4
21  Pivot Table - Part XX - Pivot cache I.mp4 (46.26 MB)
MP4
22  Pivot Table - Part XX - Pivot cache II.mp4 (80.04 MB)
MP4
23  Pivot Table - Part XX - Pivot cache III.mp4 (49.7 MB)
MP4
24  Pivot Table with Dates.mp4 (92.39 MB)
MP4
25  Pivot Charts.mp4 (166 MB)
MP4
3  Pivot Table - Part III.mp4 (105.13 MB)
MP4
4  Pivot Table - Part IV.mp4 (49.33 MB)
MP4
5  Pivot Table - Part V.mp4 (78.89 MB)
MP4
6  Pivot Table - Part VI.mp4 (130.21 MB)
MP4
7  Pivot Table - Part VII.mp4 (110.3 MB)
MP4
8  Pivot Table - Part VIII.mp4 (155.5 MB)
MP4
9  Pivot Table - Part IX.mp4 (48.35 MB)
MP4
1  Useful Worksheet Operations.mp4 (97.47 MB)
MP4
1  Comments and Notes.mp4 (56.23 MB)
MP4
10  Find and Replace - Part III.mp4 (66.93 MB)
MP4
11  Find and Replace - Part IV.mp4 (21.39 MB)
MP4
12  Grouping.mp4 (64.74 MB)
MP4
13  Importing External Data.mp4 (54.7 MB)
MP4
14  Merging Cells.mp4 (36.74 MB)
MP4
15  Opening Multiple Excel Files.mp4 (6 MB)
MP4
16  Printing.mp4 (86.12 MB)
MP4
2  Copy & Paste - Part I.mp4 (72.95 MB)
MP4
3  Copy & Paste - Part II.mp4 (74.37 MB)
MP4
4  Copy & Paste - Part III.mp4 (79.88 MB)
MP4
5  Copy & Paste - Part IV.mp4 (59.58 MB)
MP4
6  Copy & Paste - Part V.mp4 (33.68 MB)
MP4
7  Filling Cells.mp4 (13.43 MB)
MP4
8  Find and Replace - Part I.mp4 (70.88 MB)
MP4
9  Find and Replace - Part II.mp4 (32.19 MB)
MP4
1  Swap Names - Part I.mp4 (35.97 MB)
MP4
2  Swap Names - Part II.mp4 (35.98 MB)
MP4
3  Swap Names - Part III.mp4 (24.4 MB)
MP4
4  Swap Names - Part IV.mp4 (32.69 MB)
MP4
5  Swap Names - Part V.mp4 (38.13 MB)
MP4
1  Seat Planning - Part I.mp4 (51.04 MB)
MP4
2  Seat Planning - Part II.mp4 (54.7 MB)
MP4
3  Seat Planning - Part III.mp4 (129.43 MB)
MP4
4  Seat Planning - Part IV.mp4 (101.94 MB)
MP4
5  Seat Planning - Part V.mp4 (50.66 MB)
MP4
6  Seat Planning - Part VI.mp4 (82.16 MB)
MP4
7  Seat Planning - Part VII.mp4 (47.54 MB)
MP4
1  Intro.mp4 (23.33 MB)
MP4
2  Visual Basic Editor.mp4 (26.39 MB)
MP4
1  What is Excel.mp4 (17.38 MB)
MP4
2  Overview of the worksheet.mp4 (46.09 MB)
MP4
3  Overview of the ribbon.mp4 (37.32 MB)
MP4
4  Overview of the top area.mp4 (77.76 MB)
MP4
5  The file tab.mp4 (42.79 MB)
MP4
6  Basic data organisation.mp4 (131.37 MB)
MP4
1  Our First Subroutine.mp4 (23.56 MB)
MP4
10  Cells and Ranges.mp4 (34.77 MB)
MP4
11  Working With Numbers - Part I.mp4 (30.34 MB)
MP4
12  Working With Numbers - Part II.mp4 (65.5 MB)
MP4
13  Working With Numbers - Part III.mp4 (42.47 MB)
MP4
14  Working With Numbers - Part IV.mp4 (29 MB)
MP4
15  Working With Numbers - Part V.mp4 (9.97 MB)
MP4
16  About Bits and Bytes.mp4 (67.78 MB)
MP4
2  Compiling.mp4 (15.26 MB)
MP4
3  Saving a Macro Enabled Workbook.mp4 (7.19 MB)
MP4
4  UPDATE 2023 02 02 Unblocking a macro-enabled Workbook.mp4 (18.75 MB)
MP4
5  Enabling Macros.mp4 (7.74 MB)
MP4
6  Integer Variables - Part I.mp4 (26.75 MB)
MP4
7  Integer Variables - Part II.mp4 (50.77 MB)
MP4
8  String Variables - Part I.mp4 (23.9 MB)
MP4
9  String Variables - Part II.mp4 (52 MB)
MP4
1  Modules.mp4 (28.09 MB)
MP4
10  Arrays - Part II.mp4 (20.73 MB)
MP4
11  Dynamic Arrays.mp4 (51.09 MB)
MP4
12  Range to Array - Part I.mp4 (40.87 MB)
MP4
13  Range to Array - Part II.mp4 (35.4 MB)
MP4
14  The FOR Loop - Part I.mp4 (52.14 MB)
MP4
15  The FOR Loop - Part II.mp4 (13.67 MB)
MP4
16  The FOR Loop - Part III.mp4 (32.56 MB)
MP4
17  The FOR Loop - Part IV.mp4 (12.91 MB)
MP4
18  The FOR Loop - Part V.mp4 (63.84 MB)
MP4
19  The FOR Loop - Part VI.mp4 (54.38 MB)
MP4
2  IF - Part I.mp4 (28.26 MB)
MP4
20  The FOR EACH Loop.mp4 (24.35 MB)
MP4
21  The DO LOOP - Part I.mp4 (46.74 MB)
MP4
22  The DO LOOP - Part II.mp4 (18.25 MB)
MP4
23  The DO LOOP - Part III.mp4 (56.66 MB)
MP4
24  The DO LOOP - Part IV.mp4 (20.28 MB)
MP4
25  The DO LOOP - Part V.mp4 (13.65 MB)
MP4
26  The WHILE WEND Loop.mp4 (101.75 MB)
MP4
3  IF - Part II.mp4 (13.47 MB)
MP4
4  IF - Part III.mp4 (43.7 MB)
MP4
5  IF - Part IV.mp4 (39.05 MB)
MP4
6  Select Case - Part I.mp4 (24.52 MB)
MP4
7  Select Case - Part II.mp4 (26.97 MB)
MP4
8  Select Case - Part III.mp4 (29.95 MB)
MP4
9  Arrays - Part I.mp4 (25.42 MB)
MP4
1  Collections - Part I.mp4 (34.21 MB)
MP4
10  Worksheet Object - Part I.mp4 (44.54 MB)
MP4
11  Worksheet Object - Part II.mp4 (38.97 MB)
MP4
12  Worksheet Object - Part III.mp4 (34.19 MB)
MP4
13  Workbook Object - Part I.mp4 (30.27 MB)
MP4
14  Workbook Object - Part II.mp4 (53.48 MB)
MP4
15  The NOTHING Keyword.mp4 (52.97 MB)
MP4
16  Object and Non-object Variables - Part I.mp4 (74.49 MB)
MP4
17  Object and Non-object Variables - Part II.mp4 (39.87 MB)
MP4
2  Collections - Part II.mp4 (45.08 MB)
MP4
3  Collections - Part III.mp4 (39.82 MB)
MP4
4  Collections - Part IV.mp4 (28.48 MB)
MP4
5  The ActiveSheet Object.mp4 (33.15 MB)
MP4
6  Range Object - Part I.mp4 (32.11 MB)
MP4
7  Range Object - Part II.mp4 (35.3 MB)
MP4
8  Range Object - Part III.mp4 (50.5 MB)
MP4
9  Range Object - Part IV.mp4 (80.89 MB)
MP4
1  Part I.mp4 (37.81 MB)
MP4
2  Part II.mp4 (31.2 MB)
MP4
3  Part III.mp4 (20 MB)
MP4
1  Application Object.mp4 (75.89 MB)
MP4
10  GetColumnLetterPerIndex.mp4 (57.95 MB)
MP4
11  Calling With Named Arguments.mp4 (32.1 MB)
MP4
12  Declaring Arguments.mp4 (30.82 MB)
MP4
13  Optional Arguments.mp4 (39.3 MB)
MP4
14  Ways of Calling Functions and Subs.mp4 (21.75 MB)
MP4
15  Data Type Conversion - Part I.mp4 (76.87 MB)
MP4
16  Data Type Conversion - Part II.mp4 (63.87 MB)
MP4
17  Worksheet Functions.mp4 (59.89 MB)
MP4
18  VarType.mp4 (35.14 MB)
MP4
19  Constants.mp4 (43.76 MB)
MP4
2  Functions.mp4 (53.25 MB)
MP4
20  Module Level Variables and Constants.mp4 (54.38 MB)
MP4
21  Global Variables and Constants.mp4 (25.57 MB)
MP4
3  Option Explicit.mp4 (20.59 MB)
MP4
4  Arguments.mp4 (63.19 MB)
MP4
5  ByVal and ByRef - Part I.mp4 (54.25 MB)
MP4
6  ByVal and ByRef - Part II.mp4 (34.58 MB)
MP4
7  GetLastRow - Part I.mp4 (73.27 MB)
MP4
8  GetLastRow - Part II.mp4 (46.23 MB)
MP4
9  GetLastColumn.mp4 (69.62 MB)
MP4
1  Recording Macro with Absolute Reference - Part I.mp4 (33.69 MB)
MP4
2  Recording Macro with Absolute Reference - Part II.mp4 (44.34 MB)
MP4
3  Running a Macro with Relative References.mp4 (12.22 MB)
MP4
4  Copy Paste Macros - Part I.mp4 (44.21 MB)
MP4
5  Copy Paste Macros - Part II.mp4 (66.82 MB)
MP4
1  Part 1.mp4 (36.84 MB)
MP4
2  Part 2.mp4 (40.99 MB)
MP4
3  Part 3.mp4 (51.27 MB)
MP4
4  Part 4.mp4 (50.13 MB)
MP4
1  Getting User Input - InputBox.mp4 (18.33 MB)
MP4
2  Getting User Input - MsgBox.mp4 (17.17 MB)
MP4
3  Opening a New Workbook.mp4 (22.21 MB)
MP4
4  Opening an Existing Workbook.mp4 (27.08 MB)
MP4
5  Closing a Workbook.mp4 (37.01 MB)
MP4
6  Saving a Workbook.mp4 (49.63 MB)
MP4
1  Workbook Events - Part I.mp4 (45.51 MB)
MP4
2  Workbook Events - Part II.mp4 (61.83 MB)
MP4
3  Worksheet Events.mp4 (21.59 MB)
MP4
1  Exporting and Importing Modules.mp4 (14.28 MB)
MP4
2  Calling a Function or Sub of Another Workbook.mp4 (36.42 MB)
MP4
3  Personal Macro Workbook.mp4 (48.7 MB)
MP4
1  The SUM function - Part I.mp4 (40.97 MB)
MP4
10  Dynamic cell References - Part I.mp4 (33.29 MB)
MP4
11  Dynamic Cell References - Part II.mp4 (33.69 MB)
MP4
12  Basic Formatting - Part I.mp4 (37.62 MB)
MP4
13  Basic Formatting - Part II.mp4 (38.49 MB)
MP4
14  Basic Formatting - Part III.mp4 (25.48 MB)
MP4
15  Basic Formatting - Part IV.mp4 (19.42 MB)
MP4
16  Formulas Bar - Part I.mp4 (41.46 MB)
MP4
17  Formulas Bar - Part II.mp4 (27.37 MB)
MP4
18  Formula Auditing.mp4 (44.59 MB)
MP4
19  Error Checking and the Watch Window - Part I.mp4 (28.23 MB)
MP4
2  The SUM function - Part II.mp4 (64.36 MB)
MP4
20  Error Checking and the Watch Window - Part II.mp4 (28.22 MB)
MP4
3  The SUM function - Part III.mp4 (40.67 MB)
MP4
4  Addition.mp4 (18.63 MB)
MP4
5  Subtraction.mp4 (16.11 MB)
MP4
6  Multiplication - Part I.mp4 (26.42 MB)
MP4
7  Multiplication - Part II.mp4 (33.42 MB)
MP4
8  Division.mp4 (14.95 MB)
MP4
1  Intro to Object-based Programming - Part I.mp4 (40.37 MB)
MP4
10  Calculating the Order Price.mp4 (43.15 MB)
MP4
11  Private and Public keywords in Subs and Functions.mp4 (16.53 MB)
MP4
2  Intro to Object-based Programming - Part II.mp4 (15.91 MB)
MP4
3  Class Modules.mp4 (45.42 MB)
MP4
4  Private Member Variables.mp4 (57.54 MB)
MP4
5  Properties.mp4 (58.81 MB)
MP4
6  Init.mp4 (14.9 MB)
MP4
7  Order Object.mp4 (30.79 MB)
MP4
8  Car Object.mp4 (81.81 MB)
MP4
9  Associate an Order With a Car.mp4 (46.23 MB)
MP4
1  Seat Planning Overview.mp4 (40.54 MB)
MP4
10  Create Pivot Table Macro - Part II.mp4 (48.88 MB)
MP4
2  Check Worksheets.mp4 (67.03 MB)
MP4
3  DeleteWs.mp4 (34.16 MB)
MP4
4  Delete Data.mp4 (11.24 MB)
MP4
5  Add Employee Data.mp4 (80.49 MB)
MP4
6  Copy Employee Data.mp4 (11.93 MB)
MP4
7  Add Location Formula.mp4 (62.05 MB)
MP4
8  Add Free Seats Formulas.mp4 (35 MB)
MP4
9  Create Pivot Table Macro - Part I.mp4 (77.54 MB)
MP4
1  What are SQL and Databases.mp4 (49.65 MB)
MP4
2  Installing Xampp.mp4 (24.19 MB)
MP4
3  Setting Database Password.mp4 (39.33 MB)
MP4
4  Stopping MariaDB.mp4 (3.71 MB)
MP4
1  Creating a Database and a Database Table.mp4 (35.67 MB)
MP4
2  Adding Rows to Tables.mp4 (18.01 MB)
MP4
3  Our First Query.mp4 (23.41 MB)
MP4
1  Installing OBDC Driver.mp4 (24.04 MB)
MP4
2  Setting Up VBA for SQL - Part I.mp4 (37.2 MB)
MP4
3  Setting Up VBA for SQL - Part II.mp4 (8.33 MB)
MP4
4  Setting Up VBA for SQL - Part III.mp4 (55.42 MB)
MP4
1  WHERE.mp4 (46.87 MB)
MP4
10  No Records Returned.mp4 (26 MB)
MP4
11  BETWEEN.mp4 (29.52 MB)
MP4
12  LIKE.mp4 (42.77 MB)
MP4
13  IN.mp4 (18.09 MB)
MP4
14  SELECT DISTINCT.mp4 (15.47 MB)
MP4
2  Adding More data.mp4 (28.84 MB)
MP4
3  ORDER BY.mp4 (39.73 MB)
MP4
4  AND.mp4 (34.9 MB)
MP4
5  OR.mp4 (29.39 MB)
MP4
6  Combining AND and OR.mp4 (35.23 MB)
MP4
7  NOT.mp4 (20.37 MB)
MP4
8  WHERE field is NOT NULL.mp4 (33.09 MB)
MP4
9  AS.mp4 (24.29 MB)
MP4
1  Changing The Table.mp4 (48.03 MB)
MP4
2  Insert Ignore Into - Part I.mp4 (31.43 MB)
MP4
3  Insert Ignore Into - Part II.mp4 (81.14 MB)
MP4
4  UPDATE.mp4 (43.5 MB)
MP4
5  DELETE.mp4 (35.98 MB)
MP4
1  Reinserting The Data.mp4 (11.13 MB)
MP4
2  Exporting a Database.mp4 (54.49 MB)
MP4
3  SQL for Creating a Table.mp4 (44.9 MB)
MP4
4  Create a Table Using SQL.mp4 (75.11 MB)
MP4
5  ALTER TABLE ADD Column.mp4 (49.19 MB)
MP4
6  ALTER TABLE MODIFY Column.mp4 (37.08 MB)
MP4
7  ALTER TABLE DROP Column.mp4 (22.55 MB)
MP4
8  DROP TABLE.mp4 (18.93 MB)
MP4
9  UNIQUE.mp4 (63.25 MB)
MP4
1  LIMIT.mp4 (32.12 MB)
MP4
1  Inner Join - Part I.mp4 (129.21 MB)
MP4
2  Inner Join - Part II.mp4 (48.94 MB)
MP4
3  Left Join.mp4 (35.25 MB)
MP4
1  AVERAGE.mp4 (20.6 MB)
MP4
2  MIN.mp4 (12.81 MB)
MP4
3  MAX.mp4 (13.28 MB)
MP4
4  COUNT.mp4 (20.46 MB)
MP4
1  The MIN Function.mp4 (24.78 MB)
MP4
2  The MAX Function.mp4 (16.82 MB)
MP4
3  The COUNT Function.mp4 (47.02 MB)
MP4
4  The GROUP BY Function.mp4 (28.01 MB)
MP4
5  The AVG Function - Part I.mp4 (17.3 MB)
MP4
6  The AVG Function - Part II.mp4 (63.89 MB)
MP4
7  The SUM Function.mp4 (10.98 MB)
MP4
8  The HAVING Keyword.mp4 (69.34 MB)
MP4
1  Seat Planning Automation VBA and SQL.mp4 (77.71 MB)
MP4
1  Important Notice.mp4 (4.24 MB)
MP4
10  A brief overview of the Edit menu.mp4 (6.96 MB)
MP4
11  The Undo and Redo commands.mp4 (11.56 MB)
MP4
12  A brief overview of the View menu.mp4 (15.69 MB)
MP4
13  A brief overview of the Insert menu.mp4 (5.21 MB)
MP4
14  A brief overview of the Format menu.mp4 (11.76 MB)
MP4
15  A brief overview of the Data menu.mp4 (8.62 MB)
MP4
16  A brief overview of the Tools menu.mp4 (3.98 MB)
MP4
17  A brief overview of the Extensions menu.mp4 (10.13 MB)
MP4
18  A brief overview of the Help menu.mp4 (8.97 MB)
MP4
19  A brief overview of the Toolbar or Command Strip.mp4 (8.23 MB)
MP4
2  What is Google Sheets.mp4 (22.54 MB)
MP4
20  Saving your work.mp4 (4.07 MB)
MP4
21  Adding more data.mp4 (12.69 MB)
MP4
22  The problem with one dimensional data.mp4 (17.1 MB)
MP4
23  Tabular Data.mp4 (29.51 MB)
MP4
24  Adding a header.mp4 (22.56 MB)
MP4
25  End of introduction.mp4 (3.92 MB)
MP4
3  Registering a Google account.mp4 (6.09 MB)
MP4
4  Google Sheets and other software.mp4 (13.57 MB)
MP4
5  Creating a new Spreadsheet.mp4 (11.09 MB)
MP4
6  A brief intro to the Worksheet.mp4 (25.96 MB)
MP4
7  Renaming the Spreadsheet.mp4 (8.22 MB)
MP4
8  Brief discussion of some features.mp4 (14.51 MB)
MP4
9  A brief overview of the File menu.mp4 (18.29 MB)
MP4
1  How to use the resource files.mp4 (18.8 MB)
MP4
2  Column widths and autofitting.mp4 (35.6 MB)
MP4
3  Overflowing cell contents.mp4 (38.26 MB)
MP4
4  Row heights and autofitting.mp4 (16.09 MB)
MP4
5  Adding borders and fill to cells.mp4 (61.21 MB)
MP4
1  Intro to formulas.mp4 (14.54 MB)
MP4
10  The importance of the display language.mp4 (13.29 MB)
MP4
11  The formula help.mp4 (30.28 MB)
MP4
12  Range.mp4 (28.98 MB)
MP4
13  Dynamic cell references - Part 1.mp4 (27.76 MB)
MP4
14  Dynamic cell references - Part 2.mp4 (26.07 MB)
MP4
15  Sometimes we don't even need a formula.mp4 (11.24 MB)
MP4
16  Formula Suggestions.mp4 (16.53 MB)
MP4
17  Where to find more functions.mp4 (15.69 MB)
MP4
2  Addition.mp4 (8.69 MB)
MP4
3  Referring to cells.mp4 (23.28 MB)
MP4
4  Subtraction.mp4 (5.87 MB)
MP4
5  Multiplication.mp4 (4.44 MB)
MP4
6  Operator precedence.mp4 (9.56 MB)
MP4
7  Division.mp4 (10.58 MB)
MP4
8  The SUM function.mp4 (25.15 MB)
MP4
9  The importance of the locale.mp4 (14.89 MB)
MP4
1  Overview of the dashboard.mp4 (28.46 MB)
MP4
2  Moving spreadsheets.mp4 (16.99 MB)
MP4
3  Starring spreadsheets.mp4 (6.84 MB)
MP4
4  Opening a spreadsheet from Google drive.mp4 (11.85 MB)
MP4
1  CTRL SHIFT RIGHT or LEFT ARROW.mp4 (32.36 MB)
MP4
10  Number format 2.mp4 (50.08 MB)
MP4
11  Scientific notation.mp4 (100.29 MB)
MP4
12  Accounting format.mp4 (23.13 MB)
MP4
13  Financial format.mp4 (11.45 MB)
MP4
14  Currency format.mp4 (26.06 MB)
MP4
15  Changing the currency - Part 1.mp4 (30.8 MB)
MP4
16  Changing the currency - Part 2.mp4 (29.52 MB)
MP4
17  Custom number format.mp4 (73.51 MB)
MP4
18  Percent.mp4 (14.1 MB)
MP4
19  Text.mp4 (19.89 MB)
MP4
2  CTRL SHIFT UP or DOWN ARROW.mp4 (12.09 MB)
MP4
20  Dates.mp4 (29.96 MB)
MP4
21  Custom date format.mp4 (29.58 MB)
MP4
22  Date Time.mp4 (18.67 MB)
MP4
23  Time.mp4 (13.21 MB)
MP4
24  Duration.mp4 (9.12 MB)
MP4
3  CTRL A.mp4 (19.44 MB)
MP4
4  SHIFT and cursor.mp4 (5.48 MB)
MP4
5  CTRL cursor.mp4 (17.72 MB)
MP4
6  Named ranges.mp4 (34.36 MB)
MP4
7  Changing a named range.mp4 (5.99 MB)
MP4
8  Deleting a named range.mp4 (14.35 MB)
MP4
9  Number format 1.mp4 (53.41 MB)
MP4
1  Average.mp4 (31.16 MB)
MP4
2  Min.mp4 (6.01 MB)
MP4
3  Max.mp4 (6.56 MB)
MP4
4  Count.mp4 (26.54 MB)
MP4
1  UPPER.mp4 (11.41 MB)
MP4
10  Swapping names 2.mp4 (20.61 MB)
MP4
11  Improving the readability of long formulas.mp4 (15.88 MB)
MP4
12  Avoiding repetition with LET.mp4 (67.93 MB)
MP4
13  TRIM.mp4 (12.27 MB)
MP4
14  REPLACE.mp4 (20.26 MB)
MP4
15  SUBSTITUTE.mp4 (15.92 MB)
MP4
16  SPLIT.mp4 (17.79 MB)
MP4
2  LOWER.mp4 (11.52 MB)
MP4
3  CONCATENATE.mp4 (14.55 MB)
MP4
4  LEN.mp4 (7.89 MB)
MP4
5  FIND and SEARCH.mp4 (26.76 MB)
MP4
6  LEFT.mp4 (40.86 MB)
MP4
7  RIGHT.mp4 (30.91 MB)
MP4
8  MID.mp4 (39.04 MB)
MP4
9  Swapping names 1.mp4 (23.47 MB)
MP4
1  DATE.mp4 (12.81 MB)
MP4
2  DATEDIF.mp4 (21.97 MB)
MP4
3  TODAY.mp4 (4.3 MB)
MP4
4  NOW.mp4 (3.87 MB)
MP4
5  Calculation Settings.mp4 (29.07 MB)
MP4
6  Changing the timezone.mp4 (15.33 MB)
MP4
7  Version history.mp4 (16.81 MB)
MP4
1  Number Formatting - Part I.mp4 (18.81 MB)
MP4
10  Currencies - Part II.mp4 (53.8 MB)
MP4
11  Fractions.mp4 (43.44 MB)
MP4
13  Text - Part I.mp4 (44.04 MB)
MP4
14  Text - Part II - Character set.mp4 (5.25 MB)
MP4
15  Text - Part III - Numbers formatted as text.mp4 (29.96 MB)
MP4
16  Formatting The Table - Part I - Text Filters I.mp4 (51.15 MB)
MP4
17  Formatting The Table - Part II - Text Filters II.mp4 (40.57 MB)
MP4
18  Formatting The Table - Part III - Text Filters III.mp4 (50.41 MB)
MP4
19  Formatting The Table - Part IV - Number Filters I.mp4 (36.57 MB)
MP4
2  Number Formatting - Part II.mp4 (30.42 MB)
MP4
20  Formatting The Table - Part V - Number Filters II.mp4 (20.92 MB)
MP4
21  Formatting The Table - Part VI - Color filters.mp4 (47.38 MB)
MP4
22  Formatting The Table - Part VII - Date Filters.mp4 (40.32 MB)
MP4
23  Formatting The Table - Part VIII - Sorting.mp4 (67.03 MB)
MP4
24  Formatting The Table - Part IX - Multi-level sorting.mp4 (78.89 MB)
MP4
25  Formatting The Table - Part X - Autofitting.mp4 (93.41 MB)
MP4
26  Formatting The Table - Part XI - Wrapping text.mp4 (94.42 MB)
MP4
27  Formatting The Table - Part XII - Freeze Panes.mp4 (70.7 MB)
MP4
28  Formatting The Table - Part XIII - Cut-copy rows and columns.mp4 (37.5 MB)
MP4
29  Named Ranges - Part I.mp4 (64.79 MB)
MP4
3  Number Formatting - Part III.mp4 (19.65 MB)
MP4
30  Named Ranges - Part II.mp4 (62.22 MB)
MP4
31  Inserted Tables - Part I.mp4 (75.97 MB)
MP4
32  Inserted Tables - Part II.mp4 (105.16 MB)
MP4
4  Number Formatting - Part IV.mp4 (21.28 MB)
MP4
5  Date Formatting - Part I.mp4 (29.91 MB)
MP4
6  Date Formatting - Part II.mp4 (35.02 MB)
MP4
7  Epoch.mp4 (25.91 MB)
MP4
8  Percentages.mp4 (76.08 MB)
MP4
9  Currencies - Part I.mp4 (52.58 MB)
MP4
1  Conditional logic.mp4 (47.51 MB)
MP4
10  SUMIF and SUMIFS.mp4 (57.08 MB)
MP4
11  COUNTIF and COUNTIFS.mp4 (36.6 MB)
MP4
2  IF.mp4 (36.83 MB)
MP4
3  IFS - Part 1.mp4 (44.12 MB)
MP4
4  IFS - Part 2.mp4 (19.46 MB)
MP4
5  OR.mp4 (16.13 MB)
MP4
6  IF combined with OR.mp4 (22.93 MB)
MP4
7  AND.mp4 (23.67 MB)
MP4
8  IF combined with AND.mp4 (20.31 MB)
MP4
9  A challenge with IF OR AND.mp4 (45.79 MB)
MP4
1  Sorting data - Part 1.mp4 (42.65 MB)
MP4
10  Slicers.mp4 (30.54 MB)
MP4
2  Sorting data - Part 2.mp4 (52.94 MB)
MP4
3  Sorting data - Part 3.mp4 (58.56 MB)
MP4
4  Filters - Part 1.mp4 (26.26 MB)
MP4
5  Filters - Part 2.mp4 (34.04 MB)
MP4
6  Filters - Part 3.mp4 (49.6 MB)
MP4
7  Filters - Part 4.mp4 (17.74 MB)
MP4
8  Filters - Part 5.mp4 (20.36 MB)
MP4
9  Filter Views.mp4 (31.76 MB)
MP4
1  Useful Excel Shortcuts.mp4 (50 MB)
MP4
10  Iterative calculation - Part 7 of 14 - A more meaningful example.mp4 (13.68 MB)
MP4
11  Iterative calculation - Part 8 of 14 - Calculating interest without circular ref.mp4 (11.75 MB)
MP4
12  Iterative calculation - Part 9 of 14 - Calculating interest with circular ref.mp4 (34.72 MB)
MP4
13  Iterative calculation - Part 10 of 14 - The Kryptonite example.mp4 (14.21 MB)
MP4
14  Iterative calculation - 11 of 14 - Calculating amortization without circular ref.mp4 (8.23 MB)
MP4
15  Iterative calculation - 12 of 14 - Calculating amortization with circular ref.mp4 (24.65 MB)
MP4
16  Iterative calculation - 13 of 14 - The Maximum Change condition.mp4 (26.68 MB)
MP4
17  Iterative calculation - 14 of 14 - Is iterative calculation useful.mp4 (17.69 MB)
MP4
18  Will chatGPT take our Excel jobs.mp4 (106.93 MB)
MP4
2  Copy only visible cells - Part 1 of 2.mp4 (83.61 MB)
MP4
3  Copy only visible cells - Part 2 of 2.mp4 (47.73 MB)
MP4
4  Iterative calculation - Part  1 of 14 - Circular references.mp4 (20.02 MB)
MP4
5  Iterative calculation - Part 2 of 14 - Enabling iterative calculation.mp4 (14.72 MB)
MP4
6  Iterative calculation - Part 3 of 14 - Formulas without circular references.mp4 (6.9 MB)
MP4
7  Iterative calculation - Part 4 of 14 - Looking at each iteration.mp4 (18.22 MB)
MP4
8  Iterative calculation - Part 5 of 14 - The problem with Automatic calculations.mp4 (15.08 MB)
MP4
9  Iterative calculation - Part 6 of 14 - Switching to Manual calculation.mp4 (15.02 MB)
MP4
1  The INDEX Function - Part I.mp4 (71.19 MB)
MP4
10  The VLOOKUP Function - Part V.mp4 (49.6 MB)
MP4
11  The VLOOKUP Function - Part VI.mp4 (27.4 MB)
MP4
2  The INDEX Function - Part II.mp4 (52.87 MB)
MP4
3  The INDEX Function - Part III.mp4 (50.11 MB)
MP4
4  The SUM Function Combined With the INDEX Function.mp4 (55.21 MB)
MP4
5  The VLOOKUP Function - Part I.mp4 (88.68 MB)
MP4
6  A Quick Detour The Search Functionality.mp4 (20.73 MB)
MP4
7  The VLOOKUP Function - Part II.mp4 (48.47 MB)
MP4
8  The VLOOKUP Function - Part III.mp4 (27.94 MB)
MP4
9  The VLOOKUP Function - Part IV.mp4 (39.17 MB)
MP4
1  The IFERROR function - Part I.mp4 (42.53 MB)
MP4
2  The IFERROR function - Part II.mp4 (15.65 MB)
MP4
3  The NAME Error.mp4 (9.71 MB)
MP4
4  The VALUE Error.mp4 (17.29 MB)
MP4
5  The REF Error.mp4 (18.17 MB)
MP4
6  The NUM Error.mp4 (7.15 MB)
MP4
7  The DIV0 Error.mp4 (3.91 MB)
MP4
8  The NULL Error.mp4 (8.98 MB)
MP4
1  TRIM - Part I.mp4 (46.78 MB)
MP4
2  TRIM - Part II - LEN.mp4 (65.48 MB)
MP4
3  TRIM - Part III - Checking for equality.mp4 (77.4 MB)
MP4
4  Removing Blank Rows.mp4 (12.93 MB)
MP4
5  Hiding and Unhiding Rows and Columns.mp4 (48.48 MB)
MP4
6  Dropdown Lists - Part I.mp4 (60.85 MB)
MP4
7  Dropdown Lists - Part II.mp4 (45.94 MB)
MP4
8  Dropdown Lists - Part III.mp4 (62.07 MB)
MP4
1  IF - Part I.mp4 (45.47 MB)
MP4
11  COUNTIF - Part I.mp4 (50.22 MB)
MP4
12  COUNTIF - Part II.mp4 (27.48 MB)
MP4
13  COUNTIFS.mp4 (54.47 MB)
MP4
14  SUMIF - Part I.mp4 (43.79 MB)
MP4
15  SUMIF - Part II.mp4 (21.36 MB)
MP4
16  SUMIFS.mp4 (38.79 MB)
MP4
17  Conditional Formatting - Part I.mp4 (68.97 MB)
MP4
18  Conditional Formatting - Part II.mp4 (51.76 MB)
MP4
19  Conditional Formatting - Part III.mp4 (86.82 MB)
MP4
2  IF - Part II.mp4 (54.6 MB)
MP4
20  Conditional Formatting - Part IV.mp4 (85.51 MB)
MP4
21  Conditional Formatting - Part V.mp4 (76.64 MB)
MP4
22  Conditional Formatting - Part VI.mp4 (36.78 MB)
MP4
3  The IFS - Part I.mp4 (58.44 MB)
MP4
4  The IFS - Part II.mp4 (65.2 MB)
MP4
5  The IFS - Part III.mp4 (55.17 MB)
MP4
6  AND - Part I.mp4 (61.02 MB)
MP4
7  AND - Part II.mp4 (58 MB)
MP4
8  OR - Part I.mp4 (49.5 MB)
MP4
9  OR - Part II.mp4 (27.77 MB)
MP4

 https://rapidgator.net/file/d7d98705d11320706d68babbff9428b9/The_3-in-1_Excel_VBA__SQL_Master_Course.z01
https://rapidgator.net/file/0eff726147309031aabffcac82150447/The_3-in-1_Excel_VBA__SQL_Master_Course.z02
https://rapidgator.net/file/197c9d446e332b2cdc6e5ef3675fd0d8/The_3-in-1_Excel_VBA__SQL_Master_Course.z03
https://rapidgator.net/file/0bbcbbb2d7668f41edc2e25ed740ffad/The_3-in-1_Excel_VBA__SQL_Master_Course.z04
https://rapidgator.net/file/edf4884547a201b9868d60bd68e1eaba/The_3-in-1_Excel_VBA__SQL_Master_Course.z05
https://rapidgator.net/file/24880f9ce9b80765423b1f626a6057e1/The_3-in-1_Excel_VBA__SQL_Master_Course.z06
https://rapidgator.net/file/964351f4a728c2718b8beb0677c74cb2/The_3-in-1_Excel_VBA__SQL_Master_Course.z07
https://rapidgator.net/file/d61a07599bc492e348d305193081ef86/The_3-in-1_Excel_VBA__SQL_Master_Course.z08
https://rapidgator.net/file/ef6384e4ff3921c2039d4baf6a972e39/The_3-in-1_Excel_VBA__SQL_Master_Course.z09
https://rapidgator.net/file/202297e378cd5624a15a57f169766522/The_3-in-1_Excel_VBA__SQL_Master_Course.z10
https://rapidgator.net/file/d7f557d810e29ae809fafef24ba0d786/The_3-in-1_Excel_VBA__SQL_Master_Course.z11
https://rapidgator.net/file/64e789d59571c9d6f6306cd70ca6c9d1/The_3-in-1_Excel_VBA__SQL_Master_Course.z12
https://rapidgator.net/file/093b501da81729e60c25578181d5946c/The_3-in-1_Excel_VBA__SQL_Master_Course.z13
https://rapidgator.net/file/0cb1cf6b112d4582efd631123b5ed9ef/The_3-in-1_Excel_VBA__SQL_Master_Course.z14
https://rapidgator.net/file/5d74f8a515c5d854493ebe9a2cdd414b/The_3-in-1_Excel_VBA__SQL_Master_Course.z15
https://rapidgator.net/file/490fe89a96df695c4589d3a3ec7ea762/The_3-in-1_Excel_VBA__SQL_Master_Course.z16
https://rapidgator.net/file/7451b726883940ca8c1aa715cacacdc8/The_3-in-1_Excel_VBA__SQL_Master_Course.z17
https://rapidgator.net/file/db5b31f9825a4be586c88449a75fd20c/The_3-in-1_Excel_VBA__SQL_Master_Course.z18
https://rapidgator.net/file/8e5765c4efb7d9808df4365fdbb792ec/The_3-in-1_Excel_VBA__SQL_Master_Course.z19
https://rapidgator.net/file/b188b519e1c803a77bd936fbeb71f93b/The_3-in-1_Excel_VBA__SQL_Master_Course.z20
https://rapidgator.net/file/e647e99f766d469c6ed14046d7b1e326/The_3-in-1_Excel_VBA__SQL_Master_Course.z21
https://rapidgator.net/file/376539bc752674d227b5ea76166fbe1e/The_3-in-1_Excel_VBA__SQL_Master_Course.zip

 https://nitroflare.com/view/D1E66A8256D6F27/The_3-in-1_Excel_VBA__SQL_Master_Course.z01
https://nitroflare.com/view/C87004CEA4688EA/The_3-in-1_Excel_VBA__SQL_Master_Course.z02
https://nitroflare.com/view/D3B67ECE95EF51D/The_3-in-1_Excel_VBA__SQL_Master_Course.z03
https://nitroflare.com/view/CF74ED1C6113246/The_3-in-1_Excel_VBA__SQL_Master_Course.z04
https://nitroflare.com/view/955AAB318ECAAEE/The_3-in-1_Excel_VBA__SQL_Master_Course.z05
https://nitroflare.com/view/96483CAACCD9B7A/The_3-in-1_Excel_VBA__SQL_Master_Course.z06
https://nitroflare.com/view/090CBAA35727F98/The_3-in-1_Excel_VBA__SQL_Master_Course.z07
https://nitroflare.com/view/3AF5CD979BA71BE/The_3-in-1_Excel_VBA__SQL_Master_Course.z08
https://nitroflare.com/view/37B98B21EEF130F/The_3-in-1_Excel_VBA__SQL_Master_Course.z09
https://nitroflare.com/view/D2D19A0ED873827/The_3-in-1_Excel_VBA__SQL_Master_Course.z10
https://nitroflare.com/view/B529827C9ECA628/The_3-in-1_Excel_VBA__SQL_Master_Course.z11
https://nitroflare.com/view/00AD08F67B9A7A1/The_3-in-1_Excel_VBA__SQL_Master_Course.z12
https://nitroflare.com/view/7F88883006E55D0/The_3-in-1_Excel_VBA__SQL_Master_Course.z13
https://nitroflare.com/view/08CC4E04C287EB3/The_3-in-1_Excel_VBA__SQL_Master_Course.z14
https://nitroflare.com/view/3C55B9955012F0F/The_3-in-1_Excel_VBA__SQL_Master_Course.z15
https://nitroflare.com/view/2EE554F2DA1F9AA/The_3-in-1_Excel_VBA__SQL_Master_Course.z16
https://nitroflare.com/view/6006CA4BE94D2D8/The_3-in-1_Excel_VBA__SQL_Master_Course.z17
https://nitroflare.com/view/2CD807B8B2922D8/The_3-in-1_Excel_VBA__SQL_Master_Course.z18
https://nitroflare.com/view/DF6E5D31664A08B/The_3-in-1_Excel_VBA__SQL_Master_Course.z19
https://nitroflare.com/view/B396E3D9FF9C900/The_3-in-1_Excel_VBA__SQL_Master_Course.z20
https://nitroflare.com/view/D6EADC6BE6EEB73/The_3-in-1_Excel_VBA__SQL_Master_Course.z21
https://nitroflare.com/view/6E96C4A3438BA80/The_3-in-1_Excel_VBA__SQL_Master_Course.zip