3073 Courses in Glasgow delivered Online

Most people only use a fraction of Excel's capabilities. This workshop shows what you've been missing! This course will help participants: Nest formulas Get the most from pivot tables Use conditional formatting Write array formulas Explore the lookup functions Calculate by criteria Use 'goal seek' and 'scenario manager' for what-if analysis Record macros 1 Nesting formulas Principles of nesting formulas together Using IF with AND or OR to answer questions Nesting an AND function in an IF Nesting an OR function in an IF 2 Advanced pivot table reports Grouping dates, numerical and text items Running percentage analyse Running analyses to compare data Inserting Field calculations Finishing off with a user-friendly dashboard 3 Advanced conditional formatting Colour table rows based on criteria in it Applying colour to approaching dates Exploring the different rule types 4 Lookup functions Going beyond the VLOOKUP function Lookups that retrieve data from left or right The versatile INDEX and MATCH functions Retrieving data from columns with duplicates 5 Calculate by criteria Using SUMIFS to sum by criteria Finding an average by criteria with AVERAGEIFS Use SUMPRODUCT to multiply then add different values 6 What-if analysis Use Goal Seek to meet targets Forecast reports with the Scenario Manager 7 Recording Macros Macro security Understanding a Relative References macro Recording, running and editing macros Saving files as Macro Enabled Workbooks Introduction to VBA code Making macros available across workbooks Add a macro button to the Quick Access toolbar

Embark on a journey into the world of Android app development with our comprehensive Kotlin Programming: Android Coding Bible course. This in-depth training will equip you with the knowledge and skills to master Kotlin, a modern and powerful programming language specifically designed for Android development. Whether you're a complete beginner or an experienced programmer seeking to expand your skillset, this course will guide you through the fundamentals of Kotlin, covering topics such as syntax, data types, variables, operators, control flow statements, functions, error handling, and null safety. You'll gain a solid understanding of object-oriented programming principles and learn how to effectively utilize collections to manage and process data. Learning Outcomes Master the fundamentals of Kotlin programming language for Android development Gain a thorough understanding of syntax, data types, variables, operators, and control flow statements Learn how to create and utilize functions to structure and modularize code Effectively handle errors and exceptions to ensure robust and reliable applications Implement null safety mechanisms to prevent NullPointerExceptions and enhance code stability. Why choose this Kotlin Programming: Android Coding Bible 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 Kotlin Programming: Android Coding Bible course for? Aspiring Android developers seeking to master Kotlin programming language Individuals with prior programming experience looking to transition to Android development Software engineers aiming to expand their skillset with Kotlin and Android development expertise Students of computer science or related fields interested in learning Android app development Enthusiasts passionate about creating mobile applications for the Android platform. Career path Android Developer (£35,000 - £55,000) Senior Android Developer (£45,000 - £65,000) Android App Architect (£55,000 - £75,000) Mobile Application Developer (£30,000 - £50,000) Software Engineer (£40,000 - £60,000) Full-Stack Developer (£45,000 - £65,000) Prerequisites This Kotlin Programming: Android Coding Bible does not require you to have any prior qualifications or experience. You can just enrol and start learning.This Kotlin Programming: Android Coding Bible 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 Section 01: Introduction & Setup Introduction To This Course 00:02:00 Windows Setup 00:13:00 Mac Setup 00:10:00 Linux Setup 00:12:00 Online Code Editor 00:02:00 Section 02: Basics Variables 00:06:00 Data Types 00:06:00 String 00:05:00 Array 00:07:00 Data Type Conversion 00:05:00 Comments 00:04:00 Arithmetic Operators 00:07:00 Relational Operators 00:06:00 Assignment Operators 00:06:00 Unary Operators 00:05:00 Bitwise Operators 00:09:00 Logical Operators 00:04:00 Input & Output 00:03:00 Section 03: Control Statements Conditional if Statement 00:05:00 When Statement 00:07:00 For Loop 00:04:00 While Loop 00:04:00 do while Loop 00:04:00 Break Statement 00:04:00 Continue Statement 00:04:00 Section 04: Functions Basic Functions 00:03:00 Function Parameters 00:04:00 Return Values 00:04:00 Recursion 00:04:00 Default & Named Arguments 00:06:00 Lambda Function 00:04:00 Higher Order Function 00:05:00 Inline Function 00:02:00 Section 05: Error/Exception Handling Try Catch Block 00:04:00 Try Catch Expression 00:05:00 Multiple Catch Block 00:05:00 Nested Try Catch Block 00:05:00 Finally Block 00:02:00 Throw Keyword 00:02:00 Section 06: NULL Safety Nullable & Non Nullable Types 00:03:00 Smart Cast 00:02:00 Unsafe and Safe Cast 00:03:00 Elvis Operator 00:04:00 Section 07: Collections List: listOf Function 00:06:00 List: mutableListOf Function 00:05:00 List: arrayListOf Function 00:06:00 Map: mapOf Function 00:07:00 Map: HashMap 00:08:00 Map: hashMapOf Function 00:05:00 Map: mutableMapOf Function 00:04:00 Set: setOf Function 00:04:00 Set: mutableSetOf Function 00:04:00 Set: HashSet 00:04:00 Section 08: Classes & Objects Basic Example 00:07:00 Nested and Inner Class 00:06:00 Constructors 00:05:00 Visibility Modifiers 00:06:00 Inheritance 00:05:00 Method Overriding 00:04:00 Property Overriding 00:02:00 Abstract Class 00:03:00 Superclass 00:03:00 Data Class 00:05:00 Multiple Class Inheritance & Interfaces 00:03:00 Sealed Class 00:03:00 Extension Function 00:03:00 Generics 00:05:00 Section 09: Extras Integer Type Range 00:05:00 Regex 00:04:00 Call Java from Kotlin 00:03:00 Call Kotlin from Java 00:02:00 Section 10: Resource Resource 00:00:00 Assignment Assignment - Kotlin Masterclass Programming Course: Android Coding Bible 00:00:00

Duration 3 Days 18 CPD hours This course is intended for Application developers who want to build cloud-native applications or redesign existing applications that will run on Google Cloud Platform Overview This course teaches participants the following skills: Use best practices for application development. Choose the appropriate data storage option for application data. Implement federated identity management. Develop loosely coupled application components or microservices. Integrate application components and data sources. Debug, trace, and monitor applications. Perform repeatable deployments with containers and deployment services. Choose the appropriate application runtime environment; use Google Container Engine as a runtime environment and later switch to a no-ops solution with Google App Engine flexible environment. Learn how to design, develop, and deploy applications that seamlessly integrate components from the Google Cloud ecosystem. This course uses lectures, demos, and hands-on labs to show you how to use Google Cloud services and pre-trained machine learning APIs to build secure, scalable, and intelligent cloud-native applications. Best Practices for Application Development Code and environment management. Design and development of secure, scalable, reliable, loosely coupled application components and microservices. Continuous integration and delivery. Re-architecting applications for the cloud. Google Cloud Client Libraries, Google Cloud SDK, and Google Firebase SDK How to set up and use Google Cloud Client Libraries, Google Cloud SDK, and Google Firebase SDK. Lab: Set up Google Client Libraries, Cloud SDK, and Firebase SDK on a Linux instance and set up application credentials. Overview of Data Storage Options Overview of options to store application data. Use cases for Google Cloud Storage, Cloud Firestore, Cloud Bigtable, Google Cloud SQL, and Cloud Spanner. Best Practices for Using Cloud Firestore Best practices related to using Cloud Firestore in Datastore mode for:Queries, Built-in and composite indexes, Inserting and deleting data (batch operations),Transactions,Error handling. Bulk-loading data into Cloud Firestore by using Google Cloud Dataflow. Lab: Store application data in Cloud Datastore. Performing Operations on Cloud Storage Operations that can be performed on buckets and objects. Consistency model. Error handling. Best Practices for Using Cloud Storage Naming buckets for static websites and other uses. Naming objects (from an access distribution perspective). Performance considerations. Setting up and debugging a CORS configuration on a bucket. Lab: Store files in Cloud Storage. Handling Authentication and Authorization Cloud Identity and Access Management (IAM) roles and service accounts. User authentication by using Firebase Authentication. User authentication and authorization by using Cloud Identity-Aware Proxy. Lab: Authenticate users by using Firebase Authentication. Using Pub/Sub to Integrate Components of Your Application Topics, publishers, and subscribers. Pull and push subscriptions. Use cases for Cloud Pub/Sub. Lab: Develop a backend service to process messages in a message queue. Adding Intelligence to Your Application Overview of pre-trained machine learning APIs such as Cloud Vision API and Cloud Natural Language Processing API. Using Cloud Functions for Event-Driven Processing Key concepts such as triggers, background functions, HTTP functions. Use cases. Developing and deploying functions. Logging, error reporting, and monitoring. Managing APIs with Cloud Endpoints Open API deployment configuration. Lab: Deploy an API for your application. Deploying Applications Creating and storing container images. Repeatable deployments with deployment configuration and templates. Lab: Use Deployment Manager to deploy a web application into Google App Engine flexible environment test and production environments. Execution Environments for Your Application Considerations for choosing an execution environment for your application or service:Google Compute Engine (GCE),Google Kubernetes Engine (GKE), App Engine flexible environment, Cloud Functions, Cloud Dataflow, Cloud Run. Lab: Deploying your application on App Engine flexible environment. Debugging, Monitoring, and Tuning Performance Application Performance Management Tools. Stackdriver Debugger. Stackdriver Error Reporting. Lab: Debugging an application error by using Stackdriver Debugger and Error Reporting. Stackdriver Logging. Key concepts related to Stackdriver Trace and Stackdriver Monitoring. Lab: Use Stackdriver Monitoring and Stackdriver Trace to trace a request across services, observe, and optimize performance.

🌟 Unlock the Secrets of the Human Body with Our Anatomy & Physiology Level 3 Diploma Course! 🌟 Are you fascinated by the intricacies of the human body? Do you have a burning desire to delve into the complexities of anatomy and physiology? Look no further! Our comprehensive online course, 'Anatomy & Physiology Level 3 Diploma,' is your key to unlocking the secrets of the human body and advancing your knowledge to new heights.   🔍 What's Inside: Unveiling the 10 Modules 📚 Module 1: Introduction to Anatomy and Physiology Lay the foundation for your journey by understanding the basics of the human body, setting the stage for deeper exploration. 🧪 Module 2: The Chemical and Cellular Basis of Life Explore the fundamental building blocks of life, delving into the fascinating world of cells and the chemical processes that govern them. 💪 Module 3: The Muscular System Flex your knowledge muscles as you dissect the intricacies of the muscular system, understanding how it powers our every move. ️ Module 4: The Skeletal System Bones tell a story! Uncover the structure, functions, and mysteries of the skeletal system that supports and protects our bodies. 🫁 Module 5: Respiratory System Breathe life into your studies as you explore the respiratory system, understanding how we inhale, exhale, and exchange the breath of life. 🧠Module 6: The Nervous System Connect the dots in the vast network of neurons, unraveling the complexities of the nervous system and how it controls every aspect of our being. 🔧 Module 7: The Endocrine System Dive into the hormone-driven world of the endocrine system, discovering how it regulates various bodily functions. 🤸‍️ Module 8: The Musculoskeletal System Bridge the gap between muscles and bones, gaining insight into the dynamic relationship that enables movement and stability. 🚰 Module 9: Urinary System Go beyond the surface and explore the role of the urinary system in maintaining balance and eliminating waste from the body. 👶 Module 10: Reproductive System Delve into the wonders of creation, understanding the complexities of human reproduction and the miracle of life.   🌐 Why Choose Our Course? ✅ Comprehensive Curriculum: Our course covers every nook and cranny of anatomy and physiology, ensuring you graduate with a well-rounded understanding. ✅ Flexible Learning: Study at your own pace, with 24/7 access to course materials, making it ideal for busy individuals or those balancing work and family. ✅ Expert Guidance: Benefit from the expertise of experienced instructors, ready to support and guide you through your learning journey. ✅ Interactive Learning: Engage with multimedia content, quizzes, and practical exercises to reinforce your understanding and make learning enjoyable.   🚀 Embark on Your Learning Journey Today! Don't miss the chance to elevate your understanding of the human body. Enroll now in our 'Anatomy & Physiology Level 3 Diploma' course and take the first step towards a more profound knowledge of the incredible machine that is the human body. Course Curriculum Module 1 Introduction to Anatomy and Physiology Introduction to Anatomy and Physiology 00:00 Module 2 The Chemical and Cellular Basis of Life The Chemical and Cellular Basis of Life 00:00 Module 3 The Muscular System The Muscular System 00:00 Module 4 The Skeletal System The Skeletal System 00:00 Module 5 Respiratory System Respiratory System 00:00 Module 6 The Nervous System The Nervous System 00:00 Module 7 The Endocrine System The Endocrine System 00:00 Module 8 The Musculoskeletal System The Musculoskeletal System 00:00 Module 9 Urinary System Urinary System 00:00 Module 10 Reproductive System Reproductive System 00:00

Dive into the enthralling world of numbers and equations with 'High School Math (Pure Mathematics 1),' a course designed to unravel the mysteries of mathematics. Your journey begins with an Introduction that lays the foundation, not just in terms of concepts but igniting a passion for the beauty of math. As you progress, Functions become more than just equations; they turn into a language that describes the universe. Imagine the elegance of Quadratic Equations unfolding before your eyes, revealing patterns and solutions that were once hidden. Embark on an adventure through Co-ordinate Geometry, where every point and line tells a story of space and dimensions. Sequence and Series will no longer be just about numbers; they will be about the rhythm and flow of mathematical logic. The course takes a deeper dive with the Binomial Theorem, Differentiation, Tangents and Normals, each module building on the last, turning complexity into simplicity. Stationary Points & Curve Sketching, and the Second Derivative Test open new vistas in understanding the nature of graphs. As you master Simultaneous Linear Equations, you're not just solving problems; you're unlocking a new perspective on mathematical relationships. The Essential Revision at the end is your bridge to excellence, consolidating your knowledge and skills. Learning Outcomes Develop a foundational understanding of key mathematical concepts and functions. Master the intricacies of quadratic equations and co-ordinate geometry. Explore and apply the principles of sequences, series, and the binomial theorem. Gain proficiency in differentiation and its practical applications in tangents and normals. Understand and implement techniques in curve sketching, stationary points, and optimisation. Why choose this High School Math (Pure Mathematics 1) 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 High School Math (Pure Mathematics 1) course for? High school students seeking to excel in mathematics. Individuals preparing for college-level math courses. Math enthusiasts looking to deepen their understanding of pure mathematics. Students requiring a comprehensive revision of key mathematical concepts. Anyone aspiring to pursue a career involving advanced mathematics. Career path Mathematician: £30,000 - £60,000 Data Analyst: £25,000 - £50,000 Actuarial Analyst: £28,000 - £55,000 Research Scientist (Mathematics): £32,000 - £60,000 Engineering Consultant: £27,000 - £55,000 Academic Tutor (Mathematics): £24,000 - £40,000 Prerequisites This High School Math (Pure Mathematics 1) does not require you to have any prior qualifications or experience. You can just enrol and start learning.This High School Math (Pure Mathematics 1) 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 Introduction Introduction 00:03:00 Functions What is Function? 00:07:00 Vertical Line Test 00:04:00 Value of a Function Graphically 00:08:00 Domain Range of a function Algebraically 00:13:00 Domain Range of a function Graphically 00:06:00 Even & Odd Functions 00:07:00 One to one Function 00:05:00 Composite Functions 00:09:00 How to draw Rational Functions- 1 00:04:00 How to draw Rational Functions- 2 00:10:00 Inverse of a function Algebraically 00:05:00 Inverse of a function Graphically 00:09:00 Practice Problems 00:15:00 Practice Problems 00:11:00 Resources Downloads 00:40:00 Quadratic Equations Introduction to Quadratic Equations 00:04:00 Solving Quadratic Equations by Factorization method 00:10:00 Writing in completed square form 00:08:00 Solving by completed square method 00:08:00 Sketching of Quadratic Graphs 00:11:00 Quadratic graphs using Transformations 00:06:00 Quadratic inequalities 00:11:00 Deriving Quadratic formula 00:05:00 Solving problems using Quadratic Formula 00:06:00 Equations reducible to Quadratic 00:07:00 Nature of Roots of Quadratic Equations 00:04:00 Nature of roots continues 00:12:00 Quadratic Equations (Resources) 00:50:00 Co-ordinate Geometry Distance formula 00:15:00 Mid point formula 00:05:00 Gradient of a line 00:10:00 Graphing using gradient and y intercept 00:02:00 Some standard lines 00:04:00 Slope intercept form y = m x +c 00:05:00 Point slope form and two point form 00:10:00 Intersection of line and parabola 00:09:00 Practice Problems from past papers (part 3) 00:12:00 Sequence and series Sequence and series ( video) 00:08:00 Arithmetic Sequence 00:10:00 General term of an A.P. 00:07:00 Finding given term is which term? 00:05:00 Writing sequence when two terms are known 00:08:00 Condition for three terms to be in A.P. 00:05:00 Sum to n terms of A.P. 00:06:00 Practice Problems 1 (A.P.) 00:08:00 Practice problems 3 (A.P.) 00:07:00 Practice problems 4 (A.P.) 00:10:00 Geometric Progressions 00:11:00 Sum to n terms in G.P. 00:14:00 Sum to infinite Terms in G.P. 00:13:00 Practice Problems 1 (GP) 00:13:00 Practice Problems 2 (GP) 00:06:00 Practice Problems based on AP and GP both 00:15:00 Sequence and series Text 1 00:40:00 Sequence and series Text 2 00:55:00 Binomial Theorem What is Factorial? 00:06:00 n-choose -r problems 00:06:00 Properties of n - choose -r 00:05:00 Expanding using Binomial Theorem 00:11:00 Finding the indicated term in the Binomial expansion 00:10:00 Finding the indicated term from end 00:09:00 Finding the coefficient for given exponent (index) of the variable 00:08:00 Finding the term independent of variable 00:05:00 Expanding in increasing and decreasing powers of x 00:09:00 Practice problems 1 00:12:00 Practice Problems 2 00:09:00 Practice problems 3 00:10:00 Past papers problems 1 00:15:00 Past Paper problems 2 00:13:00 Past Paper problems 3 00:09:00 Resources in this section 00:50:00 Differentiation What is Derivative? 00:07:00 Derivation of formula for Derivative 00:06:00 Differentiation by definition or First Principle 00:06:00 Power Rule 00:20:00 Practice Problems on Power Rule 1 00:07:00 Practice Problems on Power Rule 2 00:07:00 Practice Problems on Power Rule 3 00:05:00 Practice Problems on Power Rule 4 00:11:00 Practice Problems on Power Rule 5 00:07:00 Tangents and Normals Tangents and Normals- Basics 00:12:00 Practice- Tangents and Normals Part 1 00:16:00 Practice- Tangents and Normals Part 2 00:13:00 Practice- Tangents and Normals Part 3 00:11:00 Practice- Tangents and Normals Part 4 00:14:00 Stationary Points & Curve Sketching Stationary Points - Basics 00:13:00 Practice- Increasing Decreasing & Maxima Minima part 1 00:11:00 Practice- Increasing Decreasing & Maxima Minima part 2 00:12:00 Practice- Increasing Decreasing & Maxima Minima part 3 00:10:00 Second Derivative Test (Maximum & Minimum Points) Concavity-Basics 00:02:00 Concavity & Second Derivative 00:08:00 Second Derivative Test 00:09:00 Practice Problems on second derivative 00:04:00 Practice Problem of Maxima Minima using second derivative test Part 1 00:17:00 Practice Problem of Maxima Minima using second derivative test Part 2 00:10:00 Practice Problem of Maxima Minima using second derivative test Part 3 00:07:00 Practice Problem of Maxima Minima using second derivative test Part 4 00:07:00 Applications of Maxima and Minima Part 1 00:09:00 Applications of Maxima and Minima Part 2 00:07:00 Applications of Maxima and Minima Part 3 00:10:00 Applications of Maxima and Minima Part 4 00:09:00 Applications of Maxima and Minima Part 5 00:10:00 Applications of Maxima and Minima Part 6 00:08:00 Past Paper Problems on applications of maxima and minima Part 1 00:09:00 Past Paper Problems on applications of maxima and minima Part 2 00:09:00 Past Paper Problems on applications of maxima and minima Part 3 00:08:00 Past Paper Problems on applications of maxima and minima Part 4 00:07:00 Chain Rule 00:12:00 Rate of change part 1 00:05:00 Rate of change part 2 00:10:00 Rate of change part 3 00:07:00 Past Paper Problems using chain rule -1 00:06:00 Past Paper Problems using chain rule - 2 00:07:00 Past Paper Problems using chain rule 3 00:07:00 Past Paper Problems using chain rule -4 00:04:00 Simultaneous Linear equations Graphical Method of solving pair of linear equations 00:10:00 Video lecture on Graphical method 00:05:00 Method of elimination by substitution 00:10:00 Video lecture on substitution method 00:06:00 Method of elimination by equating the coefficients 00:10:00 Video lecture on equating coefficients method 00:09:00 Practice Problems on Linear equation 00:20:00 Essential Revision How to take up this course? 00:10:00 Background of Algebra 00:10:00 Language of Alg ebra 00:10:00 Finding Values of algebraic expressions 00:14:00 Fractional Indices 00:10:00 Higher Indices 00:07:00 Rules of Brackets 00:04:00 Simplification by removing brackets (BODMAS) 00:11:00 Simplifications of Algebraic Fractions 00:07:00 Solving complex Linear Equations in one variable 00:10:00 Factorization by taking out common factor 00:10:00 Factorization by grouping the terms 00:09:00 Factorize using identity a ² - b ² 00:07:00 Factorization by middle term split 00:12:00

Duration 2 Days 12 CPD hours This course is intended for Implementation Consultants Key Technical Business Users involved in a GRC 12.0 project IT Governance Experts Consultants for SAP Security and GRC IT Auditors Business Project Team Leaders Overview This course will prepare you to: Introduce SAP Governance, Risk, and Compliance (GRC) 12.0 Identify key governance, risk, and compliance processes supported in the SAP GRC 12.0 solution Describe key features and business benefits of the integrated solution Identify applications that integrate with the SAP GRC 12.0 solution Describe the purpose and location of key user interface components Discuss harmonized navigation and how authorizations affect what users see Describe how common functions and relative master data are shared across the SAP GRC solutions Describe the IMG organization for GRC 12.0 Describe a general implementation process and key steps This course provides foundation knowledge for SAP Governance, Risk and Compliance (GRC) 12.0. By gaining familiarity with this solution?s harmonized navigation, common functions, shared master data, and the harmonized reporting framework, you will be better able to get the most value out of using the integrated applications in SAP GRC. Introduction to SAP Governance, Risk, and compliance (GRC) 12.0 Solution Introduction Solution Overview ? Enterprise Risk and Compliance Solution Overview ? Access Governance Solution Overview ? International Trade Management Solution Overview ? Cybersecurity Information Architecture, Security, and Authorizations Understanding the SAP Fiori Concept and Architecture Security and Authorizations The SAP GRC 12.0 User Interface Work Centers SAP Fiori Common Functions and Data User Interface Configuration Framework Shared Master Data Implementation and Configuration Streamlined Configuration Reporting Harmonized Reporting Framework SAP HANA Integration

Microsoft Office Excel 2016 for Beginners Course Overview Are you looking to begin your Microsoft Office Excel career or want to develop more advanced skills in Microsoft Office Excel? Then this Microsoft Office Excel 2016 for beginners online course will set you up with a solid foundation to become a confident office admin and help you to develop your expertise in Microsoft Office Excel. This Microsoft Office Excel 2016 for beginners online course is accredited by the CPD UK & IPHM. CPD is globally recognised by employers, professional organisations and academic intuitions, thus a certificate from CPD Certification Service creates value towards your professional goal and achievement. CPD certified certificates are accepted by thousands of professional bodies and government regulators here in the UK and around the world. Whether you are self-taught and you want to fill in the gaps for better efficiency and productivity, this Microsoft Office Excel 2016 for beginners online course will set you up with a solid foundation to become a confident office admin and develop more advanced skills. Gain the essential skills and knowledge you need to propel your career forward as an office admin. The Microsoft Office Excel 2016 for beginners online course will set you up with the appropriate skills and experience needed for the job and is ideal for both beginners and those currently working as an office admin. This comprehensive Microsoft Office Excel 2016 for beginners online course is the perfect way to kickstart your career in the field of Microsoft Office Excel. This Microsoft Office Excel 2016 for beginners online course will give you a competitive advantage in your career, making you stand out from all other applicants and employees. If you're interested in working as an office admin or want to learn more skills on Microsoft Office Excel but unsure of where to start, then this Microsoft Office Excel 2016 for beginners online course will set you up with a solid foundation to become a confident office admin and develop more advanced skills. As one of the leading course providers and most renowned e-learning specialists online, we're dedicated to giving you the best educational experience possible. This Microsoft Office Excel 2016 for beginners online course is crafted by industry expert, to enable you to learn quickly and efficiently, and at your own pace and convenience. Who should take this course? This comprehensive Microsoft Office Excel 2016 for beginners online course is suitable for anyone looking to improve their job prospects or aspiring to accelerate their career in this sector and want to gain in-depth knowledge of Microsoft Office Excel. Entry Requirement There are no academic entry requirements for this Microsoft Office Excel 2016 for beginners online course, and it is open to students of all academic backgrounds. As long as you are aged seventeen or over and have a basic grasp of English, numeracy and ICT, you will be eligible to enrol. Career path This Microsoft Office Excel 2016 for beginners online course opens a brand new door for you to enter the relevant job market and also provides you with the chance to accumulate in-depth knowledge at the side of needed skills to become flourishing in no time. You will also be able to add your new skills to your CV, enhance your career and become more competitive in your chosen industry. Course Curriculum Getting Started With Excel 2016 Navigate the Excel User Interface - Introduction Navigate the Excel User Interface Use Excel Commands - Introduction Use Excel Commands Create and Save a Basic Workbook - Introduction Create and Save a Basic Workbook Enter Cell Data - Introduction Enter Cell Data Flash Fill and Auto Fill Use Excel Help - Introduction Use Excel Help Performing Calculations Create Worksheet Formulas - Introduction Create Worksheet Formulas Insert Functions - Introduction Insert Functions Reuse Formulas and Functions - Introduction Reuse Formulas and Functions Modifying a Worksheet Insert, Delete and Adjust Cells, Columns and Rows Search for and Replace Data Insert, Delete and Adjust Cells, Columns and Rows - Introduction Use Proofing and Research Tools Check the Spelling in a Worksheet Search for and Replace Data - Introduction Insights Task Pane Formatting a Worksheet Apply Text Formats - Introduction Apply Text Formats Apply Number Formats - Introduction Apply Number Formats Align Cell Contents - Introduction Align Cell Contents Apply Cell Styles and Themes Apply Cell Styles and Themes - Introduction Create and Use Templates - Introduction Apply Basic Conditional Formatting - Introduction Apply Basic Conditional Formatting Create and Use Templates Printing Workbooks Preview and Print a Workbook Configure and Preview a Print Job Set Up the Page Layout - Introduction Set Up the Page Layout Configure Headers and Footers - Introduction Configure Headers and Footers Managing Workbooks Manage Worksheets - Introduction Manage Worksheets Manage Workbook and Worksheet Views - Introduction Manage Workbook and Worksheet Views Manage Workbook Properties - Introduction Manage Workbook Properties Bonus Lecture Recognised Accreditation CPD Certification Service This course is accredited by continuing professional development (CPD). CPD UK is globally recognised by employers, professional organisations, and academic institutions, thus a certificate from CPD Certification Service creates value towards your professional goal and achievement. CPD certificates are accepted by thousands of professional bodies and government regulators here in the UK and around the world. Many organisations look for employees with CPD requirements, which means, that by doing this course, you would be a potential candidate in your respective field. Quality Licence Scheme Endorsed The Quality Licence Scheme is a brand of the Skills and Education Group, a leading national awarding organisation for providing high-quality vocational qualifications across a wide range of industries. It will give you a competitive advantage in your career, making you stand out from all other applicants and employees.     Certificate of Achievement Endorsed Certificate from Quality Licence Scheme After successfully passing the MCQ exam you will be eligible to order the Endorsed Certificate by Quality Licence Scheme. The Quality Licence Scheme is a brand of the Skills and Education Group, a leading national awarding organisation for providing high-quality vocational qualifications across a wide range of industries. It will give you a competitive advantage in your career, making you stand out from all other applicants and employees. There is a Quality Licence Scheme endorsement fee to obtain an endorsed certificate which is £65. Certificate of Achievement from Lead Academy After successfully passing the MCQ exam you will be eligible to order your certificate of achievement as proof of your new skill. The certificate of achievement is an official credential that confirms that you successfully finished a course with Lead Academy. Certificate can be obtained in PDF version at a cost of £12, and there is an additional fee to obtain a printed copy certificate which is £35.   FAQs Is CPD a recognised qualification in the UK? CPD is globally recognised by employers, professional organisations and academic intuitions, thus a certificate from CPD Certification Service creates value towards your professional goal and achievement. CPD-certified certificates are accepted by thousands of professional bodies and government regulators here in the UK and around the world. Are QLS courses recognised? Although QLS courses are not subject to Ofqual regulation, they must adhere to an extremely high level that is set and regulated independently across the globe. A course that has been approved by the Quality Licence Scheme simply indicates that it has been examined and evaluated in terms of quality and fulfils the predetermined quality standards. When will I receive my certificate? For CPD accredited PDF certificate it will take 24 hours, however for the hardcopy CPD certificate takes 5-7 business days and for the Quality License Scheme certificate it will take 7-9 business days. Can I pay by invoice? Yes, you can pay via Invoice or Purchase Order, please contact us at info@lead-academy.org for invoice payment. Can I pay via instalment? Yes, you can pay via instalments at checkout. How to take online classes from home? Our platform provides easy and comfortable access for all learners; all you need is a stable internet connection and a device such as a laptop, desktop PC, tablet, or mobile phone. The learning site is accessible 24/7, allowing you to take the course at your own pace while relaxing in the privacy of your home or workplace. Does age matter in online learning? No, there is no age limit for online learning. Online learning is accessible to people of all ages and requires no age-specific criteria to pursue a course of interest. As opposed to degrees pursued at university, online courses are designed to break the barriers of age limitation that aim to limit the learner's ability to learn new things, diversify their skills, and expand their horizons. When I will get the login details for my course? After successfully purchasing the course, you will receive an email within 24 hours with the login details of your course. Kindly check your inbox, junk or spam folder, or you can contact our client success team via info@lead-academy.org

Course Overview: Imagine the power of interacting with databases, organising vast information, and extracting valuable insights - all at your fingertips. This might seem like a formidable task, but SQL, or Structured Query Language, brings this within reach. It is one of the most in-demand skills in the tech industry, with a projected 10% job growth rate over the next decade. Our course, The Complete SQL from Scratch: Bootcamp, provides a thorough understanding of SQL, irrespective of your prior familiarity with it. This comprehensive course walks you through the journey from the fundamentals of databases to the intricate functionalities of SQL. The curriculum includes detailed discussions on database creation, table manipulation, SQL statements, and utilisation of various operators. Moreover, it also covers essential operations like data backup and restoration, thus preparing learners for real-life database management scenarios. The course design ensures a smooth transition from one concept to another, enabling learners to solidify their understanding at each step. Enrol today and start learning SQL! Key Features of the Course: CPD certificate: Upon completion of the course, you'll receive a CPD certificate that you can use to demonstrate your skills to employers. 24/7 Learning Assistance: Our team of experts is available 24/7 to answer your questions and help you progress through the course. Interesting learning materials: The course is packed with engaging videos, interactive exercises, and quizzes to help you learn SQL in a fun and effective way. Who is This Course For? The Complete SQL from Scratch: Bootcamp course is suitable for anyone interested in diving into the world of databases or enhancing their skills further. Beginners with no prior knowledge and professionals seeking an in-depth understanding of SQL would equally benefit from the course. What You Will Learn: Through The Complete SQL from Scratch: Bootcamp , you will learn: An in-depth understanding of databases and their functions. Familiarity with PostgreSQL installation and various connections. Proficiency in manipulating data including insert, update, delete operations. A comprehensive grasp of complex SQL commands and queries. Skills to design and alter table structures using SQL scripts. Advanced knowledge about SQL statements, their structure, and usage. Competence in data backup and restoration in databases. Why Enrol in This Course: The Complete SQL from Scratch: Bootcamp course is reviewed as a top choice among learners, and is recently updated to match the trending industry needs. By enrolling, you will acquire a set of skills that are crucial in today's data-centric world, enhancing your employability and competitive edge. Requirements: No prior experience is required A computer with internet access Career Path: Database Administrator (average UK salary £47,000) Data Analyst (£40,000), Business Analyst (£43,000) SQL Developer (£45,000) Database Engineer (£48,000) Systems Analyst (£41,000) Data Architect (£62,000). Certification: After successfully completing the course, you will receive a CPD certificate, signifying your expertise in SQL. This course is your stepping stone to becoming a proficient database professional. Enrol and Lets get started! Course Curriculum 12 sections • 56 lectures • 06:39:00 total length •Introduction: 00:04:00 •Course Curriculum overview: 00:04:00 •Overview of Databases: 00:08:00 •PostgreSQL Installation: 00:13:00 •Connecting to PostgreSQL using psql: 00:04:00 •Connecting to PostgreSQL using PgAdmin: 00:07:00 •Basic of Database and Tables: 00:06:00 •Data Types: 00:07:00 •Primary Keys and Foreign Keys: 00:04:00 •Create Table in SQL Script: 00:17:00 •Insert: 00:05:00 •Update: 00:05:00 •Delete: 00:03:00 •Alter Table: 00:05:00 •Drop Table: 00:02:00 •Check Constraint: 00:12:00 •NOT NULL Constraint: 00:04:00 •UNIQUE Constraint: 00:06:00 •Overview of Challenges: 00:04:00 •SQL Statement Basic: 00:07:00 •SELECT Statement: 00:12:00 •SELECT DISTINCT: 00:10:00 •Column AS Statement: 00:07:00 •COUNT: 00:07:00 •SELECT WHERE Clause - One: 00:06:00 •SELECT WHERE Clause - Two: 00:11:00 •ORDER: 00:05:00 •LIMIT: 00:04:00 •BETWEEN keyword usage on real time: 00:08:00 •IN Operator: 00:06:00 •LIKE and ILIKE: 00:10:00 •Overview of GROUP BY: 00:03:00 •Aggregation Function: 00:12:00 •GROUP BY - One: 00:05:00 •GROUP BY - Two: 00:06:00 •HAVING on SQL Statement: 00:04:00 •Overview of JOINS: 00:07:00 •Introduction to JOINS: 00:06:00 •AS Statement table: 00:05:00 •INNER Joins: 00:14:00 •Full Outer Joins: 00:04:00 •Left Outer join: 00:03:00 •Right Outer Join: 00:05:00 •Union: 00:05:00 •Basic of Advanced SQL Commands: 00:04:00 •Timestamps: 00:17:00 •Extract from Timestamp: 00:05:00 •Mathematical Functions: 00:06:00 •String Functions: 00:16:00 •SubQuery: 00:08:00 •Overview of Databases and Tables: 00:02:00 •Creating a Database backup: 00:03:00 •Restoring a Database from backup: 00:04:00 •Overview Assessment Test: 00:02:00 •Mock Exam - The Complete SQL from Scratch: Bootcamp: 00:20:00 •Final Exam - The Complete SQL from Scratch: Bootcamp: 00:20:00

Getting Started This qualification aims to equip individuals who currently hold or aspire to attain senior positions in an organisation with the responsibilities associated with overseeing health and safety policy and its implementation.  The QUALIFI Level 6 Diploma in Health and Safety Management also allows learners to enhance their comprehension of Occupational Health and Safety management. They will acquire the knowledge and expertise necessary to comprehend the legal and regulatory framework governing occupational health and safety policy. They will also evaluate existing policies, suggest improvements, and implement these recommended policy changes. Additionally, they will learn to translate these policies into action, effectively utilising management systems, resources, risk and incident management strategies and fostering leadership, management and skill development.    Key Benefits This qualification prepares learners to Understand key health and safety policy principles, as well as an awareness of the internal, external and transformative factors that shape its implementation. Develop the knowledge and skills to effectively translate organisational policy into a well-functioning occupational health and safety management system. Enable learners to effectively address and manage risks and incidents in their capacity as health and safety practitioners, including the ability to assess and evaluate risk through appropriate strategies. Understand elements that influence health and safety behaviours, performance, and workplace culture Key Highlights This course module prepares learners to attain senior positions within an organisation for managing health and safety policy and practice. We will ensure your access to the first-class education needed to achieve your goals and dreams and to maximise future opportunities. Remember! The assessment for the qualification is done based on assignments only, and you do not need to worry about writing any exam. With the School of Business and Technology London, you can complete the qualification at your own pace, choosing online or blended learning from the comfort of your home. Learning and pathway materials and study guides developed by our qualified tutors will be available around the clock in our cutting-edge learning management system. Most importantly, at the School of Business and Technology London, we will provide comprehensive tutor support through our dedicated support desk. If you choose your course with blended learning, you will also enjoy live sessions with an assigned tutor, which you can book at your convenience. Career Pathways The QUALIFI Level 6 Diploma in Health and Safety Management can open many career pathways including, but not limited to: Health and Safety Professionals with an estimated average salary of £32,969 per annum Safety coordinator with an estimated average salary of £30,939 per annum Compliance officer with an estimated average salary of £49,222 per annum About Awarding Body QUALIFI, recognised by Ofqual awarding organisation has assembled a reputation for maintaining significant skills in a wide range of job roles and industries which comprises Leadership, Hospitality & Catering, Health and Social Care, Enterprise and Management, Process Outsourcing and Public Services. They are liable for awarding organisations and thereby ensuring quality assurance in Wales and Northern Ireland. What is included? Outstanding tutor support that gives you supportive guidance all through the course accomplishment through the SBTL Support Desk Portal. Access our cutting-edge learning management platform to access vital learning resources and communicate with the support desk team. Quality learning materials such as structured lecture notes, study guides, and practical applications, which include real-world examples and case studies, will enable you to apply your knowledge. Learning materials are provided in one of the three formats: PDF, PowerPoint, or Interactive Text Content on the learning portal. The tutors will provide Formative assessment feedback to improve the learners' achievements. Assessment materials are accessible through our online learning platform. Supervision for all modules. Multiplatform accessibility through an online learning platform facilitates SBTL in providing learners with course materials directly through smartphones, laptops, tablets or desktops, allowing students to study at their convenience. Live Classes (for Blended Learning Students only)   Assessment Time-constrained scenario-based assignments No examinations Entry Requirements Level 5 qualification or Appropriate work experience in the business sector and demonstrate ambition with clear career goals. Learners should be aged 19 years and over. Learners must have sufficient command of the English Language (IELTS 6 or equivalent)   Progression QUALIFI Level 7 Diploma Employment in an associated profession     Why gain a QUALIFI Qualification? This suite of qualifications provides enormous opportunities to learners seeking career and professional development. The highlighting factor of this qualification is that: The learners attain career path support who wish to pursue their career in their denominated sectors; It helps provide a deep understanding of the health and social care sector and managing the organisations, which will, in turn, help enhance the learner's insight into their chosen sector. The qualification provides a real combination of disciplines and skills development opportunities. The Learners attain in-depth awareness concerning the organisation's functioning, aims and processes. They can also explore ways to respond positively to this challenging and complex health and social care environment. The learners will be introduced to managing the wide range of health and social care functions using theory, practice sessions and models that provide valuable knowledge. As a part of this suite of qualifications, the learners will be able to explore and attain hands-on training and experience in this field. Learners also acquire the ability to face and solve issues then and there by exposure to all the Units. The qualification will also help to Apply scientific and evaluative methods to develop those skills. Find out threats and opportunities. Develop knowledge in managerial, organisational and environmental issues. Develop and empower critical thinking and innovativeness to handle problems and difficulties. Practice judgement, own and take responsibility for decisions and actions. Develop the capacity to perceive and reflect on individual learning and improve their social and other transferable aptitudes and skills.       Learners must request before enrolment to interchange unit(s) other than the preselected units shown in the SBTL website because we need to make sure the availability of learning materials for the requested unit(s). SBTL will reject an application if the learning materials for the requested interchange unit(s) are unavailable. Learners are not allowed to make any request to interchange unit(s) once enrolment is complete. UNIT1- Health and Safety Management Principles and Policy Reference No : L/650/6691 Credit : 15 || TQT : 150 Additionally, students will cultivate the expertise and capabilities required to assess an organisation's health and safety policy thoroughly. UNIT2- Risk and Incident Management Reference No : M/650/6692 Credit : 15 || TQT : 150 This unit aims to equip learners with the knowledge, comprehension, and proficiency needed to convert organisational policies into a proficient operational framework for occupational health and safety. This encompasses planning, organising, controlling, reviewing, and auditing health and safety management activities. Additionally, it involves the implementation of corporate social responsibility principles and ethical codes of conduct within management, as well as examining the pivotal factors in overseeing employees' occupational health and well-being. UNIT3- Promoting a Positive Health and Safety Culture Reference No : R/650/6693 Credit : 15 || TQT : 150 This unit aims to give learners insights into various elements that shape health and safety behaviours, performance, and workplace culture. This encompasses examining the effects of both human and organisational factors, leadership approaches, the structure of organisations, and mechanisms for consultation. Furthermore, students will acquire the proficiency to assess an organisation's health and safety culture and performance and the ability to devise a well-structured strategy for enhancing them. UNIT4- Maintaining a Safe Working Environment Reference No : T/650/6694 Credit : 15 || TQT : 150 This unit aims to expand the learners' occupational health and safety foundation. It encompasses the technical expertise necessary for learners/practitioners aspiring to advance in various managerial positions. UNIT5- Health and Safety Law, Regulation and Influence Reference No : Y/650/6695 Credit : 15 || TQT : 150 Students will delve into the functions performed by industry, professional organisations, and media communities in shaping and advocating for positive health and safety outcomes on local, national, and global levels. UNIT6- Development of the Health and Safety Practitioner Reference No : A/650/6696 Credit : 15 || TQT : 150 Students will acquire the competencies needed to evaluate an organisation's proficiency and skill prerequisites, and they will be able to propose training and/or recruitment strategies to fulfil these needs. Delivery Methods School of Business & Technology London provides various flexible delivery methods to its learners, including online learning and blended learning. Thus, learners can choose the mode of study as per their choice and convenience. The program is self-paced and accomplished through our cutting-edge Learning Management System. Learners can interact with tutors by messaging through the SBTL Support Desk Portal System to discuss the course materials, get guidance and assistance and request assessment feedbacks on assignments. We at SBTL offer outstanding support and infrastructure for both online and blended learning. We indeed pursue an innovative learning approach where traditional regular classroom-based learning is replaced by web-based learning and incredibly high support level. Learners enrolled at SBTL are allocated a dedicated tutor, whether online or blended learning, who provide learners with comprehensive guidance and support from start to finish. The significant difference between blended learning and online learning methods at SBTL is the Block Delivery of Online Live Sessions. Learners enrolled at SBTL on blended learning are offered a block delivery of online live sessions, which can be booked in advance on their convenience at additional cost. These live sessions are relevant to the learners' program of study and aim to enhance the student's comprehension of research, methodology and other essential study skills. We try to make these live sessions as communicating as possible by providing interactive activities and presentations. Resources and Support School of Business & Technology London is dedicated to offering excellent support on every step of your learning journey. School of Business & Technology London occupies a centralised tutor support desk portal. Our support team liaises with both tutors and learners to provide guidance, assessment feedback, and any other study support adequately and promptly. Once a learner raises a support request through the support desk portal (Be it for guidance, assessment feedback or any additional assistance), one of the support team members assign the relevant to request to an allocated tutor. As soon as the support receives a response from the allocated tutor, it will be made available to the learner in the portal. The support desk system is in place to assist the learners adequately and streamline all the support processes efficiently. Quality learning materials made by industry experts is a significant competitive edge of the School of Business & Technology London. Quality learning materials comprised of structured lecture notes, study guides, practical applications which includes real-world examples, and case studies that will enable you to apply your knowledge. Learning materials are provided in one of the three formats, such as PDF, PowerPoint, or Interactive Text Content on the learning portal. How does the Online Learning work at SBTL? We at SBTL follow a unique approach which differentiates us from other institutions. Indeed, we have taken distance education to a new phase where the support level is incredibly high.Now a days, convenience, flexibility and user-friendliness outweigh demands. Today, the transition from traditional classroom-based learning to online platforms is a significant result of these specifications. In this context, a crucial role played by online learning by leveraging the opportunities for convenience and easier access. It benefits the people who want to enhance their career, life and education in parallel streams. SBTL's simplified online learning facilitates an individual to progress towards the accomplishment of higher career growth without stress and dilemmas. How will you study online? With the School of Business & Technology London, you can study wherever you are. You finish your program with the utmost flexibility. You will be provided with comprehensive tutor support online through SBTL Support Desk portal. How will I get tutor support online? School of Business & Technology London occupies a centralised tutor support desk portal, through which our support team liaise with both tutors and learners to provide guidance, assessment feedback, and any other study support adequately and promptly. Once a learner raises a support request through the support desk portal (Be it for guidance, assessment feedback or any additional assistance), one of the support team members assign the relevant to request to an allocated tutor. As soon as the support receive a response from the allocated tutor, it will be made available to the learner in the portal. The support desk system is in place to assist the learners adequately and to streamline all the support process efficiently. Learners should expect to receive a response on queries like guidance and assistance within 1 - 2 working days. However, if the support request is for assessment feedback, learners will receive the reply with feedback as per the time frame outlined in the Assessment Feedback Policy.

You will learn how to become a Python developer through this course.