Overview Learn to use the full power and functionality of Microsoft's Excel and deliver impressive charts and analysis work. This Advanced Diploma in MS Excel course allows you to exploit the full abilities of Microsoft's best-selling tool and become capable of providing higher-quality results from it. You may use Excel every day in your work or business, but are you really using it to its full potential? With the advanced training from this course, you will quickly produce stunning spreadsheets and visually perfect graphs that will showcase business data to a much more professional degree. Use Excel to make your customer service excellent. How will I get my certificate? At the end of the course there will be a written assignment 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 Advanced Diploma in MS Excel. It is available to all students, of all academic backgrounds. Requirements Our Advanced Diploma in MS Excel is fully compatible with PC's, Mac's, Laptop, Tablet and Smartphone devices. This course has been designed to be fully compatible on tablets and smartphones so you can access your course on wifi, 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 Having these various qualifications will increase the value in your CV and open you up to multiple sectors such as Business & Management , Admin, Accountancy & Finance, Secretarial & PA, Teaching & Mentoring etc. Course Curriculum 21 sections • 90 lectures • 22:14:00 total length •Introduction to Microsoft Excel 2019 New Features: 00:07:00 •CONCAT: 00:02:00 •IFS: 00:01:00 •MAXIFS: 00:01:00 •MINIFS: 00:01:00 •SWITCH: 00:02:00 •TEXTJOIN: 00:01:00 •Map Chart: 00:02:00 •Funnel Chart: 00:01:00 •Better Visuals: 00:06:00 •Pivot Table Enhancements: 00:02:00 •Power Pivot Updates: 00:01:00 •Navigate the Excel User Interface: 00:28:00 •Use Excel Commands: 00:10:00 •Create and Save a Basic Workbook: 00:19:00 •Enter Cell Data: 00:12:00 •Use Excel Help: 00:05:00 •Create Worksheet Formulas: 00:15:00 •Insert Functions: 00:17:00 •Reuse Formulas and Functions: 00:17:00 •Insert, Delete, and Adjust Cells, Columns, and Rows: 00:10:00 •Search for and Replace Data: 00:09:00 •Use Proofing and Research Tools: 00:07:00 •Apply Text Formats: 00:16:00 •Apply Number Format: 00:08:00 •Align Cell Contents: 00:09:00 •Apply Styles and Themes: 00:12:00 •Apply Basic Conditional Formatting: 00:11:00 •Create and Use Templates: 00:08:00 •Preview and Print a Workbook: 00:10:00 •Set Up the Page Layout: 00:09:00 •Configure Headers and Footers: 00:07:00 •Manage Worksheets: 00:05:00 •Manage Workbook and Worksheet Views: 00:07:00 •Manage Workbook Properties: 00:06:00 •Work with Ranges: 00:18:00 •Use Specialized Functions: 00:11:00 •Work with Logical Functions: 00:23:00 •Work with Date & Time Functions: 00:08:00 •Work with Text Functions: 00:11:00 •Sort Data: 00:10:00 •Filter Data: 00:10:00 •Query Data with Database Functions: 00:09:00 •Outline and Subtotal Data: 00:09:00 •Apply Intermediate Conditional Formatting: 00:07:00 •Apply Advanced Conditional Formatting: 00:05:00 •Create Charts: 00:13:00 •Modify and Format Charts: 00:12:00 •Use Advanced Chart Features: 00:12:00 •Create a PivotTable: 00:13:00 •Analyze PivotTable Data: 00:12:00 •Present Data with PivotCharts: 00:07:00 •Filter Data by Using Timelines and Slicers: 00:11:00 •Use Links and External References: 00:12:00 •Use 3-D References: 00:06:00 •Consolidate Data: 00:05:00 •Use Lookup Functions: 00:12:00 •Trace Cells: 00:09:00 •Watch and Evaluate Formulas: 00:08:00 •Collaborate on a Workbook: 00:19:00 •Protect Worksheets and Workbooks: 00:08:00 •Apply Data Validation: 00:13:00 •Search for Invalid Data and Formulas with Errors: 00:04:00 •Work with Macros: 00:18:00 •Create Sparklines: 00:07:00 •MapData: 00:07:00 •Determine Potential Outcomes Using Data Tables: 00:08:00 •Determine Potential Outcomes Using Scenarios: 00:09:00 •Use the Goal Seek Feature: 00:04:00 •Forecasting Data Trends: 00:05:00 •Create a Macro Using the Macro Recorder: 01:00:00 •Edit a Macro: 01:00:00 •Debug a Macro: 00:30:00 •Customize the Quick Access Toolbar and Hotkeys: 00:30:00 •Set Macro Security: 01:00:00 •Insert Text: 00:30:00 •Format Text: 00:30:00 •Sort Data: 00:30:00 •Duplicate Data: 01:00:00 •Generate a Report: 01:00:00 •Determine the Dialog Box Type: 00:15:00 •Capture User Input: 01:00:00 •Insert, Copy, and Delete Worksheets: 00:30:00 •Rename Worksheets: 00:30:00 •Modify the Order of Worksheets: 00:15:00 •Print Worksheets: 00:30:00 •Create User-Defined Functions: 00:30:00 •Automate SUM Functions: 00:30:00 •Resources - Microsoft Excel - Beginner Course - Cpd Accredited: 00:00:00 •Assignment - Advanced Diploma in MS Excel: 00:05:00
Overview This comprehensive course on Typescript Level 4 will deepen your understanding on this topic. After successful completion of this course you can acquire the required skills in this sector. This Typescript Level 4 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? After successfully completing the course 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 Typescript Level 4. It is available to all students, of all academic backgrounds. Requirements Our Typescript Level 4 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 • 90 lectures • 04:07:00 total length •Module 01: What and why TypeScript: 00:02:00 •Module 02: TypeScript Playground: 00:04:00 •Module 03: Install TypeScript: 00:02:00 •Module 04: Install Visual Studio Code: 00:01:00 •Module 01: Introduction: 00:03:00 •Module 02: First Program Using Visual Studio Code: 00:04:00 •Module 03: Use JS in a HTML: 00:02:00 •Module 04: Strings: 00:02:00 •Module 05: Boolean: 00:01:00 •Module 06: Any Type: 00:01:00 •Module 07: Homogenous Arrays: 00:03:00 •Module 08: Heterogeneous Arrays: 00:01:00 •Module 09: Using alert confirm and prompt: 00:03:00 •Module 10: Comments: 00:02:00 •Module 11: Enum Type: 00:05:00 •Module 01: Arithmetic: 00:03:00 •Module 02: Assignment: 00:04:00 •Module 03: Comparison: 00:04:00 •Module 04: Logical: 00:04:00 •Module 05: Ternary: 00:03:00 •Module 01: Introduction: 00:01:00 •Module 02: IF Else Ladder: 00:06:00 •Module 03: Switch: 00:04:00 •Module 04: Break and Case Flow: 00:03:00 •Module 05: While loop: 00:03:00 •Module 01: Introduction: 00:02:00 •Module 02: Object Literal: 00:03:00 •Module 03: For-In Loop: 00:02:00 •Module 04: Arrays: 00:04:00 •Module 05: De-Structuring Arrays: 00:02:00 •Module 06: De-Structuring Objects: 00:02:00 •Module 01: Introduction: 00:02:00 •Module 02: First Function: 00:03:00 •Module 03: Passing a parameter: 00:01:00 •Module 04: Passing Multiple Parameters: 00:02:00 •Module 05: Optional Parameters: 00:04:00 •Module 06: Default Values: 00:01:00 •Module 07: Function as parameter: 00:02:00 •Module 08: Returning a function: 00:03:00 •Module 09: Anonymous Functions: 00:02:00 •Module 10: Overloading: 00:05:00 •Module 11: REST PARAMS: 00:05:00 •Module 12: Using a Type on REST PARAM: 00:01:00 •Module 01: Introduction: 00:02:00 •Module 02: First arrow function: 00:03:00 •Module 03: Passing Parameters: 00:03:00 •Module 04: Array of Arrow Functions: 00:03:00 •Module 01: let: 00:03:00 •Module 02: const: 00:02:00 •Module 02: const functions: 00:02:00 •Module 04: declare: 00:01:00 •Module 01: Introduction: 00:02:00 •Module 02: Define an Object Interface: 00:03:00 •Module 03: Create and object: 00:03:00 •Module 04: Defining optional properties: 00:01:00 •Module 05: Interfaces are only compile time: 00:01:00 •Module 06: Function Interfaces: 00:04:00 •Module 07: Return Types in Functional interfaces: 00:02:00 •Module 08: Adding methods to Object Interfaces: 00:02:00 •Module 09: Array Interfaces: 00:03:00 •Module 10: String indexed Array Interfaces: 00:03:00 •Module 11: Extending interfaces: 00:06:00 •Module 01: Introduction: 00:01:00 •Module 02: Create a class: 00:03:00 •Module 03: Add a constructor: 00:04:00 •Module 04: Add Function properties: 00:02:00 •Module 05: Power of TypeScript: 00:01:00 •Module 06: Using for-in and instanceof: 00:04:00 •Module 07: Implementing an interface: 00:06:00 •Module 01: Introduction: 00:03:00 •Module 02: Extending a class: 00:05:00 •Module 03: Create Child Objects: 00:07:00 •Module 04: Inheriting Functionality: 00:04:00 •Module 05: Overriding: 00:03:00 •Module 01: Public and readonly: 00:02:00 •Module 02: Encapsulation: 00:01:00 •Module 03: Private properties: 00:04:00 •Module 04: Accessor methods: 00:02:00 •Module 05: Using Static Properties: 00:04:00 •Module 06: More about static: 00:01:00 •Module 07: Static Methods: 00:03:00 •Module 01: String to numeric: 00:04:00 •Module 02: Using the toString method: 00:03:00 •Module 03: Object Casting: 00:02:00 •Module 01: Introduction: 00:01:00 •Module 02: Using Function Modules: 00:04:00 •Module 03: Import Aliasing and Alternate Export Syntax: 00:02:00 •Module 04: Default Exports: 00:02:00 •Module 05: Class Modules: 00:01:00 •Module 06: Aliasing class modules: 00:02:00
Overview This comprehensive course on Understand Piping & Instrumentation Diagrams P&IDs will deepen your understanding on this topic. After successful completion of this course you can acquire the required skills in this sector. This Understand Piping & Instrumentation Diagrams P&IDs 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 Understand Piping & Instrumentation Diagrams P&IDs. It is available to all students, of all academic backgrounds. Requirements Our Understand Piping & Instrumentation Diagrams P&IDs 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 Having these various qualifications will increase the value in your CV and open you up to multiple sectors such as Business & Management, Admin, Accountancy & Finance, Secretarial & PA, Teaching & Mentoring etc. Course Curriculum 14 sections • 119 lectures • 08:26:00 total length •Introduction: 00:04:00 •What's a P&ID ?: 00:03:00 •Why is a P&ID so important ?: 00:02:00 •Who uses P&ID's ?: 00:06:00 •How do P&ID's look like ?: 00:08:00 •Introduction- PID READING: 00:02:00 •Anatomy of a P&ID: 00:01:00 •The title block: 00:03:00 •The drawing scale: 00:03:00 •The grid system: 00:02:00 •The revision block: 00:03:00 •Changes: 00:02:00 •Notes and legends: 00:03:00 •Valve symbols: 00:14:00 •Valve actuator symbols: 00:09:00 •Control valve designations: 00:02:00 •Standards and conventions for valve status: 00:07:00 •Process equipment symbols: 00:12:00 •Piping symbols: 00:03:00 •Pipe fitting symbols: 00:03:00 •Isolating, venting & draining symbols for ease of maintenance: 00:05:00 •Instrumentation: 00:03:00 •Sensing devices and detectors: 00:04:00 •Location symbols: 00:04:00 •Modifiers and transmitters: 00:05:00 •Indicators and recorders: 00:03:00 •Controllers: 00:03:00 •Example #1 : Identifying process equipment and flow paths: 00:05:00 •Example #2 : Identifying valve position and failure mode: 00:03:00 •Example #3 : Identifying the symbols: 00:02:00 •Piping designation code: 00:06:00 •Equipment designation code: 00:03:00 •Instrument designation code: 00:02:00 •Miscellaneous designation codes: 00:02:00 •The process: 00:01:00 •Process control: 00:06:00 •The control loop: 00:02:00 •Process control terms: 00:10:00 •Control loops : Feedback control: 00:02:00 •Pressure control loops: 00:01:00 •Flow control loops: 00:01:00 •Level control loops: 00:01:00 •Temperature control loops: 00:01:00 •Multi-variable loops: 00:02:00 •Feedforward control: 00:02:00 •Feedforward + Feedback: 00:01:00 •Cascade control: 00:08:00 •Split range control: 00:03:00 •Operations on control signals: 00:02:00 •Ratio control: 00:02:00 •Batch control: 00:01:00 •Selective control: 00:01:00 •Do we need to control at all ?: 00:01:00 •Principles of equipment-wise control: 00:10:00 •Pipe control system: 00:02:00 •Control of a single pipe: 00:02:00 •Control of pressure in a pipe: 00:03:00 •Control of flow in a pipe: 00:04:00 •Flow merging: 00:08:00 •Flow splitting: 00:05:00 •Centrifugal pump control: 00:04:00 •Control valve vs Variable Frequency Drive (VFD) for centrifugal pumps: 00:03:00 •Minimum flow control for centrifugal pumps: 00:09:00 •Positive displacement pump control: 00:02:00 •Control by a recirculation pipe for PD pumps: 00:03:00 •Variable Speed Drive (VSD) control for PD pumps: 00:01:00 •Control by stroke adjustment for PD pumps: 00:01:00 •Compressor control system: 00:02:00 •Compressor capacity control: 00:12:00 •Compressor anti-surge control: 00:03:00 •Heat transfer equipment control: 00:02:00 •Heat exchanger direct control system: 00:04:00 •Heat exchanger bypass control system: 00:04:00 •Reactor temperature control: 00:06:00 •Air cooler control: 00:02:00 •Heat exchanger for heat recovery: 00:01:00 •Heat exchanger back pressure control: 00:02:00 •Basic fired heater control: 00:08:00 •Complex fired heater control: 00:05:00 •Container and vessel control: 00:07:00 •Container blanket gas control: 00:02:00 •Safety strategies: 00:01:00 •Concept of Safety Instrumented Systems (SIS): 00:01:00 •SIS actions and types: 00:14:00 •SIS extent: 00:02:00 •SIS requirement: 00:03:00 •Anatomy of a SIS: 00:02:00 •SIS element symbols: 00:01:00 •SIS primary elements : Sensors: 00:03:00 •SIS final elements: 00:04:00 •Switching valve actuator arrangements: 00:02:00 •Valve position validation: 00:02:00 •Merging a switching valve and a control valve: 00:03:00 •SIS logics: 00:01:00 •Showing safety instrumented functions on P&ID's: 00:07:00 •Discrete control: 00:05:00 •Alarm system: 00:02:00 •Anatomy of alarm systems: 00:02:00 •Alarm requirements: 00:06:00 •Alarm system symbology in P&ID's: 00:06:00 •Concept of common alarms: 00:01:00 •Fire and Gas Detection Systems (FGS): 00:03:00 •Electric motor control: 00:07:00 •P&ID representation of commands and responses: 00:05:00 •P&ID representation of inspection and repair: 00:05:00 •P&ID example of electro-motor control: 00:04:00 •P&ID example #1 : Legend and specifications: 00:05:00 •P&ID example #2 : Hydrogen delivery station: 00:16:00 •P&ID example #3 : Acid system: 00:13:00 •P&ID example #4 : Centrifugal pump: 00:09:00 •P&ID example #5 : Utility station: 00:04:00 •P&ID example #6 : Waste water filter: 00:08:00 •P&ID example #7 : Steam separator: 00:15:00 •P&ID example #8 : Flare knock-out drum: 00:14:00 •P&ID example #9 : Centrifugal compressor: 00:05:00 •P&ID example #10 : Hydrogen production from shale gas: 00:11:00 •P&ID example #11 : Fired heater: 00:07:00 •Resources - Understand Piping & Instrumentation Diagrams P&IDs: 00:00:00 •Assignment - Understand Piping & Instrumentation Diagrams P&IDs: 00:00:00
Delve into the world of data analysis with 'R Programming for Data Science,' a course designed to guide learners through the intricacies of R, a premier programming language in the data science domain. The course opens with a broad perspective on data science, illuminating the pivotal role of R in this field. Learners are then introduced to R and RStudio, equipping them with the foundational tools and interfaces essential for R programming. The curriculum progresses with an introduction to the basics of R, ensuring learners grasp the core principles that underpin more complex operations. A highlight of this course is its in-depth exploration of R's versatile data structures, including vectors, matrices, factors, and data frames. Each unit is crafted to provide learners with a comprehensive understanding of these structures, pivotal for effective data handling and manipulation. The course also emphasizes the importance of relational and logical operators in R, key elements for executing data operations. As the course advances, learners will engage with the nuances of conditional statements and loops, essential for writing efficient and dynamic R scripts. Moving into more advanced territories, the course delves into the creation and usage of functions, an integral part of R programming, and the exploration of various R packages that extend the language's capabilities. Learners will also gain expertise in the 'apply' family of functions, crucial for streamlined data processing. Further units cover regular expressions and effective strategies for managing dates and times in data sets. The course concludes with practical applications in data acquisition, cleaning, visualization, and manipulation, ensuring learners are well-prepared to tackle real-world data science challenges using R. Learning Outcomes Develop a foundational understanding of R's role in data science and proficiency in RStudio. Gain fluency in R programming basics, enabling the handling of complex data tasks. Acquire skills in managing various R data structures for efficient data analysis. Master relational and logical operations for advanced data manipulation in R. Learn to create functions and utilize R packages for expanded analytical capabilities. Why choose this R Programming for Data Science 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 R Programming for Data Science course for? Beginners in data science eager to learn R programming. Data analysts and scientists looking to enhance their skills in R. Researchers in various fields requiring advanced data analysis tools. Statisticians seeking to adopt R for more sophisticated data manipulations. Professionals in finance, healthcare, and other sectors needing data-driven insights. Career path Data Scientist (R Expertise): £30,000 - £70,000 Data Analyst (R Programming Skills): £27,000 - £55,000 Bioinformatics Scientist (R Proficiency): £35,000 - £60,000 Quantitative Analyst (R Knowledge): £40,000 - £80,000 Research Analyst (R Usage): £25,000 - £50,000 Business Intelligence Developer (R Familiarity): £32,000 - £65,000 Prerequisites This R Programming for Data Science does not require you to have any prior qualifications or experience. You can just enrol and start learning.This R Programming for Data Science 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 Unit 01: Data Science Overview Introduction to Data Science 00:01:00 Data Science: Career of the Future 00:04:00 What is Data Science? 00:02:00 Data Science as a Process 00:02:00 Data Science Toolbox 00:03:00 Data Science Process Explained 00:05:00 What's next? 00:02:00 Unit 02: R and RStudio Engine and coding environment 00:03:00 Installing R and RStudio 00:04:00 RStudio: A quick tour 00:04:00 Unit 03: Introduction to Basics Arithmetic with R 00:03:00 Variable assignment 00:04:00 Basic data types in R 00:03:00 Unit 04: Vectors Creating a vector 00:05:00 Naming a vector 00:04:00 Arithmetic calculations on vectors 00:07:00 Vector selection 00:06:00 Selection by comparison 00:04:00 Unit 05: Matrices What's a Matrix? 00:02:00 Analyzing Matrices 00:03:00 Naming a Matrix 00:05:00 Adding columns and rows to a matrix 00:06:00 Selection of matrix elements 00:03:00 Arithmetic with matrices 00:07:00 Additional Materials 00:00:00 Unit 06: Factors What's a Factor? 00:02:00 Categorical Variables and Factor Levels 00:04:00 Summarizing a Factor 00:01:00 Ordered Factors 00:05:00 Unit 07: Data Frames What's a Data Frame? 00:03:00 Creating Data Frames 00:20:00 Selection of Data Frame elements 00:03:00 Conditional selection 00:03:00 Sorting a Data Frame 00:03:00 Additional Materials 00:00:00 Unit 08: Lists Why would you need lists? 00:01:00 Creating a List 00:06:00 Selecting elements from a list 00:03:00 Adding more data to the list 00:02:00 Additional Materials 00:00:00 Unit 09: Relational Operators Equality 00:03:00 Greater and Less Than 00:03:00 Compare Vectors 00:03:00 Compare Matrices 00:02:00 Additional Materials 00:00:00 Unit 10: Logical Operators AND, OR, NOT Operators 00:04:00 Logical operators with vectors and matrices 00:04:00 Reverse the result: (!) 00:01:00 Relational and Logical Operators together 00:06:00 Additional Materials 00:00:00 Unit 11: Conditional Statements The IF statement 00:04:00 IFELSE 00:03:00 The ELSEIF statement 00:05:00 Full Exercise 00:03:00 Additional Materials 00:00:00 Unit 12: Loops Write a While loop 00:04:00 Looping with more conditions 00:04:00 Break: stop the While Loop 00:04:00 What's a For loop? 00:02:00 Loop over a vector 00:02:00 Loop over a list 00:03:00 Loop over a matrix 00:04:00 For loop with conditionals 00:01:00 Using Next and Break with For loop 00:03:00 Additional Materials 00:00:00 Unit 13: Functions What is a Function? 00:02:00 Arguments matching 00:03:00 Required and Optional Arguments 00:03:00 Nested functions 00:02:00 Writing own functions 00:03:00 Functions with no arguments 00:02:00 Defining default arguments in functions 00:04:00 Function scoping 00:02:00 Control flow in functions 00:03:00 Additional Materials 00:00:00 Unit 14: R Packages Installing R Packages 00:01:00 Loading R Packages 00:04:00 Different ways to load a package 00:02:00 Additional Materials 00:00:00 Unit 15: The Apply Family - lapply What is lapply and when is used? 00:04:00 Use lapply with user-defined functions 00:03:00 lapply and anonymous functions 00:01:00 Use lapply with additional arguments 00:04:00 Additional Materials 00:00:00 Unit 16: The apply Family - sapply & vapply What is sapply? 00:02:00 How to use sapply 00:02:00 sapply with your own function 00:02:00 sapply with a function returning a vector 00:02:00 When can't sapply simplify? 00:02:00 What is vapply and why is it used? 00:04:00 Additional Materials 00:00:00 Unit 17: Useful Functions Mathematical functions 00:05:00 Data Utilities 00:08:00 Additional Materials 00:00:00 Unit 18: Regular Expressions grepl & grep 00:04:00 Metacharacters 00:05:00 sub & gsub 00:02:00 More metacharacters 00:04:00 Additional Materials 00:00:00 Unit 19: Dates and Times Today and Now 00:02:00 Create and format dates 00:06:00 Create and format times 00:03:00 Calculations with Dates 00:03:00 Calculations with Times 00:07:00 Additional Materials 00:00:00 Unit 20: Getting and Cleaning Data Get and set current directory 00:04:00 Get data from the web 00:04:00 Loading flat files 00:03:00 Loading Excel files 00:05:00 Additional Materials 00:00:00 Unit 21: Plotting Data in R Base plotting system 00:03:00 Base plots: Histograms 00:03:00 Base plots: Scatterplots 00:05:00 Base plots: Regression Line 00:03:00 Base plots: Boxplot 00:03:00 Unit 22: Data Manipulation with dplyr Introduction to dplyr package 00:04:00 Using the pipe operator (%>%) 00:02:00 Columns component: select() 00:05:00 Columns component: rename() and rename_with() 00:02:00 Columns component: mutate() 00:02:00 Columns component: relocate() 00:02:00 Rows component: filter() 00:01:00 Rows component: slice() 00:04:00 Rows component: arrange() 00:01:00 Rows component: rowwise() 00:02:00 Grouping of rows: summarise() 00:03:00 Grouping of rows: across() 00:02:00 COVID-19 Analysis Task 00:08:00 Additional Materials 00:00:00 Assignment Assignment - R Programming for Data Science 00:00:00
The 'Making Budget & Forecast' course provides insights into the importance of budgeting and forecasting, distinguishing between operational and financial budgets. Participants will learn the components of revenue and cost budgets, as well as the logical steps involved in the budgeting process, including information requirements and linking revenue and operational plans. Learning Outcomes: Understand the significance of budgeting and forecasting in financial planning. Differentiate between operational and financial budgets. Identify the components of revenue and cost budgets. Recognize qualitative aspects that impact budgeting decisions. Gain knowledge about the logical steps involved in the budgeting process. Determine the information needed to develop revenue budgets. Analyze an example demonstrating the budgeting and planning process. Understand the process of cost budgeting and its link to revenue and operational plans. Explore other aspects related to the cost budgeting process. Why buy this Making Budget & Forecast? Unlimited access to the course for forever Digital Certificate, Transcript, student ID all included in the price Absolutely no hidden fees Directly receive CPD accredited qualifications after course completion Receive one to one assistance on every weekday from professionals Immediately receive the PDF certificate after passing Receive the original copies of your certificate and transcript on the next working day Easily learn the skills and knowledge from the comfort of your home Certification After studying the course materials of the Making Budget & Forecast you will be able to take the MCQ test that will assess your knowledge. After successfully passing the test you will be able to claim the pdf certificate for £5.99. Original Hard Copy certificates need to be ordered at an additional cost of £9.60. Who is this course for? This Making Budget & Forecast does not require you to have any prior qualifications or experience. You can just enrol and start learning. Prerequisites This Making Budget & Forecast was made by professionals and it is compatible with all PC's, Mac's, tablets and smartphones. You will be able to access the course from anywhere at any time as long as you have a good enough internet connection. Career path As this course comes with multiple courses included as bonus, you will be able to pursue multiple occupations. This Making Budget & Forecast is a great way for you to gain multiple skills from the comfort of your home. Course Curriculum Unit-01. Introduction Lecture-1 - Why Budget and Forecasts 00:11:00 Lecture-2- Is budget planning a paper exercise 00:05:00 Lecture-3- Operational and Financial Budget 00:07:00 Unit-02. Detail Budget Requirement Lecture-4 - Components - Revenue Budgets 00:05:00 Lecture-5 - Components - Cost Budget 00:11:00 Lecture-6 - Qualitative Aspects 00:05:00 Unit-03. Process of Making Budget Lecture-7- Process of Budgeting - Logical Steps 00:09:00 Lecture-8 - Revenue Budget - What Information we need to make revenue budgets 00:08:00 Lecture-9- Example we used in Class to demonstrate a broad process in budget and planning 00:17:00 Lecture-10 - Cost Budget Process - Link from revenue and operational plan 00:05:00 Lecture-11-Cost Budget Process - Other aspects 00:10:00 Assignment Assignment - Making Budget & Forecast 00:00:00
The NLP Practitioner course is designed to provide a comprehensive understanding of Neuro-Linguistic Programming (NLP) principles and techniques. Participants will learn the basics of NLP, explore key concepts like logical levels of change and cognitive dissonance, and delve into a wide range of NLP techniques for communication, influence, building rapport, time management, and personal development. Learning Outcomes: Gain insights into the fundamental principles and workings of Neuro-Linguistic Programming (NLP). Understand the logical levels of change and how they influence behavior and decision-making. Explore core concepts within NLP, including mental maps, confirmation bias, and cognitive dissonance. Learn various NLP techniques to plan and facilitate personal development and growth. Develop skills in effective communication, rapport-building, and influence using NLP methods. Master techniques for anchoring positive states, influencing others, and delivering impactful presentations. Discover the power of storytelling, metaphors, and affirmations in NLP communication. Explore models like GROW, FUEL, CLEAR, and OSCAR for goal setting, problem-solving, and decision-making. Why buy this NLP Practitioner? Unlimited access to the course for forever Digital Certificate, Transcript, student ID all included in the price Absolutely no hidden fees Directly receive CPD accredited qualifications after course completion Receive one to one assistance on every weekday from professionals Immediately receive the PDF certificate after passing Receive the original copies of your certificate and transcript on the next working day Easily learn the skills and knowledge from the comfort of your home Certification After studying the course materials of the NLP Practitioner there will be a written assignment test which you can take either during or at the end of the course. After successfully passing the test you will be able to claim the pdf certificate for £5.99. Original Hard Copy certificates need to be ordered at an additional cost of £9.60. Who is this course for? Individuals interested in self-improvement and personal development. Professionals in fields such as coaching, counseling, or training. Business leaders and managers seeking effective communication and influence skills. Anyone curious about Neuro-Linguistic Programming and its practical applications. Prerequisites This NLP Practitioner was made by professionals and it is compatible with all PC's, Mac's, tablets and smartphones. You will be able to access the course from anywhere at any time as long as you have a good enough internet connection. Career path NLP Coach: Help individuals achieve personal and professional goals through NLP techniques. Communication Trainer: Provide training in effective communication and rapport-building. Personal Development Speaker: Deliver seminars and workshops on personal growth and empowerment. Leadership Consultant: Assist leaders in enhancing their communication and influence skills. Therapist or Counselor: Integrate NLP techniques into therapeutic interventions. Course Curriculum Unit 01: Basics of Neuro-Linguistic Programming (NLP) Introduction to NLP 00:03:00 How Does NLP Work 00:03:00 Unit 02: Key Concepts in NLP Logical Levels of Change 00:08:00 Core Concepts of Neuro-Linguistic Programming 00:03:00 Understanding Mental Maps, Confirmation Bias, and Cognitive Dissonance 00:05:00 Unit 03: Application of NLP Techniques Neuro-Linguistic Programming Planning 00:03:00 Techniques of Neuro-Linguistic Programming 00:02:00 Taking Charge of Your Life 00:02:00 Communication 00:02:00 Building Rapport 00:03:00 States and Anchors 00:03:00 Influence and Persuasion 00:02:00 Hypnotising the Audience 00:03:00 Stories and Metaphors 00:03:00 Affirmations 00:02:00 Reframing 00:02:00 Meta Programs 00:03:00 Time and Timeline Therapy 00:02:00 Fast Phobia Cure 00:03:00 GROW Model 00:03:00 FUEL Model 00:03:00 CLEAR Model 00:04:00 OSCAR Model 00:03:00 Assignment Assignment - NLP Practitioner 00:00:00
Learn Excel for Business Accounting with our comprehensive course. From basic worksheet creation to advanced functions like pivot tables, charts, and data analysis, master Excel's features for efficient accounting tasks. Ideal for business professionals and students looking to enhance their Excel skills for financial management.
Master the essential mathematical skills and gain confidence for further study with our IGCSE Maths Course. Prepare for success in your exams with comprehensive coverage of all topics, including Previous Exams Solving, 2020 Specimen Solving, Examples of candidate response in previous years., and Additional General Questions. Enrol now to boost your confidence and achieve top scores in IGCSE Maths.
Acquire expertise in ESL teaching with our specialized ESL Teaching Diploma. Gain essential skills and strategies to effectively teach English as a Second Language, cater to diverse learners, and create engaging lessons. Enrol now to embark on a rewarding career empowering students to communicate confidently in English.
Embark on a journey of discovery and mastery with our Adventures in Excel Course. Explore the endless possibilities of Microsoft Excel as you learn essential tips, tricks, and techniques for spreadsheet management, data analysis, and visualization. Whether you're a beginner or seasoned user, this course offers exciting adventures to enhance your Excel skills and unlock new capabilities for productivity and efficiency in both personal and professional settings.