3449 Courses

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.

Learning Outcomes Learn the basics of Python and the simple Python syntax Acquire in-depth knowledge of different data types Know more about various number types Enhance your understanding of functions objects and variadic functions Increase your skills in lambda, generators, classes and many more Equip yourself with the necessary skills in Python and launch your career as a programmer Description Python is one of the most popular programming languages all over the globe, including in the UK. So, whether you want to be a web developer or a software engineer, without having excellent expertise in Python you can not thrive in your respective field. Are you worried to start from the beginning? Then don't worry, the Python 3 for Beginners course will educate you on basic-level Python programming. This course will provide you with a detailed understanding of Python language. In this comprehensive training, you will learn about different data types and simple Python syntax. The course will also educate you on functions objects and variadic functions. Furthermore, you will grasp a clear understanding of object initialization, lambda and much more. Therefore, sign up for our most user-friendly, easy-to-digest and flexible course and complete it to get the CPD- certificate of achievement. This certificate will help you grab the attention of employers. Certificate of Achievement After the successful completion of the final assessment, you will receive a CPD-accredited certificate of achievement. The PDF certificate is for 9.99, and it will be sent to you immediately after through e-mail. You can get the hard copy for 15.99, which will reach your doorsteps by post. Method of Assessment When you are done with your learning, you will get some assessment questions that need to pass with a score of 60%. After submitting the assessment, you will immediately receive feedback from our experts.  Career path After completing this course, you will get the chance to explore jobs in the following fields: Web Developer Software Engineer Data Scientist Machine Learning Engineer Data Analyst

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

Feeling Stuck in Your Career? The Microsoft Azure Fundamentals- (30 in 1) CPD Accredited Courses! Bundle is Your Skill-Building Solution. This exceptional collection of 30 premium courses is designed to encourage growth and improve your career opportunities. Suited to meet different interests and goals, the Microsoft Azure Fundamentals bundle provides an engaging learning experience, helping you learn skills across various disciplines. With Microsoft Azure Fundamentals- (30 in 1) CPD Accredited Courses! Bundle, you'll have a personalised journey that aligns with your career goals and interests. This comprehensive package helps you confidently tackle new challenges, whether entering a new field or enhancing your existing knowledge. The Microsoft Azure Fundamentals bundle is your gateway to expanding your career options, increasing job demand, and enhancing your skill set. By enrolling in this bundle, you'll receive complimentary PDF certificates for all courses, adding value to your resume at no extra cost. Develop key skills and achieve important progress in your career and personal development. Start your journey today and experience the transformative impact of the Microsoft Azure Fundamentals- (30 in 1) CPD Accredited Courses! bundle on your job life and career growth! This Microsoft Azure Fundamentals- (30 in 1) CPD Accredited Courses! Bundle Comprises the Following CPD Accredited Courses: Course 01: Basic PowerPoint Course 02: Microsoft Excel Course 03: Microsoft Azure Cloud Concepts Course 04: Microsoft Word Advanced 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: Excel: Top 50 Microsoft Excel Formulas in 50 Minutes! Course 09: Microsoft Excel: Master Power Query in 120 Minutes! Course 10: Excel Pivot Tables Course 11: Data Analysis In Excel 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: Outlook Tips and tricks Course 18: PowerBI Formulas Course 19: Excel PowerQuery and PowerPivot Course 20: Microsoft Power BI Course 21: Microsoft Outlook - 25 Must-Know Tips and Tricks Course 22: Microsoft Access for Beginners Course 23: Microsoft Access Tables and Queries Course 24: Microsoft Access Databases Forms and Reports Course 25: Microsoft Teams for Everyone Course 26: Advance Windows 10 Troubleshooting for IT HelpDesk Course 27: Microsoft SQL Server Development for Everyone Course 28: Microsoft Excel for Business Accounting Course 29: Microsoft Project: Learn the Fundamentals of Project Management Course 30: Admin, Secretarial & PA What will make you stand out? Upon completion of this online Microsoft Azure Fundamentals- (30 in 1) CPD Accredited Courses! Bundle, you will gain the following: CPD QS Accredited Proficiency with this Microsoft Azure Fundamentals Bundle After successfully completing the Microsoft Azure Fundamentals bundle, you will receive a FREE PDF Certificate from REED as evidence of your newly acquired abilities. Lifetime access to the whole collection of learning materials of this Microsoft Azure Fundamentals Bundle The online test with immediate results You can study and complete the Microsoft Azure Fundamentals bundle at your own pace. Study for the Microsoft Azure Fundamentals bundle using any internet-connected device, such as a computer, tablet, or mobile device. The Microsoft Azure Fundamentals- (30 in 1) CPD Accredited Courses! bundle is a premier learning resource, with each course module holding respected CPD accreditation, symbolising exceptional quality. The content is packed with knowledge and is regularly updated to ensure it remains relevant. This bundle offers not just education but a constantly improving learning experience designed to enrich both your personal and professional development. Advance the future of learning with the Microsoft Azure Fundamentals bundle, a comprehensive, complete collection of 30 courses. Each course in the Microsoft Azure Fundamentals bundle has been handpicked by our experts to provide a broad range of learning opportunities. Together, these modules form an important and well-rounded learning experience. Our mission is to deliver high-quality, accessible education for everyone. Whether you are starting your career, switching industries, or enhancing your professional skills, the Microsoft Azure Fundamentals bundle offers the flexibility and convenience to learn at your own pace. Make the Microsoft Azure Fundamentals package your trusted partner in your lifelong learning journey. CPD 300 CPD hours / points Accredited by CPD Quality Standards Who is this course for? The Microsoft Azure Fundamentals- (30 in 1) CPD Accredited Courses! is perfect for: Expand your knowledge and skillset for a fulfilling career with the Microsoft Azure Fundamentals bundle. Become a more valuable professional by earning CPD certification and mastering in-demand skills with the Microsoft Azure Fundamentals bundle. Discover your passion or explore new career options with the diverse learning opportunities in the Microsoft Azure Fundamentals bundle. Learn on your schedule, in the comfort of your home - the Microsoft Azure Fundamentals bundle offers ultimate flexibility for busy individuals. Requirements You are warmly invited to register for this bundle. Please be aware that no formal entry requirements or qualifications are necessary. This curriculum has been crafted to be open to everyone, regardless of previous experience or educational attainment. Career path Gain a wide range of skills across various fields, improve your problem-solving capabilities, and keep current with industry trends. Perfect for those aiming for career advancement, exploring a new professional direction, or pursuing personal growth. Begin your journey with the Microsoft Azure Fundamentals bundle. Certificates CPD Certificates Digital certificate - Included

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

***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.

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

Duration 2 Days 12 CPD hours This course is intended for Report authors working with dimensional data sources. Through interactive demonstrations & exercises, participants will learn how to author reports that navigate & manipulate dimensional data structures using the specific dimensional functions & features available in IBM Cognos Analytics. Introduction to Dimensional Concepts Identify different data sources and models Investigate the OLAP dimensional structure Identify dimensional data items and expressions Differentiate the IBM Cognos Analytics query language from SQL and MDX Differentiate relational and dimensional report authoring styles Introduction to Dimensional Data in Reports Work with members Identify sets and tuples in IBM Cognos Analytics Dimensional Report Context Understand the purpose of report context Understand how data is affected by default and root members Focus Your Dimensional Data Compare dimensional queries to relational queries Explain the importance of filtering dimensional queries Evaluate different filtering techniques Filter based on dimensions and members Filter based on measure values Filter using a slicer Calculations & Dimensional Functions Use IBM Cognos Analytics dimensional functions to create sets and tuples Perform arithmetic operations in OLAP queries Identify coercion errors and rules Functions for Navigating Dimesional Hierarchies Navigate dimensional data using family functions Relative Functions Navigate dimensional data using relative functions Navigate dimensional data using relative time functions Advanced Drilling Techniques & Member Sets Understand default drill-up and drill-down functionality Identify cases when you need to override default drilling behavior Configure advanced drilling behavior to support sophisticated use cases Define member sets to support advanced drilling Define member sets to support functions Set Up Drill-Through Reports Navigate from a specific report to a target report Drill down to greater detail and then navigate to target report Navigate between reports created using different data sources End-to-End Workshop Review concepts covered throughout the course