Special Executive Masters Programme (S.E.M.P) This programme is geared at enhancing professionals' careers. The SEMP is an encapsulated Senior Management Programmes are short certificate modules designed for anyone who would benefit from more in-depth business knowledge delivered in a short and intensive programme What makes us different? We are a world class business school located in the heart of London, Dubai, Islamabad and Lagos. We are one of the fastest growing British business schools with a stylish blended learning model that is both online and on campus. Learn more about the programme Special Executive Master's Programme in Personal Development Studies - Education Course Overview The MSBM Special Executive Masters Programmes (SEMP) allows you to update your skills, develop new skills, and explore and develop interests in a wide range of topics. These courses can be taken as personal or professional development and may enhance your employability. The SEMP Personal Development Studies - Education deals with approaches involved in the learning process, which are useful for tackling the process of organizing and taking in new information for development purposes. Online Students who enroll in this Programme will examine a section of development studies that focuses on personal development, soft skills improvement, and project management. In the modules, participants will also study research and development, business writing, and general communication skills. Study skills are skills that can be learned in a short time and can be applied to all fields or career path. The course provides a solid ground for enhancing your reading and writing skills demonstratable in a professional environment. Apart from inculcating team leadership and project management skills, the course will ensure the learner creates the best business presentations and write academic grade reports and essays. The course also provides a detailed explanation of key tools and concepts for researching and avoiding plagiarism. Course Details Mode of Study Using Web-based technology, this program provides self-paced, individualized instruction that can be taken anywhere and anytime an individual has access to a computer and the Internet. This Programme is suitable for successful professionals or specialists in the private, public, or voluntary sectors who have new management responsibilities and need to quickly expand their management knowledge. This Programme serves as a refresher course for those who have had their Masters a long time ago and need quick reminders and professional/ academic updates while it serves as a primer for those very experienced Professionals who never made time out for their masters yet they require the academic and practical relevance of this master’s experience. It is a short executive training that runs online for 3 months. Candidates will run 2 months of active lectures and series of assignments and 1 month for their dissertation. Upon successful completion of the Programme, candidates will be awarded a Continuing Professional Development (CPD) certificate in the specific Programme they have completed. What is a CPD Course? Continuing Professional Development (CPD) is the means by which professionals maintain and enhance their knowledge and skills. The world is constantly moving at a very fast pace so undertaking CPD is essential to support a professional in his/her current role as well as helping them with career progression. CPD is all about upgrading knowledge, skills, and capabilities to remain effective and compliant. A CPD course is an investment that you make in yourself. It’s a way of planning your development that links learning directly to practice. CPD can help you keep your skills and knowledge up to date and prepare you for greater responsibilities. It can boost your confidence, strengthen your professional credibility, and help you become more creative in tackling new challenges. Is the SEMP Development Studies the right Programme for me? As a professional, manager, or consultant, if you want to develop your individual skills in the following areas, then SEMP Personal Development Studies - Education is the right option for you: Communication Problem Solving Critical Thinking and Conceptual Skill Creativity Multidisciplinary Approach Research Self- Reflector Why SEMP Development Studies? This non-credit-bearing course examines the various skills needed for the development of professionals across the education field, and how these improved skills can be harnessed together to produce a leading professional. To study comparative development effectively, one must draw upon many disciplines and construct a balanced understanding of historical and contemporary processes. Thus, studying development as a means for social transformation requires a blend of knowledge and perspectives ranging from communication, creative thinking, time management, and self-reflection. Who should enrol in this online Certificate Program? The SEMP Personal development Studies - Education Programme is designed for entry-level managers, up to mid-level managers, senior managers or directors, consultants who are in a general management role or fast approaching such a position and want an opportunity to develop their personal skills. Here is a list of people who can enrol in the Programme. Non-Governmental OrganizationMembers(NGOs) International literacy Professionals Journalists Educators Archivist Consultants Economic Development Advisor Government Relations Advisor Intelligence Officer Policy Analyst Public Administrations Professionals Public Policy Advisor Accreditation The content of this course has been independently certified as conforming to universally accepted Continuous Professional Development (CPD) guidelines. Entry Requirements There are no strict entry requirements for this course. Work experience will be added advantage to understanding the content of the course. Workshops This is a self-study programme with unlimited tutor support. You will never be more than a message or phone call away from our tutors. Visa Requirements There are no Visa Requirements for this Course as it's an Online Course.
Microsoft® Project White Belt® 2016: Virtual In-House Training This workshop serves as an introduction to the interface and features of Microsoft® Project. This workshop serves as an introduction to the interface and features of Microsoft® Project. It is kept up to date with the framework outlined by Project Management Institute's A Guide to the Project Management Body of Knowledge (PMBOK® Guide). This course will be led by an IIL-certified instructor who will outline the benefits of Microsoft Project, provide tips on using various features and common shortcuts, recommend guidelines, and discuss the application of scheduling concepts to manage project work. What you Will Learn You'll learn how to: Define key scheduling concepts and terms Effectively navigate the user interface and interpret common views Configure essential elements of a new schedule Enter and modify a task list Set dependencies between tasks Create a basic resource list and generate assignments Format targeted areas of the Gantt Chart view Prepare the schedule for printing Getting Started Introductions Course objectives Course outline Navigating the User Interface and Views The ribbon The Quick Access Toolbar General and display options Major elements on the Project screen The Gantt chart, calendar, and network diagram views The help Setting up a New Schedule New schedules from blank, templates or other files The project starting date and forward scheduling The project standard calendar and exception days Entering, Modifying, and Outlining Task Data Task entering options and edition Unscheduled tasks Duration estimates for a single task or multiple tasks Tasks organization Multi-level outline Notes to detail tasks Creating Dependencies by Setting Links The critical path Critical path calculation in Project Dynamic schedules and dependencies Link tasks in Project Displaying the critical path Entering and Assigning Resources Resource planning Resource list Resource assignments Formatting Gantt Chart View Format options for text and Gantt charts Print options
Microsoft Project White Belt® 2013: Virtual In-House Training This workshop serves as an introduction to the interface and features of Microsoft® Project 2013. This course will be led by an IIL-certified instructor who will outline the benefits of Microsoft Project, provide tips on using various features and common shortcuts, recommend guidelines, and discuss the application of scheduling concepts to manage project work This workshop serves as an introduction to the interface and features of Microsoft® Project 2013. This course will be led by an IIL-certified instructor who will outline the benefits of Microsoft Project, provide tips on using various features and common shortcuts, recommend guidelines, and discuss the application of scheduling concepts to manage project work. What you Will Learn You'll learn how to: Define key scheduling concepts and terms Effectively navigate the user interface and interpret common views Configure essential elements of a new schedule Enter and modify a task list Set dependencies between tasks Create a basic resource list and generate assignments Format targeted areas of the Gantt Chart view Prepare the schedule for printing Getting Started Introductions Course objectives Course outline Navigating the User Interface and Views Navigate and use the Ribbon Use and customize the Quick Access Toolbar Modify general and display options Become familiar with major elements on the Project screen Navigate Gantt Chart, calendar, and network diagram views Search for a help topic Setting up a New Schedule Create new schedules Create a new schedule using existing information Enter and modify the schedule start date Enter and modify exception days in the calendar Entering, Modifying, and Outlining Task Data Enter, edit, correct, and clear information Enter unscheduled tasks Enter duration estimates for a single task or multiple tasks Organize tasks Set up a multi-level outline Add notes to tasks Creating Dependencies by Setting Links Identify a critical path in a simple schedule Understand how scheduling software calculates a critical path Describe dynamic schedules and dependencies Create links using various methods Display the critical path Entering and Assigning Resources Plan for resources Create a list of available resources Assign resources Formatting Gantt Chart View Format text and Gantt Chart bars Format a collection of items Configure print options
About this Training Course This course will provide detailed learning to the various aspects of the design, analysis and operation of subsea control systems for a variety of field development options to allow effective management of subsea facilities either from offshore structures or from shore bases. This will include power and telemetry focussing on electrical, hydraulic and electro-hydraulic systems, shut down systems, and application of intelligent monitoring and 'smart' fields. Training Objectives By attending this course, participants will be able to: To provide detailed knowledge and understanding of the requirements for, and design of, subsea electrical, electro-hydraulic, hydraulic and programmable control systems. Knowledge of the components and uses of a wide variety of subsea control systems the requirements for and design implications, of umbilicals and control lines (power and telemetry) Knowledge of, and ability to model, power requirements subsea and detailed understanding of the requirements and objectives of pre-commissioning, both at the factory and in situ. Knowledge of the standards involved in design of equipment, control and application of manual and automatic shut-down valves, and emergency response systems Introduction to design of redundancy and the role of spare capacity and to be able to put this knowledge to effect to contribute to detailed field design. An understanding of obsolescence management in subsea control systems Target Audience This course is intended for Offshore and Onshore Subsea Production Control Systems; Engineers, Technicians, Supervisors, Operators; Graduates; Apprentices; transfers from other industries, and existing staff with a limited exposure to Production Control and a need to understand the more technical aspects of the system. Companies not directly involved in the day-to-day support of the industry, but occasionally involved in supplying and supporting operators; manufacturers and suppliers of Oil and Gas equipment and services may also find this a useful course to understand how their equipment and technical expertise is integrated into the Offshore system. Trainer For most of his working life, your expert course leader has been in a role that has enabled him to pass on skills and knowledge to others. A full-time role in Training and Development came about in 1996 with the offer to take up a full-time teaching post at Aberdeen College. In 1998, he was recruited by Kvaerner Oilfield Products, an Oil & Gas industry company, specialising in Subsea Control Systems, to develop and implement a Training & Competence program acceptable for its staff of over 600 and their client companies - a challenge he could not resist. In 2003, he broadened his horizons and became an independent Training & Development consultant. Building a reputation for delivering training and development to the Oil & Gas industry to the highest standards, he later joined Jee Ltd, a leading subsea engineering and training company based in Aberdeen. He was tasked with a wide portfolio of training, coaching & mentoring to achieve high levels of competence for the client's staff and customers. He is also a Science and Engineering Ambassador (Scotland), promoting the need for engineers and technicians for Scotland's industries, a frequent consultant to the European Economic & Social Committee for standardising Vocational Skills training and competence throughout the EU. He holds memberships in the Society of Operations Engineers, Chartered Institute of Personnel & Development and Society of Underwater Technologies. POST TRAINING COACHING SUPPORT (OPTIONAL) To further optimise your learning experience from our courses, we also offer individualized 'One to One' coaching support for 2 hours post training. We can help improve your competence in your chosen area of interest, based on your learning needs and available hours. This is a great opportunity to improve your capability and confidence in a particular area of expertise. It will be delivered over a secure video conference call by one of our senior trainers. They will work with you to create a tailor-made coaching program that will help you achieve your goals faster. Request for further information post training support and fees applicable Accreditions And Affliations
***24 Hour Limited Time Flash Sale*** Engineering Management for Construction Engineering CPD Approved Admission Gifts FREE PDF & Hard Copy Certificate| PDF Transcripts| FREE Student ID| Assessment| Lifetime Access| Enrolment Letter Are you a professional feeling stuck in your career, struggling to keep up with the ever-changing demands of the industry? Or perhaps you're a beginner, unsure of where to start or how to break into your desired field. Whichever stage you're in, our exclusive Engineering Management for Construction Engineering CPD Approved Bundle provides unique insights and tools that can help you achieve your goals. Designed to cater to the needs of both seasoned professionals and aspiring newcomers, our Engineering Management for Construction Engineering CPD Approved bundle is a comprehensive program that will equip you with the essential skills and knowledge you need to succeed. Whether you're looking to advance in your current role or embark on a new career journey, this bundle has everything you need to take your professional life to the next level. But that's not all. When you enrol in Engineering Management for Construction Engineering CPD Approved Online Training, you'll receive 30 CPD-Accredited PDF Certificates, Hard Copy Certificates, and our exclusive student ID card, all absolutely free. Courses Are Included In this Engineering Management for Construction Engineering CPD Approved Career Bundle: Course 01: Engineering Management Course 02: Diploma in Construction Management Course 03: Civil Engineering Level 3 Course 04: Construction Project Management Course 05: Construction Industry Scheme (CIS) Course 06: Architectural Studies Course 07: Building Quantity Surveying Training Level 3 Course 08: Surveying Basics Course 09: Construction Cost Estimation Diploma Course 10: Construction Estimation using RSMeans Course 11: Property Law and Legislation Course 12: Site Management Safety Training Scheme (SMSTS) Course 13: Construction Safety Course 14: WELL Building Standard Course 15: LEED V4: Building Design and Construction Course 16: Solidworks Foundation Training Course 17: Interior Design Professional Diploma Course 18: CAD Design Course: Assemblies, Modelling And Civil Drawings Course 19: AutoCAD VBA Programming Course 20: Autocad Electrical Design Course 21: Agile Scrum Master Certification Course 22: Agile Project Management Course 23: Project Planning for Everyone Course 24: Strategic Management Course 25: Strategic Management - Industry Change And Value Curves Course 26: Team Management and Leadership Development Training Course 27: Compliance Risk and Management Course 28: Workplace Productivity Course Course 29: Cross-Cultural Awareness Training Course 30: Intermediate Economics Level 6 With Level 7 in Strategic Learning & Development, you'll embark on an immersive learning experience that combines interactive lessons with voice-over audio, ensuring that you can learn from anywhere in the world, at your own pace. And with 24/7 tutor support, you'll never feel alone in your journey, whether you're a seasoned professional or a beginner. Don't let this opportunity pass you by. Enrol in Engineering Management for Construction Engineering CPD Approved today and take the first step towards achieving your goals and dreams. Why buy this Level 7 in Strategic Learning & Development? Free CPD Accredited Certificate upon completion of Level 7 in Strategic Learning & Development Get a free student ID card with Level 7 in Strategic Learning & Development Lifetime access to the Engineering Management for Construction Engineering CPD Approved course materials Get instant access to this Engineering Management for Construction Engineering CPD Approved course Learn Engineering Management for Construction Engineering CPD Approved from anywhere in the world 24/7 tutor support with the Engineering Management for Construction Engineering CPD Approved course. Start your learning journey straightaway with our Engineering Management for Construction Engineering CPD Approved Training! Engineering Management for Construction Engineering CPD Approved premium bundle consists of 30 precisely chosen courses on a wide range of topics essential for anyone looking to excel in this field. Each segment of Engineering Management for Construction Engineering CPD Approved is meticulously designed to maximise learning and engagement, blending interactive content and audio-visual modules for a truly immersive experience. Certification You have to complete the assignment given at the end of the Engineering Management for Construction Engineering CPD Approved course. After passing the Engineering Management for Construction Engineering CPD Approved exam You will be entitled to claim a PDF & Hardcopy certificate accredited by CPD Quality standards completely free. CPD 300 CPD hours / points Accredited by CPD Quality Standards Who is this course for? This Engineering Management for Construction Engineering CPD Approved course is ideal for: Students seeking mastery in Level 7 in Strategic Learning & Development Professionals seeking to enhance Engineering Management for Construction Engineering CPD Approved skills Individuals looking for a Level 7 in Strategic Learning & Development-related career. Anyone passionate about Level 7 in Strategic Learning & Development Requirements This Engineering Management for Construction Engineering CPD Approved doesn't require prior experience and is suitable for diverse learners. Career path This Engineering Management for Construction Engineering CPD Approved bundle will allow you to kickstart or take your career in the related sector to the next stage. Certificates CPD Accredited Digital certificate Digital certificate - Included CPD Accredited Hard copy certificate Hard copy certificate - Included If you are an international student, you will be required to pay an additional fee of 10 GBP for international delivery, and 4.99 GBP for delivery within the UK, for each certificate
This SENCO - Essential Skills course is designed for those interested in or who are currently in a SENCO role in the early years setting. This SENCO - Essential Skills qualification provides learners with a thorough understanding of the roles and responsibilities of the Special Educational Needs Coordinator in early years setting. Learn about the strategies and techniques for assisting children and their families and gain in-depth knowledge of SEN codes of practice. The purpose of this course is to help learners progress to further and higher education and develop new practical skills in health and social care. Learning Outcomes After completing this SENCO - Essential Skills course, the learner will be able to: Understand the roles and responsibilities of the Special Educational Needs Coordinator in the early years setting. Understand the strategies and techniques for supporting children and their families. Increase knowledge of SEN codes of practice. Why Choose this Course from Us Self-paced course, access available from anywhere. Easy to understand, high-quality study materials. Course developed by industry experts. MCQ quiz after each module to assess your learning. Automated and instant assessment results. 24/7 support via live chat, phone call or email. Free PDF certificate as soon as completing the course. ***Courses are included in this SENCO - Essential Skills Course*** Course 01: SENCO - Essential Skills Course 02: Nursery Nurse Course Course 03: Level 2 Diploma for the Early Years Practitioner ***Other Benefits of thisCourse*** Free 3 PDF Certificate Access to Content - Lifetime Exam Fee - Totally Free Free Retake Exam [ Note: Free PDF certificate as soon as completing the course ] Detailed course curriculum Module 1: Roles and Responsibilities of the Special Educational Needs Coordinator in the Early Years Understand the principles, statutory guidance and legislation underpinning practice for children with Special Educational Needs and Disability (SEND) in an early years setting Understand the role of the Early Years Special Educational Needs Coordinator (SENCo) Understand partnership working for the Early Years SENCo Understand early identification and action for children with SEND Module 2: Strategies and Techniques for Supporting Children and Families Understand the graduated approach in an early years setting Understand English as an additional language (EAL) Understand Education, Health and Care (EHC) plans ------------------------- ***Level 2 Diploma for the Early Years Practitioner Course Curriculum Module 01: Roles and Responsibilities of the Early Years Practitioner Module 02: Health and Safety of Babies and Young Children in the Early Years Module 03: Equality, Diversity and Inclusive Practice in Early Years Settings Module 04: Safeguarding, Protection and Welfare of Babies and Young Children in Early Years Settings Module 05: Understand How to Support Children's Development Module 06: Support Care Routines for Babies and Young Children Module 07: Support the Planning and Delivery of Activities, Purposeful Play Opportunities and Educational Programmes Module 08: Promote Play in an Early Years Setting Module 09: Support Well-being of Babies and Young Children for Healthy Lifestyles Module 10: Support Babies and Young Children to be Physically Active Module 11: Support the Needs of Babies and Young Children with Special Educational Needs and Disability Module 12: Promote Positive Behaviour in Early Years Settings Module 13: Partnership Working in the Early Years Module 14: Support Children's Transition to School ------------------------- ***Nursery Nurse Course Course Curriculum Module 01: An Overview of Nursery Nurse Module 02: Recognizing Children's Growth and Development Module 03: Observation and Assessment of Children in Early Childhood Settings Module 04: How to Promote Equality, Diversity and Inclusive Practice in Early Years of Learning Module 05: Safeguarding and Protecting Young Children Module 06: Ensuring Health and Safety of Children in the Early Years Module 07: The Essence of Nutrition and Healthy Food for Children Module 08: Importance of Play and Learning in Children's Education Module 09: Ways of Working with Children Having Special Needs Module 10: Working in Partnership with Parents and Carers Assessment Method After completing each module of the SENCO - Essential Skills, you will find automated MCQ quizzes. To unlock the next module, you need to complete the quiz task and get at least 60% marks. Once you complete all the modules in this manner, you will be qualified to request your certification. Certification After completing the MCQ/Assignment assessment for this SENCO - Essential Skills course, you will be entitled to a Certificate of Completion from Training Tale. It will act as proof of your extensive professional development. The certificate is in PDF format, which is completely free to download. A printed version is also available upon request. It will also be sent to you through a courier for £13.99. Who is this course for? This SENCO - Essential Skills course is ideal for those already working in a SENCO role as part of their Early Years Practitioner role or interested in doing so. This course is also suitable for childminders. Requirements There are no specific requirements for this SENCO - Essential Skills course because it does not require any advanced knowledge or skills. Students who intend to enrol in this course must meet the following requirements: Good command of the English language Must be vivacious and self-driven Basic computer knowledge A minimum of 16 years of age is required Career path This SENCO - Essential Skills course is appropriate for those who want to work in the following fields: Health and social care Childhood studies Community, youth and families Social work Early years Primary teaching Nursing Certificates Certificate of completion Digital certificate - Included
The job market in the UK has been through a significant amount of turbulence over the last year, mainly due to the pandemic and recent war. As a result, finding a suitable niche in this highly competitive job market has become more challenging. So to cover up all your limitations and uproot all the hurdles to a stable and dignified career, we are here with a package you can't refuse! This time Apex Learning will show you the pathway to a successful career through the most well-researched and expertly made Microsoft Office bundle. Our Microsoft Office package, with the latest digital study materials and innovative learning method, will give you in-depth knowledge of this domain. You will dive deep into the core basics with our step-by-step lessons and proficient tutor guidance. You will be able to hone your knowledge from beginner to advanced level as there will be frequent tests, fun quizzes and practical analysis of the topics. Moreover, you will keep yourself up to date with the current situation in the area of your interest. As Microsoft Office, there are endless opportunities for you if you have the right knowledge and skill. Therefore, to make your career journey a successful one, we designed this bundle as a one-stop solution for you. This 20-in 1 Ultimate Microsoft Office bundle consists of the following Courses: Course 01: MS Word Diploma Course 02: Proofreading & Copyediting Course 03: PowerPoint Diploma Course 04: Microsoft Excel Level 3 Course 05: New Functions in Microsoft Excel 2021 Course 06: Microsoft Excel: Automated Dashboard Using Advanced Formula, VBA, Power Query Course 07: Microsoft Excel: Excel Sheet Comparison with VBA Course 08: Microsoft Excel: Master Power Query in 120 Minutes! Course 09: Excel: Top 50 Microsoft Excel Formulas in 50 Minutes! Course 10: Excel Pivot Tables Course 11: Data Analysis in Microsoft Excel Complete Training Course 12: Excel Must know Formulas and Functions Course 13: Excel spreadsheet for Beginner Course 14: Excel Data Analysis Course 15: Excel Vlookup, Xlookup, Match and Index Course 16: Excel Pivot Tables, Pivot Charts, Slicers, and Timelines Course 17: PowerBI Formulas Course 18: Outlook Tips and tricks Course 19: Excel PowerQuery and PowerPivot Course 20: Complete Microsoft Power BI 2021 Additionally, you will get 5 other career-guided courses in this Microsoft Office bundle: Course 01: Career Development Plan Fundamentals Course 02: CV Writing and Job Searching Course 03: Interview Skills: Ace the Interview Course 04: Video Job Interview for Job Seekers Course 05: Create a Professional LinkedIn Profile So, stop scrolling down and procure the skills and aptitude with Apex Learning to outshine all your peers by enrolling in this Microsoft Office bundle. Learning Outcomes of Microsoft Office bundle This career-oriented bundle will help you to Gain the ability to excel in the role of Microsoft Office Know your responsibilities as Microsoft Office and convey your experience to others Gain excellent interpersonal and communication skills Know the pros and cons of working as Microsoft Office Adhere to the regulations around this area Gain time and risk management skills to ensure efficiency Manipulate technological advancement to become more effective Maintain moral standards and set an example for your peers CPD 250 CPD hours / points Accredited by CPD Quality Standards Who is this course for? Anyone from any background can enrol in this Microsoft Office bundle. Requirements This Microsoft Office course has been designed to be fully compatible with tablets and smartphones. Career path Having this expertise will increase the value of your CV and open you up to multiple job sectors. Certificates Certificate of completion Digital certificate - Included Certificate of completion Hard copy certificate - Included You will get the Hard Copy certificate for the title course (MS Word Diploma) absolutely Free! Other Hard Copy certificates are available for £10 each. Please Note: The delivery charge inside the UK is £3.99, and the international students must pay a £9.99 shipping cost.
Overview Essential Communication Skills for Professionals Course is yet another 'Teacher's Choice' course from Teachers Training for a complete understanding of the fundamental topics. You are also entitled to exclusive tutor support and a professional CPD-accredited certificate in addition to the special discounted price for a limited time. Just like all our courses, this Essential Communication Skills for Professionals Course and its curriculum have also been designed by expert teachers so that teachers of tomorrow can learn from the best and equip themselves with all the necessary skills. Consisting of several modules, the course teaches you everything you need to succeed in this profession. The course can be studied part-time. You can become accredited within 05 Hours studying at your own pace. Your qualification will be recognised and can be checked for validity on our dedicated website. Why Choose Teachers Training Some of our website features are: This is a dedicated website for teaching 24/7 tutor support Interactive Content Affordable price Courses accredited by the UK's top awarding bodies 100% online Flexible deadline Entry Requirements No formal entry requirements. You need to have: Passion for learning A good understanding of the English language Be motivated and hard-working Over the age of 16. Certification CPD Certification from The Teachers Training Successfully completing the MCQ exam of this course qualifies you for a CPD-accredited certificate from The Teachers Training. You will be eligible for both PDF copy and hard copy of the certificate to showcase your achievement however you wish. You can get your digital certificate (PDF) for £4.99 only Hard copy certificates are also available, and you can get one for only £10.99 You can get both PDF and Hard copy certificates for just £12.99! The certificate will add significant weight to your CV and will give you a competitive advantage when applying for jobs. Section 01: Introduction Introduction 00:01:00 Section 02: Lessons Concise Communication 00:06:00 Clear Communication 00:07:00 Listening Skills 00:06:00 Building Positive Relationships 00:07:00 Collaborative Problem Solving 00:06:00 Section 03: Next Steps and Takeaways Next Steps and Takeaways 00:04:00 Assignment Assignment - Essential Communication Skills for Professionals 00:00:00
Microsoft Excel® in Depth: Virtual In-House Training The goal of this course is to provide a deeper understanding of Excel and its intricacies and a new ability to use it efficiently producing the best solutions for your projects. This practical course provides a solid background of the features of Excel and a deeper understanding of its features, benefits and uses. This is not a beginner's course in Excel. You will learn some advanced features such as Pivot Tables, Charting, Tables, Sorting, Filtering and Functions. The goal of this course is to provide a deeper understanding of Excel and its intricacies and a new ability to use it efficiently producing the best solutions for your projects. What you Will Learn You'll learn how to: Use functions like IF, AVERAGE, SUMIF, SUMIFS, SUMPRODUCT, INDEX, MATCH, CHOOSE, DATE, and many more Create meaningful charts Use pivot tables Use Conditional Formatting, Data Validation Take advantage of using Named ranges, do sorting, filtering, tables Getting Started The building blocks of Excel, built-in functions, will be examined The basics of formatting your data will be examined Shortcuts and data manipulation will be explored Built-in features like those mentioned in the 'What you will learn' section above will be explored in detail Excel Functions - VLOOKUP, IF, INDEX, MATCH, CHOOSE, SUMIF, SUMIFS, SUMPRODUCT, DATE, so many more Using Named ranges, Data Validation, Sorting, and Filtering Learn the Name manager; Learn the difference between local and global names; Ensure correct access to linked workbooks; Ensure data accuracy; Learn how to use cascading data validation (for example, once a user chooses 'cars', another cell allows only Ford, Toyota, etc.); Sorting by more than 3 fields; Filtering by font, pattern, or value; See your data based on things like dates in the 3rd quarter, or fields where quantity x price is greater than some fixed value Conditional formatting and data formatting Make relevant data stand out Isolate highs and lows Make error cells invisible Learn about Data bars, Icon sets, and Color scales Highlight differences between worksheets Learn all the codes in the Format/Number list Using cell Styles Learn all about alignment, protection, borders, colors and more Pivot Tables Learn how to summarize large amounts of data with a few clicks Learn various ways of presenting the data Learn the various pivot table tools Learn how to customize and format a pivot table to suit your needs Learn how to group data Learn how to use the various options to present your data Charts Learn how to create a chart with one keystroke! Learn the 11 types of built-in charts Learn how to create a chart with one keystroke! Learn how to customize the charts to make the information tell the right story Learn how to use the design, layout, and formatting available to charts in Excel 2007 Learn embedded charts versus chart sheets Learn how to use modify all the pieces of a chart Array formulas Learn how to use the most powerful formulas in Excel Learn how to combine many formulas into one compact array-formula Learn the real power of these formulas and why regular formulas can't do the job Learn how to use built-in array formulas, like TREND or TRANSPOSE