4400 Courses

Just-In-Time is a critical Lean tool; in fact, it is one of the two pillars of the Toyota Production system, the other one being Jidoka. The Just-In-Time (JIT) manufacturing system is a planning system for manufacturing processes that minimizes the availability of material inventories at the manufacturing site to only what, when, and how much is strictly necessary. The Just-In-Time (JIT) system is an integrated set of activities designed to achieve high-volume production using minimal inventories; raw materials, work-in-process, ?nished goods, and other consumable goods.

Duration 4 Days 24 CPD hours This course is intended for This course is geared for experienced skilled Java developers, software developers, data scientists, machine learning experts or others who wish to transtion their coding skills to Scala, learning how to code in Scala and apply it in a practical way. This is not a basic class. Overview Working in a hands-on learning environment led by our expert instructor you'll: Get comfortable with Scala's core principles and unique features, helping you navigate the language confidently and boosting your programming skills. Discover the power of functional programming and learn techniques that will make your code more efficient,maintainable, and enjoyable to write. Become proficient in creating dynamic web applications using the Play Framework, and easily connect to databases with the user-friendly Slick library. Master concurrency programming with Akka, empowering you to build scalable and fault-tolerant applications that excel in performance. Enhance your testing skills using ScalaTest and ScalaCheck, ensuring the reliability and quality of your Scala applications, while having fun in the process. Explore the fascinating world of generative AI and GPT technologies, and learn how to integrate them into your projects,adding a touch of innovation and intelligence to your Scala solutions. If your team requires different topics, additional skills or a custom approach, our team will collaborate with you to adjust the course to focus on your specific learning objectives and goals. Discover the power of Scala programming in our comprehensive, hands-on technical training course designed specifically for experienced object-oriented (OO) developers. Scala is a versatile programming language that combines the best of both OO and functional programming paradigms, making it ideal for a wide range of projects, from web applications to big data processing and machine learning. By mastering Scala, you'll be able to develop more efficient, scalable, and maintainable applications. Fast Track to Scala Programming for OO / Java Developers is a four day hands-on course covers the core principles of Scala, functional programming, web application development, database connectivity, concurrency programming, testing, and interoperability between Scala and Java. Additionally, you'll explore cutting-edge generative AI and GPT technologies, learning how to integrate them into your Scala applications for intelligent suggestions or automation. Throughout the course you?ll explore the latest tools and best practices in the Scala ecosystem, gaining valuable knowledge and experience that can be directly applied to your day-to-day work. With 50% of the course content dedicated to hands-on labs, you'll gain practical experience applying the concepts you've learned across various projects, such as building functional web applications, connecting to databases, designing modular components, and implementing concurrency. Upon completing the course, you'll have a solid understanding of the language and its features, empowering you to confidently apply your new skills in data science and machine learning projects. You'll exit well-prepared to create efficient, scalable, and maintainable Scala applications, regardless of the complexity of your projects. Introduction to Scala Scala features and benefits Comparing Scala with Java and other OO languages Installing Scala and setting up the development environment Object-Oriented Programming in Scala Classes and objects Traits, mixins, and inheritance Companion objects and factories Encapsulation and polymorphism Functional Programming Basics Pure functions and referential transparency Higher-order functions and currying Immutability and persistent data structures Pattern matching and recursion Having Fun with Functional Data Structures Lists, sets, and maps in Scala Folding and reducing operations Stream processing and lazy evaluation For-comprehensions Building Web Applications in Functional Style Introduction to Play Framework Functional web routing and request handling JSON handling with Play-JSON Middleware and functional composition Connecting to a Database Introduction to Slick library Database configuration and setup Querying and updating with Slick Transactions and error handling Building Scalable and Extensible Components Modular architecture and design patterns Dependency injection with MacWire Type classes and type-level programming Implicit parameters and conversions Concurrency Programming & Akka Introduction to Akka framework and Actor model Actor systems and message passing Futures and Promises Supervision and fault tolerance Building Confidence with Testing Introduction to ScalaTest and ScalaCheck Unit testing and property-based testing Test-driven development in Scala Mocking and integration testing Interoperability between Scala and Java Calling Java code from Scala Using Java libraries in Scala projects Converting Java collections to Scala collections Writing Scala code that can be called from Java Using Generative AI and GPT Technologies in Scala Programming Overview of GPT and generative AI Integrating GPT with Scala applications Use cases and practical examples

Get Hard Copy + PDF Certificates + Transcript + Student ID Card worth £160 as a Gift - Enrol Now Enter the fascinating world of criminal investigation and test your deductive skills to see if they would suffice in real-life incidents. This Criminology Complete Bundle brings together three fundamental areas of Policing (Profiling, Psychology, and Forensics) and trains you in their use. Along with this Criminology course, you will get 10 additional Career development courses, an original hardcopy certificate, a transcript, and a student ID card. What other courses are included with this Criminology Complete Bundle? Course 1: Criminology Complete Bundle Course 2: Criminal Intelligence Training Course 3: Certificate in Anti-Money Laundering (AML) Course 4: Paralegal Law and Skills Course 5: Security Management Advanced Diploma Course 6: Domestic Violence and Abuse Awareness - Level 2 Course 7: Financial Investigator Course 8: Network Security Level 2 Course 9: Decision-Making Course 10: Time Management Course 11: First Aid at Work With true crimes and 'armchair detection' being a popular pastime for many people, this innovative tutorial brings together different investigative techniques and explains their importance in the modern Justice System. You will be given opportunities to test and explore the theories in interactive exercises and see if a career in more law enforcement might be in your future. Learning Outcomes of Criminology Complete Bundle By the end of the course, learners will be able to: Demonstrate a good understanding of criminology, profiling and forensics. Understand the classification of crimes and different types of crime, such as violent crimes, assault, murder, etc. Understand the basics of social psychology Understand cognitive psychology and its applications Understand the victimology and criminal justice system in England and Wales Understand the basics of crime scenes and dealing with crimes. Learn about forensic science and the phases of profiling. Understand criminal psychology and the motives behind crimes. Learn about the Psychology of Atypical (Abnormal) Behaviour Master different research methods Explore the criminal and offender profiling science and logic and much more... So enrol now in this Criminology Bundle to advance your career! Course Curriculum of Criminology Bundle Criminology Complete Bundle Perspectives in Psychology Social Psychology Cognitive Psychology and Its Applications Child Development The Psychology of Atypical (Abnormal) Behaviour Research Methods Resource Materials Criminology Domestic Violence and Criminal Intelligence The detailed curriculum of the bundle is given in the resources section. How will I get my Certificate? After successfully completing the Criminology course, you will be able to order your CPD Accredited Certificates (PDF + Hard Copy) as proof of your achievement. PDF Certificate: Free (Previously it was £6*11 = £66) Hard Copy Certificate: Free (For The Title Course: Previously it was £10) P.S. The delivery charge inside the U.K. is £3.99 and the international students have to pay £9.99. CPD 110 CPD hours / points Accredited by CPD Quality Standards Who is this course for? Anyone from any background can enrol in this Criminology bundle. Requirements This Criminology course has been designed to be fully compatible with tablets and smartphones. Career path This Criminology Bundle is ideal for anyone who has an interest in learning about Criminology and wants to make a career in the relevant fields, which includes: Detectives. Crime Journalists. Crime Reporters. Lawyers. Psychologists and Counsellors. Certificates Certificate of completion Hard copy certificate - Included Hard copy certificate You will get the Hard Copy certificate for the title course (Criminology) absolutely Free! Other Hard Copy certificates are available for £10 each. Please Note: The delivery charge inside the UK is £3.99, and the international students must pay a £9.99 shipping cost. Certificate of completion Digital certificate - Included

Introduction to Graphic Design Learning an introduction to graphic design is essential for anybody who is passionate about the vibrant world of graphic design - whether you are already in the industry or are looking to begin your journey. This course covers everything you need to know about graphic design, including a full definition, all the elements involved, as well as the skill-sets and traits required for the job. From the hardware and software tools you need, to the practical applications and career options, including freelance tips, this course covers everything you will ever need to know about graphic design. You Will Learn: A full definition and breakdown of all the elements of graphic design The traits and skill-sets you need to become a successful graphic designer All about the hardware and software requirements The different career choices and a guide to becoming a freelancer Benefits of Taking This Course: You can work towards earning a great salary while doing something you love You can enter the industry and climb the ranks You can become a successful freelancer and work for yourself You can secure all the right software and hardware, no matter what your budget is

Oil painting from a nude model.

Dive into the intricate world of vacuum packing with our comprehensive course on 'Vacuum Packing Training: Food Preservation and Safety'. Explore the foundational principles behind vacuum packing, as we unravel the art of selecting the aptest packaging materials, ensuring food remains uncontaminated, and mastering advanced vacuum packing strategies. Furthermore, you'll gain insights into the robust storage and transportation protocols for vacuum-packed food, rounded off with an astute perspective on its business applications. With our meticulously curated modules, you're set to embark on a transformative journey, ensuring the longevity and safety of food through vacuum packing. Learning Outcomes Grasp the core concepts and evolution of air-tight sealing. Distinguish and choose the optimal wrapping materials for diverse food products. Enforce rigorous food safety and cleanliness standards during the sealing process. Perfect sophisticated methods to guarantee efficient air-tight closure. Assess and plan ideal procedures for storage and transit of sealed food products. Why buy this Vacuum Packing Training: Food Preservation and Safety? Unlimited access to the course for forever Digital Certificate, Transcript, student ID all included in the price Absolutely no hidden fees Directly receive CPD accredited qualifications after course completion Receive one to one assistance on every weekday from professionals Immediately receive the PDF certificate after passing Receive the original copies of your certificate and transcript on the next working day Easily learn the skills and knowledge from the comfort of your home Certification After studying the course materials of the Vacuum Packing Training: Food Preservation and Safety there will be a written assignment test which you can take either during or at the end of the course. After successfully passing the test you will be able to claim the pdf certificate for £5.99. Original Hard Copy certificates need to be ordered at an additional cost of £9.60. Who is this Vacuum Packing Training: Food Preservation and Safety for? Chefs and restaurateurs looking to enhance food preservation methods. Food industry professionals keen on updating their preservation techniques. Entrepreneurs contemplating starting a food packaging or storage business. Individuals passionate about safe food handling and storage. Logistics and transportation professionals in the food sector. Prerequisites This Vacuum Packing Training: Food Preservation and Safety does not require you to have any prior qualifications or experience. You can just enrol and start learning.This Vacuum Packing Training: Food Preservation and Safety was made by professionals and it is compatible with all PC's, Mac's, tablets and smartphones. You will be able to access the course from anywhere at any time as long as you have a good enough internet connection. Career path Vacuum Packing Specialist: £25,000 - £35,000 per annum Food Safety Officer: £30,000 - £42,000 per annum Food Storage Manager: £28,000 - £38,000 per annum Vacuum Packing Equipment Salesperson: £22,000 - £32,000 per annum Food Quality Assurance Manager: £35,000 - £50,000 per annum Food Logistics Coordinator: £27,000 - £37,000 per annum Course Curriculum Module 01: Introduction to Vacuum Packing Introduction to Vacuum Packing 00:14:00 Module 02: Choosing the Right Packaging Materials Choosing the Right Packaging Materials 00:21:00 Module 03: Food Safety and Hygiene Food Safety and Hygiene 00:24:00 Module 04: Vacuum Packing Techniques Vacuum Packing Techniques 00:12:00 Module 05: Storage and Transportation of Vacuum-Packed Food Storage and Transportation of Vacuum-Packed Food 00:22:00 Module 06: Business Applications of Vacuum Packing Business Applications of Vacuum Packing 00:17:00

Getting Started The primary objective of the Level 4 Diploma in Psychology is to furnish learners with a specialized educational program that imparts an extensive comprehension of critical elements in Psychology. Students will gain insight into historical and modern psychology approaches, encompassing biopsychology, social and developmental psychology, attachment theories, human memory processes, and contemporary research and investigative methodologies. Key Benefits The key benefits of pursuing a Qualifi Level 4 Diploma in Psychology: Comprehensive Understanding of Social Psychology: Gain insights into methodological issues and theories in social psychology, providing a deep understanding of human interactions and behaviour. Profound Insights into Cognition and Development: Explore the main theoretical views in cognition and development, establishing a solid foundation for comprehending the complexities of the human mind. In-Depth Knowledge of the Nervous System: Understand the structure and function of the nervous system, including its specific location in the brain, shedding light on the physiological basis of behaviour and mental processes. Learning Theory of Attachment: Grasp the learning theory of attachment, illuminating the dynamics of emotional bonds and their significant influence on human development. Versatile Application: Acquire a diverse knowledge base applicable in various fields, including counselling, education, and research, enhancing your career prospects and skillset. Key Highlights Remember! The assessment for the qualification is done based on assignments only, and you do not need to worry about writing any exam. With the School of Business and Technology London, you can complete the qualification at your own pace, choosing online or blended learning from the comfort of your home. Learning and pathway materials and study guides developed by our QUALIFI-approved tutors will be available around the clock in our cutting-edge learning management system. Most importantly, at the School of Business and Technology London, we will provide comprehensive tutor support through our dedicated support desk. If you choose your course with blended learning, you will also enjoy live sessions with an assigned tutor, which you can book at your convenience. Career Pathways Achieving the QUALIFI Level 4 Diploma in Psychology allows learners to advance towards additional education or enter the workforce successfully. Psychology Assistant with an estimated average salary of £26,473 per annum Mental Health Strategist with an estimated average salary of £32,500 per annum Addiction Counselor with an estimated average salary of £37,593 per annum   About Awarding Body QUALIFI, recognised by Ofqual awarding organisation has assembled a reputation for maintaining significant skills in a wide range of job roles and industries which comprises Leadership, Hospitality & Catering, Health and Social Care, Enterprise and Management, Process Outsourcing and Public Services. They are liable for awarding organisations and thereby ensuring quality assurance in Wales and Northern Ireland. What is included? Outstanding tutor support that gives you supportive guidance all through the course accomplishment through the SBTL Support Desk Portal. Access our cutting-edge learning management platform to access vital learning resources and communicate with the support desk team. Quality learning materials such as structured lecture notes, study guides, and practical applications, which include real-world examples and case studies, will enable you to apply your knowledge. Learning materials are provided in one of the three formats: PDF, PowerPoint, or Interactive Text Content on the learning portal. The tutors will provide Formative assessment feedback to improve the learners' achievements. Assessment materials are accessible through our online learning platform. Supervision for all modules. Multiplatform accessibility through an online learning platform facilitates SBTL in providing learners with course materials directly through smartphones, laptops, tablets or desktops, allowing students to study at their convenience. Live Classes (for Blended Learning Students only) Assessment Time-constrained scenario-based assignments No examinations Entry Requirements Accessible Qualification: The qualification is designed to be accessible without unnecessary barriers, with a minimum age requirement of 18 years. Language Proficiency: Non-English-speaking applicants must provide an IELTS score of 6 (or equivalent). International Qualifications: If applicable, international qualifications will be reviewed for eligibility in UK higher education postgraduate programs. Reference Requirement: Typically, applicants need to submit two references, with at least one preferably being academic. Consideration for Experience: In some cases, individuals with substantial experience but no formal qualifications may be considered, contingent upon an interview demonstrating their ability to meet qualification demands Progression Upon completing the QUALIFI Level 4 Diploma in Psychology, learners have the opportunity to advance in the following ways: Enrol in the QUALIFI Level 5 Diploma in Psychology to further their studies. Enter into employment within a related profession. Why gain a QUALIFI Qualification? This suite of qualifications provides enormous opportunities to learners seeking career and professional development. The highlighting factor of this qualification is that: The learners attain career path support who wish to pursue their career in their denominated sectors; It helps provide a deep understanding of the health and social care sector and managing the organisations, which will, in turn, help enhance the learner's insight into their chosen sector. The qualification provides a real combination of disciplines and skills development opportunities. The Learners attain in-depth awareness concerning the organisation's functioning, aims and processes. They can also explore ways to respond positively to this challenging and complex health and social care environment. The learners will be introduced to managing the wide range of health and social care functions using theory, practice sessions and models that provide valuable knowledge. As a part of this suite of qualifications, the learners will be able to explore and attain hands-on training and experience in this field. Learners also acquire the ability to face and solve issues then and there by exposure to all the Units. The qualification will also help to Apply scientific and evaluative methods to develop those skills. Find out threats and opportunities. Develop knowledge in managerial, organisational and environmental issues. Develop and empower critical thinking and innovativeness to handle problems and difficulties. Practice judgement, own and take responsibility for decisions and actions. Develop the capacity to perceive and reflect on individual learning and improve their social and other transferable aptitudes and skills. Learners must request before enrolment to interchange unit(s) other than the preselected units shown in the SBTL website because we need to make sure the availability of learning materials for the requested unit(s). SBTL will reject an application if the learning materials for the requested interchange unit(s) are unavailable. Learners are not allowed to make any request to interchange unit(s) once enrolment is complete. To know about the Qualification Structure, please get in touch with us at: admission@sbusinesslondon.ac.uk Delivery Methods School of Business & Technology London provides various flexible delivery methods to its learners, including online learning and blended learning. Thus, learners can choose the mode of study as per their choice and convenience. The program is self-paced and accomplished through our cutting-edge Learning Management System. Learners can interact with tutors by messaging through the SBTL Support Desk Portal System to discuss the course materials, get guidance and assistance and request assessment feedbacks on assignments. We at SBTL offer outstanding support and infrastructure for both online and blended learning. We indeed pursue an innovative learning approach where traditional regular classroom-based learning is replaced by web-based learning and incredibly high support level. Learners enrolled at SBTL are allocated a dedicated tutor, whether online or blended learning, who provide learners with comprehensive guidance and support from start to finish. The significant difference between blended learning and online learning methods at SBTL is the Block Delivery of Online Live Sessions. Learners enrolled at SBTL on blended learning are offered a block delivery of online live sessions, which can be booked in advance on their convenience at additional cost. These live sessions are relevant to the learners' program of study and aim to enhance the student's comprehension of research, methodology and other essential study skills. We try to make these live sessions as communicating as possible by providing interactive activities and presentations. Resources and Support School of Business & Technology London is dedicated to offering excellent support on every step of your learning journey. School of Business & Technology London occupies a centralised tutor support desk portal. Our support team liaises with both tutors and learners to provide guidance, assessment feedback, and any other study support adequately and promptly. Once a learner raises a support request through the support desk portal (Be it for guidance, assessment feedback or any additional assistance), one of the support team members assign the relevant to request to an allocated tutor. As soon as the support receives a response from the allocated tutor, it will be made available to the learner in the portal. The support desk system is in place to assist the learners adequately and streamline all the support processes efficiently. Quality learning materials made by industry experts is a significant competitive edge of the School of Business & Technology London. Quality learning materials comprised of structured lecture notes, study guides, practical applications which includes real-world examples, and case studies that will enable you to apply your knowledge. Learning materials are provided in one of the three formats, such as PDF, PowerPoint, or Interactive Text Content on the learning portal. How does the Online Learning work at SBTL? We at SBTL follow a unique approach which differentiates us from other institutions. Indeed, we have taken distance education to a new phase where the support level is incredibly high.Now a days, convenience, flexibility and user-friendliness outweigh demands. Today, the transition from traditional classroom-based learning to online platforms is a significant result of these specifications. In this context, a crucial role played by online learning by leveraging the opportunities for convenience and easier access. It benefits the people who want to enhance their career, life and education in parallel streams. SBTL's simplified online learning facilitates an individual to progress towards the accomplishment of higher career growth without stress and dilemmas. How will you study online? With the School of Business & Technology London, you can study wherever you are. You finish your program with the utmost flexibility. You will be provided with comprehensive tutor support online through SBTL Support Desk portal. How will I get tutor support online? School of Business & Technology London occupies a centralised tutor support desk portal, through which our support team liaise with both tutors and learners to provide guidance, assessment feedback, and any other study support adequately and promptly. Once a learner raises a support request through the support desk portal (Be it for guidance, assessment feedback or any additional assistance), one of the support team members assign the relevant to request to an allocated tutor. As soon as the support receive a response from the allocated tutor, it will be made available to the learner in the portal. The support desk system is in place to assist the learners adequately and to streamline all the support process efficiently. Learners should expect to receive a response on queries like guidance and assistance within 1 - 2 working days. However, if the support request is for assessment feedback, learners will receive the reply with feedback as per the time frame outlined in the Assessment Feedback Policy.

This course aims to provide a comprehensive understanding of decision-making processes and dynamics at the managerial level. The course aims to equip learners with knowledge and skills to apply various decision-making models, including decision support systems (DSS) and system modelling, to support effective organisational decision-making. Additionally, the course will enable learners to identify and prepare for trends in decision support and business intelligence and understand how management information systems can aid in decision-making. After the successful completion of the course, you will be able to learn about the following, Understand Decision-Making dynamics and process Types of decision-making, especially at the managerial level. Understanding and applying the decision-making models, including the decision support system (DSS) and its components. Analysing the Information Requirements of Key Decision-making Groups in a Firm. Identifying and preparing for trends in Decision Support and Business Intelligence. Understanding System Modelling and its Types. Learn about how Management Information Systems help in Decision Making. This course covers the fundamentals of decision-making processes and dynamics, including the types of decision-making at the managerial level. Learners will explore various decision-making models and their applications, focusing on decision support systems (DSS) and system modelling. They will gain an understanding of the components of DSS and their role in supporting effective decision-making. This course covers the fundamentals of decision-making processes and dynamics, including the types of decision-making at the managerial level. Learners will explore various decision-making models and their applications, with a particular focus on decision support systems (DSS) and system modeling. They will gain an understanding of the components of DSS and their role in supporting effective decision-making. VIDEO - Course Structure and Assessment Guidelines Watch this video to gain further insight. Navigating the MSBM Study Portal Watch this video to gain further insight. Interacting with Lectures/Learning Components Watch this video to gain further insight. Understanding the Role of MIS in Decision Making, System Design, and Modeling Self-paced pre-recorded learning content on this topic. Understanding the Role of MIS in Decision Making and Modeling Put your knowledge to the test with this quiz. Read each question carefully and choose the response that you feel is correct. All MSBM courses are accredited by the relevant partners and awarding bodies. Please refer to MSBM accreditation in about us for more details. There are no strict entry requirements for this course. Work experience will be added advantage to understanding the content of the course. The certificate is designed to enhance the learner's knowledge in the field. This certificate is for everyone eager to know more and get updated on current ideas in their respective field. We recommend this certificate for the following audience. Managers at all levels Business analysts Decision support specialists IT professionals. Consultants & Project managers Entrepreneurs and business owners Average Completion Time 2 Weeks Accreditation 3 CPD Hours Level Advanced Start Time Anytime 100% Online Study online with ease. Unlimited Access 24/7 unlimited access with pre-recorded lectures. Low Fees Our fees are low and easy to pay online.

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

Duration 1 Days 6 CPD hours This one day course provides a comprehensive overview of macOS, complete with insider tips for getting the most out of the operating system. The course shows how to configure system preferences, navigate around the finder, personalize the interface and as well as achieve fluency with all the operational functions of the macOS. Meet The macOS The User InterfaceUser PreferencesThe Menus and Menu Paths The Toolbar Scroll Bars The Sidebar The Go Menu, Utilities Folder The Clipboard Launching Applications The Finder The Launchpad and Mission Control Finder Essentials The Desktop Quick Look Different Viewing Options Spring Loaded Folders Creating an Archive Customizing your Finder The Desktop Customize your Toolbar Organizing your Desktop Labeling your Documents and Folders Creating Folders Smart Folders The Dock Opening Applications from the Dock Dock Preferences and Customizing your Dock Choosing which Applications appear in the Dock Accessing Folder content using Stacks Your Home Folder Moving, Copying and Deleting Files Emptying the Trash Switching Between Applications Showing and Hiding Applications. Closing Documents vs. Quitting Applications Using Continuity - Mac and iOS Interfacing with your Mac and your Apple mobile devices Messages and answering your iPhone Windows Closing and Minimizing Placing documents in the Dock The Keyboard Control, Option (Alt) and Command Keys Keyboard Shortcuts The Dictation Function Gestures and Voice Mouse and Hand Gestures Using Text-to-Speech Searches Finding Files and documents Advanced Spotlight Searches Widgets & Notifications The Dashboard Enabling and Viewing Widgets Enabling and Viewing Notifications Using Spaces Switching between Spaces Running applications in full screen mode Installing or Upgrading Applications Buying from the Mac App Store Downloading from the Internet Sharing Files Sending files using AirDrop Dropbox File Synchronization Enable File Sharing Getting OnLine Understanding the Apple Airport Connecting wirelessly Using Ethernet Creating a Network Connecting through outside Network Servers and VPN Staying Current with Software Update Troubleshooting Application Crashes Force Quit Deleting Preferences The Key Chain Internet Connections Backing Up Time Machine Setting up Time Machine Performing Backups Shortcuts How to better use and access Files and documents Basic shortcuts for speed and efficiency New User Account Creating a New User Switching Between Multiple User Accounts Additional course details: Nexus Humans Getting Started With the Mac Operating System training program is a workshop that presents an invigorating mix of sessions, lessons, and masterclasses meticulously crafted to propel your learning expedition forward. This immersive bootcamp-style experience boasts interactive lectures, hands-on labs, and collaborative hackathons, all strategically designed to fortify fundamental concepts. Guided by seasoned coaches, each session offers priceless insights and practical skills crucial for honing your expertise. Whether you're stepping into the realm of professional skills or a seasoned professional, this comprehensive course ensures you're equipped with the knowledge and prowess necessary for success. While we feel this is the best course for the Getting Started With the Mac Operating System course and one of our Top 10 we encourage you to read the course outline to make sure it is the right content for you. Additionally, private sessions, closed classes or dedicated events are available both live online and at our training centres in Dublin and London, as well as at your offices anywhere in the UK, Ireland or across EMEA.