3448 Courses delivered Online

This comprehensive course on AWS Certified Cloud Practitioner (CLF-C01) empowers you to fast-track your IT career. Gain in-depth knowledge of cloud computing, AWS services, and architectural concepts. With hands-on labs, quizzes, and real practice exams, you will confidently build cost-effective, fault-tolerant IT solutions on the AWS Cloud.

Duration 1 Days 6 CPD hours This course is intended for This course is intended for those with a basic understanding of Microsoft Windows and who need to learn foundational Word skills, such as creating, editing, and formatting documents; inserting simple tables and creating lists; and employing a variety of techniques for improving the appearance and accuracy of document content. Overview In this course, you will learn fundamental Word skills. You will: Navigate and perform common tasks in Word, such as opening, viewing, editing, saving, and printing documents, and configuring the application. Format text and paragraphs. Perform repetitive operations efficiently using tools such as Find and Replace, Format Painter, and Styles. Enhance lists by sorting, renumbering, and customizing list styles. Create and format tables. Insert graphic objects into a document, including symbols, special characters, illustrations, pictures, and clip art. Format the overall appearance of a page through page borders and colors, watermarks, headers and footers, and page layout. Use Word features to help identify and correct problems with spelling, grammar, readability, and accessibility. These days, most people take electronic word processing for granted. While we may still write out our grocery lists with pen and paper, we expect to use a computer to create the majority of our documents. It's impossible to avoid word-processing software in many areas of the business world. Managers, lawyers, clerks, reporters, and editors rely on this software to do their jobs. Whether you are an executive secretary or a website designer, you'll need to know the ins and outs of electronic word processing.Microsoft© Word is designed to help you move smoothly through the task of creating professional-looking documents. Its rich features and powerful tools can make your work easy, and even fun. In this course, you'll learn how to use Word on the desktop to create and edit simple documents; format documents; add tables and lists; add design elements andlayout options; and proof documents.Note: Most Office users perform the majority of their daily tasks using the desktop version of the Office software, so that is the focus of this training. The course material will alsoenable you to access and effectively utilize many web-based resources provided with your Microsoft 365 subscription. This includes brief coverage of key skills for using Word for theWeb and OneDrive. Helpful notes throughout the material alert you to cases where the online version of the application may function differently from the primary, desktop version.This course may be a useful component in your preparation for the Microsoft Word (Microsoft 365 Apps and Office 2019): Exam MO-100 and Microsoft Word Expert (Microsoft 365 Apps and Office 2019): Exam MO-101 certification exams. Lesson 1: Getting Started with Word Topic A: Navigate in Microsoft Word Topic B: Create and Save Word Documents Topic C: Edit Documents Topic D: Work with Word for the Web Lesson 2: Formatting Text and Paragraphs Topic A: Apply Character Formatting Topic B: Control Paragraph Layout Topic C: Align Text Using Tabs Topic D: Display Text in Bulleted or Numbered Lists Topic E: Apply Borders and Shading Lesson 3: Working More Efficiently Topic A: Make Repetitive Edits Topic B: Apply Repetitive Formatting Topic C: Use Styles to Streamline Repetitive Formatting Tasks Topic D: Customize the Word Environment Lesson 4: Managing Lists Topic A: Sort a List Topic B: Format a List Lesson 5: Adding Tables Topic A: Insert a Table Topic B: Modify a Table Topic C: Format a Table Topic D: Convert Text to a Table Lesson 6: Inserting Graphic Objects Topic A: Insert Symbols and Special Characters Topic B: Add Images to a Document Lesson 7: Controlling Page Appearance Topic A: Apply a Page Border and Color Topic B: Add Headers and Footers Topic C: Control Page Layout Topic D: Add a Waterm Lesson 8: Preparing to Publish a Document Topic A: Check Spelling, Grammar, and Readability Topic B: Preview and Print Documents Topic C: Use Research Tools Topic D: Check Accessibility Topic E: Dictate Text in a Document Topic F: Save a Document to Other Form Additional course details: Nexus Humans Microsoft Word for Office 365 (Desktop or Online) (v1.1) Part 1 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 Microsoft Word for Office 365 (Desktop or Online) (v1.1) Part 1 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 1 Days 6 CPD hours This course is intended for This course is designed for a non-technical audience and doesn't require any prior coding or technical experience. The handson exercises will be done using pre-built OpenAI tools and interfaces that are user-friendly and easy to use. Overview Working in an interactive learning environment, led by our engaging expert, you will: Get comfortable with the basics of prompt engineering and discover how it can make a difference in various business tasks, such as enhancing customer support, creating content, and fine-tuning sales pitches. Develop the knack for crafting, refining, and perfecting prompts suited to specific business situations by understanding context, user intent, and what makes a prompt great. Learn how to smoothly incorporate prompt engineering solutions into your existing business workflows, including pinpointing the right processes, integrating with your current software, and keeping data privacy and security in check. Become proficient in advanced techniques and best practices in prompt engineering, like making use of APIs, customizing language models, and collaborating with your teammates across different departments. Keep up with the latest developments in prompt engineering and be ready to adapt to changing business needs and trends, ensuring that you stay relevant and continue to grow in the dynamic business world. Prompt engineering is the process of designing and refining input prompts to get desired output from advanced language models, such as OpenAI Codex or GPT-4. It involves creating effective questions or statements that guide the AI model to generate useful responses for a specific task or purpose, like enhancing customer support, generating content, and fine-tuning sales pitches, making it an essential skill set for a wide range of business applications. Quick Start to Prompt Engineering for Everyday Business Users is a one-day, workshop style hands-on course that where you'll learn how to create effective prompts, integrate prompt engineering solutions into existing workflows, and uncover advanced techniques and best practices. Guided by our engaging, expert instructor, you?ll experiment with innovative tools and develop practical skills that can be immediately applied to a variety of projects. Whether you're aiming to enhance customer interactions, simplify content creation, or refine internal communication, this immersive learning experience will equip you with the knowledge to make a meaningful impact on your organization. Introduction to Prompt Engineering Understand the fundamentals of prompt engineering and its applications in the business world. What is prompt engineering? Importance of prompt engineering in business Key concepts and terminology Examples of prompt engineering in business scenarios Overview of popular prompt engineering tools (e.g., OpenAI Codex, GPT-4) Activity: Hands-on exploration of prompt engineering tools: Participants will engage in a fun scavenger hunt activity, where they will experiment with different prompt engineering tools to answer a set of questions. Developing Effective Prompts Learn how to create and refine prompts for a variety of business applications. Anatomy of a good prompt Understanding context and user intent Techniques for prompt iteration and optimization Generating specific and creative responses Handling sensitive information and biases Activity: Prompt development workshop: Participants will practice developing and refining prompts in a collaborative, game-like environment, where they will compete to create the most effective prompts for given business scenarios. Integrating Prompt Engineering into Business Processes Discover how to incorporate prompt engineering solutions into existing workflows. Identifying business processes that can benefit from prompt engineering Integrating prompt engineering with existing software and tools Evaluating the success and impact of prompt engineering solutions Ensuring data privacy and security Scaling prompt engineering solutions across an organization Activity: Business process integration simulation: Participants will work in teams to create a plan for integrating a prompt engineering solution into a simulated business process, with a focus on creativity and practicality. Advanced Techniques and Best Practices Gain insights into advanced techniques and best practices for prompt engineering in a business context. Leveraging APIs for prompt engineering Customizing and fine-tuning language models Adapting to changing business requirements and trends Collaborating with cross-functional teams Staying up-to-date with prompt engineering advancements Activity: Advanced prompt engineering challenge: Participants will take part in a friendly competition, using advanced techniques to solve complex business-related prompt engineering challenges. Additional course details: Nexus Humans QuickStart to Prompt Engineering for Everyday Business Users (TTAI2009) 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 QuickStart to Prompt Engineering for Everyday Business Users (TTAI2009) 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 4 Days 24 CPD hours This course is intended for Administrators, architects, and business leaders who manage Nutanix clusters in the datacenter Managers and technical staff seeking information to drive purchase decisions Anyone who is seeking the Nutanix Certified Professional - Multicloud Infrastructure (NCP-MCI) certification Overview During this program, attendees will: Develop a working knowledge of the Nutanix product family. Understand the requirements and considerations involved in setting up a Nutanix cluster. Familiarize themselves with cluster management and monitoring via the Prism web console. Learn how to create, manage, and migrate VMs, set up data protection services, and plan for business continuity. Understand how to plan and handle upgrades, assess future requirements, and create what-if scenarios to adress scaling for business needs. The Nutanix Enterprise Cloud Administration (ECA) course enables administrators (system, network, and storage) to successfully configure and manage Nutanix in the datacenter. The course covers many of the tasks Nutanix administrators perform through the use of graphical user interfaces (GUIs) and command line interfaces (CLIs). It also provides insight into a Nutanix cluster?s failover and self-healing capabilities, offers tips for solving common problems, and provides guidelines for collecting information when interacting with Nutanix Support Introduction The section describes the Nutanix HCI solution, walks you through the components of the Nutanix Enterprise Cloud, and explains the relationship between physical and logical cluster components. Managing the Nutanix Cluster In this section, you will use the Prism console to monitor a cluster, configure a cluster using various interfaces, use the REST API Explorer to manage the cluster, and learn how to deploy Nutanix-specific PowerShell cmdlets. Securing the Nutanix Cluster This section shows how to secure a Nutanix cluster through user authentication, SSL certificate installation, and cluster access control. Acropolils Networking This section explains how to configure managed and unmanaged Acropolis networks and describes the use of Open vSwitch (OVS) in Acropolis. You will learn how to display and manage network details, differentiate between supported OVS bond modes, and gain insight into default network configuration. VM Management This section shows you how to upload images, and how to create and manage virtual machines. Health Monitoring and Alerts In this section, you will use the Health Dashboard to monitor a cluster?s health and performance. You will also use Analysis Dashboard to create charts that you can export with detailed information on a variety of components and metrics. Distributed Storage Fabric This section discusses creating and configuring storage containers, including the storage optimization features: deduplication, compression, and erasure coding. AHV Workload Migration Using Nutanix Move, this section shows how to migrate workloads to a cluster running AHV. This is followed by a lab where a VM running on a Nutanix cluster configured with ESXi is migrated to a Nutanix cluster running AHV. File and Volumes This section gives you detailed information on Nutanix Volumes, which provides highly available, high-performance block storage through a few easy configuration steps. It also discusses Nutanix Files. Understanding Infrastructure Resiliency This section shows how Nutanix provides comprehensive data protection at all levels of the virtual datacenter: logical and physical. Data Protection Data can be replicated between Nutanix clusters, synchronously and asynchronously. This section shows how to configure a Protection Domain (PD) and Remote Sites, recover a VM from a PD, and perform a planned failover of a PD. Prism Central Having discussed and used Prism Element earlier, this section looks at the capabilities of Prism Central. With the added functionality provided by a Pro license, the focus is on features related to monitoring and managing multiple activities across a set of clusters. Monitoring the Nutanix Cluster This section shows you where to locate and how to interpret cluster-related log files. In addition, you will take a closer look at the Nutanix Support Portal and online help. Cluster Management and Expansion This section outlines essential life-cycle operations, including starting/stopping a Nutanix cluster, as well as starting/shutting down a node. You will also learn how to expand a cluster, manage licenses, and upgrade the cluster?s software and firmware. Remote Office Branch Office (ROBO) Deployments In this section, you will understand various configurations and requirements specific to a ROBO site. This includes hardware/software, Witness VM, networking, failure and recovery scenarios for two-node clusters, and the seeding process. Additional course details: Nexus Humans NECA: Nutanix Enterprise Cloud Administration 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 NECA: Nutanix Enterprise Cloud Administration 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.

Are your sales people too stressed, running on adrenalin, perhaps driving towards burnout, struggling to reach targets? Wouldn't you rather they delivered consistently good performance, sustainable over longer periods of time, with less stress (for both them and you)? This uniquely empowering workshop will help your team develop naturally high levels of focus, energy and motivation. They will attain a sense of grounded euphoria, giving them a very distinct and ethical edge in selling. A one-day programme, it gives salespeople an introduction to the 'Natural Superheroes' concepts and resources, tools and techniques, to help them improve their sales performance - realising greater sales potential, developing deeper and more profitable client relationships, winning more business. Through this experience, sales teams gain: Information about profiling clients to instantly understand more about their deepest drives and true needs so they can be genuinely met and, where possible, exceeded Insights into deep, honest and very 'real' reasons for sales procrastination - participants are given specific workable strategies they can easily apply to overcome sales resistance, by tapping their natural motivational styles An understanding of communicating at the very highest levels with different people so they truly understand your sales message and have a significantly more positive sales experience A realisation of their very specific natural sales talents as individuals and as a team A deeper level of experience and understanding of what specifically drives their own behaviour and the behaviour of their clients - these unique insights explain not only how but exactly why people behave the way they do An experience of what it takes to be unshakeable under pressure and manage the sales processes and relationships to a positive outcome for all Brand-new insights into working with and handling difficult people across all levels of authority An understanding of the pitfalls and the psychological traps we set ourselves which cause unnecessary stress, anxiety and frustration on a daily basis and, in turn, limit our sales performance Access to very simple and practical tools that massively increase self-awareness, engender accountability and responsibility and develop emotional sales mastery 1 Introducing 'Natural Superheroes' for sales What is a 'Natural Superhero'? Defining emotional intelligence in the context of sales and why it is so important Knowing yourself - why most people don't know themselves at all and how we can understand exactly what drives our behaviour for the purpose of improving sales performance specifically Knowing exactly why others, and specifically clients and team members, behave the way they do - understanding the real motives behind people's good and bad behaviour in a sales meeting Simple steps to freeing yourself of any anxiety, pressure and false sense of limitation when selling Being yourself in sales - why this is not as easy as it sounds but how you can make it effortless How to take control of achieving the sales performance you really need and want for yourself and others Strategies that raise your self-awareness, increase an authentic and sustainable sense of self-confidence, in difficult situations and in moments of crisis 2 Understanding yourself, your team members and your customers - using the Enneagram Introducing the Enneagram and why it is so valuable to sales people and their clients Exploring the 9 types of motivational drives and why people have different reasons for buying from you Core types and wings - understanding the influence of other motivations either side of the core Enneagram type How to confirm the profile of your client - using celebrities from the world of politics, cinema, sports - we explore how to identify each type - what are their core drives, why have they arisen and how can we use these insights to help you in improving your sales performance The 3 levels of behaviour within your personal profile and that of your clients Lookalike Enneagram types - mistaken identities - how to avoid these traps when profiling your clients and your team How to communicate effectively in a sales environment with each of the different Enneagram types - communication strategies for positive impact on morale, performance and, ultimately, sales results How to interpret and make use of the results of your online personal profile - participants complete an online profile before the event and have the opportunity to analyse their results with a view to improving their sales performance How sales teams sabotage their own performance and that of other people within the team - and how to stop it Uncovering your particular edge in a sales role - what unconsciously trips you up as a sales person? How the Enneagram helps us in sustaining a truly great sales performance over time 3 Why positive thinking alone doesn't work in sales Why 'PMA' does not stand for positive mental attitude when selling - learn its alternative meaning that can serve you even more effectively in a sales role 3 steps and exercises that naturally increase PMA The value of making unconscious thinking conscious and how to do this without any pain or discomfort in a sales meeting Why each Enneagram type has a different experience of PMA in terms of their outward behaviour and how to know when you are maximising your sales performance 4 Measuring success How to measure the development of your individual profile as a sales person Development planning and review Into the future - how to continue your Natural Superhero development

Course Overview Grasp the opportunity to learn Microsoft Excel from the ABCs to an advanced level within one course. The Microsoft Excel Masterclass in 2021 course will start with the basics with MS excel and gradually turn you into an expert user. The Microsoft Excel Masterclass in 2021 course will first focus on the tools and functions of excel. You will comprehend the skills to create basic formulas in excel. In this step by the step learning process, you will have the adequate knowledge and ability to make all sorts of adjustments to your worksheets. The course will teach you many strategies for cell formatting. From the easy to follow modules, you will grasp the techniques to insert shapes and images into your sheets. You will also understand how to visualize your data in charts. In the end, you will study the benefits of using excel templates. The Microsoft Excel Masterclass in 2021 course will provide you with first-hand training on excel. Enroll in the course and take your excel skills to the next level. Learning Outcomes Get an introduction to Microsoft Excel and its functions Understand the process of data validation and data visualization Learn how to adjust excel worksheets Know about the conditional functions Familiarize yourself with the process of inserting images and shapes Who is this course for? Those who want to learn Microsoft Excel. Entry Requirement This course is available to all learners, of all academic backgrounds. Learners should be aged 16 or over to undertake the qualification. Good understanding of English language, numeracy and ICT are required to attend this course. Certification After you have successfully completed the course, you will be able to obtain an Accredited Certificate of Achievement. You can however also obtain a Course Completion Certificate following the course completion without sitting for the test. Certificates can be obtained either in hardcopy at the cost of £39 or in PDF format at the cost of £24. PDF certificate's turnaround time is 24 hours, and for the hardcopy certificate, it is 3-9 working days. Why choose us? Affordable, engaging & high-quality e-learning study materials; Tutorial videos/materials from the industry-leading experts; Study in a user-friendly, advanced online learning platform; Efficient exam systems for the assessment and instant result; The UK & internationally recognized accredited qualification; Access to course content on mobile, tablet or desktop from anywhere anytime; The benefit of career advancement opportunities; 24/7 student support via email. Career Path The Microsoft Excel Masterclass in 2021 course is a useful qualification to possess and would be beneficial for any related profession or industry such as: Business Professional Data Operator Administrative Officer Data Analyst Unit 01: Excel from A-Z Course Introduction Excel from A-Z Course Intro 00:03:00 Excel Job Opportunities 00:03:00 Excel Job Types 00:04:00 Microsoft Excel Marketplace 00:04:00 What is Microsoft Excel? 00:04:00 Who is This Course For? 00:04:00 Unit 02: Getting Started With Excel Finding & Opening Excel 00:01:00 Excel's Start Screen 00:03:00 Explaining the Excel Interface 00:03:00 Excel Interface Continued 00:01:00 Excel Workbook vs. Excel Worksheet 00:02:00 Saving an Excel Document 00:04:00 Customizing the Quick Access Toolbar 00:02:00 Customizing the Excel Ribbon 00:03:00 Excel Shortcut Keys 00:02:00 Unit 03: Values, Referencing and Formulas Creating Excel Labels 00:03:00 Entering Numeric Values in Excel 00:03:00 Formatting Date Values in Excel 00:05:00 Building Basic Formulas in Excel 00:05:00 Order of Operations 00:06:00 Relative vs. Absolute Cell References 00:07:00 Unit 04: Intro to Excel Functions Excel Functions Explained 00:03:00 The SUM() Function 00:08:00 The MIN() & MAX() Function 00:04:00 The AVERAGE() Function 00:02:00 COUNT() Functions 00:05:00 Unit 05: Adjusting Excel Worksheets Moving & Copying Data 00:07:00 Insert & Delete Rows and Columns 00:05:00 Adjusting the Width and Height of Cells 00:05:00 Hiding and Unhiding Excel Rows and Columns 00:04:00 Renaming, Moving & Deleting Excel Worksheets 00:05:00 Adding Protection to Specific Cells 00:04:00 Protecting the Structure of a Workbook 00:02:00 Adding a Workbook Password to Open File 00:02:00 Unit 06: Visually Pleasing Cell Formatting Formatting Fonts and Cell Background Color 00:05:00 Adding Cell Borders 00:05:00 Formatting Data Appropriately 00:05:00 The Magic behind Excel's Format Painter 00:04:00 Creating Styles for Formatting Efficiency 00:06:00 Merging Cells for a Cleaner Look 00:03:00 The Power of Conditional Formatting 00:06:00 Unit 07: How to Insert Images and Shapes! Grab User's Attention using Illustrations 00:09:00 Customizing Icons 00:05:00 Create Compelling Graphics with SmartArt 00:06:00 Unit 08: Visualize Data with Charts The Commonly Used Column Chart 00:03:00 Changing the Chart Design 00:02:00 Formatting Elements of a Chart 00:06:00 Modifying the Data, Type & Location of a Chart 00:06:00 Unit 09: Excel's Printing Options Print Preview Options 00:04:00 Excel's Page Layout View 00:07:00 Printing a Specific Range of Cells 00:03:00 Converting Spreadsheets to PDF Files 00:02:00 Unit 10: Benefits of Using Excel Templates Why Create an Excel Template 00:01:00 How to Create an Excel Template 00:05:00 Unit 11: Working with Excel Datasets How to Prepare Data for Analysis 00:04:00 How to Sort Data in Excel 00:03:00 Multi-Level Sorting 00:03:00 Custom Sorting Datasets in Excel 00:02:00 Applying Filters to Datasets 00:05:00 Creating Subtotals within a Dataset 00:06:00 Converting Datasets into Tables 00:06:00 Finding & Removing Duplicate Values 00:07:00 Unit 12: Excel Database Functions The SUMIF() Function 00:09:00 The DSUM() Function 00:08:00 The DSUM() Function Cont. 00:07:00 The SUBTOTAL() Function 00:06:00 Unit 13: Excel Data Validation What is Excel Data Validation? 00:02:00 Creating a Drop Down List with Data Validation 00:07:00 Different Types of Excel Data Validation 00:06:00 Adding Custom Alerts to Data Validation 00:07:00 Creating a Dynamic Drop Down List 00:03:00 Complex Validation: Dependent Drop Down List! 00:09:00 Unit 14: Excel PivotTables Creating an Excel Pivot Table 00:06:00 Modifying Excel PivotTables 00:06:00 Grouping & Filtering PivotTable Data 00:07:00 Drilling Down into PivotTable Data 00:02:00 Creating Pivot Charts & Utilizing Slicers 00:08:00 Unit 15: Excel's PowerPivot Add-In What is PowerPivot? 00:04:00 Activating the Excel PowerPivot Add-In 00:02:00 Creating Relationships between Data Tables 00:06:00 Using Data Models to Create PivotTables 00:05:00 How to Create PowerPivot KPI's 00:08:00 Unit 16: Excel's Conditional Functions Excel's IF() Function 00:05:00 IF() Function with AND() Criteria 00:05:00 IF() Function with OR() Criteria 00:05:00 Nesting Multiple IF() Functions 00:07:00 The COUNTIF() Function 00:04:00 Key Benefits of Named Ranges 00:04:00 Unit 17: Excel's Lookup Function VLOOKUP() Function 00:09:00 The Beauty of Excel's IFERROR() Function 00:04:00 HLOOKUP() Function 00:06:00 INDEX() Function 00:05:00 MATCH() Function 00:05:00 INDEX() and MATCH() Combined 00:05:00 Two-Way Lookup with INDEX() and MATCH() 00:04:00 Unit 18: Text Based Functions in Excel LEFT(), RIGHT() and MID() Function 00:07:00 Extracting Specific Text using LEN() & SEARCH() 00:13:00 Combining Text with CONCATENATE() 00:06:00 Quick Tips & Other Text Based Functions 00:06:00 Unit 19: Auditing Formulas and Views in Excel Tracing Precedents & Dependents in Formulas 00:04:00 Showing Formulas 00:02:00 Grouping Data 00:03:00 3D Referencing in Formulas 00:05:00 Utilizing the Watch Window in Excel 00:03:00 How to Freeze Panes in Excel 00:03:00 Unit 20: Excel's 'what If?' Tools Excel's Scenario Manager Tool 00:06:00 Goal Seek in Excel 00:06:00 Compare Results with Excel Data Tables 00:04:00 Solver Tool 00:11:00 Unit 21: Welcome to Excel VBA The Power Behind Excel VBA 00:03:00 A Look Inside the Visual Basic Editor (VBE) 00:04:00 Recording a Macro 00:09:00 Saving & Opening a Macro-Enabled Workbook 00:02:00 Unit 22: The VBA Language Modules and Procedures 00:07:00 Objects, Methods and Properties 00:06:00 Excel VBA Variables 00:05:00 Unit 23: Writing VBA Code Referencing a Range 00:14:00 InputBox & MsgBox 00:06:00 Using Variables in VBA Code 00:05:00 If Then Else Statement 00:10:00 Worksheet Functions inside VBA 00:08:00 Creating User Defined Functions 00:09:00 User Defined Functions within VBA Scripts 00:06:00 Unit 24: Important VBA Tools and Logic Find Last Row of Data 00:06:00 Find Last Column of Data 00:03:00 With Statement 00:05:00 Debugging & Error Handling 00:07:00 Debugging & Error Handling Cont. 00:07:00 Unit 25: Excel VBA Lopps For Next Loop 00:09:00 Do Until Loop 00:06:00 For Each Loop 00:04:00 Unit 26: Triggering Macros Assigning Macros to Shapes 00:04:00 Form Controls vs ActiveX Controls 00:08:00 Worksheet Events 00:04:00 Workbook Events 00:03:00 Fun with VBA Events! 00:07:00 Unit 27: Excel User Forms Creating an Excel UserForm 00:03:00 Adding Controls to UserForms 00:10:00 How to Show an UserForm 00:03:00 Passing TextBox Values to Desired Cells 00:07:00 Passing Option Buttons to Desired Cells 00:07:00 UserForm ComboBoxes 00:08:00 Clearing Values from UserForm Controls 00:03:00 How to Close an UserForm 00:02:00 UserForms and Protected Sheets 00:05:00 Unit 28: Starting a Career in Excel Creating an Excel Resume 00:05:00 Getting Started with Freelancing 00:06:00 How to Become an Excel Freelancer 00:05:00 Top Freelance Websites 00:05:00 How to Get Your First Client 00:08:00 Personal Branding 00:07:00 Networking Do's and Don'ts 00:04:00 Importance of Having a Website 00:04:00 Resources Resources - Microsoft Excel Masterclass in 2021 00:00:00 Certificate and Transcript Order Your Certificates and Transcripts 00:00:00

This UI Design course is concerned with the development of interactive systems, including for mobile / portable devices, with a strong focus on user-centred design and usability principles. You will learn what characteristics of a user interface can make it easy or hard for people to use, and how to design user interfaces that take into account human capabilities and constraints. Why choose this course Earn an e-certificate upon successful completion. Accessible, informative modules taught by expert instructors Study in your own time, at your own pace, through your computer tablet or mobile device Benefit from instant feedback through mock exams and multiple-choice assessments Get 24/7 help or advice from our email and live chat teams Full Tutor Support on Weekdays Course Design The course is delivered through our online learning platform, accessible through any internet-connected device. There are no formal deadlines or teaching schedules, meaning you are free to study the course at your own pace. You are taught through a combination of Video lessons Online study materials Mock exams Multiple-choice assessment Certification Upon successful completion of the course, you will be able to obtain your course completion e-certificate. Print copy by post is also available at an additional cost of 9.99 and PDF Certificate at 4.99. Who is this course for? UI Design course is suitable for anyone who want to gain extensive knowledge, potential experience and professional skills in the related field. This is a great opportunity for all student from any academic backgrounds to learn more on this subject Course Content Setting Up Photoshop for UI Design Setting up Photoshop CC Preferences 00:06:00 Color Profile Settings for ui design 00:05:00 Creating Custom Shortcut Keys 00:04:00 Installing scripts in Photoshop 00:06:00 What area Photoshop Extensions 00:07:00 Power of Photoshop Extensions 00:09:00 How to install Extension in mac and win update 00:16:00 (Optional - Can watch at the end) Color Calibration and Monitors for Designers Color Calibration 00:08:00 Monitor You Need-1 00:02:00 OS Based clor Calibration 00:07:00 Basics of Photoshop for Beginners Customize Toolbar 00:04:00 how Photoshop interface works 00:05:00 creating photoshop new document 00:04:00 What are artboards 00:06:00 Layers Panel Part 1 00:06:00 Layer Panel Filtering And Finding Part 2 00:06:00 Type tool 00:05:00 Character Panel 00:07:00 Paragraph Panel 00:04:00 New Shape Tool 00:08:00 Deep dive in Pen Tool 00:16:00 selections-april2017 New 00:07:00 pen tool in web design 00:04:00 Alignments 00:06:00 common-shortcuts 00:15:00 Clipping_Masks 00:03:00 exercise_clipping_mask 00:01:00 LayerMasks_HB 00:05:00 Smart_objects 00:08:00 linked smart objects_Revised 00:07:00 Layer comps usage 00:06:00 Using Smart Guides In Photoshop-1 00:05:00 Layer Styles Basics for UI Design Drop Shadow Llayer Effect 00:04:00 Inner Shadow UI Design 00:02:00 Stroke_effect 00:03:00 Re-using layer styles 00:02:00 Gradients in Web and UI Design What.are.gradients 00:02:00 Uses.of.gradients 00:04:00 Ways-to-create-gradients 00:05:00 How to use gradient editor 00:08:00 Using-gradient-overlay 00:06:00 Using Patterns in Web and UI Design What are patterns 00:02:00 Two methods of applying patterns 00:05:00 Create Pattern From an Img File 00:03:00 Using .pat files in photoshop 00:05:00 Basics of UI Design | Light, Shadows, Color schemes & Typography How light and shadow works in UI Design 00:04:00 examples of lightshadow 00:02:00 Color schemes for beginners 00:02:00 Getting scheme from logo and hsb 00:01:00 Online tools for color schemes 00:07:00 How to choose fonts and typography 00:09:00 Using Grids for Web Design 00:06:00 Creating Grids In Photoshop 00:06:00 UI Design Exercises & Challanges with Step by Step solutions Soft-shadow button challange 00:01:00 Soft_button_solution 00:13:00 D Button Challange 00:01:00 Pressed effect in Photoshop 00:07:00 Modern pattern part 1 00:09:00 Modern header design part 2 00:09:00 Moder header design new variation 00:09:00 Color overlay header 00:11:00 Gradienteffect Header Design-audiosynced 00:13:00 Actual Exercise Transparent Image Header-1 00:13:00 Tabs-intro 00:01:00 Tabs-part1 00:14:00 Tabs-part2 00:08:00 Image Editing 101 for UI Designers removing White Bg With Blending Options 00:03:00 Spot Healing brush usage 00:04:00 Making Colors Pop in Photohsop 00:07:00 Magnetic Lasso Tool to remove background 00:16:00 Select And Mask Tool 00:10:00 IOS App Design : Exercise Iphone Food Deals App Gathering Resources IOS App-Design 00:04:00 Lets Start The IOS App Design 00:05:00 Adding Images To Design the App design 00:06:00 Adding Text On App Screen 00:06:00 Adding Phone And Book Now Buttons 00:12:00 Using Mobile Mockups 00:04:00 BONUS: Dribbble styled Dashboard UI Design (Student Request) area graph base design 00:04:00 Area graph grid 00:05:00 Adding text to graph area 00:08:00 Drwaing area graph with pen tool 00:04:00 Designing extras adding dots and hover info 00:06:00 Final Adjustments To Area Graph-1 00:10:00 Area graph to line graph 00:04:00 circular bar graph base shape.mp4 00:06:00 adding Gradients And Shadows To Circular Graphs-1 00:13:00 designing stats with text 00:09:00 bar Graph Design In Photoshop Pt 00:09:00 Bar Graph Adding Text 00:06:00 Student-request-ciruclar-percentage graph 00:08:00 Wifreframes in UI Design + Ultimate Web Design Challange What Are Wirefreams 00:04:00 Tools Used For Wireframes 00:12:00 Dribbble Shot Redesign Exercise - Student Request dribbble redesig part 1 00:15:00 dribble shot part 2 00:15:00 Exercises : Form UI Design with Photoshop Base Of Login Form 00:07:00 Form Fields Design 00:12:00 Finishing Form Design 00:12:00 Pro Secret Tips and Tools for Designers and Developers Converting psd to CSS 00:06:00 Exporting Images from Photoshop 00:07:00 Tips on Using Grids 00:02:00 Photoshop Features Updates and New Versions Match Fonts Cc2015.5-1 00:03:00 Cc2018 Update-1 00:04:00 Order your Certificates & Transcripts Order your Certificates & Transcripts 00:00:00 Frequently Asked Questions Are there any prerequisites for taking the course? There are no specific prerequisites for this course, nor are there any formal entry requirements. All you need is an internet connection, a good understanding of English and a passion for learning for this course. Can I access the course at any time, or is there a set schedule? You have the flexibility to access the course at any time that suits your schedule. Our courses are self-paced, allowing you to study at your own pace and convenience. How long will I have access to the course? For this course, you will have access to the course materials for 1 year only. This means you can review the content as often as you like within the year, even after you've completed the course. However, if you buy Lifetime Access for the course, you will be able to access the course for a lifetime. Is there a certificate of completion provided after completing the course? Yes, upon successfully completing the course, you will receive a certificate of completion. This certificate can be a valuable addition to your professional portfolio and can be shared on your various social networks. Can I switch courses or get a refund if I'm not satisfied with the course? We want you to have a positive learning experience. If you're not satisfied with the course, you can request a course transfer or refund within 14 days of the initial purchase. How do I track my progress in the course? Our platform provides tracking tools and progress indicators for each course. You can monitor your progress, completed lessons, and assessments through your learner dashboard for the course. What if I have technical issues or difficulties with the course? If you encounter technical issues or content-related difficulties with the course, our support team is available to assist you. You can reach out to them for prompt resolution.

In this competitive job market, you need to have some specific skills and knowledge to start your career and establish your position. This Effective Methods of Public Speaking and Presentation will help you understand the current demands, trends and skills in the sector. The course will provide you with the essential skills you need to boost your career growth in no time. The Effective Methods of Public Speaking and Presentation will give you clear insight and understanding about your roles and responsibilities, job perspective and future opportunities in this field. You will be familiarised with various actionable techniques, career mindset, regulations and how to work efficiently. This course is designed to provide an introduction to Effective Methods of Public Speaking and Presentation and offers an excellent way to gain the vital skills and confidence to work toward a successful career. It also provides access to proven educational knowledge about the subject and will support those wanting to attain personal goals in this area. Learning Objectives Learn the fundamental skills you require to be an expert Explore different techniques used by professionals Find out the relevant job skills & knowledge to excel in this profession Get a clear understanding of the job market and current demand Update your skills and fill any knowledge gap to compete in the relevant industry CPD accreditation for proof of acquired skills and knowledge Who is this Course for? Whether you are a beginner or an existing practitioner, our CPD accredited Effective Methods of Public Speaking and Presentation is perfect for you to gain extensive knowledge about different aspects of the relevant industry to hone your skill further. It is also great for working professionals who have acquired practical experience but require theoretical knowledge with a credential to support their skill, as we offer CPD accredited certification to boost up your resume and promotion prospects. Entry Requirement Anyone interested in learning more about this subject should take this Effective Methods of Public Speaking and Presentation. This course will help you grasp the basic concepts as well as develop a thorough understanding of the subject. The course is open to students from any academic background, as there is no prerequisites to enrol on this course. The course materials are accessible from an internet enabled device at anytime of the day. CPD Certificate from Course Gate At the successful completion of the course, you can obtain your CPD certificate from us. You can order the PDF certificate for £9 and the hard copy for £15. Also, you can order both PDF and hardcopy certificates for £22. Career path The Effective Methods of Public Speaking and Presentation will help you to enhance your knowledge and skill in this sector. After accomplishing this course, you will enrich and improve yourself and brighten up your career in the relevant job market. Course Curriculum Introduction Welcome to the Course 00:03:00 How to Talk Effectively? 00:03:00 Understand the Key Elements of Course 00:04:00 Why Don't People Learn Presentation Skills OR Public Speaking Skills? 00:02:00 QUICK UNLEARNING Before Starting this "SKILL" Unlearn Excuses, Kill this Unlearning First 00:03:00 Unlearn Excuses, Stage Fear is like any other Fear 00:01:00 Unlearn Excuses, My English is not Good? 00:02:00 Unlearn Excuses, Going Blank!!! 00:01:00 Unlearn Excuses, Feeling Nervous 00:02:00 Unlearn Excuses, Inconsistency? 00:03:00 Unlearn Excuses, WHY I need to LEARN?? 00:03:00 Unlearn Excuses, Background 00:04:00 IS THIS HAPPENED WITH YOU???? Is this happened with you? 00:05:00 When was the Last Time You Invested Money for Self Development? 00:05:00 When was the last time you got an opportunity to talk in front of people? 00:05:00 Impressive Methods of Hooking Audience, even before your Speech or Presentation HOOKING, Pause and Pan Technique 00:03:00 HOOKING, Smile Technique 00:05:00 6 Highly Impressive Methods of Starting any Speech or Presentation!! How to Start any Speech or Presentation? 'I Remember' 00:03:00 How to Start any Speech or Presentation? 'Appreciate' 00:02:00 How to Start any Speech or Presentation? 'You Focus' 00:01:00 How to Start any Speech or Presentation? 'Imagine' 00:02:00 How to Start any Speech or Presentation? 'Common' 00:02:00 How to Start any Speech or Presentation? 'Numbers' 00:02:00 Body Language: 6 Methods for Impressive Body Language for Speech or Presentation Body Language Introduction 00:02:00 Which Body part included for Body Language 00:03:00 Body Language, 'EYES' 00:05:00 Body Language, 'LIPS' 00:02:00 Body Language, 'NECK' 00:03:00 Body Language, 'SHOULDERS' 00:02:00 Body Language, 'HANDS' 00:10:00 Body Language, 'LEGS' 00:06:00 Body Language Brief Summary 00:05:00 Vocal Variety: 3 Methods (VST) for POWERFUL Vocal Variety Vocal Variety Technique Unlearn 00:03:00 Vocal Variety VST Technique, 'VOLUME' 00:02:00 Vocal Variety VST Technique, 'SPEED' 00:05:00 Vocal Variety VST Technique, 'TONE' 00:05:00 Vocal Variety VST Technique, 'QUICK SUMMARY' 00:05:00 Effective Methods of Ending Any Speech or Presentation End of Presentation 00:06:00 Closing Message 00:02:00 Bonus No Skill is Natural 00:09:00 Speak Up To the Ears 00:01:00 Do Not Use I Hope 00:01:00 When was the Last Time You Got Opportunity to Talk Infront of People? 00:02:00 Certificate and Transcript Order Your Certificates or Transcripts 00:00:00

This Hotel & Hospitality Management Diploma with Holiday Representative Training will provide you with an understanding of the interrelationships between departments that drive performance in the hotel and resort industry. The course will introduce to the central philosophies of facilities and resource management, operating procedures and compliance requirements. You will focus on developing and maintaining effective teamwork and the management of staff relationships within a hospitality team. You will become proficient in developing food and beverage menus that meet cost requirements and the management of staff training processes. You'll learn about food service operations alongside a variety of academic disciplines, including foreign languages. This course covers a range of topics such as hotels, resorts, cruise ships, private / corporate owned restaurants and special catering events. You'll also be provided with cash handling, function, restaurant service, and barista skills. Who is this course for? Retail Customer Service and Visual Merchandising Training is suitable for anyone who wants to gain extensive knowledge, potential experience, and professional skills in the related field. This course is CPD accredited so you don't have to worry about the quality. Requirements Our Retail Customer Service and Visual Merchandising Training is open to all from all academic backgrounds and there is no specific requirements to attend this course. It is compatible and accessible from any device including Windows, Mac, Android, iOS, Tablets etc. CPD Certificate from Course Gate  At the successful completion of the course, you can obtain your CPD certificate from us. You can order the PDF certificate for £9 and the hard copy for £15. Also, you can order both PDF and hardcopy certificates for £22. Career path This course opens a new door for you to enter the relevant job market and also gives you the opportunity to acquire extensive knowledge along with required skills to become successful. You will be able to add our qualification to your CV/resume which will help you to stand out in the competitive job industry. Course Curriculum Starting a Restaurant Are you ready for the challenge? 00:15:00 How to decide on a concept 00:30:00 Designing your restaurant 00:15:00 Friends and family 00:15:00 Writing a Business Plan 00:30:00 Insurance 00:15:00 Restaurant Organizations that you need to check out. 00:15:00 What are the best Catering Industry Trade Shows? 00:15:00 Managing a Restaurant Managing Yourself 00:30:00 Managing Others 00:30:00 Managing Your Money 00:15:00 Managing Your Food and Supplies 00:30:00 Managing Everything Else 00:30:00 Starting Food Catering Where You Work 00:15:00 Health and safety 00:15:00 Staff, Suppliers and Transport 00:00:00 Food Hygiene 01:00:00 Rules about Menus 00:15:00 Paperwork and Finances 00:15:00 Law 00:15:00 Food Business Food Business Basics 00:45:00 Put Together Your Business Concept 00:10:00 Identify Your Target Market 00:10:00 Identify Your Competition 00:10:00 Write A Mission Statement 00:10:00 Downline Basics 00:15:00 Equipment And Supplies 00:10:00 Marketing And Quality Control 00:10:00 Wrapping Up 00:05:00 Hospitality Introduction to Hospitality 00:15:00 Characteristics of the Hospitality Industry 00:15:00 Relationship Between the Hospitality Industry and Tourism 00:15:00 Types of Accommodation 00:15:00 Types of Room 00:30:00 Types of Hotel Guests 00:15:00 Hospitality Management Introduction to Hospitality Management 01:00:00 Influences Which Affect the Industry 00:05:00 The Development of the Hospitality Industry 00:05:00 Hospitality Brands 00:15:00 Accommodation 00:05:00 Food Service 00:05:00 Successful Quality Management 00:05:00 Holiday Representative Your Introduction to Becoming a Holiday Rep 00:15:00 Defining the Career of a Holiday Rep 00:30:00 Exploring the Various Types of Holiday Reps 00:30:00 Exploring the Origins and Growth of British Tourism 00:30:00 The Components of the Travel and Tourism Industry 00:15:00 Factors that Affect Your Career 00:30:00 Nailing the Teamwork Element Required to Surpass Expectations 01:00:00 The Standard Duties of Holiday Reps 00:15:00 The Legalities Holiday Reps Need to Know About 01:00:00 The Holiday Reps Role in Keeping their Guests Safe 00:30:00 Effective Handling of Customer Complaints 00:30:00 Administration Duties 00:15:00 Crushing It With Customer Services 00:30:00 Creating the Perfect Welcome Meeting 00:15:00 Guide to Selling Excursions 00:15:00 Preparing and Conducting Transfers Successfully 00:05:00 Tallying Floats and Converting Currencies 00:30:00 Mock Exam Mock Exam - Hotel & Hospitality Management Diploma with Holiday Representative Training 00:20:00 Final Exam Final Exam - Hotel & Hospitality Management Diploma with Holiday Representative Training 00:20:00 Certificate and Transcript Order Your Certificates or Transcripts 00:00:00

Business Process Management: Business Process Management Course Online Unlock the Power of Business Process Management: Business Process Management Course: Enrol Now! Are you a working professional with a focus on business processes or management who aspires to take the lead in various methods for discovering, modelling, analysing, measuring, improving, optimising, and automating business processes? Then our Business Process Management: Business Process Management Course is just what you need! Through this Business Process Management: Business Process Management Course you will gain a thorough understanding of the evolution of enterprise systems architectures, Business Process Management: Business Process Management Course and an introduction to the business process life cycle. You will also learn the steps of business process mapping with flow charts and diagrams, establishing business functions, identifying function leaders and adequately planning the modelling, monitoring and optimising phase. Main Course: Business Process Management course Free Courses included with Business Process Management: Business Process Management Course: Course 01: Level 5 Diploma in Business Analysis Course 02: Level 7 Diploma in Operations Management Course 03: Level 7 Life Coaching [ Note: Free PDF certificate as soon as completing Business Process Management: Business Process Management Course] Business Process Management: Business Process Management Course Online This Business Process Management: Business Process Management Course consists of 08 modules. Course Curriculum of Business Process Management: Business Process Management Course Module 01: Introduction to Business Process Management Module 02: Evolution of Enterprise Systems Architectures Module 03: Business Process Modelling Foundation Module 04: Process Orchestrations Module 05: Process Choreographies Module 06: Properties of Business Processes Module 07: Architectures and Methodologies Module 08: Business Process Management Methodology Assessment Method of Business Process Management: Business Process Management Course After completing Business Process Management: Business Process Management Course, you will get quizzes to assess your learning. You will do the later modules upon getting 60% marks on the quiz test. Apart from this, you do not need to sit for any other assessments. Who is this course for? Business Process Management: Business Process Management Course Online This Business Process Management: Business Process Management Course is designed for anyone who wants to enhance their business process management skills. Requirements Business Process Management: Business Process Management Course Online To enrol in this Business Process Management: Business Process Management Course, students must fulfil the following requirements: Good Command over English language is mandatory to enrol in our Business Process Management: Business Process Management Course. Be energetic and self-motivated to complete our Business Process Management: Business Process Management Course. Basic computer Skill is required to complete our Business Process Management course. If you want to enrol in our Business Process Management course, you must be at least 15 years old. Career path Business Process Management: Business Process Management Course Online After completing this Business Process Management: Business Process Management Course, you may able to pursue a variety of promising career opportunities, such as: Business Process Manager Business Analyst Entrepreneur Business Owner