11101 Courses

Microsoft Excel® in Depth (In-Person) 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

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

Networks demystified training course description A concise overview course covering all aspects of networking with particular emphasis of use of the 7 layer model as a framework for discussing and learning new network terms enabling delegates to recognise the main buzzwords used in the industry. What will you learn Use the 7 layer model to classify networking terms. Differentiate between LANS and WANS. Recognise bandwidth measurements. List LAN and WAN technologies. Recognise cabling issues in a network. Networks demystified training course details Who will benefit: Sales staff, managers and other non-technical personnel. Technical personnel may benefit more from our Intro to data communications and networking course. Prerequisites: None. Duration 1 day Networks demystified training course contents What are networks? What is a network? Types of network, Local Area Networks (LANs), Wide Area Networks (WANs), connecting networks together with routers. The 7 layer model What is the 7 layer model? The importance of standards, using the 7 layer model to classify networking terms. Cables Copper, Fibre, Air, standards, connectors, LAN cables, WAN cables, distance limitations, hubs and repeaters, other issues. The radio spectrum. Bandwidth Bits and bytes. Bandwidth measurements, common technologies and their bandwidth, the impact of applications on bandwidth. Full and half duplex. Joining cables together to increase bandwidth (Link aggregation). LANs and WANs What is Ethernet? What is WiFi? What are Leased lines? What is MPLS? Ethernet switches Ethernet 'packets', MAC addresses, what is a switch, what is the difference between a hub and a switch. TCP/IP What is TCP/IP? What is a protocol? What is IP? What is TCP? The role of routers in joining LANS and WANS, What is the Internet? Applications Ways to use the network, clients, servers, web browsing and HTTP, Email, instant messaging, multimedia applications.

"Elevate your skills, one-on-one" Say goodbye to crowded classes and generic curriculums. Say hello to personalised mentorship and hands-on training that helps you reach your full potential. At Peaches Training Academy your learning style will be catered for and you’ll not fade into the background of a class full of other people. You’ll experience true, quality training in a 1-1 setting. What’s more? You can choose for it to be in our academy or in the comfort of your own salon or beauty room. When you book Peaches for your next beauty course, you’ll experience: 🍑 1-1 training 🍑 On-site in the comfort of your own salon or beauty room 🍑 All courses are accredited (therefore are true qualifications) 🍑 Free lifetime student support in WhatsApp 🍑 No kit required for your training, we provide everything for the day Imagine being the centre of attention, all day long and learning in the best possible way for you. That’s the reality at Peaches. Enroll now and kickstart your beauty career

Electric Vehicle Technicians have had access to certified training at different levels of competency for a number of years, but this has not been the case for Vehicle Dismantling Technicians until now. Vehicle repairers have been taught how to diagnose faults on Electric or Hybrid vehicles, make them safe, repair or replace the high voltage component and then put the vehicle back together and make them work. Vehicle dismantlers need to know how to assess Electric and Hybrid vehicles, store them properly, make them safe and dismantle them, store the parts and ship them out for re-use, repurposing or recycling, so the accredited and certified training for vehicle repair technicians met some of the criteria for dismantling but not all. Electric Vehicle Dismantling Training raises the professional standards of the vehicle dismantling and recycling industry, provides consistent training standards across the world, helps develop knowledge and understanding, enables team members to grow their own abilities, and achieve accredited training.

ISO 9001 INTERNAL AUDITOR COURSE 2 DAY CLASS BASED COURSE

The European Society of Aesthetic Gynecology | ESAG is delighted to present a unique Masterclass on BHRT and PRP application in Regenerative & Functional Gynecology with a fully rejuvenated scientific program that will take place at Bader Medical Institute of London which is conveniently located on the well known Medical district of London in Marylebone, Central London. The Masterclass will start at 11:00 and end approximately at 18:15 and will focus on Bioidentical Hormonal Replacement Therapy (BHRT) and Platelets Rich Plasma (PRP) applications in Regenerative and Functional Gynecology. Scientific Faculty:  Maria Papadopoulou, MD, ABAARM Ob&Gyn Consultant (London) Board Certified American Academy of Anti-Ageing Medicine - A4M Vice-President of the European Society of Aesthetic Gynecology –ESAG Founder and Co-director of the Bader Medical Institute of London Prabhu Mishra, PhD MS in Molecular Medicine & Stem Cell Technology Doctoral degree, in addition to certificate courses in the field of Stem Cell Technology, Nanomedicine, and Translational medicine Covered Topics: Understanding the Female hormones Cortisol and its significant role in the balancing of Female hormones Where to test and how Treatment protocols Regenerative Medicine Procedures, Protocols and discussionsStem cells, Amniotic membranesPlacental extracts, Fat graftingNano Fat, SVF Functional Medicine Nutraceutical IV therapies, BHRT, Anti-Oxidants & supplementations Holistic Anti-Ageing therapies Platelet Rich Plasma Therapies in Gynaecology (Live demonstrations); Indications Covered:Thin Endometrium, Asherman Syndrome, Premature ovarian Failure, Oligospermia, Female Sexual DysfunctionsVaginal Laxity & Atrophy, Stress urinary Incontinence & Pelvic Floor diseasesInterstitial Cystitis And Vulvo-Vaginal Rejuvenation Limited exclusive seats available. An limited number of attendees will be able to participate and will benefit by being able to identify their patients’ needs and feel competent to manage and effectively treat them.

Electricians, take your first step towards becoming an MCS accredited PV installer in just three days!

Calling all plumbers and heating engineers! Take your first step towards becoming an MCS accredited Heat Pump Engineer in just three days!

Solar Thermal Hot Water Systems (BPEC NOS for MCS)