47217 Courses delivered On Demand

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

Are you facing difficulty in dieting? Do you want to stay fit and want to maintain a healthy diet and nutrition for your body? This Dieting Course will help to gain a crystal clear knowledge and strategies about the rules of dieting. By the end of the course, you will gain information on what, when and how to eat healthy, and nutritious food. Course Description: A slim and fit body is every human's dream. DASH or Dietary Approaches to Stop Hypertension is a type of diet that is designed to treat or prevent high blood pressure (hypertension). By reducing the sodium in your diet and by ensuring a variety of foods rich in potassium, calcium and magnesium, the diet helps you lose weight. Obesity is one of the biggest problems in developed nations. Both adult and kids are affected by the problem. The present course will guide you to learn the proper dieting and fitness activities to avoid obesity and to become healthy and fit. Course Highlights Dash Dieting Course 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 Dash Dieting Course into 10 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 9 hours 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 Dash Dieting Course 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? Dash Dieting Course 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 Dash Dieting Course is fully compatible with any kind of device. Whether you are using Windows computer, Mac, smartphones or tablets, you will get the same experience while learning. Besides that, you will be able to access the course with any kind of internet connection from anywhere at any time without any kind of limitation. Career Path 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. Introduction 00:30:00 What Is This Thing The DASH Diet? 01:00:00 The History Of The DASH Diet 01:00:00 Is The DASH Diet All It's Cracked Up To Be? 01:00:00 Incorporating The DASH Diet Into Your Lifestyle 01:00:00 What To Eat And What To Avoid 01:00:00 A Day In The Life Of A DASH Diet 01:00:00 How Do I Shop For Groceries On The DASH Diet? 01:00:00 Dang! How Do I Eat At Restaurants On The DASH Diet? 01:00:00 Start Today 00:30:00 Mock Exam Final Exam

Saving money isn't about math. The secret to saving money is the matter of priorities. The general rule of thought is, the earlier a person starts to put money aside towards savings, the more likely this said amount will eventually become a rather attractive number to facilitate some form of suitable retirement plans. This course will discuss in detail about the importance of starting to save as early as possible. You will also learn how ideal it is to start investing early. Investing will help you save or earn more money for an additional source of cash flow. Lastly, you will be provided with robust savings method that will surely make you save more and stop overspending. Course Highlights Piggy Banking 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 Piggy Banking into 7 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 4 hours, 45 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 Piggy Banking 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? Piggy Banking 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 Piggy Banking 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. Start Savings Early 00:30:00 Savings Is Never Enough: Invest Now 01:00:00 Powerful Savings Method: 401k & IRA 01:00:00 Jump Into Mutual Fund Investments 00:30:00 Save Big On Expenses: Frugal Living 01:00:00 Engage yourself to A Financial Adviser Now! 00:30:00 Wrapping Up 00:15:00 Mock Exam Final Exam

Do you want to increase your network for business purposes? Or do you love to meet new people to make some business deal? Then this is the right course for you that will show you the tips for becoming an expert in Business Networking. Course Description: If you are in a business profession, you must need to contact with many people - it may be your potential clients, or it may be the people who are interested in doing business with you. The right contact can increase your sells and thus helps you to gain profit in business. The course will cover a detailed guideline about Business networking. The course includes the topics like the business networking basics, the networking procedures, how to contact properly with the clients, etc. Finally, the course will give you the idea to gain more money by the proper contact with the potentials clients. Course Highlights Multi Level Marketing (MLM) Business Course 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 Multi Level Marketing (MLM) Business Course into 16 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 12 hours, 45 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 Multi Level Marketing (MLM) Business Course 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? Business people, entrepreneurs, professionals or anyone who is interested in learning the tips for the right Business Networking. Multi Level Marketing (MLM) Business Course 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 Multi Level Marketing (MLM) Business Course is fully compatible with any kind of device. Whether you are using Windows computer, Mac, smartphones or tablets, you will get the same experience while learning. Besides that, you will be able to access the course with any kind of internet connection from anywhere at any time without any kind of limitation. Career Path 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. Introduction To Business Networking 00:15:00 How To Run A Successful Multilevel Marketing Business 01:00:00 Tips For Network Marketing Success 01:00:00 Benefits Of Outsourcing 01:00:00 Advantages Of Outsourcing Your Prospecting Efforts In MLM 01:00:00 Process Of Online Outsourcing Work 01:00:00 Outsourcing Tips For Network Marketers 01:00:00 Upgrade Your MLM Campaign With Outsourcing 00:30:00 Where Do Marketers Outsource Their Jobs? 01:00:00 Way To Start With Outsourcing A Job 00:30:00 Way To Pay Your Hired Staff When You Outsource 00:30:00 Building A Team Through Outsourcing Business 01:00:00 How To Make The Most Of Your Outsourcing 01:00:00 About Getting Revisions For Your Outsourced Work 00:30:00 What You Must Never Outsource 00:30:00 Important Tips For Outsourcing 01:00:00 Mock Exam Final Exam