3192 Courses

About this Virtual Instructor Led Training (VILT) Governments, regulators and energy companies are pursuing CO2 storage technologies to meet their net-zero carbon commitments as well as targets set by the international Paris Agreement on climate change. For successfully executing Carbon Capture & Storage (CCS) projects, various technical, operational, economic and environmental risks and associated stakeholders need to be managed. In this 5 half-day Virtual Instructor Led Training (VILT) course, the methods for managing risk in CCS projects are addressed with a focus on CO2 injection and storage. The VILT course will also demonstrate how to assess storage capacity of a potential CO2 storage reservoir, model framing techniques, and well injectivity issues related to CO2 injection. The potential leak paths will be discussed such as reservoir seals, leakage along faults and aspects of well integrity. In the VILT course, the design of a monitoring programme will also be discussed. The VILT course will be supported by various case studies. This VILT course will cover the following modules: CCS projects in an international context Site selection and site characterization Storage capacity assessment Injectivity assessment Containment assessment Measurement, monitoring & verification Training Objectives On completion of this VILT course, participants will be able to: Uncover the functions and associated components required to capture, transport and store CO2 in subsurface aquifers and (depleted) hydrocarbon reservoirs Find a systematic and integrated approach to risk identification and assessment for CO2 storage projects (maturation) Appreciate the requirements (physics modelling) and uncertainties to assess the CO2 storage capacity of a selected site. Understand the challenges, data and methods to assess CO2 well injectivity and well integrity Identify the leakage pathways of a selected storage site, and understand the assessment methods and associated uncertainties Learn how to design a monitoring program Target Audience This VILT course is intended for all surface and subsurface engineers such as facility engineers, geologists, geophysicists, reservoir engineers, petrophysicists, production technologists/engineers, well engineers and geomechanical specialists. Also, (sub)surface team leads, project managers, business opportunity managers, decision executives, and technical risk assessment & assurance specialists will benefit from this VILT course as it provides a common framework and workflow to develop a CCS project. For each class, it is highly recommended that a mix of disciplines mentioned above are represented to facilitate discussions from different perspectives. Course Level Basic or Foundation Training Methods This VILT course is built around cases in which teams work to identify and assess CO2 storage site issues using a systematic thought approach in this course. In addition, exercises are used to practise the aspects of the CCS risk assessment process. The VILT course provides a venue for discussion and sharing of good practices as well as opportunities to practise multi-discipline co-operation and facilitation. Participants are encouraged to bring their own work issues and challenges and seek advice from the expert course leaders and other participants about all aspects of CCS. This VILT course will be delivered online in 5 half-day sessions comprising 4 hours per day, with 2 breaks of 10 minutes per day. Trainer Trainer 1: Your expert course leader has more than 36 years of experience in the oil & gas industry with Shell. He gained broad experience in petroleum engineering, with expertise in integrated production systems from subsurface, wells and surface. He has had assignments in Production Technology, R&D, Production Chemistry, Rock Mechanics and Reservoir Engineering cEOR, with a proven track record in technology screening, development and deployment, field development planning, conceptual well design and Production System Optimization (PSO) of gas and oil fields as well as preparing Well, Reservoir & Facility Management (WRFM) strategies and plans. He had also worked on assignments in NAM and did fieldwork in Oman, Gabon and Shell Nigeria. He is a skilled workshop facilitator. He discovered his passion for teaching following an assignment in Shell Learning. During his time in Shell, he developed and taught technical courses to Shell professionals via blended learning. Trainer 2: Your second expert course leader has over 30 years of experience identifying, assessing and mitigating technical risks with Shell. The main focal point of his experience is in subsurface and Geomechanical risks. He is the the founding father of various innovations in how we assess risks by tool development (for bore hole stability, 3D geomechanical field evaluations and probabilistic assessment). He also developed an eye for people motivation, change management and facilitation. He was also responsible for the Geomechanical competence framework, and associated virtual and classroom training programme in Shell for 10 years. Trainer 3: Your third expert course leader has more than 30 years of experience in Shell, focusing on research and development in drilling and offshore systems. His areas of expertise is in project management, finance, business planning, investment, development studies and economics models. In 2021, he worked on a project that looked into the economic evaluation of P18A field complex for CO2 storage. He has an MSc in Mechanical Engineering (M.E.) TU Delft Netherlands (Hons) and a baccalaureate from Erasmus University Rotterdam. 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 about post training coaching support and fees applicable for this. Accreditions And Affliations

Description:  This Microsoft Office 2010 Excel Beginners - Complete Video Course will teach you the basic functions and features of Excel 2010. After an introduction to spreadsheet terminology and Excel's window components, you will learn how to use the Help system and navigate worksheets and workbooks. Then you will enter and edit text, values, formulas, and pictures, and you will save workbooks in various formats. You will also move and copy data, learn about absolute and relative references, and work with ranges, rows, and columns. This course is designed to introduce you to using Microsoft Excel if you're unfamiliar with any major aspect of it. The series will lead you through the fundamentals of creating and working with Excel spreadsheets. Today's Excel spreadsheet isn't just for financial professionals. Microsoft Excel offers intuitive tools that make it easy to access, connect, and analyze critical data-regardless of your profession. Assessment: At the end of the course, you will be required to sit for an online MCQ test. Your test will be assessed automatically and immediately. You will instantly know whether you have been successful or not. Before sitting for your final exam you will have the opportunity to test your proficiency with a mock exam. Certification: After completing and passing the course successfully, you will be able to obtain an Accredited Certificate of Achievement. Certificates can be obtained either in hard copy at a cost of £39 or in PDF format at a cost of £24. Who is this Course for? Microsoft Office 2010 Excel Beginners - Complete Video Course is certified by CPD Qualifications Standards and CiQ. This makes it perfect for anyone trying to learn potential professional skills. As there is no experience and qualification required for this course, it is available for all students from any academic background. Requirements Our Microsoft Office 2010 Excel Beginners - Complete Video Course is fully compatible with any kind of device. Whether you are using Windows computer, Mac, smartphones or tablets, you will get the same experience while learning. Besides that, you will be able to access the course with any kind of internet connection from anywhere at any time without any kind of limitation. Career Path After completing this course you will be able to build up accurate knowledge and skills with proper confidence to enrich yourself and brighten up your career in the relevant job market. Getting Started Spreadsheet Terminology FREE 00:02:00 The Excel Environment 00:05:00 Getting Help 00:03:00 Navigating a Worksheet 00:06:00 Entering and Editing Data Entering and Editing Text and Values 00:09:00 Entering and Editing Formulas 00:09:00 Working with Pictures 00:03:00 Saving and Updating Workbooks 00:07:00 Modifying a Worksheet Moving and Copying Data 00:13:00 Moving and Copying Formulas 00:07:00 Absolute and Relative References 00:06:00 Inserting and Deleting Ranges, Rows, and Columns 00:07:00 Functions Entering Functions 00:15:00 AutoSum 00:04:00 Other Common Functions 00:11:00 Formatting Text Formatting 00:06:00 Column Formatting 00:12:00 Number Formatting 00:06:00 Conditional Formatting 00:10:00 Additional Formatting Options 00:12:00 Printing Preparing to Print 00:09:00 Page Setup Options 00:14:00 Printing Worksheets 00:04:00 Charts Chart Basics 00:11:00 Formatting Charts 00:05:00 Managing Large Workbooks Viewing Large Worksheets 00:14:00 Working with Multiple Worksheets 00:12:00 Printing Large Worksheets 00:08:00 Graphics and Screenshots Conditional Formatting with Graphics 00:09:00 SmartArt Graphics 00:05:00 Screenshots 00:05:00 Mock Exam Mock Exam- Microsoft Office 2010 Excel Beginners - Complete Video Course 00:20:00 Final Exam Final Exam- Microsoft Office 2010 Excel Beginners - Complete Video Course 00:20:00 Order Your Certificate and Transcript Order Your Certificates and Transcripts 00:00:00

>> 24 Hours Left! Don't Let the spring Deals Slip Away - Enrol Now! << Discover the inner workings and fantastic micro-verse that exists within us all by taking our fascinating Diploma in Anatomy and Physiology of Human Body in Health Care Course. The ability to understand and appreciate the natural systems that allow us to live and breathe every second is a treasured skill and something that you can aspire to with our help. This Advanced Diploma in Human Anatomy and Physiology at QLS Level 7 course is endorsed by The Quality Licence Scheme Courses Included In This Package: Course 01: Advanced Diploma in Human Anatomy and Physiology at QLS Level 7 Course 02: Phlebotomy Training Course 03: Biomedical Science Course 04: Health and Social Care Training Course 05: Public Health Every major element and organ of our bodies are examined in this Anatomy and Physiology of Human Body in Health Care course, with material gathered from industry experts and professionals. If you want to attain this knowledge for advantages with a medical career, biological research, or just intense curiosity about the process of life, then this will provide everything you need to reach your objectives. Learning Outcomes of Anatomy and Physiology of Human Body with Phlebotomy & Biomedical Science: Understand basic cellular chemistry and its biological implications. Identify cell structures and describe their primary functions. Describe the processes and significance of mitosis and meiosis. Grasp DNA replication, cellular metabolism, and energy production. Distinguish between tissue types and describe their functions. Understand skin layers, functions, and common disorders. Identify bone structures and comprehend skeletal functions. Recognize muscular tissues and understand muscle mechanics. Understand neurological processes underlying memory formation and recall. Describe sensory receptor types and their respective roles. Understand heart function and blood vessel dynamics. Recognize blood components and understand their respective roles. Describe the lymphatic system's role in fluid balance and filtration. Describe male reproductive structures and their functions. Recognize female reproductive anatomy and understand menstrual cycles and much more... It takes a deep dive into the workings of the nervous system alongside the functions of the brain and our five senses. You will be taught how food is digested, blood is pumped, diseases are fought, and the air is circulated. In short, every biological function is examined and explained for your education. Each interactive online Diploma in Anatomy and Physiology of Human Body with Phlebotomy module is presented in easy-to-learn portions that can be taken anywhere and at a pace of your own choice. Enrol now in Diploma in Anatomy and Physiology of Human Body with Phlebotomy training and learn about the inner 'you'. Why Prefer this Anatomy and Physiology of Human Body with Phlebotomy & Biomedical Science Course? Opportunity to earn a certificate endorsed by the Quality Licence Scheme and another certificate accredited by CPDQS. Get a free student ID card! (£10 postal charge will be applicable for international delivery) Innovative and engaging content. Free assessments 24/7 tutor support. Anatomy and Physiology of Human Body with Phlebotomy & Biomedical Science Take a step toward a brighter future! **** Curriculum of the Human Anatomy and Physiology Course **** Here is the curriculum breakdown of the Anatomy and Physiology of Human Body with Phlebotomy course: Advanced Diploma in Human Anatomy and Physiology at QLS Level 7 The Chemistry of Cells Cells Cell Division Replication and Metabolism Human Tissues Skin Human Skeletal System The Muscular System Skeletal Muscle Fibre Nervous System The Brain Nervous System-Spinal Cord and Spinal Nerves Nervous System - Autonomic Nervous System and Cranial Nerves Nervous System-The Eyes Nervous System-The Ears, Hearing, and Equilibrium Nervous System-Memory Sensory Systems Cardiovascular System Blood Lymphatics Immune System Digestive System Respiratory System Urinary System Male Reproductive System Female Reproductive System Assessment Process of Anatomy and Physiology of the Human Body with Phlebotomy After completing an online module, you will be given immediate access to a specially designed MCQ test. The results will be immediately analyzed, and the score will be shown for your review. The passing score for each test will be set at 60%. After passing the exam, you can order your Advanced Diploma in Human Anatomy and Physiology CPD Certificates (PDF & Hardcopy Certificate) for Free. Also, you will be able to request a certificate with additional cost that has been endorsed by the Quality Licence Scheme. CPD 200 CPD hours / points Accredited by CPD Quality Standards Who is this course for? Anatomy and Physiology of Human Body with Phlebotomy & Biomedical Science Is this Anatomy and Physiology of Human Body with Phlebotomy & Biomedical Science course for you? This Diploma in Anatomy and Physiology of Human Body in Health Care Training has been written to provide a full learning curve for those studying human anatomy, biology, and physiology. Whilst it will be of immense use to those in medical and scientific roles, it will also be of interest to those with a personal curiosity in this area. This course is suitable for everyone. Requirements Anatomy and Physiology of Human Body with Phlebotomy & Biomedical Science You will not need any prior background or expertise to enrol in this in Health Care course. Career path This Anatomy and Physiology of Human Body with Phlebotomy & Biomedical Science training is designed for anyone wanting to gain knowledge about the human body for medical, scientific, or educational purposes. As such, it covers the following careers and roles: Medical Healthcare Professional Biological Researcher First Aid Officer Anatomy and Physiology Tutor Medical Science Analyst Certificates CPDQS Accredited Certificate Digital certificate - £10 Advanced Diploma in Anatomy and Physiology of Human Body at QLS Level 7 Hard copy certificate - £139 Show off Your New Skills with a Certification of Completion You can order an original hardcopy certificate of achievement endorsed by the Quality Licence Scheme. The certificate will be home-delivered, with a pricing scheme of - 139 GBP inside the UK 149 GBP (including postal fees) for international delivery CPDQS Accredited Certificate 29 GBP for Printed Hardcopy Certificate inside the UK 39 GBP for Printed Hardcopy Certificate outside the UK (international delivery)

The main outcome of this training course is to provide you with the knowledge to carry out the functions of a fire marshal. - Please note, this course also contains all of the content in the Basic Fire Awareness and Fire Extinguisher courses. This course is a variation on the Fire Marshal course that contains information that is specific to employees of care and residential homes.

Learn PHP in less than 90 minutes with this fast-paced PHP guide

***24 Hour Limited Time Flash Sale*** QL Programming Masterclass 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 Microsoft Essentials 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 Microsoft Essentials 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 Microsoft Essentials Online Training, you'll receive 25 CPD-Accredited PDF Certificates, Hard Copy Certificates, and our exclusive student ID card, all absolutely free. Courses Are Included In this Microsoft Essentials Career Bundle: Course 01: Microsoft Office Essentials Course 02: Microsoft Word Diploma Course 03: PowerPoint Diploma Course 04: Excel for Beginner Course 05: Microsoft Excel Level 3 Course 06: New Functions in Excel 2021 Course 07: Excel: Automated Dashboard Course 08: Excel Sheet Comparison with VBA Course 09: Top 50 Microsoft Excel Formulas Course 10: Excel Pivot Tables Course 11: Excel Must Know Formulas and Functions Course 12: Excel Data Analysis Course 13: Excel Vlookup, Xlookup, Match, and Index Course 14: Master Power Query Course 15: Pivot Tables, Charts, Slicers, Timelines Course 16: PowerBI Formulas Course 17: Outlook Tips and Tricks Course 18: PowerQuery and PowerPivot Course 19: Complete Power BI 2021 Course 20: Outlook Masterclass Course 21: Microsoft Access Course (Beginner to Advanced) Course 22: Microsoft Access Tables and Queries Course 23: Microsoft Access Forms and Reports Course 24: Microsoft Teams Course 25: Proofreading & Copyediting With Microsoft Essentials, 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 Microsoft Essentials today and take the first step towards achieving your goals and dreams. Why buy this Microsoft Essentials? Free CPD Accredited Certificate upon completion of Microsoft Essentials Get a free student ID card with Microsoft Essentials Lifetime access to the Microsoft Essentials course materials Get instant access to this Microsoft Essentials course Learn Microsoft Essentials from anywhere in the world 24/7 tutor support with the Microsoft Essentials course. Start your learning journey straightaway with our Microsoft Essentials Training! Microsoft Essentials premium bundle consists of 25 precisely chosen courses on a wide range of topics essential for anyone looking to excel in this field. Each segment of Microsoft Essentials 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 Microsoft Essentials course. After passing the Microsoft Essentials exam You will be entitled to claim a PDF & Hardcopy certificate accredited by CPD Quality standards completely free. CPD 250 CPD hours / points Accredited by CPD Quality Standards Who is this course for? This Microsoft Essentials course is ideal for: Students seeking mastery in Microsoft Essentials Professionals seeking to enhance Microsoft Essentials skills Individuals looking for a Microsoft Essentials-related career. Anyone passionate about Microsoft Essentials Requirements This Microsoft Essentials doesn't require prior experience and is suitable for diverse learners. Career path This Microsoft Essentials 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, then you have to pay an additional 10 GBP for each certificate as an international delivery charge.

Get to grips with the complete darkroom workflow from processing film to printing your own black & white photographs.

Register on the Microsoft Excel 2021 Course for Everyone - Complete Excel Course today and build the experience, skills and knowledge you need to enhance your professional development and work towards your dream job. Study this course through online learning and take the first steps towards a long-term career. The course consists of a number of easy to digest, in-depth modules, designed to provide you with a detailed, expert level of knowledge. Learn through a mixture of instructional video lessons and online study materials. Receive online tutor support as you study the course, to ensure you are supported every step of the way. Get a digital certificate as a proof of your course completion. The Microsoft Excel 2021 Course for Everyone - Complete Excel Course is incredibly great value and allows you to study at your own pace. Access the course modules from any internet-enabled device, including computers, tablet, and smartphones. The course is designed to increase your employability and equip you with everything you need to be a success. Enrol on the now and start learning instantly! What You Get With The Microsoft Excel 2021 Course for Everyone - Complete Excel Course Receive an e-certificate upon successful completion of the course Get taught by experienced, professional instructors Study at a time and pace that suits your learning style Get instant feedback on assessments 24/7 help and advice via email or live chat Get full tutor support on weekdays (Monday to Friday) Course Design The course is delivered through our online learning platform, accessible through any internet-connected device. There are no formal deadlines or teaching schedules, meaning you are free to study the course at your own pace. You are taught through a combination of Video lessons Online study materials Certification Upon successful completion of the course, you will be able to obtain your course completion e-certificate. Print copy by post is also available at an additional cost of £9.99 and PDF Certificate at £4.99. Who Is This Course For The course is ideal for those who already work in this sector or are an aspiring professional. This course is designed to enhance your expertise and boost your CV. Learn key skills and gain a professional qualification to prove your newly-acquired knowledge. Requirements The online training is open to all students and has no formal entry requirements. To study the Microsoft Excel 2021 Course for Everyone - Complete Excel Course, all your need is a passion for learning, a good understanding of English, numeracy, and IT skills. You must also be over the age of 16. Course Content Section 01: Getting Started Introduction 00:03:00 Course Curriculum 00:04:00 Getting started on Windows, macOS, Android, and IOS 00:01:00 How to ask great questions 00:02:00 FAQ's 00:01:00 Starting Excel 00:04:00 Section 02: Excel Basics Introduction 00:02:00 Worksheet basics 00:22:00 Entering values and formulas 00:12:00 Data formats 00:10:00 Data handling basics - cut copy and paste 00:07:00 Save and print in excel 00:10:00 Excel Ranges 00:05:00 Section 03: Excel essential functions Introduction 00:01:00 Basic formula operations 00:06:00 Mathematical functions level 1 00:20:00 Mathematical functions level 2 00:12:00 Text functions level 1 00:09:00 Text functions level 2 00:13:00 Logical functions 00:11:00 Date time functions 00:06:00 V Lookup formula 00:12:00 HLookup formula 00:04:00 HLookup + Match formula 00:09:00 Match + Index formula 00:05:00 Section 04: XLookup only for Excel 2021 and Office 365 Introduction 00:02:00 XLookup 00:08:00 Handling #NA and Approximates match in XLookup 00:11:00 Wildcard matching in XLookup 00:06:00 Section 05: Get Data and tools Introduction 00:02:00 Split text into columns 00:07:00 Flash Fill 00:07:00 Remove Duplicates 00:08:00 Data Validation 00:07:00 Get- import Data from Text 00:06:00 Get - import Data from CSV 00:03:00 Section 06: Formatting data and tables Introduction 00:01:00 Formatting Font 00:04:00 Formatting Alignment 00:06:00 Formatting Number 00:05:00 Formatting Date 00:03:00 Formatting tables 00:05:00 Section 07: Pivot Tables Introduction 00:01:00 Creating Pivot Table 00:07:00 Value field settings 00:04:00 Number format 00:02:00 Pivot Table Design 00:03:00 Excel Exercise 00:01:00 Solution for Excel Exercise 00:02:00 Section 08: Excel Charts Introduction 00:01:00 Excel Charts - Categories 00:03:00 Elements of a chart 00:04:00 Easy way to create charts 00:02:00 Column or Bar charts 00:04:00 Formatting charts 00:04:00 Line charts 00:02:00 Area charts 00:02:00 Pie and Doughnut charts 00:04:00 Format AreaPlot or XY chart 00:08:00 Scatter or bubble charts 00:02:00 Section 09: Advanced Excel charts Introduction 00:01:00 Frequency Distribution and Histograms 00:04:00 Waterfall charts 00:02:00 Hierarchy charts: sunburst and tree map 00:03:00 Combination charts 00:02:00 Sparklines 00:05:00 Section 10: Pivot Charts Pivot charts 00:02:00 Section 11: Maps Chart above 2019 Maps chart 00:04:00 3D Maps chart 00:03:00 Section 12: Business-Geo charts Introduction 00:01:00 Stock charts 00:02:00 Radar charts 00:02:00 Surface charts 00:02:00 Heat maps 00:04:00 Section 13: Named Ranges Indirect Name range Function 00:06:00 Named ranges 00:05:00 Section 14: Import Data into Excel Import Data from Website - Excel 2019 above 00:09:00 Import Data table from PDF file - Excel 2021 00:04:00 Section 15: Advanced Excel Product Sale Tax invoice: Tax Calculations 00:05:00 Project: Sales forecast tracker 00:07:00 Frequently Asked Questions Are there any prerequisites for taking the course? There are no specific prerequisites for this course, nor are there any formal entry requirements. All you need is an internet connection, a good understanding of English and a passion for learning for this course. Can I access the course at any time, or is there a set schedule? You have the flexibility to access the course at any time that suits your schedule. Our courses are self-paced, allowing you to study at your own pace and convenience. How long will I have access to the course? For this course, you will have access to the course materials for 1 year only. This means you can review the content as often as you like within the year, even after you've completed the course. However, if you buy Lifetime Access for the course, you will be able to access the course for a lifetime. Is there a certificate of completion provided after completing the course? Yes, upon successfully completing the course, you will receive a certificate of completion. This certificate can be a valuable addition to your professional portfolio and can be shared on your various social networks. Can I switch courses or get a refund if I'm not satisfied with the course? We want you to have a positive learning experience. If you're not satisfied with the course, you can request a course transfer or refund within 14 days of the initial purchase. How do I track my progress in the course? Our platform provides tracking tools and progress indicators for each course. You can monitor your progress, completed lessons, and assessments through your learner dashboard for the course. What if I have technical issues or difficulties with the course? If you encounter technical issues or content-related difficulties with the course, our support team is available to assist you. You can reach out to them for prompt resolution.

Duration 2.25 Days 13.5 CPD hours This course is intended for The job roles best suited to the material in this course are: sales personnel, accountants, administrators, auditors, lab assistants, office job positions. Overview Work with functions. Work with lists. Analyze data. Visualize data with charts. Use PivotTables and PivotCharts. Work with multiple worksheets and workbooks. Share and protect workbooks. Automate workbook functionality. Use Lookup functions and formula auditing. Forecast data. Create sparklines and map data This course provides the knowledge to create advanced workbooks and worksheets that can deepen the understanding of organizational intelligence. The ability to analyze massive amounts of data, extract actionable information from it and present that information to decision makers. In addition this course will give you the ability to collaborate with colleagues, automate complex or repetitive tasks and use conditional logic to construct and apply elaborate formulas and functions which will allow you to work through a lot of data and generate the answers that your organisation needs. WORKING WITH FUNCTIONS Topic A: Work with Ranges Topic B: Use Specialized Functions Topic C: Work with Logical Functions Topic D: Work with Date and Time Functions Topic E: Work with Text Functions WORKING WITH LISTS Topic A: Sort Data Topic B: Filter Data Topic C: Query Data with Database Functions Topic D: Outline and Subtotal Data ANALYZING DATA Topic A: Create and Modify Tables Topic B: Apply Intermediate Conditional Formatting Topic C: Apply Advanced Conditional Formatting VISUALIZING DATA WITH CHARTS Topic A: Create Charts Topic B: Modify and Format Charts Topic C: Use Advanced Chart Features USING PIVOTTABLES AND PIVOTCHARTS Topic A: Create a PivotTable Topic B: Analyze PivotTable Data Topic C: Present Data with PivotCharts Topic D: Filter Data by Using Timelines and Slicers WORKING WITH MULTIPLE WORKSHEETS AND WORKBOOKS Topic A: Use Links and External References Topic B: Use 3-D References Topic C: Consolidate Data SHARING AND PROTECTING WORKBOOKS Topic A: Collaborate on a Workbook Topic B: Protect Worksheets and Workbooks AUTOMATING WORKBOOK FUNCTIONALITY Topic A: Apply Data Validation Topic B: Search for Invalid Data and Formulas with Errors Topic C: Work with Macros USING LOOKUP FUNCTIONS AND FORMULAS AUDITING Topic A: Use Lookup Functions Topic B: Trace Cells Topic C: Watch and Evaluate Formulas FORECASTING DATA Topic A: Determine Potential Outcomes Using Data Tables Topic B: Determine Potential Outcomes Using Scenarios Topic C: Use the Goal Seek Feature Topic D: Forecast Data Trends CREATING SPARKLINES AND MAPPING DATA Topic A: Create Sparklines Topic B: Map Data

Learn the Ruby programming language and JavaScript coding from beginner to intermediate for web development - fast!