Duration 3 Days 18 CPD hours This course is intended for This course is primarily designed for students who want to gain the skills necessary to use VBA to automate tasks in Excel such as collecting data from external sources, cleaning, and manipulating data. The target student may also want to learn how to create custom worksheet functions to streamline worksheet formulas and make complex worksheets easier to support, maintain, and understand. Overview In this course, you will develop and deploy VBA modules to solve business problems. You will: Identify general components of VBA and their appropriate use in solving business solutions. Record VBA macros to automate repetitive tasks. Use reference tools built into Excel to get help on VBA programming language and objects used in the Excel VBA environment. Write VBA code to create a custom worksheet function. Eliminate, avoid, or handle errors in VBA code, and optimize its performance. Control how and when macros run. Develop UserForm objects to create custom dialog boxes and windows. Use VBA to read and write data from local files and cloud services. Use VBA to clean and transform data. Run programs and commands outside of Excel and share VBA projects with other users VBA (Visual Basic for Applications) enables you to enhance and extend the capabilities of Microsoft© Excel© and other applications in the Microsoft© Office application suite. You can use VBA to perform tasks that would be difficult or impossible to do using only worksheet functions, and you can automate a wide range of tasks involving the collection, processing, analysis, and visualization of data. This course will give you a good foundation for understanding, creating, and using VBA in your own Excel workbooks, show you how to work with data across different applications, and how to package the macros and functions you create so you can back them up, move them to other computers, and share them with other users Prerequisites To ensure your success in this course, you should be an experienced Excel user who is comfortable creating and working with Excel workbooks, including tasks such as entering worksheet formulas, using absolute and relative addressing, formatting cells, and creating pivot tables and charts. This level of skill could be acquired by taking the Microsoft Excel for Office 365? (Desktop or Online) courses, Parts 1, 2, and 3 1 - Using VBA to Solve Business Problems Topic A: Use Macros to Automate Tasks in Excel Topic B: Identify Components of Macro-Enabled Workbooks Topic C: Configure the Excel VBA Environment 2 - Automating Repetitive Tasks Topic A: Use the Macro Recorder to Create a VBA Macro Topic B: Record a Macro with Relative Addressing Topic C: Delete Macros and Modules Topic D: Identify Strategies for Using the Macro Recorder 3 - Getting Help on VBA Topic A: Use VBA Help Topic B: Use the Object Browser to Discover Objects You Can Use in VBA Topic C: Use the Immediate Window to Explore Object Properties and Methods 4 - Creating Custom Worksheet Functions Topic A: Create a Custom Function Topic B: Make Decisions in Code Topic C: Work with Variables Topic D: Perform Repetitive Tasks 5 - Improving Your VBA Code Topic A: Debug VBA Errors Topic B: Deal with Errors Topic C: Improve Macro Performance 6 - Controlling How and When Macros Run Topic A: Prompt the User for Information Topic B: Configure Macros to Run Automatically 7 - Developing Custom Forms Topic A: Display a Custom Dialog Box Topic B: Program Form Events 8 - Using VBA to Work with Files Topic A: Use VBA to Get File and Directory Structure Topic B: Use VBA to Read Text Files Topic C: Use VBA to Write Text Files 9 - Using VBA to Clean and Transform Data Topic A: Automate Power Query Topic B: Transform Data Using VBA and Workbook Functions Topic C: Use Regular Expressions Topic D: Manage Errors in Data 10 - Extending the Programming Environment Beyond the Workbook Topic A: Run Other Programs and Commands Topic B: Share Your VBA Projects
Overview This comprehensive course on C# Programming - Beginner to Advanced will deepen your understanding on this topic. After successful completion of this course you can acquire the required skills in this sector. This C# Programming - Beginner to Advanced comes with accredited certification from CPD, which will enhance your CV and make you worthy in the job market. So enrol in this course today to fast track your career ladder. How will I get my certificate? You may have to take a quiz or a written test online during or after the course. After successfully completing the course, you will be eligible for the certificate. Who is This course for? There is no experience or previous qualifications required for enrolment on this C# Programming - Beginner to Advanced. It is available to all students, of all academic backgrounds. Requirements Our C# Programming - Beginner to Advanced is fully compatible with PC's, Mac's, Laptop, Tablet and Smartphone devices. This course has been designed to be fully compatible with tablets and smartphones so you can access your course on Wi-Fi, 3G or 4G. There is no time limit for completing this course, it can be studied in your own time at your own pace. Career Path Learning this new skill will help you to advance in your career. It will diversify your job options and help you develop new techniques to keep up with the fast-changing world. This skillset will help you to- Open doors of opportunities Increase your adaptability Keep you relevant Boost confidence And much more! Course Curriculum 13 sections • 41 lectures • 04:58:00 total length •Introduction: 00:04:00 •Intro: 00:02:00 •Visual Studio: 00:07:00 •Comments: 00:02:00 •Variables: 00:08:00 •Print and read console: 00:04:00 •Math: 00:08:00 •Intro: 00:02:00 •Boolean: 00:07:00 •IF: 00:08:00 •IF ELSE, ELSE: 00:08:00 •Switch: 00:05:00 •WHILE loop: 00:07:00 •FOR loop: 00:03:00 •Basics of a method: 00:07:00 •Parameters: 00:05:00 •Returns: 00:08:00 •Basics of a class: 00:07:00 •Access: 00:06:00 •Static: 00:07:00 •Read line: 00:03:00 •Arrays: 00:06:00 •FOR EACH loop: 00:05:00 •Convert: 00:04:00 •Cast: 00:04:00 •Date: 00:12:00 •Split, remove, substring: 00:14:00 •More on construction: 00:11:00 •More on access: 00:04:00 •Inheritance: 00:09:00 •EXAMPLE - time converter: 00:17:00 •Read a text file: 00:13:00 •Write a text file: 00:10:00 •Serialize object to byte array: 00:15:00 •Task: 00:07:00 •Async and await: 00:15:00 •Multitasking: 00:07:00 •Where: 00:11:00 •Find: 00:05:00 •Order, group and merge: 00:10:00 •Bonus lecture: 00:01:00
Implement OTA programming, FreeRTOS and deep sleep in the ESP32
Overview Uplift Your Career & Skill Up to Your Dream Job - Learning Simplified From Home! Kickstart your career & boost your employability by helping you discover your skills, talents and interests with our special Tic-Tac-Toe Clone - Perfect Cocos2d-x C++ Game Course. You'll create a pathway to your ideal job as this course is designed to uplift your career in the relevant industry. It provides professional training that employers are looking for in today's workplaces. The Tic-Tac-Toe Clone - Perfect Cocos2d-x C++ Game Course is one of the most prestigious training offered at StudyHub and is highly valued by employers for good reason. This Tic-Tac-Toe Clone - Perfect Cocos2d-x C++ Game Course Course has been designed by industry experts to provide our learners with the best learning experience possible to increase their understanding of their chosen field. This Tic-Tac-Toe Clone - Perfect Cocos2d-x C++ Game Course, like every one of Study Hub's courses, is meticulously developed and well researched. Every one of the topics is divided into elementary modules, allowing our students to grasp each lesson quickly. At StudyHub, we don't just offer courses; we also provide a valuable teaching process. When you buy a course from StudyHub, you get unlimited Lifetime access with 24/7 dedicated tutor support. Why buy this Tic-Tac-Toe Clone - Perfect Cocos2d-x C++ Game Course? Unlimited access to the course for forever Digital Certificate, Transcript, student ID all included in the price Absolutely no hidden fees Directly receive CPD accredited qualifications after course completion Receive one to one assistance on every weekday from professionals Immediately receive the PDF certificate after passing Receive the original copies of your certificate and transcript on the next working day Easily learn the skills and knowledge from the comfort of your home Certification After studying the course materials of the Tic-Tac-Toe Clone - Perfect Cocos2d-x C++ Game Course there will be a written assignment test which you can take either during or at the end of the course. After successfully passing the test you will be able to claim the pdf certificate for £5.99. Original Hard Copy certificates need to be ordered at an additional cost of £9.60. Who is this course for? This Tic-Tac-Toe Clone - Perfect Cocos2d-x C++ Game Course is ideal for Students Recent graduates Job Seekers Anyone interested in this topic People already working in the relevant fields and want to polish their knowledge and skill. Prerequisites This Tic-Tac-Toe Clone - Perfect Cocos2d-x C++ Game Course does not require you to have any prior qualifications or experience. You can just enrol and start learning.This Tic-Tac-Toe Clone - Perfect Cocos2d-x C++ Game Course was made by professionals and it is compatible with all PC's, Mac's, tablets and smartphones. You will be able to access the course from anywhere at any time as long as you have a good enough internet connection. Career path As this course comes with multiple courses included as bonus, you will be able to pursue multiple occupations. This Tic-Tac-Toe Clone - Perfect Cocos2d-x C++ Game Course is a great way for you to gain multiple skills from the comfort of your home. Course Curriculum Section 01: Introduction Introduction 00:02:00 Section 02: Setup Project Setup 00:15:00 Section 03: Scene Setup Scene Creation 00:07:00 Splash Scene 00:08:00 Main Menu Scene 00:33:00 Section 04: Grid & Gameplay Grid System 00:17:00 Grid System Part 2 00:26:00 AI 00:34:00 Section 05: Popups Game Over 00:28:00 Pause 00:23:00 Section 06: Extras Achievements 00:08:00 Extras & Going Forward 00:11:00 Assignment Assignment - Tic-Tac-Toe Clone - Perfect Cocos2d-x C++ Game Course 00:00:00
Get Any Course Only for £11.11 Limited Time Offer Browse Courses Register on the AutoCAD Programming Using C#.NET today and build the experience, skills and knowledge you need to enhance your professional development and work towards your dream job. Study this course through online learning and take the first steps towards a long-term career. The course consists of a number of easy to digest, in-depth modules, designed to provide you with a detailed, expert level of knowledge. Learn through a mixture of instructional video lessons and online study materials. Receive online tutor support as you study the course, to ensure you are supported every step of the way. Get a certificate as proof of your course completion. The AutoCAD Programming Using C#.NET course is incredibly great value and allows you to study at your own pace. Access the course modules from any internet-enabled device, including computers, tablets, and smartphones. The course is designed to increase your employability and equip you with everything you need to be a success. Enrol on the now and start learning instantly! What You Get With The AutoCAD Programming Using C#.NET course Receive a digital certificate upon successful completion of the course Get taught by experienced, professional instructors Study at a time and pace that suits your learning style Get instant feedback on assessments 24/7 help and advice via email or live chat Get full tutor support on weekdays (Monday to Friday) Course Design The course is delivered through our online learning platform, accessible through any internet-connected device. There are no formal deadlines or teaching schedules, meaning you are free to study the course at your own pace. You are taught through a combination of Video lessons Online study materials Certification After the successful completion of the final assessment, you will receive a CPD-accredited certificate of achievement. The PDF certificate is for £9.99, and it will be sent to you immediately after through e-mail. You can get the hard copy for £15.99, which will reach your doorsteps by post. Who Is This Course For: The course is ideal for those who already work in this sector or are aspiring professionals. This course is designed to enhance your expertise and boost your CV. Learn key skills and gain a professional qualification to prove your newly-acquired knowledge. Requirements: The online training is open to all students and has no formal entry requirements. To study the AutoCAD Programming Using C#.NET course, all you need is a passion for learning, A good understanding of English, numeracy, and IT skills. You must also be over the age of 16. Frequently Asked Questions Are there any prerequisites for taking the course? There are no specific prerequisites for this course, nor are there any formal entry requirements. All you need is an internet connection, a good understanding of English and a passion for learning for this course. Can I access the course at any time, or is there a set schedule? You have the flexibility to access the course at any time that suits your schedule. Our courses are self-paced, allowing you to study at your own pace and convenience. How long will I have access to the course? For this course, you will have access to the course materials for 1 year only. This means you can review the content as often as you like within the year, even after you've completed the course. However, if you buy Lifetime Access for the course, you will be able to access the course for a lifetime. Is there a certificate of completion provided after completing the course? Yes, upon successfully completing the course, you will receive a certificate of completion. This certificate can be a valuable addition to your professional portfolio and can be shared on your various social networks. Can I switch courses or get a refund if I'm not satisfied with the course? We want you to have a positive learning experience. If you're not satisfied with the course, you can request a course transfer or refund within 14 days of the initial purchase. How do I track my progress in the course? Our platform provides tracking tools and progress indicators for each course. You can monitor your progress, completed lessons, and assessments through your learner dashboard for the course. What if I have technical issues or difficulties with the course? If you encounter technical issues or content-related difficulties with the course, our support team is available to assist you. You can reach out to them for prompt resolution.
The shortage of electricians has lead to an increased demand nationwide and in turn a sharp rise in salary. Our training solutions can help you gain nationally recognised qualifications such as City & Guilds and NVQ. Not only you will train in state-of-the-art training centres, but you can also have the opportunity to attain the Work Based Performance Units and complete a portfolio of diverse evidence of onsite work.
Overview This comprehensive course on Flappy Bird Clone: SFML C++ Game will deepen your understanding on this topic. After successful completion of this course you can acquire the required skills in this sector. This Flappy Bird Clone: SFML C++ Game comes with accredited certification, which will enhance your CV and make you worthy in the job market. So enrol in this course today to fast track your career ladder. How will I get my certificate? You may have to take a quiz or a written test online during or after the course. After successfully completing the course, you will be eligible for the certificate. Who is This course for? There is no experience or previous qualifications required for enrolment on this Flappy Bird Clone: SFML C++ Game. It is available to all students, of all academic backgrounds. Requirements Our Flappy Bird Clone: SFML C++ Game is fully compatible with PC's, Mac's, Laptop, Tablet and Smartphone devices. This course has been designed to be fully compatible with tablets and smartphones so you can access your course on Wi-Fi, 3G or 4G. There is no time limit for completing this course, it can be studied in your own time at your own pace. Career Path Having these various qualifications will increase the value in your CV and open you up to multiple sectors such as Business & Management, Admin, Accountancy & Finance, Secretarial & PA, Teaching & Mentoring etc. Course Curriculum 8 sections • 34 lectures • 05:27:00 total length •Introduction: 00:02:00 •Setup Project - Windows (Visual Studio): 00:14:00 •Setup Project - Mac OS X (Xcode): 00:11:00 •State Machine: 00:18:00 •Asset Manager: 00:08:00 •Input Manager: 00:08:00 •Game Loop: 00:14:00 •Splash State: 00:17:00 •Main Menu State: 00:16:00 •Game State: 00:07:00 •Game Over State: 00:04:00 •Pipe Class Setup: 00:08:00 •Spawn Moving Pipes: 00:11:00 •Automatically Spawning Pipes and Deleting Them: 00:08:00 •Create Moving Ground: 00:14:00 •Randomise Pipe Y Position: 00:06:00 •Bird Class Setup: 00:10:00 •Animating the Bird: 00:08:00 •Fly Bird Fly: 00:11:00 •Rotate Bird: 00:06:00 •Collision with the Ground & Game State System: 00:15:00 •Collision with the Pipes: 00:09:00 •Flash Screen White upon Death: 00:12:00 •Scoring System: 00:15:00 •Displaying the Score: 00:18:00 •Setup: 00:16:00 •Display Score: 00:08:00 •Saving Score: 00:06:00 •Medals: 00:08:00 •Sound Effects: 00:08:00 •Hide Console on Windows: 00:01:00 •Distributing Your Game on Windows: 00:03:00 •Where to Go Next?: 00:07:00 •Resource: 00:00:00
Overview Uplift Your Career & Skill Up to Your Dream Job - Learning Simplified From Home! Kickstart your career & boost your employability by helping you discover your skills, talents and interests with our special Learn Game Development using Cocos2d-x v3 C++ Course. You'll create a pathway to your ideal job as this course is designed to uplift your career in the relevant industry. It provides professional training that employers are looking for in today's workplaces. The Learn Game Development using Cocos2d-x v3 C++ Course is one of the most prestigious training offered at StudyHub and is highly valued by employers for good reason. This Learn Game Development using Cocos2d-x v3 C++ Course has been designed by industry experts to provide our learners with the best learning experience possible to increase their understanding of their chosen field. This Learn Game Development using Cocos2d-x v3 C++ Course, like every one of Study Hub's courses, is meticulously developed and well researched. Every one of the topics is divided into elementary modules, allowing our students to grasp each lesson quickly. At StudyHub, we don't just offer courses; we also provide a valuable teaching process. When you buy a course from StudyHub, you get unlimited Lifetime access with 24/7 dedicated tutor support. Why buy this Learn Game Development using Cocos2d-x v3 C++? Unlimited access to the course for forever Digital Certificate, Transcript, student ID all included in the price Absolutely no hidden fees Directly receive CPD accredited qualifications after course completion Receive one to one assistance on every weekday from professionals Immediately receive the PDF certificate after passing Receive the original copies of your certificate and transcript on the next working day Easily learn the skills and knowledge from the comfort of your home Certification After studying the course materials of the Learn Game Development using Cocos2d-x v3 C++ there will be a written assignment test which you can take either during or at the end of the course. After successfully passing the test you will be able to claim the pdf certificate for £5.99. Original Hard Copy certificates need to be ordered at an additional cost of £9.60. Who is this course for? This Learn Game Development using Cocos2d-x v3 C++ course is ideal for Students Recent graduates Job Seekers Anyone interested in this topic People already working in the relevant fields and want to polish their knowledge and skill. Prerequisites This Learn Game Development using Cocos2d-x v3 C++ does not require you to have any prior qualifications or experience. You can just enrol and start learning.This Learn Game Development using Cocos2d-x v3 C++ was made by professionals and it is compatible with all PC's, Mac's, tablets and smartphones. You will be able to access the course from anywhere at any time as long as you have a good enough internet connection. Career path As this course comes with multiple courses included as bonus, you will be able to pursue multiple occupations. This Learn Game Development using Cocos2d-x v3 C++ is a great way for you to gain multiple skills from the comfort of your home. Course Curriculum Section 01: Introduction Course Introduction 00:03:00 Section 02: Setting Up Setting Up For iOS 00:05:00 Setting Up For Android on Mac 00:11:00 Setting Up For Android on Windows 00:13:00 Multi Resolution Support 00:16:00 Section 03: Adding a Sprite Adding a Sprite 00:04:00 Section 04: Positioning Positioning Using MoveBy 00:03:00 Positioning Using MoveTo 00:03:00 Positioning Using JumpBy 00:03:00 Positioning Using JumpTo 00:03:00 Positioning Using BezierBy 00:04:00 Positioning Using BezierTo 00:03:00 Positioning Using Place 00:02:00 Section 05: Scaling Scaling Using ScaleBy 00:03:00 Scaling Using ScaleTo 00:03:00 Section 06: Rotation Rotating Using RotateBy 00:03:00 Rotating Using RotateTo 00:03:00 Section 07: Tinting Tinting Using TintBy 00:03:00 Tinting Using TintTo 00:02:00 Section 08: Fading Fading Using FadeTo 00:02:00 Fading Using FadeIn 00:02:00 Fading Using FadeOut 00:02:00 Section 09: Sequencing Repeat 00:04:00 RepeatForever 00:03:00 Sequence 00:04:00 Section 10: Skewing Skewing Using SkewBy 00:02:00 Skewing Using SkewTo 00:02:00 Section 11: Audio Playing Sound Effect 00:06:00 Playing Sound Effect Repeatedly 00:04:00 Setting Sound Effect Volume 00:03:00 Stopping Sound Effect 00:05:00 Playing Music 00:04:00 Stopping Music 00:03:00 Pausing and Resuming Music 00:04:00 Setting Music Volume 00:03:00 Section 12: Touch Input Setting Up Single Touch Events 00:04:00 Touch Began Using onTouchBegan 00:05:00 Touch Moved Using onTouchMoved 00:03:00 Touch Ended Using onTouchEnded 00:03:00 Setting Up Multi Touch Events1 00:05:00 Touches Began Using onTouchesBegan 00:02:00 Touches Moved Using onTouchesMoved 00:03:00 Touches Ended Using onTouchesEnded 00:03:00 Section 13: Menus Setting up A Menu 00:03:00 Adding a Menu Font Item 00:07:00 Adding a Menu Image Item 00:05:00 Menu Alignment 00:02:00 Section 14: Scenes Creating a New Scene 00:04:00 Pushing a Scene 00:05:00 Popping a Scene 00:03:00 Replace a Scene 00:05:00 Scene Transitions 00:03:00 Section 15: Animations Sprite Animations 00:04:00 Section 16: Accelerometer Accelerometer 00:05:00 Section 17: Cocos Console Creating a New Project 00:02:00 Compiling a Project 00:07:00 Running a Project 00:07:00 Deploying a Project 00:06:00 Section 18: Resource Resource 00:00:00 Assignment Assignment - Learn Game Development using Cocos2d-x v3 C++ 00:00:00
C++ Programming Masterclass is yet another 'Teacher's Choice' course from Teachers Training for a complete understanding of the fundamental topics. You are also entitled to exclusive tutor support and a professional CPD-accredited certificate in addition to the special discounted price for a limited time. Just like all our courses, this C++ Programming Masterclass and its curriculum have also been designed by expert teachers so that teachers of tomorrow can learn from the best and equip themselves with all the necessary skills. Consisting of several modules, the course teaches you everything you need to succeed in this profession. The course can be studied part-time. You can become accredited within 04 hours studying at your own pace. Your qualification will be recognised and can be checked for validity on our dedicated website. Why Choose Teachers Training Some of our website features are: This is a dedicated website for teaching 24/7 tutor support Interactive Content Affordable price Courses accredited by the UK's top awarding bodies 100% online Flexible deadline Entry Requirements No formal entry requirements. You need to have: Passion for learning A good understanding of the English language Be motivated and hard-working Over the age of 16. Certification CPD Certification from The Teachers Training Successfully completing the MCQ exam of this course qualifies you for a CPD-accredited certificate from The Teachers Training. You will be eligible for both PDF copy and hard copy of the certificate to showcase your achievement however you wish. You can get your digital certificate (PDF) for £4.99 only Hard copy certificates are also available, and you can get one for only £10.99 You can get both PDF and Hard copy certificates for just £12.99! The certificate will add significant weight to your CV and will give you a competitive advantage when applying for jobs. Module 01 Classes and Structs 00:22:00 Enums 00:14:00 Unions 00:16:00 Introduction to Pointers 00:11:00 Pointers and Array Indexing 00:12:00 Module 02 Using Const with Pointers 00:09:00 Pointers to String Literals 00:12:00 References 00:14:00 Smart Pointers 00:22:00 Arrays 00:15:00 Module 03 Standard Library Strings 00:14:00 More Standard Library Strings 00:18:00 Functions 00:18:00 More Functions 00:16:00 Function Pointers 00:15:00 Control Statements 00:18:00