Following on from the Macros course look at how you can write your own Visual Basic code within Excel to fully automate tasks and save time. Course overview Duration: 2 days (13 hours) Our VBA in Excel course is an introduction to using the Visual Basic for Applications language for programming in Excel. It looks at structures, syntax and coding standards. This course is designed for existing experienced users of Excel who can record and run macros and those who have dabbled in VBA but would like some formal training and help to put some structure to their code. Objectives By the end of the course you will be able to: Write visual basic procedures Create event and general procedures Use commands from the Excel data model Use statements and functions Use a selection of debugging tools Create and use variables and constants Use different types of loops Create an Excel user form Content The VBA environment Project explorer Excel objects Modules Properties window Code window Code structure Code structure Navigating within your code Adding comments Using WITH Steps to creating a VBA procedure Procedures Sub procedures Event procedures Calling procedures The Excel data model Workbook commands Worksheet commands Excel selection methods Data manipulation commands Debugging Using breakpoints Stepping through code The immediate window The watch window The locals window points Variables and Constants Declaring variables Declaring multiple variables Variable data types Concatenation Scope of variables Constants Declaring constants Using constants Scope of constants Looping Do while loops Do until loops For next loops Conditional Statements IF statement SELECT CASE statement Comparison statements Logical operators Creating a User Form Form layout The control toolbox Naming conventions Adding objects Naming objects Captions Displaying the form Object properties Object properties Setting properties at design time Setting properties at run time Interconnectivity between the user form and Excel Comparing values Transferring information Running code
This one-day workshop will give you a solid overview of many of the key topics relating to gems and gemmology, covering scientific aspects of the subject, the journey of a gemstone and the practical side of gem properties and identification. You will learn to use some of the main gemmologist’s tools and have a chance to examine a wide range of gemstones. A gemstone reference book RRP £10 will be included in the price WHEN: Sunday 29th September 10 – 4.30pm WHERE: Workshop 925 based at The Mayford Centre, just outside of Woking and very close to Guildford. Unit F9 The Mayford Centre, Mayford Green Woking, Surrey GU22 0PP TUTOR: Stuart Pool from Nineteen 48 WHAT DOES THE DAY INVOLVE? This one-day workshop will give you a solid overview of many of the key topics relating to gems and gemmology, covering scientific aspects of the subject, the journey of a gemstone and the practical side of gem properties and identification. You will learn to use some of the main gemmologist’s tools and have a chance to examine a wide range of gemstones. The main areas covered are: – General Introduction – The World of Gemstones – Properties & Identification – Grading & Buying This course is suitable for complete beginners to the subject and will also interest those with some previous knowledge, such as jewellery makers who want to learn more about the materials they use. Students need only bring their energy and enthusiasm, plus something for making notes. Everything else will be provided. The main areas covered are: How gemmology covers different scientific disciplines Gem basics Definition of a gemstone Inorganic / organic material Gemstone formation Physical and optical properties (overview) Responsible sourcing Environmental concerns Traceability Disclosure Diamond producers Diamond mining Sources of coloured gemstones Coloured stone mining Mining in Sri Lanka – history, process, structure, tradition, etc. Gem identification Gemstone properties – rough and faceted Inclusions – various examples of typical inclusions Tools & instruments – descriptions and usage Practical tasks for gem identification Gem grading and valuation – The factors that affect price – Diamonds – Coloured gemstones – Buying tips A gemstone reference book RRP £10 will be included in the price WHAT TO BRING: Bring along a note book. We will provide light refreshments, however you might want to bring some lunch. We have a fridge, microwave and kettle in the workshop. PAYMENT OPTIONS: You can pay via our website or in our workshop in person using our card machine. If you prefer to pay directly, you can email us on hello@workshop925.com and we can invoice you manually to arrange a bank transfer. For classes over £80, instalment options are also available. Please email us on hello@workshop925.com to arrange. Gift Voucher – if you have a voucher to redeem, please email us before booking on hello@workshop925.com Please check your dates carefully before booking a class as we are unable to offer refunds. See our Terms & Conditions for full details.
Blacksmith lessons, Learn to forge or just have a go for a bit of fun in this relaxed class which is open to all.
This is a 12 month course, that covers all the basics you need to know about witchcraft! Debunking the silly myths that surround us, and giving you the information and confidence to start your witchcraft path!
Mindfulness is a practical technique for developing a greater sense of awareness and focus on the present moment. It is the opposite of mindlessness, meaning that actions and reactions become conscious and deliberate. It is an extremely useful tool for any busy work environment. Currently being used by the likes of Google and Pepsi, mindfulness can be adopted within the workplace to reduce stress and anxiety, provide greater focus and clarity, improve leadership capabilities and enhance the general wellbeing of staff at all levels. This workshop has been developed for forward-thinking organisations wanting to make a real and sustainable commitment to improving workplace wellbeing and productivity. This workshop will help you to understand the basic principles and benefits of mindfulness, and how it can be used in the workplace setting. It will also enable you to develop techniques to alleviate overwhelming feelings of stress or anxiety, prepare for important or challenging meetings, and generally achieve a greater sense of focus, clarity and calm whilst dealing with a hectic schedule.
Who is this for? Essential Adobe InDesign Training Course. Acquire Adobe InDesign basics from certified instructors. Master layout design, typography, and core design concepts. Opt for in-person or live online sessions. Receive a Certificate of Completion and lifelong email assistance. Lean desktop publishing skills and quality layouts. Click here for more info: Website Duration: 5 hours Approach: Individualized 1-on-1 training with customized content. Schedule: Flexible sessions, available Monday to Saturday from 9 am to 7 pm. Course Outline: Module 1: Introduction to Adobe InDesign (1 hour) Familiarize with workspace and tools Create new documents with appropriate page size and margins Effectively format text and images Customize the interface for efficient workflow Module 2: Text Formatting and Styles (1 hour) Apply consistent character and paragraph styles Manage text flow using frames Organize lists with bullets and numbering Master special characters for precise typography Module 3: Working with Images (1 hour) Import and position images in documents Adjust image size and alignment within frames Create professional layouts with text wrapping around images Enhance visuals with image frames and effects Module 4: Layout Design (1 hour) Create precise grids and guides for alignment Arrange objects for balanced layouts Streamline work with layers Maintain consistency using master pages and templates Module 5: Printing and Exporting (1 hour) Understand color modes and print principles Export to PDF and other formats for diverse outputs Ensure print readiness through preflighting Efficiently archive and manage InDesign files Through practical exercises, solidify your grasp of each module, enabling you to design visually appealing layouts, craft documents for various purposes, and manage InDesign projects adeptly. Adobe InDesign's potential is vast, and this fundamentals course opens doors for you to explore diverse design projects. Seize this opportunity to unleash your creative prowess with InDesign! Upon completing the Adobe InDesign Fundamentals course, participants will be able to: Master InDesign Tools: Demonstrate proficiency in utilizing InDesign's essential tools, workspace, and interface for effective design workflows. Layout Design Skills: Create visually appealing layouts using grids, guides, and balanced object arrangements, ensuring professional-quality design. Text Formatting Mastery: Apply consistent character and paragraph styles, manage text flow, and enhance typography with special characters. Image Manipulation Expertise: Import, position, and enhance images within frames, integrating them seamlessly into layouts. Printing and Exporting Proficiency: Understand color modes, print principles, and export documents to various formats, ensuring print readiness and diverse output options. Efficient Project Management: Utilize layers, master pages, and templates for streamlined project organization and management in InDesign. Book Recommendations: "InDesign CC Classroom in a Book" by Kelly Kordes Anton and John Cruise: This official Adobe guide provides hands-on lessons and practical techniques for mastering InDesign's core features. "InDesign Type: Professional Typography with Adobe InDesign" by Nigel French: Explore advanced typography techniques, layout principles, and typographic finesse specific to Adobe InDesign. "Real World Adobe InDesign CC" by Olav Martin Kvern, David Blatner, and Bob Bringhurst: A comprehensive guide offering practical insights, tips, and real-world techniques for InDesign users of all levels. "The Adobe InDesign CS6 Book for Digital Photographers" by Scott Kelby: Focused on integrating photography with InDesign, this book provides valuable insights into creating visually stunning layouts with images. "InDesign Secrets" by David Blatner and Anne-Marie Concepción: This book is packed with expert tips, tricks, and techniques that can significantly enhance your efficiency and creativity in InDesign. 1-on-1 InDesign Courses: Personalized Learning: Tailored 1-on-1 courses designed to meet your specific learning needs and goals. Expert Instructors: Learn from industry professionals with extensive experience in animation and design. Flexible Scheduling: Schedule sessions at your convenience, allowing you to balance learning with your busy lifestyle. Comprehensive Curriculum: Dive deep into animation techniques, software mastery, and creative skills through our comprehensive courses. Hands-On Training: Get practical, hands-on experience with real-world animation projects, enhancing your skills effectively. Individual Attention: Benefit from personalized attention and detailed feedback from instructors, ensuring your progress and understanding. Professional Development: Acquire skills relevant to the industry, empowering you for career advancement in animation and related fields. Portfolio Enhancement: Develop a strong portfolio with the guidance of experts, showcasing your newfound skills and creativity. Post-Course Support: Enjoy continued support even after the course completion, ensuring you have resources for ongoing learning and growth. Certification: Receive a certificate upon course completion, validating your expertise and enhancing your professional credentials. Course Highlights: Master Adobe InDesign's key features for layout, text, images, and graphics. Learn design principles and typography techniques for visually appealing documents. Efficiently handle multi-page projects like magazines and brochures. Utilize styles, templates, and libraries for streamlined design and consistency. Explore advanced techniques for interactive PDFs and digital publishing. Earn a Certificate of Completion for your Adobe InDesign proficiency. Flexible learning options: in-person or live online sessions. Lifetime email support for ongoing assistance after the course. Adobe InDesign Learn & Support https://helpx.adobe.com ⺠support ⺠indesign Get started with Adobe InDesign. Find tutorials, the user guide, answers to common questions, and help from the community forum.
The main subject areas of the course are: Setting up of microscopes. Filter preparation, fibre counting and outline of air sampling equipment. Calculation of results, quality control, reporting and communication.