17841 Courses delivered Online

Why Choose 3ds Max Basics Training Course? Click for more info What am I going to get from this course? Create your own models in 3ds Max; Use built in poly modelling tools to create basic 3D objects. Learn everything you need about 3ds Max with this guide, from the basics of modelling and animation to more advanced steps.  Duration: 10 hrs Method: 1-on-1, Personalized attention. 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. 3ds Max Basic Training Course: Course Name: 3ds Max Basics Training Course. Core Skills for 3D Modeling, Rendering, Animations, and Games. Target Audience: Beginners and new users from diverse industries, including architects, interior designers, engineers, game developers, artists, and animators.Course Outline: 3D Modeling and Animation with 3ds MaxI. Introduction to 3ds Max- Course overview and objectives - Navigating the user interface - Basic settings and preferencesII. Creating 3D Objects- Building simple shapes with primitive objects - Craft complex designs using Editable Poly - Enhancing objects with modifiers - Applying materials and textures for realistic effectsIII. Lighting Techniques- Illuminating scenes with different light sources - Exploring various types of lighting - Adjusting light properties for desired effects - Casting shadows to enhance realismIV. Camera Control- Creating and configuring camera views - Fine-tuning camera settings for optimal shots - Animating cameras for dynamic scenesV. Animation Fundamentals- Mastering keyframe animation techniques - Utilizing the time slider and track view - Animating object transformations - Adding movement to materials and texturesVI. Rendering Process- Configuring render settings for high-quality output - Selecting appropriate output formats - Streamlining rendering with batch processing - Enhancing final renders with post-processing effectsVII. Project-Based Learning- Applying acquired skills to complete a final project - Exercising creativity and problem-solving abilities - Integrating modeling, animation, lighting, and rendering into the projectIn-Depth Course Outline:1. Modeling- Edit Poly Modeling: Extrude, Chamfer, Cut, and Slices - Symmetry Mirror Modeling - Designing a Table and Chair - Creating a Basic House Model - Working with Lines and Shapes - Importing Plans from AutoCAD/Vectorworks - Crafting Interior Spaces - Adding Doors, Windows, Railings, and Trees - Implementing Stairs2. Modifiers- Exploring Compound Objects - Utilizing Connect, Scatter, Pro Boolean, Loft, and Terrain Modifiers - Manipulating Bend, Taper, Twist, Stretch, Skew, FFD, Wave, Ripple, and Lattice - Employing the Lathe Modifier for Curved Objects3. 3ds Max Basic Lights- Mastering Omni, Spot, and Direct Lights for Illumination4. 3ds Max Camera- Understanding Free and Target Cameras for Optimal Shots5. Texturing and Rendering- Applying Diffuse and Bump Mapping Techniques - Integrating Environment and Background Images - Configuring Render Settings for High-Quality Images - Lighting and Rendering Scenes in 3ds MaxAre you ready to take your 3D modeling and animation skills to the next level? Download the 30-day free trial of 3ds Max from Autodesk and embark on a transformative learning journey today. Explore the possibilities and unleash your creative potential!

In this competitive job market, you need to have some specific skills and knowledge to start your career and establish your position. This Content Writing & Copy Writing For SEO and Sales will help you understand the current demands, trends and skills in the sector. The course will provide you with the essential skills you need to boost your career growth in no time. The Content Writing & Copy Writing For SEO and Sales will give you clear insight and understanding about your roles and responsibilities, job perspective and future opportunities in this field. You will be familiarised with various actionable techniques, career mindset, regulations and how to work efficiently. This course is designed to provide an introduction to Content Writing & Copy Writing For SEO and Sales and offers an excellent way to gain the vital skills and confidence to work toward a successful career. It also provides access to proven educational knowledge about the subject and will support those wanting to attain personal goals in this area. Learning Objectives Learn the fundamental skills you require to be an expert Explore different techniques used by professionals Find out the relevant job skills & knowledge to excel in this profession Get a clear understanding of the job market and current demand Update your skills and fill any knowledge gap to compete in the relevant industry CPD accreditation for proof of acquired skills and knowledge Who is this Course for? Whether you are a beginner or an existing practitioner, our CPD accredited Content Writing & Copy Writing For SEO and Sales is perfect for you to gain extensive knowledge about different aspects of the relevant industry to hone your skill further. It is also great for working professionals who have acquired practical experience but require theoretical knowledge with a credential to support their skill, as we offer CPD accredited certification to boost up your resume and promotion prospects. Entry Requirement Anyone interested in learning more about this subject should take this Content Writing & Copy Writing For SEO and Sales. This course will help you grasp the basic concepts as well as develop a thorough understanding of the subject. The course is open to students from any academic background, as there is no prerequisites to enrol on this course. The course materials are accessible from an internet enabled device at anytime of the day. CPD Certificate from Course Gate At the successful completion of the course, you can obtain your CPD certificate from us. You can order the PDF certificate for £9 and the hard copy for £15. Also, you can order both PDF and hardcopy certificates for £22. Career path The Content Writing & Copy Writing For SEO and Sales will help you to enhance your knowledge and skill in this sector. After accomplishing this course, you will enrich and improve yourself and brighten up your career in the relevant job market. Course Curriculum Section 01: Introduction Introduction 00:05:00 How to Navigate This Course - Watch This Video 00:03:00 Section 02: Free Taster 13 Copywriting and Sales Buttons You Need to Know How to Push 00:07:00 Copywriting to Sell 10 Steps you must know 00:06:00 14 Step Formula to Writing Great Sales Copy 00:06:00 Section 03: BASICS: 12 Essential Steps to Great Copy Writing AIDA is not just an Opera! 00:02:00 Have you any idea who you are talking to? 00:02:00 Who cares what format you use? 00:03:00 Hurting? Want someone to heal your pain? 00:02:00 I haven't got time or money for Objections! 00:02:00 Don't worry, there's always plenty of Scarcity to go round! 00:02:00 So, why are YOU reading my Headlines? 00:02:00 Why do you always want to know whats in it for you? 00:02:00 Endorsements? Pah! Prove it to me! 00:03:00 I Guarantee to you that I love Risk! Or do I? 00:02:00 Right it Wright to Be Red! or you won't be Readable! 00:03:00 Keep it Simple S. and throw away your Theasaurus 00:02:00 Section 04: BASICS: Copywriting Formulation - Understanding Copywriting Building Blocks Introduction to Copywriting Formulation 00:02:00 Starting with AIDA 00:06:00 PAS - Problem, Agitation, Solution 00:04:00 The 4 Ps 00:03:00 QUEST 00:04:00 Section 05: BASICS: How to Write Headline What You Need to Know to Write Great Headlines 00:06:00 Section 06: BASICS: Proofreading and Editing - How to Edit Sales Copy Writing Editing: Can You Write Better Copy? 00:06:00 Proof Reading and Editing: 20 Ways to Write Better Copy 00:11:00 Editing Writing: Seven Guidelines for Editing Writing 00:06:00 Section 07: PSYCHOLOGY: The Psychology behind Copywriting Get Your Copywriting Psychology Right! 00:06:00 What are the Eight Universal Motivators? 00:07:00 100 Motivations 00:05:00 Overcoming Objections 00:08:00 Section 08: COPYWRITING FOR Blogging - Web Posts Copywriting for Blogs 00:09:00 A Simple Formula for Blog Posts 00:04:00 Blog Post Copywriting Formula 00:09:00 Blog Post Editing Checklist 00:08:00 Section 09: COPYWRITING FOR Landing Pages Copywriting for Landing Pages 00:04:00 Copywriting for Testimonials 00:06:00 Copywriting for Bullet Points 00:05:00 Section 10: COPYWRITING FOR Sales Letters Five Formulations for Sales Letters 00:03:00 The Five Point Sales Letter Formula 00:03:00 The Seven Step Copywriting Formula for Sales Letters 00:05:00 The Nine Point Formula 00:06:00 The 18 Step Sales Letter 00:06:00 The 21 Part Sales Letter Formula 00:08:00 Bonus: 32 Step Power Copywriting Formula 00:08:00 Section 11: COPYWRITING FOR Video Sales Letters What is a Video Sales Letter 00:03:00 How to Write an Attention Grabbing Video Sales Letter Headline 00:03:00 Video Sales Letter Basics - Some Simple Guidance for Better VSLs 00:04:00 Video Sales Letter Outline - with Downloadable Templates 00:07:00 Section 12: COPYWRITING FOR Email Copywriting for Email 00:07:00 How to Write Effective Welcome Emails 00:10:00 ACTIVITY: Analysis of a Long Form Story Telling Email 00:07:00 Email Copywriting Analysis 1 00:05:00 Copywriting Formulas for Email Sequences 00:06:00 Section 13: COPYWRITING FOR Advertisements Copywriting for Advertisements 00:04:00 Section 14: COPYWRITING FOR Twitter Copywriting for Twitter - Engage, Entertain, Be Brief! 00:07:00 Section 15: COPYWRITING FOR Promotional Videos How to Create a High Converting Promotional Video 00:06:00 The Promotional Video for This Course Following the Script 00:02:00 The Promotional Video - Version 2 00:02:00 Promotional Video SlideDeck 00:20:00 Promotional Video Script Checklist 00:04:00 2018 Update: The Formula for an Effective Promotional Video 00:04:00 2018 New Copywriting Course Promo Video 00:03:00 Section 16: Conclusion and Course Wrap Up Conclusion and Course Wrap Up 00:03:00 Additional File Additional File 00:00:00 Certificate and Transcript Order Your Certificates or Transcripts 00:00:00

Ever wondered about the workings of your mobile? Or the forces preventing us from slipping? Or how sound travels through your earphones? Physics is about much more than black holes and atmospheres; it's the study of unseen forces that orchestrate our world, offering answers to life's profound questions. This dynamic online programme delves deep into energy forms, their storage and transfer. You will learn about the structure of particles that constitute our surroundings, and their interactions. Explore electromagnetism, properties of radiation waves, and the marvels of the solar system. IGCSE Physics is a gateway to careers in astronomy, environmental science, engineering and beyond, and to further university study. Self-paced, with a comprehensive induction and well-structured assignments, it prepares you for your exams at your convenience. Key Benefits: Up-to-date course designed with captivating, dynamic content Fast-track option available for 2022 exams Access to our network of partner exam centres (guaranteed exam venue) Unlimited tutor support for tailored study plans and continual assistance Exam pass guarantee (we'll support you to the next exam if you don't pass first time) Physics is the science of matter, motion, energy, and universal laws. This IGCSE distance learning programme introduces fundamental physics concepts, including heat, light, magnetism and electricity. About the awarding body Awarding body: Edexcel Our course code: X814 Qualification code: 4PH1 Edexcel, the UK's largest awarding organisation, offers academic and vocational qualifications in schools, colleges, and workplaces in the UK and abroad. They have facilitated success through learning for nearly two decades. ⏱ Study Hours Allow for between 120-150 hours’ study time, plus additional time for completing assignments. 👩‍🏫 Study Method Our course is offered via our interactive online learning platform with a variety of learning resources such as videos, quizzes, and activities. You can also print the materials if preferred. 📆 Course Duration Enrol now for a course start date of 01/09/23. You'll receive your login details to MyOxbridge (our online platform) before this date. You will enjoy unlimited tutor support for two years from your course start date. 📋 Assessment Enrolment for examinations from Summer 2024 is now open. This is a linear qualification; students will sit all their exams at the end of the course. Two GCSE standard written exams are required. Guaranteed exam spaces are provided in one of our UK exam centres. Check your closest exam centre. Throughout the course, various assignments will be required. These are not counted towards your final grade but offer an opportunity for tutor feedback and progress monitoring. 👩‍🎓 Course Outcomes Upon successful completion, you'll receive an IGCSE in Physics, awarded by Edexcel. This syllabus is specifically chosen for its suitability to distance learning. ℹ️ Additional Information Difficulty - Level 2 Entry Requirements - While there are no formal entry requirements, intermediate English reading and writing ability is recommended. Course Content Forces and motion Electricity Waves Energy resources and energy transfers Solids, liquids, and gases Magnetism and electromagnetism Radioactivity and particles Astrophysics

History buffs who appreciate the power of the past to elucidate the present, this is your calling. This AQA-accredited GCSE course delivers a comprehensive understanding of pivotal historical events, societies, and personalities, empowering you to ask insightful questions about our yesteryears. A gateway to studying history at A-level and beyond, this course has been expertly crafted by subject-specialists to hone crucial abilities such as critical thinking, essay composition, and analysis. Get engrossed in three riveting topics, starting with Germany from 1890-1945, as you understand the emergence and downfall of democracy, and the rise and collapse of Nazism. Explore the interwar years fraught with conflict and tension, tracing the seeds that sprouted into the Second World War. Submerge into the tempestuous era of Norman England, marked by power conflicts and the dawn of a fresh epoch. Lastly, scrutinise health and medicine's evolution from c100 to present times, underlining milestones like germ theory's development and transformative social reforms in public health. With us, you get: A contemporary course penned to the latest AQA specifications with vibrant, engaging content. An opportunity for fast tracking your study (exams in 2022). Access to our network of partner exam centres (guaranteed exam venue). Unlimited tutor assistance – guiding you to sketch a study plan and supporting you throughout. Exam pass assurance (If you fail the first attempt, we support until your next exam). Broaden your understanding of significant historical events, societies, and people, while cultivating the ability to question the past insightfully. About the awarding body Awarding body: AQA Our course code: X813 Qualification code: 8145 AQA qualifications, honoured in 30 countries globally, are highly esteemed by employers and universities, facilitating learners to progress onto their next life stages. They cater to diverse abilities and include GCSEs, IGCSEs, and A-levels. ⏱ Study Hours Allocate between 120 to 150 hours for study, and additional time for assignment completion. 👩‍🏫 Study Method Our course utilises our online learning platform, offering a lively and engaging learning experience. If you wish, you can print learning resources. Learning materials come in varied media forms, including videos, quizzes, and interactive activities. 📆 Course Duration Upon enrolment, you have up to two years for studying and examination, with sustained unlimited tutor support. 📋 Assessment Enrol now for examinations from Summer 2022. You'll have to undertake two GCSE standard written exams. Official exams 2-hour written exam, 50% of marks. 2-hour written exam, 50% of marks. We assure an exam space in one of our nationwide exam centres, sparing you the stress of finding your own. Check your nearest exam centre. Assignments Throughout the course, you are required to complete six assignments. These do not contribute towards your final grade but serve as practice opportunities for tutor feedback. They help you monitor your progress. 👩‍🎓 Course Outcomes Successful completion will earn you a GCSE in History, conferred by AQA. This syllabus has been handpicked as it best aligns with distance learning. ℹ️ Additional Information Difficulty - Level 2 Entry requirements - There are no formal prerequisites for this course, however, it is advised that you possess an intermediate ability to read and write in English. Course Content This course delves into key periods and events in history, from Germany's political turmoil in the first half of the 20th century to the power struggles of Norman England. You will also explore health and medicine's transformation from c1000 to the present day. Prepare for your final exams as you shape your understanding of the modern world and the nation.

Dealing with the challenges of Volatility, Uncertainty, complexity and Ambiguity

The significance of mathematics has never been more paramount in our world. Our expertly curated GCSE Mathematics course, a key requisite qualification, opens doors to college and university, vocational training, apprenticeships, and a plethora of employment opportunities. Math, an age-old discipline, not only supports many other subjects but is also an independent intellectual field, serving as the lingo of science and engineering. Our specially crafted course is engineered to ensure your success in achieving the qualification you seek. You have the flexibility to choose between Foundation or Higher level study. You're also allowed to switch levels in the initial phases of the course, after receiving feedback from your assignments and tutor. This ensures that by the time you register for exams, you've opted for the level that best suits your capability. Make no mistake, GCSEs are qualifications that truly matter. Advantages you stand to gain: A freshly conceived course, drafted to the most recent specification with dynamic, captivating content Fast-track option available for the 2022 exams Guaranteed exam venue within our network of partnered exam centres Unlimited tutor support – we assist you in drafting a study plan and provide continuous support Exam pass guarantee - should you not succeed the first time, we’ll support you up to the next exam Mathematics, akin to its core counterpart English, forms a fundamental building block for a multitude of educational pursuits and daily life. Excelling in maths fosters understanding in subjects like sciences, and even humanities such as Geography. It’s more than just number-crunching; it encompasses statistics, geometry, and an array of other critical skills. So, plunge into our comprehensive GCSE Mathematics course and chart your path towards the future. About the awarding body Awarding body: AQA Our course code: X801 Qualification code: 8300 AQA qualifications are globally recognized, taught in 30 countries worldwide, highly esteemed by employers and universities, and pave the way for learners to advance to their next life stage. AQA qualifications cater to various abilities and encompass GCSEs, IGCSEs and A-levels. ⏱ Study Hours: Allocate between 120 and 150 hours for study time, along with additional time for assignment completion. 👩‍🏫 Study Method: Our course is presented via our online learning platform for a dynamic and engaging learning experience. If you prefer, you can print the learning materials. The resources are in various media, including videos, quizzes, and interactive activities. 📆 Course Duration: After enrolment, you have a span of two years to complete your study and exams. Your unlimited tutor support will continue throughout this duration. 📋 Assessment: Enrol now for exams from Summer 2022. Our Maths GCSE is a tiered exam, meaning you choose the level of your exam study: Foundation tier: Grades 1 to 5, with grade 5 as the highest attainable and equivalent to grade C. Higher tier: Grades 4 to 9, with grade 9 as the highest attainable and equivalent to grade A*. Official exams comprise three GCSE standard written exams, each of 1 hour 30 minutes and each accounting for 33.3% of marks. You also have a guaranteed exam space in one of our exam centres across the country. Assignments: You will complete one introductory assignment and 10 other assignments throughout your course. While these do not contribute to your final grade, they provide a chance to submit work to your tutor for marking and feedback, helping you assess your progress. There is no coursework to complete. All exams must be taken in the same session. 👩‍🎓 Course Outcomes: Upon successful course completion, you will receive a GCSE in Mathematics, issued by AQA. We've chosen this syllabus specifically for its suitability to distance learning. ℹ️ Additional Information: Difficulty - Level 2 Entry Requirements - There are no formal prerequisites for this course, however, we recommend an intermediate ability to read and write in English. Course Content: Numbers: This module covers all aspects of integer-based maths, from basic operations to the use of standard units of mass, length, time, and more, laying a solid foundation for subsequent units. Algebra: This unit demystifies everything from basic algebraic notation to solving complex quadratic equations, by the end of which you'll master topics like quadratics and exponential functions. Ratios and Proportions: This segment sharpens your skills in comparing numerical data, a key skill in several sciences and engineering disciplines. Topics covered include value considerations and comparative skills. Geometry and Measures: This module extends beyond studying shapes, covering properties of angles, rotations, concepts of area and volume, and more. By the end of this unit, you'll find angles a cinch. Probability: This unit lets you delve into the intricacies of probability, covering various graphical representations like tree diagrams. Statistics: A crucial element in numerous subjects like Science and Geography, this unit involves skills like inferring information about populations based on statistical analysis and understanding primary or secondary data sets.

An in depth look at Pivot Tables and their powerful features to summarise and visualize your data. Course overview Duration: 1 day (6.5 hours) Our Excel – Pivot Table Specialist course is a comprehensive guide to working with Pivot Tables for those who need to learn more about the use of Pivot Tables to summarise and analyse information. This course is designed for existing experienced users of Excel. You should be a confident Excel user and be able to create and edit worksheets and write basic formulas. Objectives By the end of the course you will be able to: Build and customise Pivot Tables Group and sort information Filter information Use slicers and the timeline filter Add different summary calculations Create Pivot Charts Add calculated fields and items Content The anatomy of a Pivot Table Using a Pivot Cache Building a Pivot Table The Pivot Table interface Refreshing the Pivot Table Adding column, row, page and data fields Changing data orientation Showing data fields in columns or rows Drilling down to underlying data Setting Pivot Table options Format options Totals and filters options Display and printing options Data options Customising Pivot Tables Modifying field names Data formatting Changing field layout options Changing summary calculations Working with subtotals Filtering and sorting Filtering items Sorting data Value and label filters Creating top 10 reports Using the Search filter Using the Slicer tool Use the Timeline filter Grouping Grouping date fields Grouping numeric fields Adding your own groups Summary calculations Running totals Differences year on year, month on month % Differences year on year, month on month % of Row, Column, Total and other fields Pivot charts Pivot Chart rules Creating a Pivot Chart Working with your Pivot Chart Creating calculations Adding calculated fields Adding calculated items

Join our Microsoft Excel course and discover your hidden skills, setting you on a path to success in this area. Get ready to improve your skills and achieve your biggest goals. The Microsoft Excel course has everything you need to get a great start in this sector. Improving and moving forward is key to getting ahead personally. The Microsoft Excel course is designed to teach you the important stuff quickly and well, helping you to get off to a great start in the field. So, what are you looking for? Enrol now! You will Learn The Following Things: Learn strategies to boost your workplace efficiency. Hone your skills to help you advance your career. Acquire a comprehensive understanding of various topics and tips. Learn in-demand skills that are in high demand among UK employers This course covers the topic you must know to stand against the tough competition. The future is truly yours to seize with this Microsoft Excel. Enrol today and complete the course to achieve a certificate that can change your career forever. Details Perks of Learning with IOMH One-to-one support from a dedicated tutor throughout your course. Study online - whenever and wherever you want. Instant Digital/ PDF certificate 100% money back guarantee 12 months access Process of Evaluation After studying the course, an MCQ exam or assignment will test your skills and knowledge. You have to get a score of 60% to pass the test and get your certificate. Certificate of Achievement After completing the Microsoft Excel course, you will receive your CPD-accredited Digital/PDF Certificate for £5.99. To get the hardcopy certificate for £12.99, you must also pay the shipping charge of just £3.99 (UK) and £10.99 (International). Who Is This Course for? This Microsoft Excel is suitable for anyone aspiring to start a career in relevant field; even if you are new to this and have no prior knowledge, this course is going to be very easy for you to understand.  On the other hand, if you are already working in this sector, this course will be a great source of knowledge for you to improve your existing skills and take them to the next level.  This course has been developed with maximum flexibility and accessibility, making it ideal for people who don't have the time to devote to traditional education. Requirements There is no prerequisite to enrol in this course. You don't need any educational qualification or experience to enrol in the Microsoft Excel course. Do note: you must be at least 16 years old to enrol. Any internet-connected device, such as a computer, tablet, or smartphone, can access this online course. Career Path The certification and skills you get from this Microsoft Excel Course can help you advance your career and gain expertise in several fields, allowing you to apply for high-paying jobs in related sectors. Course Curriculum Unit 01: Excel from A-Z Course Introduction Excel from A-Z Course Intro 00:03:00 Excel Job Opportunities 00:03:00 Excel Job Types 00:04:00 Microsoft Excel Marketplace 00:04:00 What is Microsoft Excel? 00:04:00 Who is This Course For? 00:03:00 Unit 02: Getting Started With Excel Finding & Opening Excel 00:01:00 Excel's Start Screen 00:03:00 Explaining the Excel Interface 00:03:00 Excel Interface Continued 00:01:00 Excel Workbook vs. Excel Worksheet 00:02:00 Saving an Excel Document 00:04:00 Customizing the Quick Access Toolbar 00:02:00 Customizing the Excel Ribbon 00:03:00 Excel Shortcut Keys 00:02:00 Unit 03: Values, Referencing and Formulas Creating Excel Labels 00:03:00 Entering Numeric Values in Excel 00:03:00 Formatting Date Values in Excel 00:05:00 Building Basic Formulas in Excel 00:05:00 Order of Operations 00:06:00 Relative vs. Absolute Cell References 00:07:00 Unit 04: Intro to Excel Functions Excel Functions Explained 00:03:00 The SUM() Function 00:08:00 The MIN() & MAX() Function 00:04:00 The AVERAGE() Function 00:02:00 COUNT() Functions 00:05:00 Unit 05: Adjusting Excel Worksheets Moving & Copying Data 00:07:00 Insert & Delete Rows and Columns 00:05:00 Adjusting the Width and Height of Cells 00:05:00 Hiding and Unhiding Excel Rows and Columns 00:04:00 Renaming, Moving & Deleting Excel Worksheets 00:05:00 Adding Protection to Specific Cells 00:04:00 Protecting the Structure of a Workbook 00:02:00 Adding a Workbook Password to Open File 00:02:00 Unit 06: Visually Pleasing Cell Formatting Formatting Fonts and Cell Background Color 00:05:00 Adding Cell Borders 00:05:00 Formatting Data Appropriately 00:05:00 The Magic behind Excel's Format Painter 00:03:00 Creating Styles for Formatting Efficiency 00:06:00 Merging Cells for a Cleaner Look 00:03:00 The Power of Conditional Formatting 00:06:00 Unit 07: How to Insert Images and Shapes! Grab User's Attention using Illustrations 00:09:00 Customizing Icons 00:05:00 Create Compelling Graphics with SmartArt 00:06:00 Unit 08: Visualize Data with Charts The Commonly Used Column Chart 00:03:00 Changing the Chart Design.mp4 00:02:00 Formatting Elements of a Chart 00:06:00 Modifying the Data, Type & Location of a Chart 00:06:00 Unit 09: Excel's Printing Options Print Preview Options 00:04:00 Excel's Page Layout View 00:07:00 Printing a Specific Range of Cells 00:03:00 Converting Spreadsheets to PDF Files 00:02:00 Unit 10: Benefits of Using Excel Templates Why Create an Excel Template 00:01:00 How to Create an Excel Template 00:05:00 Unit 11: Working with Excel Datasets How to Prepare Data for Analysis 00:04:00 How to Sort Data in Excel 00:03:00 Multi-Level Sorting 00:03:00 Custom Sorting Datasets in Excel 00:02:00 Applying Filters to Datasets 00:05:00 Creating Subtotals within a Dataset 00:06:00 Converting Datasets into Tables 00:06:00 Little Slice of Pie Charts 00:05:00 Finding & Removing Duplicate Values 00:07:00 Unit 12: Excel Database Functions The SUMIF() Function 00:09:00 The DSUM() Function 00:08:00 The DSUM() Function Cont. 00:07:00 The SUBTOTAL() Function 00:06:00 Unit 13: Excel Data Validation What is Excel Data Validation? 00:02:00 Creating a Drop Down List with Data Validation 00:07:00 Different Types of Excel Data Validation 00:06:00 Adding Custom Alerts to Data Validation 00:07:00 Creating a Dynamic Drop Down List 00:03:00 Complex Validation: Dependent Drop Down List! 00:09:00 Unit 14: Excel PivotTables Creating an Excel Pivot Table 00:06:00 Modifying Excel PivotTables 00:06:00 Grouping & Filtering PivotTable Data 00:06:00 Drilling Down into PivotTable Data 00:02:00 Creating Pivot Charts & Utilizing Slicers 00:08:00 Unit 15: Excel's PowerPivot Add-In What is PowerPivot? 00:04:00 Activating the Excel PowerPivot Add-In 00:02:00 Creating Relationships between Data Tables.mp4 00:06:00 Using Data Models to Create PivotTables 00:05:00 How to Create PowerPivot KPI's 00:08:00 Unit 16: Excel's Conditional Functions Excels IF Function 00:05:00 IF() Function with AND() Criteria 00:05:00 IF() Function with OR() Criteria 00:05:00 Nesting Multiple IF() Functions 00:07:00 The COUNTIF() Function 00:04:00 Key Benefits of Named Ranges 00:04:00 Unit 17: Excel's Lookup Function VLOOKUP() Function 00:09:00 The Beauty of Excel's IFERROR() Function 00:04:00 HLOOKUP() Function 00:06:00 The INDEX Function 00:05:00 MATCH() Function 00:05:00 INDEX() and MATCH() Combined 00:05:00 Two-Way Lookup with INDEX() and MATCH() 00:04:00 Unit 18: Text Based Functions in Excel LEFT(), RIGHT() and MID() Function 00:07:00 Extracting Specific Text using LEN() & SEARCH() 00:13:00 Combining Text with CONCATENATE() 00:06:00 Quick Tips & Other Text Based Functions 00:06:00 Unit 19: Auditing Formulas and Views in Excel Tracing Precedents & Dependents in Formulas 00:04:00 Showing Formulas 00:02:00 Grouping Data 00:03:00 3D Referencing in Formulas 00:05:00 Utilizing the Watch Window in Excel 00:03:00 How to Freeze Panes in Excel 00:03:00 Unit 20: Excel's 'what If?' Tools Excel's Scenario Manager Tool 00:06:00 Goal Seek in Excel 00:06:00 Compare Results with Excel Data Tables 00:04:00 Solver Tool 00:11:00 Unit 21: Welcome to Excel VBA The Power Behind Excel VBA 00:03:00 A Look Inside the Visual Basic Editor (VBE) 00:04:00 Recording a Macro 00:09:00 Saving & Opening a Macro-Enabled Workbook 00:02:00 Unit 22: The VBA Language Modules and Procedures 00:07:00 Objects, Methods and Properties 00:06:00 Excel VBA Variables 00:05:00 Unit 23: Writing VBA Code Referencing a Range 00:13:00 InputBox & MsgBox 00:06:00 Using Variables in VBA Code 00:05:00 If Then Else Statement 00:10:00 Worksheet Functions inside VBA 00:08:00 Creating User Defined Functions 00:09:00 User Defined Functions within VBA Scripts 00:06:00 Unit 24: Important VBA Tools and Logic Find Last Row of Data 00:06:00 Find Last Column of Data 00:03:00 With Statement 00:05:00 Debugging & Error Handling 00:07:00 Debugging & Error Handling Cont. 00:07:00 Unit 25: Excel VBA Loop For Next Loop 00:09:00 Do Until Loop 00:06:00 For Each Loop 00:04:00 Unit 26: Triggering Macros Assigning Macros to Shapes 00:04:00 Form Controls vs ActiveX Controls 00:08:00 Worksheet Events 00:04:00 Workbook Events 00:03:00 Fun with VBA Events! 00:07:00 Unit 27: Excel User Forms Creating an Excel UserForm 00:03:00 Adding Controls to UserForms 00:10:00 How to Show an UserForm 00:03:00 Passing TextBox Values to Desired Cells 00:07:00 Passing Option Buttons to Desired Cells 00:07:00 UserForm ComboBoxes 00:08:00 Clearing Values from UserForm Controls 00:03:00 How to Close an UserForm 00:02:00 UserForms and Protected Sheets 00:05:00 Unit 28: Starting a Career in Excel Creating an Excel Resume 00:05:00 Getting Started with Freelancing 00:06:00 How to Become an Excel Freelancer 00:05:00 Top Freelance Websites 00:05:00 How to Get Your First Client 00:08:00 Personal Branding 00:07:00 Networking Do's and Don'ts 00:04:00 Importance of Having a Website 00:04:00 Resources Resources - Microsoft Excel 00:00:00

Getting Started The CMI Level 7 Certificate in Professional Consulting is designed for individuals wishing to develop their professional consultancy abilities and who will have the knowledge, skills and behaviours to drive consultancy activities in a senior capacity. The CMI Level 7 Certificate in Professional Consulting is a shorter course aimed at practising or aspiring Senior Management Consultants wishing to formalise or develop their learning. This CMI qualification has been developed in cooperation with the Institute of Consulting (IC). Achieving the CMI Level 7 Certificate in Professional Consulting qualification will enable you to develop your strategic consulting skills, including but not limited to organisational structure and culture, entry and diagnosis, communicating strategies for consulting and group dynamics, facilitating skills, etc. Key Benefits For learners: Develop strategic skills with consulting, such as organisational structure and culture Develop group dynamics Facilitating skills Develop your skills in one of seven core professional consulting subjects Provide tools and techniques for effective consulting For Organisation: Effectively communicating the core strategies for consulting Key Highlights Do you perceive yourself to be a successful Senior Professional Consultant? The CMI Level 7 Professional Consulting offered by the School of Business and Technology London is the ideal starting point for your career journey. Remember! The assessment for the qualification is done based on assignments only, and you do not need to worry about writing any exam. With the School of Business and Technology London, you can complete the qualification at your own pace, choosing online or blended learning from the comfort of your home. Learning and pathway materials and study guides developed by our CMI-approved tutors will be available around the clock in our cutting-edge learning management system. Most importantly, at the School of Business and Technology London, we will provide you with comprehensive tutor support through our dedicated support desk. If you choose your course with blended learning, you will also enjoy live sessions with an assigned tutor, which you can book at your convenience.   Career Pathways The CMI Level 7 Professional Consulting can open many career pathways including, but not limited to: Senior Management Consultant, with an estimated salary of £89,974 per annum Management Consultant, with an estimated salary of £85,000 per annum Senior Professional Consultant, with an estimated salary of £62,441 per annum About Awarding Body Chartered Management Institute established over 60 years ago as the British Institute of Management back then; it has developed the UK's very first diploma in management studies. In the years that followed CMI has consistently been at the forefront of all aspects of management and leadership. Today CMI is the only chartered professional awarding body committed to offering the highest standards in management and leadership excellence. Presently over 100,000 managers use its unique services daily. CMI qualifications aim for managers and leaders at any level, and it remains the only Awarding Body which can award Chartered Manager status - the ultimate management accolade. Employers highly value the qualifications awarded by CMI, and boost your career prospects. What is included? Learn 100% online at your own pace Dedicated support from expert tutors Dedicated Support Desk Portal: You can raise queries, request tutor support and ask for a call back whenever you need guidance and assistance. Elevate Knowledge: Your tutors will provide formative assessment feedback for each module, helping you improve your achievements throughout the program Schedule online personal tutor meetings whenever you want, which will help you get the most out of your studies and provide guidance, support and encouragement 10 months support period 24-hour access to the online learning platform 'MyLearnDirect' Schedule live online classes for each module at your convenience. (Blended learning only) Quality learning resources and study guides developed by CMI-approved tutors. All assessment materials are conveniently accessible through the online learning platform 'MyLearnDirect' Induction: We offer online and flexible learning induction to help you settle in and prepare for your online studies Access to CMI Management Direct. It has 100,000s of reliable and validated management and leadership resources, including company and industry reports, videos, checklists, E-books, and journals. You have access to CMI Membership and Support for the duration of your study. Assessment For each module you study, you will complete a written assignment of 4000 to 4500 words and submit it online at your MyLearnDirect learning portal. The submitted assignments will be assessed by your CMI-approved tutor. Entry Requirements This course is designed for practising or aspiring senior management consultants who want to formalise and develop their learning and build a wide range of skills and knowledge to succeed and progress in professional consulting. To be eligible for this course, you must: Be 21 years of age and over Have considerable work experience as a consultant in any sector or similar job role Possess the ability to complete the Level 7 Qualification Our friendly admissions advisors will provide the best advice, considering your needs and goals.  Progression IC and CMI recommend progression once completing the Professional Consulting qualifications would be to progress onto: CMI Level 7 Qualifications in Strategic Management and Leadership Why gain a CMI Qualification? The CMI Level 7 in Professional Consulting qualifications have been developed after extensive research to ensure the qualifications reflect the tasks and activities of managers in professional consulting roles in the workplace. You will develop your skills in one of seven core professional consulting subjects and learn the tools and techniques for effective consulting with the CMI Level 7 Certificate in Professional Consulting course. We have a range of units available for this CMI Level 7 course, and you can select the units depending on your career goals and progression. Once you complete this CMI Level 7 course, you will have the professionalism to deliver impact, behave ethically and demonstrate a commitment to continual learning and development. CMI graduates achieve remarkable things: 72% agree that their CMI qualification gave them a competitive edge in the job application process. 89% agree they use the skills learnt on their accredited qualification in their current role. 88% agree that the accredited qualification gave them good career prospects. Recent CMI graduates earn a median of 28k compared to just 21k for a typical business studies graduate. Employers highly value the qualifications awarded by CMI, and over 80% of managers agree that a CMI qualification is essential to becoming a professional manager. Learners must request before enrolment to interchange unit(s) other than the preselected units shown in the SBTL website because we need to make sure the availability of learning materials for the requested unit(s). SBTL will reject an application if the learning materials for the requested interchange unit(s) are unavailable. Learners are not allowed to make any request to interchange unit(s) once enrolment is complete. UNIT1- Personal and professional development for professional consultants Reference No : CMI 724 Credit : 7 || TQT : 70 LEARNING OUTCOME 1. Understand the factors which influence personal and professional development. 2. Know how to improve consulting capability through personal and professional development. UNIT2- Professional consulting expertise Reference No : CMI 725 Credit : 7 || TQT : 70 LEARNING OUTCOME 1. Be able to evidence professional consulting expertise. 2. Know how to develop a proposition to engage with an organisation in a consulting capacity. UNIT3- Delivering client requirements through professional consulting Reference No : CMI 726 Credit : 10 || TQT : 100 LEARNING OUTCOME 1. Be able to deliver client requirements through professional consulting. 2. Be able to reflect on the delivery and impact of professional consulting. UNIT4- Principles of professional consulting Reference No : CMI 720 Credit : 10 || TQT : 100 LEARNING OUTCOME 1. Understand the context and principles which underpin professional consulting. 2. Understand the impact of ethics, CSR and sustainability in professional consulting. UNIT5- Leadership in professional consulting Reference No : CMI 721 Credit : 9 || TQT : 90 LEARNING OUTCOME 1. Understand the role of leadership in professional consulting 2. Understand strategies for optimising the way people are developed and led. UNIT6- Practice of professional consulting Reference No : CMI 722 Credit : 10 || TQT : 100 LEARNING OUTCOME 1. Understand the process for client-centric professional consulting. 2. Understand the practice of professional consulting. UNIT7- Leading innovation and change through professional consulting Reference No : CMI 723 Credit : 9 || TQT : 90 LEARNING OUTCOME 1. Understand creative, contemporary and traditional approaches to innovation and change. 2. Know how to develop strategy to lead and manage change through professional consulting. Delivery Methods School of Business & Technology London provides various flexible delivery methods to its learners, including online learning and blended learning. Thus, learners can choose the mode of study as per their choice and convenience. The program is self-paced and accomplished through our cutting-edge Learning Management System. Learners can interact with tutors by messaging through the SBTL Support Desk Portal System to discuss the course materials, get guidance and assistance and request assessment feedbacks on assignments. We at SBTL offer outstanding support and infrastructure for both online and blended learning. We indeed pursue an innovative learning approach where traditional regular classroom-based learning is replaced by web-based learning and incredibly high support level. Learners enrolled at SBTL are allocated a dedicated tutor, whether online or blended learning, who provide learners with comprehensive guidance and support from start to finish. The significant difference between blended learning and online learning methods at SBTL is the Block Delivery of Online Live Sessions. Learners enrolled at SBTL on blended learning are offered a block delivery of online live sessions, which can be booked in advance on their convenience at additional cost. These live sessions are relevant to the learners' program of study and aim to enhance the student's comprehension of research, methodology and other essential study skills. We try to make these live sessions as communicating as possible by providing interactive activities and presentations. Resources and Support School of Business & Technology London is dedicated to offering excellent support on every step of your learning journey. School of Business & Technology London occupies a centralised tutor support desk portal. Our support team liaises with both tutors and learners to provide guidance, assessment feedback, and any other study support adequately and promptly. Once a learner raises a support request through the support desk portal (Be it for guidance, assessment feedback or any additional assistance), one of the support team members assign the relevant to request to an allocated tutor. As soon as the support receives a response from the allocated tutor, it will be made available to the learner in the portal. The support desk system is in place to assist the learners adequately and streamline all the support processes efficiently. Quality learning materials made by industry experts is a significant competitive edge of the School of Business & Technology London. Quality learning materials comprised of structured lecture notes, study guides, practical applications which includes real-world examples, and case studies that will enable you to apply your knowledge. Learning materials are provided in one of the three formats, such as PDF, PowerPoint, or Interactive Text Content on the learning portal. Management Direct As part of the program, you will get access to CMI Management Direct, which provides a rich foundation of management and resource for students. The Management Direct is packed with content, including: E-Books Articles Leader videos Idea for leaders Models and so much more... How does the Online Learning work at SBTL? We at SBTL follow a unique approach which differentiates us from other institutions. Indeed, we have taken distance education to a new phase where the support level is incredibly high.Now a days, convenience, flexibility and user-friendliness outweigh demands. Today, the transition from traditional classroom-based learning to online platforms is a significant result of these specifications. In this context, a crucial role played by online learning by leveraging the opportunities for convenience and easier access. It benefits the people who want to enhance their career, life and education in parallel streams. SBTL's simplified online learning facilitates an individual to progress towards the accomplishment of higher career growth without stress and dilemmas. How will you study online? With the School of Business & Technology London, you can study wherever you are. You finish your program with the utmost flexibility. You will be provided with comprehensive tutor support online through SBTL Support Desk portal. How will I get tutor support online? School of Business & Technology London occupies a centralised tutor support desk portal, through which our support team liaise with both tutors and learners to provide guidance, assessment feedback, and any other study support adequately and promptly. Once a learner raises a support request through the support desk portal (Be it for guidance, assessment feedback or any additional assistance), one of the support team members assign the relevant to request to an allocated tutor. As soon as the support receive a response from the allocated tutor, it will be made available to the learner in the portal. The support desk system is in place to assist the learners adequately and to streamline all the support process efficiently. Learners should expect to receive a response on queries like guidance and assistance within 1 - 2 working days. However, if the support request is for assessment feedback, learners will receive the reply with feedback as per the time frame outlined in the Assessment Feedback Policy.

“Photography is more than a medium for factual communication of ideas. It is a creative art" - Ansel Adams Photoshop For Photographers When you're ready to take the next step in your photo-education and learn to use Photoshop - our Photoshop for Photographers course will take you from Photoshop novice to someone who can confidently navigate it and use its super powerful tools to take your photos beyond what you thought was possible! So if you've ever dreamt about being able to use Photoshop, maybe even got as far as opening it and quickly get overwhelmed with all that's packed inside - we've got you. KEY COURSE INFO: Course type: Instructor-led Course level: 2 levels - Essential Photoshop ( L1) and Creative Photoshop (L2) Course duration: each course level consists of 4 weeks + prep module Course format: Online course with step by step tutorials, instructional videos and interactive edit-along live classes, feedback on your learning and support group WHAT YOU LEARN: Our Photoshop for Photographers is a 2 level course - the first one covering all the key aspects of understanding how to navigate and work in Photoshop along with its most widely used tools and techniques, the second one building on top of that to really boost the creative uses you can apply it to.  This incredibly in-depth course has everything you need as a photographer who wants to harness this amazing tool.  What you learn: from basic Photoshop tools to more complex photo manipulations, from playing with colour to portrait retouching, from adding light to removing any unwanted object from your photos and lots, lots more. key photoshop tools object removal and placements - face / sky swaps Overlays & blending modes The art of adding light Skin editing and retouching introduction to compositing THIS IS THE COURSE FOR YOU IF : You you already know basics of editing (in Lightroom) but want to take them further into Photoshop ( where more fun happens) You tried using Photoshop before only to close it immediately after opening due to all the overwhelmingly unfamiliar tools and options You followed youtube tutorials before but beside replicating what the person did exactly, you still don't really have a good idea of how to use Photoshop - or why you should!? You want to be able to take advantage of the tools that are missing in Lightroom or do not give you sufficient control over them to do the job seamlessly - such as precise ways of removing unwanted objects in your image - Photoshop's powerful tools, such as the Content-Aware Fill and Clone Stamp enable you to remove distracting objects or people from your photos, ensuring the focus remains on the subject You want to be able to manipulate or replace elements in your images - from turning your background blurry to replacing blank skies, doing face swaps and more You want to be able to bring beautiful light into your images - from haze to sun rays, from - with colours that pop and light that's perfectly balanced You want to be able to take yoru portraits to a new level - remove blemishes, retouch skin,and correct imperfections, giving your images a polished and professional finish. You desire to create stunning composites: With Photoshop, you can combine multiple images seamlessly to create captivating composite photos. This skill is particularly useful for photographers who want to tell stories or create imaginative and surreal images. ONE COURSE - 2 LEVELS ESSENTIAL PHOTOSHOP Pick this course if you're new to Photoshop or do not have a lot of experience in Photoshop In this course you learn to : Navigate the software and set it up for a proper, smart, non-destructive workflow Discover all the essential tools and techniques that take your images way beyond what you could do in Lightroom Learn the key skills : from masks to brushes, from blending modes to selections, from cloning to canvas extensions, from face swaps to sky swaps - and more!! CREATIVE PHOTOSHOP Pick this course if you're already familiar with the basic tools and ways of working in Photoshop  In this course you take all that you learned in the Essentials course and turbo boost it for creativity. You'll learn : How to play with light, colour and blur for unique creative outcomes How to get more out of the familiar tools - so advanced brushes, advanced selections, advanced blending More fun skills : from skin edits to retouching, from stitching photos to involved composites, from creating effects such as neon glow to turning your photos into comics and more! Learn more about Creative Photoshop WHAT'S INCLUDED IN EACH OF OUR PHOTOSHOP COURSES: 4 core modules - each with detailed step by step tutorials, downloadable videos and PDF workbooks Support Facebook group Weekly edit-along live webinar Practice files to learn on Feedback on your images ESSENTIAL PHOTOSHOP Next Essential Photoshop course starts 15 January 2024 The way you work in Photoshop is very different compared to Lightroom and a big learning curve for anyone who begins learning it for the first time. It's also a big reason why a lot of photographers open it for the first time, find it hard to recognise any familiar tools or make them work on the image and the give up.  In this course we take you through it step by step. We show you around this tool and teach you how to use it in a way that's smart, non-destructive, flexible and making the most of its amazing features.  Here is a non-exhaustive list of what you will learn:  A thorough understanding of Layers, masks and brushes - you cannot really work effectively in Photoshop if you do not know how to use these tools. An absolute must! Key Photoshop tools - Photoshop is a hugely vast tool used by lots of different creative professions and depending on what you use it for, you will be using different tools. We introduce you to the ones that are key for a photographer! Working with Adjustment layers - these fantastic tools allow you to change colours, adjust tone and mood of images Removing and replacing parts of your photos - powerful selection, healing, cloning, content aware tools and more to allow you to clean up your images of everything that's undesirable or distracting in your images Simple composites ( Face swaps / Sky swaps) - while composites can be hugely complex and challenging, we show you how to get started with a few simple - but effective ones!Understanding Precision tools and filters for blurring and sharpening Blending modes and their immense potential for transforming your images with the tools you already know - from working with overlays to CREATIVE PHOTOSHOP Next Creative Photoshop course starts 15 April 2024 In Level 2 we build on the foundation we establish in Level 1 and start applying what you have learned more creatively - as well as learning more tools, more techniques and starting more fun projects. This is where we really get to have fun with those powerful tools - we learn not just how to fix and clean up undesirable elements from the photos, but how to creatively treat them so that they reflect your creative vision and imagination.  The magic of Colour and blur - adding mood and softness to images to transform the images . We use several creative techniques to completel;y transform the images Adding and creating light effects in Photoshop - from light beams to sun burtsts to rainbows! Step by step skin editing and portrait retouching - from adjusting skin tones, removing unwanted colour casts, disappearing blemishes and creating highend, polished portraits that still retain healthy skin texture Using smart filters and creative adjustment layers to achieve effects such as turning your images into cartoons, watercolours or neon effects Working with and creating your own custom brushes, overlays etc - the power of photoshop brushes has to be experienced to be believed - from adding light rays to Playing with composites - adding magic to your images or creating new scenes and stories from scratch PHOTOSHOP For Photographers  Photoshop courses - KEY INFO Essential Photoshop ( Level 1) - 4 week course, starts 15 Jan 2024 Creative Photoshop ( Level 2) - 4 week course, 15 April 2024 Course cost: BOOKING A SINGLE COURSE: £179 ( payment plans available ) BOOKING A BUNDLE: Book Level 1 and Level 2 together :  £259  (payment plans available )  PHOTOSHOP FOR PHOTOGRAPHERS Each course consists of 4 weekly modules with step by step illustrated tutorials and videos + prep module weekly edit along class online class ( also recorded) feedback and advice on your edits private support group PDF workbook and downloadable videos Practice images to learn on COURSE PREREQUISITES: Adobe Photoshop software installed on your computer or tablet.This can be purchased either as a standalone Photoshop Subscription or as part of the Photography Plan which includes also access to Lightroom and Lightroom Classic. Please note that you need to ensure that your computer can run Photoshop - please follow Adobe minimum system requirements guidelines