14743 Courses

Duration 2 Days 12 CPD hours This course is intended for This course is designed for students who already have foundational knowledge and skills in Excel and who wish to perform robust and advanced data and statistical analysis with Microsoft Excel using PivotTables, use tools such as Power Pivot and the Data Analysis ToolPak to analyze data, and visualize data and insights using advanced visualizations in charts and dashboards in Excel. To ensure success, you should have baseline skill using Microsoft Excel worksheets, particularly in creating workbooks with formulas and function Overview #NAME? Analyzing data to find issues, insights and opportunities, is now a critical part of many job roles. Beyond the analysis, data analysts in all job roles must be able to effectively present and communicate their findings in visually compelling ways. Microsoft© Excel© is designed for this purpose. Excel can connect to a wide range of data sources, perform robust data analysis and create diverse and robust data-backed visualizations to show insights, trends, and create reports. These capabilities enable people who use Excel for data analysis to turn data into thoughtful action. 1 - DATA ANALYSIS FUNDAMENTALS Introduction to Data Science Create and Modify Tables Sort and Filter Data 2 - VISUALIZING DATA WITH EXCEL Visualize Data with Charts Modify and Format Charts Apply Best Practices in Chart Design 3 - ANALYZING DATA WITH FORMULAS AND FUNCTIONS Analyze Data with Formulas and Named Ranges Analyze Data with Functions Implement Data Validation, Forms, and Controls Create Conditional Visualizations with Lookup Functions 4 - ANALYZING DATA WITH PIVOTTABLES Create a PivotTable Analyze PivotTable Data 5 - PRESENTING VISUAL INSIGHTS WITH DASHBOARDS IN EXCEL Visualize Data with PivotCharts Filter Data Using Slicers and Timelines Create a Dashboard in Excel 6 - CREATING GEOSPATIAL VISUALIZATIONS WITH EXCEL Create Map Charts in Excel Customize Map Charts in Excel 7 - PERFORMING STATISTICAL ANALYSIS Visualize Trendlines and Sparklines with Excel Analyze Data with the Data Analysis ToolPa 8 - GETTING AND TRANSFORMING DATA Connect to Data with Queries Clean and Combine Data Shape and Transform Data 9 - MODELING AND ANALYZING DATA WITH POWER PIVOT Install Power Pivot in Excel Create Data Models with Power Pivot Create Power Pivots Perform Advanced Data Analysis and Visualization 10 - PRESENTING INSIGHTS WITH REPORTS (OPTIONAL) Plan a Report Create a Report

Diploma in Maritime Business: 100% on line - start whenever you want - attend at your pace - from anywhere and anytime. Register today!

Photoshop Training Course Basics to Advanced designed for individuals of every skill level, ranging from beginners to advanced image editing professionals. Immerse yourself in the realm of potent image manipulation tools at our school in London. Personalized Photoshop courses either at our facility or directly at your location. Click here for more info: Website Duration: 20 hours. Method: Personalized 1-on-1. Schedule: Customize your learning with pre-booked sessions available Monday to Saturday, from 9 am to 7 pm. Course Title: Mastering Photoshop: From Basics to Advanced Proficiency Course Duration: 20 hours Module 1: Introduction to Photoshop (2 hours) Understanding the Photoshop interface Navigating tools and panels Basic keyboard shortcuts for efficient workflow Introduction to different file formats and their uses Module 2: Essential Tools and Techniques (3 hours) Selection tools and techniques for precise editing Working with layers: management and blending modes Understanding brushes, gradients, and patterns Introduction to basic filters and their applications Module 3: Image Editing and Retouching (4 hours) Color correction and adjustment layers Advanced retouching techniques: Healing Brush, Clone Stamp, and Content-Aware tools Removing backgrounds and unwanted elements Restoring old or damaged photographs Module 4: Advanced Photo Manipulation (3 hours) Compositing multiple images seamlessly Advanced blending modes and layer effects Creative use of masks and clipping paths Special effects: lighting, shadows, and reflections Module 5: Text and Typography (2 hours) Working with text layers and formatting options Creating custom typography and text effects Utilizing layer styles for creative text designs Text manipulation along paths and shapes Module 6: Web and UI Design (3 hours) Designing web banners, buttons, and interfaces Slicing and optimizing images for the web Creating interactive prototypes and mockups Exporting assets for web and app development Module 7: Print Design and Prepress (2 hours) Understanding color modes: CMYK vs. RGB Setting up documents for print: bleed, margins, and resolution Designing print materials: brochures, business cards, and posters Preparing files for professional printing Module 8: Project-Based Learning (1 hour) Applying learned techniques to real-world projects Instructor-led project: creating a digital artwork or advertisement Feedback and critique session for skill refinement Final presentation of completed projects Upon completion, you will: Master Photoshop Skills: Gain proficiency in fundamental and advanced Photoshop techniques, enabling professional-level image editing and creative design. Enhance Creativity: Develop creative problem-solving abilities, enabling innovative and visually appealing design solutions. Job Opportunities: Graphic Designer: Craft compelling visual content for ads, websites, and marketing materials. Photo Retoucher: Edit and enhance photographs to meet professional standards. Digital Artist: Create digital artwork and illustrations for various purposes. Web/UI/UX Designer: Design user-friendly interfaces and engaging online experiences. Marketing Content Creator: Generate eye-catching promotional visuals and social media content. Video Editor: Enhance video footage and create engaging video content for online platforms. Professional Adobe Photoshop Training in London - On-Site & Live Virtual Classes Being the industry-leading image editing software, Photoshop empowers users to manipulate images, enhance colors, and create visually striking designs. Its extensive toolkit allows for intricate adjustments, retouching, and even editing videos, graphic design, and 3D imagery. Enroll in our Photoshop course to establish a strong foundation in creative visuals, focusing on essential skills like image adjustment, composition, and common troubleshooting. For a more in-depth understanding, our Advanced course delves into advanced techniques such as color fills, text and layer styling, and creating web-ready artwork. Explore our masterclass options for advanced training and deeper insights. Both beginner courses are available in physical classrooms and online, providing flexible learning opportunities.   Holistic Design Education: Comprehensive training across diverse design fields. Industry-Experienced Instructors: Learn from seasoned professionals in the field. Flexible Learning: Accommodating schedules for busy professionals and students. Practical Projects: Hands-on projects for real-world design experience. Career-Focused Skills: Acquire industry-relevant skills for professional growth. Cutting-Edge Facilities: Access state-of-the-art technology and facilities. Personalized Training: Tailored programs to suit individual learning needs. Networking Opportunities: Connect with design professionals for valuable connections. Innovation Exploration: Explore creative trends and emerging technologies. Ongoing Support: Continuous assistance and post-course guidance.

Course Overview Take your business to new levels of excellence and find the best recruits in the marketplace by taking this Hiring For Your Teams Masterclass. An organisation is nothing without committed and talented employees who work together to realise a shared vision and provide fantastic service. This course uses expert tuition for guiding you towards the best recruitment approaches for your company and new ways of finding the right staff for the right jobs. This Recruitment tutorial covers all of the critical aspects of the hiring and induction process, making your choices that much easier and your range of candidates that much more accessible. From conducting interviews to identifying the potential in a recruit, every significant skill is presented and explored, allowing you to gain mastery of the process and have the ability to pick the most talented individuals in the sector. Enrol now to become a recruiting expert. This best selling Hiring For Your Teams Masterclass has been developed by industry professionals and has already been completed by hundreds of satisfied students. This in-depth Hiring For Your Teams Masterclass is suitable for anyone who wants to build their professional skill set and improve their expert knowledge. The Hiring For Your Teams Masterclass is CPD-accredited, so you can be confident you're completing a quality training course will boost your CV and enhance your career potential. The Hiring For Your Teams Masterclass is made up of several information-packed modules which break down each topic into bite-sized chunks to ensure you understand and retain everything you learn. After successfully completing the Hiring For Your Teams Masterclass, you will be awarded a certificate of completion as proof of your new skills. If you are looking to pursue a new career and want to build your professional skills to excel in your chosen field, the certificate of completion from the Hiring For Your Teams Masterclass will help you stand out from the crowd. You can also validate your certification on our website. We know that you are busy and that time is precious, so we have designed the Hiring For Your Teams Masterclass to be completed at your own pace, whether that's part-time or full-time. Get full course access upon registration and access the course materials from anywhere in the world, at any time, from any internet-enabled device.  Our experienced tutors are here to support you through the entire learning process and answer any queries you may have via email.

Course Overview Learn how to create an impact with presentations and make your projects burst into life with this training for creating Animated Lettering in Procreate. Procreate is the graphics editor app chosen by professionals for digital imagery and artistic potential in their assignments. You will be given expert tuition to move, enhance, and dazzle the readers of your work with visual flourishes that can bring high levels of attention to brands and content.  This Procreate course guides you step-by-step with full support until you are able to make words appear on the screen with dynamic handwriting or inventive movements. With a single word, a phrase, or a title, you will be shown how to use Procreate to make an entrance with them and catch the audience's eyes. Whether this skill is needed for personal or commercial use, its use is guaranteed to appeal to everyone and ensure your talents are noticed. This best selling Animated Lettering in Procreate has been developed by industry professionals and has already been completed by hundreds of satisfied students. This in-depth Animated Lettering in Procreate is suitable for anyone who wants to build their professional skill set and improve their expert knowledge. The Animated Lettering in Procreate is CPD-accredited, so you can be confident you're completing a quality training course will boost your CV and enhance your career potential. The Animated Lettering in Procreate is made up of several information-packed modules which break down each topic into bite-sized chunks to ensure you understand and retain everything you learn. After successfully completing the Animated Lettering in Procreate, you will be awarded a certificate of completion as proof of your new skills. If you are looking to pursue a new career and want to build your professional skills to excel in your chosen field, the certificate of completion from the Animated Lettering in Procreate will help you stand out from the crowd. You can also validate your certification on our website. We know that you are busy and that time is precious, so we have designed the Animated Lettering in Procreate to be completed at your own pace, whether that's part-time or full-time. Get full course access upon registration and access the course materials from anywhere in the world, at any time, from any internet-enabled device.  Our experienced tutors are here to support you through the entire learning process and answer any queries you may have via email.

Catering to the demands of busy professionals, our virtual training programs are as effective as face-to-face learning. For more queries, reach out to us: info@mangates.com

Catering to the demands of busy professionals, our virtual training programs are as effective as face-to-face learning. For more queries, reach out to us: info@mangates.com

Catering to the demands of busy professionals, our virtual training programs are as effective as face-to-face learning. For more queries, reach out to us: info@mangates.com

Catering to the demands of busy professionals, our virtual training programs are as effective as face-to-face learning. For more queries, reach out to us: info@mangates.com

Catering to the demands of busy professionals, our virtual training programs are as effective as face-to-face learning. For more queries, reach out to us: info@mangates.com