47104 Courses delivered On Demand

Whether you're an indie game developer who wants to create your own game assets, or you are just starting out as a designer and want to get your foot in the door in 2D game art design, this Modular Game Art Creation course is going to benefit you. With this course, you will master in modular design and learn how to create 2D game tilesets and game assets effectively.  This Modular Game Art Creation course aims to teach you the techniques of creating fast, cheap and effective modular game assets in Inkspace. In a nutshell, after successful completion of the course, you'll get a better understanding of modular game art design and learn how to create real and effective modular designs for video games. What you'll learn You will be able to create your own 2D game tiles You will understand and able to create real and effective modular design for video games You will work much faster with Inkscape Requirements You will need to have a basic Inkscape knowledge Who this course is for: Indie game developers who want to create their own game assets Beginner designers, who want to get into 2D game art design What is modular design First question: What is REAL modular design? FREE 00:02:00 Is modular design for you? When to use it? FREE 00:03:00 The steps of creating modular design elements for video games 00:03:00 Creating simple spaceships with modular design Planning and designing the spaceship moduls 00:16:00 Create more moduls and guns for the spaceships 00:15:00 Finishing the spaceships and assemble some variations 00:05:00 Design modular character game art in Inkscape Start to create a set of modular cartoon faces! 00:11:00 Create the mouth and eyebrow moduls 00:10:00 Finish the cartoon head game assets by adding some hairstyles 00:18:00 Create a (a modular) army of goblins! Create the blueprint and the first goblin head 00:11:00 Design 2 more goblin heads 00:12:00 Add three bodies to the heads 00:12:00 Creating goblin arms and goblin legs 00:10:00 Create a set of fantasy weapons for our goblin minions! 00:15:00 Design a tileset for a 2D topdown game with Inkscape Creating the blueprints and the first tiles! 00:15:00 Building more grass tiles and understand the design method more! 00:17:00 Draw the final grass tiles and assembling them 00:10:00 Designing the blueprint and first assets for the water tiles 00:10:00 Creating the final water tiles and assembling them 00:14:00 Planning and creating the road tiles 00:16:00 Finalize the road tiles 00:08:00 Creating individual tiles and assemble a game world map from our tile system! 00:12:00

Learn how to design your PV system and take steps to become a fully qualified solar panel engineer with the FULL SOLAR ENERGY Design Course(With SketchUp & PVSYST). This course is an in-depth training program designed to provide an insight into the solar industry and solar PV installation. In this course, you will develop practical knowledge and skills to become an expert in the field of energy consumption. You will start by learning how modern technology converts solar energy into electricity, and on completion will have full knowledge of how to design a photovoltaic system. Throughout the course, you will make use of expert solar design software PVSYST and SketchUp, to analyse your data and utilise specialist tools. System pricing, technical reports, and payback period are also discussed in detail. What you'll learn Develop your knowledge of solar energy systems and its main components Learn how to build your own solar energy system at home Fast track your career in engineering and develop the required skills Understand the fundamentals of solar radiation and PV solar energy Learn how to conduct a solar energy site survey and technical report Explore renewable energy consumption and the benefits of solar energy Gain an understanding of how solar energy is measured and its units of power Get step-by-step guidance on how to use specialist design software PVSYST & SketchUp Requirements Passion to learn! Basic computer skills Who this course is for Engineering students Beginner Engineers in this field Beginner Solar energy worker Anyone who wants to enter this sector Introduction See what will you learn FREE 00:02:00 What is Solar Energy 00:02:00 Power & Units 00:03:00 The components of the system ( Detailed explination) Solar Penels 00:04:00 Inverter 00:03:00 Peak sun hours and Shading effect 00:04:00 Mounting Structure 00:03:00 Circuit Breaker 00:02:00 Design Stage & Installation Procedure Site Survey 00:03:00 Design Steps Part 1 00:05:00 Design Steps part 2 00:08:00 Installation Procedure 00:03:00 Design softwares SketchUp Tools part 1 00:07:00 SketchUp Tools part 2 00:06:00 Skelion Plugin For PV panels Integration 00:09:00 Design A system 00:07:00 Introduction to PVSYST 00:08:00 Design a system with PVSYST 00:04:00 Pricing, Payback Period, Technical and Financial Reports Pricing 00:06:00 Payback Period 00:02:00 Technical & finanical reports 00:04:00 Additional Resources Resources File: FULL SOLAR ENERGY Design Course(With SketchUp & PVSYST) 00:00:00

Fablous Fringy updos hairstyles anyone can do! In this course you will enjoy learning all about these modern and funky fringy updos. They are perfect for the unconventional bride and prom girls who wants something a little fun and different. There is also a separate tutorial on how to make the hair knots for these looks as well as a coiling tutorial. I am always available to talk to regarding this course or any of my courses. Once you see how I put these looks together you will be able to grow and learn in your skills and impress your clients and friends. Creating special occasion hair is so exciting as you are taking part in someone's life event! ~~~ Be sure to check out my bonus section at the end of this course, containing all of my contact information and social media contacts! As a Clarity Life Coach am here for you in life and career! Who is this course for? Professional hairdressers or students looking to improve speed, skills and confidence. Anyone who loves doing awesome hairstyles on family and friends! Are you a salon owner? I understand not everyone enjoys dressing hair, but for those interested, send them here for all of their updo and hair-styling education! What will I learn as a result of this course? Long hair is limitless! Fringy styles are back! You will learn the skills to bring smiles to your clients, family and friends! Hairdressing professionals will be able to ask for more money as their expertise grows and demand for their services increase. You will be able to have better informed conversations with your clients that will result in more services, excitement, and greater loyalty. What do I need to have in order to take this course?  To work along with the tutorials, you will need: A blow dryer, a small teasing brush and comb, a rat tail comb, curling iron, hot rollers, bobby pins and hairpins to match your hair color, large hair ties, small clear elastics, silver clips, and hairspray. Someone or yourself with long hair or a mannequin head to practice on. Time and patience, gentleness toward yourself and a never give up attitude!   Introduction Welcome to the Course FREE 00:03:00 About the Instructor Fringy FREE 00:03:00 Three Fabulous Fringy Updo course videos Wedding knots! 00:03:00 Easy twists: Dress them up for evening! 00:02:00 Two for one! This epic style is shown on long and mid length hair! 00:03:00 Skill Supporting Videos: Hair Knots Tutorial 00:11:00 Hair Coiling Tutorial 00:09:00 French Twist Tutorial 00:11:00 Bonus Section & Contact Information: Clarity Coaching with Gretchen Maurer 00:05:00 Course Certification

You will hardly find a company or business who doesn't use Microsoft Excel. It is one of the most popular spreadsheet tools that is used to store, organize and analyse data. You can also manipulate the data to create useful visuals to understand trends and calculations. Having a professional Microsoft Excel degree can become an asset for you. Whether you are planning to start your career or want a promotion, our Microsoft Excel 2010 Intermediate Level will help you greatly. Please note that this course is for intermediate level. If you haven't completed the beginners course, then it will be a bit difficult for you to cope up with the intermediate features. But, if you are a quick learner and can adapt with changes, then you can enrol to this course without any doubt and master Microsoft Excel easily. It will help you to stand out in the crowd with your advanced MS Excel skills to that you can stay ahead in the workplace. Course Highlights Microsoft Excel 2010 Intermediate Level is an award winning and the best selling course that has been given the CPD Certification & IAO accreditation. It is the most suitable course anyone looking to work in this or relevant sector. It is considered one of the perfect courses in the UK that can help students/learners to get familiar with the topic and gain necessary skills to perform well in this field. We have packed Microsoft Excel 2010 Intermediate Level into 13 modules for teaching you everything you need to become successful in this profession. To provide you ease of access, this course is designed for both part-time and full-time students. You can become accredited in just 10 hours, 40 minutes and it is also possible to study at your own pace. We have experienced tutors who will help you throughout the comprehensive syllabus of this course and answer all your queries through email. For further clarification, you will be able to recognize your qualification by checking the validity from our dedicated website. Why You Should Choose Microsoft Excel 2010 Intermediate Level Lifetime access to the course No hidden fees or exam charges CPD Accredited certification on successful completion Full Tutor support on weekdays (Monday - Friday) Efficient exam system, assessment and instant results Download Printable PDF certificate immediately after completion Obtain the original print copy of your certificate, dispatch the next working day for as little as £9. Improve your chance of gaining professional skills and better earning potential. Who is this Course for? Microsoft Excel 2010 Intermediate Level is CPD certified and IAO accredited. 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 backgrounds. Requirements Our Microsoft Excel 2010 Intermediate Level 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 You will be ready to enter the relevant job market after completing this course. You will be able to gain necessary knowledge and skills required to succeed in this sector. All our Diplomas' are CPD and IAO accredited so you will be able to stand out in the crowd by adding our qualifications to your CV and Resume. Microsoft Excel 2010 Intermediate Level Module One - Getting Started 00:30:00 Module Two - Working with Permissions and Options 01:00:00 Module Three - Sharing Workbooks 00:30:00 Module Four - Performing Advanced Formula and Function Tasks 01:00:00 Module Five - Working with Array Formulas 01:00:00 Module Six - Working with Functions 01:00:00 Module Seven - Working with Macros 01:00:00 Module Eight - Working with Forms 01:00:00 Module Nine - Applying Advanced Chart Features 01:00:00 Module Ten - Working with PivotTables and PivotCharts 01:00:00 Module Eleven - Using the Automated Analysis Tools Add -In 00:30:00 Module Twelve - Wrapping Up 00:30:00 Activities Activities-Microsoft Excel 2010 Intermediate Level 00:00:00 Mock Exam Mock Exam- Microsoft Excel 2010 Intermediate level 00:20:00 Final Exam Final Exam- Microsoft Excel 2010 Intermediate level 00:20:00

This 3 in 1 Life Coaching Certification Masterclass is designed for anyone who wants to start their own life coaching business and help others reach their personal and professional development goals. This course is a complete program to teach you everything there is to know about become a holistic coach by providing you all the tools you need to become a successful professional. It is just the perfect guide for both beginners or working professionals in the health and life-skill management sector, as it discussed all the mental and physical aspects of individuals and enables you to help your client towards a positive, healthy, and happy life. To help you through the process, we will guide you through how to become an accredited personal development coach, work with clients, and grow your life coaching business in a simple, step-by-step process.  From the fundamentals of good coaching techniques and exercises to how to design an action plan for you or your clients, this is the only guide you will ever need to learn everything you need to know about becoming a personal development coach. The program is equipped with several essential worksheets, e-books, and other printable resources, fully accessible for a life-time from anywhere and any device. What you'll learn Earn 3 CPD Accredited Certificates: Life Coaching, Health Coaching & Wellness Coaching Certificate Coach Others With Personal Development & Goal Setting Learn Proven Coaching Models & Exercises Create Individual Client Programs Start Your Own Life Coaching Business Who is this Course for? This course is perfect for professionals like therapists, physical and mental health workers, and growth hack programmers, who want to develop their life coaching skills to coach others about personal development, personal transformation, and self-improvement.  It is also great for beginners who want to earn about life coaching & personal development skills and aspire to build a career in the life coaching business. Requirements No specific qualifications are required. No prior psychological, health or fitness knowledge is assumed. Fully accessible from any internet-enabled smart device. Career Path This 3 Internationally recognized CPD Accredited Certification received upon course completion will boost up your resume if you are a professional in the psychological and physical health sector or aspiring to become a specialist Life coach, nutritionist, or therapist. Introduction What You Will Learn FREE 00:06:00 Get To Know Your Instructor FREE 00:02:00 How To Get Your CPD Certificates 00:01:00 PART 1: LIFE COACHING CERTIFICATION What Is Life Coaching 00:05:00 The Benefits Of Becoming A Life Coach 00:04:00 The Difference Between Coaching, Therapy, Mentoring & Training 00:03:00 The Responsibilities Of A Life Coach 00:03:00 Coaching Fundamentals Coaching Fundamentals Overview 00:02:00 Listening Introduction 00:02:00 The 3 Kinds Of Listening As A Coach 00:05:00 Your Listening Template 00:10:00 Questioning Introduction 00:01:00 Questioning & Coaching 00:03:00 How Coaching Questions Are Different From Normal Questions 00:02:00 The Different Types Of Coaching Questions 00:12:00 Questions Summary 00:03:00 Building Trust Introduction 00:01:00 The Trust Checklist Exercise 00:03:00 How To Build Trust As A Coach 00:08:00 More Trust Building Strategies 00:05:00 Understanding Personalities Understanding Personalities Overview 00:03:00 Big Five Personality Model 00:02:00 Myers Briggs Personality Model 00:04:00 Your Personality Model 00:09:00 How To Bring Out Your Strengths With This Model 00:10:00 Coaching Models Explained Coaching Models Introduction 00:02:00 GROW Model Explained 00:05:00 STEPPPA Model Explained 00:08:00 FUEL Model Explained 00:03:00 CLEAR Model Explained 00:04:00 Why We Will Use The GROW Model 00:01:00 Coaching Step 1: Goal Setting Step 1 Introduction 00:03:00 Why Defining Your Values Is Important 00:03:00 How To Define Your Personal Values 00:06:00 What Does Your Ideal Life Look Like? 00:04:00 The 4 Biggest Goal Setting Mistakes To Avoid 00:06:00 Stretch Goals Explained 00:03:00 Why You Should Start With Long Term Goals 00:05:00 Setting Your First Long Term Goal 00:06:00 Turning Long Term Goals Into Short Term Goals 00:05:00 Next Steps 00:01:00 Coaching Step 2: Reality Step 2 Introduction 00:01:00 Status Quo Explained 00:06:00 Wheel Of Life Excercise Explained 00:06:00 Big Rocks Exercise Explained 00:05:00 Coaching Example Step 2 00:05:00 Coaching Step 3: Options & Obstacles Step 3 Introduction 00:01:00 How To Brainstorm With Your Client(s) 00:05:00 How To Evaluate Your Brainstorming Ideas 00:05:00 'Spheres Of Influence' Excerise Explained 00:03:00 'Not To Do List' Exercise Explained 00:04:00 Coaching Example Step 3 00:07:00 Coaching Step 4: Will & Action Planning Step 4 Introduction 00:01:00 The 80/20 Rule Applied To Coaching 00:04:00 How To Design An Action Plan 00:03:00 Coaching Example Step 4 00:05:00 GROW Model Recap 00:03:00 How To Structure Your Coaching Sessions Structuring Your Sessions Introduction 00:01:00 How To Define Your Coaching Ground Rules 00:03:00 How Much Should You Charge 00:03:00 The Pre Coaching Call 00:03:00 Your First Coaching Session 00:03:00 Progress Evaluation Sessions 00:05:00 My Recommended Coaching Timeline 00:03:00 Client Coach Relationship Client Coach Relationship Intro 00:01:00 What Clients Expect From Their Coaches 00:04:00 Why Clients Choose One Coach Over Another 00:02:00 Client Coach Boundaries 00:03:00 How To Retain Clients Long Term 00:05:00 Advanced Coaching Strategies Advanced Coaching Strategies Introduction 00:01:00 Reframing Explained 00:07:00 Managing Emotional States 00:07:00 Understanding Representational Systems 00:08:00 Personal SWOT Analysis 00:06:00 Johari Window - Developing Self Awareness 00:05:00 Giving Good Feedback As A Coach 00:05:00 PART 2: HOLISTIC HEALTH COACHING CERTIFICATION Part 2 Introduction 00:03:00 What It Means To Be Healthy 00:04:00 What Does A Health Coach Do? 00:03:00 How Can You Combine Life Coaching & Health Coaching 00:02:00 Diet & Nutrition Fundamentals Diet Introduction 00:01:00 Your Health & Diet: How They Are Linked 00:04:00 The Consequences Of Following A Bad Diet 00:04:00 How To Eat For Longevity 00:01:00 What Are Calories? Explained 00:04:00 The Relationship Between Bodyweight And Health 00:05:00 Calories & Bodyweight In A Healthy Diet 00:02:00 The Surprising Results Of The Twinkie Diet 00:02:00 The Relationship Between Weight Loss And Health 00:03:00 Figuring Out How Many Daily Calories You Need 00:02:00 Calculating Your Total Daily Calories 00:03:00 Healthy Weight Ranges 00:02:00 The Best Foods For A Healthier Life 00:02:00 Best Protein Foods 00:01:00 Best Carbohydrate Foods 00:01:00 Best Dietary Fat Foods 00:01:00 How Much Of Each (Protein, Carbs, Fat)? 00:04:00 What About The Remaining Calories 00:01:00 Diet & Nutrition Coaching Client Assessment Introduction 00:01:00 Client Interview 00:04:00 How To Create A Diet Plan For Clients 00:09:00 Calculating BMI 00:03:00 Exercise Coaching: Cardio Cardio Introduction 00:01:00 The Different Types Of Cardio 00:03:00 Creating A Cardio Workout For A Client 00:04:00 How To Monitor Your Heart Rate During A Workout 00:02:00 Cardio vs Weigh Training - Which Is Better For Weight Loss 00:07:00 Exercise Coaching: Resistance Training Weight Training Introduction 00:01:00 Muscle Building Formula 00:07:00 The Science Behind Muscle Growth 00:04:00 Weight Training vs Bodyweight Training 00:02:00 How To Create A Beginner Workout Plan 00:09:00 5 Most Important Aspects Of Lifting Form 00:03:00 Progressive Overload 00:03:00 Hormone Health Explained Hormones Introduction 00:02:00 The 3 Types Of Hormones 00:03:00 The Endocrine System Explained 00:04:00 Hormones & Heart Disease 00:04:00 Anabolic Steroids: Why They Are So Dangerous 00:04:00 Most Important Hormones Overview 00:01:00 insulin 00:04:00 Glucagon 00:02:00 Adrenaline 00:03:00 Cortisol 00:04:00 Ghrelin 00:02:00 Leptin 00:03:00 Thyroid Hormones 00:02:00 Estrogen 00:03:00 Growth Hormone 00:01:00 Testosterone 00:03:00 Supplements How To Build Your Own Supplement Stack 00:09:00 Top 3 Beginner Supplements For Muscle Growth 00:04:00 The Best Supplements To Boost Immunity 00:04:00 The Best Supplements For Vegans & Vegetarians 00:02:00 The Best Supplements For Joint & Bone Health 00:02:00 The Best Supplements For Fat Loss 00:04:00 Health & Fitness Motivation Health & Fitness Motivation Introduction * 00:02:00 How To Get Out Of A Workout Rut 00:09:00 Health & Fitness FAQ Answered What Is Nutrient Density 00:04:00 Is Brown Sugar Better Than White Sugar 00:03:00 What Should You Train On Your First Day At The Gym? 00:07:00 Are Microwaves Harmful? 00:05:00 Fresh vs Frozen Food: Which Is Healthier 00:04:00 PART 3: WELLNESS COACHING CERTIFICATION Part 3 Introdudction 00:02:00 Stress Management The Difference Between Stress & Anxiety 00:03:00 Short vs Long Term Stress 00:02:00 The Effects Of Stress & Anxiety On Your Body 00:05:00 Proven Stress Management Strategies & Techniques 00:02:00 The Benefits Of Calm Breathing 00:03:00 Breathing Exercise #1 - Three Part Breath 00:02:00 Breathing Exercise #2 - Bellows Breath 00:02:00 Progressive Muscle Relaxation 00:03:00 Complete PMR Routine 00:07:00 Sleep Sleeping For A Longer Life 00:04:00 Tips To Fall Asleep Faster 00:03:00 Supplements For Improved Sleep 00:02:00 Emotional Self Care What Is Emotional Self Care 00:05:00 How To Accept Yourself 00:03:00 Taming Your Inner Critic 00:06:00 Getting A Different Perspecitive 00:04:00 Acknowledging Your Qualities 00:03:00 Getting Rid Of Time Consuming Commitments 00:06:00 How To Say 'No' To Others 00:05:00 Resources Resources - Life Coach Certification Masterclass: 3 Certifications In 1 00:00:00

This is NOT a Programming course, the Goal is to understand the theory behind the creation of games. You will learn about many different aspects of Game Design and how they work, such as: What a Game is (Goal, Interaction, Obstacles, and Rules) Types of Games (Digital, Analog, and Gamification) Game Loops Game Arcs Game Roles Game Industry (Publishers, Game Studios and Indie Game Studios) Game Purposes Layers of a Digital Game Tutorials (Explicit, Implicit) Licensing (Royalty free, Creative Commons) Game Design Document (+ Template) Crowdfunding Publishing Games (Google Play, App Store, Steam and Itch io) By the end of some classes, I'll challenge you to do some exercises, to help you learn better. They are not mandatory, but they can make you become a better game designer. You will also answer some Quizzes, to help you memorize what you learnt even more. You'll also be able to download the presentation used in this course. This course will help you create a bionic eye, after your know how games are made, playing them will never be the same again. What you'll learn Understand what makes a game be a game Get to know in which area the student fits better Know the differences between the different types of Game Producers Know the different Games Purposes Learn how to adjust and choose the best tutorial for each Target Audience Find free assets to use in their games, even commercially Fill a basic Game Design Document for their own games Choose the best Store to publish games, according to the team's goal Requirements There are absolutely no prerequisites to take this course. Who is the target audience? People who want to learn about the Game Industry People who want to understand Game Theory Anyone who plans to work with Games in any area Humans that want to create a Bionic eye and play games as a Game Designer Teams who want to learn how to earn money by making games Game Structure Introduction 00:01:00 What Is A Game 00:06:00 Game Types 00:06:00 Game Loops 00:06:00 Game Arcs 00:04:00 Game Indutry Game Roles - Part 1 00:07:00 Game Roles - Part 2 00:07:00 Game Industry 00:06:00 Game Purposes 00:04:00 Game Layers Game Layers 00:06:00 Tutorials 00:06:00 Licensing 00:06:00 Development Game Design Document and Game Design Canvas 00:06:00 Crowdfunding 00:05:00 Publishing 00:04:00 Top 10 Game Designer Mistakes 00:06:00 Thank You And Congratulations 00:01:00 Resources Resources - Welcome To Game Design - Introduction to Game Design Theory 00:00:00 Course Certification

Learning Objectives Introduction , Designing Tables for Better Data Entry , Sharing Data with Other Applications , Working with Action Queries , Advanced Query Techniques , Automating Processes with Macros , Advanced Form Techniques , Advanced Report Techniques , Conclusion   Pre-Requisites Access 365 Beginner or equivalent experience.   Description This course is designed to teach students intermediate level skills in Microsoft Access 365. In this course, students will learn to design tables for improved accuracy in data entry, review the various options to share data with other applications, learn about action queries, and review various advanced query techniques. Students will also learn how to automate processes with Macros, advanced form techniques, and advanced report techniques. This course prepares students for the Access 365 Advanced course.   Module 1: Design Tables for Better Data Entry Reviewing Table Design Principles 00:11:00 Setting Field Size, Formats, and Captions 00:11:00 Setting Default Values and Required Fields 00:05:00 Restricting Data Entry-Validation Rules 00:07:00 Restricting Data Entry-Input Masks 00:09:00 Module 2: Share Data with Other Apps Exporting Tables and Queries to Excel 00:05:00 Exporting Data to a SharePoint List 00:02:00 Importing Data from Excel 00:06:00 Importing Data from a SharePoint List 00:02:00 Linking External Data Sources 00:05:00 Using Word Merge 00:06:00 Module 3: Work with Action Queries What are Action Queries 00:04:00 Creating an Update Query 00:06:00 Creating an Append Query 00:04:00 Creating a Delete Query 00:04:00 Creating a Make Table Query 00:04:00 Changing Start Number of an Auto Number Field 00:04:00 Module 4: Advanced Query Techniques Modifying Query Joins 00:06:00 Using Self Joins to Combine Data 00:06:00 Creating Find Unmatched and Find Duplicate Queries 00:09:00 Creating Parameter Queries 00:05:00 Creating a Top X Query 00:02:00 Reviewing Calculated Query Fields 00:06:00 Summarizing Query Data with Totals 00:04:00 Creating Crosstab Queries 00:06:00 Module 5: Automate Processes with Macros Understanding Macro Basics 00:14:00 Creating Macros to Open Forms by Record 00:09:00 Validating Data Entry with Macros 00:10:00 Creating a Macro to Automate Data Entry 00:08:00 Advanced Data Entry Using Macros and DLOOKUP 00:11:00 Module 6: Advanced Form Techniques Using Conditional Formatting 00:04:00 Working with the New Label Name Property 00:03:00 Organizing Form Fields with Tab Controls 00:09:00 Creating an Option Group Control 00:06:00 Creating a Combo Box Control 00:04:00 Configuring a Combo Box Control to Show Search Results 00:04:00 Using a Subform to Show Data From a Related Table 00:06:00 Module 7: Advanced Report Techniques Inserting a Chart on a Report 00:07:00 Showing Data in Columns 00:07:00 Inserting a Subreport 00:05:00 Configuring Reports with Parameter Queries 00:03:00 Sending Reports 00:03:00 Resource Resource - Access 365 Intermediate 00:00:00 Final Exam Final Exam - Access 365 Intermediate 00:20:00

Description Here at iStudy, we put our heart and soul into every single course we design. We make sure that all our courses are designed and developed by industry experts. Our aim is to always provide value to our learners with quality courses. Our learners are our top priority, and you as a learner will gain tremendous knowledge and skill on this topic from this Inner Healing Miracles. The certification that you will receive upon completing this Inner Healing Miracles will help to boost your resume and will help you stand out among your peers in the competitive job market. Our course will help you get employed in the relevant field and advance your career. Enjoy this expertly made course from iStudy. Enrol now! Why You Should Choose Inner Healing Miracles Lifetime access to the course No hidden fees or exam charges Full Tutor support on weekdays (Monday - Friday) Efficient exam system, assessment and instant results Download Printable PDF certificate immediately after completion Obtain the original print copy of your certificate, dispatch the next working day for as little as £9. Improve your chance of gaining professional skills and better earning potential. Who is this Course for? Inner Healing Miracles is CPD Qualification Standards and CiQ accredited, and IAO accredited. 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 backgrounds. Requirements Our Inner Healing Miracles 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. The Secrets to Having Emotional Freedom Course Promo 00:03:00 Lesson 01: Introduction 00:02:00 Lesson 02: Dealing With Repressed Emotions 00:07:00 Lesson 03: Emotions - How To Release Negative Emotions Before They Affect Your Health 00:09:00 Lesson 04: Emotional Exhaustion - What It Is And How To Treat It 00:05:00 Lesson 05: Trapped Emotions - How To Release Emotions Stuck In Your Body 00:06:00 Lesson 06: Emotional Turbulence 00:03:00 Lesson 07: Coping With Emotional Pain 00:05:00 Lesson 08: A Mindfulness Practice For Welcoming Your Emotions 00:10:00 Lesson 09: Building Better Mental Health 00:04:00 Lesson 10: Conclusion - Final Thoughts & Ideas 00:01:00 Downloadable Resources Resource - The Secrets to Having Emotional Freedom 00:00:00

Description Here at iStudy, we put our heart and soul into every single course we design. We make sure that all our courses are designed and developed by industry experts. Our aim is to always provide value to our learners with quality courses. Our learners are our top priority, and you as a learner will gain tremendous knowledge and skill on this topic from this Fast Learner BluePrint. The certification that you will receive upon completing this Fast Learner BluePrint will help to boost your resume and will help you stand out among your peers in the competitive job market. Our course will help you get employed in the relevant field and advance your career. Enjoy this expertly made course from iStudy. Enrol now! Why You Should Choose Fast Learner BluePrint Lifetime access to the course No hidden fees or exam charges Full Tutor support on weekdays (Monday - Friday) Efficient exam system, assessment and instant results Download Printable PDF certificate immediately after completion Obtain the original print copy of your certificate, dispatch the next working day for as little as £9. Improve your chance of gaining professional skills and better earning potential. Who is this Course for? Fast Learner BluePrint is CPD Qualification Standards and CiQ accredited, and IAO accredited. 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 backgrounds. Requirements Our Fast Learner BluePrint 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. Speed Learning Training Course Promo 00:03:00 Lesson 01: Introduction 00:02:00 Lesson 02: Skill, Learning, and Acquisition 00:09:00 Lesson 03: Smart Learners and Efficient Learning 00:04:00 Lesson 04: 10 Remarkable Traits of Successful Learners 00:04:00 Lesson 05: Learning Styles to Help You Learn Faster and Smarter 00:04:00 Lesson 06: 10 Tactics on Increasing Brain Power, Memory, and Motivation to Learn Better 00:08:00 Lesson 07: 8 Powerful Learning Hacks to Boost Your Learning Ability 00:05:00 Lesson 08: 5 Hacks to Speed up the Learning Process 00:03:00 Lesson 09: 8 Ways to Train Your Brain to Learn Faster and Remember More 00:04:00 Lesson 10: Simple Brain Training Habits to Boost Your Brain Power 00:05:00 Lesson 11: Conclusion - Final Thoughts & Ideas 00:01:00

Learning Objectives Introduction , Customizing Excel , Analyzing Data with Logical Functions , Working with Lookup Functions , Using Text Functions , Working with Date and Time Functions , Formula Auditing , What-If Analysis , Worksheet and Workbook Protection , Automating with Macros , Working with Form Controls , Ensuring Data Integrity , Collaborating in Excel , Importing and Exporting Data to a Text File , Conclusion   Pre-Requisites Excel 365 Introduction and Intermediate courses or equivalent experience.   Description This course will teach students advanced concepts and formulas in Microsoft Excel 365. Students will learn functions such as SUMIF, AVERAGEIF, and COUNTIF, advanced lookup functions, and complex logical and text functions. Additionally, students will experiment with auditing formulas and error checking, use the What-If Analysis tools, learn the options for worksheet and workbook protection, review advanced use of PivotTables and PowerPivot add-in, work with Macros, use form controls, and ensure data integrity in their worksheets and workbooks. Students will also learn about Excel's many collaboration features and import and export data to and from their workbooks. Course Introduction Introduction 00:01:00 Section 01 Lesson 01-Customizing the Ribbon 00:09:00 Lesson 02-Customizing the Quick Access Toolbar 00:06:00 Lesson 03-Customizing the General and Formula Options 00:04:00 Lesson 04-Customizing the AutoCorrect Options 00:03:00 Lesson 05-Customizing the Save Defaults 00:04:00 Lesson 06-Customizing Advanced Excel Options 00:03:00 Section 02 Lesson 01-Working with the Most Common Logical Functions 00:03:00 Lesson 02-Understanding IF Functions 00:06:00 Lesson 03-Evaluating Data with the AND Function 00:05:00 Lesson 04-Evaluating Data with the OR Function 00:03:00 Lesson 05-Creating a Nested IF Function 00:05:00 Lesson 06-Using the IFS Function 00:03:00 Lesson 07-Summarizing Data with SUMIF 00:03:00 Lesson 08-Summarizing Data with AVERAGEIF 00:02:00 Lesson 09-Summarizing Data with COUNTIF 00:02:00 Lesson 10-Summarizing Data with MAXIFS and MINIFS 00:03:00 Lesson 11-Using the IFERROR Function 00:03:00 Section 03 Lesson 01-What are Lookup Functions 00:03:00 Lesson 02-Using VLOOKUP 00:08:00 Lesson 03-Using HLOOKUP 00:03:00 Lesson 04-Using VLOOKUP with TRUE 00:04:00 Lesson 05-Using HLOOKUP with TRUE 00:02:00 Lesson 06-Using the Index Function 00:03:00 Lesson 07-Using the MATCH Function 00:03:00 Lesson 08-Combining INDEX and MATCH 00:04:00 Lesson 09-Comparing Two Lists with VLOOKUP 00:02:00 Lesson 10-Comparing Two Lists with VLOOKUP and ISNA 00:04:00 Lesson 11-Using the New XLookup Function-v2 00:07:00 Lesson 12-Using Dynamic Array functions-v2 00:06:00 Lesson 13-Other New Functions-v2 00:04:00 Section 04 Lesson 01-What are Text Functions 00:01:00 Lesson 02-Using CONCAT, CONCATENATE, AND TEXTJOIN 00:04:00 Lesson 03-Using Text to Columns 00:02:00 Lesson 04-Using LEFT, RIGHT, and MID Functions 00:03:00 Lesson 05-Using UPPER, LOWER, and PROPER Functions 00:02:00 Lesson 06-Using the Len Function 00:03:00 Lesson 07-Using the Trim Function 00:01:00 Lesson 08-Using the SUBSTITUTE Function 00:02:00 Section 05 Lesson 01-What are Date and Time Functions 00:02:00 Lesson 02-Using TODAY, NOW, and DAY Functions 00:03:00 Lesson 03-Using NETWORKDAYS and YEARFRAC Functions 00:03:00 Section 06 Lesson 01-Showing Formulas 00:03:00 Lesson 02-Tracing Precedents and Dependents 00:04:00 Lesson 03-Adding a Watch Window 00:04:00 Lesson 04-Error Checking 00:04:00 Section 07 Lesson 01-Using the Scenario Manager 00:07:00 Lesson 02-Using Goal Seek 00:03:00 Lesson 03-Analyzing with Data Tables 00:04:00 Section 08 Lesson 01-Understanding Protection 00:02:00 Lesson 02-Encrypting Files with Passwords 00:05:00 Lesson 03-Allowing Specific Worksheet Changes 00:02:00 Lesson 04-Adding Protection to Selected Cells 00:03:00 Lesson 05-Additional Protection Features 00:03:00 Section 09 Lesson 01-What are Macros 00:03:00 Lesson 02-Displaying the Developer Tab 00:03:00 Lesson 03-Creating a Basic Formatting Macro 00:05:00 Lesson 04-Assigning a Macro to a Button 00:03:00 Lesson 05-Creating Complex Macros 00:04:00 Lesson 06-Viewing and Editing the VBA Code 00:04:00 Lesson 07-Adding a Macro to the Quick Access Toolbar 00:03:00 Section 10 Lesson 01-What are Form Controls 00:02:00 Lesson 02-Adding a Spin Button and Check Boxes 00:04:00 Lesson 03-Adding a Combo Box 00:07:00 Section 11 Lesson 01-What is Data Validation 00:02:00 Lesson 02-Restricting Data Entry to the Whole Numbers 00:02:00 Lesson 03-Restricting Data Entry to a List 00:04:00 Lesson 04-Restricting Data Entry to a Date 00:02:00 Lesson 05-Restricting Data Entry to Specific Text Lengths 00:01:00 Lesson 06-Composing Input Messages 00:02:00 Lesson 07-Composing Error Alerts 00:03:00 Lesson 08-Finding Invalid Data 00:02:00 Lesson 09-Editing and Deleting Validation Rules 00:01:00 Section 12 Lesson 01-Working with Comments-v2 00:03:00 Lesson 02-Printing Comments and Errors 00:02:00 Lesson 03-Sharing a Workbook 00:04:00 Lesson 04-Co-Authoring in Excel 00:02:00 Lesson 05-Tracking Changes in a Workbook 00:03:00 Lesson 06-Working with Versions 00:03:00 Lesson 07-Sharing files Via Email-v2 00:03:00 Section 13 Lesson 01-Importing a Text File 00:04:00 Lesson 02-Exporting Data to a Text File 00:01:00 Course Recap Recap 00:02:00 Additional Materials Resource - Excel 365 Advanced 00:00:00 Final Exam Final Exam - Excel 365 Advanced 00:20:00