Overview

LearnLearn the basics of AI (genetic algorithm)Learn practical Excel function techniquesLearn practical VBA techniquesLearn shift optimization theoryLearn techniques to improve daily Excel workSeminar RequirementsIt works with Excel 2016 or later version for Windows.Important notice: Please prepare a version that can use the Spill function.The original is in Japanese, and the English version was created utilizing a machine translation.There might be some mistranslations.Since this is for advanced users, basic explanations are omitted.Course Content Features of this course You will learn while enjoying the process of building little by little just like assembling a plastic model. Usually get an expensive shift optimization app. The source code, which is not available on the market, is also included, so it is worth several hundred thousand yen in real value. Furthermore, you can freely customize it to your needs because it even comes with an explanation of the source code.Will also learn the actual development process and VBA tips.Will be able to apply it to various uses and develop useful applications.For example, it can be used to calculate the shortest or cheapest itinerary, or to plan products that make effective use of materials.Key FeaturesThis is a very economical course that gives you the programming skills to make money and the apps to make money.Curriculum Introduction1. Seminar Introduction2. Overview of Genetic Algorithms3. Programming Guidelines4. Design5. Creation of shift table base6. Generation of first shift7. Generational evolution, evaluation, and performance analysis

Skills

Reviews