5. Adding first few lines of Excel VBA code/5. Troubleshooting connecting to MySQL in VBA explained in detail.mp4 368.4 MB
5. Adding first few lines of Excel VBA code/3. Writing Initialization and termination code in Excel VBA.mp4 246.7 MB
13. From Excel VBA to VB.NET or C# Intro/1. From Excel VBA to VB.NET.mp4 222.4 MB
11. Setting up MySQL server and database on a shared hosting/5. Differences between Windows & Linux related to the MySQL server.mp4 213.6 MB
17. MySQL Data Export & Import/1. MySQL Data Export and Import.mp4 144.8 MB
6. Creating our first Virtual Forms with Virtual Forms Designer for Excel VBA/3. Create your first Virtual Form with VF Designer for Excel.mp4 130.2 MB
16. Virtual Foms Edit control design change/3. Edit control change position of Textboxes.mp4 126.3 MB
2. Setup your database/3. Creating a MySQL database and first tables using a model.mp4 117.0 MB
14. Creating Customers table and Virtual Form/1. Creating a Customers table using a SQL script.mp4 109.2 MB
18. Access database & Excel Workbook as Data source (Using Blank Templates)/2. Excel workbook as the Data source (Using Blank Templates).mp4 107.2 MB
11. Setting up MySQL server and database on a shared hosting/4. Export your database to MySQL server on Shared Hosting using Forward Engineering.mp4 100.8 MB
12. Using hosted database within Excel VBA & Virtual Forms/1. Changing connection string from local to hosted MySQL database in Excel VBA.mp4 99.5 MB
6. Creating our first Virtual Forms with Virtual Forms Designer for Excel VBA/1. Excel VBA code for opening the Virtual Form Designer.mp4 91.8 MB
2. Setup your database/8. Update (Synchronize) MySQL database schema & Model.mp4 91.0 MB
6. Creating our first Virtual Forms with Virtual Forms Designer for Excel VBA/2. Explaining the Virtual Form parts (structure).mp4 89.8 MB
2. Setup your database/2. MySQL server & MySQL Workbench installation.mp4 78.3 MB
18. Access database & Excel Workbook as Data source (Using Blank Templates)/1. Access database as the Data source (Using Blank Templates).mp4 77.7 MB
14. Creating Customers table and Virtual Form/3. Add Customers Virtual Form to Main Menu Userform in Excel VBA.mp4 77.2 MB
6. Creating our first Virtual Forms with Virtual Forms Designer for Excel VBA/6. Tip I call the ShowVirtualForm function and nothing happens.mp4 75.9 MB
Microsoft Excel - Excel from Beginner to Advanced/38. Project #7 Importing Data from Text Files/4. Project #7 Importing Multiple Text Files with the GetOpenFilename Method.mp4 68.8 MB
Microsoft Excel - Excel from Beginner to Advanced/23. Working with Excel's Lookup Functions/3. Using Excel's INDEX() and MATCH() Functions.mp4 67.1 MB
Microsoft Excel - Excel from Beginner to Advanced/38. Project #7 Importing Data from Text Files/9. Project #7 Creating Reusable Code with a VBA Function.mp4 64.0 MB
Microsoft Excel - Excel from Beginner to Advanced/38. Project #7 Importing Data from Text Files/5. Project #7 Creating a Loop to Read Each File.mp4 59.6 MB
Microsoft Excel - Excel from Beginner to Advanced/36. Project #5 Bringing it All Together and a Weekly Report/3. Project #5 - Copying and Pasting Data with VBA.mp4 57.4 MB
Microsoft Excel - Excel from Beginner to Advanced/31. Project #1 Using Excel's Macro Recorder Tool/2. Project #1 Start Recording!.mp4 51.6 MB
Microsoft Excel - Excel from Beginner to Advanced/36. Project #5 Bringing it All Together and a Weekly Report/2. Project #5 Creating the Final Report Loop.mp4 49.6 MB
Microsoft Excel - Excel from Beginner to Advanced/28. Automating Repetitive Tasks in Excel with Macros/3. Creating a Macro with the Macro Recorder.mp4 48.6 MB
Microsoft Excel - Excel from Beginner to Advanced/18. Working with Excel's PowerPivot Tools/3. Creating Data Models with PowerPivot.mp4 48.1 MB
Microsoft Excel - Excel from Beginner to Advanced/27. Mastering Excel's What If Tools/2. Working with Excel's Solver Tool.mp4 46.9 MB
Microsoft Excel - Excel from Beginner to Advanced/32. Excel VBA Concepts/4. Creating an Excel VBA Procedure.mp4 45.1 MB
Microsoft Excel - Excel from Beginner to Advanced/13. Working with an Excel List/7. Format a List as a Table.mp4 44.8 MB
Microsoft Excel - Excel from Beginner to Advanced/38. Project #7 Importing Data from Text Files/2. Project #7 Opening a Text File for Import.mp4 44.3 MB
Microsoft Excel - Excel from Beginner to Advanced/24. Working with Excel's Text Based Functions/3. Using Excel's SEARCH() Function.mp4 43.9 MB
Microsoft Excel - Excel from Beginner to Advanced/19. Working with Large Sets of Excel Data/3. Print Options for Large Sets of Data.mp4 43.0 MB
Microsoft Excel - Excel from Beginner to Advanced/14. Excel List Functions/4. Excel Function SUBTOTAL().mp4 42.6 MB
Microsoft Excel - Excel from Beginner to Advanced/13. Working with an Excel List/6. Creating Subtotals in a List.mp4 41.6 MB
Microsoft Excel - Excel from Beginner to Advanced/14. Excel List Functions/1. Excel Function DSUM().mp4 41.6 MB
Microsoft Excel - Excel from Beginner to Advanced/26. Protecting Excel Worksheets and Workbooks/1. Protecting Specific Cells in a Worksheet.mp4 41.5 MB
Microsoft Excel - Excel from Beginner to Advanced/33. Project #2 Moving Beyond the Basics and into VBA/4. Continue Excel VBA InputBox.mp4 40.8 MB
Microsoft Excel - Data Visualization, Excel Charts & Graphs/05 Next-Level Demos/052 DEMO Building a Dynamic Excel Dashboard (Part 1).mp4 171.4 MB
Microsoft Excel - Data Visualization, Excel Charts & Graphs/05 Next-Level Demos/051 DEMO Creating Interactive Area Charts to Show Changes Over Time.mp4 145.0 MB
Microsoft Excel - Data Visualization, Excel Charts & Graphs/05 Next-Level Demos/056 DEMO Building a Custom Excel Pacing Chart.mp4 130.8 MB
Microsoft Excel - Data Visualization, Excel Charts & Graphs/05 Next-Level Demos/053 DEMO Building a Dynamic Excel Dashboard (Part 2).mp4 127.7 MB
Microsoft Excel - Data Visualization, Excel Charts & Graphs/04 Mastering Basic Excel Charts Graphs/020 DEMO Excel Pie Charts Donuts Race Tracks.mp4 117.0 MB
Microsoft Excel - Data Visualization, Excel Charts & Graphs/05 Next-Level Demos/050 DEMO Adding Scroll Zoom Functionality Using Form Controls.mp4 111.3 MB
Microsoft Excel - Data Visualization, Excel Charts & Graphs/05 Next-Level Demos/055 DEMO Dynamically Highlighting Segments of Data.mp4 107.9 MB
Microsoft Excel - Data Visualization, Excel Charts & Graphs/05 Next-Level Demos/054 DEMO Dynamic Chart Formatting Based on Values.mp4 105.3 MB
Microsoft Excel - Data Visualization, Excel Charts & Graphs/04 Mastering Basic Excel Charts Graphs/042 DEMO Common Excel Combo Charts.mp4 91.5 MB
Microsoft Excel - Data Visualization, Excel Charts & Graphs/04 Mastering Basic Excel Charts Graphs/022 DEMO Excel Scatter Plots.mp4 87.7 MB
Microsoft Excel - Data Visualization, Excel Charts & Graphs/04 Mastering Basic Excel Charts Graphs/034 DEMO Excel Stock Charts.mp4 86.5 MB
Microsoft Excel - Data Visualization, Excel Charts & Graphs/04 Mastering Basic Excel Charts Graphs/012 DEMO Excel Bar Columns Charts.mp4 86.0 MB
Microsoft Excel - Data Visualization, Excel Charts & Graphs/04 Mastering Basic Excel Charts Graphs/038 DEMO Excel Surface 3D Contour Charts.mp4 81.2 MB
Microsoft Excel - Data Visualization, Excel Charts & Graphs/04 Mastering Basic Excel Charts Graphs/032 DEMO Excel Radar Charts.mp4 74.5 MB
Microsoft Excel - Data Visualization, Excel Charts & Graphs/04 Mastering Basic Excel Charts Graphs/023 DEMO Excel Bubble Charts.mp4 71.2 MB
Microsoft Excel - Data Visualization, Excel Charts & Graphs/04 Mastering Basic Excel Charts Graphs/040 DEMO Geo-Spatial Mapping with Excel Power Map.mp4 71.0 MB
Microsoft Excel - Data Visualization, Excel Charts & Graphs/05 Next-Level Demos/057 DEMO Designing a Custom Excel Gauge Chart.mp4 69.0 MB
Microsoft Excel - Data Visualization, Excel Charts & Graphs/03 Excel Chart Formatting Customization/008 Customizing Chart Elements Layouts Styles.mp4 65.6 MB