Creating Progress Bars with Excel VBA

  • Course provided by Udemy
  • Study type: Online
  • Starts: Anytime
  • Price: See latest price on Udemy
Udemy

Course Description

What am I going to learn from this course?

This course is all about using Excel VBA to design and implement progress bars and charts within your Excel projects in order to create better user experience for the users of your Excel tools.

What do I need in order to enroll in this course?


You need to have Microsoft Excel installed on your device, preferably a version after Excel 2013 including.


I am using Excel on Mac. Will this make any difference?

There are certain differences between Excel for Windows and Excel for Mac, so some of the codes may not work properly on Mac.

Do I need to have advanced level of Excel?

It will probably help, but it’s not necessary. If you know what cells, rows, columns, worksheets are, etc., then you can enroll in this course.

Who this course is for:

  • Excel users who would like to make their projects more interesting and to create better user experience

Expected Outcomes

  1. Learn how to create eye-catching progress bars and charts for your projects Monitor the progress in processing data by Excel in real time Minimize the risk of seeing the unpleasant "Not Responding" status in Excel Boost your Excel skill by learning VBA coding and macros Learn how to use shapes in your Excel projects to create better user experience Requirements Basic Excel skills (programming knowledge NOT required). MS Excel installed on your device, preferably a version after Excel 2013 including. Description What am I going to learn from this course? This course is all about using Excel VBA to design and implement progress bars and charts within your Excel projects in order to create better user experience for the users of your Excel tools. What do I need in order to enroll in this course? You need to have Microsoft Excel installed on your device, preferably a version after Excel 2013 including. I am using Excel on Mac. Will this make any difference? There are certain differences between Excel for Windows and Excel for Mac, so some of the codes may not work properly on Mac. Do I need to have advanced level of Excel? It will probably help, but it’s not necessary. If you know what cells, rows, columns, worksheets are, etc., then you can enroll in this course. Who this course is for: Excel users who would like to make their projects more interesting and to create better user experience Show more Show less Course content 6 sections • 97 lectures • 6h 53m total length Expand all sections Designing a Progress Bar (no VBA) 12 lectures • 28min Introduction Preview 01:04 Adding Shapes 01:33 Fill, Outline and Glow 02:41 Width and Height 02:21 Grouping Shapes 02:42 Rectangle With Rounded Corners 03:06 Arranging Shapes 02:46 Adding Text to Shapes 03:45 Making Shapes Transparent 00:59 Adding a BackGround Shape 03:43 Locking Size and Position 02:21 Conclusion 01:02 Introduction to VBA 14 lectures • 50min Introduction Preview 00:58 Enabling the Developer Tab Preview 03:19 Referencing Cells Preview 02:11 Debugging 04:05 The Advantage of Using the Range Object 03:59 Referencing Multiple Cells 04:28 Referencing Cells in Other Worksheets 05:26 Referencing Cells in Other Workbooks 04:15 No "CTRL+Z" after Macros 02:25 Declaring Object Variables 04:23 Finding the Last Row (1) 03:40 Finding the Last Row (2) 04:22 VBA Data Type Summary 05:58 Conclusion 00:54 Designing A Progress Bar with VBA 30 lectures • 1hr 59min Introduction Preview 03:17 Inserting a Shape Preview 04:19 Getting Shapes' Position 04:26 Looping Through Shapes 02:18 Calling / Running Subroutines 02:22 Naming Shapes 04:36 Recording Macros 04:56 Changing Fill and Outline Colors of Shapes 05:01 Bevel Effect 04:56 Making Shapes Transparent 07:23 Adding Text to Shapes 06:25 Changing Font 04:05 ZOrder Method 04:12 Glow Effect 04:15 Grouping Shapes 03:11 Shapes' Placement Property 02:11 Orders Worksheet Introduction 03:54 Finding The Last Row - Recap 04:16 For Next Loops 03:12 Locals Window 03:34 Referencing Multiple Cells Inside the Loop 04:37 If Then Statement 04:40 Not Operator 07:25 Working with a Smaller Set of Data 02:47 It's Simple Mathematics 04:11 Width Property 02:19 timeFrame Macro 03:15 Format Function 04:53 Testing the Codes 01:45 Conclusion 00:27 Using Progress Bars within Multiple Loops 27 lectures • 2hr 34min Introduction Preview 04:41 Adding a Worksheet 04:10 Looping Through Worksheets 05:05 Looping Through Rows 12:45 Debugging 04:19 Vlookup Function 04:12 Vlookup Function in VBA 08:59 Scope of Variables 05:15 CountIfs Function 03:43 CountIfs Function in VBA 05:58 SumIfs Function 03:45 SumIfs Function in VBA 03:05 NumberFormat Property 01:51 Setting Borders 04:16 Removing Duplicates 08:31 Deleting Multiple Columns 04:59 Adding More Worksheets 06:14 Copying Rows 10:13 Designing New Progress Bar 05:19 Finding New Positions 03:53 Adding Progress Status Shape 04:40 Recording Macros 04:27 Copying the Codes 04:32 Testing the First Loop 10:52 Testing the Program 07:28 Tidying Up 09:57 Conclusion 00:46 Charts in VBA 13 lectures • 1hr 2min Introduction Preview 03:43 Adding Charts 02:40 Recording Macros 03:35 Adding Charts with VBA 08:04 Referencing Charts by Name 08:20 Looping to Add Charts 02:30 Chart Title 05:02 Full Series Collection 03:42 Chart Area 03:49 Communicating with Excel Users 04:53 Testing the Program 04:54 Fixing Little Bug 03:17 Optimizing the Position of the Progress Bar 07:10 Conclusion 1 lecture • 1min Conslusion 00:46 Instructor Karen Tateosyan Process Optimization Manager 4.6 Instructor Rating 280 Reviews 1,942 Students 3 Courses My name is Karen and I am from Bulgaria. I work at one of the world’s leading online payment providers but it is the VBA programming in Excel which I would describe as my hobby. During my career I have developed many Excel tools for the companies I have worked for. I believe that Excel is one of the most used programs in the business world. Probably, we spend more time only on Facebook, Instagram and YouTube these days. My mission is to share practical knowledge in Excel VBA which goes beyond knowing how to write a few lines of VBA code. Show more Show less Udemy Business Teach on Udemy Get the app About us Contact us Careers Blog Help and Support Affiliate Impressum Kontakt Terms Privacy policy Cookie settings Sitemap © 2021 Udemy, Inc. window.handleCSSToggleButtonClick = function (event) { var target = event.currentTarget; var cssToggleId = target && target.dataset && target.dataset.cssToggleId; var input = cssToggleId && document.getElementById(cssToggleId); if (input) { if (input.dataset.type === 'checkbox') { input.dataset.checked = input.dataset.checked ? '' : 'checked'; } else { input.dataset.checked = input.dataset.allowToggle && input.dataset.checked ? '' : 'checked'; var radios = document.querySelectorAll('[name="' + input.dataset.name + '"]'); for (var i = 0; i (function(){window['__CF$cv$params']={r:'678191739bae06e1',m:'cb01e41290f69946bf87f6ab2b701e230fa82c99-1627847142-1800-AcR35kWdZ6+3RONv06BnR0hf3D6dXoC1Qdi3oG91g1mtSPb8q/1yzE2lEVZNH5mtzM85eg3ebkQDk9z/e8FYbHlDLlYCPQrVLdwOy7n3JKPoARNJoQUxFxKOiu+PvCV43YRl+dWfcT6ydEy/laLXATMVRXrO4GJaFn7LmYkWkrnm72x2zTgR6Utn6w0WqW/wrg==',s:[0xd1c5e2d060,0x8350401cae],}})();
  2. Monitor the progress in processing data by Excel in real time Minimize the risk of seeing the unpleasant "Not Responding" status in Excel Boost your Excel skill by learning VBA coding and macros Learn how to use shapes in your Excel projects to create better user experience Requirements Basic Excel skills (programming knowledge NOT required). MS Excel installed on your device, preferably a version after Excel 2013 including. Description What am I going to learn from this course? This course is all about using Excel VBA to design and implement progress bars and charts within your Excel projects in order to create better user experience for the users of your Excel tools. What do I need in order to enroll in this course? You need to have Microsoft Excel installed on your device, preferably a version after Excel 2013 including. I am using Excel on Mac. Will this make any difference? There are certain differences between Excel for Windows and Excel for Mac, so some of the codes may not work properly on Mac. Do I need to have advanced level of Excel? It will probably help, but it’s not necessary. If you know what cells, rows, columns, worksheets are, etc., then you can enroll in this course. Who this course is for: Excel users who would like to make their projects more interesting and to create better user experience Show more Show less Course content 6 sections • 97 lectures • 6h 53m total length Expand all sections Designing a Progress Bar (no VBA) 12 lectures • 28min Introduction Preview 01:04 Adding Shapes 01:33 Fill, Outline and Glow 02:41 Width and Height 02:21 Grouping Shapes 02:42 Rectangle With Rounded Corners 03:06 Arranging Shapes 02:46 Adding Text to Shapes 03:45 Making Shapes Transparent 00:59 Adding a BackGround Shape 03:43 Locking Size and Position 02:21 Conclusion 01:02 Introduction to VBA 14 lectures • 50min Introduction Preview 00:58 Enabling the Developer Tab Preview 03:19 Referencing Cells Preview 02:11 Debugging 04:05 The Advantage of Using the Range Object 03:59 Referencing Multiple Cells 04:28 Referencing Cells in Other Worksheets 05:26 Referencing Cells in Other Workbooks 04:15 No "CTRL+Z" after Macros 02:25 Declaring Object Variables 04:23 Finding the Last Row (1) 03:40 Finding the Last Row (2) 04:22 VBA Data Type Summary 05:58 Conclusion 00:54 Designing A Progress Bar with VBA 30 lectures • 1hr 59min Introduction Preview 03:17 Inserting a Shape Preview 04:19 Getting Shapes' Position 04:26 Looping Through Shapes 02:18 Calling / Running Subroutines 02:22 Naming Shapes 04:36 Recording Macros 04:56 Changing Fill and Outline Colors of Shapes 05:01 Bevel Effect 04:56 Making Shapes Transparent 07:23 Adding Text to Shapes 06:25 Changing Font 04:05 ZOrder Method 04:12 Glow Effect 04:15 Grouping Shapes 03:11 Shapes' Placement Property 02:11 Orders Worksheet Introduction 03:54 Finding The Last Row - Recap 04:16 For Next Loops 03:12 Locals Window 03:34 Referencing Multiple Cells Inside the Loop 04:37 If Then Statement 04:40 Not Operator 07:25 Working with a Smaller Set of Data 02:47 It's Simple Mathematics 04:11 Width Property 02:19 timeFrame Macro 03:15 Format Function 04:53 Testing the Codes 01:45 Conclusion 00:27 Using Progress Bars within Multiple Loops 27 lectures • 2hr 34min Introduction Preview 04:41 Adding a Worksheet 04:10 Looping Through Worksheets 05:05 Looping Through Rows 12:45 Debugging 04:19 Vlookup Function 04:12 Vlookup Function in VBA 08:59 Scope of Variables 05:15 CountIfs Function 03:43 CountIfs Function in VBA 05:58 SumIfs Function 03:45 SumIfs Function in VBA 03:05 NumberFormat Property 01:51 Setting Borders 04:16 Removing Duplicates 08:31 Deleting Multiple Columns 04:59 Adding More Worksheets 06:14 Copying Rows 10:13 Designing New Progress Bar 05:19 Finding New Positions 03:53 Adding Progress Status Shape 04:40 Recording Macros 04:27 Copying the Codes 04:32 Testing the First Loop 10:52 Testing the Program 07:28 Tidying Up 09:57 Conclusion 00:46 Charts in VBA 13 lectures • 1hr 2min Introduction Preview 03:43 Adding Charts 02:40 Recording Macros 03:35 Adding Charts with VBA 08:04 Referencing Charts by Name 08:20 Looping to Add Charts 02:30 Chart Title 05:02 Full Series Collection 03:42 Chart Area 03:49 Communicating with Excel Users 04:53 Testing the Program 04:54 Fixing Little Bug 03:17 Optimizing the Position of the Progress Bar 07:10 Conclusion 1 lecture • 1min Conslusion 00:46 Instructor Karen Tateosyan Process Optimization Manager 4.6 Instructor Rating 280 Reviews 1,942 Students 3 Courses My name is Karen and I am from Bulgaria. I work at one of the world’s leading online payment providers but it is the VBA programming in Excel which I would describe as my hobby. During my career I have developed many Excel tools for the companies I have worked for. I believe that Excel is one of the most used programs in the business world. Probably, we spend more time only on Facebook, Instagram and YouTube these days. My mission is to share practical knowledge in Excel VBA which goes beyond knowing how to write a few lines of VBA code. Show more Show less Udemy Business Teach on Udemy Get the app About us Contact us Careers Blog Help and Support Affiliate Impressum Kontakt Terms Privacy policy Cookie settings Sitemap © 2021 Udemy, Inc. window.handleCSSToggleButtonClick = function (event) { var target = event.currentTarget; var cssToggleId = target && target.dataset && target.dataset.cssToggleId; var input = cssToggleId && document.getElementById(cssToggleId); if (input) { if (input.dataset.type === 'checkbox') { input.dataset.checked = input.dataset.checked ? '' : 'checked'; } else { input.dataset.checked = input.dataset.allowToggle && input.dataset.checked ? '' : 'checked'; var radios = document.querySelectorAll('[name="' + input.dataset.name + '"]'); for (var i = 0; i (function(){window['__CF$cv$params']={r:'678191739bae06e1',m:'cb01e41290f69946bf87f6ab2b701e230fa82c99-1627847142-1800-AcR35kWdZ6+3RONv06BnR0hf3D6dXoC1Qdi3oG91g1mtSPb8q/1yzE2lEVZNH5mtzM85eg3ebkQDk9z/e8FYbHlDLlYCPQrVLdwOy7n3JKPoARNJoQUxFxKOiu+PvCV43YRl+dWfcT6ydEy/laLXATMVRXrO4GJaFn7LmYkWkrnm72x2zTgR6Utn6w0WqW/wrg==',s:[0xd1c5e2d060,0x8350401cae],}})();
  3. Minimize the risk of seeing the unpleasant "Not Responding" status in Excel Boost your Excel skill by learning VBA coding and macros Learn how to use shapes in your Excel projects to create better user experience Requirements Basic Excel skills (programming knowledge NOT required). MS Excel installed on your device, preferably a version after Excel 2013 including. Description What am I going to learn from this course? This course is all about using Excel VBA to design and implement progress bars and charts within your Excel projects in order to create better user experience for the users of your Excel tools. What do I need in order to enroll in this course? You need to have Microsoft Excel installed on your device, preferably a version after Excel 2013 including. I am using Excel on Mac. Will this make any difference? There are certain differences between Excel for Windows and Excel for Mac, so some of the codes may not work properly on Mac. Do I need to have advanced level of Excel? It will probably help, but it’s not necessary. If you know what cells, rows, columns, worksheets are, etc., then you can enroll in this course. Who this course is for: Excel users who would like to make their projects more interesting and to create better user experience Show more Show less Course content 6 sections • 97 lectures • 6h 53m total length Expand all sections Designing a Progress Bar (no VBA) 12 lectures • 28min Introduction Preview 01:04 Adding Shapes 01:33 Fill, Outline and Glow 02:41 Width and Height 02:21 Grouping Shapes 02:42 Rectangle With Rounded Corners 03:06 Arranging Shapes 02:46 Adding Text to Shapes 03:45 Making Shapes Transparent 00:59 Adding a BackGround Shape 03:43 Locking Size and Position 02:21 Conclusion 01:02 Introduction to VBA 14 lectures • 50min Introduction Preview 00:58 Enabling the Developer Tab Preview 03:19 Referencing Cells Preview 02:11 Debugging 04:05 The Advantage of Using the Range Object 03:59 Referencing Multiple Cells 04:28 Referencing Cells in Other Worksheets 05:26 Referencing Cells in Other Workbooks 04:15 No "CTRL+Z" after Macros 02:25 Declaring Object Variables 04:23 Finding the Last Row (1) 03:40 Finding the Last Row (2) 04:22 VBA Data Type Summary 05:58 Conclusion 00:54 Designing A Progress Bar with VBA 30 lectures • 1hr 59min Introduction Preview 03:17 Inserting a Shape Preview 04:19 Getting Shapes' Position 04:26 Looping Through Shapes 02:18 Calling / Running Subroutines 02:22 Naming Shapes 04:36 Recording Macros 04:56 Changing Fill and Outline Colors of Shapes 05:01 Bevel Effect 04:56 Making Shapes Transparent 07:23 Adding Text to Shapes 06:25 Changing Font 04:05 ZOrder Method 04:12 Glow Effect 04:15 Grouping Shapes 03:11 Shapes' Placement Property 02:11 Orders Worksheet Introduction 03:54 Finding The Last Row - Recap 04:16 For Next Loops 03:12 Locals Window 03:34 Referencing Multiple Cells Inside the Loop 04:37 If Then Statement 04:40 Not Operator 07:25 Working with a Smaller Set of Data 02:47 It's Simple Mathematics 04:11 Width Property 02:19 timeFrame Macro 03:15 Format Function 04:53 Testing the Codes 01:45 Conclusion 00:27 Using Progress Bars within Multiple Loops 27 lectures • 2hr 34min Introduction Preview 04:41 Adding a Worksheet 04:10 Looping Through Worksheets 05:05 Looping Through Rows 12:45 Debugging 04:19 Vlookup Function 04:12 Vlookup Function in VBA 08:59 Scope of Variables 05:15 CountIfs Function 03:43 CountIfs Function in VBA 05:58 SumIfs Function 03:45 SumIfs Function in VBA 03:05 NumberFormat Property 01:51 Setting Borders 04:16 Removing Duplicates 08:31 Deleting Multiple Columns 04:59 Adding More Worksheets 06:14 Copying Rows 10:13 Designing New Progress Bar 05:19 Finding New Positions 03:53 Adding Progress Status Shape 04:40 Recording Macros 04:27 Copying the Codes 04:32 Testing the First Loop 10:52 Testing the Program 07:28 Tidying Up 09:57 Conclusion 00:46 Charts in VBA 13 lectures • 1hr 2min Introduction Preview 03:43 Adding Charts 02:40 Recording Macros 03:35 Adding Charts with VBA 08:04 Referencing Charts by Name 08:20 Looping to Add Charts 02:30 Chart Title 05:02 Full Series Collection 03:42 Chart Area 03:49 Communicating with Excel Users 04:53 Testing the Program 04:54 Fixing Little Bug 03:17 Optimizing the Position of the Progress Bar 07:10 Conclusion 1 lecture • 1min Conslusion 00:46 Instructor Karen Tateosyan Process Optimization Manager 4.6 Instructor Rating 280 Reviews 1,942 Students 3 Courses My name is Karen and I am from Bulgaria. I work at one of the world’s leading online payment providers but it is the VBA programming in Excel which I would describe as my hobby. During my career I have developed many Excel tools for the companies I have worked for. I believe that Excel is one of the most used programs in the business world. Probably, we spend more time only on Facebook, Instagram and YouTube these days. My mission is to share practical knowledge in Excel VBA which goes beyond knowing how to write a few lines of VBA code. Show more Show less Udemy Business Teach on Udemy Get the app About us Contact us Careers Blog Help and Support Affiliate Impressum Kontakt Terms Privacy policy Cookie settings Sitemap © 2021 Udemy, Inc. window.handleCSSToggleButtonClick = function (event) { var target = event.currentTarget; var cssToggleId = target && target.dataset && target.dataset.cssToggleId; var input = cssToggleId && document.getElementById(cssToggleId); if (input) { if (input.dataset.type === 'checkbox') { input.dataset.checked = input.dataset.checked ? '' : 'checked'; } else { input.dataset.checked = input.dataset.allowToggle && input.dataset.checked ? '' : 'checked'; var radios = document.querySelectorAll('[name="' + input.dataset.name + '"]'); for (var i = 0; i (function(){window['__CF$cv$params']={r:'678191739bae06e1',m:'cb01e41290f69946bf87f6ab2b701e230fa82c99-1627847142-1800-AcR35kWdZ6+3RONv06BnR0hf3D6dXoC1Qdi3oG91g1mtSPb8q/1yzE2lEVZNH5mtzM85eg3ebkQDk9z/e8FYbHlDLlYCPQrVLdwOy7n3JKPoARNJoQUxFxKOiu+PvCV43YRl+dWfcT6ydEy/laLXATMVRXrO4GJaFn7LmYkWkrnm72x2zTgR6Utn6w0WqW/wrg==',s:[0xd1c5e2d060,0x8350401cae],}})();
  4. Boost your Excel skill by learning VBA coding and macros Learn how to use shapes in your Excel projects to create better user experience Requirements Basic Excel skills (programming knowledge NOT required). MS Excel installed on your device, preferably a version after Excel 2013 including. Description What am I going to learn from this course? This course is all about using Excel VBA to design and implement progress bars and charts within your Excel projects in order to create better user experience for the users of your Excel tools. What do I need in order to enroll in this course? You need to have Microsoft Excel installed on your device, preferably a version after Excel 2013 including. I am using Excel on Mac. Will this make any difference? There are certain differences between Excel for Windows and Excel for Mac, so some of the codes may not work properly on Mac. Do I need to have advanced level of Excel? It will probably help, but it’s not necessary. If you know what cells, rows, columns, worksheets are, etc., then you can enroll in this course. Who this course is for: Excel users who would like to make their projects more interesting and to create better user experience Show more Show less Course content 6 sections • 97 lectures • 6h 53m total length Expand all sections Designing a Progress Bar (no VBA) 12 lectures • 28min Introduction Preview 01:04 Adding Shapes 01:33 Fill, Outline and Glow 02:41 Width and Height 02:21 Grouping Shapes 02:42 Rectangle With Rounded Corners 03:06 Arranging Shapes 02:46 Adding Text to Shapes 03:45 Making Shapes Transparent 00:59 Adding a BackGround Shape 03:43 Locking Size and Position 02:21 Conclusion 01:02 Introduction to VBA 14 lectures • 50min Introduction Preview 00:58 Enabling the Developer Tab Preview 03:19 Referencing Cells Preview 02:11 Debugging 04:05 The Advantage of Using the Range Object 03:59 Referencing Multiple Cells 04:28 Referencing Cells in Other Worksheets 05:26 Referencing Cells in Other Workbooks 04:15 No "CTRL+Z" after Macros 02:25 Declaring Object Variables 04:23 Finding the Last Row (1) 03:40 Finding the Last Row (2) 04:22 VBA Data Type Summary 05:58 Conclusion 00:54 Designing A Progress Bar with VBA 30 lectures • 1hr 59min Introduction Preview 03:17 Inserting a Shape Preview 04:19 Getting Shapes' Position 04:26 Looping Through Shapes 02:18 Calling / Running Subroutines 02:22 Naming Shapes 04:36 Recording Macros 04:56 Changing Fill and Outline Colors of Shapes 05:01 Bevel Effect 04:56 Making Shapes Transparent 07:23 Adding Text to Shapes 06:25 Changing Font 04:05 ZOrder Method 04:12 Glow Effect 04:15 Grouping Shapes 03:11 Shapes' Placement Property 02:11 Orders Worksheet Introduction 03:54 Finding The Last Row - Recap 04:16 For Next Loops 03:12 Locals Window 03:34 Referencing Multiple Cells Inside the Loop 04:37 If Then Statement 04:40 Not Operator 07:25 Working with a Smaller Set of Data 02:47 It's Simple Mathematics 04:11 Width Property 02:19 timeFrame Macro 03:15 Format Function 04:53 Testing the Codes 01:45 Conclusion 00:27 Using Progress Bars within Multiple Loops 27 lectures • 2hr 34min Introduction Preview 04:41 Adding a Worksheet 04:10 Looping Through Worksheets 05:05 Looping Through Rows 12:45 Debugging 04:19 Vlookup Function 04:12 Vlookup Function in VBA 08:59 Scope of Variables 05:15 CountIfs Function 03:43 CountIfs Function in VBA 05:58 SumIfs Function 03:45 SumIfs Function in VBA 03:05 NumberFormat Property 01:51 Setting Borders 04:16 Removing Duplicates 08:31 Deleting Multiple Columns 04:59 Adding More Worksheets 06:14 Copying Rows 10:13 Designing New Progress Bar 05:19 Finding New Positions 03:53 Adding Progress Status Shape 04:40 Recording Macros 04:27 Copying the Codes 04:32 Testing the First Loop 10:52 Testing the Program 07:28 Tidying Up 09:57 Conclusion 00:46 Charts in VBA 13 lectures • 1hr 2min Introduction Preview 03:43 Adding Charts 02:40 Recording Macros 03:35 Adding Charts with VBA 08:04 Referencing Charts by Name 08:20 Looping to Add Charts 02:30 Chart Title 05:02 Full Series Collection 03:42 Chart Area 03:49 Communicating with Excel Users 04:53 Testing the Program 04:54 Fixing Little Bug 03:17 Optimizing the Position of the Progress Bar 07:10 Conclusion 1 lecture • 1min Conslusion 00:46 Instructor Karen Tateosyan Process Optimization Manager 4.6 Instructor Rating 280 Reviews 1,942 Students 3 Courses My name is Karen and I am from Bulgaria. I work at one of the world’s leading online payment providers but it is the VBA programming in Excel which I would describe as my hobby. During my career I have developed many Excel tools for the companies I have worked for. I believe that Excel is one of the most used programs in the business world. Probably, we spend more time only on Facebook, Instagram and YouTube these days. My mission is to share practical knowledge in Excel VBA which goes beyond knowing how to write a few lines of VBA code. Show more Show less Udemy Business Teach on Udemy Get the app About us Contact us Careers Blog Help and Support Affiliate Impressum Kontakt Terms Privacy policy Cookie settings Sitemap © 2021 Udemy, Inc. window.handleCSSToggleButtonClick = function (event) { var target = event.currentTarget; var cssToggleId = target && target.dataset && target.dataset.cssToggleId; var input = cssToggleId && document.getElementById(cssToggleId); if (input) { if (input.dataset.type === 'checkbox') { input.dataset.checked = input.dataset.checked ? '' : 'checked'; } else { input.dataset.checked = input.dataset.allowToggle && input.dataset.checked ? '' : 'checked'; var radios = document.querySelectorAll('[name="' + input.dataset.name + '"]'); for (var i = 0; i (function(){window['__CF$cv$params']={r:'678191739bae06e1',m:'cb01e41290f69946bf87f6ab2b701e230fa82c99-1627847142-1800-AcR35kWdZ6+3RONv06BnR0hf3D6dXoC1Qdi3oG91g1mtSPb8q/1yzE2lEVZNH5mtzM85eg3ebkQDk9z/e8FYbHlDLlYCPQrVLdwOy7n3JKPoARNJoQUxFxKOiu+PvCV43YRl+dWfcT6ydEy/laLXATMVRXrO4GJaFn7LmYkWkrnm72x2zTgR6Utn6w0WqW/wrg==',s:[0xd1c5e2d060,0x8350401cae],}})();
  5. Learn how to use shapes in your Excel projects to create better user experience Requirements Basic Excel skills (programming knowledge NOT required). MS Excel installed on your device, preferably a version after Excel 2013 including. Description What am I going to learn from this course? This course is all about using Excel VBA to design and implement progress bars and charts within your Excel projects in order to create better user experience for the users of your Excel tools. What do I need in order to enroll in this course? You need to have Microsoft Excel installed on your device, preferably a version after Excel 2013 including. I am using Excel on Mac. Will this make any difference? There are certain differences between Excel for Windows and Excel for Mac, so some of the codes may not work properly on Mac. Do I need to have advanced level of Excel? It will probably help, but it’s not necessary. If you know what cells, rows, columns, worksheets are, etc., then you can enroll in this course. Who this course is for: Excel users who would like to make their projects more interesting and to create better user experience Show more Show less Course content 6 sections • 97 lectures • 6h 53m total length Expand all sections Designing a Progress Bar (no VBA) 12 lectures • 28min Introduction Preview 01:04 Adding Shapes 01:33 Fill, Outline and Glow 02:41 Width and Height 02:21 Grouping Shapes 02:42 Rectangle With Rounded Corners 03:06 Arranging Shapes 02:46 Adding Text to Shapes 03:45 Making Shapes Transparent 00:59 Adding a BackGround Shape 03:43 Locking Size and Position 02:21 Conclusion 01:02 Introduction to VBA 14 lectures • 50min Introduction Preview 00:58 Enabling the Developer Tab Preview 03:19 Referencing Cells Preview 02:11 Debugging 04:05 The Advantage of Using the Range Object 03:59 Referencing Multiple Cells 04:28 Referencing Cells in Other Worksheets 05:26 Referencing Cells in Other Workbooks 04:15 No "CTRL+Z" after Macros 02:25 Declaring Object Variables 04:23 Finding the Last Row (1) 03:40 Finding the Last Row (2) 04:22 VBA Data Type Summary 05:58 Conclusion 00:54 Designing A Progress Bar with VBA 30 lectures • 1hr 59min Introduction Preview 03:17 Inserting a Shape Preview 04:19 Getting Shapes' Position 04:26 Looping Through Shapes 02:18 Calling / Running Subroutines 02:22 Naming Shapes 04:36 Recording Macros 04:56 Changing Fill and Outline Colors of Shapes 05:01 Bevel Effect 04:56 Making Shapes Transparent 07:23 Adding Text to Shapes 06:25 Changing Font 04:05 ZOrder Method 04:12 Glow Effect 04:15 Grouping Shapes 03:11 Shapes' Placement Property 02:11 Orders Worksheet Introduction 03:54 Finding The Last Row - Recap 04:16 For Next Loops 03:12 Locals Window 03:34 Referencing Multiple Cells Inside the Loop 04:37 If Then Statement 04:40 Not Operator 07:25 Working with a Smaller Set of Data 02:47 It's Simple Mathematics 04:11 Width Property 02:19 timeFrame Macro 03:15 Format Function 04:53 Testing the Codes 01:45 Conclusion 00:27 Using Progress Bars within Multiple Loops 27 lectures • 2hr 34min Introduction Preview 04:41 Adding a Worksheet 04:10 Looping Through Worksheets 05:05 Looping Through Rows 12:45 Debugging 04:19 Vlookup Function 04:12 Vlookup Function in VBA 08:59 Scope of Variables 05:15 CountIfs Function 03:43 CountIfs Function in VBA 05:58 SumIfs Function 03:45 SumIfs Function in VBA 03:05 NumberFormat Property 01:51 Setting Borders 04:16 Removing Duplicates 08:31 Deleting Multiple Columns 04:59 Adding More Worksheets 06:14 Copying Rows 10:13 Designing New Progress Bar 05:19 Finding New Positions 03:53 Adding Progress Status Shape 04:40 Recording Macros 04:27 Copying the Codes 04:32 Testing the First Loop 10:52 Testing the Program 07:28 Tidying Up 09:57 Conclusion 00:46 Charts in VBA 13 lectures • 1hr 2min Introduction Preview 03:43 Adding Charts 02:40 Recording Macros 03:35 Adding Charts with VBA 08:04 Referencing Charts by Name 08:20 Looping to Add Charts 02:30 Chart Title 05:02 Full Series Collection 03:42 Chart Area 03:49 Communicating with Excel Users 04:53 Testing the Program 04:54 Fixing Little Bug 03:17 Optimizing the Position of the Progress Bar 07:10 Conclusion 1 lecture • 1min Conslusion 00:46 Instructor Karen Tateosyan Process Optimization Manager 4.6 Instructor Rating 280 Reviews 1,942 Students 3 Courses My name is Karen and I am from Bulgaria. I work at one of the world’s leading online payment providers but it is the VBA programming in Excel which I would describe as my hobby. During my career I have developed many Excel tools for the companies I have worked for. I believe that Excel is one of the most used programs in the business world. Probably, we spend more time only on Facebook, Instagram and YouTube these days. My mission is to share practical knowledge in Excel VBA which goes beyond knowing how to write a few lines of VBA code. Show more Show less Udemy Business Teach on Udemy Get the app About us Contact us Careers Blog Help and Support Affiliate Impressum Kontakt Terms Privacy policy Cookie settings Sitemap © 2021 Udemy, Inc. window.handleCSSToggleButtonClick = function (event) { var target = event.currentTarget; var cssToggleId = target && target.dataset && target.dataset.cssToggleId; var input = cssToggleId && document.getElementById(cssToggleId); if (input) { if (input.dataset.type === 'checkbox') { input.dataset.checked = input.dataset.checked ? '' : 'checked'; } else { input.dataset.checked = input.dataset.allowToggle && input.dataset.checked ? '' : 'checked'; var radios = document.querySelectorAll('[name="' + input.dataset.name + '"]'); for (var i = 0; i (function(){window['__CF$cv$params']={r:'678191739bae06e1',m:'cb01e41290f69946bf87f6ab2b701e230fa82c99-1627847142-1800-AcR35kWdZ6+3RONv06BnR0hf3D6dXoC1Qdi3oG91g1mtSPb8q/1yzE2lEVZNH5mtzM85eg3ebkQDk9z/e8FYbHlDLlYCPQrVLdwOy7n3JKPoARNJoQUxFxKOiu+PvCV43YRl+dWfcT6ydEy/laLXATMVRXrO4GJaFn7LmYkWkrnm72x2zTgR6Utn6w0WqW/wrg==',s:[0xd1c5e2d060,0x8350401cae],}})();