4441 Courses

Overview This comprehensive course on Creative Writing Complete Course will deepen your understanding on this topic.After successful completion of this course you can acquire the required skills in this sector. This Creative Writing Complete Course comes with accredited certification 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? You may have to take a quiz or a written test online during or after the course. After successfully completing the course, you will be eligible for the certificate. Who is this course for? There is no experience or previous qualifications required for enrolment on this Creative Writing Complete Course. It is available to all students, of all academic backgrounds. Requirements Our Creative Writing Complete Course 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 22 sections • 105 lectures • 13:54:00 total length •Introduction to Children's Writing: 00:02:00 •Crucial Information: 00:02:00 •Keys to Success: 00:02:00 •A.I.M: 00:04:00 •Getting Ideas: 00:02:00 •Character Creation: 00:02:00 •Characters and Plotting: 00:04:00 •Planning Your Story: 00:03:00 •Storytelling: 00:03:00 •Point of View: 00:04:00 •Technical Writing Issues: 00:04:00 •Story Structure: 00:02:00 •Picture Books 1: 00:03:00 •Picture Books 2: 00:03:00 •Picture Books 3: 00:02:00 •Easy Readers: 00:03:00 •Transition Books: 00:01:00 •Chapter Books: 00:02:00 •Junior Novels: 00:02:00 •Young Adult Fiction: 00:04:00 •Dialogue: 00:05:00 •Show don't Tell: 00:05:00 •Conclusion: 00:02:00 •Introduction to Short Story Writing: 00:06:00 •Who Am I to Run This Course?: 00:06:00 •It's All About Mindset: 00:07:00 •What Tools Do You Need To Succeed?: 00:05:00 •Mental Preparation: 00:06:00 •Time Management: 00:06:00 •Self Belief: 00:02:00 •Goal Setting: 00:01:00 •Subject Matter: 00:04:00 •Genre: 00:07:00 •Scope: 00:02:00 •Getting Ideas: 00:02:00 •The 7-Step Story Generator: 00:02:00 •Characters & Character Creation: 00:03:00 •Creating Protagonists: 00:07:00 •Character Motivation & Interactions: 00:03:00 •Story & Setting: 00:03:00 •The 5-Point Story Structure: 00:02:00 •Style & Tone: 00:02:00 •Point of View & Tense: 00:03:00 •Plotting & The Twist: 00:05:00 •Building a Short Story Template: 00:03:00 •Building a Short Story Template: 00:03:00 •All Hail Scrivener!: 00:04:00 •The Opening Paragraph: 00:03:00 •Fast Writing: 00:05:00 •The Second Draft: 00:04:00 •Polishing: 00:04:00 •It's All About Presentation: 00:04:00 •Dealing With Rejection: 00:02:00 •Rights and Payment: 00:01:00 •Kindle Publishing: 00:04:00 •Conclusion Short Stories: 00:02:00 •Module 1 Part 1 - Getting Ideas and How to Develop Them: 00:30:00 •Module 1 Part 2 - Inspiration and Finding The Time: 00:30:00 •Module 2 - What It Means To Be A Writer: 00:30:00 •Module 3 - Characters: 00:30:00 •Module 4 - Plotting and Story Construction: 00:30:00 •Module 5 - Theme, Templates & Outlining: 00:30:00 •Module 6 - Show Don't Tell: 00:30:00 •Module 7 - Punctuation, Grammar and some Basic Writing Rules: 00:30:00 •Module 8 - Scene Structure, Exposition and Story Rules: 00:30:00 •Module 9 - Chapter Structure, Vision and Focus: 00:30:00 •Module 10 - Fast Writing Without Fear or Censure: 00:30:00 •Module 11 - Editing, Re-writing & Polishing: 00:30:00 •Module 12 - Finishing, Submission & Publication: 00:30:00 •Lesson One: The History of Horror: 01:00:00 •Lesson Two: Characters and Concepts: 01:00:00 •Lesson Three: Location and Backdrop: 01:00:00 •Lesson Four: Story and Plotting: 01:00:00 •Lesson Five: Writing Issues: 01:00:00 •Lesson Six: Horror Markets: 01:00:00 •Introduction to Writing Fantasy: 01:00:00 •Writing Fantasy - Lesson One - Imagining Fantasy: 01:00:00 •Writing Fantasy - Lesson Two - World Building, Maps and Visualization: 01:00:00 •Writing Fantasy - Lesson Three - Characters, Races and Societies: 01:00:00 •Writing Fantasy - Lesson Four - Plotting, Questing and Traveling: 01:00:00 •Writing Fantasy - Lesson Five - Point of View, Artifacts and Magic: 01:00:00 •Writing Fantasy - Lesson Six - Resolutions and Sequels: 01:00:00 •Amusing Article About Fantasy Writing (because it's true!): 01:00:00 •Fantasy: Recommended Author & Book List: 01:00:00 •Fantasy Societies Listing: 01:00:00 •Mythological Creature Listing: 02:00:00 •Introduction to Writing the Thriller: 00:30:00 •The Thriller: Form and Function: 00:30:00 •Writing the Thriller: Lesson Two: 00:30:00 •Exercise 1 - Building Your Thriller: 00:00:00 •Writing the Thriller: Lesson Three: 00:30:00 •Exercise 2 - Building Your Thriller: 00:30:00 •Writing the Thriller: Lesson Four: 00:30:00 •Exercise 3 - Building Your Thriller: 00:30:00 •Writing the Thriller: Lesson Five: 00:30:00 •Exercise 4 - Building Your Thriller: 00:30:00 •Writing the Thriller: Lesson Six: 00:30:00 •Welcome to the Writer's Greatest Untapped Income Source: 00:15:00 •Introduction to Writing for TV, Cable and Satellite Networks: 01:00:00 •Your Ideas and How to Present Them: 01:00:00 •What's Different About TV Writing?: 01:00:00 •Scripting, Editing and the Story Bible: 00:30:00 •A Special Masterclass On Comedy Writing: 00:30:00 •The Money and How You Get Paid: 00:30:00 •Writing the Thriller: Lesson One: 00:30:00

Payroll Management

Overview This comprehensive course on R Programming for Data Science will deepen your understanding on this topic. After successful completion of this course you can acquire the required skills in this sector. This R Programming for Data Science 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? You may have to take a quiz or a written test online during or after the course. After successfully completing the course, you will be eligible for the certificate. Who is This course for? There is no experience or previous qualifications required for enrolment on this R Programming for Data Science. It is available to all students, of all academic backgrounds. Requirements Our R Programming for Data Science 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 23 sections • 129 lectures • 06:25:00 total length •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:01:00 •Engine and coding environment: 00:03:00 •Installing R and RStudio: 00:04:00 •RStudio: A quick tour: 00:04:00 •Arithmetic with R: 00:03:00 •Variable assignment: 00:04:00 •Basic data types in R: 00:03:00 •Creating a vector: 00:05:00 •Naming a vector: 00:04:00 •Vector selection: 00:06:00 •Selection by comparison: 00:04:00 •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 •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 •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 •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 •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 •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 •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 •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 •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 •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 •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 •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 •Mathematical functions: 00:05:00 •Data Utilities: 00:08:00 •Additional Materials: 00:00:00 •grepl & grep: 00:04:00 •Metacharacters: 00:05:00 •sub & gsub: 00:02:00 •More metacharacters: 00:04:00 •Additional Materials: 00:00:00 •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 •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 •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 •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 - R Programming for Data Science: 00:00: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

Flash Sale Now On | Gifts: PDF Certificate

Overview This comprehensive course on Microsoft Excel: Automated Dashboard Using Advanced Formula, VBA, Power Query will deepen your understanding on this topic. After successful completion of this course you can acquire the required skills in this sector. This Microsoft Excel: Automated Dashboard Using Advanced Formula, VBA, Power Query comes with accredited certification 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? You may have to take a quiz or a written test online during or after the course. After successfully completing the course, you will be eligible for the certificate. Who is this course for? There is no experience or previous qualifications required for enrolment on this Microsoft Excel: Automated Dashboard Using Advanced Formula, VBA, Power Query. It is available to all students, of all academic backgrounds. Requirements Our Microsoft Excel: Automated Dashboard Using Advanced Formula, VBA, Power Query 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 12 sections • 76 lectures • 06:08:00 total length •Course Outline and Introduction: 00:04:00 •Minimum Requirements for the Course: 00:01:00 •Prepayments Introduction: 00:01:00 •Month End Date Prepaid Expenses Amortization Calculation: 00:00:00 •Exact Prepaid Expenses Payment Date Calculation: 00:00:00 •Prepaid Expenses Accounting Definition: Prepayments: 00:03:00 •Prepaid Expense Example: How Accounting works for Prepayments: 00:03:00 •Advantages and Disadvantages of Prepaid Expenses: 00:03:00 •Introduction to PRO Excel Models and Formulas: 00:06:00 •Date Function: 00:05:00 •EOMONTH Function: 00:04:00 •DATEVALUE function: 00:03:00 •IF Function: 00:08:00 •IFS Function (Office 365 Only): 00:07:00 •VLOOKUP Function: 00:07:00 •MATCH Function: 00:05:00 •INDIRECT Function: 00:02:00 •NAMED Ranges: Name Manager: 00:03:00 •Advanced Version of VLOOKUP Function: 00:07:00 •Introduction to Model and Control Panel Tab (Important Sheet Tab): 00:08:00 •Formula Based Prepaid Expenses Model - Deep Dive (Part 1): 00:05:00 •Formula Based Prepaid Expenses Model - Deep Dive (Part 2): 00:06:00 •Formula Based Prepaid Expenses Model - Deep Dive (Part 3): 00:06:00 •IFS Function - Month End date Prepayment calculation: 00:04:00 •Prepaid Expenses - Closing Balance Summary Tab (Formula Based Summary): 00:09:00 •Protecting Formulas Cells and Fields in the Model: 00:04:00 •Exact Date Prepaid Amortisation calculation Intro: 00:03:00 •Formulas update and Model Changes for Exact Prepaid Exps Calculation: 00:03:00 •Formulas Update for Exact Date Prepaid Exps Amortisation (Part 1): 00:04:00 •Formulas Update for Exact Date Prepaid Exps Amortisation (Part 2): 00:03:00 •Formulas Update for Exact Date Prepaid Exps Amortisation (Part 3): 00:02:00 •Formulas Update for Exact Date Prepaid Exps Amortisation (Part 4): 00:07:00 •IFS Function - Exact Date Prepayments Amortisation: 00:04:00 •Data Validation Controls (Enhancing Data Input Controls with Protection): 00:10:00 •Bonus: Prepayment Model with Opening Balance Calculation (Part 1): 00:08:00 •Bonus: Prepayment Model with Opening Balance Calculation (Part 2): 00:09:00 •Additional Material: Resources: 00:00:00 •Power Query and Pivot Table Prepayment Summary Table Intro: 00:06:00 •What is Power Query and Some Awesome Resources for Power Query learning: 00:07:00 •Power Query and Pivot Table Summary - Deep Dive (Part 1): 00:05:00 •Power Query and Pivot Table Summary - Deep Dive (Part 2): 00:04:00 •Power Query and Pivot Table Summary - Deep Dive (Part 3): 00:05:00 •Power Query and Pivot Table Summary - Deep Dive (Part 4): 00:09:00 •Using Array Formulas to Add Formula Protection: 00:04:00 •Bonus: Allocate Prepaid Expenditure Cost Centre Wise - 1: 00:02:00 •Bonus: Allocate Prepaid Expenditure Cost Centre Wise - 2: 00:08:00 •Bonus: Prepayment Model with Opening Balance Calculation (PQ and PT Version): 00:13:00 •Changing Macros Security in Excel: 00:05:00 •Complete Walkthrough - Advanced VBA Prepaid Expenses Amortisation Model: 00:06:00 •Bonus : New Version - Excel VBA Model for Prepayment Expenditure: 00:08:00 •Dynamic Dashboard Overview: 00:07:00 •Importing Profit and Loss Statements Source Files and creating YTD P&L Sheets: 00:08:00 •Creating Dynamic Data Validation: 00:02:00 •Creating Named Ranges for Dynamic Table Arrays: 00:03:00 •Dynamic Date Column Headings for each Divisional PL Table: 00:02:00 •Dynamic Month and YTD Dashboard tables headings (PRO TIP): 00:03:00 •Dynamic VLOOKUP Formula - Preparing First section of the Dashboard: 00:04:00 •Creating Rolling Dashboard with Dynamic VLOOKUP Function: 00:08:00 •IMPORTANT : Error Checking for your reports/Dashboard (PRO TIP): 00:03:00 •Data Prep for Visualization: AREA Charts (Awesome trick using #NA Function): 00:05:00 •Visualization: AREA Charts for Month - Revenue, Gross Profit and Net Profit: 00:05:00 •Visualization DONUT Charts Revenue, Gross Profit and Net Profit (Part 1): 00:03:00 •Visualization DONUT Charts Revenue, Gross Profit and Net Profit (Part 2): 00:06:00 •Introduction - Formula-less Dashboard - Fully Dynamic and easily refreshed: 00:05:00 •Understanding the data files before building dashboard: 00:02:00 •Consolidating Reports with Power Query (Get & Transform) , How to install PQ: 00:08:00 •Dynamic File Path Trick in Power Query with Parameters (Amazing trick): 00:06:00 •Conditional Cumulative totals with SUMIFS Function: 00:04:00 •Bonus: Conditional Cumulative totals with Power Query Custom Formula (M Code): 00:06:00 •Dashboard Creation - Pivot Table showing Month and YTD KPIs division wise: 00:06:00 •Dashboard Creation Donuts Charts linked with Pivot Table (Replicate Charts fast): 00:08:00 •Dashboard Creation - Line Charts: 00:08:00 •Update Dashboard with Additional Divisional Data with Few Click (Magical): 00:03:00 •Thank you: 00:02:00 •Ultimate Prepaid Expenditure Model (Super Bonus): 00:02:00 •Resources - Microsoft Excel: Automated Dashboard Using Advanced Formula, VBA, Power Query: 00:00:00

This workshop will provide participants with the insight and skills to be more effective business networkers, face-to-face and online. The approach taken is to build on the strengths people already have and their successes. It is easier to develop what you already have than to try and develop skills that do not come easily. Being yourself is the most effective tool for business networking and building relationships. This course will help those attending: Appreciate the importance of networking, and different forms of networking Understand the dynamics of communication that are specific to networking Become more confident and assured when 'working' a room Improve their influencing skills, especially with people who are experts and in positions of authority 'Sell' themselves and promote their company Identify and manage their profiles using online social networking sites Use effective follow-up to maintain active contacts and connections Select the correct networking groups, clubs and events Create their own personal network 1 The importance, and different types, of networking Personal objectives and introductions Test networking session Examples of the importance, purpose and format of various types of networking, and benefits you can expect 2 How to work a room - preparation and strategy Three things to know before you attend any event Non-verbal communication and art of rapport Breaking the ice - worked examples with practical demonstration 3 Communication dynamics in networking - the power of the listening networker Why it is better to listen than talk Effective questioning and active listening Creating a natural and engaging conversation, 1-2-1 and in a larger group 4 Assumptions when networking How to use the 'instant judgement' of others to your advantage What assumptions are you making? How to keep an open mind 5 Business networking etiquette Meeting and greeting at a business networking event - approaching complete strangers and introducing yourself Socialising: joining and leaving groups easily Making a good first impression in 30 seconds The use of status when networking 6 Making connections Asking for cards, contact details and referrals Gaining a follow-up commitment Some tips and tricks 7 Business networking rehearsals Practice sessions 8 Personal business networking online Overview of different types of networking sites - there is a lot more out there than just Facebook! Examples of creating an effective profile Using social networking effectively - case studies and application 'Advanced' applications - blogs, articles, twitter, feeds, etc. Online demonstration and examples 9 Building relationships - follow-up and follow-through Maintaining a good database Developing a contact strategy with different types and levels of contact How to analyse your contact base

Many people have a misconception about networking events, and lose out on new business opportunities as a result. They either don't appreciate the real benefits and techniques of networking and don't attend events, or they attempt to 'sell on the first date', causing resentment. You can either attempt to make a sale for a quick buck (which is particularly likely to backfire at a networking event), or you can try to open a long-term relationship, creating new opportunities and a high lifetime value customer (which is how it's meant to be done). Networking, when done properly, is an excellent tool for referrals. But you have to appreciate that it's done on the basis of giving rather than receiving and this doesn't always come naturally to sales professionals. The old saying that it's about getting to 'know, like and trust' is still true. This workshop is about having your prospects and customers getting to know, like and trust you, and building that lifetime value as a result. By the end of this programme, participants will be able to: Understand what networking is - networking etiquette Know how and where to network Clarify their objectives - why network Use the 4 basic questions to start a conversation Build rapport quickly and easily Answer the question 'What do you do?' effectively in a few seconds Deliver a 60-second pitch Break into a group Prepare for a network meeting Identify opportunities Use tools to assist in networking 1 Introduction Aims and objectives 2 What is networking? Why network - objectives and goal setting Networking etiquette Preparation - online and offline tools to use Identify networking opportunities - where to network Know what you have to offer 'Know, like and trust' - the process 3 What do you do? Answer in 5-10 seconds Create and deliver a 60-second pitch Who is your target market? 4 Starting a conversation Breaking into a group Building rapport The 4 questions to start a conversation Moving on 5 Communicate and engage LISTEN - 4 types of listening skill Ask powerful questions Influence - don't sell What can you do to help others - give to get 6 Power of referrals Who can give you referrals? When to give or ask for referrals Have a referral system Showing appreciation 7 Social media and other online tools Using LinkedIn and other social media Online directories 8 Next steps Following up Arranging one-to-one meetings Developing relationships

This Professional Certificate Course in Risk Management and Ethical Considerations in Event Management aims to provide a comprehensive overview of crucial aspects in event planning. Participants will delve into the intricacies of risk management, ethical considerations, and legal issues, ensuring a responsible approach to event execution. The curriculum also explores current technology trends, with a special focus on virtual events, equipping participants to adapt to the evolving landscape. Additionally, the course addresses the broader impact of events on tourism destinations, guiding participants to evaluate, enhance positive impacts, and mitigate negative effects through strategic measures.After the successful completion of the course, you will be able to learn about the following: Risk management in event management. Ethical considerations in event management. Discuss legal issues in event management. Current technology trends for events management. Virtual Events. Evaluate the range of impacts that events can have on tourism destinations. Recommend measures to increase the positive impacts of events on tourism destinations Recommend measures to reduce the negative impacts of events on tourism destinations. This Professional Certificate Course in Risk Management and Ethical Considerations in Event Management aims to provide a comprehensive understanding of risk mitigation strategies and ethical practices within the event industry. Participants will delve into topics such as legal issues in event management, stay abreast of current technology trends, and explore the dynamics of virtual events. The course also addresses the intricate relationship between events and tourism destinations, guiding participants to evaluate the impacts and recommend measures to enhance positive effects while minimizing negative consequences. This Professional Certificate Course in Risk Management and Ethical Considerations in Event Management aims to provide a comprehensive understanding of risk management, focusing on identifying and mitigating potential challenges within the event industry. Participants will delve into ethical considerations inherent to event management, addressing moral dilemmas and ensuring responsible decision-making. The curriculum explores legal issues, empowering professionals to navigate the legal landscape of event planning. Additionally, the course covers current technology trends, with a specific focus on virtual events, enabling participants to adapt to the evolving landscape. Participants will also learn to evaluate the multifaceted impacts events can have on tourism destinations and develop strategic recommendations to enhance positive effects while mitigating negative impacts. Course Structure and Assessment Guidelines Watch this video to gain further insight. Navigating the MSBM Study Portal Watch this video to gain further insight. Interacting with Lectures/Learning Components Watch this video to gain further insight. Risk Management and Ethical Considerations in Event Management Self-paced pre-recorded learning content on this topic. Risk Management And Ethical Considerations In Event Management Put your knowledge to the test with this quiz. Read each question carefully and choose the response that you feel is correct. All MSBM courses are accredited by the relevant partners and awarding bodies. Please refer to MSBM accreditation in about us for more details. There are no strict entry requirements for this course. Work experience will be added advantage to understanding the content of the course.The certificate is designed to enhance the learner's knowledge in the field. This certificate is for everyone eager to know more and get updated on current ideas in their respective field. We recommend this certificate for the following audience, Event Managers and Planners Risk Management Professionals Ethical Decision-Makers in Event Industry Legal Advisors for Event Management Technology and Virtual Events Enthusiasts Tourism Destination Managers Professionals Seeking Comprehensive Event Education Average Completion Time 2 Weeks Accreditation 3 CPD Hours Level Advanced Start Time Anytime 100% Online Study online with ease. Unlimited Access 24/7 unlimited access with pre-recorded lectures. Low Fees Our fees are low and easy to pay online.

Duration 0.5 Days 3 CPD hours This course is intended for This course is intended for a wide range of managers and staff members who need to successfully manage small- to medium-sized projects. Overview Upon successful completion of this course, students will be able to: - plan the project and its parameters, including its scope, requirements, resources, and constraints. - implement the project plan, which includes putting the work of the project in motion and delegating tasks, and then monitoring the progress of the project and managing changes as they arise. In this course, students will identify methods of effectively managing small- to medium-sized projects and achieving their stated objectives. Planning the Project Define the Project Requirements Create Your Project Plan Implementing the Project Plan Execute the Project Plan Monitor the Progress of the Project Negotiate for Success Evaluate the Process