10966 Courses delivered Online

Description: This Microsoft Office 2007 Excel Advanced - Complete Video Course builds on knowledge gained in the Introduction and Intermediate courses. In Advanced Microsoft Office Excel 2007, you will explore the many data analysis tools available in Excel, such as formula auditing, goal seek, Scenario Manager and subtotals. Additionally, during this course you will use advanced functions, learn how to apply conditional formatting, filter and manage your data lists, create and manipulate PivotTables and PivotCharts and record basic macros. You will also learn to use key advanced financial, logical, text, statistical and math, and lookup functions, audit formulas for errors, analyze data using subtotals, goal seek and the scenario manager, use custom and conditional formatting, manage data with tables, filtering and sorting, create, edit and format PivotTables and PivotCharts, import and export date to and from a workbook, create and use macros. So, by taking this course you will have a complete understanding of the higher functions of Excel. Assessment: At the end of the course, you will be required to sit for an online MCQ test. Your test will be assessed automatically and immediately. You will instantly know whether you have been successful or not. Before sitting for your final exam you will have the opportunity to test your proficiency with a mock exam. Certification: After completing and passing the course successfully, you will be able to obtain an Accredited Certificate of Achievement. Certificates can be obtained either in hard copy at a cost of £39 or in PDF format at a cost of £24. Who is this Course for? Microsoft Office 2007 Excel Advanced - Complete Video Course is certified by CPD Qualifications Standards and CiQ. This makes it perfect for anyone trying to learn potential professional skills. As there is no experience and qualification required for this course, it is available for all students from any academic background. Requirements Our Microsoft Office 2007 Excel Advanced - Complete Video Course is fully compatible with any kind of device. Whether you are using Windows computer, Mac, smartphones or tablets, you will get the same experience while learning. Besides that, you will be able to access the course with any kind of internet connection from anywhere at any time without any kind of limitation. Career Path After completing this course you will be able to build up accurate knowledge and skills with proper confidence to enrich yourself and brighten up your career in the relevant job market. Advanced Functions Logical Functions FREE 00:08:00 Math and Statistical Functions 00:06:00 Financial Functions 00:03:00 Displaying and Printing Formulas 00:02:00 Lookups and Data Tables Using Lookup Functions 00:03:00 Using MATCH and INDEX 00:01:00 Creating Data Tables 00:03:00 Advanced List Management Validating Cell Entries 00:01:00 Exploring Database Functions 00:01:00 PivotTables and PivotCharts Working with PivotTables 00:04:00 Rearranging PivotTables 00:02:00 Formatting PivotTables 00:02:00 PivotCharts 00:01:00 Exporting and Importing Exporting and Importing Text Files 00:07:00 Exporting and Importing XML Data 00:02:00 Querying External Databases 00:03:00 Analytical Options Goal Seek and Solver 00:05:00 The Analysis ToolPak 00:01:00 Scenarios 00:02:00 Views 00:01:00 Macros and Custom Functions Running and Recording a Macro 00:02:00 Working with VBA Code 00:01:00 Creating Functions 00:05:00 Conditional Formatting and SmartArt Conditional Formatting with Graphics 00:03:00 SmartArt Graphics 00:02:00 Mock Exam Mock Exam- Microsoft Office 2007 Excel Advanced - Complete Video Course 00:20:00 Final Exam Final Exam- Microsoft Office 2007 Excel Advanced - Complete Video Course 00:20:00 Certificate and Transcript Order Your Certificates and Transcripts 00:00:00

Duration 2 Days 12 CPD hours This course is intended for This course is intended for individuals who want to gain an indepth knowledge of formatting documents using Word. Overview Upon successful completion of this course, students will be able to create and modify documents by using Microsoft Office Word 2016/365/2019. In this course, students will create, edit, and enhance technical documents using Microsoft Office Word 2016/365/2019. Formatting Text and Paragraphs Apply Character Formatting Control Paragraph Layout Aligh Text Using Tabs Display Text in Bulleted or Numbered Lists Working More Efficiently Make Repetitive Edits Apply Repetitive Formatting Use Styles to Streamline Repetitive Formatting Tasks Customize the Word Environment Managing Lists Sort a List Format a List Adding Tables Insert a Table Modify a Table Format a Table Inserting Graphic Objects Insert Symbols and Special Characters Add Images to a Document Controlling Page Appearance Add Headers and Footers Control Page Layout Add a Watermark Preparing to Publish Check Spelling, Grammar, and Readability Previw and Print Documents Use Research Tools Customizing Formats Using Styles and Themes Create and Modify Text Styles Cerate Custom List or Table Styles Apply Document Themes Inserting Content Using Quick Parts Insert Building Blocks Create and Modify building Blocks Insert Fields Using Quick Parts Using Templates to Automate Document Formatting Create a Document Using a Template Create and Modify a Template Manage Templates with the Template Organizer Controlling the Flow of a Document Control Paragrpah Flow Insert Section Breaks Insert Columns Managing Long Documents Insert Blank and Cover Pages Insert an Index Insert a Table of Contents Insert an Anchillary Table Manage Outlines Create a Master Document Manipulating Images Integrate Pictures and Text Adjust Image Appearance Adding Document References and Links Add Captions Add Cross-References Add Bookmarks Add Hyperlinks Insert Footnotes and Endnotes Add Citations and a Bibilography Additional course details: Nexus Humans Formatting Technical Documents Using Microsoft for Office 365 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 Formatting Technical Documents Using Microsoft for Office 365 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.

This full day workshop is designed to follow on and build on the learning from the 1-hour webinar to provide an embedded learning experience leading to acceptance and change of culture around neurodiversity. We understand the pressure managers can experience working within a neurodiverse team, this training is designed with managers in mind.

Why Learn Game Designing Training Course 3ds Max and Unity 3D? Click for more info Learn Game Designing with 3ds Max and Unity 3D for industry demand, 3d and 2d skills, game design, AR/VR projects, game programming, and 3d visualization. Enhance your career in the thriving gaming and interactive media industry. Duration: 40 hrs. Method: 1-on-1 & Tailored content. Schedule: Tailor your own schedule by pre-booking a convenient hour of your choice, available from Mon to Sat 9 am and 7 pm. Explore the World of Unity 3D with Our Training Courses Unity is a robust cross-platform game development engine, responsible for creating a significant portion of the world's games. Learn ultimate game development platform to build top-notch 3D & 2D games, deployable on mobile, desktop, VR/AR, consoles, or the Web. The opportunities are limitless. Led by certified and experienced Unity instructors, our training courses are filled with practical, real-world exercises. 40-hour Game Designing Training Course with 3ds Max and Unity 3D: Course Overview: Module 1: Introduction to 3ds Max and Unity 3D (4 hours) Get acquainted with 3ds Max and Unity 3D interfaces and workflows Efficiently set up and manage projects Master importing and handling assets Module 2: 3D Modeling with 3ds Max (8 hours) Dive into 3D modeling techniques Create stunning 3D models using 3ds Max Explore polygonal, spline, and NURBS modeling Enhance models with textures and materials Module 3: Animation and Rigging with 3ds Max (8 hours) Understand animation techniques in 3ds Max Rig 3D models for smooth animations Bring creations to life with keyframe animation Employ procedural animation methods Export animations for Unity 3D integration Module 4: Game Design with Unity 3D (8 hours) Learn the Unity 3D game engine Grasp essential game mechanics and concepts Create and manage game scenes and levels Master control of game objects and components Utilize physics and collision detection for immersive experiences Module 5: Scripting and Programming with Unity 3D (8 hours) Introduce Unity 3D scripting with C# Understand variables, data types, and functions in C# Control game objects and components using C# Explore game loops and events for interactive gameplay Module 6: User Interfaces and Audio with Unity 3D (4 hours) Design captivating user interfaces within Unity 3D Implement interactive buttons, sliders, and input fields Elevate games with audio import and editing Control sound effects and background music Module 7: Optimization and Deployment (4 hours) Master game optimization in Unity 3D Enhance game performance through scripting techniques Build and test games for various platforms Publish games on the web or app stores Game Designing Training Course 3ds Max and Unity 3D (Live Online Only): Explore advanced 3ds Max techniques for modeling, lighting, and cameras Dive into character animation for lifelike characters Enhance Unity 3D skills with real-time development and game authoring settings Unity - Real-time 3D Development Platform: Unlock Your Creativity https://www.unity.com/ Create 3D, 2D, VR & AR Experiences For Any Industry: Games, Auto, AEC, Film, And More. Complete Solution To Develop Better, Iterate Faster, And Grow Your Business. Amazing Games. Immersive Experiences. Multi-Platform Support. 3ds Max Free Trial | Autodesk Download a free 30-day trial of 3ds Max, 3D modeling, and rendering software for design visualization, games, and animation.

CSS Certification Level 1 CSS is as critical to web architecture, as designing is to building. It is the establishment of each site and is additionally one of the least demanding coding techniques to learn. While html is viewed as the granddad of coding, CSS is the thing that makes a site look better. Consequently, it is exceptionally valuable to comprehend what CSS coding is and how to utilize it. As a rule when you are planning your own site page, it is helpful to realize how to execute the plan components in the back end. Regardless of whether you recruit an assistance or somebody to do the programming for you, it is still helpful to see how everything functions. In this instructional exercise, you won't just find out about the significance of CSS coding, yet additionally how to start programming utilizing this simple CSS coding technique. Albeit this can sound scary, the prospects of making an excellent and fun plan are boundless when you realize how to utilize and execute CSS. Allow us to investigate what you will realize in the course and what a portion of the advantages of taking this course are: What you will realize in this course: The most effective method to work on coding utilizing a free site, for example, jsbin.com The contrast among html and CSS coding and how to disclose to them separated Comprehend the utilization of section labels, how to isolate them and make distinctive format choices Figure out how to distinguish the utilization of an 'id' and 'classes' Normally utilized text styles and how to add colors utilizing a hex code Instructions to successfully utilize cushioning to plan the format of the site page The most effective method to utilize Latin content as a 'skeleton' when assembling a page Advantages of taking this course: Figure out how to modify a website page and make back-end changes Get a good deal on website specialists Find out about various parts of website composition, for example, textual styles that are utilized, when they are utilized and what makes them one of a kind Step by step instructions to guarantee that a site can be suitably seen on all stages, i.e., work area, cell phones Instructions to plan an excellent website page by embeddings pictures and messing with design so the site page and foundation supplement one another Start to upgrade innovative yield

Inspiring, interactive and unique 4-hour CPD certified training on Communication and Co-production with Parents/Carers

Emotional Intelligence, EQ, EI, Moccasin Approach, Moccasin Manager,

Unlock the Gateway to Smart Purchasing with 'Purchasing Basics' Are you ready to master the art of making savvy purchasing decisions? Introducing 'Purchasing Basics' - your ultimate guide to navigating the complex world of procurement with confidence and finesse. 🎓   What You'll Learn: In this comprehensive text course, you'll delve into the fundamental principles of purchasing, from understanding the procurement process to negotiating deals like a pro. Gain insights into vendor management, cost analysis, and contract negotiation techniques that will empower you to optimize your organization's purchasing strategy. 📚   Benefits of Taking This Course: Enhanced Decision-Making Skills: Learn to analyze market trends, evaluate supplier options, and make informed decisions that drive efficiency and savings. Cost Savings: Discover strategies to negotiate better deals, leverage volume discounts, and minimize procurement costs, ultimately boosting your organization's bottom line. Risk Mitigation: Equip yourself with the knowledge to identify and mitigate potential risks associated with procurement, ensuring smoother operations and fewer unexpected setbacks. Career Advancement: Position yourself as a valuable asset in your organization or industry by mastering essential purchasing skills that are highly sought after in today's competitive job market. Increased Confidence: Approach purchasing tasks with confidence and assurance, knowing that you have a solid understanding of best practices and industry standards.   Who is This For? Procurement Professionals: Whether you're just starting out in your procurement career or seeking to deepen your expertise, this course is designed to meet your needs. Business Owners and Managers: Gain valuable insights into optimizing your organization's purchasing processes to drive efficiency and maximize profitability. Students and Graduates: Jumpstart your career in procurement with a solid foundation in purchasing basics that will set you apart in the job market.   Career Path: Upon completion of 'Purchasing Basics,' you'll be well-equipped to pursue various career opportunities in procurement and supply chain management, including: Procurement Specialist Purchasing Manager Supply Chain Analyst Vendor Manager Contract Negotiator   FAQs: Q: Is this course suitable for beginners? A: Yes, 'Purchasing Basics' is designed to cater to learners at all levels, from beginners seeking to grasp the fundamentals to seasoned professionals looking to refine their skills. Q: How long does it take to complete the course? A: The duration of the course can vary depending on individual learning pace and commitment. However, most learners complete it within a few weeks. Q: Will I receive a certificate upon completion? A: Yes, upon successfully completing the course, you will receive a certificate of achievement to showcase your newfound expertise in purchasing basics. Q: Can I access the course materials on mobile devices? A: Absolutely! The course materials are accessible on various devices, including smartphones, tablets, and computers, allowing you to learn on the go. Q: Is there any prerequisite knowledge required? A: No prior experience or knowledge in purchasing is required. This course is designed to provide a comprehensive overview of purchasing basics, making it accessible to all learners. Q: Can I interact with instructors or fellow learners? A: While this is a text-based course, you will have access to discussion forums and community groups where you can engage with instructors and fellow learners, share insights, and seek support. Q: Is there a money-back guarantee? A: Yes, we offer a satisfaction guarantee. If you're not completely satisfied with the course, simply contact our support team within 30 days of enrollment for a full refund, no questions asked. Don't miss out on this opportunity to unlock the secrets of successful purchasing. Enroll in 'Purchasing Basics' today and embark on a journey toward procurement excellence! 🚀 Course Curriculum Module 1 Introduction to Purchasing Basics Introduction to Purchasing Basics 00:00 Module 2 Supplier Identification and Evaluation Supplier Identification and Evaluation 00:00 Module 3 The Art of Negotiation in Purchasing The Art of Negotiation in Purchasing 00:00 Module 4 Contract Management and Supplier Performance Contract Management and Supplier Performance 00:00 Module 5 Strategic Sourcing for Value Creation Strategic Sourcing for Value Creation 00:00 Module 6 Supplier Performance Measurement and Continuous Improvement Supplier Performance Measurement and Continuous Improvement 00:00 Module 7 Risk Management in Purchasing and Supply Chain Risk Management in Purchasing and Supply Chain 00:00

Level 5 Diploma(FREE QLS Endorsed Certificate)| 12-in-1 Bundle | Free Certificates | CPD Accredited | Lifetime Access

Description Explore the basics of typography for web and mobile UI to make your design powerful with the Level 3 Diploma in Typography for UI Designers course. The element of every layout is essential while designing a website. The course starts by explaining the typography terms and anatomy. You will learn to create amazing web and mobile app design by using meaningful fonts. The use of fonts, line-height and letter spacing, Google android typography, using Vertical Rhythm in Bootstrap will be discussed here. Then you will learn to balance balancing your design by using LEGO Blocks method. Finally, the procedures for connecting your Photoshop Screen to iPhone or Android Device, and many other essential concepts will be reviewed in the course. Shortly, the course covers the concepts of Font Pairing, Web Typography, App Typography & Vertical Rhythm. Entry Requirement: NOT for Novices (Must have some Photoshop Experience) Web Designers Mobile App Designers All Designers who think their design have something missing Web Developers Graphic Designer Assessment: At the end of the course, you will be required to sit an online multiple-choice test. Your test will be assessed automatically and immediately so that you will instantly know whether you have been successful. Before sitting for your final exam, you will have the opportunity to test your proficiency with a mock exam. Certification: After completing and passing the course successfully, you will be able to obtain an Accredited Certificate of Achievement. Certificates can be obtained either in hard copy at a cost of £39 or in PDF format at a cost of £24. Why choose us? Affordable, engaging & high-quality e-learning study materials; Tutorial videos/materials from the industry leading experts; Study in a user-friendly, advanced online learning platform; Efficient exam systems for the assessment and instant result; The UK & internationally recognized accredited qualification; Access to course content on mobile, tablet or desktop from anywhere anytime; The benefit of career advancement opportunities; 24/7 student support via email. Career Path After completing this course you will be able to build up accurate knowledge and skills with proper confidence to enrich yourself and brighten up your career in the relevant job market. Introduction to Typography 1.2.Intro to typography course 00:05:00 1.3. how typography cousre is laid out 00:02:00 1.4.What are Font Families 00:05:00 1.5.typography-antomy-terms 00:07:00 1.6.Humanist Old and Transitional 00:07:00 1.7.Sans-Serif Script Other Sans 00:06:00 1.8. Line-length in Typography 00:03:00 1.9.Alignments of your text 00:05:00 1.10.Line-height matters 00:07:00 1.11.Letter Spacing kerning 00:05:00 1.12.exercise to apply all we learned 00:11:00 More about Typography 2.1.Different Types of Hyphens & Dashes 00:02:00 2.2. About Quotation Marks 00:03:00 Typography Scales and Grids 3.1.1Expanding Scales-NEW 00:07:00 3.1.Roles Of Typefaces-1 00:05:00 3.2.Typography Scale-1 00:03:00 3.3Type Hierarchy Online Tools 00:05:00 3.4.How Many Levels Of Hierarchy-update 00:03:00 3.5.Vertical Rhythm-updated 00:05:00 3.6.Vertical Rhythm In Photoshop 00:07:00 3.7.exercise Vertical Rhythm-1 00:12:00 3.8.modular Grid 00:11:00 EXERCISES: Modular + Baseline Grid Design Ultimate Exericse 4.1.prepare Modular Grid For Design Exericse 00:11:00 4.2.Modular Design part 1 00:16:00 4.3.Modular design 2nd 00:10:00 4.4.Modular Design Refining the design 00:03:00 4.5.Modulr Design 3rd Layout 00:10:00 How to Select Fonts? 5.1.how Many Fonts 00:05:00 5.2.Moods Voices Of Typefaces- 00:13:00 5.3.colors Efffect On Typo 00:04:00 How to Pair Fonts? 6.1.Font Pairing Intro-Updated 00:04:00 6.2.X-height Matching 00:05:00 6.3.Contrast Matching 00:10:00 6.4.Look For Similar Features 00:10:00 6.5.Avoid Too Similarity 00:04:00 6.6.Pairing Fonts Same Family Designer 00:05:00 6.7.Online Tools Font Pairing 00:06:00 How to get Variation in text for Great Designs 7.1.variation with bold italic 00:04:00 7.2.variation with colors 00:03:00 7.3.Variation with Reverse-colors updated- 00:03:00 7.4.variation with lineheight 00:04:00 EXERCISES: Dribbble LEVEL Designs 8.1. Dribbble Hero Design preperation 00:05:00 8.2.dribbble Hero Design V1 Part 1 00:16:00 8.3.dribbble Hero Design V1 Part 2 00:16:00 8.4. Dribbble Hero Variation Intro 00:04:00 8.5. Dribbble Hero Variation 2 Part 1 00:08:00 8.6. Dribbble Hero Variation 2 Part2 00:06:00 Exercise: Social Media Ad Design with 3 different fonts 9.1.summer Discount Ad DesignPreperations 00:04:00 9.2 Preparing base of design 00:07:00 9.3. Adding Text and styles 00:14:00 9.4.final Adjustments 00:03:00 Nature Health Themed Typography Exercises 10.1.juicy Design Exercise Preperations-1 00:03:00 10.2.making Of Juicy Design-2 00:16:00 10.3.juicy Designs Final-3 00:12:00 Typography for Iphone and Android App Designs (Mobile App Typography) 11.1 Intro IOS point sizing 00:05:00 11.2.IOS Font Specs 00:03:00 11.3.Designing multiple IOS Screens 00:14:00 11.4. Student Question About Resoltutions 00:14:00 11.5.connect Your Iphone With Photoshop 00:05:00 11.6. Android Typography 00:04:00 11.7.android Design Exercise For All Sizes 00:09:00 Typography for Web Developers 12.1.Using Google Fonts 00:04:00 12.2.using Premium Fonts 00:06:00 12.3.Intro to css font sizigin 00:03:00 12.4.what Is Em Font Size 00:08:00 12.5.What is rem font size 00:05:00 12.6.How percentage font size works 00:04:00 12.7.How vw font unit works 00:04:00 Responsive Typography for Developers 13.1.how Vertical Rhythm Works In CSS 00:08:00 13.2.Gridlover Exercise 00:08:00 13.3.custom Typographic Scale Boostrap-3 00:13:00 13.4.dont Use Code From Typescale 00:02:00 New and Latest in Typography 14.1.responsive Typography Intro 00:07:00 14.2.different Ratios And Scales In Responsive Typography 00:10:00 14.3.percentage Value Technique For Responsive Type 00:12:00 15.1 Color Fonts 00:05:00 15.2 variable-fonts101 00:08:00 Mock Exam Final Exam Certificate and Transcript Order Your Certificates and Transcripts 00:00:00