Learning Objectives Introduction , Getting Started with VBA , Working with Variables , Working with Conditional Logic , Working with Strings and String Functions , Working with Loops , Working with Sub Procedures Options and Functions , Working with User Forms , Debugging your Code , Conclusion Pre-Requisites Intermediate Microsoft Excel training or equivalent experience is recommended. Description This course will teach students proper Visual Basic programming techniques along with an understanding of Excel's object structure. Students will learn how to work with variables, how to use various conditional logic statements such as If and Else, and how to work with string functions. Students will also learn how to work with various loops such as next loops and each loops, as well as how to create user forms. Finally, students will get an in-depth understanding of the debugging tools available and how to effectively debug their code. Course Introduction Introduction 00:03:00 Section 01 Lesson 1-Adding the Developer Toolbar 00:05:00 Lesson 2-Understanding the VBA Editor 00:11:00 Lesson 3-Recording a Macro in Personal 00:10:00 Lesson 4-Understanding the Elements of the VBA Language 00:07:00 Lesson 5-Understanding Methods 00:05:00 Lesson 6-Understanding Comments 00:06:00 Lesson 7-Working with the Range Property and Worksheet Object 00:07:00 Lesson 8-Adding a Macro Button to a Spreadsheet 00:03:00 Lesson 9-Working with the ActiveCell Object 00:02:00 Lesson 10-Working with the Offset Property 00:08:00 Section 02 Lesson 1-Understanding Variables 00:07:00 Lesson 2-Working with Integer Variables 00:03:00 Lesson 3-Understanding Option Explicit 00:05:00 Lesson 4-Working with Other Variable Types 00:07:00 Section 03 Lesson 1-Working with IF Statements 00:04:00 Lesson 2-Working with ELSE 00:03:00 Lesson 3-Working with ELSEIF 00:03:00 Lesson 4-Understanding Conditional Operators 00:06:00 Lesson 5-Working with NOT, AND, and OR 00:07:00 Lesson 6-Working with Nested IF 00:04:00 Lesson 7-Working with Select Case 00:06:00 Lesson 8-Working with WITH and END WITH 00:05:00 Section 04 Lesson 1-Working with Text Strings 00:05:00 Lesson 2-Working with LCASE and UCASE Functions 00:05:00 Lesson 3-Working with LEN and TRIM Functions 00:07:00 Lesson 4-Working with LEFT, RIGHT, and MID Functions 00:07:00 Section 05 Lesson 1-Understanding Loops 00:02:00 Lesson 2-Working with For Next Loops 00:07:00 Lesson 3-Working with For Each Loops 00:06:00 Lesson 4-Working with Cells Property 00:08:00 Lesson 5-Working with Do Until Loops 00:09:00 Lesson 6-Working with Do While Loops 00:05:00 Section 06 Lesson 1-Calling Sub Procedures 00:05:00 Lesson 2-Working with Exit Sub 00:04:00 Lesson 3-Working with Message Boxes 00:08:00 Lesson 4-Working with Input Boxes 00:08:00 Lesson 5-Working with VBA Functions 00:12:00 Lesson 6-Working with Object Variable and Set 00:06:00 Section 07 Lesson 1-Understanding and Creating a User Form 00:08:00 Lesson 2-Adding Controls to a User Form 00:16:00 Lesson 3-Adding Code for a User Form 00:10:00 Lesson 4-Launching a User Form from Excel 00:05:00 Section 08 Lesson 1-Getting Started with Debugging 00:10:00 Lesson 2-Stepping Through Your Code 00:06:00 Lesson 3-Working with Breakpoints 00:03:00 Lesson 4-Working with the Immediate Window 00:05:00 Lesson 5-Working with the Locals Window 00:05:00 Lesson 6-Working with the Err Object 00:06:00 Lesson 7-Getting Help-v2 00:07:00 Course Recap Recap 00:02:00 Additional Materials Resource - Excel 365 VBA Expert 00:00:00 Final Exam Final Exam - Excel 365 VBA Expert 00:20:00
SQL Azure is Microsoft's cloud database service. Based on SQL Server database technology and built on Microsoft's Windows Azure cloud computing platform, SQL Azure enables organizations to store relational data in the cloud and quickly scale the size of their databases up or down as business needs change. This Azure - SQL focuses primarily on Azure SQL Database as a database service that can quickly and efficiently scale to meet demand, is automatically highly available, and supports a variety of third party software. Learn how to deploy relational and non-relational databases in the cloud and explore the breadth of Azure's data services, from a single database instance to a massive scale data warehouse for working with Big data. You'll gain an understanding of how to configure firewall rules, manage log-ins and users, as well as roles and permissions, perform a database restore, and generally secure an Azure SQL database. Finally, you'll be introduced to Azure SQL Data Warehouse, a fully managed and scalable cloud service, that is compatible with other Azure offerings, such as Machine Learning and Data Factory, as well as existing SQL Server tools. What Will I Learn? Overview and provision Azure SQL Connect to Azure SQL DB and Migrate DB to Azure Work with SQL security and metrics Configure SQL DB auditing Copy and export a database Use DB Self-Service Restore and SQL DB Geo-Replication Who is the target audience? Students wanting an understanding of Azure SQL and to build their skills. Requirements Basic understanding of Azure and SQL concepts Introduction Introduction FREE 00:02:00 Azure SQL Azure SQL 00:02:00 Provisioning Azure SQL 00:06:00 Connecting to Azure SQL DB 00:08:00 Migrating to Azure DB 00:06:00 Understanding SQL Security 00:03:00 Understanding SQL DB Metrics and Auditing 00:05:00 Backing Up and Protecting your Database 00:05:00 Using SQL DB Geo-Replication 00:03:00 Conclusion Course Recap 00:02:00 Course Certification
Azure Storage is Microsoft's cloud storage solution for modern data storage scenarios. Azure Storage offers a massively scalable object store for data objects, a file system service for the cloud, a messaging store for reliable messaging, and a NoSQL store. This Azure - Azure Storage is designed to instruct you on Azure, and specifically how it pertains to containers. In this course, you will gain a comprehensive overview of storage in Azure. The course will teach you how to work with Azure storage accounts. You will learn how to expose file shares to multiple VMs in Azure at the same time. It guides you the procedures of using Blob storage, File Storage, and Content Delivery Network. Additionally, you will know how to monitor the storage and look at Azure File Sync. You will also review CDN profile. Finally, the course teaches you how to work with Backup Vault and site Recovery. What Will I Learn? Work with Azure storage accounts Use Blob Storage Use Content Delivery Network Work with Backup Vault and Site Recovery Requirements Some prior knowledge in Azure is required, or the completion of Introduction to Azure course Introduction Introduction FREE 00:03:00 Working with Storage Azure Storage Overview 00:03:00 Working with Azure Storage Accounts 00:09:00 Storage Access 00:05:00 Using Azure Blob Storage 00:06:00 Using Azure File Storage 00:04:00 Azure File Sync 00:10:00 Monitoring Storage 00:03:00 Content Delivery Network 00:03:00 CDN Profile 00:06:00 Azure Backup Vault 00:04:00 Azure Site Recovery 00:03:00 Conclusion Course Recap 00:03:00 Course Certification
Do you know that 55% of people watch online videos every day? And of those people, more than 50% watch branded videos that sell products and services. Yes, video content does matter, and sales videos rule in the marketing world. Welcome to this Make Awesome Sales Video in 2 Days with PowerPoint (Even If Never Done) course and start making high-quality sales videos in no time. The most important aspect of this Make Awesome Sales Video in 2 Days with PowerPoint (Even If Never Done) course is that you start creating your own sales video right away after completion, even if you have no prior experience. Throughout this video course, the instructor will teach you how to master the art of appealing to the audience's emotions, to keep them engaged from start to finish. You'll familiarise with our secret sales formula and learn how to apply them for creating MP4 videos using PowerPoint. Enrol now and boost sales, with this Make Awesome Sales Video in 2 Days with PowerPoint (Even If Never Done) course. What you'll learn Uncover the secret sales formula that will guarantee success Learn how to make an MP4 video using PowerPoint Understand the techniques of creating an effective sales video Learn how to add noiseless voiceover to your video Learn how to add background music to your video Explore the opportunities to earn money by teaching others about sales video making Learn how to make an effective sales video from scratch. Who is this Course for? Make Awesome Sales Video in 2 Days with PowerPoint (Even If Never Done) is CPD Qualification Standards. This makes it perfect for anyone trying to learn potential professional skills. As there is no experience and qualification required for this course, it is available for all students from any academic backgrounds. Requirements Our Make Awesome Sales Video in 2 Days with PowerPoint (Even If Never Done) is fully compatible with any kind of device. Whether you are using Windows computer, Mac, smartphones or tablets, you will get the same experience while learning. Besides that, you will be able to access the course with any kind of internet connection from anywhere at any time without any kind of limitation. Career Path You will be ready to enter the relevant job market after completing this course. You will be able to gain necessary knowledge and skills required to succeed in this sector. All our Diplomas' are CPD Qualification Standards so you will be able to stand out in the crowd by adding our qualifications to your CV and Resume. DAY 01 DAY-1a Introduction to the Course FREE 00:02:00 DAY-1b Proven Formula for Sales Script 00:04:00 DAY-1c Five Handy Tips 00:02:00 DAY-1d Transfer Sales Script to PPT 00:04:00 DAY-1e Create-Master-Slide-in-PowerPoint 00:02:00 DAY-1f Format Video Texts with Suitable Font 00:03:00 DAY-1g Modify Background for Nice Video Appearance 00:03:00 DAY 02 DAY-2a Control Transitions Between Slides 00:04:00 DAY-2b Produce Video from Plain Texts with Simple Animations 00:06:00 DAY-2c Free Audio Recording Editing Producing Tool 00:05:00 DAY-2d Edit Voice Recording to Make Noise Free 00:02:00 DAY-2e Synchronize Voice Clips with PPT Slides 00:07:00 DAY-2f Embed Background Music for Sales Video 00:04:00 DAY-2g Conclusion Video 00:02:00
Course Duration: Half-day or full-day program (with virtual and in-person options) Target Audience: Professionals working remotely, hybrid teams, managers, HR leaders, and individuals looking to improve their work-life integration in today’s fast-paced, digital-first work environment. Course Objectives By the end of this course, participants will be able to: Understand the concept of work-life integration versus work-life balance. Recognise the challenges and benefits of working remotely or in hybrid settings. Learn practical strategies for managing boundaries, time, and energy. Cultivate habits that support both productivity and personal well-being. Apply tools to foster sustainable work-life integration in their teams and organisations. Course Outline Module 1: Rethinking Work-Life Integration The difference between work-life balance and work-life integration The challenges of work-life boundaries in a remote-first world The impact of technology on personal and professional lives Why flexibility matters: remote work as a tool for integration, not separation Module 2: Understanding Your Energy and Time Identifying personal energy patterns throughout the day Time audit: understanding how you currently allocate time and energy The role of breaks, boundaries, and rituals in energy management Tools for task prioritisation: Pomodoro, time blocking, and task batching Module 3: Managing Boundaries in a Digital World Setting and communicating clear boundaries for work and personal time Managing "always-on" culture in a remote environment Tools for setting expectations with colleagues and managers Creating a dedicated workspace and establishing personal rituals Saying no effectively: how to manage overcommitment and avoid burnout Module 4: Navigating Flexibility and Productivity The benefits and challenges of flexible working hours Time management strategies for remote and hybrid work settings Overcoming distractions: creating a productive work environment at home Staying focused and motivated without the physical office Managing work interruptions and creating space for personal time Module 5: Well-Being in Remote and Hybrid Work Importance of self-care and mental health in work-life integration Strategies for staying physically active, social, and mentally engaged remotely Building habits for sleep, mindfulness, and recovery Setting clear personal and professional goals to stay aligned with values Techniques for managing stress and avoiding burnout in a remote environment Module 6: Building a Remote-First Culture Leading with empathy: supporting remote teams’ well-being Fostering communication, trust, and accountability in hybrid teams Encouraging regular check-ins, feedback loops, and work-life check-ups Building a culture of flexibility and autonomy while maintaining performance Best practices for team collaboration and social connection in remote environments Module 7: Action Planning for Sustainable Integration Developing a personalised work-life integration plan Identifying areas of improvement: time, energy, boundaries, and well-being Setting achievable goals for short-term and long-term work-life integration Peer sharing: tips and strategies that have worked for you Building accountability structures: partners, progress tracking, and revisiting goals Delivery Style Highly interactive, with a mix of discussions, reflection exercises, and case studies Practical tools, tips, and templates that participants can apply immediately Group activities to share experiences and learn from peers Guided self-reflection and action planning for immediate impact Course Materials Provided Work-Life Integration Guide Time Audit Worksheet and Energy Mapping Tools Setting Boundaries Framework and Template Remote Work Well-Being Checklist Personal Action Plan for Sustainable Integration Resource list: Apps, podcasts, and books on work-life integration Optional Add-ons Post-course coaching or check-in sessions Customised team workshop focused on hybrid work challenges Leadership session on managing remote-first teams effectively Follow-up webinars on remote collaboration and staying connected
Course Duration: Half-day or full-day program (with virtual and in-person options) Target Audience: Professionals working remotely, hybrid teams, managers, HR leaders, and individuals looking to improve their work-life integration in today’s fast-paced, digital-first work environment. Course Objectives By the end of this course, participants will be able to: Understand the concept of work-life integration versus work-life balance. Recognise the challenges and benefits of working remotely or in hybrid settings. Learn practical strategies for managing boundaries, time, and energy. Cultivate habits that support both productivity and personal well-being. Apply tools to foster sustainable work-life integration in their teams and organisations. Course Outline Module 1: Rethinking Work-Life Integration The difference between work-life balance and work-life integration The challenges of work-life boundaries in a remote-first world The impact of technology on personal and professional lives Why flexibility matters: remote work as a tool for integration, not separation Module 2: Understanding Your Energy and Time Identifying personal energy patterns throughout the day Time audit: understanding how you currently allocate time and energy The role of breaks, boundaries, and rituals in energy management Tools for task prioritisation: Pomodoro, time blocking, and task batching Module 3: Managing Boundaries in a Digital World Setting and communicating clear boundaries for work and personal time Managing "always-on" culture in a remote environment Tools for setting expectations with colleagues and managers Creating a dedicated workspace and establishing personal rituals Saying no effectively: how to manage overcommitment and avoid burnout Module 4: Navigating Flexibility and Productivity The benefits and challenges of flexible working hours Time management strategies for remote and hybrid work settings Overcoming distractions: creating a productive work environment at home Staying focused and motivated without the physical office Managing work interruptions and creating space for personal time Module 5: Well-Being in Remote and Hybrid Work Importance of self-care and mental health in work-life integration Strategies for staying physically active, social, and mentally engaged remotely Building habits for sleep, mindfulness, and recovery Setting clear personal and professional goals to stay aligned with values Techniques for managing stress and avoiding burnout in a remote environment Module 6: Building a Remote-First Culture Leading with empathy: supporting remote teams’ well-being Fostering communication, trust, and accountability in hybrid teams Encouraging regular check-ins, feedback loops, and work-life check-ups Building a culture of flexibility and autonomy while maintaining performance Best practices for team collaboration and social connection in remote environments Module 7: Action Planning for Sustainable Integration Developing a personalised work-life integration plan Identifying areas of improvement: time, energy, boundaries, and well-being Setting achievable goals for short-term and long-term work-life integration Peer sharing: tips and strategies that have worked for you Building accountability structures: partners, progress tracking, and revisiting goals Delivery Style Highly interactive, with a mix of discussions, reflection exercises, and case studies Practical tools, tips, and templates that participants can apply immediately Group activities to share experiences and learn from peers Guided self-reflection and action planning for immediate impact Course Materials Provided Work-Life Integration Guide Time Audit Worksheet and Energy Mapping Tools Setting Boundaries Framework and Template Remote Work Well-Being Checklist Personal Action Plan for Sustainable Integration Resource list: Apps, podcasts, and books on work-life integration Optional Add-ons Post-course coaching or check-in sessions Customised team workshop focused on hybrid work challenges Leadership session on managing remote-first teams effectively Follow-up webinars on remote collaboration and staying connected
Course Duration: Half-day or full-day program (with virtual and in-person options) Target Audience: Professionals working remotely, hybrid teams, managers, HR leaders, and individuals looking to improve their work-life integration in today’s fast-paced, digital-first work environment. Course Objectives By the end of this course, participants will be able to: Understand the concept of work-life integration versus work-life balance. Recognise the challenges and benefits of working remotely or in hybrid settings. Learn practical strategies for managing boundaries, time, and energy. Cultivate habits that support both productivity and personal well-being. Apply tools to foster sustainable work-life integration in their teams and organisations. Course Outline Module 1: Rethinking Work-Life Integration The difference between work-life balance and work-life integration The challenges of work-life boundaries in a remote-first world The impact of technology on personal and professional lives Why flexibility matters: remote work as a tool for integration, not separation Module 2: Understanding Your Energy and Time Identifying personal energy patterns throughout the day Time audit: understanding how you currently allocate time and energy The role of breaks, boundaries, and rituals in energy management Tools for task prioritisation: Pomodoro, time blocking, and task batching Module 3: Managing Boundaries in a Digital World Setting and communicating clear boundaries for work and personal time Managing "always-on" culture in a remote environment Tools for setting expectations with colleagues and managers Creating a dedicated workspace and establishing personal rituals Saying no effectively: how to manage overcommitment and avoid burnout Module 4: Navigating Flexibility and Productivity The benefits and challenges of flexible working hours Time management strategies for remote and hybrid work settings Overcoming distractions: creating a productive work environment at home Staying focused and motivated without the physical office Managing work interruptions and creating space for personal time Module 5: Well-Being in Remote and Hybrid Work Importance of self-care and mental health in work-life integration Strategies for staying physically active, social, and mentally engaged remotely Building habits for sleep, mindfulness, and recovery Setting clear personal and professional goals to stay aligned with values Techniques for managing stress and avoiding burnout in a remote environment Module 6: Building a Remote-First Culture Leading with empathy: supporting remote teams’ well-being Fostering communication, trust, and accountability in hybrid teams Encouraging regular check-ins, feedback loops, and work-life check-ups Building a culture of flexibility and autonomy while maintaining performance Best practices for team collaboration and social connection in remote environments Module 7: Action Planning for Sustainable Integration Developing a personalised work-life integration plan Identifying areas of improvement: time, energy, boundaries, and well-being Setting achievable goals for short-term and long-term work-life integration Peer sharing: tips and strategies that have worked for you Building accountability structures: partners, progress tracking, and revisiting goals Delivery Style Highly interactive, with a mix of discussions, reflection exercises, and case studies Practical tools, tips, and templates that participants can apply immediately Group activities to share experiences and learn from peers Guided self-reflection and action planning for immediate impact Course Materials Provided Work-Life Integration Guide Time Audit Worksheet and Energy Mapping Tools Setting Boundaries Framework and Template Remote Work Well-Being Checklist Personal Action Plan for Sustainable Integration Resource list: Apps, podcasts, and books on work-life integration Optional Add-ons Post-course coaching or check-in sessions Customised team workshop focused on hybrid work challenges Leadership session on managing remote-first teams effectively Follow-up webinars on remote collaboration and staying connected
The comprehensive Advanced AutoLISP Programming has been designed by industry experts to provide learners with everything they need to enhance their skills and knowledge in their chosen area of study. Enrol on the Advanced AutoLISP Programming today, and learn from the very best the industry has to offer! This best selling Advanced AutoLISP Programming has been developed by industry professionals and has already been completed by hundreds of satisfied students. This in-depth Advanced AutoLISP Programming is suitable for anyone who wants to build their professional skill set and improve their expert knowledge. The Advanced AutoLISP Programming is CPD-accredited, so you can be confident you're completing a quality training course will boost your CV and enhance your career potential. The Advanced AutoLISP Programming is made up of several information-packed modules which break down each topic into bite-sized chunks to ensure you understand and retain everything you learn. After successfully completing the Advanced AutoLISP Programming , you will be awarded a certificate of completion as proof of your new skills. If you are looking to pursue a new career and want to build your professional skills to excel in your chosen field, the certificate of completion from the Advanced AutoLISP Programming will help you stand out from the crowd. You can also validate your certification on our website. We know that you are busy and that time is precious, so we have designed the Advanced AutoLISP Programming to be completed at your own pace, whether that's part-time or full-time. Get full course access upon registration and access the course materials from anywhere in the world, at any time, from any internet-enabled device. Our experienced tutors are here to support you through the entire learning process and answer any queries you may have via email.
This Hotel Receptionist course is for SPANISH Speaking People This Spanish Hotel Receptionist course is perfect for anyone from a Hotel Receptionist to Front Office Supervisors. You will get the overview of the hotel industry learning communication skills, Customer Service, Conflict Management and Filing Systems and Record Keeping to name a few. Moreover, You will be able to handle any situations that come your way with ease. According to Reed a Hotel Receptionist can earn upto £24,000 in a year depending on experience, location and other factors. So what are you waiting for enrol now and take this Hotel Receptionist course as a guide to perfectly execute the role of a Hotel Receptionist. Translated in Spanish: Este curso de espa��ol para recepcionista de hotel es perfecto para cualquier persona, desde recepcionista de hotel hasta supervisores de recepci��n. Obtendr�� una descripci��n general de la industria hotelera aprendiendo habilidades de comunicaci��n, servicio al cliente, gesti��n de conflictos y sistemas de archivo y mantenimiento de registros, por nombrar algunos. Adem��s, podr�� manejar cualquier situaci��n que se le presente con facilidad. Seg��n Reed, un recepcionista de hotel puede ganar hasta £24.000 al a��o, dependiendo de la experiencia, la ubicaci��n y otros factores. Entonces, ��qu�� esperas para inscribirte ahora y realizar este curso de Recepcionista de Hotel como gu��a para ejecutar a la perfecci��n el rol de Recepcionista de Hotel? Key Features: CPD Certified Free Certificate Developed by Specialist Lifetime Access Course Curriculum: Hotel Receptionist (In Spanish) Module 01: Panorama general de la industria hotelera Module 02: Gesti��n of Frente Oficina de Operaciones Module 03: Habilidades de comunicaci��n Module 04: Servicio al cliente Module 05: Habilidades de un administrador eficaz Module 06: Gesti��n de conflictos Module 07: Gesti��n del tiempo Module 08: Habilidades organizativas Module 09: T��cnicas de negociaci��n Module 10: Habilidades telef��nicas comerciales Module 11: Sistemas de archivo y mantenimiento de registros Learning Outcomes: Understand hotel industry dynamics, roles, and responsibilities. Execute front office operations efficiently with effective management techniques. Enhance communication skills for effective guest interaction and team collaboration. Provide exceptional customer service catering to diverse guest needs. Apply managerial skills in handling staff, tasks, and daily operations. Resolve conflicts, manage time, organize tasks, and negotiate effectively. CPD 10 CPD hours / points Accredited by CPD Quality Standards Who is this course for? This Hotel Receptionist (In Spanish) course is accessible to anyone eager to learn more about this topic. Through this course, you'll gain a solid understanding of Hotel Receptionist (In Spanish). Moreover, this course is ideal for: Individuals seeking entry-level positions in hotel receptionist roles. Those aiming to develop foundational skills in hospitality management. Students pursuing careers in the hospitality and tourism sectors. Professionals looking to enhance their customer service and managerial abilities. Anyone interested in a career at the frontline of hospitality services. Requirements There are no requirements needed to enrol into this Hotel Receptionist (In Spanish) course. We welcome individuals from all backgrounds and levels of experience to enrol into this Hotel Receptionist (In Spanish) course. Career path After finishing this Hotel Receptionist (In Spanish) course you will have multiple job opportunities waiting for you. Some of the following Job sectors of Hotel Receptionist (In Spanish) are: Hotel Receptionist Front Desk Agent Guest Service Associate Concierge Reservation Agent Front Office Supervisor Certificates Digital certificate Digital certificate - Included Certificate of Completion Digital certificate - Included Will be downloadable when all lectures have been completed.