20525 Courses

Mentoring skills refer to the abilities needed to guide someone’s personal or professional development. Mentorship skills include active listening, providing constructive feedback, and offering guidance. Mentoring skills help individuals develop their professional skills and achieve their goals. They create the right environment for growth such as fostering safety and trust. Effective mentors provide guidance, support, and feedback to their mentees. This helps mentees navigate challenges and make progress in their careers

Course Objectives At the end of this course you will be able to: Work with advanced lookup and reference functions Create macros to automate common tasks Use advanced techniques to analyse data Create PivotTables and PivotCharts Work with data validation tools Import and export data ' Customer Feedback Best Training Ever! Just finished a bespoke 1-1 training course in Excel Advanced, Macros & VBA. Pedro is an excellent trainer, imparting his skills and knowledge in the best way - appropriately to audience skills, knowledge and ability. Pedro is always approachable, encouraging and supportive, giving delegates the optimum learning environment. I would not hesitate to recommend Pedro as a trainer, whatever your level of ability. Amanda Morris - Treasury & Systems Accountant at Reall - Real Equity for All The course was very interesting and engaging and will definitely be put to use. The trainer was very helpful and charismatic. Marving Lopez - AM Best Europe Pedro was excellent. Very knowledgeable, clear and great rapport with class. Darren Barkey - Direct Wines Great content and learnt a lot. Really enjoyable :) Kristie-Lee Ryan - Stirling Ackroyd 1 year email support service Take a closer look at the consistent excellent feedback from our growing corporate clients visiting our site ms-officetraining co uk 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. Please visit our site (ms-officetraining co uk) to get a feel of the excellent feedback our courses have had and look at other courses you might be interested in. Advanced Functions COUNT, COUNTA, COUNTIF, COUNTBLANK, SUMIF, SUBTOTAL IF, OR, AND, IFERROR VLOOKUP to lookup Exact Values and Approximate values MATCH, INDIRECT, ROW/COLUMN, INDEX, OFFSET Analysing Data PMT function to calculate a monthly payment of a loan What If Analysis using Goal Seek Use scenarios to consider many different variables Using Solver Add-in to optimize variables PivotTables Create a PivotTable to analyse worksheet data Add or remove fields in a PivotTable Change the data source for a PivotTable Working with external data sources Using different Statistical Functions Calculate a Running Total, % of Grant Total, Difference From… Using the Slicer and Timeline to filter the PivotTable Using Filters in a PivotTable Group by Date, Auto Group by ranges of values, Custom Group Create a PivotChart The GETPIVOTDATA function Formula auditing Precedents and dependents Error checking Watch a formula and its result by using the Watch Window Evaluate a nested formula one step at a time Data Validation Number Validation Data List Validation Message Prompts and Alerts Conditional Data Validation Data Validation Errors Consolidation Consolidate data by position Consolidate data by category Use a formula to consolidate data Outline (group) data in a worksheet Create an outline of rows Create an outline of columns Copy outlined data Hide or remove an outline Connect external data to your workbook Using the Power Query Editor to import data From Text and CSV, From Access, From Web, From another Workbook Using the Power Query Editor to; Transform your data by Selecting which fields to import, by Splitting Columns, Changing Data Type and more. Deleting Applied Steps Refreshing your data Working with Form Controls; Buttons, Option Buttons and Scroll Bars Introduction to Macros Change Macro Security settings How to Record a macro Some Macro Examples Delete a macro Edit the macro to view the VBA code Copy part of a macro to create another macro Assign a macro to a button Who is this course for? Who is this course for? This course is intended to end users who want to develop their skills so they can use advanced techniques to analyse extensive and complex datasets in Excel and to automate simple tasks with the use of Macros. Requirements Requirements Preferably, delegates should have attended the Excel Intermediate course. Career path Career path Excel 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

Sharpen your HTML, CSS, and JavaScript by working on a large variety of projects. In this course, we'll be working through a project a day using vanilla JavaScript. Over the next 50 days, you'll have 50 small, unique, DOM-oriented projects under your belt.

Turn yourself into the linchpin of highly organised data and a facilitator of streamlined processes. Learn about Using Excel's Flash Fill and Autofill to Automate Data Entry.

Why Choose AutoCAD Architecture Training Classes? Course info Master architectural design tools and workflows. Create precise floor plans, elevations, and sections. Utilize BIM for intelligent 3D modeling. Access recorded lessons and lifetime email support. Enroll for in-person or online sessions. Duration: 16 hrs. Method: 1-on-1, Personalized attention. Schedule: Tailor your own schedule by pre-booking a convenient hour of your choice, available from Mon to Sat between 9 am and 7 pm. AutoCAD Architecture 3D Course Outline: Introduction to AutoCAD Architecture Understanding the difference between AutoCAD Architecture and AutoCAD LT Familiarization with the user interface and 3D viewing Wall Construction and Modification Adding walls to the model Creating curtain walls for specialized designs Modifying walls to fit specific requirements Joining walls together to form complex structures Adding and modifying wall openings for doors and windows Ceiling Plans (Reflected) Creating ceiling grids and construction detailing Modifying ceiling grids to match design needs Inserting ceiling fixtures and construction detailing Structural Design and Analysis Working with structural members and online resources Creating column grids and detailing columns Modifying column grids and annotations Annotating column grids and detailing for clarity Stairs Creating stairs in the model Modifying stairs to suit design specifications Adding railings to stairs and construction detailing Modifying railings and construction detailing Floors and Slabs Creating floor slabs and construction detailing Modifying floor slabs to align with the design Editing slabs using Slab Tools and construction detailing Roofs and Construction Detailing of Roofs Creating roofs for the building Designing roof slabs for specific areas Modifying roofs and roof slabs as needed Using Roof Slab Tools for precise detailing Annotation Detail drawing for scale and annotation Adding text, leaders, and comments to the model Dimensioning in AutoCAD Architecture for accurate measurements Utilizing other annotation tools for clarity Equipment and Furnishings Adding interior and exterior furnishings to the design Incorporating blocks and online 3D models for realistic representations Utilizing Tool Palettes and Autodesk Seek resources Model Views Ready for Print PDF Creating callouts for specific views Designing elevations, sections, and construction detailing Modifying callout objects for better visualization Implementing live sections and elevations Generating reports and managing project resources Schedules Adding door and window labels to the model Editing label data for accuracy Creating schedules for better project management Modifying schedules to suit specific requirements This AutoCAD Architecture 3D course covers a comprehensive range of topics, providing participants with the skills to create detailed 3D architectural models, implement construction detailing, and manage project resources efficiently. The course enables participants to produce professional-grade architectural designs using AutoCAD Architecture software.

Elevate your skills with Energy Edge's classroom training on CSOV and WIV charterparty management. Learn essential maritime laws and enhance your professional journey.

The Greek Online School Immersion Course for adults is back! In Summer 2023 we will learn Greek in the historic Anargyrios & Korgialenios School of Spetses!

Course Overview Do you want to familiarize with various programming structure and build your career as a software engineer? Then this course is perfect for you. Learn how you can use HTML CSS my SQL GitHub XAMPP and Heroku from this Modern PHP/MYSQL/ GitHub & Heroku Tutorial course and boost your programming skill in no time. This Modern PHP/MYSQL/ GitHub & Heroku Tutorial course will teach you the function of different platforms of web development. You will learn about PHP, bootstrap, MySQL, GitHub and Heroku. The lessons will help you understand programming structures from scratch and explore different areas of web development. The activities of the course will help you to practice the knowledge you learn and enhance your skill. You'll be able to work and create sample websites with the lectures.  You'll receive certifications after completing the course. This course can be a stepping stone for you to enhance your skill and be a professional web developer. Learning Outcomes Understand how XAMPP works Familiarize with the role of PHP in web-based programs Setup Apache server and PHP environment using XAMPP server Learn how to use GitHub Be able to build data-driven and dynamic web applications Learn how to deploy web applications using Heroku Learn the basics of bootstrap 4 Who is this course for? This course is a complete package of the database, PHP, Bootstrap and GitHub. This is ideal for anyone who wants to learn software designing and its steps. The course will teach you the necessary skills and knowledge you need for software development from scratch. 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 Modern PHP/MYSQL/ GitHub & Heroku Tutorial Course is a useful qualification to possess and would be beneficial for any related profession or industry such as: Web Developers Web Designers Software Developers PHP Developers App Designers Unit 01: Introduction Introduction 00:06:00 Unit 02: Environment Configuration Module 01: Setup a PHP Environment using XAMPP 00:16:00 Module 02: Install Composer Package Manager 00:03:00 Module 03: Visual Studio Code - Web Development Add ons 00:12:00 Module 04: Create a GitHub Account 00:13:00 Module 05: Create a Heroku Account 00:08:00 Unit 03: PHP Basics and Syntax Module 01: How PHP Works 00:29:00 Module 02: IFELSE Statements 00:19:00 Module 03: Switch Statements 00:09:00 Module 04: FOR Loop 00:10:00 Module 05: WHILE AND DOWHILE Loops 00:14:00 Module 06: PHP Arrays and Manipulation 00:13:00 Module 07: String Manipulation Functions 00:28:00 Module 08: Date and Time Manipulation Functions 00:15:00 Module 09: User Defined Functions 00:22:00 Module 10: PHP Include and Require 00:22:00 Module 11: PHP Website Layout - With Bootstra 00:23:00 Module 12: Add Project to Github 00:08:00 Module 13: Publish Website to Heroku 00:20:00 Unit 04: PHP Forms and MySQL and User Authentication Module 01: Project and Website Setup 00:21:00 Module 02: Create a Bootstrap 4 Form 00:28:00 Module 03: PHP Form - $_GET Action 00:23:00 Module 04: PHP Form - $_POST Action 00:11:00 Module 05: Design Database with phpMyAdmin 00:19:00 Module 06: Connect to Database using PHP PDO 00:18:00 Module 07: Save Records to Database 00:38:00 Module 08: View Database Records 00:36:00 Module 09: View One Record's Details 00:28:00 Module 10: Update Database Records 00:34:00 Module 11: Delete Database Records 00:11:00 Module 12: Final Touches: Form Validation, Error Messages, Success Messages 00:17:00 Module 13: Create Heroku App and Remote Database 00:21:00 Module 14: Setup Authentication Tables in Database 00:20:00 Module 15: Setup Login and Authentication 00:29:00 Module 16: Control User Access 00:08:00 Module 17: Sending Confirmation Emails 00:31:00 Module 18: Upload Profile Pictures 00:31:00 Module 19: Final Touches 00:14:00 Resources Resources - Modern PHP/MYSQL/ GitHub & Heroku Tutorial 00:00:00 Certificate and Transcript Order Your Certificates and Transcripts 00:00:00

Description Bridge Funnel is pretty helpful for affiliate or network marketers who don't control the pages they are sending their visitors to when they are ready to sign up. This course will help you understand how to structure your sales funnel and each page internally that will enable you to make more money from the same traffic that you get now. With the help of this course, learn some practical methods and create a culture of buyers for your company. Learn how to communicate and socially connect with your customers and offer them more valuable services in return for more profit. Grasp all the essential areas that you need to know about Bridge Funnel with one particular course entitled Bridge Funnel Training. Assessment: This course does not involve any MCQ test. Students need to answer assignment questions to complete the course, the answers will be in the form of written work in pdf or word. Students can write the answers in their own time. Once the answers are submitted, the instructor will check and assess the work. Certification: After completing and passing the course successfully, you will be able to obtain an Accredited Certificate of Achievement. Certificates can be obtained either in hard copy at a cost of £39 or in PDF format at a cost of £24. Who is this Course for? Bridge Funnel Training is certified by CPD Qualifications Standards and CiQ. 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 background. Requirements Our Bridge Funnel Training 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 After completing this course you will be able to build up accurate knowledge and skills with proper confidence to enrich yourself and brighten up your career in the relevant job market. Module : 01 Introduction FREE 00:01:00 What is a Sales Funnel 00:06:00 OTOs and Overviews 00:09:00 Squeeze Page Secrets 00:12:00 My Squeeze Page Example 00:05:00 Bridge Page Secrets 00:12:00 Front-End Overview 00:12:00 The Order Form Bump 00:08:00 Module : 02 WWWH Script 00:04:00 Star Story Solution Script 00:17:00 Upsell Page 00:05:00 Creating Your Upsells 00:10:00 OTO Script 00:09:00 Why Email Everyday 00:03:00 Soap Opera Sequence 00:13:00 Seinfeld Email Sequence 00:11:00 Order Your Certificate and Transcript Order Your Certificates and Transcripts 00:00:00

Understand why it is difficult for us to accept changes when they occur - both in our personal and professional lives. Outline the emotional stages of the change curve which maps out distinct stages all individuals go through after a change, and learn to utilise a range of strategies to cope with changes.