880 Courses delivered Live Online

Microsoft Excel® in Depth (Virtual) This practical course provides a solid background of the features of Excel and a deeper understanding of its features, benefits and uses.This is not a beginner's course in Excel. You will learn some advanced features such as Pivot Tables, Charting, Tables, Sorting, Filtering and Functions. The goal of this course is to provide a deeper understanding of Excel and its intricacies and a new ability to use it efficiently producing the best solutions for your projects. What you will Learn You'll learn how to: Use functions like IF, AVERAGE, SUMIF, SUMIFS, SUMPRODUCT, INDEX, MATCH, CHOOSE, DATE, and many more Create meaningful charts Use pivot tables Use Conditional Formatting, Data Validation Take advantage of using Named ranges, do sorting, filtering, tables

Microsoft Excel® in Depth: Virtual In-House Training The goal of this course is to provide a deeper understanding of Excel and its intricacies and a new ability to use it efficiently producing the best solutions for your projects. This practical course provides a solid background of the features of Excel and a deeper understanding of its features, benefits and uses. This is not a beginner's course in Excel. You will learn some advanced features such as Pivot Tables, Charting, Tables, Sorting, Filtering and Functions. The goal of this course is to provide a deeper understanding of Excel and its intricacies and a new ability to use it efficiently producing the best solutions for your projects. What you Will Learn You'll learn how to: Use functions like IF, AVERAGE, SUMIF, SUMIFS, SUMPRODUCT, INDEX, MATCH, CHOOSE, DATE, and many more Create meaningful charts Use pivot tables Use Conditional Formatting, Data Validation Take advantage of using Named ranges, do sorting, filtering, tables Getting Started The building blocks of Excel, built-in functions, will be examined The basics of formatting your data will be examined Shortcuts and data manipulation will be explored Built-in features like those mentioned in the 'What you will learn' section above will be explored in detail Excel Functions - VLOOKUP, IF, INDEX, MATCH, CHOOSE, SUMIF, SUMIFS, SUMPRODUCT, DATE, so many more Using Named ranges, Data Validation, Sorting, and Filtering Learn the Name manager; Learn the difference between local and global names; Ensure correct access to linked workbooks; Ensure data accuracy; Learn how to use cascading data validation (for example, once a user chooses 'cars', another cell allows only Ford, Toyota, etc.); Sorting by more than 3 fields; Filtering by font, pattern, or value; See your data based on things like dates in the 3rd quarter, or fields where quantity x price is greater than some fixed value Conditional formatting and data formatting Make relevant data stand out Isolate highs and lows Make error cells invisible Learn about Data bars, Icon sets, and Color scales Highlight differences between worksheets Learn all the codes in the Format/Number list Using cell Styles Learn all about alignment, protection, borders, colors and more Pivot Tables Learn how to summarize large amounts of data with a few clicks Learn various ways of presenting the data Learn the various pivot table tools Learn how to customize and format a pivot table to suit your needs Learn how to group data Learn how to use the various options to present your data Charts Learn how to create a chart with one keystroke! Learn the 11 types of built-in charts Learn how to create a chart with one keystroke! Learn how to customize the charts to make the information tell the right story Learn how to use the design, layout, and formatting available to charts in Excel 2007 Learn embedded charts versus chart sheets Learn how to use modify all the pieces of a chart Array formulas Learn how to use the most powerful formulas in Excel Learn how to combine many formulas into one compact array-formula Learn the real power of these formulas and why regular formulas can't do the job Learn how to use built-in array formulas, like TREND or TRANSPOSE

We are excited to announce the Online version of the Step by Step Course. It will include live demonstrations of the process that you will then follow. Unique opportunity to be guided step by step and experience meditative practice of icon painting.

Microsoft Excel® in Depth: In-House Training The goal of this course is to provide a deeper understanding of Excel and its intricacies and a new ability to use it efficiently producing the best solutions for your projects. This practical course provides a solid background of the features of Excel and a deeper understanding of its features, benefits and uses. This is not a beginner's course in Excel. You will learn some advanced features such as Pivot Tables, Charting, Tables, Sorting, Filtering and Functions. The goal of this course is to provide a deeper understanding of Excel and its intricacies and a new ability to use it efficiently producing the best solutions for your projects. What you Will Learn You'll learn how to: Use functions like IF, AVERAGE, SUMIF, SUMIFS, SUMPRODUCT, INDEX, MATCH, CHOOSE, DATE, and many more Create meaningful charts Use pivot tables Use Conditional Formatting, Data Validation Take advantage of using Named ranges, do sorting, filtering, tables Getting Started The building blocks of Excel, built-in functions, will be examined The basics of formatting your data will be examined Shortcuts and data manipulation will be explored Built-in features like those mentioned in the 'What you will learn' section above will be explored in detail Excel Functions - VLOOKUP, IF, INDEX, MATCH, CHOOSE, SUMIF, SUMIFS, SUMPRODUCT, DATE, so many more Using Named ranges, Data Validation, Sorting, and Filtering Learn the Name manager; Learn the difference between local and global names; Ensure correct access to linked workbooks; Ensure data accuracy; Learn how to use cascading data validation (for example, once a user chooses 'cars', another cell allows only Ford, Toyota, etc.); Sorting by more than 3 fields; Filtering by font, pattern, or value; See your data based on things like dates in the 3rd quarter, or fields where quantity x price is greater than some fixed value Conditional formatting and data formatting Make relevant data stand out Isolate highs and lows Make error cells invisible Learn about Data bars, Icon sets, and Color scales Highlight differences between worksheets Learn all the codes in the Format/Number list Using cell Styles Learn all about alignment, protection, borders, colors and more Pivot Tables Learn how to summarize large amounts of data with a few clicks Learn various ways of presenting the data Learn the various pivot table tools Learn how to customize and format a pivot table to suit your needs Learn how to group data Learn how to use the various options to present your data Charts Learn how to create a chart with one keystroke! Learn the 11 types of built-in charts Learn how to create a chart with one keystroke! Learn how to customize the charts to make the information tell the right story Learn how to use the design, layout, and formatting available to charts in Excel 2007 Learn embedded charts versus chart sheets Learn how to use modify all the pieces of a chart Array formulas Learn how to use the most powerful formulas in Excel Learn how to combine many formulas into one compact array-formula Learn the real power of these formulas and why regular formulas can't do the job Learn how to use built-in array formulas, like TREND or TRANSPOSE

Course Overview The Portuguese Language Course for Beginners is designed to introduce learners to the essentials of the Portuguese language, equipping them with the ability to communicate confidently in everyday situations. This course covers key aspects such as greetings, basic vocabulary, sentence structure, and conversational skills. Whether you are preparing for travel, work, or personal enrichment, this course provides a strong foundation for further language development. By the end of the course, learners will have gained the competence to understand and use common Portuguese expressions, engage in simple conversations, and appreciate the cultural nuances of Portuguese-speaking countries. With its clear structure and engaging approach, this course offers practical value by enhancing communication skills, boosting cultural understanding, and opening up new personal and professional opportunities. Course Description The Portuguese Language Course for Beginners offers a structured introduction to the language through a series of focused lessons. Learners will explore essential topics including basic grammar, vocabulary building, pronunciation techniques, and conversational etiquette. Each section of the course is designed to enhance comprehension and speaking abilities, fostering a gradual progression towards language confidence. Learners will also gain insights into Portuguese culture, helping them to apply their language skills in real-world contexts with sensitivity and awareness. The course combines interactive exercises, audio support, and accessible content to ensure an enriching learning experience. Upon completion, learners will have developed the linguistic tools necessary to engage in everyday Portuguese conversations, navigate simple social and professional interactions, and lay the groundwork for further language study. The course is ideal for those seeking a reliable and well-rounded entry point into Portuguese language acquisition. Course Modules Module 01: Lesson 1 Module 02: Lesson 2 Module 03: Lesson 3 Module 04: Lesson 4 (See full curriculum) Who is this course for? Individuals seeking to communicate effectively in Portuguese during travel or relocation. Professionals aiming to expand career opportunities in Portuguese-speaking markets. Beginners with an interest in learning a new language for cultural enrichment. Students or enthusiasts looking to build foundational language skills for academic or personal growth. Career Path Translator or Interpreter (Entry-Level) Customer Service Representative in multilingual environments Travel and Tourism Assistant International Sales or Business Support Officer Language Tutor (Beginner Level) Cultural Exchange Programme Coordinator

Duration 1 Days 6 CPD hours This course is intended for The Power BI in a Day course is designed for beginners and intermediate users of Power BI. Overview #NAME? Students will discover the full capabilities of Power BI in a one-day, hands-on workshop. Please Note: This workshop is primarily self-directed and students will work at their own pace while having access to an instructor for questions. 1 - Accessing & Preparing data Data Set Power BI Desktop Power BI Desktop ? Accessing Data Power BI Desktop ? Data Preparation 2 - Data Modeling and Exploration Power BI Desktop ? Data Modeling and Exploration Power BI Desktop ? Data Exploration Continued References 3 - Data Visualization Power BI Desktop Power BI Desktop ? Data Visualization References 4 - Publishing & Accessing Reports Power BI Desktop ? Creating Mobile View Power BI Service Power BI Service ? Publishing Report Power BI Mobile ? Accessing Report on Mobile Device Power BI Service ? Collaboration and Distribution References 5 - Dashboard and Collaboration Power BI Service Building Dashboard References Additional course details: Nexus Humans Power BI: Dashboard in a Day training program is a workshop that presents an invigorating mix of sessions, lessons, and masterclasses meticulously crafted to propel your learning expedition forward. This immersive bootcamp-style experience boasts interactive lectures, hands-on labs, and collaborative hackathons, all strategically designed to fortify fundamental concepts. Guided by seasoned coaches, each session offers priceless insights and practical skills crucial for honing your expertise. Whether you're stepping into the realm of professional skills or a seasoned professional, this comprehensive course ensures you're equipped with the knowledge and prowess necessary for success. While we feel this is the best course for the Power BI: Dashboard in a Day course and one of our Top 10 we encourage you to read the course outline to make sure it is the right content for you. Additionally, private sessions, closed classes or dedicated events are available both live online and at our training centres in Dublin and London, as well as at your offices anywhere in the UK, Ireland or across EMEA.

Sketchup face to face training customised and bespoke.

Adobe After Effects Training Fundamentals to Essentials. Learn essential techniques for creating visual effects and animations. Adobe After Effects Essentials VFX Course to learn auto-correction methods and tools, adjust video effects or presets to layers, and utilize 3D space for modifying composition. Click here for more info: Website Duration: 20 hours Approach: 1-on-1 personalized sessions and Tailored content. Flexibility: Book a time convenient for you, Monday to Saturday, between 9 am and 5 pm. Duration: 20 Hours Module 1: Introduction to After Effects (2 hours) Understanding the After Effects interface Project planning and organization techniques Module 2: Asset Preparation and Composition Setup (3 hours) Importing and organizing multimedia assets Setting up compositions for different media formats Module 3: Applying Transformations and Effects (5 hours) Animating images, videos, and text Applying diverse transformations and effects for dynamic visuals Module 4: Mastering Masking and Compositing (5 hours) Creating and refining masks for precise editing Advanced compositing techniques for seamless integration Module 5: Rendering High-Quality Videos (3 hours) Configuring rendering settings for various output formats Ensuring optimal quality in the final video output Module 6: Project Review and Q&A Session (2 hours) Reviewing projects and addressing individual queries Fine-tuning techniques based on participants' needs Course Benefits: Hands-on learning with personalized attention Mastering crucial After Effects skills for diverse media projects Access to recorded lessons for future reference Continuous email support for post-course inquiries After Effects Download  https://www.adobe.com Upon completing the Essential After Effects Skills Mastery course, participants will: Proficiency in After Effects: Master the After Effects interface, gaining confidence in navigating the software effectively. Strategic Project Planning: Acquire skills in project organization and planning, ensuring a systematic approach to video projects. Advanced Asset Management: Learn efficient techniques for importing, organizing, and managing multimedia assets within After Effects projects. Dynamic Composition Creation: Gain expertise in setting up compositions tailored to various media formats, understanding their intricacies and potential applications. Creative Animation Techniques: Apply diverse transformations and effects to images, videos, and text, enhancing the visual appeal of multimedia content. Precision in Masking and Compositing: Master the art of masking, enabling precise editing, and explore advanced compositing techniques for seamless visual integration. High-Quality Video Rendering: Understand rendering settings, ensuring optimal video quality for different output formats, whether for online platforms or professional presentations. Project Review and Refinement: Engage in project reviews and Q&A sessions, refining techniques and addressing individual queries for comprehensive learning. Confidence in Video Production: Develop confidence in producing high-quality videos, equipped with a robust skill set essential for various creative projects. Continuous Learning Support: Benefit from continuous email support, providing assistance with post-course inquiries, ensuring ongoing learning and skill refinement. In this course, you will learn: Efficient workflow planning and asset organization in After Effects projects. Creative project development techniques for engaging visuals. Image and video asset preparation using Photoshop. After Effects project setup, compositions, and asset integration. Animation of transformations and effects on layers. Advanced mask creation and animation for creative compositing. Dynamic text animation and 3D exploration. Keying and seamless visual integration techniques. Understanding export settings, project backup, and archiving. Learning Objectives: Upon completion, you will master asset organization, animations, masks, text effects, and seamless integration, ensuring proficiency in After Effects projects. Prerequisites: Basic computer skills and a fast-paced learning mindset are required. No prior experience is necessary, making this course suitable for beginners. Key Features: Personalized one-on-one or live online coaching sessions. Suitable for both beginners and professionals in motion graphics and animation. Tailored Training: Courses customized to meet your specific requirements. Flexible scheduling options to suit your availability. Industry Standard: Adobe After Effects, the industry-preferred software for visual effects, motion graphics, and compositing. Widely used in filmmaking, video games, and TV production. Learning Approach: Hands-on training with detailed, step-by-step demonstrations. Real-time feedback during sessions, along with access to session recordings. Course Benefits: Certificate of Attendance upon completion. Comprehensive practical training guide for reference. Lifetime email and phone support for continuous assistance. Help with software installation for a seamless learning experience. Lifetime Support: Ongoing email and phone/WhatsApp support for lifelong learning assistance. Elevate your motion graphics expertise with our Adobe After Effects Basic to Fundamentals Training Course. Open doors to exciting opportunities in the ever-evolving realm of visual effects.

Aspiring author? We know how frustrating it can be to have a brilliant story idea but feel stuck on where to start. The blank page can be intimidating, and finding the time and confidence to write can seem impossible. This Two-Day Creative Writing Workshop is designed specifically for beginners like you, ready to turn your novel dreams into reality! 🚀✍️

Drawing for Beginners - 8 week online course (to your inbox)