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

4700 Business Management courses

VPMMA: Building Our Future Project Management Workforce

By IIL Europe Ltd

VPMMA: Building Our Future Project Management Workforce A tremendous project management talent pool exists but is unknown to many: Since every mission or exercise a military leader is tasked with is a temporary endeavor expected to produce unique goods, services or results, this means they have a significant amount of project management experience.An estimated 58% of the 250,000 service members that transition back into the civilian workforce each year are military leaders, i.e. high enough rank to be consistently tasked with projects, meaning we could consider an additional 145,000 experienced individuals a year for our project management roles! However, these PM candidates lack context about the civilian project environment, which presents a unique opportunity for mentorship, professional development and placement of these talented, experienced, proven project managers.Since January 2018, a collaboration between two project management companies has matched experienced PMs from industry with Military and Veteran PMs entering the profession, with astounding results! In just over a year, the Veteran Project Manager Mentor Alliance (VPMMA) has attracted 200+ participants across 29 states and 5 countries, and built partnerships with industry leading organizations such as Arizona State University, International Institute for Learning, Sensei Project Solutions and PM Master Prep.

VPMMA: Building Our Future Project Management Workforce
Delivered Online On Demand3 hours
£15

The Practical Application of Advanced Analysis Tools to Improve Project Success

By IIL Europe Ltd

The Practical Application of Advanced Analysis Tools to Improve Project Success The Practical Application of Advanced Analysis Tools to Improve Project Success Advanced analysis techniques are often presented in such a way that they are not only confusing but don't seem applicable or worth the time. Unfortunately, because of a lack of understanding of when and how to apply various quality and statistical tools, these tools are underutilized or completely disregarded. The result is missed opportunities for real improvement. This presentation will introduce basic yet powerful tools which can help a project team better understand the drivers to customer satisfaction and other important metrics of the business. If a project manager wants to take the next step in terms of knowledge and skill set enhancement, they need to learn about and apply advanced analysis techniques to tackle the toughest problems. It's that simple. This and other IIL Learning in Minutes presentations qualify for PDUs. Some titles, such as Agile-related topics may qualify for other continuing education credits such as SEUs, or CEUs. Each professional development activity yields one PDU for one hour spent engaged in the activity. Some limitations apply and can be found in the Ways to Earn PDUs section that discusses PDU activities and associated policies. Fractions of PDUs may also be reported. The smallest increment of a PDU that can be reported is 0.25. This means that if you spent 15 minutes participating in a qualifying PDU activity, you may report 0.25 PDU. If you spend 30 minutes in a qualifying PDU activity, you may report 0.50 PDU.

The Practical Application of Advanced Analysis Tools to Improve Project Success
Delivered Online On Demand15 minutes
£15

Professional Certificate Course in Understanding the Basics of Financial Statements and Auditing in London 2024

4.9(261)

By Metropolitan School of Business & Management UK

This course provides an overview of financial statements and auditing, covering topics such as the purpose of financial statements, the different types of financial statements, the auditing process, and the roles and responsibilities of auditors. After the successful completion of the course, you will be able to learn about the following; Understand the accounting concept, including its definition and its role in business. Identify the historical events and developments that have shaped financial accounting practices. Define financial statements and describe their purpose in financial reporting. Differentiate between the different types of financial statements, including balance sheets, income statements, cash flow statements, statements of changes in net assets, and notes to the financial statements. Explain the concept of auditing and its importance in ensuring the accuracy and reliability of financial statements. Trace the evolution of auditing systems over time and describe the key developments that have shaped modern auditing practices. Identify the different types of audits, including external, internal, and government audits. Describe the four phases of an audit cycle and the activities during each phase. Define the role of an auditor and identify the key skills and functions required to be an effective auditor. This course provides a comprehensive introduction to financial accounting and auditing, covering the fundamental principles and concepts that underpin these fields. The course begins by exploring the concept of accounting and its historical development, providing students with a broad understanding of the role that accounting plays in business. The course then delves into financial statements, examining the different types of financial statements organizations use to report their financial performance, including balance sheets, income statements, cash flow statements, and statements of changes in net assets. Students will learn how to read and interpret these financial statements and understand the key metrics and ratios used to assess a company's financial health. This course provides an overview of financial statements and auditing, covering topics such as the purpose of financial statements, the different types of financial statements, the auditing process, and the roles and responsibilities of auditors. VIDEO - 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. Understanding the Basics of Financial Statements & Auditing Self-paced pre-recorded learning content on this topic. Understanding the Basics of Financial Statements & Auditing 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. CEO, Director, Manager, Supervisor Accountants Auditors Financial analysts Investment analysts Business managers Entrepreneurs Financial consultants Tax professionals Bankers Students pursuing a degree in accounting or finance 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.

Professional Certificate Course in Understanding the Basics of Financial Statements and Auditing in London 2024
Delivered Online On Demand14 days
£28

Understand Piping & Instrumentation Diagrams P&IDs

4.9(27)

By Apex Learning

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

Understand Piping & Instrumentation Diagrams P&IDs
Delivered Online On Demand8 hours 26 minutes
£12

R Programming for Data Science

4.9(27)

By Apex Learning

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

R Programming for Data Science
Delivered Online On Demand6 hours 25 minutes
£12

Microsoft Excel: Automated Dashboard Using Advanced Formula, VBA, Power Query

4.9(27)

By Apex Learning

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

Microsoft Excel: Automated Dashboard Using Advanced Formula, VBA, Power Query
Delivered Online On Demand6 hours 8 minutes
£12

WELL Building Standard

4.9(27)

By Apex Learning

Flash Sale Now On | Gifts: PDF Certificate

WELL Building Standard
Delivered Online On Demand4 hours
£12

Agenda Organisation for Energy & Time Management

5.0(1)

By LearnDrive UK

Master the art of effective agenda organization with our comprehensive course on Energy & Time Management. Discover strategies to enhance focus, manage distractions, and optimize your daily routines for peak productivity and energy conservation.

Agenda Organisation for Energy & Time Management
Delivered Online On Demand1 hour
£5

Lean Organisation Management Techniques Level 2 Certificate Course

By Qdos Training Limited

Qualification Number 603/5253/X Minimum entry age 19 Guided Learning Hours 90 What does this qualification cover? This qualification will enable learners to understand and implement lean organisation techniques, business improvement tools and techniques and to work effectively in a business team. What are the entry requirements? There are no specific recommended prior learning requirements for this qualification. How is this qualification structured? The qualification is made up of three mandatory units: • Unit 1 Working in teams • Unit 2 Business improvement tools and techniques • Unit 3 Lean organisation techniques How is it assessed? This qualification is assessed via an internally assessed and externally verified portfolio of evidence. Funding for our qualifications This qualification is available fully funded under the Adult Education Budget funding stream and is free to the candidate.

Lean Organisation Management Techniques Level 2 Certificate Course
Delivered OnlineFlexible Dates
FREE

Establishing an Enterprise PMO

By IIL Europe Ltd

Establishing an Enterprise PMO Creating a PMO is difficult, but there are special approaches you can use to successfully establish a structure for project, program and portfolio management (PPM) at an enterprise level. This session provides frameworks and lessons learned that will guide you in creating an enterprise PPM function within your organization. This and other IIL Learning in Minutes presentations qualify for PDUs. Some titles, such as Agile-related topics may qualify for other continuing education credits such as SEUs, or CEUs. Each professional development activity yields one PDU for one hour spent engaged in the activity. Some limitations apply and can be found in the Ways to Earn PDUs section that discusses PDU activities and associated policies. Fractions of PDUs may also be reported. The smallest increment of a PDU that can be reported is 0.25. This means that if you spent 15 minutes participating in a qualifying PDU activity, you may report 0.25 PDU. If you spend 30 minutes in a qualifying PDU activity, you may report 0.50 PDU.

Establishing an Enterprise PMO
Delivered Online On Demand15 minutes
£10