1510 Courses in Leicester delivered Live Online

Click here for info. Training duration: 20 hrs. Method: 1-2-1, Personalized attention, Tailored content, Flexible pace, Individual support. Schedule: Personalized training experience with our flexible 1-2-1 sessions. Tailor your own schedule by pre-booking a convenient hour of your choice, available from Monday to Saturday between 9 am and 7 pm. Maya Basic to Intermediate Course Course Duration: 20 hours Course Description: Discover Autodesk Maya's potential in our 20-hour course. Master 3D modeling and animation, explore texturing, rigging, rendering, and special effects. Unleash your creativity with advanced modeling techniques. Join us on this exciting journey to unlock the full power of Maya. Course Outline: I. Introduction to Maya (1.5 hours) - Discover the vast applications of Maya and its significance in diverse industries - Navigate seamlessly through Maya's interface, understanding essential tools - Master viewport controls and proficiently manage projects II. Creating 3D Models (3 hours) - Build a strong foundation in polygon modeling, creating basic shapes and objects - Hone your skills in editing and modifying objects with precision - Master complex object creation using extrusions, bevels, and NURBS for organic shapes III. Texturing and Materials (1.5 hours) - Step into the captivating world of texturing, adding depth to your creations - Create and expertly apply materials to breathe life into your models - Unwrap textures with precision and import images seamlessly IV. Lighting and Rendering (2 hours) - Illuminate your scenes with fundamental lighting techniques - Compose visually captivating compositions with camera setup - Harness the power of rendering for still images and dynamic animations V. Animation (4 hours) - Embrace the art of animation, unlocking its potential in your projects - Master keyframe animation, animation curves, and animation clips - Rig and animate characters, adding life and movement to your creations - Explore motion paths and animation layers for added depth and complexity VI. Rigging (2 hours) - Delve into the world of rigging and its significance in animation - Create joints and skeletons, laying the foundation for character animation - Bind skin to joints and craft weight maps for smooth animation - Implement simple rigging systems and rig characters for animation VII. Special Effects (1.5 hours) - Unleash your creativity with mesmerizing particle systems and dynamics - Create captivating fluid and fire effects, manipulating them with finesse - Craft and edit special effects, from explosions to captivating smoke VIII. Advanced Modeling Techniques (1.5 hours) - Elevate your modeling skills with advanced techniques using Booleans and deformers - Master the art of creating and modifying curves and surfaces - Explore the world of sculpting tools to craft high-resolution and intricate models IX. Conclusion and Next Steps (0.5 hours) - Recap the rich knowledge acquired during the course - Discover valuable tips and resources for continuous learning and growth - Engage in a dynamic Q&A session, providing valuable feedback Note: The course outline can be customized to meet the specific needs and proficiency levels of learners. Throughout the course, you will receive lifetime email support, ensuring you have assistance for any queries or challenges you encounter. Embrace the world of Autodesk Maya, and unveil your creative potential in 3D modeling and animation.   Unlock your potential in Autodesk Maya with our comprehensive Basics to Intermediate Training Course. Whether you're a budding 3D artist, animator, or visual effects enthusiast, this program provides a structured learning path to master essential tools and techniques. Join us for interactive in-person or live online sessions, and receive guidance from experienced instructors. Enroll now to create captivating 3D visuals and animations and explore the creative possibilities of Autodesk Maya. In this course, explore the world of Maya 2023 and master the skills to create high-quality 3D models and animations. Discover a real-world, project-based workflow applicable to film, motion graphics, and game design. Learn Basic to Intermediate techniques like customizing the interface, object manipulation, and scene organization. Dive into polygonal, sculpting, and NURBS modeling, and apply materials for color, texture, and reflectivity. Integrate cameras, lighting, and depth-of-field effects with the Arnold renderer. Finally, learn animation tools to add movement and bring your creations to life, guided by instructor Autodesk certified trainers In this course, explore the world of Maya 2023 and master the skills to create high-quality 3D models and animations. Discover a real-world, project-based workflow applicable to film, motion graphics, and game design. Learn Basic to Intermediate techniques like customizing the interface, object manipulation, and scene organization. Dive into polygonal, sculpting, and NURBS modeling, and apply materials for color, texture, and reflectivity. Integrate cameras, lighting, and depth-of-field effects with the Arnold renderer. Finally, learn animation tools to add movement and bring your creations to life, guided by instructor Autodesk certified trainers In this course, explore the world of Maya 2023 and master the skills to create high-quality 3D models and animations. Discover a real-world, project-based workflow applicable to film, motion graphics, and game design. Learn Basic to Intermediate techniques like customizing the interface, object manipulation, and scene organization. Dive into polygonal, sculpting, and NURBS modeling, and apply materials for color, texture, and reflectivity. Integrate cameras, lighting, and depth-of-field effects with the Arnold renderer. Finally, learn animation tools to add movement and bring your creations to life, guided by instructor Autodesk certified trainers Master 3D modeling and animation. Create realistic textures and materials. Understand rigging for character animation. Illuminate scenes with effective lighting. Create mesmerizing special effects. Explore advanced modeling techniques. Gain practical skills for real-world projects. Unlock creative potential in film, animation, and game design.

Why Learn Vectorworks Spotlight Training Courses? VectorWorks Spotlight Course offers strong 2D drawing tools and lighting skills. while. Spotlight goes beyond fundamentals, offering solution for designing, modeling, and sharing entertainment projects. It's the industry standard for lighting, scenery, sets, corporate events, theater, and exhibits. Click here for more info: Website When can I book this course? 1-on-1 training. Duration: 16 hrs, Flexible scheduling (Mon to Sat, 9 am - 7 pm). Choose your own day and time. Training Course: Vectorworks Spotlight Duration: 16 hours Course Overview: I. Introduction to Vectorworks (1 hour) Overview of Vectorworks software and its diverse applications Familiarization with the user interface and navigation Customizing preferences and settings to optimize workflow II. 2D Drawing Tools (2 hours) Utilizing basic drawing tools for creating lines, rectangles, circles, and polygons Implementing text and dimension tools for annotations Applying modify tools for object editing and transformation Organizing elements using layers and classes III. 3D Modeling Tools (3 hours) Introduction to extrude, revolve, sweep, and loft tools for 3D modeling Creating 3D objects from 2D shapes for spatial representation Modifying and refining 3D models Exploration of the 3D modeling environment IV. Advanced 3D Modeling Tools (2 hours) Utilization of solid modeling tools for complex geometry creation Performing Boolean operations to combine or subtract shapes Creation and use of symbols for efficient workflow V. Introduction to Spotlight (1 hour) Overview of the Spotlight workspace and its features Adding and configuring lighting devices for stage and event design Creation and modification of lighting positions for precise placement VI. Spotlight Tools and Techniques (3 hours) Creation and editing of lighting instruments for customized setups Use of visualization tools for lighting simulations Creation and application of labels and legends for documentation Generation of worksheets and reports for lighting analysis VII. Advanced Spotlight Techniques (2 hours) Utilization of video and projection tools for multimedia presentations Incorporation of audio and sound systems for immersive experiences Understanding rigging and hoisting for stage setup Management of paperwork and documentation for effective planning VIII. Integration with Other Software (1 hour) Importing and exporting files for collaborative work with other software Utilizing Vectorworks in CAD and BIM workflows for seamless interoperability Exploration of plugins and add-ons for expanded functionality IX. Project-based Exercises (1 hour) Application of learned techniques to real-world scenarios Creation of a lighting plan for a concert or theater production Designing a 3D model of a building or interior space Free 30-day BIM & CAD Software Trial Request: Vectorworks After completing Vectorworks 2D | 3D and Spotlight Training Course? Vectorworks Proficiency: Master Vectorworks software, including interface and tools. 2D Drafting: Create precise technical drawings using fundamental 2D tools. 3D Modeling: Develop skills in 3D modeling, modification, and spatial representation. Spotlight Expertise: Learn stage and event design tools, focusing on lighting setups. Advanced Techniques: Explore complex 3D modeling and Spotlight features. Interdisciplinary Integration: Integrate Vectorworks with other software in CAD and BIM workflows. Project Application: Apply skills to real-world scenarios, creating plans and models. Job Opportunities: CAD Technician: Draft detailed plans for architecture and engineering firms. Stage Designer: Plan lighting, sound, and multimedia setups for events. Event Planner: Design event layouts with lighting and audio-visual setups. Architectural Drafter: Create accurate architectural plans and models. Interior Designer: Visualize interior spaces in 2D and 3D for clients. Lighting Designer: Specialize in various lighting applications, from buildings to stages. BIM Specialist: Work with architectural firms on Building Information Modeling projects. Freelance Designer: Offer services in 2D/3D modeling, event planning, or architectural visualization. What is Vectorworks Spotlight? Vectorworks Spotlight is a specialized package tailored for entertainment design professionals, offering both 2D and 3D capabilities. It is the industry-standard CAD software for entertainment design, ideal for lighting, scenery, sets, events, theater, and exhibits. Training Details: Duration: 16 hrs (flexible scheduling) Method: Personalized 1-on-1 training (In-person or Live Online over Zoom) Tailored content, adaptable pace, individual support Differences from Vectorworks Fundamentals: Vectorworks Fundamentals serves general modeling and drawing needs, while Spotlight provides comprehensive solutions for design, modeling, documentation, and collaborative project sharing, catering specifically to industry experts. Applications of Spotlight: Spotlights have diverse uses, including emergency situations and when a powerful light source surpassing a flashlight is required. Interior Designers and Vectorworks: Yes, interior designers use Vectorworks software, particularly Vectorworks Architect, for efficient workflow and effective realization of creative visions. Course Structure: Individualized Instruction (1-2-1) Customized Content Adaptable Learning Pace Flexible Scheduling: Monday to Saturday, 9 am to 7 pm Get Vectorworks: For more information and to download Vectorworks, visit Vectorworks Website. Individualized Training: Get personalized attention and tailored guidance during your training sessions. Flexible Timings: Select your preferred schedule and training days to fit your convenience. Post-Training Assistance: Access complimentary online support even after course completion. Comprehensive Resources: Receive detailed PDF notes and handouts for effective learning. Certification of Completion: Receive a recognition certificate upon successfully finishing the course. Affordable Pricing: Take advantage of budget-friendly training rates. Software Setup Support: Receive assistance in configuring the software on your device. Referral Benefits: Recommend a friend and enjoy discounts on upcoming courses. Group Training Offers: Benefit from special discounts for group training programs. Convenient Hours: Attend sessions from Monday to Sunday, with extended operating hours. Tailored Learning: Experience customized training designed to meet your specific requirements.

The Level 1 Award in Motor Vehicle Studies is designed to encourage and enable learners who have an interest in this area of study to acquire knowledge and skills to aid progression to further study or employment.

Basics to Essential Photoshop Skills Course, Master retouching, layers, color, correction, shapes, and symbols. Delve into graphic design, photo editing, and digital art. Elevate your skills from beginner to pro, gaining expertise in UX strategies, ensuring your websites are impactful and user-friendly. Click here for more info: Website Duration: 16 hours Method: Personalized 1-on-1 sessions ensure individual attention. Schedule: Customize your learning with pre-booked sessions available Monday to Saturday, from 9 am to 7 pm. Module 1: Introduction to Photoshop (2 hours) Understanding the Photoshop interface and workspace Navigating tools, panels, and menus Essential keyboard shortcuts for efficient workflow Introduction to different file formats and their uses Module 2: Basic Image Editing Techniques (2 hours) Cropping, resizing, and straightening images Color adjustments and corrections using adjustment layers Removing blemishes and distractions with healing tools Introduction to layers and blending modes Module 3: Advanced Image Manipulation (2 hours) Creating composite images with layer masks Utilizing advanced selection tools for precise editing Applying filters and special effects for creative enhancements Mastering text and typography in Photoshop Module 4: Graphic Design and Layout (2 hours) Designing banners, posters, and social media graphics Working with shapes, gradients, and patterns Creating visually appealing typography compositions Introduction to vector graphics and custom shapes Module 5: Web and UI Design (2 hours) Designing user interfaces for websites and applications Creating web-ready graphics and optimizing images Prototyping interactive elements and buttons Designing responsive layouts for various devices Module 6: Introduction to 3D and Animation (2 hours) Creating 3D objects and text Basic 3D manipulation and lighting effects Introduction to animation with the Timeline panel Exporting animations and interactive multimedia Module 7: Project-Based Learning (2 hours) Applying learned techniques to real-world projects Designing a digital artwork, website mockup, or social media campaign Receiving instructor feedback for skill refinement Final presentation of completed projects and portfolio building Upon completing our personalized Photoshop Mastery course, you'll: Master Tools: Excel in Photoshop's essential and advanced tools, including image manipulation and graphic design techniques. Design Expertise: Develop skills in creating compelling graphics, web layouts, and interactive UI designs. 3D & Animation Skills: Understand 3D manipulation, lighting, and basic animation techniques. Career Opportunities: This course prepares you for roles such as Graphic Designer, Web/UI Designer, Digital Artist, Photo Retoucher, 3D Artist, or Entrepreneur in the design industry. Dive deep into the world of Photoshop with our exclusive 1-on-1 training program. Tailored to your pace and skill level, this course offers a comprehensive understanding of Photoshop's essentials and advanced features. From image editing to graphic design and 3D manipulation, master Photoshop with personalized attention and hands-on guidance. Key Details: Personalized Attention: Enjoy dedicated 1-on-1 sessions with an experienced Photoshop instructor, ensuring focused learning and personalized guidance. Tailored Curriculum: The course content is customized based on your goals, allowing you to explore specific areas of interest and address individual challenges. Flexible Scheduling: Schedule sessions at your convenience, accommodating your busy lifestyle. Choose from weekdays or weekends, morning or evening, for a flexible learning experience. Hands-on Learning: Engage in practical, real-time exercises and projects tailored to your interests, reinforcing your skills and boosting confidence. In-depth Exploration: Cover a wide range of topics, including image editing, graphic design, 3D manipulation, web design, and more, delving deep into each area for a thorough understanding. Interactive Q&A: Participate in interactive Q&A sessions during each class, clarifying doubts and gaining valuable insights from your instructor. Lesson Recordings: Access recordings of your sessions for review and reinforcement, ensuring you grasp every concept and technique thoroughly. Ongoing Support: Benefit from continuous email support even after the course completion, receiving guidance on projects and addressing any post-training queries. Solid Foundation: Develop foundational Photoshop skills, mastering essential techniques for image editing and graphic design. Versatile Editing: Learn retouching, color correction, and photo enhancement for professional-quality results. Efficient Workflow: Optimize your work with layer management, non-destructive editing, and time-saving tricks. Creative Mastery: Harness Photoshop's power to create digital art, manipulate images, and design stunning graphics. Real-world Application: Apply skills to diverse projects like photo editing, web design, and social media graphics. Flexible Review: Access recorded lessons for convenient review of specific techniques or workflows. Lifelong Support: Enjoy lifetime email assistance for guidance, questions, and clarifications even after course completion.

AutoCAD Training for 15 hours - Live and Online The AutoCAD Training is for 15 hours that will cover from Introduction to Intermediate in small classes with only 1 people per class. AutoCAD course is for Windows or AutoCAD for MAC platforms. If you have AutoCAD for MAC, please let us know to book the specific course.  The training is tailored to your needs and we will focus the AutoCAD course on the area you want to learn.   During the training, you will receive many AutoCAD tips on how to work fast and efficient.  This live AutoCAD course will be now online at a reduced price.  You will receive a certificate of attendance at the end of the course. After the training, you can book 1 to 1 AutoCAD support to answer your questions and support your journey to learn AutoCAD. This is an extra service that you can book a minimum of 2.5 hours. Spread the cost with interest-free instalments. Buy now, pay later courses! AutoCAD Training: https://www.bimrevittraining.com/autocad-training AutoCAD Course Description AutoCAD Settings and Customization • Workspaces (AutoCAD Classic/2D Drafting & Annotation) • Background Color • Cross Air Size • New / Open and Save • User Preferences • Toolbars • Drawing Units • Drawing Limits • Snap Mode • Grid Display • Ortho Mode • Polar Tracking • Object Snap • Object Snap Tracking   AutoCAD Drawing Tools • Line • Multiple Line • Construction Line • Polyline • Polygon • Rectangle • Arc • Circle • Revision Cloud • Spline • Ellipse / Ellipse Arc • Insert Block • Make Block • Point • Hatch/Gradient • Region • Table • Multiline Text   Modify Tools • Erase • Copy • Mirror • Offset • Array • Move • Rotate • Scale • Stretch • Trim • Extend • Break at Point • Break • Join • Chamfer • Fillet • Explode   Working Methods •Object Properties •Match Properties •Layer Properties Manager •Adding Layers •Working with Layouts •External References •Insert/Edit Images •Insert PDF   AutoCAD Plotting / Publishing •Page Setup Manager •Plot Style Manager •Plotting •Publish •eTransmit

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."

Why Learn AutoCAD 3D Basics-Advanced Training Course? Course Link Learn 3D modeling, materials, lighting, and rendering, and parametric models. Learn real-world Architecture, products, mechanics. Enroll for in-person or online sessions to master AutoCAD 3D. Duration: 16 hrs Method: 1-on-1 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. "Dial 02077202581 or WhatsApp 07970325184 to reserve your preferred dates and times.  AutoCAD 3D Basics-Advanced Level 1-2-1 Training Course: Comprehensive coverage from basics to advanced techniques. Suitable for beginners and those advancing their 3D modeling skills. Personalized attention in a private learning environment. Experienced instructors with expertise in 3D modeling. Hands-on practice for confident 3D modeling. Flexible scheduling and lifetime email support. Certificate upon course completion for career advancement AutoCAD 3D Basics-Advanced Level 1-2-1 Training Course: Comprehensive coverage from basics to advanced techniques. Suitable for beginners and those advancing their 3D modeling skills. Personalized attention in a private learning environment. Experienced instructors with expertise in 3D modeling. Hands-on practice for confident 3D modeling. Flexible scheduling and lifetime email support. Certificate upon course completion for career advancement AutoCAD 3D Basics to Advanced Level Training Course Outline (10 hours): Session 1: Introduction to 3D Modeling (2 hours) Understanding 3D modeling concepts Working in the 3D Modeling Workspace Drawing 3D objects with Solid tools Extruding 2D polylines to create 3D objects Session 2: Advanced 3D Features and UCS (2 hours) Setting up AutoCAD for advanced 3D modeling Mastering the User Coordinate System (UCS) Using viewports to aid in 3D drawing Efficient modeling with Array tools Session 3: Rendering and Visualization (2 hours) Testing rendering techniques Creating a quick study rendering Simulating natural lighting and the sun Enhancing 3D models with materials and lights Session 4: Editing 3D Solids and Mesh Modeling (2 hours) Understanding solid modeling principles Creating and editing basic solid forms Editing 3D solids and streamlining 2D drawing process Exploring 3D mesh modeling and editing The AutoCAD 3D training course provides a comprehensive understanding of 3D modeling, visualization, and rendering. Participants will learn to create complex 3D models, render realistic visuals, and efficiently customize the AutoCAD interface for improved productivity. Master 3D Modeling: From basics to advanced techniques. Realistic Rendering: Achieve lifelike visualizations. Professional Presentations: Dynamic walkthroughs and showcases. Enhanced Career Opportunities: Stronger prospects in design fields. Personalized Learning: One-to-one attention for focused training. Practical Hands-On Practice: Building confidence in 3D modeling. Lifetime Email Support: Ongoing assistance beyond the course. Certification: Proof of proficiency in AutoCAD 3D modeling.

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

Live online course with study materials and certificate of completion included This HTML course will provide you with an easy to follow, hands-on introduction to HTML and CSS, the basic coding languages which drive the internet. Participants will learn how to create an attractive and well-structured web page using basic HTML and CSS. This workshop is highly recommended for anyone wishing to learn how to create websites and also for people who already use applications such as Dreamweaver or WordPress and need more control over their web output. Resources Introduction to HTML & CSS Course Information Description Completing this course will enable you to do the following and more: Understand what HTML and CSS are and how they work together Learn basic HTML elements Learn how to create hyperlinks Work with images Use DIVs, forms and lists to arrange content Create page structure Use Cascading Style Sheets to control the layout and look of HTML elements Use Developer Tools to preview CSS changes Know how and when to use Inline CSS Create code that is both readable, compliant with HTML5 standards Understand what makes good SEO For the full course content please download the course information pdf listed above. Who is this course for? This workshop is suitable for anyone with basic PC or Mac skills who wants to understand how the web works. No previous knowledge or experience of HTML or CSS is necessary. Requirements Attendees should have basic PC or Mac skills. You will need a broadband internet connection to participate in this live online course. Certificates Certificate of completion Digital certificate - Included

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 Certificates Certificates Certificate of completion Digital certificate - Included