Expand your VBA knowledge further and learn some of the more advanced coding features. Course overview Duration: 2 days (13 hours) This course is aimed at experienced VBA users or those who have attended our Part 1 course and have started to use the language. Part 2 expands on the huge array of commands and elements of the data model that can be used and looks at building more complex VBA models Objectives By the end of the course you will be able to: Use comparison operators and system functions Use Arrays Work with ranges Work with the worksheets and workbooks collections and objects Use application objects Use the FileSystemObject Create function procedures Import and save text files Connect to other applications Content Comparison operators Using Comparison operators and functions The LIKE function Wildcards Using SELECT Case System functions The VAL function Case functions Trim functions Text functions Date functions Excel worksheet functions Using Excel functions in VBA Arrays Creating arrays Using arrays Ubound and Lbound Single and multi dimensional arrays Static vs dynamic arrays Working with ranges Creating range objects Passing data between range objects and arrays Using Transpose The Excel object model The object browser Working with collections Collections Creating object variables Setting object variables The For Each . . . Next Loo Sheet collections The worksheets collection The worksheet object The sheets collection Using object Grouping worksheets Using Typename The Workbook collection The workbooks collection Setting workbook variables Application objects Excel default information Display/alerts Screen updating Status bar On Time Using Wait Systems dialog boxes Showing dialog boxes Using dialog boxes Working with files Searching for files and folders The DIR function The FileSystemObject Function procedures Creating functions Adding arguments Calling functions Working with text files Searching for files and folders The DIR function The FileSystemObject Using the FILE and FOLDER collections Sharing data with other applications Early vs Late Binding Setting references to other applications Creating application variables Setting application variables
Overview Uplift Your Career & Skill Up to Your Dream Job - Learning Simplified From Home! Kickstart your career & boost your employability by helping you discover your skills, talents and interests with our special isiXhosa for Beginners - South African Language Course. You'll create a pathway to your ideal job as this course is designed to uplift your career in the relevant industry. It provides professional training that employers are looking for in today's workplaces. The isiXhosa for Beginners - South African Language Course is one of the most prestigious training offered at StudyHub and is highly valued by employers for good reason. This isiXhosa for Beginners - South African Language Course has been designed by industry experts to provide our learners with the best learning experience possible to increase their understanding of their chosen field. This isiXhosa for Beginners - South African Language Course, like every one of Study Hub's courses, is meticulously developed and well researched. Every one of the topics is divided into elementary modules, allowing our students to grasp each lesson quickly. At StudyHub, we don't just offer courses; we also provide a valuable teaching process. When you buy a course from StudyHub, you get unlimited Lifetime access with 24/7 dedicated tutor support. Why buy this isiXhosa for Beginners - South African Language? 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 isiXhosa for Beginners - South African Language 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 course for? This isiXhosa for Beginners - South African Language course is ideal for Students Recent graduates Job Seekers Anyone interested in this topic People already working in the relevant fields and want to polish their knowledge and skill. Prerequisites This isiXhosa for Beginners - South African Language does not require you to have any prior qualifications or experience. You can just enrol and start learning.This isiXhosa for Beginners - South African Language 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 As this course comes with multiple courses included as bonus, you will be able to pursue multiple occupations. This isiXhosa for Beginners - South African Language is a great way for you to gain multiple skills from the comfort of your home. Course Curriculum Section 01: Introduction Introduction 00:08:00 IsiXhosa Personal Pronouns 00:04:00 Section 02: The isiXhosa Noun and Its Functions The Noun as subject of the sentence -1 00:08:00 The Noun as subject of the sentence -2 00:11:00 The Noun as object of the sentence 00:12:00 The Personal pronoun as object of the sentence 00:03:00 The Locative - stating place where 00:08:00 Stating exact whereabouts 00:04:00 Stating presence or absence 00:07:00 Forming diminutivesq 00:03:00 Identifying people and objects 00:09:00 Expressing Possession 00:09:00 Vowel merging 00:05:00 The Instrumental 00:06:00 Section 03: The isiXhosa Pronouns The Absolute Pronoun expressing 'it' 00:07:00 The Emphatic Pronoun expressing superlatives 00:10:00 The Demonstrative Pronoun expressing 'this, that,' etc 00:09:00 The Locative Demonstrative pronoun expressing position 00:05:00 The Quantitative Pronoun expressing 'all' every', etc 00:04:00 The Quantitative Pronoun, (contd) 00:11:00 The Possessive Pronoun 00:09:00 Section 04: isiXhosa Adjectives Introduction to isiXhosa adjectives - The small group of adj stems 00:07:00 The negative of the small group of adjective stems 00:07:00 Intro to the large group of adjective stems 00:07:00 The large group (contd) positive and negative forms 00:08:00 Section 05: The Verb in isiXhosa The Command form of the verb 00:05:00 Including the Object Link in the command 00:04:00 The Present Tense positive 00:04:00 The Present Tense negative 00:05:00 The Future Tense Positive 00:03:00 The Future Tense Negative 00:04:00 The Past Tenses: The Recent Past Positive 00:07:00 The Past Tenses: The Recent Past Negative 00:05:00 The Past Tenses: The Remote Past Positive 00:05:00 The Remote Past Negative 00:04:00 Extending the verb with suffixes (contd) 00:06:00 Extending the verb with suffixes (contd) 00:06:00 The Passive Verb Extension 00:10:00 Extending the verb with infixes 00:03:00 The Past Continuous Tenses 00:04:00 Updating the links and further uses of the Past Continuous 00:05:00 The Subjunctive - Verb ending on -e 00:09:00 The Subjunctive, summarised 00:05:00 The Verbal Relative - Describing the action 00:06:00 The indirect Relative - The object and the verb 00:07:00 The Potential - Events that could take place 00:03:00 Section 06: The Adverb The Adverb in isiXhosa 00:04:00 Section 07: The Ideophone in isiXhosa The Ideophone in isiXhosa 00:04:00 Assignment Assignment - isiXhosa for Beginners - South African Language 00:00:00
Course Objectives At the end of this course you will be able to: Identify the components of the PowerPoint interface Create slides Format text on slides Add and modify graphical objects to a presentation Work with tables in a presentation Add charts to a presentation Prepare the SlideShow '1 year email support service Take a look at the consistent excellent feedback from our corporate clients visiting our site ms-officetraining co uk Customer Feedback Very patient Trainer. Happy to adapt course + help with problems on existing presentations. Andrea Lethbridge - CNN ' 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. Getting Started with PowerPoint Identify the Components of the PowerPoint Interface Create a PowerPoint Presentation Accessing Help Choose the right view for the task in PowerPoint Normal view Slide Sorter view Notes Page view Outline view Add, rearrange, and delete slides in PowerPoint Working with Themes Add colour and design to my slides with themes Remove the current slide design (theme) Slide Layout What is a slide layout? Apply or change a slide layout Working with text Add text to a slide Create a new text box Format text Tables Add a table to a slide Format a Table Copy and paste a table from Word Insert an Excel spreadsheet within PowerPoint Edit Cells, Rows and Columns Delete a table Graphics Working with Clipart, and Shapes Selecting objects, shapes, pictures or text boxes Arrange a picture, shape or other object Adding Charts to Your Presentation Create a Chart Format a Chart Insert a Chart from Microsoft Excel Inserting date and slide numbers Add slide numbers to your presentation Hide slide numbers on the title slide Change where the page numbers appear on your slides Start your slide numbering with a specific number Print slides, notes, or handouts Create the Slide Show Record your slide show Preview the recorded slide show Turn slide timings off Set the slide timings manually Add or remove transitions between slides Add Animations to Text and Objects Deliver the Presentation Speakers notes Add speaker notes to your slides View your speaker notes as you deliver your slide show Who is this course for? Who is this course for? This course is designed for end users who are interested in learning the fundamentals needed to create and modify engaging presentations. Requirements Requirements General knowledge of the Windows OS Career path Career path Microsoft Office 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
Duration 5 Days 30 CPD hours This course is intended for Storage and virtual infrastructure consultants, solution architects, and administrators who are responsible for production support and administration of VMware vSAN. Overview By the end of the course, you should be able to meet the following objectives: Describe vSAN concepts Detail the underlying vSAN architecture and components Explain the key features and use cases for vSAN Identify requirements and planning considerations for vSAN clusters Explain the importance vSAN node hardware compatibility Describe the use of VMware vSphere Lifecycle Manager⢠to automate driver and firmware installations Describe the different vSAN deployment options Explain how to configure vSAN fault domains Detail how to define and create a VM storage policy Discuss the impact of vSAN storage policy changes Detail vSAN resilience and data availability Describe vSAN storage space efficiency Explain how vSAN encryption works Identify requirements to configure the vSAN iSCSI target Detail VMware HCI Mesh⢠technology and architecture Detail vSAN File Service architecture and configuration Explain the use cases of vSAN Direct Configuration⢠Describe how to setup a stretched and a two-node vSAN cluster Discuss vSAN cluster backup methodology Describe vSAN maintenance mode and data evacuation options Define the steps to shut down a vSAN cluster for maintenance Explain how to use proactive tests to check the integrity of a vSAN cluster Use VMware Skyline Health⢠for monitoring vSAN health During this five-day course, you will gain the knowledge, skills, and tools to plan and deploy a VMware vSAN? cluster. You will learn about managing and operating vSAN. This course focuses on building the required skills for common Day-2 vSAN administrator tasks such as vSAN node management, cluster maintenance, security operations, and advanced vSAN cluster operations. You will learn these skills through the completion of instructor-led activities and hands-on lab exercises. Course Introduction Introductions and course logistics Course objectives Introduction to vSAN Describe vSAN architecture Describe the vSAN software components: CLOM, DOM, LSOM, CMMDS, and RDT Identify vSAN objects and components Describe the advantages of object-based storage Describe the difference between All-Flash and Hybrid vSAN architecture Explain the key features and use cases for vSAN Discuss the vSAN integration and compatibility with other VMware technologies Planning a vSAN Cluster Identify requirements and planning considerations for vSAN clusters Apply vSAN cluster planning and deployment best practices Determine and plan for storage consumption by data growth and failure tolerance Design vSAN hosts for operational needs Identify vSAN networking features and requirements Describe ways of controlling traffic in a vSAN environment Recognize best practices for vSAN network configurations Deploying a vSAN Cluster Recognize the importance of hardware compatibility Ensure the compatibility of driver and firmware versioning Use tools to automate driver validation and installation Apply host hardware settings for optimum performance Use vSphere Lifecycle Manager to perform upgrades Deploy and configure a vSAN Cluster using the Cluster QuickStart wizard Manually configure a vSAN Cluster using VMware vSphere© Client? Explain and configure vSAN fault domains Using VMware vSphere© High Availability with vSAN Understand vSAN Cluster maintenance capabilities Describe the difference between implicit and explicit fault domains Create explicit fault domains vSAN Storage Policies Describe a vSAN object Describe how objects are split into components Explain the purpose of witness components Explain how vSAN stores large objects View object and component placement on the vSAN datastore Explain how storage policies work with vSAN Define and create a virtual machine storage policy Apply and modify virtual machine storage policies Change virtual machine storage policies dynamically Identify virtual machine storage policy compliance status vSAN Resilience and Data Availability Describe and configure the Object Repair Timer advanced option Plan disk replacement in a vSAN cluster Plan maintenance tasks to avoid vSAN object failures Recognize the importance of managing snapshot utilization in a vSAN cluster Configuring vSAN Storage Space Efficiency Discuss deduplication and compression techniques Understand deduplication and compression overhead Discuss compression only mode Configure erasure coding Configure swap object thin provisioning Discuss reclaiming storage space with SCSI UNMAP Configure TRIM/UNMAP vSAN Security Operations Identify differences between VM encryption and vSAN encryption Perform ongoing operations to maintain data security Describe the workflow of data-in transit encryption Identify the steps involved in replacing Key Management Server Introduction to Advanced vSAN Configurations Identify requirements to configure vSAN iSCSI target Detail VMware HCI Mesh technology and architecture Detail vSAN File Service architecture and configuration Explain the use cases of vSAN Direct Configuration vSAN Cluster Maintenance Perform typical vSAN maintenance operations Describe vSAN maintenance modes and data evacuation options Assess the impact on cluster objects of entering maintenance mode Determine the specific data actions required after exiting maintenance mode Define the steps to shut down and reboot hosts and vSAN clusters Use best practices for boot devices Replace vSAN nodes vSAN Stretched and Two Node Clusters Describe the architecture and uses case for stretched clusters Detail the deployment and replacement of a vSAN witness node Describe the architecture and uses case for two-node clusters Explain the benefits of vSphere HA and vSphere Site Recovery Manager in a vSAN stretched cluster Explain storage policies for vSAN stretched cluster vSAN Cluster Monitoring Describe how the Customer Experience Improvement Program (CEIP) enables VMware to improve products and services Use VMware Skyline Health for monitoring vSAN cluster health Manage alerts, alarms, and notifications related to vSAN in VMware vSphere© Client? Create and configure custom alarms to trigger vSAN health issues Use IOInsight metrics for monitoring vSAN performance Analyse vsantop performance metrics Use a vSAN proactive test to detect and diagnose cluster issues Additional course details:Notes Delivery by TDSynex, Exit Certified and New Horizons an VMware Authorised Training Centre (VATC) Nexus Humans VMware vSAN: Install, Configure, Manage [V7] 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 VMware vSAN: Install, Configure, Manage [V7] 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.
Duration 2 Days 12 CPD hours Whether you are already an instructional designer or just looking to get into the world of developing eLearning courses, this two-day course covers the full feature set of Articulate Storyline 360 and uses real world exercises to create projects from scratch. The course will include how to add interactivity to your slides via buttons, triggers, text entry areas, and hotspots. You'll also learn how to create quizzes, and how to publish your eLearning projects for the widest possible audience. The class will also explore Articulate Storyline's advance techniques and methods on Themes & Templates, Custom Navigation, Gamification, Advanced Quizzing, Accessibility and Reporting, and more. Exploring Articulate Storyline Explore a Finished Storyline Project Explore Slides and Panels Zoom and Magnify Explore Panels Preview the Entire Project Creating Projects Create a New Project Apply a Theme Apply a Content Master Slide Insert New Slides Create a New Content Master Slide Apply a Different Master Slide Layout to a Slide Import Content From PowerPoint Adding Content Create and Format a Text Box Work with a List Add an Image to a Slide Add a Shape to a Slide Customize a Shape Insert a Character Insert a Caption Interactivity Add Buttons to Slides Change Button States Create Layers Insert a Text Entry Field Triggers and Hotspots Delete Default Triggers Add a Trigger to a Button Hide Player Buttons Add Triggers to Layers Add a Hide Layer Trigger Add a Slide Trigger Add a Conditional Trigger Edit a Trigger Add a Hotspot and Lightbox Trigger Variables Manage a Variable Reference a Variable Create a Variable Manipulate a Variable with a Trigger Create a True/False Variable Create a Trigger to Change a True/False Variable Add a Condition to an Existing Trigger Play Audio with a Conditional Trigger Add a Condition to a Button Audio, Animation and Video Add Voiceover Audio to a Slide Change Slide Audio Edit Slide Audio Add Silence Record Voiceover Audio Control Object Timing Animate an Object Control Animation Options Insert Video Delay Object Start Times Trim Video Animate a Video Add a Slide Transition Quizzes Insert a Multiple Choice Slide Insert a Matching Drag-and-Drop Slide Insert a Freeform Drag and Drop Quiz Slide Insert a Quiz Result Slide
This course offers an immersive experience in data analysis, guiding you from initial setup with Python and Pandas, through series and DataFrame manipulation, to advanced data visualization techniques. Perfect for enhancing your data handling and analysis skills.
QLS Endorsed + CPD QS Accredited - Dual Certification | Instant Access | 24/7 Tutor Support | All-Inclusive Cost
Duration 1 Days 6 CPD hours This course is intended for Individuals who have knowledge, skills, and experience developing front-end and/or back-end JavaScript applications for the web stack. Developers who have experience designing, developing, testing, and deploying applications using an object-oriented programming language and would like to transfer those skills to building applications with JavaScript. Overview When you complete this course, you will be able to: Understand the different exam objectives and their weighting on the exam. Know which JavaScript concepts to focus on to best prepare for your exam. Study the provided repository of JavaScript sample code. Are you ready to take the next step in your career by becoming a Salesforce Certified JavaScript Developer I? By covering the details around the exam structure and objectives, this course will help hone your problem-solving skills and reinforce your knowledge of key features and concepts of the JavaScript programming language. This course includes a voucher to sit for the Salesforce JavaScript Developer I certification exam. JavaScript Basics Data Types and Variables Type Conversion (explicit and implicit) Collections Working with Strings, Numbers, and Dates Working with JSON Objects, Functions, and Classes Creating Objects Defining Functions Object Prototypes Declaring Classes Using JavaScript Modules Browser and Events Document Object Model DOM Events Browser Dev Tools Debugging and Error Handling Throwing and Catching Errors Working with the Console Asynchronous Programming Callback Functions Promises Async/Await Server Side JavaScript Node.js CLI Node.js Libraries Debugging in Node.js npm Testing Assertions Types of Testing Additional course details: Nexus Humans Salesforce Certification Preparation for Salesforce JavaScript Developer I (CRT600) 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 Salesforce Certification Preparation for Salesforce JavaScript Developer I (CRT600) 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.
Experimental knitting workshop, combining neon yarns with simple geometric designs to create a bold statement!
Experimental knitting workshop using free knitting techniques to explore colour, and dyeing your own yarns using Procion MX dyes.