Enhance your skills and learn how to use a range of advanced formulas and functions to manage and extract data more efficiently. There are some great ones here that will save a lot of time. Course overview Duration: 1 day (6.5 hours) Our Excel Module 4 – Advanced Formulas and Functions course looks at some of the more advanced functions of Excel that can be used to manipulate and extract data. This is an intensive one-day course and designed for experienced users of Excel. Participants should be confident in creating and using Excel and be able to build simple formula before attending. Objectives By the end of the course you will be able to: Use a range of Text functions to manage text data Create and use different types of date and time functions Work with rounding functions Use logical statements Build nested formula Use SUMIF, COUNTIF and AVERAGEIF Cross reference data from other worksheets using LOOKUP, INDEX and MATCH functions Use IS functions and IFERROR to test cell values Content Working with text Splitting text into multiple cells Merging data into one cell Extracting data using text functions Tidying data Working with dates and times Formatting dates and times Date and time functions Calculating date and time differences Using functions to round numbers up and down ROUND ROUNDUP ROUNDDOWN CEILING FLOOR Use lookup functions Lookup functions Creating a lookup table Range naming Using VLOOKUP Using HLOOKUP Using INDEX and MATCH Working with logical statements Creating an IF statement Using the AND plus OR functions Nesting functions Calculating values based on given criteria SUMIF(S) COUNTIF(S) AVERAGEIF(S) Using IS and IFERROR and test cell values ISBLANK ISNUMBER ISTEXT ISERROR IFERROR
Learn the ‘Essentials’ of gift wrapping in just 90 minutes (with your friends!) What’s included (and how it will help): Step by step tuition covering all the Essential Techniques of gift wrapping so you never need to grab a gift/bottle bag again Practical guidance on tying different styles of Ribbon Bow so you can confidently use them on any gift (and when it’s best to use each one) Learn Pro tips so you feel less overwhelmed & can gift wrap quickly at busy times With many years experience teaching classes, both one to one and in groups, you will complete the class feeling confident that your gift wrapping will never be an embarrassment to you again. 90 Minute Group Class No Replay £97 How to measure exactly how much gift wrapping paper you need so you always know how much to cut (and why this is important) Wrap a box using the paper & only 3 pieces of tape so you can do this quickly & easily Learn to tie 2 differnt styles of bow (and when to use them) How to pleat gift wrapping paper so you can add extra detail to a gift How to wrap a bottle so you never need to grab a bottle bag again 90 Minute Group Class Includes replay ££117 How to measure exactly how much gift wrapping paper you need so you always know how much to cut (and why this is important) Wrap a box using the paper & only 3 pieces of tape so you can do this quickly & easily Learn to tie 2 differnt styles of bow (and when to use them) How to pleat gift wrapping paper so you can add extra detail to a gift How to wrap a bottle so you never need to grab a bottle bag again Plus a replay of the class FREQUENTLY ASKED QUESTIONS 1. What's included in a 90 minute virtual class? Step by step tuition covering all the Essential Techniques of gift wrapping so you never need to grab a gift/bottle bag again Practical guidance on tying different styles of Ribbon Bow so you can confidently use them on any gift (and when it’s best to use each one) Learn Pro tips so you feel less overwhelmed & can gift wrap quickly at busy times 2. How much is a 90 minute virtual gift wrapping class?There are 2 options to choose from starting from £97 per person3. How long does a virtual gift wrapping class last?A group virtual gift wrapping class lasts 90 minutes but I recommend allowing 2 hours in case there are any tech issue (unlikely but better to be prepared).4. Are materials provided?No, materials are not provided. I will send you a list of what you need at least 2 weeks ahead of the class (or once your booking is confirmed if less than 2 weeks until the class)5. What is the difference between an in person & a virtual workshop?At a 90 minute virtual class you will get tuition on essential gift wrapping techniques, practical guidance on tying different styles of bow & learn pro tips. An in-person class ususally last a full day, includes lunch/refreshments and all materials which are not included with any virtual classes. 6. What if I can't attend the class - do I get a refund?If you can bo longer attend the date of the class you have chosen, you may move your booking to another date, once, at no extra charge. I do limit the number of people at a group virtual class so if your chosen date to move to is full, you may need to wait until another class becomes available. If no class is available then you will be eligible for a refund. 7. Who is a virtual class suitable for?The classes are suitable for any skill level from beginner to anyone that has already tried the basics and wants to learn more. A group class is ideal if want to attend with a group of friends but you struggle to attend an in person class that fits in with your schedule/commitments. 8. Who is a virtual class not suitable for? There are no exclusions to suitability 9. What results can I expect if I attend a virtual class?That all depends on you and if you’re prepared to go away and practice/use the skills you have learned in the class. 10. Is there a replay? You do have the option to buy a class that includes a recording. If you decide after the class that you’d like to purchase a recording, email me louise@louiselewis.co.uk
Enhance your knowledge in coal power plant life cycle management and flexible operations with EnergyEdge. Learn about decommissioning, preservation, repurposing, and recommissioning.
Why Learn Autodesk Maya Basics to Advanced Level Course? Course info. Autodesk Maya is one of the best tools for 3D animation and visual effects. Learn Maya with our training courses covering sectors like Architecture, Games & Films, Animation, and Media. London Design Training Courses empower you to master Maya, transforming your 3d skills.  Duration: 40 hrs Method: 1-on-1. Schedule: Tailor your own schedule by pre-booking a convenient hour of your choice, available from Mon to Sat 9 am and 7 pm. Experience advanced-level Maya training covering essential aspects such as modeling, UV mapping, texturing, lighting, camera movement, and rigging. The course is tailored to your specific requirements and work preferences. You can discuss your learning goals with our trainer, and we will suggest a syllabus that meets your needs. Flexible Training Options: Choose in-class training at one of our UK center or attend live online sessions. Certified Tutors and Authoritative: London Design Training Course has all Autodesk Authorized Trainers. Hands-on Learning Approach: The training is practical and hands-on, combining theory and step-by-step demonstrations. You'll have ample time to practice techniques on your computer with Maya, and you can keep all the files you create. Compatible with Windows and Mac: Maya training is available for both Windows and Mac users, with options to suit any recent version of Maya. Maya Basic to Advanced Course Duration: 40 hours Course Description: In this course, you will learn the fundamental and advanced skills to create complex 3D models and animations using Autodesk Maya software. You will gain knowledge of the Maya interface, tools, and workflow. You will learn the essentials of modeling, texturing, rigging, animating, and rendering 3D models. You will also learn how to create advanced special effects and understand advanced modeling techniques. I. Introduction to Maya (3 hours) Overview of Maya and its Uses Maya interface and basic tools Navigation and viewport controls Creating and saving projects II. Basic Polygon Modeling (6 hours) Polygon modeling basics Creating basic shapes and objects Editing and modifying objects Creating complex objects with extrusions and bevels Creating organic shapes with NURBS III. Intermediate Modeling (6 hours) Advanced polygon modeling techniques Creating complex models with Booleans and deformers Creating and modifying curves and surfaces Creating organic shapes with sculpting tools Creating architectural models IV. Texturing and Materials (6 hours) Introduction to texturing Creating and applying materials Texture mapping and UV unwrapping Creating realistic materials with shaders Painting textures with the 3D paint tool V. Lighting and Rendering (6 hours) Basic lighting techniques Advanced lighting techniques Creating realistic lighting environments Setting up a camera and creating a composition Rendering still images and animations Output options and file formats VI. Animation (9 hours) Introduction to animation Keyframe animation and animation curves Creating and editing animation clips Rigging and animating a simple character Creating and editing motion paths and animation layers Creating complex character rigs Creating lip sync and facial animation Creating realistic animation with dynamics and simulations Cloth Animation Ncloth VII. Rigging (4 hours) Introduction to rigging Creating joints and skeletons Binding skin to joints and creating weight maps Creating simple rigging systems and rigging a character Creating complex rigging systems VIII. Special Effects (4 hours) Particle systems and dynamics Creating and manipulating fluids and fire effects Creating and editing special effects like explosions and smoke Creating advanced simulations with nCloth and nParticles Paint effects Mash Networks and Mash Animation IX. Advanced Rendering Techniques (2 hours) Render layers and passes Global illumination and ambient occlusion Mental Ray rendering and settings X. Conclusion and Next Steps (1 hour) Review of course content Tips for further learning and resources Q&A; and feedback Note: The above course outline is just a suggestion, and the course content and duration can be adjusted according to the needs and level of the learners. Proficiency in Advanced Maya Techniques: Participants will gain advanced skills in various aspects of Maya, including modeling, UV mapping, texturing, lighting, camera movement, and rigging. Tailored Training: The course is customized to meet the specific requirements of participants, focusing on their preferred techniques and work type. Hands-On and Practical Experience: The training is practical and hands-on, allowing participants to practice techniques on their own computers with Maya. Versatility in Operating Systems: Participants will be equipped to use Maya on both Windows and Mac systems. Accredited Certification: Upon successful completion, participants will receive an e-certificate, accredited by Autodesk Certified instructor, confirming their achievement in the Maya training course. Post-Course Support: After the training, participants are entitled to 30 days of email support from their Maya trainer, ensuring assistance with any post-course questions or issues. Up-to-Date and Relevant Learning: The training can be based on any recent version of Maya, providing participants with up-to-date knowledge and skills.
Learn how to control how your team works - and sells Includes Creating Your Sales Process, Automating the Process, Six Top Sales Techniques, Creating Sales Battle Cards
Learn how to build a solid foundation for success in Sales Management Includes Moving Up, 7 Best Practices, Sales Team Management Tips & Techniques, How to Fix Common Sales Team Problems
Guaranteeing Adequate Staff Levels Certification Figuring out how to guarantee satisfactory staff levels is essential information for anyone from any industry hoping to build profitability and make the most out of the main resource for any organization - the staff. This course gives a far reaching manual for guaranteeing satisfactory staff levels, through both deciding the labor force prerequisites just as upgrading the enlistment and choice interaction. From how to examine the current responsibility and existing staffing, to the study of ideal staff enrollment, determination and situation, this course covers all you require to know to guarantee sufficient staff levels and increment profitability! You Will Learn Step by step instructions to decide your labor force necessities by deliberately breaking down your present responsibility needs Step by step instructions to look at your current staffing circumstance and roll out the vital improvements to smooth out your cycles Tips and procedures for how to discover and select the correct contender for positions Step by step instructions to choose the correct staff by understanding who to pick and how to talk with them Advantages of Taking This Course You will definitely improve efficiency and yield by setting the perfect measure of individuals in the correct position You will significantly improve staff assurance and usefulness by smoothing out cycles and correspondence You will save time spent on gatherings and training by upgrading your staff supplement You will maintain a strategic distance from the encounter and opportunity squandering that accompanies disciplinary cycles and miniature administration
24 Hours Left! Don't Let Year-End Deals Slip Away - Enrol Now! Step into the world of exponential learning growth with our phenomenal bundle - "Growth Mindsets for Teachers and Learners". Expand your knowledge horizon with a selection of six distinct yet interconnecting courses. Acquire insights into growth mindsets that will empower both your personal and professional development. Dive into the core principles of lesson planning, learn the nuances of educational psychology, and master the art of education and pedagogy. Explore the magic of phonics teaching, delve into the vital early years of primary teaching, and become proficient in the challenging but rewarding role of a teaching assistant. Our course bundle provides an exclusive opportunity to gain expertise in SEN teaching and the latest remote teaching strategies. Understand learning disabilities from a comprehensive perspective and learn effective ways to manage challenging behaviours in children. Make a difference in your teaching journey with this growth-oriented, knowledge-rich bundle. This Growth Mindsets for Teachers and Learners Bundle Contains 11 of Our Premium Courses for One Discounted Price: Course 01: Growth Mindsets for Teachers and Learners Course 02: Lesson Planning for Teaching Course 03: Educational Psychology Course 04: Education and Pedagogy Course 05: Teaching Phonics Course 06: Early Years Primary Teaching Course 07: Teaching Assistant Complete Diploma Course 08: SEN - Special Educational Needs Teaching Assistant Diploma Course 09: Remote Teaching Strategies Course 10: Learning Disability Awareness Course 11: Challenging Behaviour in Children Learning Outcomes: By the end of this Growth Mindsets for Teachers and Learners bundle course, learners will be able to: Understand and apply the concept of growth mindsets in teaching and learning. Gain comprehensive knowledge in lesson planning for effective teaching. Acquire an in-depth understanding of educational psychology principles and their applications. Master the techniques of pedagogy for improved teaching practices. Learn the science of phonics teaching to enhance children's reading skills. Understand early years primary teaching and its significant impact on a child's development. Learn effective strategies for SEN teaching and handling challenging behaviours in children. In an ever-evolving educational landscape, a bundle such as "Growth Mindsets for Teachers and Learners" holds immense value. This rich collection of courses is designed to impart theoretical knowledge that extends beyond conventional learning boundaries, focusing on various crucial aspects of modern teaching. With growth mindsets at the heart of this bundle, educators can reshape their teaching methods to adapt to different learning styles and needs. This bundle encompasses all the necessary elements, from mastering lesson planning and understanding educational psychology to tackling challenging behaviours in children and managing special educational needs. This learning journey is your stepping stone to fostering growth mindsets within your educational ecosystem. CPD 250 CPD hours / points Accredited by CPD Quality Standards Who is this course for? This Growth Mindsets for Teachers and Learners course is ideal for: Aspiring educators eager to deepen their understanding of modern teaching strategies. Experienced teachers looking to incorporate growth mindsets in their teaching methodologies. Education professionals keen to learn more about SEN teaching. Parents want to supplement their children's education with a growth mindset approach. Career path Teacher (salary range in the UK: £24,000 - £40,000) Special Educational Needs Teacher (salary range in the UK: £26,000 - £45,000) Teaching Assistant (salary range in the UK: £18,000 - £25,000) Phonics Teacher (salary range in the UK: £24,000 - £35,000) Early Years Teacher (salary range in the UK: £20,000 - £32,000) Educational Psychologist (salary range in the UK: £35,000 - £90,000) Certificates CPD Accredited Certificate Digital certificate - Included Upon successfully completing the Bundle, you will need to place an order to receive a PDF Certificate for each course within the bundle. These certificates serve as proof of your newly acquired skills, accredited by CPD QS. Also, the certificates are recognised throughout the UK and internationally. CPD Accredited Certificate Hard copy certificate - Included International students are subject to a £10 delivery fee for their orders, based on their location. Growth Mindsets for Teachers and Learners - CPD Certified Hard copy certificate - Included
This course is aimed at those who would like to work as a learning support assistant in a school or further education setting. Level 3 Certificate in Supporting Teaching and Learning will give you an understanding of the skills and knowledge needed to support learners in the classroom.