Overview This comprehensive course on Stock Market Investing for Beginners will deepen your understanding on this topic. After successful completion of this course you can acquire the required skills in this sector. This Stock Market Investing for Beginners comes with accredited certification from CPD, which will enhance your CV and make you worthy in the job market. So enrol in this course today to fast track your career ladder. How will I get my certificate? At the end of the course there will be an online written test, which you can take either during or after the course. After successfully completing the test you will be able to order your certificate, these are included in the price. Who is This course for? There is no experience or previous qualifications required for enrolment on this Stock Market Investing for Beginners . It is available to all students, of all academic backgrounds. Requirements Our Stock Market Investing for Beginners is fully compatible with PC's, Mac's, Laptop, Tablet and Smartphone devices. This course has been designed to be fully compatible with tablets and smartphones so you can access your course on Wi-Fi, 3G or 4G. There is no time limit for completing this course, it can be studied in your own time at your own pace. Career Path Learning this new skill will help you to advance in your career. It will diversify your job options and help you develop new techniques to keep up with the fast-changing world. This skillset will help you to- Open doors of opportunities Increase your adaptability Keep you relevant Boost confidence And much more! Course Curriculum 20 sections • 20 lectures • 02:10:00 total length •Module 01: Introduction to the Course .: 00:01:00 •Module 02: Introduction to Stocks.: 00:04:00 •Module 03: Money Required for Primary Investment.: 00:02:00 •Module 04: Opening an Investment Account.: 00:05:00 •Module 05: Brokerage Account Walkthrough.: 00:13:00 •Module 06: Finding Winning Stocks.: 00:24:00 •Module 07: Earning from Dividends.: 00:06:00 •Module 08: Diversifying Portfolio.: 00:05:00 •Module 09: Investment Plan.: 00:07:00 •Module 10: Rebalancing Portfolio.: 00:05:00 •Module 11: Understanding Order Types.: 00:05:00 •Module 12: Investment Tax.: 00:06:00 •Module 13: Investment Rules: Rule-1: 00:01:00 •Module 14: Investment Rules: Rule-2.: 00:01:00 •Module 15: Investment Rules: Rule-3.: 00:02:00 •Module 16: Investment Rules: Rule-4.: 00:02:00 •Module 17: Investment Rules: Rule-5.: 00:01:00 •Module 18: Stock Market Dictionary.: 00:10:00 •Module 19: Setting Up the Trading Platform.: 00:30:00 •Assignment -Stock Market Investing for Beginners: 00:00:00
Overview This comprehensive course on Painting and Decorating will deepen your understanding on this topic. After successful completion of this course you can acquire the required skills in this sector. This Painting and Decorating comes with accredited certification from CPD, which will enhance your CV and make you worthy in the job market. So enrol in this course today to fast-track your career ladder. How will I get my certificate? You may have to take a quiz or a written test online during or after the course. After successfully completing the course, you will be eligible for the certificate. Who is This course for? There is no experience or previous qualifications required for enrolment on this Painting and Decorating. It is available to all students, of all academic backgrounds. Requirements Our Painting and Decorating is fully compatible with PC's, Mac's, Laptop, Tablet and Smartphone devices. This course has been designed to be fully compatible with tablets and smartphones so you can access your course on Wi-Fi, 3G or 4G. There is no time limit for completing this course, it can be studied in your own time at your own pace. Career Path Learning this new skill will help you to advance in your career. It will diversify your job options and help you develop new techniques to keep up with the fast-changing world. This skillset will help you to- Open doors of opportunities Increase your adaptability Keep you relevant Boost confidence And much more! Course Curriculum 8 sections • 28 lectures • 02:05:00 total length •Introduction: 00:01:00 •Setting Up Your Workspace: 00:04:00 •Workspace - Cleaning Your Glass Palette: 00:02:00 •Workspace - Substrates: 00:02:00 •Workspace - Preparing Your Paper: 00:04:00 •Color Mixing Resources: 00:02:00 •Color Mixing Part 1: 00:06:00 •Color Mixing Part 2: 00:05:00 •Color Mixing Part 3: 00:05:00 •Brushes Part 1: 00:05:00 •Brushes Part 2: 00:06:00 •Brushes Part 3: 00:05:00 •Cleaning & Caring For Your Brushes: 00:03:00 •Texture Part 1: 00:05:00 •Texture Part 2: 00:06:00 •Dimension Part 1: 00:06:00 •Dimension Part 2: 00:06:00 •Dimension Part 3: 00:06:00 •Dimension Part 4: 00:06:00 •Dimension Part 5: 00:05:00 •Depth of Field Part 1: 00:06:00 •Depth of Field Part 2: 00:06:00 •Depth of Field Part 3: 00:06:00 •Depth of Field Part 4: 00:06:00 •Depth of Field Part 5: 00:05:00 •Depth of Field Part 6: 00:05:00 •Final Thoughts & Class Project: 00:01:00 •Assignment - Painting and Decorating: 00:00:00
Overview This comprehensive course on Scrum Master Level 2 will deepen your understanding on this topic. After successful completion of this course you can acquire the required skills in this sector. This Scrum Master Level 2 comes with accredited certification from CPD, which will enhance your CV and make you worthy in the job market. So enrol in this course today to fast track your career ladder. How will I get my certificate? At the end of the course there will be an online written test, which you can take either during or after the course. After successfully completing the test you will be able to order your certificate, these are included in the price. Who is This course for? There is no experience or previous qualifications required for enrolment on this Scrum Master Level 2. It is available to all students, of all academic backgrounds. Requirements Our Scrum Master Level 2 is fully compatible with PC's, Mac's, Laptop, Tablet and Smartphone devices. This course has been designed to be fully compatible with tablets and smartphones so you can access your course on Wi-Fi, 3G or 4G. There is no time limit for completing this course, it can be studied in your own time at your own pace. Career Path Learning this new skill will help you to advance in your career. It will diversify your job options and help you develop new techniques to keep up with the fast-changing world. This skillset will help you to- Open doors of opportunities Increase your adaptability Keep you relevant Boost confidence And much more! Course Curriculum 9 sections • 30 lectures • 01:55:00 total length •Introduction: 00:01:00 •Overview of Workflows and Approaches: 00:02:00 •Traditional (Waterfall a like): 00:06:00 •Agile.: 00:06:00 •Traditional vs Agile: 00:07:00 •Summary on Workflows and Approaches: 00:03:00 •Agile Manifesto: 00:02:00 •It's Scrum time: 00:01:00 •Scrum Overview: 00:05:00 •Methodology vs Framework: 00:04:00 •Scrum Roles Overview: 00:01:00 •Scrum Master (SM): 00:06:00 •Product Owner (PO): 00:06:00 •Development Team (Dev Team): 00:07:00 •Summary on Scrum Roles: 00:01:00 •Scrum Events Overview: 00:01:00 •Daily Scrum (Standup): 00:04:00 •Sprint Planning: 00:07:00 •Sprint Review: 00:07:00 •Sprint Retrospective: 00:07:00 •Other Non-Prescribed Events: 00:02:00 •Summary on Scrum Events: 00:03:00 •Scrum Artifacts Overview: 00:01:00 •Product Backlog: 00:10:00 •Sprint Backlog: 00:09:00 •Product Increment: 00:03:00 •Other Non-Prescribed Artifacts: 00:01:00 •Summary on Scrum Artifacts: 00:01:00 •Thank you!: 00:01:00 •Assignment - Scrum Master Level 2: 00:00:00
Overview This comprehensive course on Mini MBA will deepen your understanding on this topic. After successful completion of this course you can acquire the required skills in this sector. This Mini MBA comes with accredited certification from CPD, which will enhance your CV and make you worthy in the job market. So enrol in this course today to fast track your career ladder. How will I get my certificate? You may have to take a quiz or a written test online during or after the course. After successfully completing the course, you will be eligible for the certificate. Who is This course for? There is no experience or previous qualifications required for enrolment on this Mini MBA. It is available to all students, of all academic backgrounds. Requirements Our Mini MBA is fully compatible with PC's, Mac's, Laptop, Tablet and Smartphone devices. This course has been designed to be fully compatible with tablets and smartphones so you can access your course on Wi-Fi, 3G or 4G. There is no time limit for completing this course, it can be studied in your own time at your own pace. Career Path Learning this new skill will help you to advance in your career. It will diversify your job options and help you develop new techniques to keep up with the fast-changing world. This skillset will help you to- Open doors of opportunities Increase your adaptability Keep you relevant Boost confidence And much more! Course Curriculum 25 sections • 25 lectures • 03:25:00 total length •Appreciating the Mini MBA: 00:10:00 •The Foundations of Business: 00:10:00 •Understanding Business Law: 00:10:00 •Competitive Business Strategies: 00:10:00 •Departments in Business: 00:10:00 •Planning the Right Strategy for Business: 00:05:00 •Managing Human Resources in Business: 00:10:00 •Economics Influences on Business: 00:10:00 •Business Accounting: 00:10:00 •Finance in Business: 00:10:00 •Business Marketing: 00:10:00 •Advertising and Promotion: 00:10:00 •The Art of Negotiation: 00:05:00 •Communication and Presentation: 00:05:00 •Organisational Behaviour in Business: 00:10:00 •Building Teams in Business: 00:05:00 •Business Leadership: 00:05:00 •Operations Management: 00:15:00 •The Importance of Risk Management: 00:10:00 •Project Management: 00:05:00 •Quantitative Research and Analysis: 00:05:00 •Qualitative Research and Analysis: 00:05:00 •Becoming an Entrepreneur: 00:05:00 •Corporate Social Responsibility (CSR): 00:10:00 •Avoiding Management Mistakes: 00:05:00
Overview Gain the skills and abilities to attain a long and satisfying career in business by studying the principles of Accounting and Bookkeeping.This Diploma in Accounting and Bookkeeping course will quickly and efficiently provide the tutoring you need to excel in organising the financial management of a company.Written with the aid of industry experts, the course will train you to keep a business payroll operating, track supplies and inventory, handle budgets and cash, pay taxes, and report to all of your stakeholders. There is no more complete way to obtain this certificated amount of training and learn how to master a dynamic career path. How will I get my certificate? Upon successful completion of the Diploma in Accounting and Bookkeeping course, obtaining your certificate is a straightforward process. Here's how it works: Course Completion: Once you've successfully finished the course, you'll be eligible to receive your certificate. Order Your Certificate: You can conveniently order your certificate directly through our platform. Who is this course for? Diploma in Accounting and Bookkeeping is specially designed for a variety of learners. Open to all: No prior experience or certifications are required. Inclusive Learning: Welcoming students from various academic backgrounds. Universal Accessibility: Open to everyone interested in studying a Diploma in Accounting and Bookkeeping. Requirements Our Diploma in Accounting and Bookkeeping course is designed for maximum flexibility and accessibility. It is optimised for use on PCs, Macs, laptops, tablets, and smartphones. Study easily on your tablet or smartphone, accessible with any Wi-Fi connection. No time limit for completion; study at your own pace and on your own schedule. Basic English proficiency is required to ensure effective learning. This course structure allows for a convenient and adaptable learning experience. Career path Having these various qualifications will increase the value of your CV and open you up to multiple sectors, such as: Accountant: Steady career, £22k-£35k+. Manage day-to-day finances. Management Accountant: Analyse data, £28k-£40k+. Influence key decisions. Financial Analyst: Assess investments, £25k-£35k+. Fast-paced, dynamic environment. Auditor: Verify records, £28k-£40k+. Ensure financial integrity. Tax Advisor: Minimise tax liabilities, £25k-£35k+. Help clients save money. Remember, ranges vary depending on experience and location. Consider professional certifications for a boost! Course Curriculum 9 sections • 21 lectures • 05:56:00 total length •Introduction: 00:02:00 •Introduction to Bookkeeping: 00:15:00 •Manual System: 00:08:00 •Computerised Systems: 00:11:00 •How it Fits Together: 00:08:00 •Bookkeeping Basics: 00:30:00 •Ledgers: 00:10:00 •Trial Balance and Coding: 00:11:00 •PNL Account and Balance Sheet: 00:05:00 •AILE Personal: 00:06:00 •Course Overview: 00:05:00 •Getting the Facts Straight: 00:30:00 •The Accounting Cycle: 00:30:00 •The Key Reports: 00:30:00 •A Review of Financial Terms: 00:30:00 •Understanding Debits and Credits: 00:15:00 •Your Financial Analysis Toolbox: 00:30:00 •Identifying High and Low Risk Companies: 00:30:00 •The Basics of Budgeting: 00:30:00 •Working Smarter: 00:10:00 •Assignment - Diploma in Accounting and Bookkeeping: 00:10:00
Overview Learn how to help and support anyone affected by the loss of a loved one and now show signs of distress.By enrolling in this Bereavement Counselling course, you will be trained on how to assist those individuals who are in mourning and finding difficulties in their lives.Whether you are a professional counsellor or someone who wants to gain the ability to face issues around mortality, this course will provide the knowledge that you require. You will learn how grief impacts mental and physical wellbeing and the appropriate procedures that should be initiated to help those in need of guidance. How will I get my certificate? Upon successful completion of the Bereavement Counselling course, obtaining your certificate is a straightforward process. Here's how it works: Course Completion: Once you've successfully finished the course, you'll be eligible to receive your certificate. Order Your Certificate: You can conveniently order your certificate directly through our platform. Who is this course for? Bereavement Counselling is specially designed for a variety of learners: Open to all: No prior experience or certifications are required. Inclusive Learning: Welcoming students from various academic backgrounds. Universal Accessibility: Open to everyone interested in studying Bereavement Counselling. Requirements Our Bereavement Counselling course is designed for maximum flexibility and accessibility: It is optimised for use on PCs, Macs, laptops, tablets, and smartphones. Study easily on your tablet or smartphone, accessible with any Wi-Fi connection. No time limit for completion; study at your own pace and on your own schedule. Basic English proficiency is required to ensure effective learning. This course structure allows for a convenient and adaptable learning experience. Career path Having these various qualifications will increase the value of your CV and open you up to multiple sectors, such as: Counsellor: £25-25,000 (charities, healthcare facilities) Psychotherapist: £30-60k+ (more qualifications, deeper therapy) Specialist in Grief Support: £22-35k+ (workshops, groups) Specialist in Corporate Loss: £30-50k (support for employees) £28-45k (training, research) for an educator/researcher Ranges depend on the employer, qualifications, and experience. Extra credit and private practice can increase revenue. Course Curriculum 4 sections • 23 lectures • 02:38:00 total length •About the Instructor & the Course: 00:03:00 •What is counselling: Introduction to Counselling Theory: 00:07:00 •Core Skills in Counselling: 00:07:00 •Counselling Approaches in Counselling: 00:09:00 •What is 'Grief' and 'Bereavement'?: 00:09:00 •The Role of the Bereavement Counsellor: 00:07:00 •Beliefs that people held about 'death' and 'dying': 00:09:00 •A child and adolescent view of death: 00:07:00 •Spirituality and Religion: 00:08:00 •The process of dying: 00:07:00 •Stages of Grief: 00:08:00 •What is 'Complicated grief'?: 00:09:00 •Sadness Vs Depression: 00:06:00 •Grief Vs Depression: 00:05:00 •Types of Depression: 00:09:00 •Diagnosis of Depression: 00:05:00 •Treatments available for depression: 00:08:00 •Grief counselling: The loss of 'self': 00:07:00 •Adjusting to violent death: 00:08:00 •Counselling the dying: 00:07:00 •Acceptance, Surrender, and 'Letting go': 00:05:00 •Ending long-term counselling and follow-up: 00:07:00 •Thank You and Good Bye!: 00:01:00
Overview This comprehensive course on Animator Training: Animate in Photoshop will deepen your understanding on this topic. After successful completion of this course you can acquire the required skills in this sector. This Animator Training: Animate in Photoshop comes with accredited certification from CPD, which will enhance your CV and make you worthy in the job market. So enrol in this course today to fast track your career ladder. How will I get my certificate? You may have to take a quiz or a written test online during or after the course. After successfully completing the course, you will be eligible for the certificate. Who is This course for? There is no experience or previous qualifications required for enrolment on this Animator Training: Animate in Photoshop. It is available to all students, of all academic backgrounds. Requirements Our Animator Training: Animate in Photoshop is fully compatible with PC's, Mac's, Laptop, Tablet and Smartphone devices. This course has been designed to be fully compatible with tablets and smartphones so you can access your course on Wi-Fi, 3G or 4G. There is no time limit for completing this course, it can be studied in your own time at your own pace. Career Path Learning this new skill will help you to advance in your career. It will diversify your job options and help you develop new techniques to keep up with the fast-changing world. This skillset will help you to- Open doors of opportunities Increase your adaptability Keep you relevant Boost confidence And much more! Course Curriculum 6 sections • 18 lectures • 01:49:00 total length •Introduction to Animate in Photoshop!: 00:02:00 •Why Use Photoshop to Animate? How I Use Photoshop in Multimedia. A Case Study: 00:03:00 •Royalty-Free and Public Domain Video Resources: 00:03:00 •Setting Up to Animate in Photoshop: Windows and Tools: 00:03:00 •Importing Your Video and Working With Different Video Formats: 00:07:00 •Make a Quick & Dirty Stop Motion Animation By Adjusting Your Frames Per Second: 00:06:00 •Drawing Right Over Your Video and Making a Simple Frame By Frame Animation: 00:04:00 •Using the Onion Skin Options to Make More Decisive Drawings (Frame By Frame): 00:04:00 •Use the 'Wiggle' Technique to Get More Mileage Out of Your Drawings (Looping): 00:10:00 •Let's Have Photoshop Animate For Us (Position, Scaling, Opacity, Rotation, etc.): 00:12:00 •Rotoscoping and Animating the Frame By Frame Way (*The Essence of How I Work: 00:12:00 •Adding Filters and Other Special Effects to Your Video (For Good or For Evil): 00:06:00 •Turning a Video Into an Animated Painting With Brushes: 00:06:00 •Exporting the Final Video From Photoshop: 00:04:00 •How to Create a Simple Animated Gif in Photoshop: 00:11:00 •How to Create a Quick & Dirty (But Beautiful) Animated Gif Slideshow: 00:09:00 •Top Social Media Platforms and Websites For Filmmakers and Animators: 00:07:00 •Assignment - Animator Training: Animate in Photoshop: 00:00:00
Overview Promote positive mental health in a learning environment with the Mental Health Awareness in Schools course.This Mental Health Awareness in Schools course will teach you all about mental health and young minds. It will explore mental health issues in children and young people and their symptoms. You will also gain the skills to promote positive mental health and a healthy environment within schools, exploring various aspects of mental health.Ensure a healthy environment and the wellbeing of children in a school setting, by enrolling today. How will I get my certificate? You may have to take a quiz or a written test online during or after the course. After successfully completing the course, you will be eligible for the certificate. Who is this course for? There is no experience or previous qualifications required for enrolment on this Mental Health Awareness in Schools. It is available to all students, of all academic backgrounds. Requirements Our Mental Health Awareness in Schools is fully compatible with PC's, Mac's, Laptop, Tablet and Smartphone devices. This course has been designed to be fully compatible on tablets and smartphones so you can access your course on wifi, 3G or 4G.There is no time limit for completing this course, it can be studied in your own time at your own pace. Career path Having these various qualifications will increase the value in your CV and open you up to multiple sectors such as Business & Management , Admin, Accountancy & Finance, Secretarial & PA, Teaching & Mentoring etc. Course Curriculum 2 sections • 31 lectures • 01:10:00 total length •Children's Mental Health Basics: 00:30:00 •Nurturing Positivity And Confidence: 01:00:00 •Recognise Changed Behaviour In Your Child: 01:00:00 •About Birth Defects: 01:00:00 •About Behaviour Disorders: 01:00:00 •Mental Health Games For Children: 01:00:00 •Make Sure You Take Care Of Yourself As Well: 00:30:00 •The Basics About Autism: What Is It?: 00:30:00 •What Are the Factors that Contribute A Child to Autism: 01:30:00 •Autism and Genetics: 01:30:00 •What Are the Basic Symptoms of Autism: 01:00:00 •What Are the Speech and Communication Problems of Autism: 01:00:00 •Autism and Body Language: 01:00:00 •Autism, Toxic Metals, and Vaccines: 00:30:00 •The Cause of Autism Might Be Found in Autistic Mice: 00:30:00 •Autism: The Need for Increased Research: 00:30:00 •How is Autism Treated: 01:00:00 •How Is Autism Diagnosed: 00:30:00 •Myths about Autism: 00:10:00 •How to Look for Autism Signs in Infants: 00:30:00 •How Can Families Cope With an Autistic Child and the Financial Burden: 00:30:00 •The Differences Between Asperger's Syndrome and Autism: 01:00:00 •Autism Assistance Dogs: 01:00:00 •Teaching Autistic Children: 01:00:00 •The Fixation Behavior of an Autistic Child: 00:30:00 •The Autism Society of America: 00:30:00 •Childproofing Your Home for Your Autistic Child: 00:30:00 •Autism and Nutritional Supplements: 01:00:00 •Toilet Training the Autistic Child: 01:00:00 •Difficulties of an Autistic Adult: 01:00:00 •Alternative Treatments for Autism: 01:00:00
Overview This comprehensive course on Develop Vector Game Art With Inkscape will deepen your understanding on this topic. After successful completion of this course you can acquire the required skills in this sector. This Develop Vector Game Art With Inkscape comes with accredited certification from CPD, which will enhance your CV and make you worthy in the job market. So enrol in this course today to fast track your career ladder. How will I get my certificate? You may have to take a quiz or a written test online during or after the course. After successfully completing the course, you will be eligible for the certificate. Who is This course for? There is no experience or previous qualifications required for enrolment on this Develop Vector Game Art With Inkscape. It is available to all students, of all academic backgrounds. Requirements Our Develop Vector Game Art With Inkscape is fully compatible with PC's, Mac's, Laptop, Tablet and Smartphone devices. This course has been designed to be fully compatible with tablets and smartphones so you can access your course on Wi-Fi, 3G or 4G. There is no time limit for completing this course, it can be studied in your own time at your own pace. Career Path Learning this new skill will help you to advance in your career. It will diversify your job options and help you develop new techniques to keep up with the fast-changing world. This skillset will help you to- Open doors of opportunities Increase your adaptability Keep you relevant Boost confidence And much more! Course Curriculum 8 sections • 30 lectures • 04:27:00 total length •Introduction: 00:02:00 •The user interface: 00:03:00 •Drawing your first object: 00:07:00 •Working with multiple objects: 00:07:00 •Colors in Inkscape: 00:06:00 •Path operations - creating simple shapes: 00:09:00 •Gradients and groups: 00:11:00 •Modify path - the best way refine your objects: 00:09:00 •Use what you learned draw a bomb in Inkscape: 00:09:00 •Export bitmap image: 00:07:00 •How and why to save to SVG: 00:03:00 •First step - learn the text tool: 00:06:00 •Align and distribute: 00:05:00 •Button states: 00:05:00 •Buton variations: 00:17:00 •Design a basic platform: 00:08:00 •Tiling platforms: 00:09:00 •Platform mutationsPlatform mutations: 00:08:00 •Draw and move a character or a top down shooter: 00:09:00 •Design a a game hero!: 00:11:00 •Character poses: 00:11:00 •Practice animation The blob!: 00:14:00 •Set up and understand a more complex walk cycle: 00:14:00 •Finish the walk cycle: 00:09:00 •Understanding backgrounds: 00:05:00 •Tiling backgrounds: 00:14:00 •Add foreground elements: 00:20:00 •Bacground variations: 00:17:00 •Modularity - be more creative and efficient: 00:11:00 •Bonus lecture: 00:01:00
Overview This comprehensive course on Data Analysis and Forecasting in Excel will deepen your understanding on this topic. After successful completion of this course you can acquire the required skills in this sector. This Data Analysis and Forecasting in Excel comes with accredited certification from CPD, which will enhance your CV and make you worthy in the job market. So enrol in this course today to fast track your career ladder. How will I get my certificate? You may have to take a quiz or a written test online during or after the course. After successfully completing the course, you will be eligible for the certificate. Who is This course for? There is no experience or previous qualifications required for enrolment on this Data Analysis and Forecasting in Excel. It is available to all students, of all academic backgrounds. Requirements Our Data Analysis and Forecasting in Excel is fully compatible with PC's, Mac's, Laptop, Tablet and Smartphone devices. This course has been designed to be fully compatible with tablets and smartphones so you can access your course on Wi-Fi, 3G or 4G. There is no time limit for completing this course, it can be studied in your own time at your own pace. Career Path Learning this new skill will help you to advance in your career. It will diversify your job options and help you develop new techniques to keep up with the fast-changing world. This skillset will help you to- Open doors of opportunities Increase your adaptability Keep you relevant Boost confidence And much more! Course Curriculum 10 sections • 31 lectures • 04:43:00 total length •Insert, Delete, and Adjust Cells, Columns, and Rows: 00:10:00 •Search for and Replace Data: 00:09:00 •Use Proofing and Research Tools: 00:07:00 •Sort Data: 00:10:00 •Filter Data: 00:10:00 •Query Data with Database Functions: 00:09:00 •Outline and Subtotal Data: 00:09:00 •Apply Intermediate Conditional Formatting: 00:07:00 •Apply Advanced Conditional Formatting: 00:05:00 •Create Charts: 00:13:00 •Modify and Format Charts: 00:12:00 •Use Advanced Chart Features: 00:12:00 •Create a PivotTable: 00:13:00 •Analyze PivotTable Data: 00:12:00 •Present Data with PivotCharts: 00:07:00 •Filter Data by Using Timelines and Slicers: 00:11:00 •Use Links and External References: 00:12:00 •Use 3-D References: 00:06:00 •Consolidate Data: 00:05:00 •Use Lookup Functions: 00:12:00 •Trace Cells: 00:09:00 •Watch and Evaluate Formulas: 00:08:00 •Apply Data Validation: 00:13:00 •Search for Invalid Data and Formulas with Errors: 00:04:00 •Work with Macros: 00:18:00 •Create Sparklines: 00:07:00 •MapData: 00:07:00 •Determine Potential Outcomes Using Data Tables: 00:08:00 •Determine Potential Outcomes Using Scenarios: 00:09:00 •Use the Goal Seek Feature: 00:04:00 •Forecasting Data Trends: 00:05:00