• Professional Development
  • Medicine & Nursing
  • Arts & Crafts
  • Health & Wellbeing
  • Personal Development

15713 Courses

SQL NoSQL Big Data and Hadoop

4.9(27)

By Apex Learning

Overview This comprehensive course on SQL NoSQL Big Data and Hadoop will deepen your understanding on this topic. After successful completion of this course you can acquire the required skills in this sector. This SQL NoSQL Big Data and Hadoop comes with accredited certification from CPD, which will enhance your CV and make you worthy in the job market. So enrol in this course today to fast track your career ladder. How will I get my certificate? At the end of the course there will be an online written test, which you can take either during or after the course. After successfully completing the test you will be able to order your certificate, these are included in the price. Who is This course for? There is no experience or previous qualifications required for enrolment on this SQL NoSQL Big Data and Hadoop. It is available to all students, of all academic backgrounds. Requirements Our SQL NoSQL Big Data and Hadoop is fully compatible with PC's, Mac's, Laptop, Tablet and Smartphone devices. This course has been designed to be fully compatible with tablets and smartphones so you can access your course on Wi-Fi, 3G or 4G. There is no time limit for completing this course, it can be studied in your own time at your own pace. Career Path Learning this new skill will help you to advance in your career. It will diversify your job options and help you develop new techniques to keep up with the fast-changing world. This skillset will help you to- Open doors of opportunities Increase your adaptability Keep you relevant Boost confidence And much more! Course Curriculum 14 sections • 130 lectures • 22:34:00 total length •Introduction: 00:07:00 •Building a Data-driven Organization - Introduction: 00:04:00 •Data Engineering: 00:06:00 •Learning Environment & Course Material: 00:04:00 •Movielens Dataset: 00:03:00 •Introduction to Relational Databases: 00:09:00 •SQL: 00:05:00 •Movielens Relational Model: 00:15:00 •Movielens Relational Model: Normalization vs Denormalization: 00:16:00 •MySQL: 00:05:00 •Movielens in MySQL: Database import: 00:06:00 •OLTP in RDBMS: CRUD Applications: 00:17:00 •Indexes: 00:16:00 •Data Warehousing: 00:15:00 •Analytical Processing: 00:17:00 •Transaction Logs: 00:06:00 •Relational Databases - Wrap Up: 00:03:00 •Distributed Databases: 00:07:00 •CAP Theorem: 00:10:00 •BASE: 00:07:00 •Other Classifications: 00:07:00 •Introduction to KV Stores: 00:02:00 •Redis: 00:04:00 •Install Redis: 00:07:00 •Time Complexity of Algorithm: 00:05:00 •Data Structures in Redis : Key & String: 00:20:00 •Data Structures in Redis II : Hash & List: 00:18:00 •Data structures in Redis III : Set & Sorted Set: 00:21:00 •Data structures in Redis IV : Geo & HyperLogLog: 00:11:00 •Data structures in Redis V : Pubsub & Transaction: 00:08:00 •Modelling Movielens in Redis: 00:11:00 •Redis Example in Application: 00:29:00 •KV Stores: Wrap Up: 00:02:00 •Introduction to Document-Oriented Databases: 00:05:00 •MongoDB: 00:04:00 •MongoDB Installation: 00:02:00 •Movielens in MongoDB: 00:13:00 •Movielens in MongoDB: Normalization vs Denormalization: 00:11:00 •Movielens in MongoDB: Implementation: 00:10:00 •CRUD Operations in MongoDB: 00:13:00 •Indexes: 00:16:00 •MongoDB Aggregation Query - MapReduce function: 00:09:00 •MongoDB Aggregation Query - Aggregation Framework: 00:16:00 •Demo: MySQL vs MongoDB. Modeling with Spark: 00:02:00 •Document Stores: Wrap Up: 00:03:00 •Introduction to Search Engine Stores: 00:05:00 •Elasticsearch: 00:09:00 •Basic Terms Concepts and Description: 00:13:00 •Movielens in Elastisearch: 00:12:00 •CRUD in Elasticsearch: 00:15:00 •Search Queries in Elasticsearch: 00:23:00 •Aggregation Queries in Elasticsearch: 00:23:00 •The Elastic Stack (ELK): 00:12:00 •Use case: UFO Sighting in ElasticSearch: 00:29:00 •Search Engines: Wrap Up: 00:04:00 •Introduction to Columnar databases: 00:06:00 •HBase: 00:07:00 •HBase Architecture: 00:09:00 •HBase Installation: 00:09:00 •Apache Zookeeper: 00:06:00 •Movielens Data in HBase: 00:17:00 •Performing CRUD in HBase: 00:24:00 •SQL on HBase - Apache Phoenix: 00:14:00 •SQL on HBase - Apache Phoenix - Movielens: 00:10:00 •Demo : GeoLife GPS Trajectories: 00:02:00 •Wide Column Store: Wrap Up: 00:05:00 •Introduction to Time Series: 00:09:00 •InfluxDB: 00:03:00 •InfluxDB Installation: 00:07:00 •InfluxDB Data Model: 00:07:00 •Data manipulation in InfluxDB: 00:17:00 •TICK Stack I: 00:12:00 •TICK Stack II: 00:23:00 •Time Series Databases: Wrap Up: 00:04:00 •Introduction to Graph Databases: 00:05:00 •Modelling in Graph: 00:14:00 •Modelling Movielens as a Graph: 00:10:00 •Neo4J: 00:04:00 •Neo4J installation: 00:08:00 •Cypher: 00:12:00 •Cypher II: 00:19:00 •Movielens in Neo4J: Data Import: 00:17:00 •Movielens in Neo4J: Spring Application: 00:12:00 •Data Analysis in Graph Databases: 00:05:00 •Examples of Graph Algorithms in Neo4J: 00:18:00 •Graph Databases: Wrap Up: 00:07:00 •Introduction to Big Data With Apache Hadoop: 00:06:00 •Big Data Storage in Hadoop (HDFS): 00:16:00 •Big Data Processing : YARN: 00:11:00 •Installation: 00:13:00 •Data Processing in Hadoop (MapReduce): 00:14:00 •Examples in MapReduce: 00:25:00 •Data Processing in Hadoop (Pig): 00:12:00 •Examples in Pig: 00:21:00 •Data Processing in Hadoop (Spark): 00:23:00 •Examples in Spark: 00:23:00 •Data Analytics with Apache Spark: 00:09:00 •Data Compression: 00:06:00 •Data serialization and storage formats: 00:20:00 •Hadoop: Wrap Up: 00:07:00 •Introduction Big Data SQL Engines: 00:03:00 •Apache Hive: 00:10:00 •Apache Hive : Demonstration: 00:20:00 •MPP SQL-on-Hadoop: Introduction: 00:03:00 •Impala: 00:06:00 •Impala : Demonstration: 00:18:00 •PrestoDB: 00:13:00 •PrestoDB : Demonstration: 00:14:00 •SQL-on-Hadoop: Wrap Up: 00:02:00 •Data Architectures: 00:05:00 •Introduction to Distributed Commit Logs: 00:07:00 •Apache Kafka: 00:03:00 •Confluent Platform Installation: 00:10:00 •Data Modeling in Kafka I: 00:13:00 •Data Modeling in Kafka II: 00:15:00 •Data Generation for Testing: 00:09:00 •Use case: Toll fee Collection: 00:04:00 •Stream processing: 00:11:00 •Stream Processing II with Stream + Connect APIs: 00:19:00 •Example: Kafka Streams: 00:15:00 •KSQL : Streaming Processing in SQL: 00:04:00 •KSQL: Example: 00:14:00 •Demonstration: NYC Taxi and Fares: 00:01:00 •Streaming: Wrap Up: 00:02:00 •Database Polyglot: 00:04:00 •Extending your knowledge: 00:08:00 •Data Visualization: 00:11:00 •Building a Data-driven Organization - Conclusion: 00:07:00 •Conclusion: 00:03:00 •Assignment -SQL NoSQL Big Data and Hadoop: 00:00:00

SQL NoSQL Big Data and Hadoop
Delivered Online On Demand22 hours 34 minutes
£12

Oracle Primavera P6 PPM Professional Advanced Features

By Packt

With an emphasis on intermediate-level abilities, this course covers Oracle Primavera Project Manager P6 PPM Professional Client's advanced features. The tool's database administration and setup instructions are also included. Upgrade your skills in Oracle Primavera Project Manager P6 PPM Professional Client with this advanced course.

Oracle Primavera P6 PPM Professional Advanced Features
Delivered Online On Demand5 hours 32 minutes
£33.99

Level 5 Diploma in Good Manufacturing Practice (GMP) - QLS Endorsed

4.7(47)

By Academy for Health and Fitness

24-Hour Knowledge Knockdown! Prices Reduced Like Never Before Did you know that over 20% of UK product recalls are due to manufacturing non-compliance? Are you passionate about ensuring quality and safety in production processes? Are you equipped with the skills to thrive in this dynamic industry? This bundle combines essential courses in Manufacturing, Good Manufacturing Practice (GMP), and Product Management to give you a well-rounded understanding of bringing high-quality products to market. This Good Manufacturing Practice Bundle equips you with the knowledge and skills to excel across the manufacturing value chain. You'll gain insights into modern manufacturing practices, ensuring efficient production processes. Learn the fundamentals of Good Manufacturing Practice (GMP) to guarantee product quality and regulatory compliance. Master product management principles to develop, launch, and manage successful products that meet customer needs. This Good Manufacturing Practice at QLS Level 5 course is endorsed by The Quality Licence Scheme and accredited by CPD QS (with 150 CPD points) to make your skill development & career progression more accessible than ever! With a single payment, you will gain access to Good Manufacturing Practice course, including 10 premium courses, a QLS Endorsed Hardcopy certificate (for the title course) and 11 PDF certificates for Absolutely free. This Good Manufacturing Practice (GMP) Bundle Package includes: Main Course : Diploma in Good Manufacturing Practice (GMP) at QLS Level 5 10 Additional CPD Accredited Premium Courses related to Manufacturing: Course 01: Modern Manufacturing Course 02: Product Management Course 03: Retail Management Skills Course 04: SAP Controlling (CO) - Product Costing S4HANA Course 05: Operations Management: Process Mapping & Supply Chain Course 06: Certificate in Purchasing and Procurement Course 07: Quality Assurance Course 08: Warehouse Safety Course 09: Import/Export Course 10: Business Law & Commercial Law Enrol today and take a significant step towards a rewarding career in Manufacturing & Product Management! Learning Outcomes of Good Manufacturing Practice (GMP) Master Good Manufacturing Practices (GMP) and quality assurance principles. Understand modern manufacturing techniques and product lifecycle management. Implement effective operations management and supply chain optimization. Ensure regulatory compliance and adhere to industry standards. Develop expertise in purchasing, procurement, and warehouse safety. Gain insights into product costing, retail strategies, and business law. Why Choose Us? Get a Free QLS Endorsed Certificate upon completion of Good Manufacturing Practice Get a free student ID card with Good Manufacturing Practice Training program (£10 postal charge will be applicable for international delivery) The Good Manufacturing Practice is affordable and simple to understand This course is entirely online, interactive lesson with voiceover audio Get Lifetime access to the Good Manufacturing Practice course materials The Good Manufacturing Practice comes with 24/7 tutor support Start your learning journey straightaway! *** Course Curriculum *** Main Course : Diploma in Good Manufacturing Practice (GMP) at QLS Level 5 Module 01: Basic Concept Of GMP And Safety Regulations Module 02: Good And Bad Manufacturing Practice Module 03: Preventing And Controlling Contamination Module 04: Maintenance And Hygiene Module 05: GMP For Pharmaceutical Industry Module 06: GMP For Food Industry Module 07: GMP For Cosmetics Industry Module 08: IT Applications On GMP Course 01: Modern Manufacturing Section 01: Introduction Section 02: Electric Discharge Machining Section 03: Electrochemical Machining Section 04: Abrasive Jet Machining Section 05: Ultrasonic Machining Section 06: Laser Beam Machining Section 07: Plasma Arc Machining Section 08: Electron Beam Machining Section 09: The Finish Line Course 02: Product Management Module 01: Introduction To Product Management Module 02: Product Classification Module 03: Developing The Product Plan Module 04: New Product Development Module 05: Levels Of A Product And Product Life Cycle Module 06: Product Pricing Strategy Module 07: Product And Brand Portfolio Analysis Module 08: Channels Management Module 09: Basics Of Marketing For Products Module 10: Financial Analysis For Product Management =========>>>>> And 8 More Courses <<<<<========= How will I get my Certificate? After successfully completing the course, you will be able to order your QLS Endorsed Certificates and CPD Accredited Certificates as proof of your achievement. PDF Certificate: Free (Previously it was £12.99*11 = £143) QLS Endorsed Hard Copy Certificate: Free (For The Title Course: Previously it was £119) CPD 255 CPD hours / points Accredited by CPD Quality Standards Who is this course for? This Manufacturing & Good Manufacturing Practice (GMP) bundle is suitable for Manufacturing Professionals Retail Managers Product Managers SAP Consultants Requirements You will not need any prior background or expertise. Career path This Good Manufacturing Practice (GMP) bundle will allow you to kickstart or take your career in the following sectors: Manufacturing Manager: £35,000 - £80,000 Product Manager: £40,000 - £100,000 Retail Operations Manager: £30,000 - £60,000 SAP Consultant: £45,000 - £100,000 Visual Merchandiser: £20,000 - £40,000 Quality Assurance Manager (GMP): £30,000 - £70,000 Certificates CPD Accredited Digital Certificate Digital certificate - Included Upon passing the Course, you need to order a Digital Certificate for each of the courses inside this bundle as proof of your new skills that are accredited by CPD QS for Free. Diploma in Good Manufacturing Practice (GMP) at QLS Level 5 Hard copy certificate - Included Please note that International students have to pay an additional £10 as a shipment fee.

Level 5 Diploma in Good Manufacturing Practice (GMP) - QLS Endorsed
Delivered Online On Demand44 hours
£105

VAT Bookkeeping Course Online

By Osborne Training

Overview Knowledge of how to prepare and submit VAT Return can help you to stand out from the crowd of job seekers. Moreover, if you are running a business or thinking of running a business, the vat training course will help you to understand the issues relating to vat more clearly and help process VAT Return more accurately and efficiently. Our VAT Training courses are eligible CPD Training for accountants and attending this course can give you a more detailed understanding of how to do a VAT return correctly. What is VAT Return? Almost every business has to submit a VAT Return. VAT Return contains Output VAT and Input VAT information to be submitted to Taxman (HMRC). Through the VAT return, HMRC knows exactly how much the business owes to HMRC. Moreover, HMRC can pay back any VAT amount overpaid which only can be determined through an accurate VAT return. How to do VAT Return Firstly, businesses need to register with HMRC before they can process a VAT Return. Businesses must fulfil the criteria to become VAT registered and to get a VAT Registration no. Once the business is registered they can then regularly submit the VAT return using specified VAT forms. There are many VAT Schemes available in general. There are some specialised VAT schemes available only for specific industries. Understanding VAT Principles Analysis of different VAT Scheme Preparing VAT in Spreadsheet Reconciliation of VAT Completing a VAT return Import and Export VAT analysis Calculating VAT for a business with mixed zero-rated and standard-rated sales, using Spreadsheet Introduction of TOMS (Tour Operator Margin Scheme) Submission Steps of VAT Return to HMRC Introduction to Making Tax Digital(VAT) scheme

VAT Bookkeeping Course Online
Delivered OnlineFlexible Dates
Price on Enquiry

VAT Accounting, Preparation and Submission Training Course

By Osborne Training

VAT Accounting, Preparation and Submission Training Course Overview: Knowledge of how to prepare and submit VAT Return can help you to stand out from the crowd of job seekers. Moreover, if you are running a business or thinking of running a business, the vat training course will help you to understand the issues relating to vat more clearly and help process VAT Return more accurately and efficiently. Our VAT Training courses are eligible CPD Training for accountants and attending this course can give you a more detailed understanding of how to do a VAT return correctly. What is VAT Return? Almost every business has to submit a VAT Return. VAT Return contains Output VAT and Input VAT information to be submitted to Taxman (HMRC). Through the VAT return, HMRC knows exactly how much the business owes to HMRC. Moreover, HMRC can pay back any VAT amount overpaid which only can be determined through an accurate VAT return. How to do VAT Return Firstly, businesses need to register with HMRC before they can process a VAT Return. Businesses must fulfil the criteria to become VAT registered and to get a VAT Registration no. Once the business is registered they can then regularly submit the VAT return using specified VAT forms. There are many VAT Schemes available in general. There are some specialised VAT schemes available only for specific industries. Certificate of Attendance Understanding VAT Principles Analysis of different VAT Scheme Preparing VAT in Spreadsheet Reconciliation of VAT Completing a VAT return Import and Export VAT analysis Calculating VAT for a business with mixed zero-rated and standard-rated sales, using Spreadsheet Introduction of TOMS (Tour Operator Margin Scheme) Submission Steps of VAT Return to HMRC Introduction to Making Tax Digital(VAT) scheme

VAT Accounting, Preparation and Submission Training Course
Delivered OnlineFlexible Dates
Price on Enquiry

SketchUp Course With Layout and V-Ray

By ATL Autocad Training London

Why Opt for SketchUp Course With Layout and V-Ray? Learn SketchUp with Layout and V-Ray for professional 3D modeling, detailed modeling, and high-quality rendering. Essential for architects and designers for creating visualizations and precise presentations. Check our Website When can I Enrol? 1-on-1 training. Mon to Sat 9 am and 7 pm Book over the Phone 02077202581. Training Duration: 10 hours. You have the flexibility to split these hours over multiple days. Training Method: In-person or live online. Course Outline: SketchUp, Layout, and V-Ray - 10-Hour Training Module 1: Introduction to SketchUp (1 Hour) SketchUp Interface: Explore the basics of the SketchUp user interface. Navigation and View Tools: Learn how to navigate and manipulate 3D space. Module 2: SketchUp Fundamentals (1 Hour) Drawing and Modeling: Begin creating 3D objects and structures. Editing Tools: Manipulate and modify objects efficiently. Module 3: Advanced SketchUp Techniques (1 Hour) Components and Groups: Understand component and group organization. Layers and Scenes: Organize your model and create dynamic views. Module 4: SketchUp for Architectural Design (1 Hour) Architectural Modeling: Explore architectural modeling techniques. Interior Design: Apply SketchUp to interior space design. Module 5: Landscape Design with SketchUp (1 Hour) Landscape Modeling: Use SketchUp for outdoor environment design. Terrain and Topography: Model terrain and natural landscapes. Module 6: Introduction to Layout (1 Hour) Layout Basics: Get familiar with the Layout interface. Setting Up Viewports: Begin using viewports for presenting your SketchUp models. Module 7: Creating Layout Documents (2 Hours) Document Setup: Set up and customize your layout documents. Inserting SketchUp Models: Import SketchUp models into Layout viewports. Dimensioning and Labeling: Add dimensions and labels to your layout documents. Module 8: Presentation and Export (1 Hour) Styling and Rendering: Enhance your SketchUp models for presentations. Exporting and Printing: Learn how to export and print your Layout documents. Module 9: Introduction to V-Ray (1 Hour) V-Ray Interface: Get acquainted with the V-Ray user interface. Materials and Lighting: Learn the basics of materials and lighting in V-Ray. Module 10: Advanced V-Ray Rendering (1 Hour) Advanced Materials: Explore advanced material creation and customization. Realistic Lighting: Master V-Ray lighting techniques for photorealistic renders. By the end of this 10-hour course, you'll have a comprehensive understanding of SketchUp for 3D modeling, Layout for professional documentation, and V-Ray for rendering, empowering you to create stunning 3D designs and presentations. Upon completing this course, you will: Master SketchUp: Create 3D models with precision and creativity. Layout Proficiency: Produce professional design documentation. V-Ray Rendering Skills: Craft photorealistic visualizations. Advanced Techniques: Explore advanced modeling and rendering. Project Experience: Apply skills to real-world projects. Job Opportunities: Architectural Designer Interior Designer Landscape Designer CAD Technician 3D Modeler Rendering Specialist Visualization Artist Layout Specialist Freelance Designer Urban Planner Learning Objectives: Mastering SketchUp with Layout: Learn to create precise 2D floor plans, elevations, and construction documents using SketchUp's Layout tool. Advanced Rendering with V-Ray: Dive into V-Ray to create photorealistic renders, enhancing your visualizations with lighting, textures, and realistic materials. Collaborative Design: Develop skills for collaborative project planning and presentation, enabling effective communication with clients and teams. Job Opportunities: Architectural Visualization Specialist: Create detailed architectural visualizations and presentations for clients and marketing purposes. Interior Designer: Design interior spaces, produce detailed layouts, and create realistic renders for residential and commercial projects. 3D Visualization Artist: Work in the gaming or animation industry, creating 3D models and environments. Freelance Rendering Expert: Offer specialized rendering services to architectural firms, interior designers, or real estate developers. Layout Designer: Specialize in creating professional 2D layouts and construction documents for architectural projects. Why Choose Us? Tailored One-on-One Training: Personalized coaching from industry experts, in-person or online, Monday to Saturday. Customized Tutorials: Enhance skills with exclusive video tutorials designed for your learning journey. Comprehensive Resources: Access a digital reference book for thorough concept revision. Free Ongoing Support: Enjoy continuous assistance via phone or email even after the course ends. Flexible Syllabus: Adapted to your needs for focused and efficient learning. Official Certification: Ccertificate upon course completion. Why Us? Supported Individual Learning: Unwavering support with personalized homework and post-course assistance. Personalized Attention: Experience one-on-one learning, fostering a confident and comfortable environment. Financial Flexibility: Choose from various payment plans tailored to your budget. Expert Instructors: Learn from industry experts dedicated to your success.

SketchUp Course With Layout and V-Ray
Delivered in London or OnlineFlexible Dates
£348

Level 7 Diploma in Admin, Secretarial & PA - QLS Endorsed

4.7(47)

By Academy for Health and Fitness

24-Hour Knowledge Knockdown! Prices Reduced Like Never Before Think about the backbone of any successful organization. It's the administrative team, the secretarial staff, and the PAs who keep things running smoothly. A recent study in the UK found that demand for skilled administrative professionals has grown by 15% in the last two years. Are you ready to step up and take on a leadership role in this essential field? This comprehensive Level 7 Diploma equips you with the advanced skills and knowledge to excel in administrative, secretarial, and personal assistant positions. You'll master essential areas like business communication, time management, project coordination, and legal procedures. Additionally, you'll gain expertise in using the latest Microsoft Office tools and navigate complex areas like GDPR and payroll. This Admin, Secretarial & PA at QLS Level 7 course is endorsed by The Quality Licence Scheme and accredited by CPD QS (with 180 CPD points) to make your skill development & career progression more accessible than ever! With a single payment, you will gain access to Admin, Secretarial & PA course, including 10 premium courses, a QLS Endorsed Hardcopy certificate (for the title course) and 11 PDF certificates for Absolutely free. This Admin, secretarial & PA Bundle Package includes: Course 01: Advanced Diploma in Admin, Secretarial & PA at QLS Level 7 10 Additional CPDQS Accredited Premium Courses - Course 01: Complete Microsoft Word Course 02: Microsoft Excel - Beginner, Intermediate & Advanced Course 03: Legal Secretary Course 04: GDPR Course 05: Payroll Course 06: Administrative Management Course 07: Leadership & Management Diploma Course 08: HR Assistant Course 09: Decision-Making in High-Stress Situations Course 10: Workplace Health and Safety Empower yourself to become an indispensable asset in today's competitive workplace. Enrol today and take your career to the next level! Learning outcome of this Admin, Secretarial & PA: Apply advanced administrative procedures for optimal efficiency. Demonstrate exceptional communication skills in written and verbal formats. Effectively manage time and prioritize tasks in a fast-paced environment. Utilize advanced Microsoft Office applications to streamline workflows. Navigate complex legal and regulatory requirements with confidence. Develop leadership qualities to motivate and support colleagues. Why Choose Us? Get a Free QLS Endorsed Certificate upon completion of Admin, secretarial & PA Get a free student ID card with Admin, secretarial & PA Training program (£10 postal charge will be applicable for international delivery) The Admin, secretarial & PA is affordable and simple to understand This course is entirely online, interactive lesson with voiceover audio Get Lifetime access to the Admin, secretarial & PA course materials The Admin, secretarial & PA comes with 24/7 tutor support Start your learning journey straightaway! *** Course Curriculum *** Course 01: Advanced Diploma in Admin, Secretarial & PA at QLS Level 7 Module 1: Personal Assistant Module 2: Admin Support Module 3: Administrative Management Module 4: Organisational Skills Module 5: Telephone Etiquette Module 6: Business Writing Module 7: Time Management Module 8: Body Language and Effective Communication Module 9: Meeting Management Module 10: Excel Basics Module 11: PowerPoint Basic Course 01: Complete Microsoft Word Manipulating Images Using Custom Graphic Elements Collaborating On Documents Adding Document References And Links Securing A Document Using Forms To Manage Content Automating Repetitive Tasks With Macros Course 02: Microsoft Excel - Beginner, Intermediate & Advanced Section 01: Getting Started Section 02: Excel Basics Section 03: Excel Essential Functions Section 04: XLookup Only For Excel 2021 And Office 365 Section 05: Get Data And Tools Section 06: Formatting Data And Tables Section 07: Pivot Tables Section 08: Excel Charts Section 09: Advanced Excel Charts Section 10: Pivot Charts Section 11: Maps Chart Above 2019 Section 12: Business-Geo Charts Section 13: Named Ranges Section 14: Import Data Into Excel Section 15: Advanced Excel =========>>>>> And 8 More Courses <<<<<========= How will I get my Certificate? After successfully completing the course, you will be able to order your QLS Endorsed Certificates and CPD Accredited Certificates as proof of your achievement. PDF Certificate: Free (Previously it was £12.99*11 = £143) QLS Endorsed Hard Copy Certificate: Free (For The Title Course: Previously it was £139) CPD 255 CPD hours / points Accredited by CPD Quality Standards Who is this course for? Anyone interested in learning more about the topic is advised to take this bundle. This bundle is ideal for: Seasoned Admin, Secretarial & PA professionals seeking career growth. Aspiring executive and personal assistants. Career changers entering Admin, Secretarial & PA roles. Individuals specialising in Admin, Secretarial & PA. Advanced administrative skills seekers. Requirements No prior background or expertise is required for this Admin, secretarial & PA bundle. Career path After completing this bundle, you are to start your career or begin the next phase of your career. Executive Assistant: £25,000 - £50,000 Office Manager: £30,000 - £45,000 PA to CEO: £35,000 - £60,000 Administrative Director: £45,000 - £80,000 Operations Manager: £35,000 - £70,000 Business Development Manager: £35,000 - £70,000 Certificates Advanced Diploma in Admin, Secretarial & PA at QLS Level 7 Hard copy certificate - Included Please note that International students have to pay an additional £10 as a shipment fee. CPD Accredited Digital Certificate Digital certificate - Included Upon passing the Course, you need to order a Digital Certificate for each of the courses inside this bundle as proof of your new skills that are accredited by CPD QS for Free.

Level 7 Diploma in Admin, Secretarial & PA - QLS Endorsed
Delivered Online On Demand3 weeks
£119

University of Cambridge & Bayfield Training - Real Estate Financial Modelling Certificate (Online Self-Study)

4.3(5)

By Bayfield Training

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

University of Cambridge & Bayfield Training - Real Estate Financial Modelling Certificate (Online Self-Study)
Delivered Online & In-Person
£2,500

Microsoft Power BI Online

By Nexus Human

Duration 1 Days 6 CPD hours This course is intended for The student should be familiar with Excel and the concepts of datasets and basic reporting. Overview Understand and utilize Power BI Online. Understand and examine the differences between Power BI Desktop and Power BI Online. Understand and explore the Power BI Online interface. Understand and perform importing Excel worksheets, CSV, TXT, PBIX. Understand connecting to databases. Understand other forms of data. Understand data refresh. Understand and perform creating a new Power BI report. Understand and perform adding filters to a report. Understand and perform adding KPI's to a report. Understand and perform creating a Power BI dashboard. Understand and perform pinning tiles. Understand sharing reports and dashboards. Understand Power BI Mobile. This Logical Operations courseware is no longer available on the LO Store, but can be purchased by phone orderThis one-day course familiarizes the student with Power BI Online, which allows the student to intuitively discover and automate the import, transformation, and combination of data across a variety of data sources. COURSE OVERVIEW Introduction Course Materials Facilities Prerequisites What We'll Be Discussing INTRODUCTION TO POWER BI ONLINE What is Power BI Online Examining the Differences Between Power BI Desktop and Power BI Online Exploring the Power BI Online Interface IMPORTING DATA Utilizing Excel (.xlsx or .xlsm), Comma Separated Value (.csv), and Power BI Desktop (.pbix) Files Connecting to Databases Examining Other Forms of Data Understanding Data Refresh CREATING REPORTS Creating a New Power BI Report Adding Filters to a Power BI Report Adding KPI?s to a Report CONFIGURING DASHBOARDS Creating a Power BI Dashboard Pinning Tiles SHARING REPORTS AND DASHBOARDS Sharing Reports and Dashboards Exploring Power BI Mobile

Microsoft Power BI Online
Delivered OnlineFlexible Dates
Price on Enquiry

QuickBooks for Self-Employed

By The Teachers Training

Overview QuickBooks for Self-Employed Course is yet another 'Teacher's Choice' course from Teachers Training for a complete understanding of the fundamental topics. You are also entitled to exclusive tutor support and a professional CPD-accredited certificate in addition to the special discounted price for a limited time. Just like all our courses, this QuickBooks for Self-Employed Course and its curriculum have also been designed by expert teachers so that teachers of tomorrow can learn from the best and equip themselves with all the necessary skills. Consisting of several modules, the course teaches you everything you need to succeed in this profession. The course can be studied part-time. You can become accredited within 05 Hours studying at your own pace. Your qualification will be recognised and can be checked for validity on our dedicated website. Why Choose Teachers Training Some of our website features are: This is a dedicated website for teaching 24/7 tutor support Interactive Content Affordable price Courses accredited by the UK's top awarding bodies 100% online Flexible deadline Entry Requirements No formal entry requirements. You need to have: Passion for learning A good understanding of the English language Be motivated and hard-working Over the age of 16. Certification CPD Certification from The Teachers Training Successfully completing the MCQ exam of this course qualifies you for a CPD-accredited certificate from The Teachers Training. You will be eligible for both PDF copy and hard copy of the certificate to showcase your achievement however you wish. You can get your digital certificate (PDF) for £4.99 only Hard copy certificates are also available, and you can get one for only £10.99 You can get both PDF and Hard copy certificates for just £12.99! The certificate will add significant weight to your CV and will give you a competitive advantage when applying for jobs. Section 01: Introduction to QuickBooks Self-Employed Who Can Benefit From QuickBooks Self-Employed 00:04:00 What QuickBooks Self-Employed Can Do For You 00:02:00 Advantages of QuickBooks Self-Employed 00:04:00 Disadvantages of QuickBooks Self-Employed 00:03:00 Comparison between QuickBooks Self-Employed and QuickBooks Online Simple Start 00:04:00 Section 02: How to Set Up Your QuickBooks Self-Employed Account Tax Profile 00:03:00 Vehicle Info 00:02:00 Health Insurance Info 00:02:00 Section 03: Bank and Invoicing Bank Account 00:03:00 Create an Invoice 00:04:00 Manage an Invoice 00:02:00 Expense Receipts 00:04:00 Section 04: Transactions How to Add Transactions 00:02:00 How to Import Transaction Manually 00:02:00 How to Treat Duplicate Transactions 00:02:00 How to Export Transactions 00:01:00 Section 05: Categorization Categorization 00:02:00 Income and Expense Categories 00:02:00 Transfers 00:03:00 Rules 00:02:00 Split a Transaction 00:02:00 Miles Driven 00:02:00 Section 06: Basic Reports Profit And Loss Report 00:02:00 Tax Summary 00:03:00

QuickBooks for Self-Employed
Delivered Online On Demand1 hour 2 minutes
£27.99