2556 Courses in London

Why Choose Garden Design Courses with Vectorworks Training Program? Designed to enhance your skills in crafting stunning garden designs. Led by certified tutors. From 2D layouts to 3D landscapes and detailed plans and visualizations. Check our Website Details: 1-on-1 training. Customize your schedule, available Mon to Sat 9 am and 7 am Call 02077202581 to book your session over the phone.   Duration: 16 hours. "You can divide this over multiple days to suit your schedule." Approach: 1-on-1 in-person or live online. Course Duration: 16 hours Course Description: This advanced Vectorworks course is tailored for individuals who already possess basic knowledge of the software and wish to enhance their skills to become proficient users. Participants will learn more advanced 2D and 3D techniques, including advanced 3D modeling, rendering, visualization, and customizing Vectorworks to suit their specific needs and workflows. The course will cover topics such as creating custom tools, working with planting plans, and integrating with AutoCAD. Course Outline: Module 1: Vectorworks Interface and Basic Concepts - Understanding the Vectorworks interface and palettes - Opening, saving, and managing files - Creating and editing objects and shapes - Utilizing Undo/Redo and Snaps for precision - Applying graphic attributes and working with dimensions Module 2: Modeling and Drawing Techniques - Exploring advanced tools and commands in detail - Integrating with AutoCAD and data exchange - Creating, modifying, and editing text - Utilizing callout text tool for annotations - Organizing information using design layers and classes Module 3: Working with Buildings and Models - Utilizing design layers and sheet layers for architectural projects - Assigning objects to layers and classes - Working with viewports and sheet layers for presentation - Drawing buildings, including walls and roofs - Setting up and rendering perspective views Module 4: Creating Site and Landscape Plans - Importing land surveys or architects' files - Drawing site surveys and working with hard landscape elements - Adding and customizing plantings using the plant tool - Editing plant definitions and creating custom plant symbols - Generating plant schedules and reports Module 5: Vectorworks Architect Features - Setting up files and scaling the drawing - Customizing text styles and dimension standards - Working with scanned images and creating site models - Designing floors, doors, and windows using standard Vectorworks elements - Creating and managing title blocks, labels, notes, and keynotes Module 6: Working Drawings and Final Project - Developing the final project with 2D and 3D elements - Applying site modifiers and stairs to the design - Generating printing layouts for presentations - Creating working drawings with detailed plans and elevations Download Vectorworks Trial https://www.vectorworks.net/trial Learning Outcomes: Master Vectorworks Tools: Proficiency in Vectorworks software, specializing in garden design features. Comprehensive Garden Design Skills: Expertise in 2D/3D modeling, plant selection, hardscapes, and irrigation systems. Professional Documentation: Create precise construction documents and visually compelling presentations. Collaboration and Project Management: Understand collaborative workflows, project management, and client communication. Job Opportunities: Landscape Designer/Architect: Design aesthetically pleasing and functional gardens for residential and commercial spaces. Garden Consultant/Horticulturist: Provide expert advice on plant selection, garden health, and sustainable practices. Entrepreneur/Educator: Start your own garden design business or teach garden design principles and techniques. Elevate your career with the Vectorworks Garden Design Course! Vectorworks Garden Design Mastery Course Course Enrollment Details: Unlock a personalized learning journey with our flexible 1-on-1 training sessions. Customize your schedule by reserving a time slot at your convenience, available Monday to Saturday between 9 a.m. and 7 p.m. Call 02077202581 to book your session over the phone. Training Duration: 16 hours. "You can divide these 16 hours over multiple days to suit your schedule." Training Approach: Experience tailored 1-on-1 sessions, either in-person or live online, providing individualized attention, customized content, flexible pacing, and comprehensive support. Live online 1-on-1 sessions via Zoom are also available. Course Overview: The Vectorworks Garden Design Mastery Course is meticulously crafted to empower participants with the expertise needed to craft exquisite garden designs using Vectorworks software. Guided by certified tutors and industry professionals, this program delivers a profound understanding of Vectorworks tools specifically tailored for garden design, enabling you to transform your landscaping ideas into breathtaking realities. Throughout the course, delve into the specialized features and functionalities of Vectorworks tailored for garden design. From 2D layouts to intricate 3D landscapes, master the art of utilizing Vectorworks to create detailed plans, visualize designs, and produce impeccable documentation for your garden projects. Tailored Training Excellence: Personalized One-to-One Guidance: Experience individualized coaching with undivided attention and customized instruction. Flexible Scheduling: Choose your preferred training slots, tailored to your schedule, even on weekends and late evenings. Post-Course Support and Comprehensive Materials: Access free online support post-training and receive detailed PDF notes and handouts for effective learning. Recognition of Achievement: Earn a Certificate of Attendance upon course completion, validating your expertise. Affordable Learning Solutions: Enjoy budget-friendly training rates without compromising on the quality of education. Tech Assistance and Referral Benefits: Receive software setup support and unlock referral discounts by recommending friends. Group Learning Perks and Tailored Courses: Avail special discounts for group sessions and experience customized training designed just for you. Elevate your skills affordably with our flexible schedules and personalized support.

Exclusive to AutoCAD subscribers, the AutoCAD Electrical toolset simplifies electrical system creation. Click here for more info: Website Our course provides a strong foundation in 2D electrical design, covering essential tools. Flexible one-on-one sessions from 9 a.m. to 7 p.m., Monday to Saturday. Call 02077202581 or book online. The 16-hour course offers flexibility, divide hours across days. Benefit from individualized attention and tailored content. Enroll for in-person or Zoom sessions to excel in AutoCAD Electrical. AutoCAD Electrical Course Content: Introduction to AutoCAD Electrical Software: Overview and features of AutoCAD Electrical Understanding the software interface and tools Project file structure and management Layout and Navigation: Navigating the AutoCAD Electrical workspace Creating new project files and using attribute editors Understanding WDD, WDX, and WDF project files Exploring the Project Manager interface and attribute editors Electrical Diagram Drawing: Numbering and titling wires in diagrams Labelling components Utilizing diagram symbol libraries Creating and editing Electrical Control Circuits (ECC) Component dialog box and Circuit Scale dialog box Introduction to Programmable Logic Controllers (PLCs) and Integrated Systems: PLC Symbols and Concepts Inserting Programmable Logic Controllers (PLCs) into diagrams Adding PLC Units to diagrams Working with PLC Input and Output points and circuits Understanding PLC-based classification Using the Spreadsheet to PLC Input and Output Points utility Custom and Bespoke Symbols: Creating custom symbols for Switches, Wires, Contactors, Motors, Transformers, etc. Specifying symbol conventions and standards Offline and online usage of AutoCAD Electrical databases Drawing for Terminals and Plans: Implementing Terminal symbols in diagrams Handling terminal plans and locations Working with compound level terminals and locations Utilizing the Component command for single and multiple components Managing Jumpers and wiring Modifying Terminal Strips and Dual In-Line Packages (DIP) Understanding DIN Rail, Electrical Enclosure, Circuit Breakers, and Electrical Equipment Generating PDFs and Reports: Exporting drawings to PDF format Organizing report templates Automating the generation of reports Creating Electrical Audit Reports This AutoCAD Electrical course provides comprehensive knowledge of the software, focusing on electrical diagram drawing, symbol creation, PLC integration, terminal planning, and report generation. Participants will gain the skills needed to efficiently design electrical systems using AutoCAD Electrical software. Upon completion, participants will proficiently use AutoCAD Electrical to create precise electrical diagrams, integrate PLCs, design custom symbols, plan terminals, and generate reports efficiently. They will possess the skills needed to confidently design electrical systems and enhance their expertise in electrical design and drawing. AutoCAD Electrical Training Course: Master precision in specialized electrical design skills. Optimize your design process with streamlined workflows. Ensure compliance with industry standards consistently. Boost productivity in electrical design tasks. Facilitate seamless collaboration with fellow professionals. Benefit from recorded lessons for convenient review. Enjoy continuous support with lifetime email assistance. Unleash the complete power of AutoCAD for your electrical design needs. Enroll today and craft precise, professional electrical drawings confidently. Select between in-person and live online sessions to suit your preference. Flexible Evening Sessions: Learn AutoCAD at your own pace with evening sessions designed for busy individuals. Boost your career opportunities in computer-aided design. Comprehensive Skill Development: Gain a strong foundation in AutoCAD's core features and advance to 3D modeling and rendering techniques, enhancing your design capabilities. Industry-Standard Knowledge: Become proficient in AutoCAD, a widely used CAD software in architecture, engineering, and construction fields, making you highly sought after by employers. Practical Application: Apply AutoCAD skills to real-world design scenarios, creating detailed plans for professional projects in architecture, engineering, and mechanical fields. Recorded Lessons for Review: Access lesson recordings to reinforce learning and review specific topics or techniques whenever needed. Lifetime Email Support: Enjoy ongoing support with lifetime email assistance, even after completing the course, for guidance and clarification.

Who is this course for? AutoCAD 2D Basics to Advanced Course. Click here for more info: Website This course enables you to learn the skills in the CAD. Upon completion, you'll proficiently edit and create 2D drawings, utilizing advanced features like Paperspace and Block Attributes for increased efficiency.   1-on-1 sessions. Our booking are available Mon to Sat, 9 am to 7 pm Duration: 16 hours, which you can flexibly distribute across as many days you want. Approach: In-person or live online training. AutoCAD Basics to Advanced Level Training Course Outline. Fundamental Concepts: Introduction to AutoCAD interface, commands, and tools. Managing drawings and creating basic shapes. Basic modification techniques like erase, move, rotate, and scale. Intermediate Techniques: Working with layers and adjusting properties. Creating and modifying text and dimensions. Introduction to blocks and attributes. Advanced Topics: Advanced object modification techniques such as fillet, chamfer, trim, and extend. Utilizing grips for object manipulation. Creating and editing polylines and splines. Course Highlights: Engaging exercises and projects for skill reinforcement. Access to Q&A and troubleshooting support. Proficiency in AutoCAD 2D for basic to intermediate drawings. Topics Covered: Drawing techniques encompassing various shapes. Inquiry tools for measurement and selection. Modification commands for object manipulation. Layer management and attributes. Annotation and dimensioning. Hatching objects and working with reusable content. Layouts and viewports for better organization. Annotating drawings effectively. Polylines, splines, ellipses, and tables. Plotting drawings and creating templates. Multi-lines, revision clouds, and wipeout objects. Working with point objects and calculations. Creating and managing templates. Annotation scaling and text manipulation. Dimensioning and geometric annotations. Dynamic blocks and attributes. Layer management best practices. Introduction to sheet sets and their properties. Utilizing fields and attributes in sheet sets. Working with tables, table styles, and advanced tables. Exporting and importing tables. Creating tables linked to external data. Download AutoCAD Software https://www.autodesk.co.uk What Will I Gain from this Course? Throughout this course, you will develop expertise in the following areas: CAD layering techniques Text and dimension style manipulation Proficiency in creating and editing 2D drawings Mastery of attributed block creation and editing Efficient utilization of Paperspace Dynamic input and grips utilization This comprehensive training program not only provides you with an advanced comprehension of 2D drawing in AutoCAD but also offers a fundamental introduction to 3D drawing concepts. Upon completion of this course, you will possess the skills to: Swiftly generate schematics, parts, and assemblies Enhance efficiency by reusing content and customizing tool palettes Save time through the use of dynamic blocks, which can be edited in place Gain full control over your viewports and layouts Is This Course Right for Me? This advanced AutoCAD 2D training assumes that you are already a proficient AutoCAD user. We recommend prior attendance of our Introduction and/or Intermediate AutoCAD 2D training courses or practical experience in the topics covered in those courses. If you have any doubts about the suitability of this course for your skill level, please feel free to contact us, and we will be happy to assist you. In this course, you will gain proficiency in utilizing essential features of AutoCAD (Computer Aided Design) to enhance the efficiency of producing and editing 2D CAD drawings. You will acquire expertise in layering, text and dimension styles, the creation and modification of attributed blocks, and effective use of Paperspace. Additionally, you will master dynamic inputs, grips, and the art of renaming and purging. This flexible course grants you 16 hours to complete, typically spanning 4 to 5 days. It serves as a valuable continuation of skills acquired from the CAD: AutoCAD 2D Essentials course or as an opportunity to expand your existing AutoCAD knowledge. Upon course completion, you will possess the ability to efficiently create and modify 2D drawings, leveraging advanced features like Paperspace and Block Attributes. Your instruction will be provided by an Autodesk-certified instructor with industry experience." 1. All-encompassing course designed to accommodate both novices and advanced users. 2. Addresses essential functions and advanced methodologies in AutoCAD. 3. Enhances proficiency in creating precise and professional 2D drawings. Interactive instruction guided by seasoned educators. Benefit from on-demand access to lesson recordings for convenient revision. Receive ongoing support through lifetime email and phone assistance. Post-course Assistance: Enjoy continuous support via lifetime email and phone assistance. Should you encounter any challenges or queries after the course, we are readily available to address your concerns via email or phone calls."

Course Title: 3ds Max Essential Training Course Perfect for novice 3ds Max users, our Essentials Training Course, hosted by an Autodesk Certified Trainer, equips you with core skills for creating 3D models and animations. Click here for more info: Website Duration: 16 hours Method: 1-on-1, Personalized Attention, Tailored Content, Flexible Pace, Individual Support Schedule: Tailor your own schedule by pre-booking a convenient hours, available from Mon to Sat between 9 am and 7 pm. Course Highlights: Comprehensive Learning: Covering 3ds Max from the basics, including interface navigation and customization, to essential skills for professional 3D modeling and animations. Expert Guidance: Certified tutors and industry experts provide personalized attention, ensuring a deep understanding of 3D concepts. Flexible Scheduling: Tailor the learning experience to your pace and preferences, with one-on-one sessions available from Monday to Sunday. Interactive Learning: Engage in hands-on exercises and practical projects, enhancing your skills in a real-world context. Job Opportunities: Upon completion, students can pursue careers as: 3D Modelers: Creating detailed 3D models for games, movies, or architectural visualization. Animation Artists: Designing engaging animations for various media platforms. Visual Effects (VFX) Artists: Working on special effects for films, TV shows, and commercials. Architectural Visualizers: Producing realistic architectural renders for construction and design projects. Game Designers: Developing immersive game environments and characters. Recommended Reading: "3ds Max 2022 for Beginners" by CADFolks: A beginner-friendly guide covering fundamental concepts and techniques in 3ds Max. "Mastering Autodesk 3ds Max 2022" by Nicholas Boughen: A comprehensive resource for mastering advanced features and workflows in 3ds Max. "The Animator's Survival Kit" by Richard Williams: A classic animation guide providing valuable insights for aspiring animators. These books offer valuable knowledge and techniques, complementing the skills learned in the course and aiding in future career endeavors. Upon completing the 3ds Max Basic to Fundamentals Training Course, participants will: Master 3ds Max Tools: Gain a deep understanding of the software interface, tools, and navigation, enabling efficient 3D modeling and animation. Create Complex Models: Develop proficiency in creating intricate 3D models, including objects, characters, and architectural elements, using various modeling techniques. Apply Realistic Textures: Learn to apply textures, maps, and materials to enhance the realism of 3D models, understanding diffuse, bump, and reflective materials. Perfect Lighting and Rendering: Acquire skills in setting up various lights, environment lighting, and global illumination for realistic renderings, optimizing rendering settings for quality output. Animate with Precision: Master keyframe animation, path animation, and constraints, bringing 3D scenes to life with smooth and accurate motion. Understand Dynamics and Simulations: Explore basic dynamics and simulations, including particle systems, creating dynamic and interactive 3D environments. Problem-Solve Creatively: Develop problem-solving skills for common challenges in 3D design, using innovative techniques and tools. Professional Project Execution: Apply learned skills to real-world projects, ensuring a professional approach to 3D modeling, animation, and visualization. By the end of the course, participants will be equipped with the knowledge and skills to confidently create visually stunning 3D models, animations, and visualizations, making them proficient 3ds Max users ready for diverse industry applications. Course Highlights: Comprehensive Learning: Covering 3ds Max from the basics, including interface navigation and customization, to essential skills for professional 3D modeling and animations. Expert Guidance: Certified tutors and industry experts provide personalized attention, ensuring a deep understanding of 3D concepts. Flexible Scheduling: Tailor the learning experience to your pace and preferences, with one-on-one sessions available from Monday to Sunday. Interactive Learning: Engage in hands-on exercises and practical projects, enhancing your skills in a real-world context. Job Opportunities: Upon completion, students can pursue careers as: 3D Modelers: Creating detailed 3D models for games, movies, or architectural visualization. Animation Artists: Designing engaging animations for various media platforms. Visual Effects (VFX) Artists: Working on special effects for films, TV shows, and commercials. Architectural Visualizers: Producing realistic architectural renders for construction and design projects. Game Designers: Developing immersive game environments and characters. Recommended Reading: "3ds Max 2022 for Beginners" by CADFolks: A beginner-friendly guide covering fundamental concepts and techniques in 3ds Max. "Mastering Autodesk 3ds Max 2022" by Nicholas Boughen: A comprehensive resource for mastering advanced features and workflows in 3ds Max. "The Animator's Survival Kit" by Richard Williams: A classic animation guide providing valuable insights for aspiring animators. These books offer valuable knowledge and techniques, complementing the skills learned in the course and aiding in future career endeavors. Receive ongoing email support for a lifetime. Access comprehensive handouts and valuable documents. Explore flexible financial support choices, including installment plans and funding through job center plus and DWP (Contact us for specifics). Rest assured with our money-back guarantee: If you're dissatisfied after your initial session, we address your concerns and provide a refund if necessary (Terms and conditions may apply). Get help with computer optimization to enhance software performance in Autocad, 3ds Max, and Photoshop on both PC platforms. Benefit from our industry connections, facilitating portfolio promotion and job opportunities.

AutoCAD-Mac Introduction to Advanced Training Course This project-based course is tailored for AutoCAD Mac users, architecture and interior design students and professionals. Click here for more info: Website When Can I Book This Training Course? Personalized experience with 1-on-1 sessions designed to fit your unique needs. Available from Monday to Saturday, 9 am to 7 am Or Call to Book 02077202581. Duration of Training: 16 hours. Training Method:  1-on-1, providing the option for in-person sessions or live online training. Course Content Section 1: Introduction Course Overview Section 2: Basic Concepts Status Bar and The Units Drawing Commands Control Points - Vertex or Verteces Modifying Commands Snap Settings Drawing An Outline Section 3: Dimensions and Customization Adding Dimensions and Dimension Style Manager Importing Dimension Styles Customizing Shortcuts Section 4: Advanced Techniques Adding Walls Thickness with Offset Command Adding interior layout Cleaning Layout lines with Trim Section 5: Text and Styling Text Editing and Importing Text Styles Main File Formats in AutoCAD Section 6: Design Elements Creating Openings in the Floor Plan Adding Openings - Part 2 Adding Openings - Part 3 Drawing Doors & Windows Using Line Types & Linetype Scale Group and Ungroup Commands Using Blocks Using Blocks Library & Dynamic Blocks Section 7: Layers and Furnishing Layers - Part 2 Layers - Part 3 Furnishing Bedrooms & Bathrooms - Part 1 Adding Furniture, Fixtures, and Equipments | part 2 Adding Furniture, Fixtures, and Equipments | part 3 Drawing the Kitchen Drawing the Living Room Drawing Dining Room & Adding Casework Adding Steps and Railings Using Stretch Command Finishing Steps and patio areas Hatch command Hatch Customization Adding Plants & Finishing Floor Plan Section 8: Layout and Printing Paper Space & Page Setup Manager Working with Viewport & Using Print Command Scale & Using Multiple Viewports Locking Viewport Scale Drawing A Titleblock - Part 1 Drawing A Titleblock - Part 2 Copying the Titleblock Using Titleblock with Attributes Section 9: Roof Plan and Organization Drawing The Roof Plan Placing Roof Plan on Sheet Organizing Project Drawings & Using Layer Freeze AutoCAD Crashing And What To Do Section 10: Elevations Exterior elevations - Drawing the Outline Exterior elevations - Drawing the Openings Elevations - Detailing - Part 1 Elevations - Detailing - Part 2 Elevations - Repeating the workflow Elevations - Finishing 3rd Elevation Elevations - Drawing the final elevation Section 11: Sections Sections: Drawing Cut Lines & the Outline Sections: Placing 1st Section on Sheet Sections: Drawing Section #2 - Different Technique Sections: Adding Final Detail Section 12: Interior Elevations Interior Elevations: Drawing the Outline Interior Elevations: Placing on Sheet Interior Elevations: Using Block Clip Interior Elevations: Final Drawing Section 13: Conclusion Putting the Final Set Together Proficient AutoCAD Skills: Master essential tools for efficient drawing creation and manipulation. Accurate 2D Designs: Create precise and high-quality layouts with attention to detail. Effective Object Handling: Excel in selecting, moving, copying, and scaling objects. File Management: Organize drawings efficiently and understand different file formats. Precise Measurements: Utilize inquiry commands for accurate design analysis. Annotations and Hatching: Apply text, dimensions, and hatching to enhance drawings. Object Organization: Manage layers and object properties for organized designs. Reusable Content: Efficiently use blocks, tool palettes, and groups for productivity. Layout Optimization: Create layouts with viewports for optimal design presentation. Professional Output: Generate professional plots and PDF output for polished results. Enhanced Productivity: Explore AutoCAD toolsets and web/mobile apps for streamlined workflow. Course Overview: Learn versatile AutoCAD for Mac drawing techniques, applicable across all industries, enabling you to excel in the application. Our trainers incorporate exercises from various disciplines. Who Should Attend: Ideal for newcomers to AutoCAD for Mac, self-taught users seeking correct techniques, and those transitioning from other CAD tools. Requirements: A solid Mac OS understanding is essential, while prior CAD knowledge is not required. Pre-course preparation guidance is provided for new AutoCAD users. Highlights: Perfect for AutoCAD for Mac beginners. Gain skills for precise 2D layouts and designs. Versatile drawing techniques for all industries. Choose between in-class or live online training. Autodesk Certified Tutors: AutoCAD 1-2-1 courses. Hands-on learning with expert trainers. Lifetime post-course email support. Tailored on-request training available. Certificate: Digital certificate included. Tailored Mac Training: Excel in AutoCAD with specialized Mac training, leveraging its distinct features and interface for heightened efficiency. Comprehensive Skill Enhancement: Advance from fundamental to intermediate AutoCAD Mac proficiency, creating precise and professional 2D drawings. Industry-Relevant Expertise: Attain in-demand skills valued by employers in architecture, engineering, and design sectors. Hands-On Project Exposure: Immerse yourself in practical exercises mirroring real-world design scenarios, fostering practical competence. Lesson Recordings for Review: Access recorded lessons for reinforcement and deeper AutoCAD Mac comprehension. Ongoing Email Support: Benefit from lifetime email support, ensuring assistance beyond course completion."

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 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. 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 Visualizations, 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

Course Objectives At the end of this course you will be able to: Record and edit a Macro Assign macros to keyboard shortcuts, Quick Access Toolbar, Buttons and Shape objects. Use the Visual Basic Editor; change the properties of an object; add a module to a project; write the code for a procedure and then run it; and use the Object Browser to search procedures Manipulate data by declaring variables of different data types; combine data by using expressions; use functions to accept input and display output; and declare variables and procedures with the appropriate scope Use decision structures to create procedures that make decisions; and use loop structures to perform repetitive tasks Create an error handling routine in case things go wrong with VBA code ' 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 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 trainer was very knowledgeable, kept everyone involved and was enthusiastic. A great experience.. Simon Harper - Lloyd's of London My learning experience was awesome. Perdinand Reagan - Subsea7 Very nice and relaxed approach to teaching. Was definitely a good learning experience. Jerome Pupe - S5 Agency World The Trainer – Very positive + patient + helpful + thorough Agnes Souza - Direct Wines ' 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 classroom, 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. Introduction to Macros and VBA Introducing Visual Basic for Applications Recording a Macro Naming conventions for Macro Procedures Running a Macro Absolute or Relative Cell Referencing Saving and Opening Files with Macros Making macros always available Adding Macros to Keyboard Shortcuts, Quick Access Toolbar, Buttons and Shapes Editing a Macro in the Visual Basic Editor Understanding the Development Environment Customising the Editor Tips for General Typing in VBA Using Visual Basic Help Working with Procedures Program Design Understanding Modules Naming Rules Creating a Module Understanding Procedures Programming Macro Concepts Creating a Subroutine Creating a Function Understanding Arguments Exiting Procedures Calling Procedures Objects, Properties, Methods and Events Understanding Objects Properties, Methods, and Events Navigating the Object Hierarchy Understanding Collections Accessing a Member of a Collection Understanding Hierarchy Using the Object Browser Using the With Statement Working with Properties Working with Methods Creating an Event Procedure Reserved Macro Names Using Expressions, Variables and Intrinsic Functions Understanding Expressions and Statements Declaring Variables Understanding Data Types Determining the Value of Variables Working with Variable Scope Using Built-in VBA Functions Understanding Constants Using Message Boxes Controlling the Answer to a Message Box Using Input Boxes Declaring and Using Object Variables Controlling Program Execution Understanding Control-of-Flow Structures Using the If...End If Decision Structures Nested If Statements Using the Select Case ... End Select Structure Using the Do ... Loop Structure Using the For ... Next Structure Using the For Each ... Next Structure Guidelines for Use of Control-of-Flow Structures Debugging and Handling Errors Understanding Errors Using Debugging Tools Setting Breakpoints and Using Break Mode Stepping Through Code Trapping Errors with the On Error Statement Understanding the Err Object Working with Inline Error Handling Writing an Error-Handling Routine Working with Forms and Controls Understanding UserForms Creating a Form Displaying and Removing a Form Aligning and Sizing Controls Using the Toolbox Working with a Form's Properties, Methods, and Events Working with Form and Control Properties, Methods and Event Setting the Tab Order Populating a Control Who is this course for? Who is this course for? This course is designed to give proficiency in the Visual Basic Editor (VBE), predominantly making use of Excel objects, understanding Object's Properties, Events and Methods, basic VBA Object oriented programming, event handling, control structures, and debugging tools. Requirements Requirements Preferably, delegates should have attended the Excel Advanced 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

COSHH training course will help to ensure that your business complies with relevant legislation...

Ceremonial cacao Flow to music meditation and Yoga Nidra guided meditation to help relax and unwind

Contemporary dance class for all levels. Adults and 13+. Develop skills, get fit and feel creatively amazing.