44 Courses in London

Photography is a way of feeling, of touching, of loving. ... it remembers little things, long after you have forgotten everything. - Aaron Sisking For the kind of photos that are worthy of the memories  Because we just don't get do-overs with kids. There is no such thing as second-first steps. Because all their little quirks, all the big and little moments that shape their lives and their childhoods are something that only YOU as parents see and appreciate fully. And they are the thing that make them who they are. There is simply no outside photographer who can come in and capture those unique things because nobody knows your children like you do. Photography For Parents Fundamentals Our flagship 6 week Photography course designed to help you learn all the key photography skills that you will need to drastically improve your children's photos.  KEY COURSE INFO: Course type: Instructor-led or self paced Course duration: 6 weeks Course format: Online course with Interactive weekly live classes, personal photo feedback and support group WHAT YOU LEARN: Our hands-on online instructor-led approach helps guarantee that you will quickly learn the key camera and photographic storytelling skills while keeping the focus on photographing children.  From camera know-how, light and composition, specific recipes to help you capture typical situations and getting it all right on the fly - yeah, our kids don't sit still either LEARN WHAT'S INCLUDED IN EACH MODULE Key Camera skills Working with natural light Capturing kids on the move Photo composition Portraits and details Photo storytelling HERE IS HOW YOU LEARN WITH US:  If you have bought an online course before, then gave up half way through because ... life.. - well, we are a bit different. This is A LOT more than a bunch of random tutorials. This is a proper, well designed, supported and paced course that genuinely delivers. HERE ARE THE INGREDIENTS THAT MAKE OUR COURSE DELIVER The one with all the materials: 5 core course modules, introduced on a weekly basis, plus a bonus wraparound module ( more on that below) - courses accessible online and in pdf version The one with all the people: You're not going through the course on your own - as part of the course you join an online peer support group, moderated daily by the instructor, where you connect, get help and go through this journey together with other parents like you. The one with all the answers: Every week we run an live online class which is where your instructor goes through the key parts of your course, answers live questions and demonstrates techniques and additional illustration photos. The Live classes are run in the evening ( after the kids are in bed) and are always recorded in case you couldn't join in live The one that's all about you: Every week comes with homework to help you practice the elements we introduce in the modules. You submit those images to your instructor on a weekly basis and receive thorough, photo-by-photo, video feedback from your instructor - so it's all about you and your progress, nobody else's The one with the bonuses: A PDF workbook to help you go through the materials and practice the skills, handy cheat sheets formatted for your phone so you can whip them out on the go plus a Bonus wrap-up module with swipe files of photo ideas for children at different ages, handy checklists and more!  The one after it's over: We don't just leave you on your lonesome after the course is over - you get access to a=our Alumni group - a Photography for Parents Clique if you will - which is where we continue supporting you, answering your questions, encouraging you to take photos through weekly and monthly challenges and peer support Next Fundamentals course starts on 15th January 2024 5 core course modules Support Facebook group Weekly online Live class Personal Feedback on your images BONUS: extra module with ideas bank for photographing children of all ages BONUS: PDF course workbook BONUS: Printable and mobile friendly Pocket Guides HERE IS WHAT YOU WILL LEARN WITH US:  How to finally, actually, properly use your camera - no more cryptic buttons and the 'oh no! what have I pressed now?!' panic. Life's too short to be intimidated by your camerant The precise steps and 'recipes' to help you capture all sorts of different situations - whether your kids are indoors on a dark and dreary day or tearing through the park in the sun How to see the world and your children through a photographers eyes and learn to compose your photographs on the fly so they truly reflect the beauty you see How to get great photos CONSISTENTLY - I mean the spray and pray method is fine, but wouldn't it be nice to have confidence your images will turn out the way you want them? How to learn to notice and capture the little details, the big picture, the whole story of your children growing up. BEAUTIFULLY. "Absolutely, without a doubt, the best money I have ever spent on anything kid related. I so wish i had done these courses 6 years ago, just before my 1st was born. My photography has improved significantly and I'm just sad the course are over, I have loved everything about them!" Hannah Slater "The most enjoyable online course I ever done" I cannot recommend this course highly enough, and I am so grateful for Ania for creating this amazing course and community, teaching busy parents how to document their family storied beautifully! DALIA SEABORNE "I'm amazed at how much my photography has improved " I have learned so much and am amazed at how much my photography has improved - they are brilliant value for money considering the level of personal attention you receive! I've come away with a whole lot more technical knowledge as well as a heap of inspiration and ideas. LUCY GRIFFITH "The most wonderful entry into the incredible photography world" I am seeing things that I have never noticed before, I am using the DSLR to capture precious moments with my family and am signed up to two further courses because the instructors, modules and supportive community are amazing and I think I might be addicted KIRSTY FINNIE Photography for Parents FUNDAMENTALS Next course starts on 15th Jan 2024 All the learning resources, all the community, all the support, all the personal help. Virtually failproof 5 core course modules Bonus Idea Bank module PDF course workbook Pocket reference guide Support group Weekly online live class Personal Feedback on your images Access to Photography For Parents Alumni community But will it work for me? - our guarantee: GUARANTEE We know our course works. We have seen a few thousands of students go through our courses and really improve. BUT, if you find that after the first couple of modules that it just doesn't work for you, you haven't learnt anything new, it's the wrong level for you, you haven't improved, or you simply don't get on or engage with it - we will simply refund you in full. Simple as that! INSIDE THE MODULES - aka WHAT DO YOU LEARN? Module 1: See what your camera sees Our first module is dedicated to breaking you our of the snapping habit and giving you a fresh perspective. We show you how your camera sees the world differently than what you might expect in three major ways - the optics. the focus and the light. Major Takeaways: At the end of the module you will have gained full control of your focus - no more guessing game and kids turning out all blurry, you will also gain an insight of how to use your lens ( there is a skill to it) and how to let the light help make your subjects stand out. What's included: The importance of focus and what it does to our brain Taking control of your focus - the Where and HOW your camera focuses Mastering focus formula - a process to help you determine what settings to use for each occasion To zoom or not to zoom and how it changes what and how your camera sees Learning how your camera sees the light and how to make it better, especially with tricky light Learning how to shoot against the light - like a bright window and NOT end up with the person looking all dark Module 2: On exposure and all things sharp and blurry In our second module we take you off the auto setting and dive deep into learning about exposure - i.e. making sure that your images are not too dark or bright or blurry. But not only that, we pay special attention to how to make some of the things in your image sharp and others blurry through the use of specific combinations of settings  Major Takeaways: How to work your camera in priority ( semi-manual) modes, how to capture detail or portraits with a great separation of sharp and blurry to make these elements stand out.  What's included: Understanding the mechanics of your camera - how does a photo actually happen inside Taking your camera firmly OFF the Auto settings - learning the key factors ( aperture, shutter speed and ISO) and how they interact with one another How to capture portraits and those precious detail shots beautifully Switching to Aperture priority and controlling your aperture - the how and the why Taking control of what in your image will be sharp and what will be blurry - hello full control over blurry backgrounds, blurry foregrounds and pin sharp subjects in between. Module 3: Capturing movement  One of my favourite modules, dedicated to helping you capture your kids in motion - whether they're wriggling babies, speedy crawlers, wobbly toddlers or perpetual-motion-machines that most children are. We learn how to match your focus settings, your shutter settings and your composition to capture great movement photos.  Major Takeaways: Learn how to capture your children on the move, SHARP but also how to use blur and speed to really showcase and highlight movement. Big AH-HA moments here!  What's included: Switching your camera to shutter priority and mastering MOVEMENT Learning how to capture moving things SHARP - yes, that includes those fast movingbaby arms and legs Learning how to capture moving things BLURRY - and why would you want to do it? Learning how to highlight action and energy and speed in your images and how to help yourself with composition Creative techniques like night time light trails or panning or creative blur How to use your focus settings on top of your shutter settings to help capture things sharp Module 4: See what your camera sees Although we introduce elements of photographic composition throughout the course, this is the module entirely dedicated to it. We look at composition not just as a set of arbitrary rules, but more as something that helps you express what you really see and feel. We look at photographic storytelling and helping your images get look more impactful and stronger Major Takeaways: Good photographic composition principles to help you really show the magic you are seeing. At the end of this module you will say goodbye to boring flat photos and will instead start taking rich images with lots of depth and eye catching composition.  What's included: understanding how we 'read' photographs and how to compose so that the magic YOU see translates into what the others see when they pick up that photo fundamental rules of photo composition - we started you off with the rule of thirds but there is MORE Good crops, bad crops, crazy crops and everything in between storytelling through your photographs - how to make your images mean something and show something real, beyond 'my child looks cute here' getting creative and expressing yourself through photographs learning to go beyond your usual compositions and discovering different styles Module 5: Photographic composition and storytelling Although we introduce elements of photographic composition throughout the course, this is the module entirely dedicated to it. We look at composition not just as a set of arbitrary rules, but more as something that helps you express what you really see and feel. We look at photographic storytelling and helping your images get look more impactful and stronger Major Takeaways: Good photographic composition principles to help you really show the magic you are seeing. At the end of this module you will say goodbye to boring flat photos and will instead start taking rich images with lots of depth and eye catching composition.  What's included: Understanding how we 'read' photographs and how to compose so that the magic YOU see translates into what the others see when they pick up that photo Fundamental rules of photo composition - we started you off with the rule of thirds but there is MORE Good crops, bad crops, crazy crops and everything in between Storytelling through your photographs - how to make your images mean something and show something real, beyond 'my child looks cute here' Getting creative and expressing yourself through photographs Learning to go beyond your usual compositions and discovering different styles BONUS Module 6: Idea Bank : Photographing children at different ages This last module is a bit different. We us it to give you lots of ideas for photos with children of different ages - from photographing milestones to capturing what's unique about them at a particular stage and really getting into their world to capture where they're at. The module is packed with ready to take ideas and will let you take all that you have learned in the first 5 modules and apply it in real life sitautions. We also help you think ahead to the next steps in your photography education - should you want to continue. 

DNA3 Theta Healing course in London and online/ class processes include deep resentment and belief work to know thyself; intuitively lining up the Eternal Molecules; spiritual bi-location; understanding the energy fields of non-organic material and the power of our words to manifest our reality.

Why Choose Complete Maya Beginner to Advanced Training? Maya's extensive toolkit includes modeling, animation, simulation, and more, amplifying your versatility and influence in the 3D production pipeline. Click here for more info: Website Beginners or those with basic 3D knowledge. No specific digital media background is required. Duration: 40 hours Training Approach: 1-on-1 Sessions. Schedule: Customize your schedule by pre-booking a convenient hour of your choice, available Monday to Saturday between 9 am and 7 pm Course Structure: I. Introduction to Maya (3 hours) Maya Overview and Applications Interface Navigation and Basic Tools Project Creation and Management II. Basic Polygon Modeling (6 hours) Fundamentals of Polygon Modeling Creating and Editing Basic Shapes Advanced Techniques: Extrusions, Bevels, and NURBS for Organic Shapes III. Intermediate Modeling (6 hours) Advanced Polygon Modeling: Booleans, Deformers, and Surfaces Architectural Model Creation Sculpting Tools for Organic Shapes IV. Texturing and Materials (6 hours) Introduction to Texturing and Material Application Texture Mapping, UV Unwrapping, and Shaders Painting Textures with 3D Paint Tool V. Lighting and Rendering (6 hours) Basic and Advanced Lighting Techniques Realistic Lighting Environments Camera Setup, Composition, and Rendering VI. Animation (9 hours) Keyframe Animation and Animation Curves Character Rigging and Animation Complex Character Rigs, Lip Sync, Facial Animation, Dynamics, and Simulations VII. Rigging (4 hours) Skeleton Creation and Joint Binding Weight Maps and Simple to Complex Rigging Systems VIII. Special Effects (4 hours) Particle Systems, Fluid Dynamics, Fire, and Explosions Advanced Simulations with nCloth and nParticles Paint Effects and Mash Networks IX. Advanced Rendering Techniques (2 hours) Render Layers, Passes, and Global Illumination Mental Ray Rendering and Settings X. Conclusion and Next Steps (1 hour) Course Review, Tips for Further Learning Q&A Session and Feedback Please note that the course outline is flexible and can be tailored based on the learners' needs and proficiency levels. Autodesk Maya Basics to Advanced Level Course: Modeling: Surfaces, Control Vertex, Polygons, Extrusion Techniques, Subdiv Modeling, and More Deformations: Twist, Lattice, Flare, Bend Tools Shapes: Lines, Pen Tools, Surface Manipulation Techniques Animations: Keyframe Setup, Path Animations, Skeletons, IK Handles, Skinning Dynamics and Special Effects: Particle Systems, Fluid Dynamics, Lighting Effects, and Advanced Simulations Texturing and Rendering: Diffuse and Bump Mapping, Reflections, Shaders, Lights, and Camera Techniques Fluid Effects and Ncloth: 2D and 3D Containers, Collision Effects, Wind Simulations, and Gravity Control Rendering: Image and Animation Rendering, Playblast, Resolution Controls, and Output Formats. Advanced Modeling: Master intricate 3D models, including polygon, NURBS, and architectural modeling. Expert Texturing: Create realistic textures, apply shaders, and utilize the 3D paint tool. Complex Animation: Rig characters, perform lip sync, facial animation, and dynamic simulations. Special Effects Mastery: Understand particle systems, fluid dynamics, fire effects, and advanced simulations. Rendering Expertise: Grasp advanced rendering techniques, including layers, passes, and global illumination. Comprehensive Rigging: Develop joints, skeletons, and advanced rigging systems for characters and objects. Fluid Dynamics Proficiency: Manipulate 2D/3D fluid containers, create collision effects, and work with wind/gravity simulations. Advanced Lighting and Camera: Perfect lighting, shadows, and special effects. Master camera setups for diverse visual compositions. Recommended Books: "Introducing Autodesk Maya 2023" by Dariush Derakhshani and Randi L. Derakhshani "Mastering Autodesk Maya 2023" by Todd Palamar "Maya Character Creation: Modeling and Animation Controls" by Chris Maraffi "Maya Secrets of the Pros" by John Kundert-Gibbs and Dariush Derakhshani "The Art of 3D Computer Animation and Effects" by Isaac Victor Kerlow Advanced Maya Training Tailored to You: Elevate your Maya skills with specialized training covering essential areas like modeling, UV mapping, texturing, lighting, camera movement, and rigging. Your learning experience is personalized to match your unique requirements and preferences. Discuss your goals with our trainer, and we'll create a syllabus tailored just for you. Flexible Training Choices: Select between in-person sessions at our UK center or attend live online classes, offering convenience and accessibility. Certified Instructors: Benefit from expert guidance provided by Autodesk Authorized Trainers from London Design Training Course. Hands-On Learning: Our practical approach combines theory with step-by-step demonstrations, allowing ample time for hands-on practice on your computer with Maya. You'll retain all the files you create. Compatibility Across Platforms: Maya training caters to both Windows and Mac users, ensuring compatibility with various versions of Maya. Comprehensive Training Package: Participants receive an e-certificate upon successful completion, validating their Maya training. Lifetime Support: Enjoy a lifetime of email support post-training, ensuring assistance with any queries or challenges that arise. Tailored to Your Version: Training can be adapted to your preferred Maya version, ensuring you learn using the most relevant and up-to-date software features. Download Maya  https://www.autodesk.co.uk  Highly skilled mentors with practical experience. Cutting-edge facilities ensuring an immersive learning environment. Comprehensive courses spanning diverse design disciplines. Practical projects to enhance your portfolio. Networking avenues within the dynamic design community. Skills attuned to current industry trends. Opportunities for professional growth. Choose from flexible in-person or online classes. Internationally recognized training credentials. Engage in London's thriving art and design scene.

Why Choose Complete Rhino 3D and V-Ray Training Program: Basic to Intermediate? Learn Rhino 3D and V-Ray for Rhino Basic to Intermediate Training Course. Suitable for beginners and experienced users alike, this program equips you with vital modeling and rendering skills. Opt for in-person or live online sessions. Click here for more info: Website Duration: 16 hours. Approach: 1-on-1 Sessions, Customized Content and Flexible Learning. Scheduling Flexibility: Tailor your sessions from Mon to Sat between 9 am and 7 pm. Course Title: Complete Rhino 3D and V-Ray Training Program: Basic to Intermediate - 16 Hours Session 1-2: Introduction to Rhino 3D Basics (2 hours) Understanding Rhino Interface: Navigating toolbars, command line, and properties panel. Basic Geometric Shapes: Creating lines, circles, and polygons with precision. Editing Tools: Mastering move, rotate, scale, and mirror commands. Session 3-4: Advanced Rhino 3D Modeling Techniques (2 hours) Curves and Surfaces: Delving into NURBS curves, creating complex surfaces, and blending techniques. Modeling Aids: Utilizing grids, snaps, and construction planes for accuracy. Organizing with Layers: Managing complex projects efficiently. Session 5-6: Introduction to V-Ray for Rhino (2 hours) V-Ray Interface: Understanding V-Ray toolbar and settings. Basic Lighting: Exploring different light types and their effects on scenes. Materials: Creating realistic materials, understanding diffuse, reflection, and transparency. Session 7-8: Intermediate V-Ray Concepts (2 hours) Advanced Lighting: Mastering HDRI lighting, creating natural outdoor lighting scenarios. Texture Mapping: Understanding UV mapping, applying textures seamlessly. Rendering Optimization: Reducing noise, optimizing settings for quicker, high-quality renders. Session 9-10: Rhino-V-Ray Integration (2 hours) Model Preparation: Optimizing Rhino models for V-Ray rendering. Advanced Material Manipulation: Creating complex materials, incorporating textures. Interactive Rendering: Real-time adjustments for immediate feedback. Session 11-12: Advanced Modeling Techniques in Rhino (2 hours) Advanced Surface Modeling: Creating organic shapes, advanced surfacing techniques. Precision Modeling: Advanced curve editing, filleting, and trimming. Working with 3D Text: Creating custom 3D text for design projects. Session 13-14: Scene Composition and Presentation (2 hours) Camera Settings: Understanding focal length, depth of field, and perspective. Scene Composition: Design principles, rule of thirds, focal points, and balance. Post-Processing: Enhancing renders in Photoshop, adding atmosphere and context. Session 15-16: Final Project and Portfolio Review (2 hours) Final Project Work: Participants apply learned skills to create a complex 3D scene. Instructor-led Critique: Feedback session for final projects. Portfolio Guidance: Tips for selecting the best works for a professional portfolio. By the end of this 16-hour course, participants will have a deep understanding of both Rhino 3D and V-Ray, allowing them to create intricate 3D models and produce high-quality, realistic renders for various applications. Upon completing the Rhino 3D and V-Ray Basic to Intermediate Training Course, participants can expect to achieve the following learning outcomes: Proficiency in Rhino 3D and V-Ray: Develop a comprehensive understanding of Rhino 3D and V-Ray interfaces, tools, and functionalities, enabling participants to navigate and utilize the software effectively. 3D Modeling Skills: Master the art of creating captivating 3D objects and shapes using Rhino 3D, including editing, transforming, and refining designs for diverse applications. Material Application: Acquire the ability to apply and customize materials and textures to enhance the visual appeal and realism of 3D models, elevating the quality of designs. Lighting Techniques: Gain expertise in utilizing V-Ray lighting tools, such as V-Ray lights and HDRI maps, to achieve striking lighting effects in rendered scenes. Rendering Excellence: Learn to optimize V-Ray render settings, control global illumination, and apply dynamic effects like depth of field and motion blur for high-quality and impressive renders. Advanced Modeling: Develop skills in advanced modeling techniques, including handling curves, surfaces, and solids, enabling participants to tackle complex design challenges. Lighting Mastery: Acquire the knowledge and expertise to create and adjust artificial lights, utilize the Sun and Sky system, and craft custom HDR images for realistic lighting setups. Seamless File Management: Understand various file formats for exporting and importing 3D models, facilitating efficient collaboration and preparation for 3D printing. Creative Problem-Solving: Enhance creative thinking and problem-solving abilities through hands-on practice and exploration of diverse design scenarios. Professional Presentation: Learn post-production techniques in Photoshop to enhance renders and create visually appealing design presentations for effective communication. Continuous Learning: Access valuable resources and tips to encourage continuous learning and professional growth in Rhino 3D and V-Ray. Skills You'll Gain: Master Rhino 3D basics: Curves, surfaces, modeling aids, and precision techniques. Explore intermediate V-Ray concepts: Advanced lighting, material manipulation, and texture mapping. Understand Rhino-V-Ray integration for seamless 3D modeling and rendering workflows. Optimize render settings for high-quality output and reduced rendering times. Career Opportunities: Upon completing this program, you'll be prepared for various roles in the design and visualization industry, such as: 3D Modeler: Create detailed 3D models for diverse industries, including architecture and product design. Architectural Visualizer: Produce realistic architectural visualizations for presentations and marketing materials. Product Designer: Develop visually appealing product prototypes and visualizations for marketing and manufacturing. Visualization Specialist: Work in design studios, advertising agencies, or game development companies, creating immersive visual content. Freelance Designer: Offer your skills on platforms like Upwork or Fiverr, providing 3D modeling and rendering services to clients worldwide. Solidify Rhino 3D Expertise: Master foundational modeling skills, including intricate geometries and surface manipulation, establishing a robust foundation for your 3D design journey. Unlock V-Ray for Rhino: Explore the potential of V-Ray for Rhino, learning to create mesmerizing visualizations and achieve lifelike rendering results that bring vitality to your designs. Enhance Visual Appeal: Grasp advanced lighting techniques, material application, and texture methods to elevate the visual allure of your 3D creations, making them more immersive and authentic. Explore Advanced Concepts: Delve into optimizing rendering settings, post-production tactics, and efficient workflows, advancing your design proficiency to higher levels. Hands-On Experience: Engage in practical exercises and real-world projects, applying your skills in practical contexts to enrich your portfolio and showcase your capabilities effectively. Certification of Achievement: Receive a valuable Certificate of Completion, confirming your expertise in Rhino 3D and V-Ray for Rhino, enhancing your professional credibility as a skilled designer. Flexible Learning Paths: In-Person or Live Online: Opt for in-person sessions, fostering collaborative learning, or choose live online classes for convenience and accessibility, tailoring your learning experience to your preferences. Personalized Guidance: Regardless of your chosen format, benefit from tailored instruction and guidance, ensuring optimal learning outcomes and continuous support throughout the course.

Course Objectives At the end of this course you will be able to: Work with advanced lookup and reference functions Create macros to automate common tasks Use advanced techniques to analyse data Create PivotTables and PivotCharts Work with data validation tools Import and export data ' Customer Feedback Best Training Ever! Just finished a bespoke 1-1 training course in Excel Advanced, Macros & VBA. Pedro is an excellent trainer, imparting his skills and knowledge in the best way - appropriately to audience skills, knowledge and ability. Pedro is always approachable, encouraging and supportive, giving delegates the optimum learning environment. I would not hesitate to recommend Pedro as a trainer, whatever your level of ability. Amanda Morris - Treasury & Systems Accountant at Reall - Real Equity for All The course was very interesting and engaging and will definitely be put to use. The trainer was very helpful and charismatic. Marving Lopez - AM Best Europe Pedro was excellent. Very knowledgeable, clear and great rapport with class. Darren Barkey - Direct Wines Great content and learnt a lot. Really enjoyable :) Kristie-Lee Ryan - Stirling Ackroyd 1 year email support service Take a closer look at the consistent excellent feedback visiting our site ms-officetraining co uk With more than 20 years experience, we deliver courses on all levels of the Desktop version of Microsoft Office and Office 365; ranging from Beginner, Intermediate, Advanced to the VBA level. Our trainers are Microsoft certified professionals with a proven track record with several years experience in delivering classrom, one to one, tailored and bespoke courses. Tailored In Company training: You can choose to run the course exactly as they are outlined by us or we can customise it so that it meets your specific needs. A tailored or bespoke course will follow the standard outline but may be adapted to your specific organisational needs. Please visit our site (ms-officetraining co uk) to get a feel of the excellent feedback our courses have had and look at other courses you might be interested in. Advanced Functions COUNT, COUNTA, COUNTIF, COUNTBLANK, SUMIF, SUBTOTAL IF, OR, AND, IFERROR VLOOKUP to lookup Exact Values and Approximate values MATCH, INDIRECT, ROW/COLUMN, INDEX, OFFSET Analysing Data PMT function to calculate a monthly payment of a loan What If Analysis using Goal Seek Use scenarios to consider many different variables Using Solver Add-in to optimize variables PivotTables Create a PivotTable to analyse worksheet data Add or remove fields in a PivotTable Change the data source for a PivotTable Working with external data sources Using different Statistical Functions Calculate a Running Total, % of Grant Total, Difference From… Using the Slicer and Timeline to filter the PivotTable Using Filters in a PivotTable Group by Date, Auto Group by ranges of values, Custom Group Create a PivotChart The GETPIVOTDATA function Formula auditing Precedents and dependents Error checking Watch a formula and its result by using the Watch Window Evaluate a nested formula one step at a time Data Validation Number Validation Data List Validation Message Prompts and Alerts Conditional Data Validation Data Validation Errors Consolidation Consolidate data by position Consolidate data by category Use a formula to consolidate data Outline (group) data in a worksheet Create an outline of rows Create an outline of columns Copy outlined data Hide or remove an outline Connect external data to your workbook Using the Power Query Editor to import data From Text and CSV, From Access, From Web, From another Workbook Using the Power Query Editor to; Transform your data by Selecting which fields to import, by Splitting Columns, Changing Data Type and more. Deleting Applied Steps Refreshing your data Working with Form Controls; Buttons, Option Buttons and Scroll Bars Introduction to Macros Change Macro Security settings How to Record a macro Some Macro Examples Delete a macro Edit the macro to view the VBA code Copy part of a macro to create another macro Assign a macro to a button Who is this course for? Who is this course for? This course is intended to end users who want to develop their skills so they can use advanced techniques to analyse extensive and complex datasets in Excel and to automate simple tasks with the use of Macros. Requirements Requirements Preferably, delegates should have attended the Excel Intermediate course. Career path Career path Excel know-how can instantly increase your job prospects as well as your salary. 80 percent of job openings require spreadsheet and word-processing software skills

Course Objectives At the end of this course you will be able to: Manage project costs Consolidate and reuse project plan information Exchange project plan data with other applications Update a project plan Customise Project to meet specific requirements ' 1 year email support service Take a look at the consistent excellent feedback from our corporate clients visiting our site ms-officetraining co uk Customer Feedback Really useful and engaging course. Learnt a lot that will be very beneficial in my job. Trainer was great. Kelly Moreley - TACT Very happy with the course. Worked as a good refresher from what I knew already and enhanced my knowledge further Jenny Price - Acer ' With more than 20 years experience, we deliver courses on all levels of the Desktop version of Microsoft Office and Office 365; ranging from Beginner, Intermediate, Advanced to the VBA level. Our trainers are Microsoft certified professionals with a proven track record with several years experience in delivering public, one to one, tailored and bespoke courses. Our competitive rates start from £550.00 per day of training Tailored training courses: You can choose to run the course exactly as they are outlined by us or we can customise it so that it meets your specific needs. A tailored or bespoke course will follow the standard outline but may be adapted to your specific organisational needs. Exchanging Project Plan Data with Other Applications Import a list of tasks from Outlook Import a Task List from an Excel File Create a Custom Import Map Export Project Plan Cost Data into Excel Save Project Plan Information as a Web Page Updating a Project Plan Enter Task Progress Information View Task Progress Split a Task Reschedule a Task Creating Custom Fields Text fields Lookup fields Calculated fields with the use of formulas and functions Inserting Graphical Indicators Customizing how you look at data Filter Tasks in a Project Plan Create a Custom Table Create a Custom View Copy custom Views and Tables between projects Earned value analysis Understanding Earned Value Fields View Multiple Baselines in a Single Project Tracking progress between interim plans Creating Custom Reports Create a Custom Report Modify a Custom Report's Header and Footer Add a Picture to a Report Modify a Custom Report's Margins Print a Custom Report Re-using Project Plan Information Create a Project Plan Template Create a Custom Combination View Make Custom Views Available to Other Project Plans Share Resources between Projects, Create a Master Project Plan with sub projects Who is this course for? Who is this course for? This course is designed for those that who already have the skills to create and modify project plans and would like to acquire a more in depth and thorough knowledge of more advanced functionalities in project planning and tracking. Requirements Requirements Preferably, delegates would have attended the MS Project Introduction course. Career path Career path Microsoft Office know-how can instantly increase your job prospects as well as your salary. 80 percent of job openings require spreadsheet and word-processing software skills

This course will allow you to explore the potential of self-service business intelligence using Power BI Desktop to analyse and connect to different sources of data, creating Relationships between those different datasets, Query the data using Shaping and data Modelling, to create Visualizations, and publish Reports to different platforms . Course Objectives At the end of this course you will be able to: Connect to data from different sources. Use the Query Editor Perform Power BI desktop data Shaping and Transformation. Create Power BI desktop Modelling. Create Power BI desktop Visualizations and Reports. ' 1 year email support service Take a closer look at the consistent excellent feedback from our growing corporate clients visiting our site ms-officetraining co uk With more than 20 years experience, we deliver courses on all levels of the Desktop version of Microsoft Office and Office 365; ranging from Beginner, Intermediate, Advanced to the VBA level and Business Intelligence. Our trainers are Microsoft certified professionals with a proven track record with several years experience in delivering public, one to one, tailored and bespoke course Tailored training courses: in in company training, you can choose to run the course exactly as they are outlined by us or we can customise it so that it meets your specific needs. A tailored or bespoke course will follow the standard outline but may be adapted to your specific organisational needs. Please visit our site (ms-officetraining co uk) to get a feel of the excellent feedback our courses have had and look at other courses you might be interested in. Introduction to Power BI Power BI Jargon explained A quick look at Power BI Desktop A quick look at the Power BI service Helpful resources Power BI and Excel Introduction to using Excel data in Power BI Upload Excel data to Power BI Import Power View and Power Pivot to Power BI Getting started with Power BI Desktop Overview of Power BI Desktop Accessing Help and Helpful resources Connect to data sources in Power BI Desktop Shaping and Transforming Data with Query Editor Introduction to the Query Editor Data Sources Power BI Desktop can Connect to Introduction to Steps and M code Combining Data Using Merge and Append Queries Data Type Properties Working with Delimiters Clean and transform your data with the Query Editor Text Specific Transformation Tools Number Specific Transformation Tools Date Specific Transformation Tools Split and Merge columns Creating an Index Column Adding Conditional Columns Columns From Examples Grouping and Aggregating data Pivoting and Unpivoting Using filters Modeling the data Introduction to modeling your data How to manage your data relationships Create calculated columns Optimizing data models Create calculated measures Show Values As and Quick Measures Create calculated tables Explore your time-based data Introduction to DAX DAX calculation types DAX functions Visualizations Introduction to visuals in Power BI Create and customize simple visualizations Modify colors in charts and visuals Shapes, text boxes, and images Page layout and formatting Group interactions among visualizations Visual hierarchies and drill-down Using custom visualizations Create a KPI Visualization Geo-Data and Maps Reports, Publishing and Sharing Introduction to the Power BI service Quick insights in Power BI Create and configure a dashboard Ask questions of your data with natural language Create custom Q&A suggestions Share dashboards with your organization Introduction to content packs, security, and groups Publish Power BI Desktop reports Print and export dashboards and reports Create groups in Power BI Use content packs Update content packs Publish to web Who is this course for? Who is this course for? This course facilitates you with knowledge on the potential for Power BI Desktop to analyse and connect to different sources of data, creating Relationships between those different datasets, Query the data using Shaping and data Modelling, and to create Visualisations, and publish Reports to different platforms. Requirements Requirements Before attending this course, delegates should have: - A general knowledge of database concepts (fields, records and relationships) - Familiarity with Excel. Career path Career path Business Intelligence Data Analysis ETL & Data Warehousing

This 1 day course is designed for the end user who is using or will use Office 365. This course will provide delegates with the knowledge and skills to efficiently use Office 365 on a day-to-day basis. The course is designed with real world scenarios in mind. Delegates will learn how to use Outlook Online, Skype for Business, OneDrive for Business, SharePoint Online, and OneNote. At the end of this course delegates will be able to effectively navigate Office 365 and make use of all of the features of Office 365 Office 365 Overview Introducing Cloud Computing Identify and Outline the Component Products in Office 365 including Outlook Web App, Office Online Apps, OneDrive and Skype for Business Navigating around Office 365 Customising the Office 365 Nav Bar Updating your Profile in Office 365 Using the Outlook Online Application Overview of Outlook Online Working with Email and Folders Outlook People and IM Contacts Using the Calendar Shared Calendars Outlook Tasks in the Web App Setting Outlook Options, Signatures, Automatic Replies and Rules Using Skype for Business Overview of Skype for Business Viewing and Setting Presence Status Using Instant Messages in Business Understanding the Interactive Contact Card in Microsoft Office Applications Integration with Outlook Using Skype for Business for Online Presentations including Content Sharing, Polls and a Virtual Whiteboard Working with OneDrive for Business What is OneDrive for Business? Navigating around OneDrive Accessing Content in OneDrive Using the Office Online Apps Sharing Documents and Collaborating Connecting Microsoft Office to OneDrive Creating Office Documents and Saving Directly to OneDrive Using Groups and Delve Introduction to Groups Collaborating using Groups Getting to Content using Delve Requirements Requirements Before attending this course, students must have: Basic understanding of Microsoft Office Basic understanding of Microsoft Windows Operating systems

Why Learn Autodesk AutoCAD | 3ds Max Training Course? Course Link 3ds Max serves as a powerful tool in architectural modeling, product design, games and films. Engaging with 3ds Max tutorials proves invaluable, particularly for game designers, as it can significantly enhance their professional growth and career prospects. Duration: 16 hrs Method: 1-on-1, Personalized attention. Schedule: Tailor your own schedule by pre-booking a convenient hour of your choice, available from Mon to Sat between 9 am and 7 pm. AutoCAD and 3ds Max Training Course: Tailored Learning Experience: Benefit from personalized, one-on-one training tailored to your individual needs and learning pace. Flexibility in Learning: Choose between attending in-person sessions or participating in live online classes, granting you the flexibility to learn from anywhere at your convenience. Accessible Lesson Recordings: Access recorded lessons to revisit concepts, practice techniques, and reinforce your understanding whenever you need. Ongoing Email Support: Receive continuous assistance and expert guidance through lifetime email support, ensuring you never feel left behind in your learning journey. Learn from Certified Tutors and Industry Experts: Be educated by experienced professionals proficient in both Autodesk AutoCAD and 3ds Max, providing valuable insights into industry best practices. Complimentary Career Advice: Take advantage of our career advisory services to receive valuable guidance in navigating your professional path and making informed decisions. Download Autodesk Autocad and 3ds max AutoCAD and 3ds Max Training Course. Course Duration: 16 hours Course Overview: Join our training program to master AutoCAD and 3ds Max. Suitable for beginners and experienced 2D/3D modelers, this course equips you with essential skills to create stunning designs in both 2D and 3D. Course Outline: Part 1: Introduction to AutoCAD Familiarizing with the AutoCAD interface Understanding the drawing environment Mastering basic 2D geometry creation Exploring essential drawing tools and commands Introduction to blocks and symbols for efficient design Part 2: Advanced AutoCAD Techniques Delving into advanced drawing techniques Manipulating and editing 2D geometry like a pro Creating custom symbols and blocks for enhanced productivity Working with text and annotations for clear communication Utilizing layers and line types for organized design Part 3: Plans sections and Elevations Entering the realm of Plans sections and Elevations Crafting Plans and 2D construction detailing precision Modifying and manipulating 2D seamlessly Crafting custom materials and textures for realistic designs Part 4: Introduction to 3ds Max Embracing the 3ds Max interface and workspace setup Mastering navigation within 3ds Max Understanding the viewport for optimized design Exploring basic 3D modeling techniques in 3ds Max Part 5: Materials and Textures in 3ds Max Applying and modifying textures to elevate designs Unraveling the art of UVW mapping for precise texturing Utilizing the material editor for creative freedom Crafting custom materials to suit your design vision Harnessing the power of Vray materials for realistic renders Part 6: Lighting in 3ds Max Introducing various lighting techniques Understanding light properties for impactful designs Setting up lights strategically to enhance scenes Illuminating scenes using Vray lights Part 7: Cameras in 3ds Max Mastering camera systems in 3ds Max Exploring camera properties for cinematic effects Creating animation with cameras for dynamic scenes Utilizing Vray cameras to achieve stunning renders Part 8: Rendering in 3ds Max Unveiling the art of rendering Utilizing Vray Global Illumination for realistic lighting Leveraging Vray Physical Cameras for precise control Enhancing scenes with Vray HDRI Lighting Following a Vray Rendering Workflow for professional results Part 9: Advanced Modeling Techniques Crafting complex geometry with finesse Utilizing modifiers for intricate designs Exploring polygonal modeling for versatile creations Creating organic and inorganic models with expertise Unleashing the potential of advanced modeling techniques Part 10: Projects Applying all learned skills to create real-world scenes Designing a simple interior scene with attention to detail Crafting a captivating exterior scene for visual impact Creating a complex scene with multiple objects and materials Course Requirements: A computer with AutoCAD and 3ds Max installed Basic knowledge of computer operations An interest in 2D and 3D modeling and design

Course Objectives At the end of this course you will be able to: Customise tables and charts Customise formatting with styles and themes Modify pictures in a document Create customised graphic elements Insert content using Quick Parts Control text flow Use templates to automate document creation Perform mail merges Use macros to automate common tasks '1 year email support service Take a look at the consistent excellent feedback from our corporate clients visiting our site ms-officetraining co uk Customer Feedback Excelent enviroment for training. Tahnk you. Jenny Price - ACER ' With more than 20 years experience, we deliver courses on all levels of the Desktop version of Microsoft Office and Office 365; ranging from Beginner, Intermediate, Advanced to the VBA level. Our trainers are Microsoft certified professionals with a proven track record with several years experience in delivering public, one to one, tailored and bespoke courses. Our competitive rates start from £550.00 per day of training Tailored training courses: You can choose to run the course exactly as they are outlined by us or we can customise it so that it meets your specific needs. A tailored or bespoke course will follow the standard outline but may be adapted to your specific organisational needs. Working with Tables and Charts Sort Table Data Control Cell Layout Perform Calculations in a Table Create a Chart Customising Formats Using Styles and Themes Create and Modify Text Styles Create Custom List or Table Styles Apply Document Themes Using Images in a Document Resize an Image Adjust Image Appearance Integrate Pictures and Text Insert and Format Screenshots Use the Snipping tool Creating Custom Graphic Elements Create Text Boxes and Pull Quotes Draw Shapes Add WordArt and Other Text Effects Create Complex Illustrations with SmartArt Inserting Content Using Quick Parts Insert Building Blocks Create and Modify Building Blocks Insert Fields Using Quick Parts Controlling Text Flow Control Paragraph Flow Insert Section Breaks Insert Columns Link Text Boxes to Control Text Flow Using Templates Create a Document Using a Template Create a Template Using Mail Merge The Mail Merge Features Merge Envelopes and Labels Create a Data Source Using Word Using Macros Automate Tasks Using Macros Create a Macro Who is this course for? Who is this course for? This course is designed for users who to create or modify complex business documents as well as customised Word efficiency tools Requirements Requirements Preferably, delegates should have attended the Word Introduction course. Career path Career path Microsoft Office know-how can instantly increase your job prospects as well as your salary. 80 percent of job openings require spreadsheet and word-processing software skills Certificates Certificates Certificate of completion Digital certificate - Included