1544 Running courses delivered Online

Unveil your entrepreneurial spirit with our encompassing course bundle: "Candle Making, Startup and Baking Business - QLS Endorsed". Through this journey, you'll find the theoretical knowledge needed to start your Candle Making Business, learn the intricacies of a Startup, and discover the secret recipe to a successful Baking Business. Begin your journey with our QLS-endorsed courses, diving deep into the realm of Candle Making Business, exploring the essential components of a successful Business Startup, and kneading your path to Baking Business mastery. Upon course completion, receive a hardcopy certificate, showcasing your theoretical proficiency in Candle Making, Startup and Baking Business. To complement these, our bundle also includes five CPD QS accredited courses, each covering an essential aspect of your business journey. Key Features of the Candle Making, Startup and Baking Business Bundle: 3 QLS-Endorsed Courses: We proudly offer 3 QLS-endorsed courses within our Candle Making, Startup and Baking Business bundle, providing you with industry-recognized qualifications. Plus, you'll receive a free hardcopy certificate for each of these courses. QLS Course 01: Candle-Making Business QLS Course 02: Business Startup QLS Course 03: Baking: Starting Your Own Bakery 5 CPD QS Accredited Courses: Additionally, our bundle includes 5 relevant CPD QS accredited courses, ensuring that you stay up-to-date with the latest industry standards and practices. Course 01: Cookery Course Course 02: UK Cooking and Gastronomy Technician Course 03: Mastering Entrepreneurship Course 04: Business Management Course 05: Business Law In Addition, you'll get Five Career Boosting Courses absolutely FREE with this Bundle. Course 01: Professional CV Writing Course 02: Job Search Skills Course 03: Self-Esteem & Confidence Building Course 04: Professional Diploma in Stress Management Course 05: Complete Communication Skills Master Class Convenient Online Learning: Our Candle Making, Startup and Baking Business courses are accessible online, allowing you to learn at your own pace and from the comfort of your own home. Ready to embark on your entrepreneurial journey in Candle Making, Startup, and Baking Business? Enroll today! Learning Outcomes: Understand the theoretical aspects of starting and managing a Candle Making Business. Learn the essential components of launching a Business Startup. Gain theoretical knowledge about starting and running a successful Baking Business. Enhance your culinary skills through the Cookery Course and UK Cooking and Gastronomy. Gain entrepreneurial knowledge through the Mastering Entrepreneurship course. Learn about Business Management and Business Law. Grasp the key factors for the successful operation of your business. The "Candle Making, Startup, and Baking Business - QLS Endorsed" bundle equips you with the comprehensive theoretical knowledge you need to kick-start your entrepreneurial journey. With our blend of three QLS-endorsed and five CPD QS accredited courses, we pave the way for you to explore your passion in Candle Making, Startup, and Baking Business. Embrace your entrepreneurial spirit and join us as we explore the theoretical concepts of candle making, starting up a business, and baking, paving the way to fulfilling your business aspirations. CPD 260 CPD hours / points Accredited by CPD Quality Standards Who is this course for? Aspiring entrepreneurs interested in Candle Making, Startup and Baking Business. Individuals who want to gain theoretical knowledge in the field of entrepreneurship. Anyone looking to refine their skills in cookery and gastronomy. Individuals aiming to understand business management and business law. Career path Candle Making Business Owner - £20,000 - £40,000 per year. Startup Founder - £25,000 - £70,000 per year. Bakery Owner - £20,000 - £50,000 per year. Gastronomy Technician - £20,000 - £40,000 per year. Business Manager - £30,000 - £60,000 per year. Business Law Consultant - £40,000 - £80,000 per year. Certificates Digital certificate Digital certificate - Included Hard copy certificate Hard copy certificate - Included

Unlock the door to your business future with our QLS Endorsed Business Development, Analysis, and Finance course bundle. This comprehensive selection includes three QLS-endorsed courses: Business Development, Diploma in Business Analysis, and Basic Business Finance, each conferring a hardcopy certificate upon completion as a testament to your theoretical prowess. In addition to these, five CPD QS accredited courses are part of the package. These insightful courses delve into Business Law, Marketing Strategies for Business, Business Continuity Management, Business Intelligence and Data Mining, and Touch Typing Essentials. Armed with this robust knowledge, you can confidently navigate the business world, adeptly handling development, analysis, and finance. Whether your interest lies in entrepreneurship, corporate finance, or business analysis, this bundle offers an enriching theoretical journey into the heart of business. Key Features of the QLS Endorsed Business Development, Analysis and Finance Bundle: 3 QLS-Endorsed Courses: We proudly offer 3 QLS-endorsed courses within our QLS Endorsed Business Development, Analysis and Finance bundle, providing you with industry-recognized qualifications. Plus, you'll receive a free hardcopy certificate for each of these courses. QLS Course 01: Business Development QLS Course 02: Diploma in Business Analysis QLS Course 03: Basic Business Finance 5 CPD QS Accredited Courses: Additionally, our bundle includes 5 relevant CPD QS accredited courses, ensuring that you stay up-to-date with the latest industry standards and practices. Course 01: Business Law Course 02: Marketing Strategies for Business Course 03: Business Continuity Management Course 04: Business Intelligence and Data Mining Course 05: Touch Typing Essentials In Addition, you'll get Five Career Boosting Courses absolutely FREE with this Bundle. Course 01: Professional CV Writing Course 02: Job Search Skills Course 03: Self Esteem & Confidence Building Course 04: Professional Diploma in Stress Management Course 05: Complete Communication Skills Master Class Convenient Online Learning: Our QLS Endorsed Business Development, Analysis and Finance courses are accessible online, allowing you to learn at your own pace and from the comfort of your own home. Learning Outcomes: Gain a comprehensive understanding of business development principles. Acquire skills to perform effective business analysis. Understand the basics of business finance. Familiarise with the legal aspects of running a business. Learn how to develop effective marketing strategies. Understand the importance of business continuity management. Gain insights into business intelligence and data mining. Our QLS Endorsed Business Development, Analysis, and Finance bundle presents a comprehensive theoretical journey into the world of business. The course bundle is a balance of QLS-endorsed and CPD QS accredited courses, covering critical areas like business development, business analysis, business finance, business law, marketing strategies, business continuity management, business intelligence, data mining, and touch typing essentials. This bundle is a gateway to a holistic understanding of business processes, structures, and strategies, whether you're a budding entrepreneur, an aspiring business analyst, or a business graduate seeking deeper knowledge. Dive into this wealth of knowledge and embark on a successful business career! CPD 250 CPD hours / points Accredited by CPD Quality Standards Who is this course for? Aspiring entrepreneurs looking to understand the nuances of business development, analysis, and finance. Individuals aiming to pursue a career in business analysis or finance. Business professionals seeking to broaden their knowledge and skills. Students of business studies wishing to supplement their academic learning. Career path Business Development Manager (Salary Range: £30,000 - £60,000) Business Analyst (Salary Range: £35,000 - £70,000) Finance Manager (Salary Range: £40,000 - £75,000) Business Law Consultant (Salary Range: £40,000 - £90,000) Marketing Strategist (Salary Range: £25,000 - £55,000) Business Continuity Manager (Salary Range: £40,000 - £80,000) Certificates Digital certificate Digital certificate - Included Hard copy certificate Hard copy certificate - Included

Duration 5 Days 30 CPD hours This course is intended for This is an intermediate course for z/OS system programmers, z/OS performance analysts, and z/OS performance administrators new to performance management for their z/OS system.Note: ES54 is intended for individuals new to WLM and the z/OS performance area Overview The objectives for this course are as follows:Describe a performance and tuning methodologyDevelop a systematic z/OS performance and tuning planDescribe the factors which could affect the performance of an z/OS systemUse the WLM ISPF applicationDescribe the components of a service definitionDefine workloads and service levels and classification rulesState which z/OS commands affect WLM operationIdentify the major WLM services for z/OS, including enclaves and application environments, and how they are used by DB2, WebSphere, and CICSAnalyze CPU performance when running in a shared LPAR environmentUtilize and monitor zIIP and zAAP specialty enginesMeasure and tune z/OS DASD, processor storage, and coupling facility configurationsExplain the functions and facilities of RMF and SMFAnalyze performance bottlenecks using RMFUse Workload License Charges (WLC), defined capacity and soft capping to manage software costsDescribe advanced z/OS environments that utilize Intelligent Resource Director (IRD), HiperDispatch, z/OSMF Workload Management, and I/O Priority ManagerUse the z/OSMF Workload Management (WLM) taskUse Performance Monitoring with z/OSMFModify a WLM service definition to meet the requirements for monitoring a specific system workloadCreate and customize Monitoring DesktopsReview any issues by using the Monitoring Desktops options displaysAssess the performance of the workloads running on the z/OS This course is designed for new performance analysts to learn to work with the Workload Manager (WLM) in goal mode. Learn concepts of WLM and performance management in the z/OS system using the WLM. Day 1 Welcome Unit 1 - Tuning methodology Unit 2 - Using SMF and RMF to monitor performance Lab 1 - Introduction to your system Lab 2 - Using RMF Monitor I and Monitor II Day 2 Unit 3 - Performance impacts when running in a shared LPAR environment Unit 4 - Basic system workload management (part 1) Lab 3 - Implementing a WLM environment on z/OS (part 1) Day 3 Unit 4 - Basic system workload management (part 2) Lab 3 - Implementing a WLM environment on z/OS (part 2) Day 4 Unit 5 - WLM commands, internals, and service Lab 4 - Using RMF Monitor III to solve performance problems Day 5 Unit 6 - z/OS DASD performance topics Unit 7 - Tuning processor storage Unit 8 - Miscellaneous performance topics Lab 5 - z/OSMF and performance management

Level 5 Certificate in Cleaning Overview In order to maintain a clean and healthy living environment, cleaning is an integral part of our everyday life. However, cleaning needs a certain set of abilities and knowledge, and it can be a difficult and time-consuming task. This is where the Level 5 Certificate in Cleaning comes in handy. After finishing this course, you will have an in-depth knowledge of the cleaning sector and know how to successfully and efficiently offer high-quality cleaning services. The 17 modules in the course cover every facet of cleaning, from basic housekeeping to cleaning offices and commercial kitchens to cleaning exterior surfaces and spaces. Every module aims to equip you with the necessary information and abilities to thrive in the cleaning sector. Additionally, you will learn about keyholding, chemical safety, and cleaner alarm codes-all of which are critical knowledge for any professional cleaner. The course covers effective cleaning techniques in addition to staff management, staff startup, marketing, advertising, and sales. Using this all-inclusive strategy guarantees that you possess not just the ability to deliver high-quality cleaning services but also the know-how and abilities to manage a profitable cleaning company. Learning Outcome Familiarise with the cleaning job Understand the diversity of cleaning jobs Gain in-depth knowledge of cleaning equipment, products and clothing Deepen your understanding of house cleaning How Much Do Cleaners Earn? Senior - £25,000 (Apprx.) Average - £20,000 (Apprx.) Starting - £17,000 (Apprx.) Requirement Our Level 5 Certificate in Cleaning 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. Level 5 Certificate in Cleaning Module 01: An Introduction to the Cleaning Job An Introduction to the Cleaning Job 00:16:00 Module 02: The Diversity of Cleaning Jobs The Diversity of Cleaning Jobs 00:23:00 Module 03: Cleaning Equipment, Products and Clothing Cleaning Equipment, Products and Clothing 00:21:00 Module 04: House Cleaning House Cleaning 00:20:00 Module 05: Food Kitchen and Commercial Kitchen Cleaning Food Kitchen and Commercial Kitchen Cleaning 00:20:00 Module 06: Bathrooms and Toilets Bathrooms and Toilets 00:19:00 Module 07: Office Cleaning Office Cleaning 00:17:00 Module 08: Cleaning External Surfaces and Areas Cleaning External Surfaces and Areas 00:15:00 Module 09: Dealing with Non-Routine Waste Dealing with Non-Routine Waste 00:18:00 Module 10: Chemical Safety, Keyholding and Alarm Codes for Cleaners Chemical Safety, Keyholding and Alarm Codes for Cleaners 00:18:00 Module 11: Starting a Cleaning Business and Planning for it Starting a Cleaning Business and Planning for it 00:14:00 Module 12: Running the Business with Quality Service Running the Business with Quality Service 00:19:00 Module 13: Customer Satisfaction Customer Satisfaction 00:20:00 Module 14: Management of Staff Management of Staff 00:19:00 Module 15: Marketing, Advertising and Sales Marketing, Advertising and Sales 00:21:00 Module 16: Expansion Management Expansion Management 00:15:00 Module 17: Business Insurance, Tax and Additional Equipment Business Insurance, Tax and Additional Equipment 00:21:00

Overview This comprehensive course on Learn AutoCAD Programming using VB.NET - Hands On! will deepen your understanding on this topic. After successful completion of this course you can acquire the required skills in this sector. This Learn AutoCAD Programming using VB.NET - Hands On! 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 Learn AutoCAD Programming using VB.NET - Hands On!. It is available to all students, of all academic backgrounds. Requirements Our Learn AutoCAD Programming using VB.NET - Hands On! 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 11 sections • 105 lectures • 12:09:00 total length •Module 01: Course Outline: 00:05:00 •Module 02: Introduction: 00:01:00 •Module 03: Who is this Course for?: 00:01:00 •Module 04: What will I learn from this Course?: 00:01:00 •Module 05: What is VB.NET?: 00:01:00 •Module 06: What is AutoCAD .NET API?: 00:01:00 •Module 07: What are the advantages of programming in AutoCAD .NET API?: 00:01:00 •Module 08: Hands-on Projects overview: 00:06:00 •Module 01: AutoCAD .NET API Components Overview: 00:01:00 •Module 02: AutoCAD .NET API Assemblies: 00:02:00 •Module 03: Understanding AutoCAD Object Hierarchy: 00:03:00 •Module 04: AutoCAD .NET API Application Object: 00:02:00 •Module 05: AutoCAD .NET API Document Object: 00:02:00 •Module 06: AutoCAD .NET API Database Object: 00:04:00 •Module 01: Section Overview: 00:04:00 •Module 02: Installing Visual Studio 2019: 00:05:00 •Module 03: Setting up Visual Studio 2019 Integrated Development Environment (IDE): 00:04:00 •Module 04: Creating First VB.NET Plugin (Hello AutoCAD): 00:12:00 •Module 05: Different ways to communicate with the User: 00:04:00 •Module 06: Configuring VS2019 Target Processor: 00:10:00 •Module 01: Creating AutoCAD Object using VB.NET Overview: 00:01:00 •Module 02: Creating DrawObjects Project: 00:04:00 •Module 03: Creating a Line Object using VB.NET: 00:15:00 •Module 04: Creating a MText Object using VB.NET: 00:12:00 •Module 05: Creating a Circle Object using VB.NET: 00:09:00 •Module 06: Creating an Arc Object using VB.NET: 00:07:00 •Module 07: Creating a Polyline Object using VB.NET: 00:08:00 •Module 08: Creating Multiple Circles Vertically: 00:09:00 •Module 09: Creating Multiple Circles Horizontally: 00:05:00 •Module 01: Manipulating AutoCAD Objects Overview: 00:01:00 •Module 02: Creating the Project ManipulateObjects: 00:04:00 •Module 03: Creating the SingleCopy Method: 00:13:00 •Module 04: Creating the MultipleCopy Method: 00:11:00 •Module 05: Creating the EraseObject Method: 00:12:00 •Module 06: Creating the MoveObject method: 00:07:00 •Module 07: Creating the MirrorObject method: 00:10:00 •Module 08: Creating the RotateObject method: 00:07:00 •Module 09: Creating the ScaleObject method: 00:05:00 •Module 10: Creating the OffsetObject method: 00:05:00 •Module 01: Exploring AutoCAD Dictionaries - Overview: 00:02:00 •Module 02: Creating LayersLineTypesAndStyles Project: 00:06:00 •Module 03: Creating the ListLayers Method: 00:11:00 •Module 04: Creating the CreateLayer Method: 00:10:00 •Module 05: Creating the UpdateLayer Method: 00:12:00 •Module 06: Creating the SetLayerOnOff Method: 00:08:00 •Module 07: Creating the SetLayerFrozenOrThaw Method: 00:04:00 •Module 08: Creating the DeleteLayer Method: 00:05:00 •Module 09: Creating the LockUnlockLayer Method: 00:04:00 •Module 10: Creating the SetLayerToObject Method: 00:08:00 •Module 11: Creating the ListLineTypes Method: 00:09:00 •Module 12: Creating the LoadLineType Method: 00:07:00 •Module 13: Creating the SetCurrentLineType Method: 00:05:00 •Module 14: Creating the DeleteLineType Method: 00:09:00 •Module 15: Creating the SetLineTypeToObject Method: 00:05:00 •Module 16: Exploring TextStyles - Overview: 00:01:00 •Module 17: Creating the ListStyles Method: 00:08:00 •Module 18: Creating the UpdateCurrentTextStyleFont Method: 00:12:00 •Module 19: Creating the SetCurrentTextStyle Method: 00:08:00 •Module 20: Creating the SetTextStyleToObject Method: 00:08:00 •Module 01: User Input Functions - Overview: 00:02:00 •Module 02: Creating the UserInteractions Project: 00:03:00 •Module 03: Creating the GetName Method: 00:11:00 •Module 04: Creating the SetLayer Method using the GetString function: 00:12:00 •Module 05: Creating the CreateLineUsingGetpoint Method: 00:11:00 •Module 06: Creating the CalculateDefinedArea Method: 00:17:00 •Module 07: Creating the DrawObjectsUsingGetKeywords Method: 00:14:00 •Module 08: Creating the GetDistanceBetweenTwoPoints Method: 00:05:00 •Module 09: Creating the CountObjects Method: 00:15:00 •Module 01: Selection Sets and Filters - Overview: 00:13:00 •Module 02: Creating the SelectionSets Project: 00:05:00 •Module 03: Creating the SelectAllAndChangeLayer Method: 00:12:00 •Module 04: Creating the SelectObjectOnScreen Method: 00:08:00 •Module 05: Creating the SelectWindowAndChangeColor Method: 00:06:00 •Module 06: Creating the SelectCrossingAndDelete Method: 00:05:00 •Module 07: Creating the SelectFenceAndChangeLayer Method: 00:06:00 •Module 08: Creating the CountPickFirstSelection Method: 00:07:00 •Module 09: Creating the SelectLines Method: 00:13:00 •Module 10: Creating the SelectMTexts Method: 00:05:00 •Module 11: Creating the SelectPlines Method: 00:04:00 •Module 12: Creating the SelectWalls Method: 00:07:00 •Module 13: Creating the SelectStairs Method: 00:03:00 •Module 14: Creating the SelectFrenchDoors Method: 00:04:00 •Module 15: Creating the SelectBifoldDoors Method: 00:03:00 •Module 16: Creating CountReceptacles Method: 00:04:00 •Module 17: Creating the CountLightingFixtures Method: 00:10:00 •Module 01: Developing Projects - Hands on Overview: 00:02:00 •Module 02: BlocksCounter Plugin Demo: 00:03:00 •Module 03: Creating the BlocksCounter Project: 00:04:00 •Module 04: Creating the CountBlocksToTable Method: 00:08:00 •Module 05: Creating the PromptUser Function: 00:08:00 •Module 06: Creating the GatherBlocksAndDrawTable Method: 00:12:00 •Module 07: Continuation of GatherBlocksAndDrawTable Method: 00:17:00 •Module 08: Running and Debugging the BlocksCounter Project - Part 1: 00:15:00 •Module 09: Running and Debugging the BlocksCounter Project - Part 2: 00:11:00 •Module 10: Running and Debugging the BlocksCounter Project - Part 3: 00:01:00 •Module 11: Creating the ObjectExtractor Plugin Project: 00:04:00 •Module 12: Creating the ExtractObjects Method: 00:07:00 •Module 13: Creating the ExtractLine Method: 00:16:00 •Module 14: Running and Debugging the ExtractLine Method: 00:05:00 •Module 15: Creating the ExtractCircle Method: 00:11:00 •Module 16: Creating the ExtractMText Method: 00:13:00 •Module 17: Creating the ExtractPolyline Method: 00:19:00 •Module 18: Creating the ExtractBlock Method: 00:10:00 •Module 01: Congratulations and Thank you very much!: 00:01:00 •Assignment - Learn AutoCAD Programming using VB.NET - Hands On!: 00:00:00

Course Objectives At the end of this course you will be able to: Work with advanced lookup and reference functions Create macros to automate common tasks Use advanced techniques to analyse data Create PivotTables and PivotCharts Work with data validation tools Import and export data ' 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 course was very interesting and engaging and will definitely be put to use. The trainer was very helpful and charismatic. Marving Lopez - AM Best Europe Pedro was excellent. Very knowledgeable, clear and great rapport with class. Darren Barkey - Direct Wines Great content and learnt a lot. Really enjoyable :) Kristie-Lee Ryan - Stirling Ackroyd 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 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. Please visit our site (ms-officetraining co uk) to get a feel of the excellent feedback our courses have had and look at other courses you might be interested in. Advanced Functions COUNT, COUNTA, COUNTIF, COUNTBLANK, SUMIF, SUBTOTAL IF, OR, AND, IFERROR VLOOKUP to lookup Exact Values and Approximate values MATCH, INDIRECT, ROW/COLUMN, INDEX, OFFSET Analysing Data PMT function to calculate a monthly payment of a loan What If Analysis using Goal Seek Use scenarios to consider many different variables Using Solver Add-in to optimize variables PivotTables Create a PivotTable to analyse worksheet data Add or remove fields in a PivotTable Change the data source for a PivotTable Working with external data sources Using different Statistical Functions Calculate a Running Total, % of Grant Total, Difference From… Using the Slicer and Timeline to filter the PivotTable Using Filters in a PivotTable Group by Date, Auto Group by ranges of values, Custom Group Create a PivotChart The GETPIVOTDATA function Formula auditing Precedents and dependents Error checking Watch a formula and its result by using the Watch Window Evaluate a nested formula one step at a time Data Validation Number Validation Data List Validation Message Prompts and Alerts Conditional Data Validation Data Validation Errors Consolidation Consolidate data by position Consolidate data by category Use a formula to consolidate data Outline (group) data in a worksheet Create an outline of rows Create an outline of columns Copy outlined data Hide or remove an outline Connect external data to your workbook Using the Power Query Editor to import data From Text and CSV, From Access, From Web, From another Workbook Using the Power Query Editor to; Transform your data by Selecting which fields to import, by Splitting Columns, Changing Data Type and more. Deleting Applied Steps Refreshing your data Working with Form Controls; Buttons, Option Buttons and Scroll Bars Introduction to Macros Change Macro Security settings How to Record a macro Some Macro Examples Delete a macro Edit the macro to view the VBA code Copy part of a macro to create another macro Assign a macro to a button Who is this course for? Who is this course for? This course is intended to end users who want to develop their skills so they can use advanced techniques to analyse extensive and complex datasets in Excel and to automate simple tasks with the use of Macros. Requirements Requirements Preferably, delegates should have attended the Excel Intermediate 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

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

Level 7 QLS Endorsed Course | CPD & CiQ Accredited | Audio Visual Training | Free PDF Certificate | Lifetime Access

Bike Maintenance / Motorcycle Maintenance Introducing: Bike Maintenance / Motorcycle Maintenance- Your Ultimate Guide to Keeping Your Ride Running Smoothly! Do you want to make a career in the Bike Maintenance / Motorcycle Maintenance field? This Bike Maintenance / Motorcycle Maintenance course aims to provide a better understanding of Bike Maintenance / Motorcycle Maintenance. Our extensive Bike Maintenance / Motorcycle Maintenance course covers all the latest topics to keep you better prepared for your Bike Maintenance / Motorcycle Maintenance profession. Our Bike Maintenance / Motorcycle Maintenance course is designed for those who want to learn how to maintain their bikes/motorcycles. You will learn essential skills, such as Engine Design & Basic Theory, Engine Cooling & Lubrication, Clutch, Suspension, Charging System, Troubleshooting and more. Our comprehensive Bike Maintenance / Motorcycle Maintenance course covers everything you need to know to keep your bike/motorcycle running smoothly and efficiently. Our format makes it easy and convenient to take the Bike Maintenance / Motorcycle Maintenance course at your own pace. You can access the Bike Maintenance / Motorcycle Maintenance course from anywhere and anytime, whether you are at home or on the go. Enrol now for a successful Bike Bike Maintenance / Motorcycle Maintenance career! Special Offers of this Bike Maintenance Course This Bike Maintenance Course includes a FREE PDF Certificate. Lifetime access to this Bike Maintenance: Bike Maintenance Course Instant access to this Bike Maintenance: Bike Maintenance Course Get FREE Tutor Support from Monday to Friday in this Bike Maintenance Course Courses you GET Course 01: Bike Maintenance / Motorcycle Maintenance Course 02: Car Mechanic Training Course 03: Bicycle Maintenance [ Note: Free PDF certificate as soon as completing the Bike Maintenance / Motorcycle Maintenance course] Bike Maintenance / Motorcycle Maintenance Industry Experts Designed this Bike Maintenance / Motorcycle Maintenance course into 15 detailed modules. Module 1: Engine Design & Basic Theory Module 2: Engine Cooling & Lubrication Module 3: Ignition Module 4: Intake, Fuel, & Exhaust Systems Module 5: Clutch Module 6: Transmission & Primary Drive Module 7: Final Drive Module 8: Suspension Module 9: Wheels & Tires Wheels Module 10: Brakes Module 11: Frame & Steering Module 12: Charging System & Battery Electrical Basics Module 13: Lights, Switches, & Instruments Module 14: Cleaning, Setting-Up, & Storage Module 15: Troubleshooting Assessment Method of Bike Maintenance / Bike Maintenance After completing each module of the Bike Maintenance / Motorcycle Maintenance Course, you will find automated MCQ quizzes. To unlock the next module, you need to complete the quiz task and get at least 60% marks. Certification of Bike Maintenance / Bike Maintenance After completing the MCQ/Assignment assessment for this Bike Maintenance / Motorcycle Maintenance course, you will be entitled to a Certificate of Completion from Training Tale. Who is this course for? Bike Maintenance / Motorcycle Maintenance This Bike Maintenance / Motorcycle Maintenance course is open to everyone. Requirements Bike Maintenance / Motorcycle Maintenance Students who intend to enrol in this Bike Maintenance course must meet the following requirements: Bike Maintenance: Good command of the English language Bike Maintenance: Must be vivacious and self-driven Bike Maintenance: Basic computer knowledge Bike Maintenance: A minimum of 16 years of age is required Career path Bike Maintenance / Motorcycle Maintenance Certificates Certificate of completion Digital certificate - Included

Do you want to be a successful business? Do you want to understand the type of business you are entering? This course will help you to get a crystal clear idea about tuition business and its effectiveness. Course Description: Tuition is one of the demanding fields in today's world. Nowadays, the education system is intermingled with tuition system. Every parent wants to make their child educated. As a result, the demand for an alternative teaching system is increasing day by day. The course focuses the basics of tuition business and explains why it is an excellent idea for business. The course illustrates the importance of running a tuition business. By the end of the course, you will be able to decide whether it is the perfect business for you or not. Course Highlights Tuition Business Fundamentals is an award winning and the best selling course that has been given the CPD Certification & IAO accreditation. It is the most suitable course anyone looking to work in this or relevant sector. It is considered one of the perfect courses in the UK that can help students/learners to get familiar with the topic and gain necessary skills to perform well in this field. We have packed Tuition Business Fundamentals into 8 modules for teaching you everything you need to become successful in this profession. To provide you ease of access, this course is designed for both part-time and full-time students. You can become accredited in just 3 hours and it is also possible to study at your own pace. We have experienced tutors who will help you throughout the comprehensive syllabus of this course and answer all your queries through email. For further clarification, you will be able to recognize your qualification by checking the validity from our dedicated website. Why You Should Choose Tuition Business Fundamentals Lifetime access to the course No hidden fees or exam charges CPD Accredited certification on successful completion Full Tutor support on weekdays (Monday - Friday) Efficient exam system, assessment and instant results Download Printable PDF certificate immediately after completion Obtain the original print copy of your certificate, dispatch the next working day for as little as £9. Improve your chance of gaining professional skills and better earning potential. Who is this Course for? Tuition Business Fundamentals is CPD certified and IAO accredited. This makes it perfect for anyone trying to learn potential professional skills. As there is no experience and qualification required for this course, it is available for all students from any academic backgrounds. Requirements Our Tuition Business Fundamentals 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. Career Path You will be ready to enter the relevant job market after completing this course. You will be able to gain necessary knowledge and skills required to succeed in this sector. All our Diplomas' are CPD and IAO accredited so you will be able to stand out in the crowd by adding our qualifications to your CV and Resume. Chapter-1 Introduction To Tuition Business Basics 00:30:00 Chapter-2 Reasons To Start A Tuition Business 00:30:00 Chapter-3 Arranging Your Tuition Business 00:30:00 Chapter-4 How To Start A Successful Tuition Business 00:30:00 Chapter-5 Best Way To Grow Your Tutoring Business 00:30:00 Chapter-6 The Essential Benefits Of running A Tuition Business 00:15:00 Chapter-7 Wrapping Up 00:15:00 Additional Study Material Tutor business book preview 00:00:00 Mock Exam Final Exam