• Professional Development
  • Medicine & Nursing
  • Arts & Crafts
  • Health & Wellbeing
  • Personal Development

3076 Courses in Birmingham delivered Live Online

3ds Max and Photoshop Training

By London Design Training Courses

Why Choose 3ds Max and Photoshop Training Course? Click here for more info 3D modeling and rendering potential with our specialized 3ds Max and Photoshop Training Course! Learn from modeling to rendering in 3ds Max and enhance visuals with Photoshop. Personalized, live online sessions with an experienced instructor. Enroll now and bring your 3D visualizations to life. Duration: 20 hrs Method: 1-on-1, Personalized attention. Schedule: Tailor your own hours of your choice, available from Mon to Sat between 9 am and 7 pm. The 3ds Max and Photoshop Training Course offers comprehensive learning for beginners, focusing on core skills to create 3D models, rendered images, animations, and games using 3ds Max and Photoshop. Led by Autodesk Certified Instructors with expertise in 3D design, CGI, and visualizations, the course provides hands-on and practical training. 20-hour 3ds Max and Photoshop Training Course Course Description: 20-hour 3ds Max and Photoshop Training Course to master 3D modeling, rendering, and post-production. Learn to create 3D models, apply textures, animate objects, and utilize lighting techniques in 3ds Max. Gain expertise in Photoshop for post-processing and creating photorealistic textures. Ideal for 3D artists of all levels. Course Outline: Part 1: Introduction to 3ds Max (6 hours) - Understanding the user interface and workspace of 3ds Max - Navigating the viewport and utilizing basic tools for modeling - Creating and manipulating primitive objects for design purposes - Modifying objects with modifiers to achieve specific effects - Working with materials and textures to add realistic detail to 3D models - Basic lighting and rendering techniques to present the 3D scenes Part 2: Intermediate 3ds Max Techniques (6 hours) - Modeling using splines and polygons for more complex shapes - Creating and animating cameras to simulate real-world perspectives - Rigging and animating characters with bones for animation projects - Utilizing particle systems for visual effects and dynamic simulations - Designing realistic environments using landscape tools for outdoor scenes - Exploring advanced lighting and rendering techniques for enhanced visuals Part 3: Introduction to Photoshop for 3D Artists (4 hours) - Understanding the Photoshop workspace and essential tools for editing - Importing and exporting 3D models and textures between 3ds Max and Photoshop - Creating and editing textures and materials in Photoshop for realistic surfaces - Utilizing Photoshop for post-production and compositing to enhance 3D renders Part 4: Advanced Photoshop Techniques for 3D Artists (4 hours) - Creating custom brushes and textures for unique artistic elements - Using layer masks and adjustment layers for non-destructive editing - Exploring advanced compositing techniques for seamless integration of 3D elements - Creating photorealistic textures and materials for stunning 3D visuals Part 5: Project-Based Learning (4 hours) - Applying 3ds Max and Photoshop techniques to a real-world project - Creating a 3D model, texturing it in Photoshop, and rendering the final image - Receiving instructor feedback for critiquing and refining the project - Final presentation of the completed project showcasing skills learned.

3ds Max and Photoshop Training
Delivered in London or OnlineFlexible Dates
£600

Online Course

By Project Forex

The Online Course consists of images, text, voice overs, diagrams, charts, videos and tests in order to give a full learning experience for every type of learner. The Online Course is designed with easy to follow, brief, yet detailed explanations to add value to your trading journey making it almost impossible for you not to become a consistently profitable trader once completed and competent.   All students that take the online course receive a Project Forex trading box. There are 50+ lessons spread out over 7 stages which are designed to help beginners and advanced traders master their trading skills and knowledge throughout the course. Price: £500 One Off Payment

Online Course
Delivered OnlineFlexible Dates
£500

BOHS P402 Online - Surveying and sampling strategies for Asbestos in buildings

By Airborne Environmental Consultants Ltd

The main subject areas of the course are: Building construction and the uses of asbestos Survey types Bulk sampling and material assessments Survey reports Quality control

BOHS P402 Online - Surveying and sampling strategies for Asbestos in buildings
Delivered in Manchester + 1 more or OnlineFlexible Dates
£575

BOHS P402 - Surveying and sampling strategies for Asbestos in buildings

By Airborne Environmental Consultants Ltd

Asbestos surveyors, or managers of surveyors and surveying teams. Asbestos re-inspectors or anyone that undertakes asbestos re-inspections. Those who require a detailed understanding of asbestos surveying principles (e.g. asbestos report writers, architects, building surveyors etc.) Prior Knowledge and Understanding Candidates for this course are expected to be aware of the contents of HSG 264 Asbestos, the survey guide and have a minimum of six months prior experience of assisting on asbestos surveys. In addition, candidates are expected to have had training to cover the core competencies outlined within the foundation material detailed within Table A9.1 of HSG248 Asbestos: The Analysts' Guide (July 2021). This may be achieved by In -house learning or through the P400 foundation module.

BOHS P402 - Surveying and sampling strategies for Asbestos in buildings
Delivered in Manchester + 1 more or OnlineFlexible Dates
£575

Nutrition & Health Certificate

By Plaskett International

UNDERSTANDING THE IMPORTANCE OF NUTRITION IS REAL AND PRESSING. LEARN HOW TO MAKE A BIG DIFFERENCE IN YOUR LIFE NOW. A MESSAGE FROM THE AUTHOR This course is a must for anyone who is passionate about health & well-being whether in relation to themselves and their loved ones, or in the workplace whereby an understanding of nutrition will enhance the service you provide . It will teach you basic nutritional principles and help you to formulate healthy diets and set out well-informed programmes for yourself and for your family when faced with the bewildering array of nutritional supplements on the shelves today. The hope is expressed that this course will lead you to feeling more informed, on a deeper naturopathic level, and provide you with a range of measures that you can apply towards better health. DR. LAWRENCE PLASKETT Course Duration 6 months Study Hours 50 hours Course Content 12 sections Course Fee £125 Course Overview The Plaskett certificate in Nutrition & Health is designed for individuals who are passionate about health & wellbeing, whether on an informal basis whereby it will enable you to work out sound nutritional regimes for yourself or for members of your family, or on a professional basis whereby nutrition is a feature of your line of work and a better understanding of the subject will only enhance the service that you provide.  In studying this course, you will: Be introduced to the concept of naturopathy Gain a general understanding of the subject of health and nutrition Grasp the fundamentals of the cell's need for nutrients Appreciate the role of carbohydrates, fats, proteins, vitamins and minerals and understand the basics of how these nutrients work in the body Be aware of the enormous health benefits that can come from favourable dietary change Appreciate the merits of particular foods and nutrients Ultimately gain the knowledge that will lead towards a better standard of well-being now, and a prolonging of good health in the future Although this is not a practitioner level course, it will benefit any health care professional who wants to expand her/his knowledge of nutrition and health. Whether you work in mainstream medicine or in one of the alternative disciplines, the course can inform aspects of your main practice or enable you to provide simple nutritional programmes for your clients. It is especially useful if you are working in: voluntary health care or employment in health and fitness, weight control, catering, the health food market or the nutrition business, or even in the media reporting upon nutritional subjects. the NHS in contact with patients. alternative and complementary medicine such as an osteopath, chiropractor, acupuncturist, homoeopath, herbalist, reflexologist, aromatherapist etc and wanting a better general understanding of nutrition to supplement your professional base. contemplating moving into alternative and complementary medicine in the future. BREAKDOWN OF THE COURSE SECTIONS The Nutrition & Health Certificate includes the following 12 sections: SECTION 1 THE PRINCIPLE BULK NUTRIENTS & ASSOCIATED FOODS In Section 1, we begin the study of nutrients and foods by looking at the main bulk nutrients that our diets contain: protein, carbohydrate and fat. Before one can consider individual vitamins and minerals, one has to know about the nutrients that make up most of our diets, namely the bulk nutrients. These are the suppliers of food energy, essential amino acids and fatty acids. You will need to understand these so as to manipulate them with skill. Areas Covered Proteins The carbohydrates Fibre Fats Classes of foods based upon composition SECTION 2 THE CELL & CELL ENERGY This section will illuminate the nature of the cell and explain how the energy of the cell is generated and what functions the cell must perform using that energy. It explains calories as units of energy measurement and the dynamic role of the enzymes in the cells. Areas Covered The cell Cell energy The energy content of food What else does the body have to do with its energy? How does the body release energy from food? Enzymes The overwhelming importance of cell energy The vitality of cells and tissues The key role of blood glucose What key factors are most likely to erode good vitality? Go-factors for enzymes Internal cell environment Enzyme poisons SECTION 3 THE ENVIRONMENT INSIDE THE CELL This section explains the importance of the controlled environment inside the cell. It particularly stresses how important it is to maintain the balance between sodium and potassium and between calcium and magnesium. Areas covered Out of balance intakes of sodium and potassium Calcium and magnesium balance Calcium mishandling SECTION 4 THE NEED FOR THE CELL TO SELF CLEANSE This section shows you how the cell needs to remain vital and active and to maintain the integrity of its energy systems and enzymes. It stresses the cell's need to excrete waste and toxic materials and to actively cleanse. This approach is both naturopathic and science-based. Areas covered Naturopathic elimination The concept of self-cleansing Naturopathy Vitality Chronic and acute Suppression SECTION 5 THE MICRO-MINERALS & THEIR CONTRIBUTION TO THE CELL This section emphasises and explains the importance of micro-minerals. It shows them in their role as enzyme activators and how they contribute in this way to cell energy and to maintaining the cell's integrity and function. It explains the key roles and characteristics of individual micro-minerals. Areas covered How metals act as enzyme activators Iron Zinc Manganese Copper Chromium Selenium Molybdenum General supplementation policy on trace metals Non-metallic micro-minerals Toxic metals Notes on metallic macro-minerals SECTION 6 THE VITAMINS This section covers the entire group of vitamins. It shows how they activate enzymes, contribute to cell energy and increase vitality. It explains their differing functions and characteristics. Areas covered Vitamins defined Intakes and rnis for vitamins How vitamins work The vitamins Non-vitamin nutrients How vitamins contribute to cell energy and increase the life force Food sources of the vitamins SECTION 7 BOWEL FLORA – HOW IT AIDS CLEANSING & MAINTENANCE OF A GOOD BODY ENVIRONMENT This section explains how the complex population of bacteria in the intestines contribute to maintaining vitality and health. In particular, it will become clear how these bacteria aid cleansing and the maintenance of a good environment within the body, which is so essential to good health. It includes how to nurture your own bowel flora organisms. Areas covered The bacteria of the large intestine (the bowel) The alternative view of desirable and undesirable bowel flora The benefits from an acidic lower bowel The effect of bowel flora upon cleansing Association of lactobacillus with milk Synthesis and absorption of b vitamins The reciprocal effects of bowel flora The bowel flora from infancy to adulthood Candida albicans How to maintain the bowel flora The use of bowel flora products SECTION 8 CHARACTERISTICS OF THE MAIN FOODS. SUPPRESSIVE VERSUS ELIMINATIVE FOODS This section identifies the 'suppressive' foods - those which block the body's elimination of toxins. It separates them from the 'eliminative' foods - those which enable or enhance the voiding of toxins. It gives the characteristics (in this respect) of the main food groups. It will tell you what problem foods to avoid and identify the acid-producing foods. Areas Covered Milk as a problem food Wheat and rye as problem foods Vegetables Relation of elimination to acidity The two-step process of elimination The neutral grains Salt Sugar SECTION 9 THE COMPOSITION OF FOODS This section provides a great deal of data on the composition of foods, their content and the main differences between them. This is a working mass of data to enable your own design of health-giving diets. Areas Covered Commentary on food tables The spread of bulk nutrients The spread of mineral nutrients SECTION 10 ALLERGIES, INTOLERANCE & SENSITIVITY. MICRO-MINERALS & THEIR CONTRIBUTION TO THE CELL This section is an introduction to allergies or intolerances - what they are; physical signs and symptoms, the most frequent; masked/hidden and/or addictive allergies; causes of allergy - food, chemical, emotional and mental; stages of allergy; different types of allergy - fixed, variable, cyclic; managing allergies and sensitivities - how to handle them; rotation diets (including the rotation chart); allergy testing and its limitations; food additives and chemicals; the role of nutrition in all this. Areas Covered Allergic reactions defined The nature of allergies and the effect they have Obvious reactions The four main classes of allergy The possible underlying causes of allergy Viewing allergy tests and their limitations What help is available to deal with allergies The key role of nutrition in the underlying case and treatment of allergy How allergies interfere with treatment The concept of neutralisation The allopathic or orthodox drug approach SECTION 11 DESIGNING DIETS This section provides clear guidance on designing maintenance nutritional diets that, compared to most ordinary diets, should improve health. Areas Covered Dietary paragraphs Using the dietary paragraphs to make up diets SECTION 12 THE USE OF SUPPLEMENTS This section explains and demystifies the subject of vitamin and mineral supplements and their use. It enables you to design simple maintenance and health-giving programmes of supplementation. Areas Covered General guidelines in the use of supplements Always attend to the diet first Preparing for mineral and vitamin supplementation Steps in supplement intake Simple and effective combinations The eliminative qualities of magnesium and calcium Less frequently used combinations Use of multiple formulations Adding in the trace elements as a further stimulant of toxin elimination & for correction of deficiencies On to the next stage – zinc and manganese Conditions where practitioners of nutritional medicine might use such formulae Vitamins a & d Vitamins c & e Choline & inositol Calcium pantothenate The role of the practitioner of nutritional medicine TESTIMONIALS Here's what students have to say about the course Julie A, Podiatrist South Africa Thank you for a very comprehensive overview course on the fundamentals of health and personal wellness. While I am already in the Health industry in another field, I found this course added a more in-depth perspective to health from a cellular point of view and clearly linked the importance of nutrition and the incidence of chronic disease. I also found the on- line accessibility user friendly. Emma Rubio, Health Coach Spain I studied the Health and Nutrition certificate first with the Plaskett College to see if what it was taught matched my believes. At the end of that certificate I decided to pursue my studies with Plaskett college to become a Nutritional therapist. For that, I am studying Nutritional medicine and Iridology. During the Health & Nutrition certificate I learnt already about supplements. Now I know which type is best and most absorbable by our body, and the combinations to keep minerals in balance. Thus, I am more confident when I choose supplements for me and my family. I liked that the founder Dr. Plaskett was a doctor in Biochemistry. My background is in science and I wanted to study both the biochemical and the holistic sides of nutrition. I am happy to have a mentor to answer my doubts, and get my assignments reviewed. I like the flexibility they gave me to complete my first certificate. I love the subjects and the way is explained. Catherine Rogers Henley-On-Thames, UK I have found this course extremely enjoyable, user friendly and insightful. The information covered throughout the course was up to date and provided a holistic approach, educating students on nutrition at multiple levels. I found the content of the course easy to read and understand but also challenging when it needed to be. For someone with no prior knowledge of nutrition it was perfect yet was still applicable to student who had prior knowledge on the subjects covered. The course started with the basics to improve your base level understanding and built up the course week by week. Material was extremely user friendly. Materials could be studied through the course book provided or downloaded which was extremely useful for traveling! The tutors provided fantastic feedback. They explained when I got things wrong and were always happy to help. Their contact time was great too. I have thoroughly enjoyed this course on so many levels and I would recommend it to

Nutrition & Health Certificate
Delivered OnlineFlexible Dates
£125

AutoCAD 3D Basics-Advanced Training

By London Design Training Courses

Why Learn AutoCAD 3D Basics-Advanced Training Course? Course Link Learn 3D modeling, materials, lighting, and rendering, and parametric models. Learn real-world Architecture, products, mechanics. Enroll for in-person or online sessions to master AutoCAD 3D. Duration: 16 hrs Method: 1-on-1 Schedule: Tailor your own schedule by pre-booking a convenient hour of your choice, available from Mon to Sat between 9 am and 7 pm. "Dial 02077202581 or WhatsApp 07970325184 to reserve your preferred dates and times.  AutoCAD 3D Basics-Advanced Level 1-2-1 Training Course: Comprehensive coverage from basics to advanced techniques. Suitable for beginners and those advancing their 3D modeling skills. Personalized attention in a private learning environment. Experienced instructors with expertise in 3D modeling. Hands-on practice for confident 3D modeling. Flexible scheduling and lifetime email support. Certificate upon course completion for career advancement AutoCAD 3D Basics-Advanced Level 1-2-1 Training Course: Comprehensive coverage from basics to advanced techniques. Suitable for beginners and those advancing their 3D modeling skills. Personalized attention in a private learning environment. Experienced instructors with expertise in 3D modeling. Hands-on practice for confident 3D modeling. Flexible scheduling and lifetime email support. Certificate upon course completion for career advancement AutoCAD 3D Basics to Advanced Level Training Course Outline (10 hours): Session 1: Introduction to 3D Modeling (2 hours) Understanding 3D modeling concepts Working in the 3D Modeling Workspace Drawing 3D objects with Solid tools Extruding 2D polylines to create 3D objects Session 2: Advanced 3D Features and UCS (2 hours) Setting up AutoCAD for advanced 3D modeling Mastering the User Coordinate System (UCS) Using viewports to aid in 3D drawing Efficient modeling with Array tools Session 3: Rendering and Visualization (2 hours) Testing rendering techniques Creating a quick study rendering Simulating natural lighting and the sun Enhancing 3D models with materials and lights Session 4: Editing 3D Solids and Mesh Modeling (2 hours) Understanding solid modeling principles Creating and editing basic solid forms Editing 3D solids and streamlining 2D drawing process Exploring 3D mesh modeling and editing The AutoCAD 3D training course provides a comprehensive understanding of 3D modeling, visualization, and rendering. Participants will learn to create complex 3D models, render realistic visuals, and efficiently customize the AutoCAD interface for improved productivity. Master 3D Modeling: From basics to advanced techniques. Realistic Rendering: Achieve lifelike visualizations. Professional Presentations: Dynamic walkthroughs and showcases. Enhanced Career Opportunities: Stronger prospects in design fields. Personalized Learning: One-to-one attention for focused training. Practical Hands-On Practice: Building confidence in 3D modeling. Lifetime Email Support: Ongoing assistance beyond the course. Certification: Proof of proficiency in AutoCAD 3D modeling.

AutoCAD 3D Basics-Advanced Training
Delivered in London or OnlineFlexible Dates
£580

Revit Structure Training - 15 Hours - Basic to Intermediate

By FirstScale Revit Consultant and Training

The Revit Structure Training is for 15 hours, £525, and it will cover from Introduction to Intermediate in small classes with only 1 people per class.

Revit Structure Training - 15 Hours - Basic to Intermediate
Delivered OnlineFlexible Dates
£525

Microsoft Excel Advanced

By Microsoft Office Training

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 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 classrom, 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. 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

Microsoft Excel Advanced
Delivered OnlineFlexible Dates
£550

IELTS Prep Courses

5.0(7)

By Virtual Educators Ltd.

https://www.facebook.com/virtualeducators.co.uk/ https://www.instagram.com/virtualeducators.co.uk https://www.linkedin.com/groups/8980893/ https://www.tiktok.com/@virtualeducatorsltd https://www.tiktok.com/@virtualeducatorsltd https://www.youtube.com/@virtualeducatorsltd6561

IELTS Prep Courses
Delivered OnlineFlexible Dates
£40

Microsoft Excel Macros & VBA - Online classroom

By Microsoft Office Training

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

Microsoft Excel Macros & VBA - Online  classroom
Delivered OnlineFlexible Dates
£550