37620 Courses

Supercharge your skills and career and learn in-demand knowledge needed to build business intelligence dashboards. This beginner to intermediate level course will introduce you to all the Power BI technologies i.e. Power Query, DAX, Data Modelling (Power Pivot), M, types of visualizations, etc.

Our students will receive theoretical knowledge and practical skills for 3 key facial areas using dermal fillers techniques for the face to ensure they understand the importance of facial harmony and balance. Our goal at the Cosmetic College is to deliver the highest quality training in dermal fillers using the safest and most up-to-date techniques. Our Essential dermal filler training courses are carried out in small groups. This enables us to provide you with a training programme tailored to your needs, with more time and emphasis on the hands-on practical sessions. Course Prerequisites This course is suitable for those with or without a medical background. It is designed to allow the student to seek employment or start their own business upon completion. At a minimum, students will be required to be qualified with one or more of the following: Medically trained as a nurse, doctor or dentist with current registration with the NMC, GMC or GDC. NVQ Level 3 in Beauty Therapy, ITEC or HND 12 months of needling experience 6 Months of micropigmentation experience and Anatomy & Physiology Level 3 Please note that if your qualification does not appear above, we offer a fast-track access course for those new to the industry.  Course Agenda A mixture of online study, virtual lectures and practical onsite sessions A series of online and onsite assessments 1 day online webinar followed by 2 days onsite training program Course Structure All courses are kept intimate with a maximum of 4 students per course Course Agenda Anatomy and physiology of the face Infection control Sharps and hazardous waste training First aid and anaphylaxis training Introduction to dermal filler injection techniques Elective and emergency dissolving Start Business up (How to set up a business, insurance, stockist, social media, managed, join our Instagram group) Injection techniques practice Danger zones training Vessels, muscles, fat pads workshop Professional live demonstrations Legal requirements, obtaining consent with consultation techniques and documentation Practical training Clinical setup procedures Areas Covered (Dermal Filler) Lips Nasolabial Folds (Smile lines) Marionette lines Professional Kit Dermal filler (For Training purposes) Numbing cream Massage gel Chlorhexidine pre-injection wipes Sterile treatment packs Gloves Surgical face masks Skin marker pencils Ice pack Consultation forms Course Benefits Student Benefits Comprehensive Knowledge: By enrolling in this training, students will gain in-depth knowledge about dermal fillers, including facial anatomy, product selection, injection techniques, and patient assessment. This knowledge will provide a solid foundation for performing dermal filler treatments effectively and safely. Practical Skills: The course includes hands-on training, allowing students to develop practical skills in administering dermal fillers. Through supervised practice on live models, students can refine their techniques and gain confidence in delivering natural-looking results. Professional Advancement: Acquiring expertise in dermal fillers can significantly enhance a student's career prospects in the aesthetics industry. Client Benefits Natural-Looking Results: Clients can expect natural-looking results from trained professionals who have a thorough understanding of facial anatomy and the skill to administer dermal fillers effectively. The training ensures that students are equipped to enhance facial features and address specific concerns with precision. Safety and Care: Clients can have confidence in the skills and knowledge of practitioners who have undergone comprehensive training. Trained professionals prioritise client safety, follow proper hygiene protocols, and provide appropriate aftercare instructions. Earning Potential Earning potential and salary in the field of dermal fillers can vary depending on several factors, including geographic location, experience, and the number of clients. As professionals gain experience and build their reputation, they may have the potential to earn a competitive income. It's important to note that individual earning potential may vary and is influenced by various factors in the aesthetics industry. Additionally, continuing education and expanding your skill set by taking advanced courses and staying updated with the latest techniques and trends can also contribute to your earning potential. This allows you to offer a wider range of services and attract more clients seeking specialised treatments. Frequently Asked Questions Is prior experience required to enrol in the course? No, this course is suitable for both beginners and experienced practitioners. It provides a comprehensive foundation in dermal fillers, covering essential knowledge and practical skills. Are live models provided for the practical training? Yes, live models will be provided for the practical training sessions. This allows you to practice your skills under the guidance and supervision of experienced instructors.

Based on our extensive work and experience with leaders, both in the private and public sectors, this ILM Level 5 Coaching and Mentoring programme has been designed to develop the capability of leaders to positively impact the performance of individuals and teams. We are experts at unlocking peak performance. Coaching and mentoring improves relationships, performance and engagement. This programme has been created to sharpen a leader's skills - enabling them to balance control, commitment and empowerment through productive conversations with individuals and teams. Scroll down to find out more about this ILM Level 5 qualification, or use the buttons below to jump straight to the scheduled course dates and prices. All of our ILM Programmes are provided in partnership with The BCF Group, which is the ILM Approved Centre we deliver under. Course Syllabus The syllabus of the ILM Level 5 Qualification in Business Coaching and Mentoring is comprised of six modules, covering the following: Module OneIntroduction 1.1) Explore the myths 1.2) What is coaching and mentoring? 1.3) What is business coaching? 1.4) Thoughts and perceptions 1.5) 7 competencies of a coach 1.6) Definitions - Mentoring / Consulting / Coaching / Therapy / Counseling Module TwoModels and Practice 2.1) The Wheel of Life 2.2) Johari's Window 2.3) KASH - Knowledge, Attitude, Skills, Habits of an effective coach 2.4) STAR / GROW model 2.5) Effective use of Paradigm cards 2.6) Practice and feedback Module ThreeBuilding the Relationship 3.1) Self-management 3.2) How motivation works 3.3) Personality & behavioural traits 3.4) Rapport and trust Module FourCommunication and Practice 4.1) Non-verbal communication 4.2) Effective communication 4.3) Questioning through 2nd/3rd/4th level questioning 4.4) Building a bank of coaching questions 4.5) Practice and feedback Module FiveStructure 5.1) Introduction 5.2) The coaching cycle 5.3) How to give feedback 5.4) The COMET model 5.5) Executive coaching 5.6) Psychometrics 5.7) Closing the coaching session Module SixWell-Formed Outcomes 6.1) Challenge and focus steps 6.2) Coaching goals 6.3) Establishing the gap analysis 6.4) Using diagnostic tools 6.5) SMART objectives 6.6) Designing & planning focus steps 6.7) Gaining commitment 6.8) Practice and feedback Who is it for? Business coaching is the skill to have in today's rapidly changing business climate. People and team development through business coaching is fast, efficient and cost effective, and will get you measurable results. The ILM Level 5 Qualifications in Business Coaching and Mentoring are highly accessible and have been designed for all tiers of director, management and supervisory level, or indeed anyone involved in people development. With a business-relevant, tried-and-tested approach, we encourage participants to bring live business issues and case histories with them on the course. Accreditation Upon completion of this programme all attendees will receive the 'ILM Endorsed Programme in Business Coaching & Mentoring' certificate. Participants will also be eligible to receive ILM letters after their name; either AMInstLM (Affiliate/Associate Member Institute Leadership & Management) or MInstLM (Member Institute Leadership & Management). As with all ILM Accredited Programmes, participants will need to complete the post-programme activity in order to achieve their full 'ILM Level 5 Certificate in Coaching and Mentoring in Management' certificate. These elements have been designed in order to show to the Institute of Leadership and Management (ILM) that you are able to put the skills and techniques learned on the programme into practice. Full support and guidance is provided for completing these final elements. Required Activities Pre-Course We ask you to come prepared with issues which you are currently experiencing that you would be happy to discuss and be coached on. We also send out a short document containing questions and exercises which will help our coaches understand you better and work with you in order to receive the best training. Post-Course To achieve this ILM qualification, participants will have to complete the following post-course activities: 3 x work-based assignments need to be completed within 1 year from attendance and registration. Embedded in the assignments, the Certificate will require delegates to complete 18 hours of coaching or mentoring activity with 2-3 people. The Diploma will require delegates to complete 54 hours of coaching or mentoring with 4-9 people. Tutor guided learning will take on the format of book and video reviews with ongoing tutor guidance and support via phone, Skype or face-to-face. Optional: Self-initiated 2 x 45 min executive coaching sessions per delegate to offer a coaching best practice view. Course Material Each participant will be issued with a workbook to assist them both during and after the course, which will contain information, guidance and forms to assist with the coaching sessions. Participants will also complete a Paradigm psychometric report and receive a year's membership with the Institute of Leadership & Management (ILM). In-House & Classroom Courses Available Online We have developed an alternative to traditional face-to-face training that continues to provide a full learning experience, and allows delegates to learn effectively whilst self-isolating from home. This is how it looks: Delegates booked on Classroom and In-House courses will continue to have access to their trainer online throughout the days that the course is booked to run. Prior to a delegate's course start date, they will be enrolled on our e-learning platform (in partnership with BCF Group) for the course they are booked on to. They will also be given contact information for their trainer, and details of how to access the online workshops. Delegates will not require any special IT equipment. A desktop computer, laptop, tablet, or a mobile phone with internet and audio capability is all that is required. Delegates taking ILM Qualifications will then proceed to the book review, video review and work based assignments with 12 months tutor support as appropriate, and in line with our previous arrangements. We hope you agree that this blended learning experience represents the safest way to continue supporting our clients and delegates during the Coronavirus disruption. Scheduled Courses Classroom Course - Nottingham (NG12 4DG) Classroom training courses enable you to benefit from having the tutor and other delegates right there in the room with you. Face-to-face training sessions are one of the best ways to learn, as it is easy to ask questions and have group discussions. In addition to the 2 days in the classroom, delegates will need to undertake self-directed learning and 3 work-based assignments. As a guide, this is estimated to take 3 hours per week for 12 months. Diploma: £2,195 + vat | Certificate: £1,895 + vat 03-04 October 2023 22-23 February 2024 Classroom Course - Reading (RG41 5QS) Classroom training courses enable you to benefit from having the tutor and other delegates right there in the room with you. Face-to-face training sessions are one of the best ways to learn, as it is easy to ask questions and have group discussions. In addition to the 2 days in the classroom, delegates will need to undertake self-directed learning and 3 work-based assignments. As a guide, this is estimated to take 3 hours per week for 12 months. Diploma: £2,195 + vat | Certificate: £1,895 + vat 14-15 September 2023 14-15 December 2023 14-15 March 2024 Zoom™ Course Attending a course via Zoom videoconferencing gives you all of the benefits of classroom training without the need to leave your home or office. You still benefit from a real tutor facilitating the programme, and the content is exactly the same. The only difference is that we split the course into four half-day sessions to make it easier on your eyes! Diploma: £1,795 + vat | Certificate: £1,495 + vat September 2023 - 25th Sep (morning), 25th Sep (afternoon), 26th Sep (morning), 26th Sep (afternoon) November 2023 - 6th Nov (morning), 6th Nov (afternoon), 7th Nov (morning), 7th Nov (afternoon) January 2024 - 11th Jan (morning), 11th Jan (afternoon), 12th Jan (morning), 12th Jan (afternoon) March 2024 - 11th Mar (morning), 11th Mar (afternoon), 12th Mar (morning), 12th Mar (afternoon) May 2024 - 14th May (morning), 14th May (afternoon), 15th May (morning), 15th May (afternoon) July 2024 - 9th Jul (morning), 9th Jul (afternoon), 10th Jul (morning), 10th Jul (afternoon Dickson Training Ltd Founded in 1985 in Yorkshire, we have built an impressive and loyal client base. Our partnerships are built by consistently delivering outstanding development solutions and working in close collaboration with our clients, resulting in us becoming a leading UK and international training provider.

Course Description Training will cover detailed anatomy and physiology of the lymphatic and associated vascular system, pathology of lymphoedema and chronic oedema and the different stages and types of lymphoedema. Please note: Your training will be delivered through a blended learning format. With our blended learning format, you will have the opportunity to complete the theoretical components of your training at your own pace. In addition to the online learning, we offer clinical skills training on scheduled workshop dates. This hands-on training will allow you to put your theoretical knowledge into practice and develop the necessary skills to excel in your field. Our experienced instructors will guide you through each step of the training, ensuring that you are fully prepared and confident in your abilities. Once you have completed your clinical skills training, you will receive your certification, validating your skills and knowledge. Please note price includes VAT Our Comprehensive Lymphoedema Training Course  Course Summary Join us on our blended learning training programme especially designed for certified healthcare professionals working within clinical settings.   By the end of the course, you will have a thorough understanding of the anatomy and physiology of the lymphatic system, enabling you to holistically assess and diagnose a patient with lymphoedema. You will be able to design and implement an appropriate research and evidence based individualised management strategy selecting from a range of therapies and new innovations. You will be competent in the field of Decongestive Lymphatic Therapy including Multi Component Bandaging (MCB) and the latest knowledge and research in Fluoroscopy Guided - Manual Lymphatic Drainage (FG-MLD®) Entry Requirements This training is suitable for: All certified healthcare professionals. Such as Medics, Registered General Nurses, Physiotherapists, Radiographers, Occupational therapists, Osteopaths and Chiropractors Learning Format Your course is made up of a blended learning format meaning your content and modules will be taught via live interactive webinars, through self-guided independent study and face to face clinical skills workshops. So, whether you're learning style is social, solitary, visual, kinesthetic, auditory or a combination we have a learning style to help you get the best out of the course. We hope that you make the most out of the tools that are available to you throughout the course but don't worry if you are not the most "tech-savvy", we have real people on hand to help you every step of the way. Assessment Criteria All students will undergo a series of course specific formative & summative assessments. Throughout the course you will be assessed through observation of practical tasks, written assessments, assignments, research and online tests. Course Contents You will gain knowledge, skills and techniques in: Compression Exercise Skincare & Wound Healing Garments Multi-Component Bandaging Assessment & Treatment of Oedema Anatomy & Pathways of the Upper & Lower Limb FG-MLD® Technique Tissue Dielectric Constant Head & Neck, Midline & Genital Oedema.   Training will also cover innovations and consideration for clinical practice. Course Inclusions As part of your training pack, LTA will provide all training support materials required to undertake the course.   Such as but not limited to: Corporate Sponsored Bandaging Pack LymphBalls™ Latest LTA Research & Development articles Lymphoedema supporting literature Access to in-house LTA training & demonstration videos Learning management platform (CANVAS) profile & course content Snacks & Refreshments throughout your practical skills workshops Dedicated support from the LTA training team Course Certification The benefits of an LTA certification means you can; Display FG-MLD® Certified and LTA Cert. logo on your marketing material Write LTA Cert. after your name Wear your qualification badge Practice MLD to further enhance outcomes Use an innovative technique and ensure effective treatment programmes Receive training and support from Jane Wigg & Team Access the latest developments in Lymphoedema care Have access to a private FG-MLD® Therapist FB Page Recertification To maintain your LTA Therapist Certification, a 2-day recertification is required after 12 months after your initial training, and you will be required to attend a 1-day recertification every 2 years thereafter to maintain your certification of practice.

Join us for an insightful masterclass that delves into the profound effects of neglect on a child's life. This session is meticulously designed for professionals working closely with children in various educational settings, providing essential knowledge and practical tools to identify, manage, and seek support for neglected children.

This course teaches people how to help someone who may be experiencing a mental health issue.

This is course will give you EVERYTHING you need to become a VTCT Level 2 Qualified Skin Specialist. Why do you need THIS course? Previously the beauty industry had very lax regulation and you could start your business with just CPD accreditation. However, insurance companies are now looking for qualifications like VTCT as these are a set standard that require assignments and exams at a very minimum of Level 2. This means a combination of both VTCT and CPD means your business will meet industry standards What is the difference between CPD and VTCT? Qualifications are listed on the Regulated Qualifications Framework (RQF), which is the national framework of UK qualifications, and the certificate of achievement is issued by an Awarding Organisation. Your certificate means you are ‘qualified’ in that subject CPD is a piece of training developed by an individual or organisation that sits outside the regulated qualifications framework. It confers a skill not a qualification. Treatments such as dermaplaning can only be completed as a CPD therefore a combination of both VTCT and CPD will increase your revenue. If you prefer one treatment at a time then we offer this too. You can find all our courses here Please confirm dates and availability with us prior to purchasing Who Is This Course Suitable For? This course is perfect for those who are beginners with no experience. However, the course can be tailored for those who have partial qualifications/ accreditation and would like to become a qualified Level 2 practitioner. Course Content You will cover; VTCT Level 2 Facial Massage & Skin Care Provide facial skincare Steam Extractions Skin Types and Conditions Face Massage Client care and communication in beauty-related industries Follow health and safety practice in the salon Advanced Skin Care Diploma Microdermabrasion LED Light Therapy (full course content can be found here) Dermaplaning (full course content can be found here) Chemical Peels. (full course content can be found here) Microneedling Nano Needling (full course content can be found here) A full start up equipment kit will be available to purchase on training. Details will be provided upon booking. Course Duration & Cost You will be registered onto online portal with easy access for viewing of tutorials reducing time in the centre. You will be required to do home study of treatment theory as well as assignments before you attend the practical training. This will allow more time to work on models and get hands on experience. The Qualified Level 2 Skin Specialist course is a combination of the Advanced Skin Care Diploma and VTCT Level 2 Facial Massage & Skin Care and you will be required to be in the centre for 3 intensive practical days £1999 Why Choose Us? This course will allow you to offer the most on trend and in demand treatments that are results driven. The key to a successful business is to offer services that clients will want to keep coming back for. All of the treatments within this diploma have proven results which will support you in customer retention. We do not offer online courses for treatments that require the skill that can only be performed in front an experienced trainer. We ensure we offer a practical course that allows you to work on 2 models per treatment. We want you to be confident in the skill so you can start your business straight away. We are not an Academy and we take pride in this. This means we offer more than just training you in a skill. We understand how difficult and overwhelming it can be to start a new business and our ethos is to provide guidance and support to get you started. All our sessions have an option of 1-2-1 sessions for a personalised experience and have a maximum of 4 students per session. Your journey with us doesn’t end in the practical training session. When you train with Elixir Skin Training you become a part of our brand. We stay in touch with all our graduates and provide that motivation to get you going, which you will not find in large Academies. Quality of training is important but so is what comes after- we support you in every aspect because we want to see you build your business. Categories: Advanced Skin Care Courses, Combined Courses, ofqual

Organisational retreat, organisational seminar, executive development,

Our students will receive theoretical knowledge and practical skills for six key facial areas using dermal fillers and anti-wrinkle techniques for the face to ensure they understand the importance of facial harmony and balance. Our goal at the Cosmetic College is to deliver the highest quality training in dermal fillers using the safest and most up-to-date techniques. Our Essential dermal filler training courses are carried out in small groups. This enables us to provide you with a training programme tailored to your needs, with more time and emphasis on the hands-on practical sessions. Course Prerequisites This course is suitable for those with or without a medical background. It is designed to allow the student to seek employment or start their own business upon completion. At a minimum, students will be required to be qualified with one or more of the following: Medically trained as a nurse, doctor or dentist with current registration with the NMC, GMC or GDC. NVQ Level 3 in Beauty Therapy, ITEC or HND 12 months of needling experience 6 Months of micropigmentation experience and Anatomy & Physiology Level 3 Please note that if your qualification does not appear above, we offer a fast-track access course for those new to the industry.  Course Agenda A mixture of online study, virtual lectures and practical onsite sessions A series of online and onsite assessments 3 days training program Course Structure This course is held over five days of intensive theory and practical sessions. All courses are kept intimate with a maximum of 4 students per course. Course Agenda Anatomy and physiology of the face Infection control Sharps and hazardous waste training First aid and anaphylaxis training Introduction to dermal filler injection techniques Elective and emergency dissolving Start Business up (How to set up a business, insurance, stockist, social media, managed, join our Instagram group) Injection techniques practice Danger zones training Vessels, muscles, fat pads workshop Professional live demonstrations Legal requirements, obtaining consent with consultation techniques and documentation Practical training Clinical setup procedures Areas Covered (Dermal Filler) Lips Nasolabial Folds (Smile lines) Marionette lines Areas Covered ( Anti-Wrinkle) Glabella lines Cross feet Frown Lines Professional Kit Dermal filler (For Training purposes) Numbing cream Massage gel Chlorhexidine pre-injection wipes Sterile treatment packs Gloves Surgical face masks Skin marker pencils Ice pack Consultation forms Course Benefits Student Benefits Comprehensive Training: By enrolling in this package, you will receive comprehensive training in two highly sought-after aesthetic treatments. You will gain in-depth knowledge about dermal fillers and anti-wrinkle injections, including the underlying anatomy, injection techniques, safety considerations, and client assessment. This comprehensive training will make you a confident and skilled practitioner in these treatments. Hands-on Experience: Our training package emphasises hands-on experience to ensure that you develop the practical skills necessary to perform dermal filler and anti-wrinkle injection treatments. Under the guidance of experienced instructors, you will have the opportunity to practice these techniques on models, allowing you to refine your skills and build confidence in delivering safe and effective treatments. Diversify Your Skill Set: By enrolling in this package, you will expand your skill set and offer a wider range of services to your clients. Dermal fillers and anti-wrinkle injections are versatile treatments that can address multiple aesthetic concerns, including volume loss, wrinkles, and fine lines. By mastering these techniques, you can cater to a broader client base and meet their individual needs. Enhanced Professional Credentials: Completing the Dermal Fillers and Anti-Wrinkle Training Package will enhance your professional credentials in the aesthetics industry. You will receive certifications for both dermal fillers and anti-wrinkle injections, which will validate your expertise and demonstrate your commitment to providing high-quality treatments. This can elevate your professional reputation and help you attract new clients. Client Benefits Comprehensive Treatment Options: Clients seeking facial rejuvenation and anti-aging solutions will benefit from your ability to offer both dermal fillers and anti-wrinkle injections. These treatments can address a wide range of concerns, including volume loss, deep wrinkles, and fine lines. By providing comprehensive treatment options, you can tailor your services to meet each client's unique needs and goals. Natural-Looking Results: With your comprehensive training, you will be able to deliver natural-looking results to your clients. Dermal fillers can restore lost volume, enhance facial features, and create a more youthful appearance. Anti-wrinkle injections can relax facial muscles and smooth out wrinkles, resulting in a more refreshed and rejuvenated appearance. Clients will appreciate your ability to achieve subtle and harmonious enhancements. Professional and Safe Treatments: Clients will have peace of mind knowing that you have received professional training in dermal fillers and anti-wrinkle injections. Your knowledge of the underlying anatomy, injection techniques, and safety considerations will ensure that treatments are performed with precision and care. Clients can trust that they are in safe hands and will receive high-quality treatments. Earning Potential Expanded Client Base: By offering both dermal fillers and anti-wrinkle injections, you can attract a wider range of clients seeking various aesthetic treatments. This can lead to an increase in client bookings and revenue potential. Client Retention and Referrals: Satisfied clients who receive effective and natural-looking results are more likely to become repeat customers. They may also refer their friends, family, and acquaintances to experience your services. Client retention and referrals can significantly contribute to your earning potential. Stay Competitive in the Industry: The demand for dermal fillers and anti-wrinkle treatments continues to grow as more individuals seek non-surgical options for facial rejuvenation. By mastering these techniques, you position yourself as a skilled practitioner in a competitive market. This can help you attract new clients and stay ahead of the competition

Microsoft Excel® in Depth 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