6041 Courses

The Executive Secretarial & PA Course is a wonderful learning opportunity for anyone who has a passion for this topic and is interested in enjoying a long career in the relevant industry. It's also for anyone who is already working in this field and looking to brush up their knowledge and boost their career with a recognised certification. This Executive Secretarial & PA Course consists of several modules that take around 11 hours to complete. The course is accompanied by instructional videos, helpful illustrations, how-to instructions and advice. The course is offered online at a very affordable price. That gives you the ability to study at your own pace in the comfort of your home. You can access the modules from anywhere and from any device. Why Choose this Course? Earn a digital 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 free of cost. Print copy by post is also available at an additional cost of £9.99 and PDF Certificate at £4.99. Course Content Module 1: Introduction to Personal Assistant Introduction to Personal Assistant 00:18:00 Module 2: Business Telephone Skills Business Telephone Skills 00:20:00 Module 3: Representing Your Boss and Company Representing Your Boss and Company 00:37:00 Module 4: Mail Services and Shipping Mail Services and Shipping 00:28:00 Module 5: Travel Arrangements Travel Arrangements 00:27:00 Module 6: Organising Meeting and Conferences Organising Meeting and Conferences 00:28:00 Module 7: Time Management Time Management 00:38:00 Module 8: Record Keeping and Filing Systems Record Keeping and Filing Systems 00:31:00 Module 9: Business Writing Skills Business Writing Skills 00:43:00 Module 10: Organisational Skills Organisational Skills 00:28:00 Module 11: Communication Skills Communication Skills 00:28:00 Module 12: Customer Service Customer Service 00:19:00 Module 13: Effective Planning and Scheduling Effective Planning and Scheduling 00:49:00 Module 14: Document Proofreading and Editing Document Proofreading and Editing 00:08:00 Module 15: Advanced MS Excel Excel: Top 50 Microsoft Excel Formulas in 50 Minutes! How to Get the most of the course 00:01:00 Text formulas in Excel 00:08:00 Text Formulas Exercise 00:01:00 Text Formulas Exercise (answers) 00:01:00 Mathematical Formulas In Excel 00:04:00 Mathematical Formulas Exercise 00:01:00 Mathematical Formulas Exercise (answers) 00:01:00 Date and Time Formulas In Excel 00:05:00 Date and Time Formulas Exercise 00:01:00 Date and Time Exercise Formulas (answers) 00:01:00 Logic Formulas In Excel 00:12:00 Logic Formula Exercise 00:01:00 Logic Formula Exercise (answers) 00:01:00 Financial Formula In Excel 00:06:00 Financial Formula Exercise 00:01:00 Financial Formula Exercise (answers) 00:02:00 Informational Formula In Excel 00:04:00 Informational Formula Exercise 00:01:00 Informational Formula Exercise (answers) 00:01:00 Getting Traffic To Your Site 01:00:00 VLOOKUP: Master Excel Formula VLOOKUP in 60 minutes! Menu Example with Excel Vlookup 00:08:00 Wildcard Search with Excel Vlookup 00:09:00 Looking to the Left with Excel Vlookup 00:17:00 2-Way Lookup 00:14:00 Comparing Lists with Excel Vlookup 00:03:00 Microsoft Excel Vlookup Tips and Tricks 00:14:00 Microsoft Excel: Master Power Query in 120 Minutes! Power Query Intro and Excel version 00:03:00 Excel Power Query - Introduction 00:03:00 Enabling M in Power Query 00:02:00 Transform Data - Trim in Excel Power Query 00:05:00 Transform Data - Format Dates and Values in Excel Power Query 00:02:00 Simple Expressions 00:08:00 Simple Expressions - Nested Expressions 00:03:00 Transform Data - Parsing URLs in Excel Power Query 00:05:00 Variables 00:06:00 Microsoft Excel Keyboard Shortcuts Formatting Excel Keyboard Shortcuts 00:02:00 Table Excel Keyboard Shortcuts 00:02:00 Editing Excel Keyboard Shortcuts 00:05:00 Formula Excel Keyboard Shortcuts 00:03:00 Workbook Excel Keyboard Shortcuts 00:02:00 Handy Excel Shortcuts Keyboard Shortcuts 00:05: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.

Bayfield Training and the University of Cambridge Department of Land Economy This prestigious eight-week online Real Estate course is suitable for modellers new to Real Estate and experienced Real Estate Analysts looking to formalise their skill set. This course will equip you with skills to start building your own financial models and the certificate will give your employers and colleagues reassurance of your expertise. If you want to enhance your financial modelling skills over an extended period, the Real Estate Financial Modelling Certificate is the course for you. This online real estate course has been put together exclusively for the Real Estate Financial Modelling certificate, using state of the art digital resources such as animations, video-steps, digital whiteboard and video-interactions as well as the spreadsheets, text based resources and tutor contact you would expect from any of Bayfield Training’s classroom based courses.  Assessment is in the form of a guided model build exercise and written model appraisal. Participants benefit from an additional months access to the course platform after submission of the assessment. On this course you will: Become a competent model builder, building Real Estate Financial Models from scratch Learn tricks and concepts from financial modelling experts with decades of experience in practice and academia Learn how to use Real Estate Financial Models to make informed investment decisions Learn at a consistent pace over 8 weeks allowing you to take the time to fully grasp this important skill This course is suitable for: Chartered Surveyors Asset Managers Financial Controllers Financial Analysts Investment Managers Property Managers Real Estate Students/Recent Graduates Course Outline: Module 1 - Economic Context Introduction to Real Estate Asset Modelling and how it relates to and is distinct from Econometric Models. Introduction to Real Estate Asset Modelling and how it relates to and is distinct from Econometric Models. Why Real Estate Asset Modelling is important Understanding the occupier, asset and development markets and the relevant modelling approaches for each Real Estate Sub-Sector Key Performance Indicators Introduction to conventional valuations and financial mathematics Understanding and minimising errors in Financial Models Module 2 - Cash Flow Fundamentals Constructing a financial model from first principles. Understanding all the components of a basic cash flow model Understand why Corporate Finance Models and Real Estate Models are different Financial Model Design Making the link between valuations, income mathematics and discounted cash flows Internal Rate of Return, Net Present Value,Worth and other metrics Features and techniques to aid fast model building Module 3 - Developing the Cash Flow Adapting financial models for different periodicities and building rent functions for different rent behaviour. Understanding how leases vary with respect to rent over time: Rent Reviews, Break Clauses, Rent Free Periods, Lease Expiries etc. Developing the concept of a Rent Function in Excel Logic mathematics and Logic functions Projecting rent to adapt to different lease contracts and growth patterns Alternative solutions to Logic functions Comparative analysis of lease structures in different jurisdictions and adapting financial models Module 4 - Real Estate Data Understanding the different sources of data, constructing basic time series models and recognising basic patterns. Key Property market indicators Characteristics and application of key input metrics for Real Estate Appraisals Understanding the eight components of Real Estate Price Dynamics Awareness of the different sources of data Reading and using general property market reports Constructing basic time series models and recognising basic patterns Module 5 - Development Appraisals Constructing a development appraisal from first principles and understanding development return metrics. Understanding the key components of a development project Understanding the difference between development and investment appraisals Residual Appraisals and Profit Calculations Cost orientated cash flows and phased sales Cumulative construction cost patterns: incidental, fixed, loaded and S-curve Development return metrics and Modified IRRs Module 6 - Multi-let Cash Flows Constructing an advanced multi-let cash flow model and learn different techniques to build flexible rent functions. Multi-let and portfolio model design principles Building complex date functions and date series The three multi-let rent projection techniques Perpendicular Rent Functions Incorporate advanced rent adjustments into the Rent Function Incorporate sector and period varying rental growth rates Simplifying OPEX and CAPEX projections Discounting techniques on complex and volatile cash flows Module 7 - Project Finance Constructing a flexible Real Estate Debt Finance model. Revision of the Mathematics of amortisation and debt finance Basic senior debt models and geared net cash flow LTV, IRR and Interest Rate Dynamics Flexible term, repayment options and deferred interest Loan covenant tests Understanding different tranches of debt Understanding how complex debt structures impact the returns to different parties Module 8 - Model Interpretation and Risk Analysis Learn how to read, analyse and report on real estate financial models. Understand how to read models and develop an investment narrative Visualise model outputs using graph functions, conditional formatting, dynamic symbols and dashboards Learn how to use built-in Sensitivity, Scenario Analysis tools and third-party add-ins Learn how to construct varied project scenarios in a systematic way Introduction to Monte Carlo Analysis and VBA Optimising sale dates and other parameters Create well written, attractive and persuasive reports Included in the Course Bayfield Training and University of Cambridge Accredited Certificate & LinkedIn Proficiency Badge 64 CPD Hours 1 Month Post-Course Access to the Digital Platform - 12 Months Post-Course Access to the Platform can be purchased for an additional fee Course Files Q&A Webinars and Guest Speaker Webinars Further Learning Resources (Reading, Files and Videos) Post Course Support - Two Months of Questions & Answers 2024 Cohort Dates Include: 3rd June to 29th July 5th August to 25th September 2024 30th September to 25th November For more information, please contact Sam on the Bayfield Training Sales team: E - s.musgrave@bayfieldtraining.com T - 01223 517851 W - www.bayfieldtraining.com

With our course 'Excel: Top 50 Microsoft Excel Formulas in 50 Minutes!' you can take a dynamic learning trip and advance your Excel skills to new levels. In just 50 minutes, unlock the secrets of Excel's most potent formulas, revolutionizing your approach to data manipulation and analysis. This isn't your average Excel tutorial; it's a fast-paced, immersive experience crafted to optimally utilize every minute of your learning journey. Dive into the intricacies of text, mathematical, date and time, logic, and financial formulas, demystifying their complexities with engaging exercises and comprehensive answers. Each module is strategically structured, ensuring you grasp the essence of Excel's powerhouse formulas efficiently. Whether you're a novice eager to conquer Excel or a seasoned user aiming to enhance your skills, this course offers a streamlined, time-efficient path to mastery. Learning Outcomes Text Formulas Proficiency: Master text manipulation with Excel, enhancing your ability to streamline and present information effectively. Mathematical Formula Mastery: Acquire a deep understanding of mathematical formulas, enabling you to perform complex calculations effortlessly. Date and Time Formula Expertise: Unlock the potential of Excel's date and time functions, facilitating precise chronological data management. Logic Formulas Competence: Develop proficiency in logic formulas, empowering you to create dynamic decision-making processes within your spreadsheets. Financial Formula Proficiency: Gain financial acumen by mastering Excel's financial formulas, essential for robust financial analysis and planning. Why choose this Excel: Top 50 Microsoft Excel Formulas in 50 Minutes! course? Unlimited access to the course for a lifetime. Opportunity to earn a certificate accredited by the CPD Quality Standards and CIQ after completing this course. Structured lesson planning in line with industry standards. Immerse yourself in innovative and captivating course materials and activities. Assessments designed to evaluate advanced cognitive abilities and skill proficiency. Flexibility to complete the Course at your own pace, on your own schedule. Receive full tutor support throughout the week, from Monday to Friday, to enhance your learning experience. Unlock career resources for CV improvement, interview readiness, and job success. Who is this Excel: Top 50 Microsoft Excel Formulas in 50 Minutes! course for? Individuals seeking to boost their Excel proficiency quickly. Students aiming to enhance their data manipulation skills. Professionals wanting to streamline their spreadsheet tasks efficiently. Entrepreneurs and small business owners looking to optimize data analysis. Anyone keen on mastering Excel's powerful formulas for personal or professional growth. Career path Data Analyst: £25,000 - £40,000 Financial Analyst: £30,000 - £50,000 Business Intelligence Specialist: £35,000 - £55,000 Project Manager: £40,000 - £60,000 Operations Manager: £45,000 - £70,000 Management Consultant: £50,000 - £80,000 Prerequisites This Excel: Top 50 Microsoft Excel Formulas in 50 Minutes! does not require you to have any prior qualifications or experience. You can just enrol and start learning. This Excel: Top 50 Microsoft Excel Formulas in 50 Minutes! was made by professionals and it is compatible with all PC's, Mac's, tablets and smartphones. You will be able to access the course from anywhere at any time as long as you have a good enough internet connection. Certification After studying the course materials, there will be a written assignment test which you can take at the end of the course. After successfully passing the test you will be able to claim the pdf certificate for £4.99 Original Hard Copy certificates need to be ordered at an additional cost of £8. Course Curriculum Excel: Top 50 Microsoft Excel Formulas in 50 Minutes! Excel promo 00:01:00 Getting the most of the course 00:01:00 How to Get the most of the course 00:01:00 Text formulas in Excel 00:08:00 Text Formulas Exercise 00:01:00 Text Formulas Exercise (answers) 00:01:00 Mathematical Formulas In Excel 00:04:00 Mathematical Formulas Exercise 00:01:00 Mathematical Formulas Exercise (answers) 00:01:00 Date and Time Formulas In Excel 00:06:00 Date and Time Formulas Exercise 00:01:00 Date and Time Exercise Formulas (answers) 00:01:00 Logic Formulas In Excel 00:12:00 Logic Formula Exercise 00:01:00 Logic Formula Exercise (answers) 00:01:00 Financial Formula In Excel 00:06:00 Financial Formula Exercise 00:01:00 Financial Formula Exercise (answers) 00:02:00 Informational Formula In Excel 00:04:00 Informational Formula Exercise 00:01:00 Informational Formula Exercise (answers) 00:01:00 Getting Traffic To Your Site 01:00:00 Additional Resources Resources : Excel: Top 50 Microsoft Excel Formulas in 50 Minutes! 00:00:00

The Fitness Instructor course is designed to provide a deep understanding of the scientific and theoretical aspects of fitness training. Starting with an introduction to the fundamental concepts of fitness training, this course guides you through the critical areas of anatomy and physiology, essential for any aspiring fitness professional.

This is an extensive course designed to provide an in-depth understanding of fitness and nutrition. The course is structured into eight modules, each focusing on different aspects of health and wellness.

We are all created from energy, as well as the objects we hold and the situations we are in, meaning that we are surrounded by both positive and negative energy. We all experience hard times and setbacks, but ignoring the negative energy that may keep resurfacing will greatly affect our relationships and balance, especially of our home. The negative things in our lives can easily take a massive toll on our mental health and emotional state without us even realizing it.  Cleansing our home from negative energies or simply from spirits that have lost their ways towards the light and need help in this transition (which is called "shamanic psychopomp") is a beautiful help we are providing to these souls to find their peace after death. I can assist you, as a shamanic practitioner, to take healing to your home or to any spirits that may be involved.  When is a house cleansing required? *Before moving to a new home, as we the property has surely energy blockages from previous experiences of the inhabitants, likely brought on by the challenges of life. *Any time we need to start a new project or phase in our life and we need to cut old energetic cords that bind us and our space to old happenings. *After personal difficulties or illness *If anyone at home is having problems sleeping. How is the cleansing done? Through incense, sound, light, mantras and a shamanic journey. And whatever my Spirit Allies guide me through my intuition.      By attending to our classes, workshops, 1 to 1 sessions and retreats you agree to our TERMS AND CONDITIONS Payment  Bookings are non-refundable.  Disclaimer  By booking a class or workshop or retreat or 1-1 session -online or any other venues – with us, you release Giada Gaslini, Invisible Caims/School of Shamanism from any liability arising out of any personal injuries, emotional or physical release, death, expectations of results, theft in the venue or damages that may happen to people and objects while attending. We recommend that you consult your GP regarding the suitability of undertaking an exercise programme, if the class you are booking includes it like with yoga or similar, and following all the safety instructions required before beginning to exercise. When participating in an exercise, there is the possibility of sustaining a physical injury. If you engage in this exercise programme, you agree that you do so at your own risk, are voluntarily participating in these activities and assume all risk of injury to yourself. You acknowledge that coaching, shamanic healing and counselling are not to be used as a substitute for psychotherapy, psychoanalysis, mental health care, or other professional advice by legal, medical or other professionals. Our sessions are aimed at inner research, problem solving and personal growth, they do not replace the work of doctors and psychotherapists because they do not consider, treat or aim to solve pathologies and symptoms that are strictly medical. All contracts subject to and governed by the law according to my current insurance.  

Do you struggle to stand up for yourself? Do you always tolerate people treating you badly in relationships? Do you find yourself in bad relationships constantly? Do you always hang on to people for fear of being on your own? This course is to help those who always end up being bullied and mistreated in relationships and struggle to set boundaries, exercise principles and self-value. This course will teach you how to: Correct unhealthy dating patterns Improve self-esteem Have more confidence Not be afraid to walk away from negative relationships Enforce boundaries when disrespected Build respect in relationships Enhance understanding and self-communication Recognise personal needs Pinpoint areas that are causing present issues https://relationshipsmdd.com/product/how-to-set-boundaries-package/

The all new NASM Women’s Fitness Specialization (NASM-WFS) will deliver your next step in fitness programming knowledge to meet the needs of your female clients. Whether it’s your own interest in the topic or wanting to better address the fitness needs of women, the NASM-WFS gives you the insights to confidently design safe and effective programming to support women on their fitness and health pursuits across various ages and life stages. Unlike other women’s fitness courses you may have encountered, the NASM-WFS is a comprehensive program that dives into the many health and fitness topics that women want to know more about – and do something positive about!

iscover the fascinating world of Python programming as you take your first steps into the realm of coding. This course is designed to ignite your passion for programming, providing a solid foundation for beginners. Get ready to unleash your creative potential in the world of technology.

The 'Linux Shell Scripting' course offers comprehensive training in shell scripting for Linux environments. From creating a local Linux shell scripting environment to network scripting and automation, learners will develop practical skills to automate tasks, process data, and improve efficiency using shell scripts. Learning Outcomes: Set up a local Linux shell scripting environment for practical learning. Create shell scripts for user and account management, including password generation and handling shell script arguments. Apply Linux programming conventions to maintain clear and efficient code. Develop shell scripts that parse command-line options for flexible user interaction. Utilize shell scripting for data processing, transformation, and reporting tasks. Automate network scripting and distributed systems for enhanced efficiency. Summarize the key concepts and techniques learned throughout the course. Access additional course extras and resources for further exploration and practice. Why buy this Linux Shell Scripting? Unlimited access to the course for forever Digital Certificate, Transcript, student ID all included in the price Absolutely no hidden fees Directly receive CPD accredited qualifications after course completion Receive one to one assistance on every weekday from professionals Immediately receive the PDF certificate after passing Receive the original copies of your certificate and transcript on the next working day Easily learn the skills and knowledge from the comfort of your home Certification After studying the course materials of the Linux Shell Scripting there will be a written assignment test which you can take either during or at the end of the course. After successfully passing the test you will be able to claim the pdf certificate for £5.99. Original Hard Copy certificates need to be ordered at an additional cost of £9.60. Who is this course for? This Linux Shell Scripting course is ideal for Students Recent graduates Job Seekers Anyone interested in this topic People already working in the relevant fields and want to polish their knowledge and skill. Prerequisites This Linux Shell Scripting does not require you to have any prior qualifications or experience. You can just enrol and start learning.This Linux Shell Scripting was made by professionals and it is compatible with all PC's, Mac's, tablets and smartphones. You will be able to access the course from anywhere at any time as long as you have a good enough internet connection. Career path As this course comes with multiple courses included as bonus, you will be able to pursue multiple occupations. This Linux Shell Scripting is a great way for you to gain multiple skills from the comfort of your home. Course Curriculum Unit 01: Course Introduction Introduction and Course Overview 00:02:00 Course Downloads 00:03:00 Unit 02: Creating a Local Linux Shell Scripting Environment Creating a Local Lab Environment Using Vagrant and VirtualBox - Background 00:16:00 Exercise 1 Instructions - Creating a Local Linux Shell Scripting Lab Environment 00:28:00 Exercise 1 - Walkthrough - Part I - Windows Users Only 00:04:00 Exercise 1 - Walkthrough - Part I - Mac Users Only 00:02:00 Exercise 1 - Walkthrough - Part I - Linux (CentOS/RHEL) Users Only 00:03:00 Exercise 1 - Walkthrough - Part II - All Users 00:23:00 Unit 03: User and Account Creation - Shell Scripting Project 1 Section Introduction 00:03:00 Getting Started with Shell Scripting: Naming, Permissions, Variables, Builtins. 00:35:00 Special Variables, Pseudocode, Command Substitution, if Statement, Conditionals. 00:23:00 Exit Statuses, Return Codes, String Test Conditionals, More Special Variables. 00:18:00 Reading Standard Input, Creating Accounts, Username Conventions, More Quoting. 00:23:00 Exercise 2 - Instructions 00:12:00 Exercise 2 - Walkthrough 00:21:00 Unit 04: Password Generation and Shell Script Arguments - Shell Scripting Project 2 Random Data, Cryptographic Hash Functions, Text and String Manipulation. 00:31:00 Positional Parameters, Arguments, for Loops, Special Parameters 00:30:00 The while Loop, Infinite Loops, Shifting, Sleeping 00:16:00 Exercise 3 - Instructions 00:12:00 Exercise 3 - Walkthrough 00:20:00 Unit 05: Linux Programming Conventions - Shell Scripting Project 3 Advanced Standard Input, Standard Output, and Standard Error - Part I 00:13:00 Advanced Standard Input, Standard Output, and Standard Error - Part II 00:26:00 Exercise 4 - Instructions 00:05:00 Exercise 4 - Walkthrough 00:12:00 Unit 06: Parsing Command Line Options - Shell Scripting Project 4 Case Statements 00:20:00 Functions 00:33:00 Parsing Command Line Options with getopts, Part 1 00:20:00 Parsing Command Line Options with getopts, Part 2 00:18:00 Deleting and Disabling Linux Accounts, Part 1 of 4 (Finding Files) 00:11:00 Deleting and Disabling Linux Accounts, Part 2 of 4 (The userdel command) 00:05:00 Deleting and Disabling Linux Accounts, Part 3 of 4 (Archives with tar) 00:14:00 Deleting and Disabling Linux Accounts, Part 4 of 4 (Disabling Accounts) 00:08:00 Deleting Users - Exercise 5 - Instructions 00:14:00 Deleting Users - Exercise 5 - Walkthrough 00:33:00 Unit 07: Transforming Data / Data Processing / Reporting - Shell Scripting Project 5 Cut and Awk 00:22:00 Cut and Awk Demonstration Script: Open Network Ports 00:10:00 Sort and Uniq 00:18:00 Parsing Log Files - Exercise 6 - Walkthrough 00:15:00 Sed 00:29:00 Unit 08: Network Scripting & Automation of Distributed Systems: Shell Scripting Project 6 Configuring a Mini Network and Scripting for Remote Systems 00:30:00 Scripting Remote Commands - Walkthrough - Part 1 00:26:00 Scripting Remote Commands - Exercise - Instructions 00:12:00 Scripting Remote Commands - Walkthrough - Part 2 00:13:00 Unit 09: Course Summary Summary 00:08:00 Unit 10: Course Extras What Shell Scripting Is and Why You Should Learn It 00:10:00 Resources Resources - Linux Shell Scripting 00:00:00 Assignment Assignment - Linux Shell Scripting 00:00:00