1914 Secretarial & PA courses

Overview Eat good and live smart with your self-planned diet by enrolling in the highly effective Diet and Nutrition Complete Food Composition Diploma course. An Ayurvedic proverb says, 'When diet is wrong, medicine is of no use. When diet is correct, medicine is of no need'. Wherefore, there's certainly no magic shot other than eating healthy to live healthy. But, due to having inadequate knowledge of diet and nutrition, we tend to depend on experts where we often fail to understand their instructions. So, here is the well-researched course, outlined by a top nutritionist, offering you an opportunity to be a diet expert with in-depth knowledge regarding nutritious diets and a healthy lifestyle. Last but not least, the course modules are approached using scientific and theoretical concepts which will foster your professional skill development as well. How will I get my certificate? You may have to take a quiz or a written test online during or after the course. After successfully completing the course, you will be eligible for the certificate. Who is this course for? There is no experience or previous qualifications required for enrolment on this Diet and Nutrition Complete Food Composition Diploma. It is available to all students, of all academic backgrounds. Requirements Our Diet and Nutrition Complete Food Composition Diploma is fully compatible with PC's, Mac's, Laptop, Tablet and Smartphone devices. This course has been designed to be fully compatible on tablets and smartphones so you can access your course on wifi, 3G or 4G. There is no time limit for completing this course, it can be studied in your own time at your own pace. Career path Having these various qualifications will increase the value in your CV and open you up to multiple sectors such as Business & Management , Admin, Accountancy & Finance, Secretarial & PA, Teaching & Mentoring etc. Course Curriculum 10 sections • 75 lectures • 03:01:00 total length •Course Promo: 00:02:00 •Introduciton & What you will learn in the course: 00:04:00 •who this course is for: 00:02:00 •what is nutrition: 00:01:00 •The principles of healthy dieting: 00:04:00 •the true dieting pyramid: 00:04:00 •Calories Explained: 00:04:00 •bodyweight and health: 00:05:00 •Calories & bodyweight in a healthy diet: 00:02:00 •the twinkie diet: 00:02:00 •weight loss and health: 00:03:00 •How many calories do you need daily: 00:02:00 •How To Determin Your Optimal Calorie Intake: 00:03:00 •healthy weight ranges: 00:02:00 •How to lose weight if you are close to the optimal range: 00:03:00 •How to lose weight when you start from a higher weight: 00:02:00 •Diet breaks: 00:05:00 •How to track calories: 00:05:00 •How to lose weight without tracking calories: 00:04:00 •food composition intro: 00:03:00 •Protein Composition copy: 00:02:00 •Carbohydrate Composition copy: 00:03:00 •Fat Composition copy: 00:01:00 •Overview food composition: 00:03:00 •Macros intro: 00:01:00 •Protein Explained: 00:02:00 •protein needs for overall health: 00:02:00 •How Much Carbs should you eat per day copy: 00:01:00 •How Much Fat Should You Eat Per Day copy: 00:04:00 •Overview Macronutrients: 00:03:00 •Nutrient Timing Intro: 00:02:00 •Nutrient Timing Facts: 00:04:00 •Nutrient Timing Recommendations: 00:02:00 •Supplements intro: 00:04:00 •Why Mulitvitamins arent a good idea: 00:02:00 •supplements for vegans and vegetarians: 00:02:00 •supplements for joint health: 00:02:00 •supplements for improved sleep: 00:02:00 •supplements for better memory and focus: 00:02:00 •Supplements Overview: 00:01:00 •How to naturally increase testosterone: 00:07:00 •basics of healthy dieting: 00:02:00 •making changs towards a healthier diet: 00:04:00 •How to read a nutrition label copy: 00:03:00 •diet myths into: 00:01:00 •Dieting myth #1 Carbs are bad for you copy: 00:02:00 •Dieting Myth #2 Fat is bad for you copy: 00:02:00 •Dieting Myth #3 Protein is bad for you copy: 00:04:00 •Dieting Myth #4 Eating Eggs Raises Cllesterol copy: 00:01:00 •Dieting Myth #5 Avoid Salt At All Cost copy: 00:01:00 •Dieting Myth #6 Eat several small meals throughout the day to lose weight copy: 00:01:00 •Dieting Myth #7 Diet Foods Will Lead To Weight Loss copy: 00:01:00 •Red meat always causes cancer copy: 00:03:00 •Common Diets Intro 2 copy: 00:01:00 •Gluten Free Diet Explained copy: 00:03:00 •Paleo Diet Explained copy: 00:04:00 •Low Carb Diet Explained copy: 00:03:00 •Intermittend Fasting Explained copy: 00:03:00 •Vegan Diet Explained copy: 00:05:00 •Micronutrients Introduction 2 copy: 00:01:00 •Vitamin A copy: 00:02:00 •Vitamin B copy: 00:01:00 •Vitamin C copy: 00:01:00 •Vitamin D copy: 00:02:00 •Vitmain E copy: 00:01:00 •Vitamin K copy: 00:01:00 •Calcium copy: 00:02:00 •Magnesium copy: 00:01:00 •Phosphorus copy: 00:01:00 •Potassium copy: 00:01:00 •Sodium copy: 00:01:00 •Copper copy: 00:01:00 •Iron copy: 00:01:00 •Zinc copy**: 00:02:00 •water copy: 00:04:00

Overview Ensure you have all the knowledge and facts needed to craft a safe and effective fitness plan for your personal goals. This intuitive course will raise your awareness of the need for nutrition and exercise in a lifestyle and drive you to a healthier state. The Improving Personal Health and Nutrition Level 3 course understands that people need help and guidance to get truly fit and healthy, so you will be taught the many different aspects you need to consider when striving for your goals. Alongside dietary changes and exercise routines, you will be advised on your personal anatomy and also your psychological requirements. How will I get my certificate? You may have to take a quiz or a written test online during or after the course. After successfully completing the course, you will be eligible for the certificate. Who is this course for? There is no experience or previous qualifications required for enrolment on this Improving Personal Health and Nutrition Level 3. It is available to all students, of all academic backgrounds. Requirements Our Improving Personal Health and Nutrition Level 3 is fully compatible with PC's, Mac's, Laptop, Tablet and Smartphone devices. This course has been designed to be fully compatible on tablets and smartphones so you can access your course on wifi, 3G or 4G. There is no time limit for completing this course, it can be studied in your own time at your own pace. Career path Having these various qualifications will increase the value in your CV and open you up to multiple sectors such as Business & Management , Admin, Accountancy & Finance, Secretarial & PA, Teaching & Mentoring etc. Course Curriculum 11 sections • 76 lectures • 03:01:00 total length •Course Promo: 00:02:00 •Introduciton & What you will learn in the course: 00:04:00 •who this course is for: 00:02:00 •what is nutrition: 00:01:00 •The principles of healthy dieting: 00:04:00 •the true dieting pyramid: 00:04:00 •Calories Explained: 00:04:00 •bodyweight and health: 00:05:00 •Calories & bodyweight in a healthy diet: 00:02:00 •the twinkie diet: 00:02:00 •weight loss and health: 00:03:00 •How many calories do you need daily: 00:02:00 •How To Determin Your Optimal Calorie Intake: 00:03:00 •healthy weight ranges: 00:02:00 •How to lose weight if you are close to the optimal range: 00:03:00 •How to lose weight when you start from a higher weight: 00:02:00 •Diet breaks: 00:05:00 •How to track calories: 00:05:00 •How to lose weight without tracking calories: 00:04:00 •food composition intro: 00:03:00 •Protein Composition copy: 00:02:00 •Carbohydrate Composition copy: 00:03:00 •Fat Composition copy: 00:01:00 •Overview food composition: 00:03:00 •Macros intro: 00:01:00 •Protein Explained: 00:02:00 •protein needs for overall health: 00:02:00 •How Much Carbs should you eat per day copy: 00:01:00 •How Much Fat Should You Eat Per Day copy: 00:04:00 •Overview Macronutrients: 00:03:00 •Nutrient Timing Intro: 00:02:00 •Nutrient Timing Facts: 00:04:00 •Nutrient Timing Recommendations: 00:02:00 •Supplements intro: 00:04:00 •Why Mulitvitamins arent a good idea: 00:02:00 •supplements for vegans and vegetarians: 00:02:00 •supplements for joint health: 00:02:00 •supplements for improved sleep: 00:02:00 •supplements for better memory and focus: 00:02:00 •Supplements Overview: 00:01:00 •How to naturally increase testosterone: 00:07:00 •basics of healthy dieting: 00:02:00 •making changs towards a healthier diet: 00:04:00 •How to read a nutrition label copy: 00:03:00 •diet myths into: 00:01:00 •Dieting myth #1 Carbs are bad for you copy: 00:02:00 •Dieting Myth #2 Fat is bad for you copy: 00:02:00 •Dieting Myth #3 Protein is bad for you copy: 00:04:00 •Dieting Myth #4 Eating Eggs Raises Cllesterol copy: 00:01:00 •Dieting Myth #5 Avoid Salt At All Cost copy: 00:01:00 •Dieting Myth #6 Eat several small meals throughout the day to lose weight copy: 00:01:00 •Dieting Myth #7 Diet Foods Will Lead To Weight Loss copy: 00:01:00 •Red meat always causes cancer copy: 00:03:00 •Common Diets Intro 2 copy: 00:01:00 •Gluten Free Diet Explained copy: 00:03:00 •Paleo Diet Explained copy: 00:04:00 •Low Carb Diet Explained copy: 00:03:00 •Intermittend Fasting Explained copy: 00:03:00 •Vegan Diet Explained copy: 00:05:00 •Micronutrients Introduction 2 copy: 00:01:00 •Vitamin A copy: 00:02:00 •Vitamin B copy: 00:01:00 •Vitamin C copy: 00:01:00 •Vitamin D copy: 00:02:00 •Vitmain E copy: 00:01:00 •Vitamin K copy: 00:01:00 •Calcium copy: 00:02:00 •Magnesium copy: 00:01:00 •Phosphorus copy: 00:01:00 •Potassium copy: 00:01:00 •Sodium copy: 00:01:00 •Copper copy: 00:01:00 •Iron copy: 00:01:00 •Zinc copy**: 00:02:00 •water copy: 00:04:00 •Assignment - Improving Personal Health and Nutrition Level 3: 00:00:00

Overview This comprehensive course on Landscape Photography will deepen your understanding on this topic. After successful completion of this course you can acquire the required skills in this sector. This Landscape Photography comes with accredited certification, which will enhance your CV and make you worthy in the job market. So enrol in this course today to fast track your career ladder. How will I get my certificate? You may have to take a quiz or a written test online during or after the course. After successfully completing the course, you will be eligible for the certificate. Who is This course for? There is no experience or previous qualifications required for enrolment on this Landscape Photography. It is available to all students, of all academic backgrounds. Requirements Our Landscape Photography is fully compatible with PC's, Mac's, Laptop, Tablet and Smartphone devices. This course has been designed to be fully compatible with tablets and smartphones so you can access your course on Wi-Fi, 3G or 4G. There is no time limit for completing this course, it can be studied in your own time at your own pace. Career Path Having these various qualifications will increase the value in your CV and open you up to multiple sectors such as Business & Management, Admin, Accountancy & Finance, Secretarial & PA, Teaching & Mentoring etc. Course Curriculum 11 sections • 79 lectures • 05:13:00 total length •Module 01: Introduction to Nature Photography: 00:02:00 •Module 02: What Is Landscape Photography?: 00:01:00 •Module 01: Overall: 00:01:00 •Module 02: Camera: 00:02:00 •Module 03: Sensors: 00:02:00 •Module 04: Lenses: 00:03:00 •Module 05: Pro vs Budget Lenses: 00:03:00 •Module 06: Prime Lenses: 00:02:00 •Module 07: Tripod: 00:03:00 •Module 08: Filters: 00:02:00 •Module 09: Other Accessories: 00:04:00 •Module 01: Introduction to Camera Basic: 00:01:00 •Module 02: ISO: 00:03:00 •Module 03: ISO Practical: 00:03:00 •Module 04: ISO Practical Night: 00:02:00 •Module 05: Shutter Speed: 00:01:00 •Module 06: Practical of Shutter Speed: 00:03:00 •Module 07: Shutter Speed Waterfall: 00:04:00 •Module 08: Aperture: 00:03:00 •Module 09: Practical Aperture: 00:05:00 •Module 10: Aperture Low Light Photography: 00:03:00 •Module 11: Exposure Triangle: 00:03:00 •Module 12: Aperture Priority: 00:03:00 •Module 01: Introduction to Advanced Camera Basics: 00:02:00 •Module 02: Histogram: 00:03:00 •Module 03: Expose to the Right: 00:02:00 •Module 04: Metering Modes: 00:02:00 •Module 05: Exposure Compensation: 00:02:00 •Module 06: RAW vs JPEG: 00:03:00 •Module 07: What is RAW?: 00:02:00 •Module 08: Dynamic Range: 00:03:00 •Module 09: White Balance: 00:03:00 •Module 01: Introduction to Focusing: 00:01:00 •Module 02: Hyperfocal Distance vs Single Point: 00:03:00 •Module 03: Aperture in Focusing: 00:02:00 •Module 04: Aperture, Focusing & Lens: 00:03:00 •Module 05: Focusing with a Wide-Angle Lens: 00:05:00 •Module 06: Focusing For Telephoto Photography: 00:04:00 •Module 01: What is a Polarizing Filter?: 00:02:00 •Module 02: How a Polarizer Works Near Waterfalls: 00:03:00 •Module 03: How a Polarizer Works Reducing Haze: 00:03:00 •Module 04: What is Nd Filter?: 00:02:00 •Module 05: Nd Filter to Achieve Silky Water: 00:04:00 •Module 06: What is Color Cast?: 00:02:00 •Module 01: Introduction to Exposure: 00:01:00 •Module 02: Dynamic Range & Expose to the Right: 00:04:00 •Module 03: The Impact of Light in Photography: 00:03:00 •Module 04: Finding the Correct Light: 00:04:00 •Module 05: Single Exposure Sunset: 00:04:00 •Module 06: Why Exposure Bracketing Helps You to Take Better Image: 00:05:00 •Module 01: Introduction to Composition: 00:01:00 •Module 02: Element of Composition: 00:03:00 •Module 03: Rules of Third: 00:04:00 •Module 04: Farming a Subject: 00:02:00 •Module 05: Leading Lines: 00:05:00 •Module 06: Diagonals: 00:03:00 •Module 07: Using S and Z curves: 00:05:00 •Module 08: Changing Perspective with Different Focal Ranges: 00:05:00 •Module 09: Changing Perspective through Framing: 00:02:00 •Module 10: Simple Reflection Photography: 00:03:00 •Module 01: Wide-Angle Photography: 00:04:00 •Module 02: Telephoto Photography: 00:06:00 •Module 03: Focus Stacking: 00:12:00 •Module 04: Panoramic: 00:07:00 •Module 05: Creating Scales: 00:03:00 •Module 06: Minimalist Nature Photography: 00:04:00 •Module 07: Creating Leading Lines from Long Exposure: 00:04:00 •Module 01: Introduction to Photo Editing: 00:01:00 •Module 02: Editing in Lightroom: 00:06:00 •Module 03: Global Adjustment: 00:21:00 •Module 04: Local Adjustment: 00:12:00 •Module 05: Histogram (Expose to the Right): 00:07:00 •Module 06: Grab Filter Effect: 00:12:00 •Module 07: Editing an Image like a Professional: 00:17:00 •Module 08: How to Focus Stack: 00:12:00 •Module 09: How to Remove Color Cast: 00:04:00 •Module 10: How to Blend Multiple Image: 00:05:00 •Module 11: How to Stitch a Pano: 00:07:00 •Assignment - Landscape Photography: 00:00:00

Overview This comprehensive course on Django Rest Framework Level 4 will deepen your understanding on this topic. After successful completion of this course you can acquire the required skills in this sector. This Django Rest Framework Level 4 comes with accredited certification, which will enhance your CV and make you worthy in the job market. So enrol in this course today to fast track your career ladder. How will I get my certificate? You may have to take a quiz or a written test online during or after the course. After successfully completing the course, you will be eligible for the certificate. Who is This course for? There is no experience or previous qualifications required for enrolment on this Django Rest Framework Level 4. It is available to all students, of all academic backgrounds. Requirements Our Django Rest Framework Level 4 is fully compatible with PC's, Mac's, Laptop, Tablet and Smartphone devices. This course has been designed to be fully compatible with tablets and smartphones so you can access your course on Wi-Fi, 3G or 4G. There is no time limit for completing this course, it can be studied in your own time at your own pace. Career Path Having these various qualifications will increase the value in your CV and open you up to multiple sectors such as Business & Management, Admin, Accountancy & Finance, Secretarial & PA, Teaching & Mentoring etc. Course Curriculum 15 sections • 82 lectures • 04:40:00 total length •Module 01: Course and Instructor Introduction: 00:03:00 •Module 02: How to make the best of this course: 00:02:00 •Module 01: What is REST?: 00:06:00 •Module 02: Why REST: 00:08:00 •Module 03: What and Why DJango REST Framework: 00:06:00 •Module 01: Install DJango: 00:03:00 •Module 02: Install DJango REST Framework: 00:01:00 •Module 03: Install MySql and MySql workbench: 00:03:00 •Module 04: Launch MySql workbench: 00:02:00 •Module 05: Install python mysqlclient: 00:01:00 •Module 06: Install ATOM: 00:03:00 •Module 07: Install Postman: 00:01:00 •Module 01: Create the project: 00:02:00 •Module 02: Create a view: 00:02:00 •Module 03: Configure the URL and TEST: 00:03:00 •Module 04: Create app level urls: 00:02:00 •Module 05: Create a model class: 00:03:00 •Module 06: Configure the database and run migrations: 00:03:00 •Module 07: Use the model in the view and test: 00:03:00 •Module 01: DRF Components: 00:06:00 •Module 02: Function Based Views: 00:05:00 •Module 03: Serializers: 00:04:00 •Module 04: Create the Project: 00:02:00 •Module 05: Create the Model: 00:02:00 •Module 06: Create the Serializer: 00:02:00 •Module 07: GET single student: 00:04:00 •Module 08: Create Student: 00:04:00 •Module 09: Implement Non Primary Key Based Operations: 00:07:00 •Module 10: Use @api_view: 00:01:00 •Module 11: Configure the URLs: 00:02:00 •Module 12: Test: 00:07:00 •Module 13: Test Using Postman: 00:04:00 •Module 01: Introduction: 00:01:00 •Module 02: Create the Project: 00:01:00 •Module 03: Implement Non Primary Key Based Operations: 00:06:00 •Module 04: Implement Primary Key Based Operations: 00:07:00 •Module 05: Configure the URLs and TEST: 00:04:00 •Module 01: Introduction: 00:05:00 •Module 02: Non Primary Key based operations: 00:04:00 •Module 03: Primary Key based operations: 00:02:00 •Module 04: Configure the URLs and TEST: 00:02:00 •Module 01: Generics: 00:03:00 •Module 02: Generics in action: 00:03:00 •Module 01: Introduction: 00:03:00 •Module 02: Create ViewSet: 00:02:00 •Module 03: Configure URLs and Test: 00:04:00 •Module 01: Create the Project: 00:03:00 •Module 02: Create model: 00:03:00 •Module 03: Create Serializers: 00:04:00 •Module 04: Create REST endpoints: 00:03:00 •Module 05: Configure URLs: 00:02:00 •Module 06: Test: 00:03:00 •Module 01: Introduction: 00:06:00 •Module 02: Pagination in action: 00:05:00 •Module 03: Pagination at class level: 00:03:00 •Module 04: Using LimitOffsetPagination: 00:01:00 •Module 01: Introduction: 00:04:00 •Module 02: Authentication in action: 00:03:00 •Module 03: Authorization in action: 00:06:00 •Module 04: Global Security: 00:04:00 •Module 01: Usecase: 00:01:00 •Module 02: Create the Project: 00:01:00 •Module 03: Create Model Classes: 00:03:00 •Module 04: Create Reservation Model: 00:01:00 •Module 05: Create Serializers: 00:01:00 •Module 06: Create ViewSets: 00:02:00 •Module 07: Configure the Router: 00:02:00 •Module 08: Run Migrations: 00:01:00 •Module 09: Initial round of testing: 00:04:00 •Module 10: Implement findFlights endpoint: 00:03:00 •Module 11: Test findFlights: 00:05:00 •Module 12: Implement Save Reservation: 00:06:00 •Module 13: Test Save Reservation: 00:04:00 •Module 01: In-Built Validations: 00:04:00 •Module 02: Allowing Blank and Null Values: 00:02:00 •Module 03: Create Custom Validator: 00:05:00 •Module 04: Two more ways: 00:07:00 •Module 01: Introduction: 00:03:00 •Module 02: Configure Token Auth: 00:05:00 •Module 03: Create Users and Token: 00:04:00 •Module 04: Token Auth in action: 00:03:00 •Module 05: Automate Token Creation: 00:09:00

Overview Learn to use the full power and functionality of Microsoft's Excel and deliver impressive charts and analysis work. This Advanced Diploma in MS Excel course allows you to exploit the full abilities of Microsoft's best-selling tool and become capable of providing higher-quality results from it. You may use Excel every day in your work or business, but are you really using it to its full potential? With the advanced training from this course, you will quickly produce stunning spreadsheets and visually perfect graphs that will showcase business data to a much more professional degree. Use Excel to make your customer service excellent. How will I get my certificate? At the end of the course there will be a written assignment test which you can take either during or after the course. After successfully completing the test you will be able to order your certificate, these are included in the price. Who is this course for? There is no experience or previous qualifications required for enrolment on this Advanced Diploma in MS Excel. It is available to all students, of all academic backgrounds. Requirements Our Advanced Diploma in MS Excel is fully compatible with PC's, Mac's, Laptop, Tablet and Smartphone devices. This course has been designed to be fully compatible on tablets and smartphones so you can access your course on wifi, 3G or 4G. There is no time limit for completing this course, it can be studied in your own time at your own pace. Career path Having these various qualifications will increase the value in your CV and open you up to multiple sectors such as Business & Management , Admin, Accountancy & Finance, Secretarial & PA, Teaching & Mentoring etc. Course Curriculum 21 sections • 90 lectures • 22:14:00 total length •Introduction to Microsoft Excel 2019 New Features: 00:07:00 •CONCAT: 00:02:00 •IFS: 00:01:00 •MAXIFS: 00:01:00 •MINIFS: 00:01:00 •SWITCH: 00:02:00 •TEXTJOIN: 00:01:00 •Map Chart: 00:02:00 •Funnel Chart: 00:01:00 •Better Visuals: 00:06:00 •Pivot Table Enhancements: 00:02:00 •Power Pivot Updates: 00:01:00 •Navigate the Excel User Interface: 00:28:00 •Use Excel Commands: 00:10:00 •Create and Save a Basic Workbook: 00:19:00 •Enter Cell Data: 00:12:00 •Use Excel Help: 00:05:00 •Create Worksheet Formulas: 00:15:00 •Insert Functions: 00:17:00 •Reuse Formulas and Functions: 00:17:00 •Insert, Delete, and Adjust Cells, Columns, and Rows: 00:10:00 •Search for and Replace Data: 00:09:00 •Use Proofing and Research Tools: 00:07:00 •Apply Text Formats: 00:16:00 •Apply Number Format: 00:08:00 •Align Cell Contents: 00:09:00 •Apply Styles and Themes: 00:12:00 •Apply Basic Conditional Formatting: 00:11:00 •Create and Use Templates: 00:08:00 •Preview and Print a Workbook: 00:10:00 •Set Up the Page Layout: 00:09:00 •Configure Headers and Footers: 00:07:00 •Manage Worksheets: 00:05:00 •Manage Workbook and Worksheet Views: 00:07:00 •Manage Workbook Properties: 00:06:00 •Work with Ranges: 00:18:00 •Use Specialized Functions: 00:11:00 •Work with Logical Functions: 00:23:00 •Work with Date & Time Functions: 00:08:00 •Work with Text Functions: 00:11:00 •Sort Data: 00:10:00 •Filter Data: 00:10:00 •Query Data with Database Functions: 00:09:00 •Outline and Subtotal Data: 00:09:00 •Apply Intermediate Conditional Formatting: 00:07:00 •Apply Advanced Conditional Formatting: 00:05:00 •Create Charts: 00:13:00 •Modify and Format Charts: 00:12:00 •Use Advanced Chart Features: 00:12:00 •Create a PivotTable: 00:13:00 •Analyze PivotTable Data: 00:12:00 •Present Data with PivotCharts: 00:07:00 •Filter Data by Using Timelines and Slicers: 00:11:00 •Use Links and External References: 00:12:00 •Use 3-D References: 00:06:00 •Consolidate Data: 00:05:00 •Use Lookup Functions: 00:12:00 •Trace Cells: 00:09:00 •Watch and Evaluate Formulas: 00:08:00 •Collaborate on a Workbook: 00:19:00 •Protect Worksheets and Workbooks: 00:08:00 •Apply Data Validation: 00:13:00 •Search for Invalid Data and Formulas with Errors: 00:04:00 •Work with Macros: 00:18:00 •Create Sparklines: 00:07:00 •MapData: 00:07:00 •Determine Potential Outcomes Using Data Tables: 00:08:00 •Determine Potential Outcomes Using Scenarios: 00:09:00 •Use the Goal Seek Feature: 00:04:00 •Forecasting Data Trends: 00:05:00 •Create a Macro Using the Macro Recorder: 01:00:00 •Edit a Macro: 01:00:00 •Debug a Macro: 00:30:00 •Customize the Quick Access Toolbar and Hotkeys: 00:30:00 •Set Macro Security: 01:00:00 •Insert Text: 00:30:00 •Format Text: 00:30:00 •Sort Data: 00:30:00 •Duplicate Data: 01:00:00 •Generate a Report: 01:00:00 •Determine the Dialog Box Type: 00:15:00 •Capture User Input: 01:00:00 •Insert, Copy, and Delete Worksheets: 00:30:00 •Rename Worksheets: 00:30:00 •Modify the Order of Worksheets: 00:15:00 •Print Worksheets: 00:30:00 •Create User-Defined Functions: 00:30:00 •Automate SUM Functions: 00:30:00 •Resources - Microsoft Excel - Beginner Course - Cpd Accredited: 00:00:00 •Assignment - Advanced Diploma in MS Excel: 00:05:00

Overview This comprehensive course on AutoCAD Programming using C# with Windows Forms will deepen your understanding on this topic. After successful completion of this course you can acquire the required skills in this sector. This AutoCAD Programming using C# with Windows Forms comes with accredited certification, which will enhance your CV and make you worthy in the job market. So enrol in this course today to fast track your career ladder. How will I get my certificate? You may have to take a quiz or a written test online during or after the course. After successfully completing the course, you will be eligible for the certificate. Who is This course for? There is no experience or previous qualifications required for enrolment on this AutoCAD Programming using C# with Windows Forms. It is available to all students, of all academic backgrounds. Requirements Our AutoCAD Programming using C# with Windows Forms is fully compatible with PC's, Mac's, Laptop, Tablet and Smartphone devices. This course has been designed to be fully compatible with tablets and smartphones so you can access your course on Wi-Fi, 3G or 4G. There is no time limit for completing this course, it can be studied in your own time at your own pace. Career Path Having these various qualifications will increase the value in your CV and open you up to multiple sectors such as Business & Management, Admin, Accountancy & Finance, Secretarial & PA, Teaching & Mentoring etc. Course Curriculum 6 sections • 63 lectures • 09:11:00 total length •Introduction: 00:03:00 •Who is this course for?: 00:02:00 •Tools needed in this course: 00:01:00 •What will you learn from this course?: 00:05:00 •Controls Project Demo - Overview: 00:03:00 •Controls Demo Project Requirement - Explained: 00:03:00 •Create the Controls Demo Project: 00:03:00 •Controls Demo Project - Creating the Form (User Interface): 00:15:00 •Develop the Controls Demo Utility Class: 00:10:00 •Using Combobox Control to select an option: 00:13:00 •Using Textbox Control to select an option: 00:09:00 •Using Radiobutton Control to select an option: 00:06:00 •Using Checkbox Control to select an option(s): 00:18:00 •Developing Projects - Overview: 00:03:00 •Project 1: Creating a Rectangle - Project Overview: 00:03:00 •Project 1: Creating the Rectangle Utility Class: 00:17:00 •Project 1: Creating the User Interface: 00:10:00 •Project 1: Coding the User Interface28:50: 00:29:00 •Project 1: Running and Testing the Draw Rectangle Plugin: 00:08:00 •Project 2: Update Objects Layer - Overview: 00:02:00 •Project 2: Create the User Interface of Update Objects Layer Plugin: 00:09:00 •Project 2: Coding the Form Load Event: 00:07:00 •Project 2: Coding the Browse drawing Button: 00:03:00 •Project 2: Coding the Update Button control: 00:07:00 •Project 2: Coding the Update Layer Utility Class: 00:12:00 •Project 2: Running and Testing the Plugin: 00:08:00 •Project 3: Extracting Block Attributes to Files - Overview: 00:03:00 •Project 3: Creating the AutomaticBlockExtractor Project: 00:02:00 •Project 3: Creating the User Interface for the BlockExtractor Project: 00:09:00 •Project 3: Completing User Interface code: 00:22:00 •Project 3: Coding the AutoBlockExtractor Utility Class: 00:24:00 •Project 3: Running and Testing the AutomaticBlockExtractor Plugin in AutoCAD: 00:15:00 •Project 4: Updating MText Textstyle Project - Overview and Walkthrough: 00:05:00 •Project 4: Creating the UpdateTextStyle Utility Class: 00:19:00 •Project 4: Designing the UpdateTextStyle Plugin User Interface: 00:06:00 •Project 4: User Interface Code: 00:16:00 •Project 4: Running and Testing the UpdateTextstyle Plugin: 00:05:00 •Project 5: Converting Drawing to PDF Plugin - Overview: 00:03:00 •Project 5: Creating the PlotDWGtoPDF Project in Visual Studio 2019: 00:04:00 •Project 5: Creating the User Interface for MultiplePlotDWGtoPDF Project: 00:09:00 •Project 5: Coding the User Interface: 00:16:00 •Project 5: Developing the GetPlotSizes Method: 00:10:00 •Project 5: Developing the PlotCurrentLayout Method: 00:27:00 •Project 5: Testing and Running the MultiplePlotDWGtoPDF Project: 00:10:00 •Project 6: Multiple Object Extractor Project - Overview: 00:03:00 •Project 6: Creating the MultiObjectExtractor Project: 00:02:00 •Project 6: Designing the MultiObjectExtractor User Interface: 00:14:00 •Project 6: Coding the FormLoad Event: 00:07:00 •Project 6: Coding the BrowseDwg Button: 00:12:00 •Project 6: Coding the BrowseFile Button: 00:03:00 •Project 6: Coding the ProcessExtract Button: 00:05:00 •Project 6: Creating the Code Validation Methods: 00:10:00 •Project 6: Coding the ProcessDrawing Method: 00:19:00 •Project 6: Coding the ProcessObjectExtraction Method: 00:11:00 •Project 6: Coding the ExtractLine Method: 00:11:00 •Project 6: Coding the ExtractCircle Method: 00:04:00 •Project 6: Coding the ExtractPolyline Method: 00:11:00 •Project 6: Coding the ExtractMText Method: 00:05:00 •Project 6: Coding the ExtractBlock Method: 00:03:00 •Project 6: Coding the ExtractObjects Method: 00:02:00 •Project 6: Running and Testing the MultiObjectExtractor Plugin: 00:14:00 •Conclusion and Thank you: 00:01:00 •Assignment - AutoCAD Programming using C# with Windows Forms: 00:00:00

Overview This comprehensive course on AutoCAD Programming using VB.NET with Windows Forms will deepen your understanding on this topic. After successful completion of this course you can acquire the required skills in this sector. This AutoCAD Programming using VB.NET with Windows Forms comes with accredited certification from CPD, which will enhance your CV and make you worthy in the job market. So enrol in this course today to fast track your career ladder. How will I get my certificate? You may have to take a quiz or a written test online during or after the course. After successfully completing the course, you will be eligible for the certificate. Who is This course for? There is no experience or previous qualifications required for enrolment on this AutoCAD Programming using VB.NET with Windows Forms. It is available to all students, of all academic backgrounds. Requirements Our AutoCAD Programming using VB.NET with Windows Forms is fully compatible with PC's, Mac's, Laptop, Tablet and Smartphone devices. This course has been designed to be fully compatible with tablets and smartphones so you can access your course on Wi-Fi, 3G or 4G. There is no time limit for completing this course, it can be studied in your own time at your own pace. Career Path Having these various qualifications will increase the value in your CV and open you up to multiple sectors such as Business & Management, Admin, Accountancy & Finance, Secretarial & PA, Teaching & Mentoring etc. Course Curriculum 6 sections • 61 lectures • 09:51:00 total length •Module 01: Course Outline: 00:03:00 •Module 02: Introduction: 00:05:00 •Module 03: Who is this course for?: 00:04:00 •Module 04: Tools Needed for this Course: 00:01:00 •Module 01: What will you learn from this Course - Overview: 00:06:00 •Module 01: Windows Form and Controls - Overview: 00:04:00 •Module 02: ControlsDemo Project - Overview: 00:03:00 •Module 03: ControlsDemo Project - Creating the Project: 00:04:00 •Module 04: Controls Demo Project - Designing the Form: 00:19:00 •Module 05: ControlsDemo Project - Creating the Utility Class: 00:10:00 •Module 06: ControlsDemo Project - Coding the Combobox Control: 00:15:00 •Module 07: ControlsDemo Project - Coding the Textbox Control: 00:10:00 •Module 08: ControlsDemo Project - Coding the Radiobutton Control: 00:08:00 •Module 09: ControlsDemo Project - Coding the Checkbox Control: 00:17:00 •Module 01: Draw Rectangle Project - Overview: 00:03:00 •Module 02: Creating the DrawRectangle Project: 00:04:00 •Module 03: DrawRectangle Project - Creating the Utility Class: 00:20:00 •Module 04: DrawRectangle Project - Designing the Form: 00:15:00 •Module 05: DrawRectangle Project - Coding the User Interface Part 1: 00:24:00 •Module 06: DrawRectangle Project - Coding the User Interface Part 2: 00:18:00 •Module 07: DrawRectangle Project - Running the Program: 00:06:00 •Module 08: Automate Update Layer Project - Overview: 00:02:00 •Module 09: Creating the AutomateUpdateLayer Project: 00:03:00 •Module 10: Automate Update Layer Project - Creating the Utility Class: 00:17:00 •Module 11: AutomateUpdateLayer Project - Designing the User Interface: 00:07:00 •Module 12: AutomateUpdateLayer Project - Coding the Form: 00:18:00 •Module 13: AutomateUpdateLayer Project - Running the Program: 00:07:00 •Module 14: Automatic Block Extractor Project - Overview: 00:03:00 •Module 15: AutomaticBlockExtractor Project - Creating the Project: 00:03:00 •Module 16: AutomaticBlockExtractor Project - Creating the User Interface: 00:09:00 •Module 17: AutomaticBlockExtractor Project - Coding the Form: 00:27:00 •Module 18: AutomaticBlockExtractor Project - Creating the Utility Class: 00:27:00 •Module 19: AutomaticBlockExtractor Project - Running the Program: 00:10:00 •Module 20: AutomateUpdateTextStyles Project - Overview: 00:03:00 •Module 21: AutomateUpdateTextStyle Project - Creating the Project: 00:02:00 •Module 22: AutomateUpdateTextStyle Project - Creating the User Interface: 00:09:00 •Module 23: AutomateUpdateTextStyle Project - Coding the Form: 00:20:00 •Module 24: AutomateUpdateTextStyle Project - Coding the Utility Class: 00:16:00 •Module 25: AutomateUpdateTextStyle Project - Running the Program: 00:08:00 •Module 26: Multiple Plot DWG to PDF Project - Overview: 00:03:00 •Module 27: MultiplePlotDWGtoPDF Project - Creating the Project: 00:04:00 •Module 28: MultiplePlotDWGtoPDF Project - Creating the User Interface: 00:09:00 •Module 29: MultiplePlotDWGtoPDF Project - Coding the Form: 00:20:00 •Module 30: MultiplePlotDWGtoPDF Project - Creating the Utility Class: 00:30:00 •Module 31: MultiplePlotDWGtoPDF Project - Running the Program: 00:13:00 •Module 32: Multiple Object Extractor Project - Overview: 00:03:00 •Module 33: MultipleObjectExtractor Project - Creating the Project: 00:02:00 •Module 34: MultipleObjectExtractor Project - Creating the User Interface: 00:15:00 •Module 35: MultipleObjectExtractor Project - Coding the Form Load Event: 00:05:00 •Module 36: MultipleObjectExtractor Project - Coding the Browse Buttons: 00:10:00 •Module 37: MultipleObjectExtractor Project - Coding the Extract Button: 00:20:00 •Module 38: MultipleObjectExtractor Project - Coding the ProcessDrawing Method: 00:09:00 •Module 39: MultipleObjectExtractor Project - Coding the ProcessObjectExtraction Method: 00:11:00 •Module 40: MultipleObjectExtractor Project - Coding the ExtractLine Method: 00:09:00 •Module 41: MultipleObjectExtractor Project - Coding the ExtractCircle Method: 00:03:00 •Module 42: MultipleObjectExtractor Project - Coding the ExtractPolyline Method: 00:09:00 •Module 43: MultipleObjectExtractor Project - Coding the ExtractMText Method: 00:05:00 •Module 44: MultipleObjectExtractor Project - Coding the ExtractBlock Method: 00:05:00 •Module 45: MultipleObjectExtractor Project - Running the Program: 00:15:00 •Module 01: Conclusion: 00:01:00 •Assignment - AutoCAD Programming using VB.NET with Windows Forms: 00:00:00

Overview This comprehensive course on Solar Energy will deepen your understanding on this topic. After successful completion of this course you can acquire the required skills in this sector. This Solar Energy comes with accredited certification, which will enhance your CV and make you worthy in the job market. So enrol in this course today to fast track your career ladder. How will I get my certificate? After successfully completing the course you will be able to order your certificate, these are included in the price. Who is This course for? There is no experience or previous qualifications required for enrolment on this Solar Energy. It is available to all students, of all academic backgrounds. Requirements Our Solar Energy is fully compatible with PC's, Mac's, Laptop, Tablet and Smartphone devices. This course has been designed to be fully compatible with tablets and smartphones so you can access your course on Wi-Fi, 3G or 4G. There is no time limit for completing this course, it can be studied in your own time at your own pace. Career Path Having these various qualifications will increase the value in your CV and open you up to multiple sectors such as Business & Management, Admin, Accountancy & Finance, Secretarial & PA, Teaching & Mentoring etc. Course Curriculum 10 sections • 55 lectures • 11:44:00 total length •Module 1- Introduction To PV System Construction: 00:24:00 •Module 2- Solar Heating, Solar Irradiation And Panels: 00:38:00 •Module 3- Effect of Insolation and Temperature on V-I Curve: 00:05:00 •Module 4- PV Installation, Short Circuit And Open Circuit Tests Using Avometer: 00:15:00 •Module 5- Solar Wires And Cables Installation Process: 00:22:00 •Module 6- Mounting Of PV System: 00:04:00 •Module 7- Shading and Tilt angle In Solar Energy: 00:15:00 •Module 8- Half Cut Cell Technology In PV System For Solar Engineering: 00:25:00 •Module 9- Importance Of Charge Controller In Solar Energy System: 00:03:00 •Module 10- PWM And MPPT Charge Controllers: 00:14:00 •Module 11- Understanding More about MPPT Solar Charge Controller For Solar Energy Course: 00:24:00 •Module 12- Junction Box In Solar Energy System: 00:04:00 •Module 13- Wiring of Junction Box In Solar Energy System: 00:05:00 •Module 14- Function, Types And Data Sheet Of Inverter: 00:55:00 •Module 15- Determining PV Array Maximum System Voltage: 00:09:00 •Module 1- Construction And Types Of Batteries In Solar Energy System: 00:09:00 •Module 2- Charging Of Lead Acid Batteries And Hydrometer In Solar Energy System: 00:07:00 •Module 3- Maintenance Of Batteries And Methods Of Charging In Solar Energy System: 00:03:00 •Module 4- Cycle of Batteries: 00:04:00 •Module 1- Off-Grid Solar System: 00:02:00 •Module 2- Advantages of Off-Grid Solar System: 00:02:00 •Module 3- Equipment of Off-Grid Solar System: 00:04:00 •Module 4- Selection and Datasheet of the Panel: 00:04:00 •Module 5- Inverter Selection: 00:02:00 •Module 6- Example 1 On Designing Off Grid System: 00:01:00 •Module 7- Determine Power Consumption Demands: 00:04:00 •Module 8- Size the PV modules: 00:05:00 •Module 9- Inverter sizing: 00:04:00 •Module 10- Battery Sizing: 00:08:00 •Module 11- Solar Charge Controller Sizing: 00:05:00 •Module 12- MPPT Charge Controller Sizing: 00:10:00 •Module 13- Example 2 Design of an OFF Grid System: 00:20:00 •Module 1- Grid-Tied Solar System: 00:03:00 •Module 2- Advantages of Grid-Tied Solar System: 00:04:00 •Module 3- Equipment of Grid-Tied Solar System: 00:03:00 •Module 4- Example Design of an On Grid System: 00:10:00 •Module 5- PV Energy According to Area: 00:02:00 •Module 1- Design of an Off Grid Solar Energy System Using PVSYST Program: 00:28:00 •Module 2- Design Of An On Grid Solar Energy System Using PVSyst Program: 00:12:00 •Module 3- Mega PV System Design Using PVSyst Program For Solar Energy: 00:29:00 •Module 1- Introduction To Water Pumping System And Steps Of Design: 00:24:00 •Module 2- Solved Example On Solar Pumping System Design: 00:23:00 •Module 1- Introduction to Protection Of PV System: 00:07:00 •Module 2- Selection of Fuses and Protection of String: 00:13:00 •Module 3- Protection of Arrays: 00:07:00 •Module 4- Protection of Inverter: 00:07:00 •Module 5- Protection of Transformer: 00:07:00 •Module 6- Surge Protection Device: 00:02:00 •Module 7- Grounding of PV System: 00:07:00 •Module 8- Types of BusBars in PV System and Selection of BusBars: 00:12:00 •Module 1-Design Of Off Grid PV System Using Excel Sheet: 00:26:00 •Module 1- Single Line Diagram Of PV System And Selection Of Fuses And Breakers: 00:45:00 •Module 1- Simulation Of PV Cell In MATLAB And Obtaining V-I Characteristics: 00:28:00 •Module 2- Get a Complete Grid Connected PV Solar Energy System In MATLAB Simulink: 00:25:00 •Module 3- PV System Simulation Using ETAP Lesson: 00:24:00

Watch a film, don't read a powerpoint! If you work with display screen equipment, such as computers, laptops, tablets, or smartphones, then obtaining a Display Screen Equipment training certificate is highly recommended. This certification is essential for anyone who wants to ensure their own well-being and promote a safe working environment.

The often-used phrase, 'just the receptionist', completely misrepresents the role. An excellent receptionist is a most valuable resource for any organisation. This programme has been designed specifically to deal with the essential skills necessary to represent the organisation to the best possible effect. It will also help you get the most out of your working day. There are six key reasons to take part in this workshop. It will help you: See your role in a new light Develop your communication skills Deal with different types of customer and situation Boost your confidence Cope in a pressurised environment Get more satisfaction from your working day 1 Introduction Workshop objectives and personal objectives The challenges of 21st century communication What makes an excellent point of Reception? And why is it so important? Who and where are our customers? As a customer, how do you like to be treated? What makes people feel valued? Objective and subjective aspects of customer service 'Micro moments' that shape the relationship 2 Communication on reception Definition of communication Barriers to good communication The 'recipe' of verbal, vocal and visual aspects of communication Differences between communicating face-to-face and on the telephone Communication 'leaks' The primitive human response The impact of visual communication - body language, gesture and facial expression Voice - tone, speed, volume, pitch, clarity, inflection, pacing Words - positive words and phrases compared with negative terminology Professional greetings face-to-face Steering the conversation with effective questioning 3 Telephone excellence How we use the telephone Qualities of the telephone Non-verbal communication on the telephone - what aspects can be 'seen' by the other person? Professional telephone etiquette Taking and leaving messages - key points that can help customers, colleagues and the organisation Clarifying information 4 Listening skills for accuracy and relationship building How accurate are your listening skills? What are the challenges for accurate listening? Active / empathetic listening 5 Creating a rapport by 'style flexing' Understanding how different people communicate Shaping our message to the other person so that they feel understood How changing situations can alter communication needs 6 Confidence and assertiveness Recognising different styles of behaviour - aggressive, passive and assertive Qualities of assertive communication - verbal, vocal and visual Assertive techniques - basic, persistence, negotiation / empathetic Demonstrating confidence 7 Coping in a pressurised environment Words - the most useful ones to use with stressed people and identifying the 'red rag' words Challenging situations - what do you find difficult and how do you respond? Dealing with outbursts of anger Bringing non-stop talkers back from their tangent Constructive ways to say 'no' 8 Pulling it all together Action plans Summary of key learning points