5410 Courses in Cardiff delivered Online

Everybody is a genius. But if you judge a fish by its ability to climb a tree, it will live its whole life believing that it is stupid. If a child can't learn the way you teach, maybe you should teach the way they learn. And what most people don't know is that most Special Education teachers are really angels disguised as extraordinary humans. If you want to become one of them, then this Level 3 Award in Education & Training (RQF) and Special Educational Needs (SEN) is for you. As it's the teacher that makes the difference, not the classroom. And this noble in-demand job has its rewards too. The average special needs teacher salary in the United Kingdom is £36,000 per year or £18.46 per hour. Where entry-level positions start at £31,339 per year while most experienced workers make up to £47,047 per year. So it's high time you choose your career wisely. Our Level 3 Award in Education & Training (RQF) is Ofqual regulated (the UK Govt. recognised) and offers you 115 CPD hours in this programme so that you can improve your teaching skills and enhance your chances of employability. This course was precisely created by renowned world-leading professors to thoroughly prepare you for the academic year-end assessment for Education & Training (RQF). What other courses are included with this AET: Level 3 Award in Education & Training AET (former PTLLS) Course?: With this AET: Level 3 Award in Education & Training AET (former PTLLS) Course, learners will get the 20 Premium courses absolutely FREE. Course 01: Education Management Course 02: Educational Psychology and Development Course 03: Advanced Teaching Assistant Diploma Course 04: Special Education Needs (SEN) Training - Level 2 Course 05: EYFS Teaching - Level 3 Course 06: Phonics Teaching Diploma Level 3 Course 07: Leadership in Teaching Course 08: Lesson Planning for Teaching Course 09: Remote Teaching Online Course 10: Classroom Behaviour Management Course 11: Performance Management Course 12: Work Area Organisation for Increased Office Productivity Course 13: Report Writing Course 14: Domestic Violence and Abuse Awareness - Level 2 Course 15: Child Neglect Awareness Certificate Course Course 16: Level 3 Mental Health and Adolescent Course Course 17: Safeguarding Children Level 3 Course 18: Functional Skills English Practice Level 2 Course 19: Train the Trainer Course 20: Leadership & Management Diploma Enrol in this AET: Level 3 Award in Education and Training AET (Formerly PTTLS) Course to become certified at a nationally acceptable level. Why is this Level 3 Award in Education & Training (RQF) and Special Educational Needs (SEN) Course perfect for You? Choose & Advance Your Career: Join today and make a life-changing decision, learn with our Regulated qualifications and move up to the next level in your organisation with expertise. 20 Additional Courses: With a single payment, you will get access to the Level 3 Award in Education & Training (RQF) and Special Educational Needs (SEN) along with 3 additional CPD courses Upgrade Your Skills: Add value to your current educational profile and gain the skill sets to compete in your job role with unlimited dedicated personal tutor support. Enhance Your Credibility: Quality assured for your peace of mind - qualification regulated by Ofqual. The Level 3 Award in Education & Training (RQF) course is Ofqual, UK Govt. Regulated and Awarded by Focus, which adds value to your educational profile. 100% Money-Back Guarantee: We are confident about our course quality and want to provide the best service to our invaluable learners. That's why we provide 14 days Unconditional Full Money-Back Guarantee with this course to ensure a hassle-free purchase. Qualification Summary Qualification type: Focus Level 3 Award Qualification title: Focus Level 3 Award in Education and Training (RQF) Accreditation status: Accredited Level: 3 Guided Learning Hours (GLH): 48 Total Qualification Time (TQT): 120 Advantages of Learning Level 3 Award in Education & Training (RQF) and Special Educational Needs (SEN) with Apex Learning: Buy 1 Get 20 additional CPD courses. Premium quality, intensive e-learning course materials LinkedIn profile optimisation Resume support from professionals for jobs hunting No Hidden Charges Find a well-defined website for learning 24/7 teacher assistance Step-by-step guidelines Budget-friendly price Earned recognition from the UK's top awarding bodies Study in a user-friendly, advanced student portal Convenient and Flexible time limit Course Curriculum of Level 3 Award in Education & Training (RQF) **Focus Level 3 Award in Education and Training (RQF)** Unit 1: Understanding Roles, Responsibilities and Relationships in Education and Training Unit 2: Understanding and Using Inclusive Teaching and Learning Approaches in Education and Training Unit 5: Understanding Assessment in Education and Training **Special Education Needs (SEN) Training** Module 01: Special Education Needs (SEN) An Overview Module 02: SEN Support Module 03: High Quality Teaching for Pupils with SEN Module 04: SEN Teaching Methodologies Module 05: Communication and Interaction Module 06: Cognition and Learning Module 07: Social, Emotional and Mental Health Difficulties Module 08: Sensory or Physical Needs Module 09: Working in Partnership Learning Outcomes What skills will I gain from this Level 3 Award in Education & Training AET (former PTLLS) Course? AET (former PTLLS) - Understand the underlying fundamentals of teaching and learning AET (former PTLLS) - Make a practical approach to session planning AET (former PTLLS) - Explore the various approaches to learning AET (former PTLLS) - Determine the students' desires and long-term goals AET (former PTLLS) - Implement strategies for assessing your students' potential AET (former PTLLS) - You will become an expert in education and training AET (former PTLLS) - You will gain knowledge in teacher expectations & attributions and much more Learning Duration AET (former PTLLS) Total Qualification Time It is an estimate of the total amount of time anticipated that a learner would spend to demonstrate mastery of all learning outcomes to achieve the award of the qualification. The whole qualification time is defined as GLH and an estimate of the time a learner will devote to preparation, study, and assessment. It does not underlie supervision by a lecturer, supervisor, or tutor. In the case of qualification, the credit value is defined by TQT, and one credit corresponds to ten hours of learning. Total Qualification Time for this qualification is 120 hours. The total credit value for this qualification is 12 AET (former PTLLS) Guided Learning Hours Guided Learning Hours for this qualification is 48. These hours comprise all real-time contact time, hours of lectures or tutorials or supervision of a learner, tutor, trainer or other education providers. Progression Level 4 Certificate in Education and Training Level 5 Diploma in Education and Training Level 3 Award in Understanding the Principles and Practices of Assessment Level 3 Award in Assessing Competence in the Work Environment Level 3 Award in Assessing Vocational Related Achievement Level 3 Certificate in Assessing Vocational Achievement Level 4 Award in Understanding the Internal Quality Assurance of Assessment Processes and Practice Level 4 Award in the Internal Quality Assurance of Assessment Processes and Practice Level 4 Certificate in Leading the Internal Quality Assurance of Assessment Processes and Practice Level 4 Award in Learning and Development Level 4 Diploma in Learning and Development Tutor Support 1-2-1 Expert Tutor Support Method of Assessment: Unit 1: In Unit 1, you need to complete a variety of writing assignments Unit 2: In Unit 2, there should be an assessment taken in the workplace, primarily evaluating learners' work, professional discussions with audio-video evidence Unit 5: In Unit 5, you will be demonstrated through your delivered work items and audio-video evidence after evaluating learners in a training context. AET (former PTLLS) Video Assessment You have to plan many things, such as observation, questioning/ professional discussion, and inspection of supporting work products evidence. Detailed assignment instructions will be made available to you in the 'Guidance for Achieving the Unit' section of your learning portal with a careful and clear explanation. You have to submit all your assignments via the online portal Certification Successful candidates will be awarded a Level 3 Award in Education & Training AET (former PTLLS) from Focus Award Limited. Who is this course for? Our comprehensive Level 3 Award in Education & Training (RQF) and Special Educational Needs (SEN) course is designed for ambitious students who are currently employed or seeking employment in the teaching field. The qualification is also suitable for individuals who: Wish to join in a teaching professionals Beginner this field and wish to acquire in-demand assessing skills Wish to gain formal recognition of their skills Want to study from home at their own convenience Requirements Our Level 3 Award in Education & Training (RQF) and Special Educational Needs (SEN) is fully compatible with PC's, Mac's, laptops, tablets and Smartphone devices. This course has been designed to be fully compatible with 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 Level 3 Award in Education & Training (RQF) You will have the ability to accomplish a lot of things with this certificate. Here are just a few examples: Primary School Teacher Secondary School Teacher Private Tutor Freelance Teacher/ Trainer Consultant Job hunters & School leavers Educational Psychologist Office clerk & Administration Assistant College or University Student

40-in-1 CPD Accredited Bundle| Special Gifts: Free PDF & Transcript Certificate| Updated course materials| Learner Support

Explore the intricacies of timber harvesting with our comprehensive course on Logger Training: Techniques in Timber Harvesting. From sustainable practices to advanced technology, delve into key topics including environmental conservation, legal considerations, and supply chain management. Master logging techniques, prioritize safety, and gain insights into the ethical dimensions of the industry. Elevate your skills and contribute to sustainable forestry management. Enroll now!

Excel but different. Harness this most powerful tool but on a course tailored to your business and needs. Using case studies relevant to your business and often actual files your firm uses on a daily basis we embark on a voyage of discovery. This isn't a boring "watch what I do and copy" course. This is exciting, engaging, funny and enjoyable. Delegates will learn relevant skills but also, because of the delivery methods they will gain an increased enjoyment of using Excel and will retain and implement all of the material covered. They also have access to the trainer for an unlimited amount of time after the course to continue to grow their knowledge

Excel but different. Harness this most powerful tool but on a course tailored to your business and needs. Using case studies relevant to your business and often actual files your firm uses on a daily basis we embark on a voyage of discovery. This isn't a boring "watch what I do and copy" course. This is exciting, engaging, funny and enjoyable. Delegates will learn relevant skills but also, because of the delivery methods they will gain an increased enjoyment of using Excel and will retain and implement all of the material covered. They also have access to the trainer for an unlimited amount of time after the course to continue to grow their knowledge

In today’s digital age, ensuring your workstation is set up correctly is essential for maintaining both health and productivity. This course offers a structured approach to understanding the key aspects of computer workstation safety, providing guidance on how to optimise your working environment. Whether you spend long hours at a desk or simply use a computer for occasional tasks, this training will teach you the fundamentals of ergonomics, proper equipment placement, and posture management to avoid strain or injury. Our course is designed to equip individuals with the necessary knowledge to create a safe and comfortable workspace without the need for in-person instruction. It covers vital topics such as adjusting seating, screen positioning, and keyboard usage, all of which can help mitigate common issues like eye strain, back pain, and repetitive stress injuries. Delivered in an accessible online format, this training ensures you can improve your workstation safety at your own pace, promoting a healthier, more efficient working environment without the need for a classroom setting. Key Features CPD Accredited FREE PDF + Hardcopy certificate Fully online, interactive course Self-paced learning and laptop, tablet and smartphone-friendly 24/7 Learning Assistance Discounts on bulk purchases Course Curriculum of Computer Workstation Safety Training Module 01 :Introduction to Computer Workstation Safety Module 02 :Ergonomics in Computer Workstation Module 03 :Preventing Repetitive Strain Injuries (RSI) Module 04 :Preventing Eye Injuries Module 05 :Posture and Movement Module 06 :Stretching and Relaxation Techniques Module 07 :Digital Security Learning Outcomes: Master Ergonomic Principles Apply RSI Prevention Techniques Implement Eye Safety Measures Optimize Posture and Movement Execute Relaxation Techniques Strengthen Digital Security Awareness Accreditation This course is CPD Quality Standards (CPD QS) accredited, providing you with up-to-date skills and knowledge and helping you to become more competent and effective in your chosen field. CPD 10 CPD hours / points Accredited by CPD Quality Standards Who is this course for? Office workers seeking to enhance workstation safety. IT professionals prioritizing digital security. Health and safety enthusiasts wanting specialised knowledge. Students aiming to bolster their employability. Managers striving for a safer work environment. Individuals concerned about long-term health impacts. Entrepreneurs focused on employee well-being. Anyone using a computer for extended periods. Career path Health and Safety Officer Ergonomics Consultant Occupational Health Specialist IT Security Analyst Office Manager Occupational Therapist Certificates Digital certificate Digital certificate - Included Once you've successfully completed your course, you will immediately be sent a FREE digital certificate. Hard copy certificate Hard copy certificate - Included Also, you can have your FREE printed certificate delivered by post (shipping cost £3.99 in the UK). For all international addresses outside of the United Kingdom, the delivery fee for a hardcopy certificate will be only £10. Our certifications have no expiry dates, although we do recommend that you renew them every 12 months.

Get ready for an exceptional online learning experience with the Merchandising Bundle! This carefully curated collection of 30 premium courses is designed to cater to a variety of interests and disciplines. Dive into a sea of knowledge and skills, tailoring your learning journey to suit your unique aspirations. The Merchandising Bundle is a dynamic package that blends the expertise of industry professionals with the flexibility of digital learning. It offers the perfect balance of foundational understanding and advanced insights. Whether you're looking to break into a new field or deepen your existing knowledge, the Merchandising - Bundle package has something for everyone. As part of the Merchandising Bundle package, you will receive complimentary PDF certificates for all courses in this bundle at no extra cost. Equip yourself with the Merchandising bundle to confidently navigate your career path or personal development journey. Enrol today and start your career growth! This Bundle Comprises the Following 30 CPD Accredited Courses: Course 01: Merchandising Course 02: Visual Merchandising Diploma Course 03: Store Assistant Course 04: Retail Management Course 05: Retail Associate Certificate Course 06: Fashion Store Assistant Course 07: Warehouse Operative Course 08: Inventory Controller Course 09: Product Management Course 10: Quality Management Course 11: Interior Design Diploma Course 12: Interior Design: Space Planning Course 13: Styling & Staging in Interior Design Course 14: Supply Chain Management Course 15: Certificate in Purchasing and Procurement Course 16: Purchase Ledger Course 17: Operations Management: Process Mapping & Supply Chain Course 18: Supply Chain Management for Different Retail Formats Course 19: Import/Export Course 20: Logistic Management Course 21: Transport Planner Course Course 22: Port Management Diploma Course 23: Level 3 E-commerce Management Course 24: Sales Negotiation Training Course Course 25: Creating Highly Profitable Sales Funnels Course 26: Customer Relationship Management Course 27: SAP Controlling (CO) - Product Costing S4HANA Course 28: Xero Accounting and Bookkeeping Training Course 29: Compliance and Risk Management Diploma Course 30: Workplace Productivity Training What will make you stand out? Upon completion of this online Merchandising bundle, you will gain the following: CPD QS Accredited Proficiency with this Merchandising bundle After successfully completing the Merchandising bundle, you will receive a FREE CPD PDF Certificates as evidence of your newly acquired abilities. Lifetime access to the whole collection of learning materials of this Merchandising bundle The online test with immediate results You can study and complete the Merchandising bundle at your own pace. Study for the Merchandising bundle using any internet-connected device, such as a computer, tablet, or mobile device. Each course in this Merchandising bundle holds a prestigious CPD accreditation, symbolising exceptional quality. The materials, brimming with knowledge, are regularly updated, ensuring their relevance. This bundle promises not just education but an evolving learning experience. Engage with this extraordinary collection, and prepare to enrich your personal and professional development. Embrace the future of learning with Merchandising, a rich anthology of 30 diverse courses. Each course in the Merchandising bundle is handpicked by our experts to ensure a wide spectrum of learning opportunities. This Merchandising bundle will take you on a unique and enriching educational journey. The bundle encapsulates our mission to provide quality, accessible education for all. Whether you are just starting your career, looking to switch industries, or hoping to enhance your professional skill set, the Merchandising bundle offers you the flexibility and convenience to learn at your own pace. Make the Merchandising package your trusted companion in your lifelong learning journey. CPD 300 CPD hours / points Accredited by CPD Quality Standards Who is this course for? The Merchandising bundle is perfect for: Lifelong learners looking to expand their knowledge and skills. Professionals seeking to enhance their career with CPD certification. Individuals wanting to explore new fields and disciplines. Anyone who values flexible, self-paced learning from the comfort of home. Requirements You are cordially invited to enroll in this Merchandising bundle; please note that there are no formal prerequisites or qualifications required. We've designed this curriculum to be accessible to all, irrespective of prior experience or educational background. Career path Unleash your potential with the Merchandisingbundle. Acquire versatile skills across multiple fields, foster problem-solving abilities, and stay ahead of industry trends. Ideal for those seeking career advancement, a new professional path, or personal growth. Embrace the journey with the Merchandising bundle package. Certificates CPD Quality Standard Certificate Digital certificate - Included 30 CPD Quality Standard Certificates - Free

Duration 3 Days 18 CPD hours This course is intended for This course is primarily designed for students who want to gain the skills necessary to use VBA to automate tasks in Excel such as collecting data from external sources, cleaning, and manipulating data. The target student may also want to learn how to create custom worksheet functions to streamline worksheet formulas and make complex worksheets easier to support, maintain, and understand. Overview In this course, you will develop and deploy VBA modules to solve business problems. You will: Identify general components of VBA and their appropriate use in solving business solutions. Record VBA macros to automate repetitive tasks. Use reference tools built into Excel to get help on VBA programming language and objects used in the Excel VBA environment. Write VBA code to create a custom worksheet function. Eliminate, avoid, or handle errors in VBA code, and optimize its performance. Control how and when macros run. Develop UserForm objects to create custom dialog boxes and windows. Use VBA to read and write data from local files and cloud services. Use VBA to clean and transform data. Run programs and commands outside of Excel and share VBA projects with other users VBA (Visual Basic for Applications) enables you to enhance and extend the capabilities of Microsoft© Excel© and other applications in the Microsoft© Office application suite. You can use VBA to perform tasks that would be difficult or impossible to do using only worksheet functions, and you can automate a wide range of tasks involving the collection, processing, analysis, and visualization of data. This course will give you a good foundation for understanding, creating, and using VBA in your own Excel workbooks, show you how to work with data across different applications, and how to package the macros and functions you create so you can back them up, move them to other computers, and share them with other users Prerequisites To ensure your success in this course, you should be an experienced Excel user who is comfortable creating and working with Excel workbooks, including tasks such as entering worksheet formulas, using absolute and relative addressing, formatting cells, and creating pivot tables and charts. This level of skill could be acquired by taking the Microsoft Excel for Office 365? (Desktop or Online) courses, Parts 1, 2, and 3 1 - Using VBA to Solve Business Problems Topic A: Use Macros to Automate Tasks in Excel Topic B: Identify Components of Macro-Enabled Workbooks Topic C: Configure the Excel VBA Environment 2 - Automating Repetitive Tasks Topic A: Use the Macro Recorder to Create a VBA Macro Topic B: Record a Macro with Relative Addressing Topic C: Delete Macros and Modules Topic D: Identify Strategies for Using the Macro Recorder 3 - Getting Help on VBA Topic A: Use VBA Help Topic B: Use the Object Browser to Discover Objects You Can Use in VBA Topic C: Use the Immediate Window to Explore Object Properties and Methods 4 - Creating Custom Worksheet Functions Topic A: Create a Custom Function Topic B: Make Decisions in Code Topic C: Work with Variables Topic D: Perform Repetitive Tasks 5 - Improving Your VBA Code Topic A: Debug VBA Errors Topic B: Deal with Errors Topic C: Improve Macro Performance 6 - Controlling How and When Macros Run Topic A: Prompt the User for Information Topic B: Configure Macros to Run Automatically 7 - Developing Custom Forms Topic A: Display a Custom Dialog Box Topic B: Program Form Events 8 - Using VBA to Work with Files Topic A: Use VBA to Get File and Directory Structure Topic B: Use VBA to Read Text Files Topic C: Use VBA to Write Text Files 9 - Using VBA to Clean and Transform Data Topic A: Automate Power Query Topic B: Transform Data Using VBA and Workbook Functions Topic C: Use Regular Expressions Topic D: Manage Errors in Data 10 - Extending the Programming Environment Beyond the Workbook Topic A: Run Other Programs and Commands Topic B: Share Your VBA Projects

48-Hour Knowledge Knockdown! Prices Reduced Like Never Before. Diploma of Landscape Architecture (Online) - CPD Certified Did you know that demand for Landscape Architects in the UK has soared by 20% in the last five years? Propel your career forward with our online "Diploma of Landscaping" course, offering CPD-certified, comprehensive, 4-in-1 bundled learning. Immerse yourself in a journey from fundamentals to advanced concepts taught by experienced professionals. Our structured, easy-to-follow modules equip you with the right skills and knowledge to excel in this rapidly-growing field. Set your career in motion today and become a part of the thriving £1 billion UK landscaping industry. Explore new horizons, learn from experts, and craft your future with the Diploma of Landscaping (Online). Courses Are Included in this Diploma of Landscaping (Online) - CPD Certified Bundle: Course 01: Diploma in Landscape Architecture at QLS Level 4 Course 02: Advanced Diploma in Architectural Studies at QLS Level 7 Course 03: Land Management Course Course 04: Environment Management Course Learning Outcomes of Landscape Architecture Gain comprehensive knowledge of landscaping principles, techniques, and design principles, with a focus on sustainability and environmental considerations. Develop practical skills in landscape planning, site analysis, and project management, enabling you to execute professional landscaping projects. Understand the UK landscaping industry's current trends and market demands, backed by up-to-date statistics and insights. Acquire proficiency in using industry-standard software and tools for landscape design, enhancing your efficiency and productivity. Receive a CPD certification upon completion, boosting your credibility and increasing your chances of securing lucrative job opportunities in the growing UK landscaping sector. Data: According to the Landscape Institute, the landscaping industry in the UK generates approximately £1 billion in revenue annually. Furthermore, the demand for skilled landscape architects is projected to grow by 14% by 2027, as reported by the Office for National Statistics. Why Choose Our Landscape Architecture Course? FREE Landscape Architecture certificate accredited Get a free student ID card with Landscape Architecture Training Learn Landscape Architecture from anywhere in the world Landscaping is affordable and simple to understand This course is entirely online, interactive lesson with voiceover audio Lifetime access to the Landscape Architecture course materials Landscaping comes with 24/7 tutor support So enrol now in this Landscape Architecture Today to advance your career! Start your learning journey straightaway with Diploma of Landscape Architecture! This Landscape Architecture curriculum has been designed by Landscape Architectureexperts with years of experience behind them. This course is extremely dynamic and well-paced to help you understand Landscape Architecture with ease. You'll discover how to master the Landscaping skill while exploring relevant and essential topics. Assessment Process of Diploma of Landscape Architecture Once you have completed all the courses in the Landscape Architecture bundle, you can assess your skills and knowledge with an optional assignment. Our expert trainers will assess your assignment and give you feedback afterwards. CPD 180 CPD hours / points Accredited by CPD Quality Standards Who is this course for? Diploma of Landscape Architecture (Online) - CPD Certified This Diploma of Landscape Architecture bundle is suitable for everyone. Requirements Diploma of Landscape Architecture (Online) - CPD Certified You will not need any prior background or expertise to enrol in this Diploma of Landscaping . Career path Diploma of Landscape Architecture (Online) - CPD Certified This Diploma of Landscape Architecture bundle will allow you to kickstart or take your career in the related sector to the next stage. Certificates Digital certificate Digital certificate - Included Hard copy certificate Hard copy certificate - £29 If you are an international student, you will be required to pay an additional fee of 10 GBP for international delivery, and 4.99 GBP for delivery within the UK, for each certificate

Microsoft Excel® in Depth: In-House Training The goal of this course is to provide a deeper understanding of Excel and its intricacies and a new ability to use it efficiently producing the best solutions for your projects. This practical course provides a solid background of the features of Excel and a deeper understanding of its features, benefits and uses. This is not a beginner's course in Excel. You will learn some advanced features such as Pivot Tables, Charting, Tables, Sorting, Filtering and Functions. The goal of this course is to provide a deeper understanding of Excel and its intricacies and a new ability to use it efficiently producing the best solutions for your projects. What you Will Learn You'll learn how to: Use functions like IF, AVERAGE, SUMIF, SUMIFS, SUMPRODUCT, INDEX, MATCH, CHOOSE, DATE, and many more Create meaningful charts Use pivot tables Use Conditional Formatting, Data Validation Take advantage of using Named ranges, do sorting, filtering, tables Getting Started The building blocks of Excel, built-in functions, will be examined The basics of formatting your data will be examined Shortcuts and data manipulation will be explored Built-in features like those mentioned in the 'What you will learn' section above will be explored in detail Excel Functions - VLOOKUP, IF, INDEX, MATCH, CHOOSE, SUMIF, SUMIFS, SUMPRODUCT, DATE, so many more Using Named ranges, Data Validation, Sorting, and Filtering Learn the Name manager; Learn the difference between local and global names; Ensure correct access to linked workbooks; Ensure data accuracy; Learn how to use cascading data validation (for example, once a user chooses 'cars', another cell allows only Ford, Toyota, etc.); Sorting by more than 3 fields; Filtering by font, pattern, or value; See your data based on things like dates in the 3rd quarter, or fields where quantity x price is greater than some fixed value Conditional formatting and data formatting Make relevant data stand out Isolate highs and lows Make error cells invisible Learn about Data bars, Icon sets, and Color scales Highlight differences between worksheets Learn all the codes in the Format/Number list Using cell Styles Learn all about alignment, protection, borders, colors and more Pivot Tables Learn how to summarize large amounts of data with a few clicks Learn various ways of presenting the data Learn the various pivot table tools Learn how to customize and format a pivot table to suit your needs Learn how to group data Learn how to use the various options to present your data Charts Learn how to create a chart with one keystroke! Learn the 11 types of built-in charts Learn how to create a chart with one keystroke! Learn how to customize the charts to make the information tell the right story Learn how to use the design, layout, and formatting available to charts in Excel 2007 Learn embedded charts versus chart sheets Learn how to use modify all the pieces of a chart Array formulas Learn how to use the most powerful formulas in Excel Learn how to combine many formulas into one compact array-formula Learn the real power of these formulas and why regular formulas can't do the job Learn how to use built-in array formulas, like TREND or TRANSPOSE