2175 Courses in Cardiff delivered Live Online

Adobe Illustrator and Photoshop Masterclass Training, your gateway to Photoshop and Illustrator. Learn with the best software for publishing and marketing materials. This comprehensive training covers Photoshop, Illustrator, and InDesign, offering step-by-step tutorials tailored for creative professionals. Click here for more info: Website Duration: 10 hours Approach: Individualized, Tailored Content, Flexible Pace, Personal Support Scheduling Flexibility: 1-on-1 sessions from Mon to Sat, 9 am to 7 pm, based on your availability. Course Title: Adobe Photoshop and Illustrator Mastery Workshop Duration: 10 Hours (Divided into 10 Modules) Module 1: Introduction to Adobe Photoshop (1 hour) Familiarization with Photoshop interface and tools Understanding bitmap graphics and resolution Basic image editing techniques (cropping, resizing, color adjustments) Significance of layers in design Module 2: Essential Photoshop Tools (1 hour) Mastery of selection tools (Marquee, Lasso, Magic Wand) Understanding brushes and their settings Introduction to the Pen tool for precise selections Working adeptly with layers and layer styles Module 3: Advanced Image Editing (1 hour) Proficiency in advanced color adjustments (Curves, Levels, Hue/Saturation) Techniques for photo retouching and manipulation Creating composite images using blending modes Application of filters and special effects for creative designs Module 4: Introduction to Adobe Illustrator (1 hour) Exploration of Illustrator interface and tools Working with vector graphics and paths Basic shapes and drawing tools Understanding anchor points and handles Module 5: Creating Vector Artwork (1 hour) Expert use of the Pen tool for precise vector illustration Creating and editing shapes and objects Mastery in handling gradients and patterns Understanding the Appearance panel Module 6: Illustrator Typography (1 hour) Text tools and advanced formatting options Crafting text effects and artistic typography Integration of text with shapes and images Working adeptly with text on a path Module 7: Combining Photoshop and Illustrator (1 hour) Importing Illustrator files into Photoshop and vice versa Efficient use of smart objects and vector shapes in Photoshop Creation of custom brushes and patterns in Illustrator for seamless use in Photoshop Designing posters and flyers by combining elements from both software Module 8: Integration with InDesign (1 hour) Exporting assets from Photoshop and Illustrator for InDesign Crafting layouts in InDesign using assets from both programs Understanding print and digital design nuances Preparing files for printing and online use Module 9: Advanced Techniques and Tips (1 hour) Creating custom actions and automation in Photoshop Mastery in advanced selection techniques Utilizing Illustrator's advanced tools (Pathfinder, Shape Builder, etc.) Exploration of creative design styles and trends Module 10: Final Projects and Portfolio (1 hour) Individual or group projects incorporating Photoshop and Illustrator skills Detailed review and feedback on the projects Preparation of a portfolio showcasing the work   Upon completion of the Adobe Photoshop and Illustrator Mastery Workshop, participants will: Master Advanced Design Techniques: Acquire expert skills in both Adobe Photoshop and Illustrator, delving into advanced tools, filters, and effects for intricate design work. Seamlessly Integrate Software: Learn to seamlessly integrate Photoshop and Illustrator, enabling the creation of dynamic and visually appealing designs by leveraging the unique strengths of both programs. Develop Creative Problem-Solving: Cultivate creative problem-solving abilities by exploring diverse design styles and industry-relevant trends, empowering the creation of innovative and captivating visuals. Construct Professional Portfolios: Gain the expertise to construct professional portfolios, showcasing a diverse range of projects incorporating advanced Photoshop and Illustrator techniques. Collaborate on Real-World Projects: Collaborate effectively on real-world design projects, combining Photoshop and Illustrator skills to produce high-quality marketing materials, promotional content, and digital artwork. Career Opportunities: Upon mastering Photoshop and Illustrator, participants can pursue a range of creative careers, including: Graphic Designer: Craft visually appealing designs for print and digital media, ranging from marketing materials to social media graphics. Digital Illustrator: Create intricate digital illustrations and artworks for various applications, including book covers, digital publications, and games. Web Designer: Develop engaging and user-friendly website layouts and elements, optimizing user experience through appealing visuals. Advertising Artist: Design compelling advertisements for print and online platforms, captivating audiences and promoting brands effectively. Freelance Designer: Work as a freelance designer, taking on diverse projects from clients and agencies, showcasing versatility in both Photoshop and Illustrator skills. By mastering these Adobe tools, participants open doors to a multitude of creative opportunities in the ever-expanding digital design industry. Skills Acquired: Participants in the Adobe Illustrator and Photoshop Masterclass Training will develop advanced skills in vector graphics, digital illustration, and photo manipulation using Adobe Illustrator and Photoshop. Key skills include: Precision Vector Graphic Design in Illustrator Creative Digital Illustration Techniques Advanced Photo Editing and Manipulation in Photoshop Job Opportunities: Upon completion, individuals can pursue roles such as: Graphic Designer Digital Illustrator Advertising Creative Branding Specialist Elevate Your Design Skills: Master Adobe Illustrator and Photoshop, crafting stunning graphics, logos, and digital illustrations. Understand design principles, tools, and workflows. Receive a recognized Certificate of Completion and access recorded lessons for future reference. Expert Guidance, Your Schedule: Learn from certified experts, tailored to your timetable-flexible online or in-person sessions, Monday to Sunday, 9 am to 8 pm. Enjoy lifetime email support for seamless learning. Unleash Your Creativity Today: Enroll now to ignite your creative potential in Adobe Illustrator and Photoshop. Elevate your designs effortlessly.

The course will be delivered through 9 online virtual classroom sessions. The 10th and last session will involve the additional practical work for the course as well as the written examination (multiple choice for City & Guilds and written for Hi-Tech Training) which will take place at our training centre at 43 North Great Georges Street, Dublin 1 (completed online for non ROI learners). During the virtual classroom sessions, trainees will have a live video feed with their instructor talking to them, doing practical live demonstrations on equipment being involved actively in the learning. We will send out a practical kit so that trainees can complete assignments and practical work at home. The kit is the property of Hi-Tech Training and will be returned to Hi-Tech Training on the last day of the course. (The kits may also be purchased by the learner….see the Kits Page Link for more details). The kit consists of power supply unit breadboard, multimeter, cables, The kit consists of breadboard, multimeter, oscilloscope, battery and connectors, components including resistors, LEDs and ICs (AND, NAND, OR, NOR, X-OR, X-NOR, Inverter, Buffer, Latches, Flip-Flops, Timers, etc). Trainees will build various projects as part of the course. The kit forms an integral part of the course, so full course fees need to be paid at least 7 days prior to course commencement to allow time to ship the kit in time for the course.

The 3-day course is designed to deliver a complete knowledge of the PRINCE2® 7th Edition methodology to the participants. The course prepares you for the exam to obtain the international PRINCE2® 7th Edition Foundation certificate issued by the accrediting organization. PRINCE2® 7th Edition Foundation course offered by Advised Skills Ltd is accredited by PeopleCert, on behalf of AXELOS, based upon Partner's Agreement and complies with the accreditation requirements.

Why Choose V-Ray for Rhino Essentials Training? Master photorealistic rendering in Rhino with our intensive V-Ray training. Led by certified experts, learn lighting, material manipulation, rendering configurations, textures, and global illumination.  Check our Website Training Duration: 10 hours Approach: 1-on-1, in-Person and Live online and Customized Content.   Flexibility: 1-on-1 sessions scheduled at your convenience, from Mon to Sat between 9 am and 7 pm. Vray for Rhino Essentials - 10 Hours Course Session 1: Introduction to Vray and Rhino Integration Overview of Vray: Understanding its importance in architectural and product visualization. Setting up Vray in Rhino: Installation, basic configurations, and interface exploration. Understanding the Rhino-Vray workflow: Navigating between Rhino and Vray seamlessly. Session 2: Basic Lighting Techniques Exploring different light sources: Domes, spotlights, and area lights. Adjusting light intensity and color temperature for realistic ambiance. Creating natural lighting scenarios: Daylight, twilight, and night scenes. Session 3: Mastering Material Creation Introduction to Vray materials: Diffuse, reflection, refraction, and bump maps. Crafting realistic materials: Wood, glass, metal, and fabrics. Utilizing the material editor efficiently for precise adjustments. Session 4: Advanced Rendering Configurations Global Illumination: Understanding photon mapping and irradiance mapping. Fine-tuning render settings: Quality vs. speed, resolution, and anti-aliasing. Exploring Vray frame buffer: Post-processing and image enhancement. Session 5: Texture Manipulation and Mapping Understanding UV mapping: Unwrapping complex geometries for accurate textures. Applying textures in Vray: Diffuse, bump, displacement, and normal maps. Realistic texture manipulation: Scaling, rotation, and blending textures seamlessly. Session 6: Camera Settings and Scene Composition Camera configurations: Focal length, depth of field, and exposure settings. Composing visually appealing scenes: Rule of thirds, focal points, and balance. Rendering interior and exterior scenes: Managing lighting challenges and reflections. Session 7: Real-Time Feedback and Interactive Rendering Introduction to Vray interactive rendering: Real-time feedback for quick adjustments. Utilizing Vray's denoiser for noise reduction in interactive mode. Enhancing productivity with interactive rendering: Modifying materials and lighting on the fly. Session 8: Optimizing Render Times Efficient render optimization techniques: Reducing noise and enhancing quality. Distributed rendering: Utilizing multiple machines for faster rendering. Troubleshooting common rendering issues: Flickering, artifacts, and texture problems. Session 9: Post-Processing and Presentation Post-production in Photoshop: Enhancing renders, adding depth, and adjusting colors. Creating compelling visual narratives: Adding people, context, and atmosphere. Designing professional presentation boards: Layout, annotations, and graphic elements. Session 10: Final Project and Portfolio Review Participants showcase their final Vray-rendered projects. Instructor-led critique and feedback session. Tips for building a strong portfolio: Choosing the best renderings and presenting your work effectively. By the end of this 10-hour course, participants will have a comprehensive understanding of Vray for Rhino, enabling them to create photorealistic renderings and significantly enhance their design visualization skills. Upon completing the Vray for Rhino Essentials course, participants will: Master Lighting Techniques: Expertly utilize various light sources. Create realistic lighting scenarios for diverse scenes. Advanced Material Proficiency: Manipulate complex materials and textures for lifelike renders. Understand reflective surfaces and material interaction. Optimize Rendering Settings: Fine-tune render configurations for optimal quality and speed. Implement noise reduction techniques for cleaner renders. Texture Mapping Mastery: Perfect UV mapping methods for accurate texture application. Seamlessly blend textures for realistic surface mapping. Effective Camera Use and Composition: Configure camera settings, depth of field, and exposure. Compose visually appealing scenes for impactful renders. Real-Time Rendering Skills: Utilize interactive rendering for immediate feedback and adjustments. Enhance scenes in real time for efficient workflow. Post-Processing Expertise: Enhance renders in post-production using software tools. Add depth, adjust colors, and create visually compelling final images. Professional Presentation Techniques: Design layouts, annotations, and context to create impactful visual narratives. Curate a strong portfolio with the best-rendered projects. By honing these skills, participants will produce photorealistic renders and significantly enhance their architectural and product visualization capabilities. Skills You'll Gain: Master lighting techniques for realistic visualization. Learn material manipulation and texture enhancement in Vray. Understand advanced rendering configurations for high-quality results. Explore global illumination concepts for lifelike scenes. Career Opportunities: Upon completing Vray for Rhino Essentials, you'll be well-equipped for various roles in the design and visualization industry, including: Architectural Visualizer: Create stunning architectural visualizations for presentations and client approvals. Product Designer: Enhance product design by creating photorealistic prototypes and visualizations. Interior Designer: Craft immersive interior spaces with realistic lighting and material textures. 3D Visualization Artist: Work in animation studios, gaming companies, or marketing agencies, producing high-quality 3D visualizations. Freelance Rendering Specialist: Offer your skills on platforms like Upwork or Fiverr, providing rendering services to clients worldwide. Course Highlights: Acquire fundamental skills in V-Ray for Rhino, covering lighting, materials, and rendering setups. Explore advanced techniques for lifelike textures, reflections, and global illumination effects. Master the workflow for crafting architectural renderings, both interior and exterior. Harness the power of V-Ray features like proxies, fur, and particle systems for dynamic visuals. Optimize render times and quality using efficient techniques and expert tips. Validate your expertise with a Certificate of Completion, showcasing your V-Ray proficiency. Access recorded lessons for future reference, enabling self-paced learning and continuous improvement. Professional Guidance: Learn from certified tutors and industry experts with extensive practical experience. Gain valuable insights and personalized feedback as you progress through the course, ensuring a comprehensive understanding of V-Ray for Rhino.

Learn how to use this powerful tool to import and clean data and create some amazing visuals. Course overview Duration: 2 days (13 hours) Power BI Desktop is a powerful tool for working with your data. It enables you to import multiple data sources and create effective visualisations and reports. This course is an introduction to Power BI to get you started on creating a powerful reporting capability. You should have a good working knowledge of Excel and managing data before attending. Objectives  By the end of the course you will be able to: Import data from multiple data sources Edit and transform data before importing Create reports Create different visualisations Create data models Build data relationships Use the drill down features Create measures Use the Power BI Service Build dashboards Use the mobile app Content Essentials Importing Data Power BI Overview Data sources Importing data Transforming Your Data Editing your data Setting data types Removing columns/rows Choosing columns to keep Setting header rows Splitting columns Creating Reports Creating and saving reports Adding pages Renaming pages Interactivity Refreshing your data Adding Columns Columns from example Custom columns Conditional columns Append Queries Importing folders Setting up and using append queries Creating Chart Visualisations Adding chart elements Choosing chart types Setting properties Setting values, axis and legends Using tooltips Visual filters Setting page and report filters Creating Tables, Cards, Gauges and Maps Adding table elements Adding maps Working with cards Working with matrices KPIs and Gauges Conditional Formatting Setting rules Removing conditional formatting   Working with Data Models Merge Queries Setting up and using merge queries Merging in columns of data Creating a Data Model The data model Multiple data tables Connecting tables Building relationships Relationship types Building visuals from multiple tables Unpivoting Data Working with summary data Unpivoting data Using Hierarchies Using built in hierarchies Drill down Drill up See next level Expand a hierarchy Create a new hierarchy Grouping Grouping text fields Grouping date and number fields Creating Measures DAX functions DAX syntax Creating a new measure Using quick measures Using the PowerBI Service Shared workspaces My workspace Dashboards Reports Datasets Drill down in dashboards Focus mode Using Q&A Refreshing data Using Quick Insights Power BI Mobile App Using the Power BI Mobile App

Why Choose Character Animation in 3ds Max Training Course? Click here for more info. Top character animation course in 3ds Max, this course provides an accessible learning experience. Learning character animation enables you to create your own short films. It's not just a means of income; it evolves into a passion.  Duration: 20 hrs Method: 1-on-1, Personalized attention. Schedule: Tailor your own hours of your choice, available from Monday to Saturday between 9 am and 7 pm. Enroll in our exclusive "Character Animation Fundamentals in 3ds Max" course at London Design Training, guided by experienced tutors Sitwat Ali, Qasim Ali, and Jess. Gain in-depth insights into animating 3D characters, covering essential techniques like character rigging, pose creation, and seamless pose-to-pose animation. 3ds Max Character Animation Course Duration: 20 hours Course Overview: Master the art of character animation in 3ds Max with our comprehensive course. Ideal for beginners and those with some 3D modeling and animation experience, this course covers everything you need to know to bring characters to life. Course Outline: Introduction to Character Animation Explore animation principles Get familiar with 3ds Max animation tools Learn to create character rigs and manage the timeline Basic Animation Principles Understand keyframes and animation cycles Apply the 12 principles of animation Work with the graph editor and ease-in/out techniques Advanced Animation Techniques Utilize the reaction manager for complex animations Master non-linear animation methods Animate with inverse kinematics, custom controllers, expressions, and scripts Creating Characters Craft a character model with proper topology Create UV maps and apply textures Prepare characters for rigging Facial Animation Learn facial animation principles Create blend shapes and morph targets Master lip syncing techniques Body Animation Animate walk cycles and character motion Achieve believable character poses Implement character physics Advanced Character Animation Work with motion capture data Use CAT and Biped tools Understand motion blur and create special effects Render and output animations Character Animation Projects Bring all skills together in practical projects Create basic and complex character animations Course Requirements: Computer with 3ds Max installed Basic computer operations knowledge Passion for character animation Course Goals: Upon completion, you'll have a thorough grasp of character animation in 3ds Max, capable of creating realistic and sophisticated character animations using advanced techniques. You'll be equipped with the skills to continue honing your character animation abilities independently.

Learn AutoCAD Evening Training Course. Clickhere for info This Autodesk AutoCAD 2D Introduction Evening Course is ideal for students who are completely new to the software and for those looking to produce advanced 2D plans, elevations and sections, as well as understanding all key tools in AutoCAD 2D. Call 02077202581 or WhatsApp 07970325184. Duration: 10 hrs. Method: 1-on-1, Personalized attention Schedule: Tailor your own slots, available from Mon to Sat between 9 am and 7 pm. Flexible Evening Sessions: Learn at your pace with evening classes. Comprehensive Skill Development: Master 2D Plans, Sections and Elevations. Industry-Standard Knowledge: Gain proficiency sought by employers. Practical Application: Apply skills to real-world design scenarios. Recorded Lessons for Review: Revisit course material anytime. Lifetime Email Support: Get ongoing assistance even after course completion. Course Duration: 10 hours Course Overview: AutoCAD 2D Training Course Designed for beginners, this course teaches the fundamentals of AutoCAD 2D software. Participants will learn essential tools and features to create, edit, and annotate 2D drawings. By course completion, students will confidently produce their own 2D drawings using AutoCAD. Introduction to AutoCAD 2D Overview of AutoCAD 2D software Understanding the user interface Navigating the drawing area Setting up drawing units and limits Creating basic shapes and lines Drawing Tools Utilizing Line, Circle, and Arc tools Implementing Polyline and Spline tools Adding dimensions and annotations Understanding layers and object properties Creating and inserting blocks into drawings Editing Tools Using Erase, Move, and Copy tools Implementing Rotate and Scale tools Understanding grips and grip editing Utilizing Trim and Extend tools Exploring fillets and chamfers Advanced Drawing Tools Utilizing Offset and Mirror tools Implementing Array and Divide tools Understanding hatching and gradient fills Adding text and multiline text Incorporating tables and fields into drawings Final Project Completing a final project using all learned tools and features Instructor-guided process to create a personal 2D drawing with AutoCAD Q&A and review of course material Assessment: Submission of the final project Active participation in class exercises and discussions Requirements: AutoCAD 2D software installed on the student's computer Basic computer skills and familiarity with the Windows operating system A laptop or desktop computer with a minimum of 4GB RAM and a 64-bit operating system.

When staff are new to sales it can seem daunting, especially when they have targets to meet. If the staff you need to promote your products and services get it wrong then it can knock their confidence and negatively impact how your customers see you as an organisation. This programme provides staff with the basic skills they need to sell. This course will help participants: Profile customers Research and identify potential new customers Use the consultative sales process Build effective rapport with customers Identify customer needs through effective questioning and listening Position products and services effectively Close the sale or gain commitment to further action Manage their customer portfolio to maximise sales 1 Introduction Aims and objectives of the training Personal introductions and objectives Self-assessment of existing sales skills Overview of content 2 Knowing your customers Who are your customers, and what do they want from you? What are your strengths, compared to your competitors? Who are your new potential customers? How do you communicate with new customers? What do you need to know about your customers before you start to sell? Making the initial approach Planning your pipeline - keeping the customers coming 3 The four-step sales process Overview of the consultative sales process Key benefits of using the consultative sales process Focusing on behaviours not targets The behaviours of a good salesperson Common pitfalls and mistakes Personal strengths and weaknesses 4 Building rapport First impressions - Mehrabian theory of communication Short cuts to building rapport Looking out for clues as to how the customer is thinking Looping back to keep the conversation flowing Acknowledging past communication Dealing with emotions such as anger Setting the agenda to keep control Getting past gatekeepers 5 Questioning and listening How to ask open questions to uncover information Left brain questions When closed question can be useful What stops us listening? The four levels of listening How to develop your listening skills 6 Presenting products and services to customers When to present Using benefits not features Making it personal Using reciprocity The tendency towards the middle Using consistency 7 Gaining commitment Testing the water Dealing with objections using ACLEO Asking for the business Getting referrals Ending with a personalised close Following-up 8 Managing your customer pipeline Spotting opportunities for cross-sales Managing your portfolio Maximising sales proactively Review meetings Customer satisfaction measures and surveys Mystery shopping 9 Putting it all together Skills practice Personal learning summary and action plans

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

This course starts with the basics then moves seamlessly to an intermediate level. It includes a comprehensive yet balanced look at the four main components that make up Power BI Desktop: Report view, Data view, Model view, and the Power Query Editor. It also demonstrates how to use the online Power BI service. It looks at authoring tools that enables you to connect to and transform data from a variety of sources, allowing you to produce dynamic reports using a library of visualisations. Once you have those reports, the course looks at the seamless process of sharing those with your colleagues by publishing to the online Power BI service. The aim of this course is to provide a strong understanding of the Power BI analysis process, by working with real-world examples that will equip you with the necessary skills to start applying your knowledge straight away. 1 Getting started The Power BI process Launching Power BI Desktop The four views of Power BI Dashboard visuals 2 Connecting to files Connect to data sources Connect to an Excel file Connect to a CSV file Connect to a database Import vs. DirectQuery Connect to a web source Create a data table 3 Transforming data The process of cleaning data Column data types Remove rows with filters Add a custom column Append data to a table Fix error issues Basic maths operations 4 Build a data model Table relationships Manage table relationships 5 Merge queries Table join kinds Merging tables 6 Create report visualisations Creating map visuals Formatting maps Creating chart visuals Formatting chart Tables, matrixes, and cards Control formatting with themes Filter reports with slicers Reports for mobile devices Custom online visuals Export report data to Excel 7 The power query editor Fill data up and down Split columns by delimiter Add conditional columns Merging columns 8 The M formula Creating M functions Create an IF function Create a query group 9 Pivot and unpivot tables Pivot tables in the query editor Pivot and append tables Pivot but don't summarise Unpivot tables Append mismatched headers 10 Data modelling revisited Data model relationships Mark a calendar as a date table 11 Introduction to calculated columns New columns vs. measures Creating a new column calculation The SWITCH function 12 Introduction to DAX measures Common measure categories The SUM measure Adding measures to visuals COUNTROWS and DISINCTCOUNT functions DAX rules 13 The CALCULATE measure The syntax of CALCULATE Things of note about CALCULATE 14 The SUMX measure The SUMX measure X iterator functions Anatomy of SUMX 15 Introduction to time intelligence Importance of a calendar table A special lookup table The TOTALYTD measure Change year end in TOTALYTD 16 Hierarchy, groups and formatting Create a hierarchy to drill data Compare data in groups Add conditional formatting 17 Share reports on the web Publish to the BI online service Get quick insights Upload reports from BI service Exporting report data What is Q&A? Sharing your reports 18 Apply your learning Post training recap lesson