1188 Courses delivered Online

If you have a lots of going on in your life and feel a bit lost, craving for some relaxing time and creativity, join me online for an hour of journaling, mindful breathing, drawing and lettering

Course Objectives At the end of this course you will be able to: Record and edit a Macro Assign macros to keyboard shortcuts, Quick Access Toolbar, Buttons and Shape objects. Use the Visual Basic Editor; change the properties of an object; add a module to a project; write the code for a procedure and then run it; and use the Object Browser to search procedures Manipulate data by declaring variables of different data types; combine data by using expressions; use functions to accept input and display output; and declare variables and procedures with the appropriate scope Use decision structures to create procedures that make decisions; and use loop structures to perform repetitive tasks Create an error handling routine in case things go wrong with VBA code ' 1 year email support service Take a closer look at the consistent excellent feedback from our growing corporate clients visiting our site ms-officetraining co uk Customer Feedback Best Training Ever! Just finished a bespoke 1-1 training course in Excel Advanced, Macros & VBA. Pedro is an excellent trainer, imparting his skills and knowledge in the best way - appropriately to audience skills, knowledge and ability. Pedro is always approachable, encouraging and supportive, giving delegates the optimum learning environment. I would not hesitate to recommend Pedro as a trainer, whatever your level of ability. Amanda Morris - Treasury & Systems Accountant at Reall - Real Equity for All The trainer was very knowledgeable, kept everyone involved and was enthusiastic. A great experience.. Simon Harper - Lloyd's of London My learning experience was awesome. Perdinand Reagan - Subsea7 Very nice and relaxed approach to teaching. Was definitely a good learning experience. Jerome Pupe - S5 Agency World The Trainer – Very positive + patient + helpful + thorough Agnes Souza - Direct Wines ' With more than 20 years experience, we deliver courses on all levels of the Desktop version of Microsoft Office and Office 365; ranging from Beginner, Intermediate, Advanced to the VBA level. Our trainers are Microsoft certified professionals with a proven track record with several years experience in delivering public, one to one, tailored and bespoke courses. Our competitive rates start from £550.00 per day of training Tailored training courses: You can choose to run the course exactly as they are outlined by us or we can customise it so that it meets your specific needs. A tailored or bespoke course will follow the standard outline but may be adapted to your specific organisational needs. Introduction to Macros and VBA Introducing Visual Basic for Applications Recording a Macro Naming conventions for Macro Procedures Running a Macro Absolute or Relative Cell Referencing Saving and Opening Files with Macros Making macros always available Adding Macros to Keyboard Shortcuts, Quick Access Toolbar, Buttons and Shapes Editing a Macro in the Visual Basic Editor Understanding the Development Environment Customising the Editor Tips for General Typing in VBA Using Visual Basic Help Working with Procedures Program Design Understanding Modules Naming Rules Creating a Module Understanding Procedures Programming Macro Concepts Creating a Subroutine Creating a Function Understanding Arguments Exiting Procedures Calling Procedures Objects, Properties, Methods and Events Understanding Objects Properties, Methods, and Events Navigating the Object Hierarchy Understanding Collections Accessing a Member of a Collection Understanding Hierarchy Using the Object Browser Using the With Statement Working with Properties Working with Methods Creating an Event Procedure Reserved Macro Names Using Expressions, Variables and Intrinsic Functions Understanding Expressions and Statements Declaring Variables Understanding Data Types Determining the Value of Variables Working with Variable Scope Using Built-in VBA Functions Understanding Constants Using Message Boxes Controlling the Answer to a Message Box Using Input Boxes Declaring and Using Object Variables Controlling Program Execution Understanding Control-of-Flow Structures Using the If...End If Decision Structures Nested If Statements Using the Select Case ... End Select Structure Using the Do ... Loop Structure Using the For ... Next Structure Using the For Each ... Next Structure Guidelines for Use of Control-of-Flow Structures Debugging and Handling Errors Understanding Errors Using Debugging Tools Setting Breakpoints and Using Break Mode Stepping Through Code Trapping Errors with the On Error Statement Understanding the Err Object Working with Inline Error Handling Writing an Error-Handling Routine Working with Forms and Controls Understanding UserForms Creating a Form Displaying and Removing a Form Aligning and Sizing Controls Using the Toolbox Working with a Form's Properties, Methods, and Events Working with Form and Control Properties, Methods and Event Setting the Tab Order Populating a Control Who is this course for? Who is this course for? This course is designed to give proficiency in the Visual Basic Editor (VBE), predominantly making use of Excel objects, understanding Object's Properties, Events and Methods, basic VBA Object oriented programming, event handling, control structures, and debugging tools. Requirements Requirements Preferably, delegates should have attended the Excel Advanced course. Certificates Certificates Certificate of completion Digital certificate - Included

Certified Family Trauma Professional (CFTP) training is a premium quality program designed for treating kids and youth trauma.

How To Set Up Progressive Training Routines? All the training routine is between 8 - 15 minutes and designed to getting better and stronger in the basic movements! Weekly New Routines are coming! How do beginners Should use kettlebells? - SAFETY - QUALITY - REGULARITY - PROGRESSIVE SYSTEM - MAKE THE FOUNDATION STRONG Beginners should have to use kettlebells carefully always! Safety first every time and not only with kettlebell training! Focus on the quality of the movements! Without correct techniques there is no progress and easy to get injuries! Regular practice! To get adaptation need to practice at least 2 - 3 times a week! Need to follow a progressive system to get progress! Adaptation is happening with regular practice what makes the basic stronger and easier to step to the next level! Here you can find 5 FREE kettlebell training routine following by StrongFirst system! These routines will build stronger basic, builds strength fast and safe! FREE KETTLEBELL TRAINING ROUTINES TO BUILD STRONGER FOUNDATION! Welcome to the course! Welcome to this free training routines! How to use it? Next Steps... The foundation Builder Kettlebell Routine 1 Get Stronger Foundations For Kettlebell Training Kettlebell Strength Builder For Beginners Foundation Builder 2 / Dead lift - swing - squat Progression to Turkish Get Up Progress to Turkish Get Up 2 Strength Booster single Kettlebell routine Kettlebell Arms and chest builder routine! 5 Mistakes what you shouldn't do with kettlebells About this course Free 10 lessons 1.5 hours of video content

Unlock the secrets to timeless beauty with our comprehensive course on Anti-Ageing and Blemish Care: Skincare Strategies. From cleansing techniques to advanced serums, master the art of skincare to combat signs of ageing and achieve flawless, spot-free skin. Join us to discover expert tips and personalized routines tailored to your skin's unique needs. Start your journey to radiant, ageless skin today!

Feedback Mastery Unleashed: 28 day online mini-programme to ignite high performance leadership for high achieving teams

MySQL Performance & Tuning training course description This MySQL Performance & Tuning course is designed for Database Administrators, Application Developers and Technical Consultants who need to monitor and tune the performance of MySQL servers and databases. The course provides practical experience in monitoring and tuning MySQL servers and databases. Note: This MySQL Performance & Tuning course does not cover clustering (other than at overview level), replication or non-standard storage engines such as Falcon and PBXT. What will you learn Develop a monitoring and tuning plan Use server configuration and status variables. Identify and improve problem queries. Make efficient use of indexes. Monitor and size memory caches and locks. Tune the MyISAM and InnoDB storage engine. Evaluate the use of partitioning for performance. MySQL Performance & Tuning training course details Who will benefit: Anyone who wishes to monitor and tune MySQL performance. Prerequisites: Delegates must have a working knowledge of MySQL Database Administration Duration 3 days MySQL Performance & Tuning training course contents Introduction to performance tuning Tuning overview, Resolving performance issues, Recommended approach to tuning, Items to evaluate, Where to look, Planning a monitoring routine, Building a new database for performance, Tuning an existing database, Setting suitable goals. MySQL performance tuning tools Administration tools, the information schema, performance-related SHOW commands, benchmarking tools, the MySQL performance schema, MonYog. Hands on Obtaining performance information. Schema design Normalisation, de-normalisation, naming conventions, load generation, stress testing and benchmarking tools, selecting data types, data types, character sets, choosing storage engines. Hands on effects of design on performance. Statement tuning Overview of statement tuning, identifying problem queries, the optimizer, explain, explain extended. Hands on identifying problem queries and using explain. Indexes Index overview, Types of index, Index tuning, Indexes and joins. Hands on Indexes and performance. Server configuration and monitoring Server configuration variables, server status variables, table cache, multi-threading, connection issues, query cache. Hands on setting and interpreting server variables and caching. Locking Types of locking, locking and storage engines, effects of locking on performance. Hands on locking and performance. The InnoDB engine Transactions, crash recovery, locking, monitoring InnoDB, caches and buffers, configuring data files, configuring the log files. Hands on InnoDB configuration and performance. Other storage engines MyISAM engine, merge engine, archive engine, memory engine, blackhole engine, CSV engine, the Spider engine, the ColumnStore engine, the MyRocks engine, mixing sorage engines. Hands on storage engine performance. Overview of clustering and performance Advantages of performance, advantages of clustering, performance issues and clustering, the NDBCluster engine, the Galera cluster, the Percona XtraDB cluster, MySQL InnoDB cluster, the federated engine, the federatedX engine, overview of other high availability techniques. NOSQL and Mencached overview. Dumping and loading data SQL statements versus delimited data, parameters affecting dump performance, parameters affecting load performance. Hands on dump and load performance. Partitioned tables Partitioned tables concepts, range partitioning, hash partitioning, key partitioning, list partitioning, composite partitioning or subpartitioning, partition pruning. Hands on partitioned table performance.

Course Objectives At the end of this course you will be able to: Record and edit a Macro Assign macros to keyboard shortcuts, Quick Access Toolbar, Buttons and Shape objects. Use the Visual Basic Editor; change the properties of an object; add a module to a project; write the code for a procedure and then run it; and use the Object Browser to search procedures Manipulate data by declaring variables of different data types; combine data by using expressions; use functions to accept input and display output; and declare variables and procedures with the appropriate scope Use decision structures to create procedures that make decisions; and use loop structures to perform repetitive tasks Create an error handling routine in case things go wrong with VBA code ' 1 year email support service Take a closer look at the consistent excellent feedback from our growing corporate clients visiting our site ms-officetraining co uk Customer Feedback Best Training Ever! Just finished a bespoke 1-1 training course in Excel Advanced, Macros & VBA. Pedro is an excellent trainer, imparting his skills and knowledge in the best way - appropriately to audience skills, knowledge and ability. Pedro is always approachable, encouraging and supportive, giving delegates the optimum learning environment. I would not hesitate to recommend Pedro as a trainer, whatever your level of ability. Amanda Morris - Treasury & Systems Accountant at Reall - Real Equity for All The trainer was very knowledgeable, kept everyone involved and was enthusiastic. A great experience.. Simon Harper - Lloyd's of London My learning experience was awesome. Perdinand Reagan - Subsea7 Very nice and relaxed approach to teaching. Was definitely a good learning experience. Jerome Pupe - S5 Agency World The Trainer – Very positive + patient + helpful + thorough Agnes Souza - Direct Wines ' With more than 20 years experience, we deliver courses on all levels of the Desktop version of Microsoft Office and Office 365; ranging from Beginner, Intermediate, Advanced to the VBA level. Our trainers are Microsoft certified professionals with a proven track record with several years experience in delivering classroom, one to one, tailored and bespoke courses. Tailored In Company training: You can choose to run the course exactly as they are outlined by us or we can customise it so that it meets your specific needs. A tailored or bespoke course will follow the standard outline but may be adapted to your specific organisational needs. Introduction to Macros and VBA Introducing Visual Basic for Applications Recording a Macro Naming conventions for Macro Procedures Running a Macro Absolute or Relative Cell Referencing Saving and Opening Files with Macros Making macros always available Adding Macros to Keyboard Shortcuts, Quick Access Toolbar, Buttons and Shapes Editing a Macro in the Visual Basic Editor Understanding the Development Environment Customising the Editor Tips for General Typing in VBA Using Visual Basic Help Working with Procedures Program Design Understanding Modules Naming Rules Creating a Module Understanding Procedures Programming Macro Concepts Creating a Subroutine Creating a Function Understanding Arguments Exiting Procedures Calling Procedures Objects, Properties, Methods and Events Understanding Objects Properties, Methods, and Events Navigating the Object Hierarchy Understanding Collections Accessing a Member of a Collection Understanding Hierarchy Using the Object Browser Using the With Statement Working with Properties Working with Methods Creating an Event Procedure Reserved Macro Names Using Expressions, Variables and Intrinsic Functions Understanding Expressions and Statements Declaring Variables Understanding Data Types Determining the Value of Variables Working with Variable Scope Using Built-in VBA Functions Understanding Constants Using Message Boxes Controlling the Answer to a Message Box Using Input Boxes Declaring and Using Object Variables Controlling Program Execution Understanding Control-of-Flow Structures Using the If...End If Decision Structures Nested If Statements Using the Select Case ... End Select Structure Using the Do ... Loop Structure Using the For ... Next Structure Using the For Each ... Next Structure Guidelines for Use of Control-of-Flow Structures Debugging and Handling Errors Understanding Errors Using Debugging Tools Setting Breakpoints and Using Break Mode Stepping Through Code Trapping Errors with the On Error Statement Understanding the Err Object Working with Inline Error Handling Writing an Error-Handling Routine Working with Forms and Controls Understanding UserForms Creating a Form Displaying and Removing a Form Aligning and Sizing Controls Using the Toolbox Working with a Form's Properties, Methods, and Events Working with Form and Control Properties, Methods and Event Setting the Tab Order Populating a Control Who is this course for? Who is this course for? This course is designed to give proficiency in the Visual Basic Editor (VBE), predominantly making use of Excel objects, understanding Object's Properties, Events and Methods, basic VBA Object oriented programming, event handling, control structures, and debugging tools. Requirements Requirements Preferably, delegates should have attended the Excel Advanced course. Career path Career path Excel know-how can instantly increase your job prospects as well as your salary. 80 percent of job openings require spreadsheet and word-processing software skills Certificates Certificates Certificate of completion Digital certificate - Included

How to Fix Lower Back Pain in Just 21 Days  When back pain strikes, it can ruin your life. Reaching for painkillers or having surgery can be ineffective and even dangerous for your health. Chronic pain affects 100 million people each year, and low back pain is the most common complaint. When the body's pain signals keep firing in the nervous system, it can have a draining effect on the quality of life-physically, mentally, and spiritually. In the United States, 8 out of 10 people will experience low back pain at some time in their lives. Low back pain is the second most frequent reason for doctor visits, next to the common cold, and it is the leading cause of job-related disabilities. What you'll learn You will learn the 9 worst back exercises for back pain (with better alternatives) You will learn a highly effective 21-day, 30-minutes or less, back pain exercise routine You will learn a 15-minute, Doctor-recommended back pain exercise routine You will learn 6 foam rolling moves to conquer back pain You will learn a 6-minute emergency back pain treatment that's safe for both herniated and bulging discs You will learn 7 exercises you need to be doing to prevent back spasms and herniated discs You will learn 7 resistance-band exercises that will help strengthen your low back and hips And You will learn 4 moves to do before you roll out of bed in the morning Requirements You should have basic computer skills and access to a wifi connection No fancy gym equipment is needed. All you need is a comfortable surface like a carpet, rug or yoga mat. You will need to 15-30 minutes a day to do this at home back pain relief exercise routine. You will also need the will and determination to do the exercises. I did them for 21 days and BOOM - my back pain vanished! So can yours if you follow my program. Low Back Pain Relief Secrets Welcome to Low Back Pain Relief FREE 00:02:00 4 Most Common Reasons for Lower Back Pain FREE 00:02:00 9 Worst Back Exercises for Back Pain 00:04:00 21 Day Low Back Pain Relief 00:15:00 15 Minute Doctor 00:08:00 Top 7 Exercises To Prevent 00:05:00 6 Minute Emergency Back Pain Treatment 00:03:00 7 Resistance Band Exercises for Low Back Pain 00:06:00 6 Foam Rolling Moves to Conqier Back Pain 00:03:00 4 Moves To Do Before You Roll Out of Bed 00:02:00 Bonus Better Posture Reports Prolonged Sitting and Back Pain 00:10:00 Stand The Right Way in 8 Moves 00:10:00 6 Exercises to Reverse Bad Posture 00:10:00

Course Description Get instant knowledge from this bite-sized Cattery Management Part - 1 course. This course is very short and you can complete it within a very short time. In this Cattery Management Part - 1 course you will get fundamental ideas of cattery management, the key understanding of designing your cattery, equipment required and so on. Enrol in this course today and start your instant first step towards learning about catteries. Learn faster for instant implementation. Learning Outcome Familiarise with catteries Understand the planning and designing of your cattery Gain in-depth knowledge of the equipment required and daily routine Learn about licences and legislation How Much Do Cattery Managers Earn? Senior - £135,000 (Apprx.) Average - £69,000 (Apprx.) Starting - £36,000 (Apprx.) Requirement Our Cattery Management Part - 1 is fully compatible with any kind of device. Whether you are using Windows computer, Mac, smartphones or tablets, you will get the same experience while learning. Besides that, you will be able to access the course with any kind of internet connection from anywhere at any time without any kind of limitation. Cattery Management Part - 1 Module 01: Introduction to Catteries 00:14:00 Module 02: Licences and Legislation 00:18:00 Module 03: Planning and Designing your Cattery 00:24:00 Module 04: Equipment Required and Daily Routine 00:19:00 Assignment Assignment - Cattery Management Part - 1 00:00:00