Learn how to use Microsoft Project to create and resource robust project plans and how to maintain and track throughout the project lifecycle. Course overview Duration: 1 day (6.5 hours) Our Project Planning and Control course gives you the essential skills to use Microsoft Project to build, resource and monitor project schedules. It looks at initial setup, building plans, using a work breakdown structure and managing resources through to baselining and progressing your schedule. This course is designed for new or existing users of Microsoft Project, and no previous experience of Project is required. Knowledge of planning techniques would be an advantage. Objectives By the end of the course you will be able to: Create project schedules Build a Work Breakdown Structure Create relationships Set baselines Manage resources Set deadlines and task properties Print and report on your project Update and track project schedules Content Creating a new project Project defaults Project start date Setting default hours per day/week Setting daily working times Project timeline Building a project Creating a work breakdown structure Adding tasks and durations Estimated durations Setting milestones Recurring tasks Linking, Baselining and Resourcing Setting start dates and dependencies Task Inspector Resourcing Assigning resources Filtering available resources Baseline Setting a baseline Removing a baseline Managing resources Resource properties Dealing with over allocations Tasking information Constraint dates Setting deadline Assigning task specific calendars Task types Updating your project Completing work Completing work per resource Updating tasks Updating the project Rescheduling work Change highlighting Printing and reporting Setup and Printing Visual reports Using the Timeline Creating Dashboard reports
Get to grips with all the features of Teams, including calls and chats, Teams and Channels and Meetings Course overview Duration: 2 hours This session is aimed at those new or self-taught users of Teams to show them the features and how to setup and use it effectively. Objectives By the end of the course you will be able to: Use the core functions of Microsoft Teams Set up Microsoft Teams Make Calls Send Chats to colleagues via teams Set up channels Run Teams meetings Content What is Teams Teams elements Setting up your Teams Setting up audio and video Using voicemail Setting voicemail language Calls and Chats Sending individual and group chats Making and receiving calls Missed call notification Searching Teams and Channels Creating channels Channel settings Setting channel notifications Emailing channels Creating private channels Posting to channels Alerting specific people in a channel Adding files to channels Sending links to channels Teams Meetings Setting up meetings Running meetings from channels Setting backgrounds Screen sharing in meetings Handing over control Creating meeting notes Adding files to teams or meetings Using the meeting chat
Pediatric Examination Aims to These pediatric assessment and examination techniques are specific for pediatric patients. In this pediatric examination CPD course you will evaluate the physical, developmental, and functional aspects of children, the level of milestones, and the relation with normal growth and abnormal growth patterns or delayed milestones. You will explore evidence-based methodologies, expert guidance, and assessment scales to effectively address the needs of pediatric populations. By this certified CPD course for medical worker, pediatric history taking and physical examination will become easier. Learning Objective Understand the importance of pediatric assessment What are different age groups according to different organizations? This CPD Course will provide complete knowledge about pediatric general physical examination. In this CPD course, you will explore the milestones related to certain age groups and gain insight about the factors that affect developmental milestones. Understand typical vs atypical movement patterns in certain age groups supported by evidence-based research. Learn about the ICF model of pediatric assessment Physiotherapy assessment tool for pediatric Explore the clinical pediatric assessment and understand the pediatric assessment with the case study Become proficient in making pediatric examination reports. Understand the impact of multimodal pediatric examination in the clinical or hospital setting. By the end of this CPD course, you will be able to make the pediatric examination report by using the pediatric assessment scales. This CPD course will help to make informed decision about the treatment plan and to make referrals for serious conditions. Who Should Enroll Pediatric Physiotherapist Pediatric Orthopedic Medical Students Pediatric Nurses Occupational Therapist CPD Credit Hours 2 Hours 30 min Resources 1-Month Access to Learning Resources Downloadable Course Material CPD Certificate Course Instructor: Dr. Khadija Fareed (DPT, MS Pain Management, PPTA) is a skilled physiotherapist with five years of clinical experience. She holds a degree in physiotherapy from RLMC and a master's in pain management from Superior University. Dr. Khadija Fareed has worked in orthopedic departments, she also served as an academic physiotherapist, and presented at conferences. Her commitment to patient care and professional development makes her a valuable asset in the field. Course Instructor About Physiotherapy Online Physiotherapy Online is a physiotherapist-owned educational company with a vision to create an ensemble of international educators to cater to undergraduate, postgraduate physiotherapy students as well as post professionals who are keen to advance or refesh their existing knowledge in varied specialties. As every student has a unique approach to learning, we have therefore created a library of bite sized chapters which may be accessed as an individual module or a course as a whole; self study webinars; live workshops for those who would like to get an in-person hands on immersive experience and audio books for those on the go.
English as a foreign language Prepare to pass the citizenship English language test (IELTS life skills) Classes from A1 to B1 level of the CEFR (Common European Framework of Reference for Languages) . A1-A2 Elementary This course is designed for students of English who have little knowledge of the English language and want to achieve a better level. The course will focus on speaking practice, reading comprehension and pronunciation skills, writing and grammar. The syllabus: countries, numbers, possessive pronouns, days of the week, pronunciation skills (linking, stress, intonation). Family vocabulary and everyday objects; present tense of most common regular and irregular verbs. Asking questions and talking about activities, can and can’t, transports, some and any, how much and how many. Past simple, regular and irregular verbs, ordering food and drinks, dates and other past time phrases, buying tickets, asking politely, past simple, negative forms and questions, shops and shopping for clothes. Comparative adjectives, use of articles, going out and staying in, might and will, education and careers, filling a form, present perfect and sentence stress. Prepositions of movement, going places and describing things in a town, real life: for example, telephoning; consolidation activities. A2 - B1 Pre-intermediate This course will develop further your English language skills acquired with the Elementary course. This course will help you with the preparation for the citizenship test. Each lesson will focus on a grammar topic, vocabulary, reading and pronunciation practice, writing. The syllabus: revision of questions; present simple and frequency phrases. Talking about leisure activities and games, past simple, positive and negative, time phrases (at, on, in ago), describing feelings, talking about daily routines and jobs; should and shouldn’t, present continuous for future arrangements; inviting people; Comparative and superlative adjectives, questions with: how, what and what … like? Describing people; vowel sounds and silent letters, weak forms of prepositions. Quantifiers with countable and uncountable nouns, asking and giving directions. Present tense after if, adjectives for describing places, talking about how things were in the past, used to, past continuous, talking about health. Like and would like, conditional sentences with would, present simple passive and past simple passive, talking about products and personal items, writing a review, giving your opinion. Present perfect continuous and past perfect. Job interviews, getting a job and personal characteristics, meeting people; making suggestions. B1 - B2 Intermediate Asking and answering questions: everyday activities, people around you. The difference between have and have got. Speaking practice. E-mail writing (informal). Pronunciation and stress sounds activities. Past simple and continuous. Pronunciation of the -ed sound for past simple endings. Vocabulary: remembering and forgetting. Listening and speaking: first meetings and childhood memories (used to). Real life: showing interest. Pronunciation: sounding polite. Speaking practice. The sound /w/. Comparatives and superlatives. Describing towns and cities. Readings and discussions topics about travel and places to visit. Phrases for comparing. Design your own tour. Real life: booking a flight. Present perfect simple: strong and weak forms of ‘have’. Describing life events. Speaking: talking about people you admire. Writing task: curriculum vitae. Vocabulary: ‘take’. For, since and ago and the present perfect continuous. Pronunciation: linking. Comparing the past and the present. Future forms and future clauses with if, when etc. Talking about work. How to write a covering letter. Real life: a formal telephone call. Adjectives: -ed/-ing. Extreme adjectives. Write a review of a book/concert. Writing a consumer review. The passive forms. Speaking practice. Ripetizioni d’inglese Who these courses are for: Italian speakers who live in the UK who want to improve their skills to pass the UK citizenship exams (IELTS life skills). for Italian schoolchildren who need to prepare for exams (such as ‘esame di maturita’). for Italian students who want to improve their grades at school or simply need help with homework. for adults who want to improve their English for work or travel. IELTS – International English Language Testing System Life in the UK Test
Learn how create and structure enterprise projects and programmes. Course overview Duration: 2 days (13 hours) Our P6 Project Planning and Controls Fundamentals course is an intensive two day course aimed at experienced planners and project controllers who need to use Primavera to create and manage detailed plans. It includes creating EPS levels, projects, WBS levels and detailed activity and resource planning. Experience of project planning and scheduling techniques is essential. Objectives By the end of the course you will be able to: Create a programme structure Create projects and set project properties Create programme milestones Create a Work Breakdown Structure (WBS) Create detailed plans including activities, links and resources Progress the schedule Manage actuals Customise layouts Use the reporting tools in Primavera Content Programme Management Creating EPS elements Defining the programme structure Navigating the EPS structure Finding programmes Project Management and WBS Creating projects Setting project properties Validating projects Assigning project codes Building a work breakdown structure Creating a WBS structure Creating WBS elements Work package management Top Down budgets Allocating top down budgets Budget change Programming milestones and activity planning Creating programme milestones Setting constraints Linking milestones Scheduling Using the schedule function Detailed activity planning Creating activities Relationship types Creating relationships Adding milestones Assigning activity codes Resourcing, workloads and baselining Resource types Creating resources Resource attributes Assigning resources Switching resources Split load resource assignment Reduced hours resource assignment Checking workload Reviewing workload Dealing with resource conflicts Assignments view Baselining Creating baselines Assigning baselines Working with layouts Creating layouts Customising columns Setting filters Sorting and grouping Changing the timescale Customising the Gantt Creating activity code breakdown structures Progressing the schedules Updating task status and remaining duration Setting the data date Monitoring and reporting Exporting and importing information Primavera standard reports Creating custom reports Creating portfolios Printing Printing your schedule Printing to other packages
Unlock the power of effective negotiation. Gain essential skills to navigate complex deals, build lasting partnerships, and achieve optimal outcomes. Course overview Duration: 1 day (6.5 hours) This course is designed for those who need to understand and be able to use essential negotiation skills to make them more effective in their role. Externally you maybe negotiating with suppliers, customers, regulatory authorities and other organisations. Internally you will be negotiating with stakeholders, colleagues, and team members which could be for resources, time, budget or facilities. Being able to negotiate agreements that are acceptable to all parties requires skill and is essential to maintain healthy, functional relationships. This will be a facilitated workshop designed to be flexible to achieve the desired outcome. We will achieve the objectives through a mixture of facilitated discussion, interactive exercises designed to give insight and facilitator input. During the day we will deal with the stages of a negotiation from preparation to closing. Individuals will get the opportunity to practice the skills needed to create win-win outcomes through a number of generic but realistic scenarios. Objectives By the end of the course you will be able to: State the principles of effective negotiation Prepare effectively for different types of negotiation Set negotiation objectives and identify what can be ‘traded’ Explain how assertiveness and influencing skills can affect outcomes Deploy appropriate strategies and tactics to achieve the best results Use different techniques to deal with difficult customers and difficult situations Content Influencing Seek first to understand, and then be understood The importance of understanding the other party’s position and how to do it The power of non-verbal communication Dealing with difficult customers and difficult situations whilst maintaining a positive relationship How to approach negotiations Identifying potential negotiations and preparing for potential outcomes Aiming for results which deliver win/win outcomes Developing a win/win mindset and behaviours Rights and responsibilities of negotiators Setting Negotiation Objectives Clarifying essential, desirable and ideal objectives Assessing the most favoured, realistic target and walk away positions The Negotiation Process The importance of preparation Creating an opening proposal Where to pitch the opening proposal Bargaining/Trading - Gaining Momentum Knowing your parameters – what can be traded? Choosing a strategy and tactics Dealing with questionable tactics and ploys Building rapport – the communication process Asking the right questions and active listening Being assertive, demanding your rights and ensuring you meet your responsibilities Closing Techniques Trial and actual closing techniques Signalling Summarising and documenting the agreement Follow up and implementation of the deal
Discover the amazing features this tool has to offer in combining, collating and editing documents and the forms, markups and redaction techniques available. Duration 1 day (6.5 hours) Overview This Adobe Acrobat course looks at the powerful features of the tool quite often overlooked. The course requires the use of either the Standard or Professional versions of Acrobat as the free Acrobat Reader only has limited functionality. Learn how to combine documents into a single file, edit and mark up PDFs, compare documents, redact data from documents and create fillable forms. Objectives By the end of the course you will be able to: Create PDFs from other tools Set security Collate and combine files into a single PDF Edit PDF files Complete and sign documents Create fillable forms Mark up PDF documents Compare files Redact data Content Creating PDFs Building PDF documents from Word, Excel and PowerPoint Setting PDF options for print, image quality and security Working in Acrobat Home, Tools and Document Views Using the Navigation Panel and Pane Floating toolbar and Contextual menus Collating and Combining Files Combining multiple files into a single PDF Adding extra files Deleting pages and reorganising pages Editing Files Editing text and graphics Adding text and images Adding headers and footers, watermarks and backgrounds Adding Links Adding manual links Automatic links Completing and signing documents Using fill and sign to complete forms Adding signatures Creating Fillable and Signable Forms Prepare a form Autodetect fillable fields Add manual fillable fields Adding drop downs, check boxes, etc. Naming fields Setting field properties Previewing the form Marking Up Documents Marking up changes Using sticky notes Using the highlighter pen Adding stamps Attaching documents and audio Replying to comments Comparing Files Selecting settings Comparison report Reviewing differences Using the changes pane Redacting Data (Acrobat Professional only) Setting redaction options Redacting chosen text Searching and redacting words, phrases or patterns Redacting whole pages Applying redaction
Learn how to work with and connect multiple data sets to effectively analyse and report on data. Course overview Duration: 1 day (6.5 hours) Within Excel you have some powerful features to enable you to connect and analyse multiple data sources. Power Query enables you to import and manipulate your data, Power Pivot enables you to connect multiple data sources and create pivot tables and pivot charts from them. This course is an introduction to Power Query and Power Pivot in Excel to get you started on creating a powerful reporting capability. Knowledge of working with Excel workbooks and relational databases would be an advantage. Objectives By the end of the course you will be able to: Import data from multiple data sources Edit and transform data before importing Add extra columns of data Append data Merge data from other tables Create data models Build data relationships Build Pivot Tables Build Pivot Charts Use Slicers and Timeline Filters Content Importing data Data sources Importing data Transforming data Editing your data Setting data types Removing columns/rows Choosing columns to keep Setting header rows Splitting columns Appending queries Appending data from other tables Adding text Columns from example Custom columns Conditional columns Merge queries Setting up and using merge queries Merging in columns of data Creating a data model The data model Multiple data tables Connecting tables Building relationships Relationship types Building visuals from multiple tables Analysing information using pivot tables Creating and modifying a Pivot Table Recalculating the Pivot Table Filtering the Pivot Table Searching the Pivot Table Drilling down to underlying data Customising field names Changing field formatting Pivot charts, slices and timelines Creating Pivot Charts Adding and using Slicers
Ideal for those already using Excel but who really want to get to grips with formulas and functions. Course overview Duration: 1 day (6.5 hours) Our Excel Mastering Formulas and Functions course looks at how to confidently use formulas and functions within Excel. It looks at how to correctly construct formulas and explains how to build common formulas such as working with percentages. It investigates a range of built in Excel functions and shows you how to use the formula auditing tools to help when things go wrong. This course is aimed at existing users of Excel who want to further their skills. Participants should be able to confidently create and amend worksheets. Objectives By the end of the course you will be able to: Construct Formulas Use a range of common Functions Work with absolute and relative references in formulas Create percentage calculations Use named ranges in formulas Use the XLOOKUP command Create formulas with date and use date functions Use formulas in conditional formatting Use a range of Count functions Use the formula auditing tools Content Formulas vs Functions Constructing formulas Using functions Common Excel functions Using the function wizard vs the formula bar Formulas in tables Absolute vs relative references in formulas Using absolute references in formulas Using partial absolute referencing Range Naming Naming ranges Using range names in formulas Single and multi-cell ranges Working with percentages Creating formulas with percentages Percentage breakdowns Percentage increases Formatting as a percentage Using Lookups Using XLOOKUP to insert information from other spreadsheets Calculating with dates Calculating with dates Using date functions Using formulas in conditional formatting Using conditional formulas Using functions in conditional formatting Count functions COUNT COUNTA COUNTBLANK Formula auditing Using the auditing facility Tracing how formulas are made up Tracing precedents and dependants Evaluating formulas Error checking Showing formulas on a sheet
Following on from the Macros course look at how you can write your own Visual Basic code within Excel to fully automate tasks and save time. Course overview Duration: 2 days (13 hours) Our VBA in Excel course is an introduction to using the Visual Basic for Applications language for programming in Excel. It looks at structures, syntax and coding standards. This course is designed for existing experienced users of Excel who can record and run macros and those who have dabbled in VBA but would like some formal training and help to put some structure to their code. Objectives By the end of the course you will be able to: Write visual basic procedures Create event and general procedures Use commands from the Excel data model Use statements and functions Use a selection of debugging tools Create and use variables and constants Use different types of loops Create an Excel user form Content The VBA environment Project explorer Excel objects Modules Properties window Code window Code structure Code structure Navigating within your code Adding comments Using WITH Steps to creating a VBA procedure Procedures Sub procedures Event procedures Calling procedures The Excel data model Workbook commands Worksheet commands Excel selection methods Data manipulation commands Debugging Using breakpoints Stepping through code The immediate window The watch window The locals window points Variables and Constants Declaring variables Declaring multiple variables Variable data types Concatenation Scope of variables Constants Declaring constants Using constants Scope of constants Looping Do while loops Do until loops For next loops Conditional Statements IF statement SELECT CASE statement Comparison statements Logical operators Creating a User Form Form layout The control toolbox Naming conventions Adding objects Naming objects Captions Displaying the form Object properties Object properties Setting properties at design time Setting properties at run time Interconnectivity between the user form and Excel Comparing values Transferring information Running code