Withdrawal method: Baidu.com
Total [33] sections
Availability of courseware: Yes

You will gain

Finance, data analysts, people who want to automate their office work.

population (esp. of a group of people)

everyone
Courses

Workbook: talked about the expression of the workbook, as well as batch manipulation of workbook data. For example, merging multiple workbook data.
Worksheets: talks about workbook expressions, and batch manipulating worksheet data.
Cells: Cells are objects with a high frequency of operation, the expression of cells, through methods or properties to obtain and so on.
Arrays: In order to improve the speed of VBA arithmetic, a special explanation of arrays. And his related applications
Graphics: This is the exciting part. It talks about the various ways of inserting graphics in bulk. Automatic drawing of graphics by coordinates. Batch production of employee cards and other examples. Many examples can be used at work.


Course Catalog

2.0 VBA Advanced Tutorial Sneak Peek (see if it's the tutorial you want) 18:20
2.1 N ways to express a workbook 09:31
2.2 Workbook routines 32:18
2.3 Examples of workbook applications 12:13
2.4 Function Basics and Applications for Traversing Folder Files 12:29
2.5 N expressions and common operations of worksheets 23:16
2.6 Combined Worksheet and Workbook Applications (Splitting Worksheets to Workbooks) 12:40
2.7 Cell-area expressions (example: combining data from multiple worksheets) 40:53
2.8 Getting cell regions by attributes 22:01
2.9 Integrated Application (Conditional Filtering of Multiple Worksheets) 21:44
2.10 Getting cell regions by method 29:44
2.11 Cell merging and splitting 19:17
2.12 Array technology in VBA 28:05
2.13 Example of reading and writing to an array 18:33
2.14 Example Application of Arrays (Multi-Criteria Filtering) 21:09
2.15 Array magic (one-dimensional nesting becomes two-dimensional) 21:03
2.16 Dynamic arrays 20:13
2.17 JOIN 25:12 common functions in arrays
2.18 SPLIT of common functions in arrays 11:39
2.19 Common Functions in Arrays FILTER 17:54
2.20 Graphics Basics in VBA 17:22
2.21 Text box example (batch generation of passes) 34:27
2.22 SmartArt Basics for VBA Graphics 20:05
2.23 Exploring the structure of SmartArt objects 26:13
2.24 SmartArt example (batch importing images into SmartArt graphics) 37:14
2.25 Pictures in VBA (Batch Importing Pictures) 21:37
2.26 Application of Annotations in VBA (Dynamically Getting the Name and Subject of the Highest Score) 28:33
2.27 Example Application of Annotations (Adding Picture Annotations According to Names in Batch) 16:56
2.28 Integrated Application (Batch Generation of Employee Cards) 38:21
2.29 Several ways to represent graphical objects 19:46
2.30 Integrated Applications (Graph Formation from Coordinates) 51:05
2.31 Comprehensive Applications (Making Graphs That Are Better Than Mini-Graphs) 38:59
2.32 Integrated Applications (Generating Graphs from Coordinates 2) 18:50

Resource Download

The download price for this resource is18.9Gold coins, please firstlog in

Resource Disclaimer (Purchase is deemed to be agreement with this statement):
1. Any operation on the website platform is considered to have read and agreed to the registration agreement and disclaimer at the bottom of the website, this site resources have been ultra-low price, and does not provide technical support
2. Some network users share the net disk address may be invalid, such as the occurrence of failure, please send an e-mail to customer service code711cn#qq.com (# replaced by @) will be made up to send
3. This site provides all downloadable resources (software, etc.) site to ensure that no negative changes; but this site can not guarantee the accuracy, security and integrity of the resources, the user downloads at their own discretion, we communicate to learn for the purpose of not all the source code is not 100% error-free or no bugs; you need to have a certain foundation to be able to read and understand the code, be able to modify the debugging yourself! code and solve the error. At the same time, users of this site must understand that the Source Code Convenience Store does not own any rights to the software provided for download, the copyright belongs to the legal owner of the resource.
4. All resources on this site only for learning and research purposes, please must be deleted within 24 hours of the downloaded resources, do not use for commercial purposes, otherwise the legal disputes arising from the site and the publisher of the collateral liability site and will not be borne!
5. Due to the reproducible nature of the resources, once purchased are non-refundable, the recharge balance is also non-refundable