942 Basic courses in London

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

Give staff the basic skills to understand how and what to train, and to use learner-centred techniques to boost the effectiveness and impact of their training courses.

The aim of the CCNSG Safety Passport is to ensure a basic knowledge of health and safety for all site personnel to enable them, after appropriate site induction, to work on site more safely with lower risk to themselves and others. Book via our website @ ESS | Training Courses | Vp ESS (vp-ess.com) or via email at: esstrainingsales@vpplc.com or phone on: 0800 000 346 or via email at: esstrainingsales@vpplc.com or phone on: 0800 000 346

Peering demystified training course description A concise overview course covering The Internet and peering. Particular emphasis is placed on the structure of the Internet, how IXs benefit the Internet, IX architectures, peering and the technical buzzwords behind the IX services. What will you learn Describe the structure of the Internet Explain the role of RIPE, ARIN and IXs in the Internet Explain how IXs connect ISPs and the benefits of using IXs. Describe peering from a technical perspective including the role of BGP and AS's. Peering demystified training course details Who will benefit: Non technical staff working for Internet companies. Prerequisites: None. Duration 1 day Peering demystified training course contents IP and routers IP as glue. What is a router? How routers join networks, benefits and disadvantages of routers, default gateways, routing tables, routing protocols. Addressing IP address format, rules of IP addressing, where to get IP addresses. Subnetting and groups of IP addresses. The Internet What is the Internet? The big picture, IP basics, registering IP addresses, DNS and registering domain names, whois, The IAB, IANA, ICANN, RIPE and other Internet organisations. ISPs Top ISPs, Tier 1, Tier 2 and Tier 3 ISPs, backbone providers, circuit providers, content providers, virtual ISPs, the internal network of ISPs. Customer connections to ISPs (DSL, Leased lines, MPLS…) ISP to ISP connections: Peering points Public peering versus private peering, NAPs, Internet Exchanges, Metropolitan Area Exchanges, LINX, other major peering points, the geography of the Internet. BGP and ASNs. How to peer. IRRs. IX architecture Ethernet switching.

Our Stoma Care Training course allows learners to gain theoretical and practical stoma care knowledge.

This course is ideal to give all members of staff basic fire training to increase awareness and cooperation in the event of a fire in the workplace.

This course explores ‘What is diabetes’ and the basic anatomy and physiology of what happens to cause diabetes, management, short & long term complications, and caring for someone with diabetes.

Basics Java Course. Basic Java syntax and principles of Object Orientated Programming. Java Programming Fundamentals webinar Courses London, evenings, 6 weeks. Virtual Classroom. Our Style: Hands-on, Practical Course, Instructor-led Course. Level: From basics to fully functional. Who would benefit from the course: basics to Java, attend after work. Duration: one lesson of 2 hours per week for 6 weeks, from 6pm - 8pm. The first date shows as the booking date.

Hello there, tiny tumblers and little leapers! Welcome to our delightful Acro Beginners Dance Class, meticulously designed for our budding acrobats aged between 5 and 9. Are you ready to jump into an exciting world of flips, spins, and maybe a cartwheel or two? If your answer is a resounding "Yes!", then you're in the right place. Acro dance is a unique style that combines the grace of dance with the thrill of acrobatics. Our Acro Beginners class is the perfect introduction to this fascinating dance form. From the moment your little one steps onto our specially designed acro mats, they'll be set for an exhilarating journey of discovery! Our class starts with basic acrobatic tricks that are as fun to learn as they are to perform. We'll be somersaulting, cartwheeling, and even handstanding our way into the world of acro dance. Our friendly and experienced instructors will ensure that each child learns at their own pace in a safe and supportive environment. But we'll be doing more than just acrobatics. We're also working on enhancing flexibility, balance, and stretching. Through a variety of engaging activities and exercises, your child will develop these skills, becoming not just a better acro dancer, but also a more confident mover! Yet, our Acro Beginners class is not just about learning acro dance. We believe that dance is an invaluable tool for teaching life skills. Through acro dance, your child will improve their self-esteem, learn to work as part of a team, and even develop resilience. Each cartwheel, leap, and roll is a lesson in determination and self-belief! And let's not forget the wonderful friends your child will make in our class. Acro dance is about collaboration and trust, and our class is a community of little acrobats supporting and cheering for each other. Your child will make friendships that go beyond the dance floor, creating beautiful memories along the way. So, lace up your dancing shoes, little acrobats! It's time to tumble, flip, and leap into the captivating world of acro dance. We can't wait to welcome you to our Acro Beginners Dance Class and start this exciting journey together. Remember, acro dance is about having fun, expressing yourself, and working together. So, let's embark on our acro adventure, where every flip and roll is a step towards joy and self-confidence! See you on the dance mat!

Java Evenings Course. Basic Java syntax and principles of object-oriented programming. Our Style: Hands-on, Practical Course, Instructor-led Course. Level: From basics to fully functional. Who would benefit from the course: basics to Java, attend after work. Duration: one lesson of 2 hours per week for 6 weeks, from 6pm to 8pm.